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
This is a UNIQUE AND RARE OPPORTUNITY to acquire a LARGE, HIGH-END, LUXURY & IMPOSING home within walking distance of the centre of Topsham. Whilst this home may be large it is also EFFICIENT, with ex... 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
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
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
Stunning development in the quaint town of Topsham.FOUR BEDROOM bright and spacious DOUBLE FRONTED family home WITH LOVELY OPEN VIEWS to the front. Private landscaped garden to the rear and OVERSIZED... 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.