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

Exeter | Devon

Guide Price £1,400,000

SUBSTANTIAL DETACHED HOUSE with LUCRATIVE “HOME & INCOME”/RESIDENTIAL/DEVELOPMENT POTENTIAL* Set in c. ½ ACRE PLOT close to city centre, Exeter College, main University Campus and both Exeter mainline train stations. c. (contd...)...

Topsham | Exeter

Guide Price £1,200,000 5

Splendid detached Grade II Listed period house, in a quiet road off Topsham's renowned Strand, offering spacious, adaptable accommodation, set amidst beautifully landscaped MATURE GARDENS, excellent PARKING and a GARAGE. No onward chain....

Sold STC

Exmouth | Devon

Guide Price £1,175,000 4

IMPRESSIVE NEW DETACHED HOUSE with FABULOUS SEA AND COASTAL VIEWS just yards from the beach. Boasting GREAT LIVING SPACE including 41’ OPEN PLAN KITCHEN/DINING ROOM; separate sitting room and study; 4 LARGE DOUBLE BEDROOMS; 3 LUXURIOUS BATHROOMS. (...

Sold STC

Exmouth | Devon

Guide Price £1,100,000 4

Detached house of c.3000 sq ft set in a SEMI RURAL and PEACEFUL POSITION in the SOUGHT AFTER address of Marley Drive. c. 2.8 acres of extensive gardens, SCOPE TO FURTHER DEVELOP & EXTEND, south west facing terrace, woodland, GATED DRIVEWAY and TRIPL...

Exmouth | Devon

Guide Price £1,100,000 4

ARCHITECTURALLY DESIGNED MODERN HOME with BEAUTIFUL VIEWS across the Maer Valley. Situated in the desirable 'AVENUES', c. 1 mile to EXMOUTH BEACH and in a tucked away position, LUXURIOUS ACCOMMODATION, LANDSCAPED GARDENS & SUN TERRACE, DRIVEWAY plus ...

Exmouth

From £1,000,000 4

GUIDE PRICE £1,000,000 - £1,100,000 OUTSTANDING PENTHOUSE APARTMENT located within the desirable area of the THE AVENUES and less than half a mile to EXMOUTH BEACH. (contd...)...

Sold STC

Topsham | Devon

Guide Price £1,000,000 4

SPACIOUS EXTENSIVELY IMPROVED detached family-size home with RIVER VALLEY VIEWS. BEAUTIFULLY-PRESENTED throughout with fabulous BESPOKE KITCHEN with AGA, 22’ triple aspect living room, home office, LARGE GARDEN and FANTASTIC LARGE DOUBLE GARAGE/WOR...

Sold STC

Exmouth | Devon

Guide Price £1,000,000 5

A BEAUTIFUL, SUBSTANTIAL FAMILY HOME with VIEWS OVER NATIONAL TRUST FIELDS and ESTUARY. Located in this DESIRABLE ADDRESS, c. HALF ACRE PLOT with FABULOUS OPEN PLAN LIVING SPACE inc. snug, picture window, bi-folding doors decked terrace, DOUBLE GARAG...

Sold STC

Nr Crediton | Devon

Offers in Excess of £995,000 6

A STUNNING, BRIGHT AND SPACIOUS high quality detached barn conversion set in OVER HALF AN ACRE in an UNSPOILT RURAL location, with SPECTACULAR COUNTRYSIDE VIEWS. Just 30 minutes west of Exeter on the edge of Dartmoor National Park. (contd...)...

Exeter | Devon

£990,000 11

Attractive 11 bed HMO will 11 En-suites CLOSE TO THE UNIVERSITY, fully let with a NET INCOME OF c.£82,000. Set in an attractive tree lined square between the city centre, St Davids railway station and the University of Exeter.

...