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_excerpt like '%open house%' and (post_title LIKE '%%' or post_content like '%%') ORDER BY `mainsort` , CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) desc
OPEN HOUSE - BEAUTIFULLY REFURBISHED AND CLEVERLY EXTENDED Edwardian detached house with SPECTACULAR SEA AND COASTAL VIEWS in a small select development in one of Exmouth's best addresses. Boasting a ... Read more
OPEN HOUSE - 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 L... Read more
OPEN HOUSE - 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 with MARBLE... Read more
OPEN HOUSE - 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 l... Read more
OPEN HOUSE - A superbly presented detached family home with a good sized South-westerly facing rear garden. Far reaching views to the Haldon Hills. Conveniently located in Pennsylvania and close to Ex... Read more
OPEN HOUSE - PRICE RANGE: £475,000 - £500,000A SUPERBLY PROPORTIONED and well-presented DETACHED family home OVER 2000 SQ FT, just 6 miles to the East of Exeter. Good access to the A30 and M5 motor... Read more
OPEN HOUSE - OPEN HOUSE - A SUPERBLY PRESENTED end of terrace house with a GREAT LOFT CONVERSION providing a DOUBLR ROOM and SHOWER ROOM. In the sought after Heavitree area, CLOSE TO the RD&E hospital... Read more
OPEN HOUSE - A delightful, EXTENDED three bedroom Edwardian house with 3 RECEPTION ROOMS, MODERN KITCHEN and SOUTH WEST FACING GARDENS with OFF ROAD PARKING situated on the outskirts of this popular E... Read more
OPEN HOUSE - A BEAUTIFULLY PRESENTED and STYLISH Grade II Listed GROUND FLOOR CITY CENTRE APARTMENT near the historic Iron Bridge and within walking distance of the CITY CENTRE and QUAYSIDE, offering ... Read more
OPEN HOUSE - This THREE bedroom house is situated close to St David's Station and the CITY CENTRE. The accommodation offers a LARGE KITCHEN/DINING ROOM with access on to the private COURTYARD garden.... 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.