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_postmeta tp on tp.post_id = p.Id and tp.meta_value = 'new_home' and tp.meta_key = 'cp_new_home' 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
STYLISH CITY LIVING at its finest. Currently under construction by a QUALITY LOCAL BUILDER. The property offers a rare opportunity to have a house finished TO THE BUYER'S SPECIFICATION. Due to be COMP... Read more
TOTALLY UNIQUE detached residence of IMMENSE CHARACTER in a select village-edge new development of just seven luxury homes. Fine southerly aspect PRIVATE COURTYARD aspect with STUNNING FAR REACHING ... Read more
A Luxurious 4 BEDROOM well finished home with spectacular SEA VIEWS situated on the Teignmouth edge of HOLCOMBE. This ENERGY EFFICIENT property benefits from UNDERFLOOR heating, Quality INTEGRATED KIT... Read more
The Haddeo, a luxurious high-quality 4 bedroom DETACHED home in Topsham, one of the region's most DESIRABLE LOCATIONS. Benefitting from an OPEN PLAN kitchen / dining room with BI-FOLDING DOORS leading... Read more
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.
We are currently experiencing technical problems with our phone system which may cause issues with incoming calls. If you experience any problems ringing us, please email firstname.lastname@example.org We are working hard to rectify this problem and apologise for any inconvenience.