Sugar
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

Newton Abbot | Devon

POA

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...

Sold STC

St Leonards | Exeter

POA

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...)...

Lympstone | Exmouth

POA 5

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...

Exmouth | Devon

POA

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....

Exmouth | Devon

POA

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....

Exeter | Devon

POA

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.
...

Brixton | Devon

POA

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

...

Exeter | Devon

POA 4

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...

Newton Abbot | Devon

POA

1.27 acre with OUTLINE PLANNING APPROVAL for 9 detached houses. Located on a raised field with VIEWS TOWARDS TEIGNMOUTH and the SURROUNDING COUNTRYSIDE....

Sold STC

Dawlish | Devon

POA

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 ...