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
STUNNING SPACIOUS (c. 3,500 sq ft) NEW HOME in a fine rural spot, with lovely countryside views, just a mile from the centre of Ottery town. FABULOUS 39' OPEN PLAN KITCHEN / DINING / LIVING ROOM openi... Read more
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
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 ... 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
An OUTSTANDING NEW detached 5 BEDROOM family home located in EASY REACH of TOPSHAM town centre with EXCELLENT COMMUNICATION LINKS to Exeter. Offering SPACIOUS accommodation, BEAUTIFUL LANDSCAPED GARD... Read more
FIVE BEDROOM bright and spacious 3 storey DOUBLE FRONTED home IN A CUL DE SAC setting. Many HIGH SPECIFICATION upgrades including UNDERFLOOR HEATING, fully integrated kitchen & Luxury FLOORING PACKAGE... 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.