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;... Read more
Stunning HIGH-SPECIFICATION detached new home on the edge of this popular coastal resort. With a SWEEPING view from TEIGNMOUTH in the South West across the BAY to EXMOUTH and the coast beyond to the E... Read more
Stunning HIGH-SPECIFICATION new home with BEAUTIFUL SEA VIEWS on the edge of this popular coastal resort. Boasting fabulous OPEN PLAN KITCHEN/DINING with LARGE principal room opening onto a BALCONY. ... 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
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
A luxurious high-quality 5 bedroom DETACHED home in Topsham. An ENERGY EFFICIENT home with Spacious Living spaces and a huge MASTER BEDROOM SUITE WITH BATHROOM AND DRESSING ROOM, layout lends itself t... Read more
Striking HIGH-SPECIFICATION new home with STUNNING SEA VIEWS on the edge of this popular coastal resort. Boasting fabulous OPEN PLAN LIVING SPACE with HUGE double aspect principal room and adjoining S... Read more
SMALL SELECT NEW DEVELOPMENT of just five quality local craftsmen-built detached homes. Handy for Newcourt train station and M5 Motorway network. High specification, SPACIOUS WELL-DESIGNED accommodati... 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 email@example.com We are working hard to rectify this problem and apologise for any inconvenience.