SELECT *,CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) Price, CASE WHEN minp.meta_value = 'POA' THEN '1' WHEN minp.meta_value != 'POA' THEN '2' END as `mainsort` FROM wp_posts p inner join wp_postmeta minp on minp.post_id = p.Id and CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) >= CONVERT('',UNSIGNED INTEGER) and minp.meta_key = 'cp_price' inner join wp_term_relationships tr on tr.object_id = p.Id and tr.term_taxonomy_id =9 WHERE ID not in (62293) and post_status='publish' and post_type='post' and (post_title LIKE '%%' or post_content like '%%') ORDER BY `mainsort` , CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) desc
C. 4.25 ACRE (1.7 Hectares) of on the edge of Newton Abbot . Two separate plots 2.99 acre and 1.27 acre with OUTLINE PLANNING APPROVAL. 22 houses with VIEWS to Seale-Hayne and 9 Detached Houses with VIEWS towards Teignmouth. AVAILABLE AS A WHOLE OR I...
Consented site for SEVEN LUXURY APARTMENTS with lift, balconies and private parking for 10 cars. Comprising 6 X C.80 SQ M 2 BEDROOMS and C.110 SQ M PENTHOUSE APARTMENT with roof terrace and incredible views. (contd...)...
A truly exceptional home of over 3000 sq ft, located in the heart of the village, finished to a very high standard throughout with a number of fantastic features, double garage and South-facing garden. Please contact Wilkinson Grant for more informat...
Rare redevelopment opportunity. STUNNING 3.25 acre site with FAR REACHING Sea, Estuary and Coastal VIEWS in a select residential address in this popular seaside town....
A RARE OPPORTUNITY to acquire a level town centre redevelopment site WITHIN CLOSE PROXIMITY TO SHOPS, SEAFRONT and overlooking an ATTRACTIVE PUBLIC PARK. Planning application submitted for 35 Apartments and Ground Floor Commercial space....
A Well-maintained and well-managed residential investment portfolio COMPRISING TEN HOUSES (May consider splitting), all in good city addresses. Total of 44 bedrooms producing Gross rental income of c.295,000 PA. Acquisition fee will apply. ...
C.2.29 ACRE (0.93 Hectares) with an EXPIRED OUTLINE PLANNING PERMISSION (07/1197/15/O) for 17 units in the South Hams. POSSIBLE REDESIGN for c.10 detached houses
6 houses / 24 BED / Licence for 30 RESIDENTIAL INVESTMENT BLOCK WITH PARKING and potential future development. A high quality investment opportunity producing RENTAL INCOME of over £167,000 pa. CLOSE TO THE HEAVITREE SHOPS and the main city hospit...
1.27 acre with OUTLINE PLANNING APPROVAL for 9 detached houses. Located on a raised field with VIEWS TOWARDS TEIGNMOUTH and the SURROUNDING COUNTRYSIDE....
VIDEO TOUR AVAILABLE - A superb development site with stunning sea views and private access to the beach below. Planning Permission granted for 3 x 250m2 detached houses. We have taken the decision that the development will be better as a site for 2 ...
By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. You can change your cookie settings at any time but parts of our site will not function correctly without them. Read more about cookies and learn how to disable them.
When you visit a website, it may store or collect information on your browser, usually using small files called cookies. Cookies enables us to recognise and remember you. The information might be about your online behaviour or preferences, the type of device you are using, or may even be used to ensure the website can work properly. The information used by Wilkinsongrant can give you a more personalised experience on our site. You can use the 'Manage settings' feature to switch on or off certain types of cookies, although some cookies are necessary for the website to work correctly.
Click on the different category headings to find out more or change your settings.
Find out more information about our advertising technology partners here and find out more about here.
Strictly Necessary Cookies
Always active
These cookies are necessary for the website to function. Examples of this include: setting your privacy preferences, filling in forms. Though these cookies cannot be switched off, you can set your browser to block or alert you about these cookies, but please be aware that this will stop some parts of the website from functioning as intended.
These cookies allow us to understand how people use our website and where they came from, so that we can measure and improve the performance of our website, as well as to remember your preferences. They help us see which pages are the most and least popular, and how visitors move around the website.
If you do not allow these cookies we will not know when you have visited our website and will not be able to monitor its performance.
These cookies record your visit to the website, the individual pages you visit, the links you follow and the type of device you use. We will use this information to make the website and the adverts we show you more relevant to your interests. Our use of these cookies might also mean that you may see Wilkinsongrant adverts when you visit Facebook.
These cookies record your activity on the website and our partners may use that information to show you adverts that they think you will be most interested in when you visit other websites. Our partners may also use information recorded by these cookies to see how well their adverts are performing.
If you do not allow these cookies, you may see more content and adverts that do not match your interests.