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_title LIKE '%%' or post_content like '%%') ORDER BY `mainsort` , CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) desc
SUBSTANTIAL DETACHED HOUSE with LUCRATIVE “HOME & INCOME”/RESIDENTIAL/DEVELOPMENT POTENTIAL* Set in c. ½ ACRE PLOT close to city centre, Exeter College, main University Campus and both Exeter mainline train stations. c. (contd...)...
Splendid detached Grade II Listed period house, in a quiet road off Topsham's renowned Strand, offering spacious, adaptable accommodation, set amidst beautifully landscaped MATURE GARDENS, excellent PARKING and a GARAGE. No onward chain....
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 LARGE DOUBLE BEDROOMS; 3 LUXURIOUS BATHROOMS. (...
Detached house of c.3000 sq ft set in a SEMI RURAL and PEACEFUL POSITION in the SOUGHT AFTER address of Marley Drive. c. 2.8 acres of extensive gardens, SCOPE TO FURTHER DEVELOP & EXTEND, south west facing terrace, woodland, GATED DRIVEWAY and TRIPL...
ARCHITECTURALLY DESIGNED MODERN HOME with BEAUTIFUL VIEWS across the Maer Valley. Situated in the desirable 'AVENUES', c. 1 mile to EXMOUTH BEACH and in a tucked away position, LUXURIOUS ACCOMMODATION, LANDSCAPED GARDENS & SUN TERRACE, DRIVEWAY plus ...
GUIDE PRICE £1,000,000 - £1,100,000 OUTSTANDING PENTHOUSE APARTMENT located within the desirable area of the THE AVENUES and less than half a mile to EXMOUTH BEACH. (contd...)...
SPACIOUS EXTENSIVELY IMPROVED detached family-size home with RIVER VALLEY VIEWS. BEAUTIFULLY-PRESENTED throughout with fabulous BESPOKE KITCHEN with AGA, 22’ triple aspect living room, home office, LARGE GARDEN and FANTASTIC LARGE DOUBLE GARAGE/WOR...
A BEAUTIFUL, SUBSTANTIAL FAMILY HOME with VIEWS OVER NATIONAL TRUST FIELDS and ESTUARY. Located in this DESIRABLE ADDRESS, c. HALF ACRE PLOT with FABULOUS OPEN PLAN LIVING SPACE inc. snug, picture window, bi-folding doors decked terrace, DOUBLE GARAG...
A 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 edge of Dartmoor National Park. (contd...)...
Attractive 11 bed HMO will 11 En-suites CLOSE TO THE UNIVERSITY, fully let with a NET INCOME OF c.£82,000. Set in an attractive tree lined square between the city centre, St Davids railway station and the University of Exeter.
By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. 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.
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
Always active
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.