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
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 BRIGHT AND SPACIOUS high quality detached barn conversion set in OVER HALF AN ACRE in an UNSPOILT RURAL location, with SPECTACULAR COUNTRYSIDE VIEWS. Just 30 minutes west of Exeter on the edg... 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
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
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
Small select development of just five detached houses. Built to a high specification by a local building company, tucked away in a location on the outskirts of Exeter with good access to Newcourt trai... Read more
An OUTSTANDING NEW detached 4 BEDROOM family home located in EASY REACH of both EXETER and TOPSHAM with EXCELLENT COMMUNICATION LINKS. Offering SPACIOUS accommodation to HIGH SPECIFICATION, fully enc... Read more
When you visit a website, it may store or collect information on your browser, usually using small files called cookies. Cookies enables us to recognise and remember you. The information might be about your online behaviour or preferences, the type of device you are using, or may even be used to ensure the website can work properly. The information used by Wilkinsongrant can give you a more personalised experience on our site. You can use the 'Manage settings' feature to switch on or off certain types of cookies, although some cookies are necessary for the website to work correctly.
Click on the different category headings to find out more or change your settings.
Find out more information about our advertising technology partners here and find out more about here.
Strictly Necessary Cookies
These cookies are necessary for the website to function. Examples of this include: setting your privacy preferences, filling in forms. Though these cookies cannot be switched off, you can set your browser to block or alert you about these cookies, but please be aware that this will stop some parts of the website from functioning as intended.
These cookies allow us to understand how people use our website and where they came from, so that we can measure and improve the performance of our website, as well as to remember your preferences. They help us see which pages are the most and least popular, and how visitors move around the website.
If you do not allow these cookies we will not know when you have visited our website and will not be able to monitor its performance.
These cookies record your visit to the website, the individual pages you visit, the links you follow and the type of device you use. We will use this information to make the website and the adverts we show you more relevant to your interests. Our use of these cookies might also mean that you may see Wilkinsongrant adverts when you visit Facebook.
These cookies record your activity on the website and our partners may use that information to show you adverts that they think you will be most interested in when you visit other websites. Our partners may also use information recorded by these cookies to see how well their adverts are performing.
If you do not allow these cookies, you may see more content and adverts that do not match your interests.
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.