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

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

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

POA 3

A STUNNING CITY CENTRE DUPLEX APARTMENT enjoying a fantastic location. STYLISH and SPACIOUS ACCOMMODATION with THREE BEDROOMS (TWO ENSUITE), fantastic OPEN-PLAN LIVING SPACE, HIGH QUALITY KITCHEN and PARKING SPACE. Sold with NO ONWARD CHAIN....

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

Topsham

POA 3

Impressive, beautifully presented modern house, in a favoured address about 800 yards from the centre of town with nearby riverside walks. 21’X18’ living/dining room with bi-fold doors, south westerly landscaped garden. Fabulous designer kitchen....