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' 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
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 WEALTH OF ORI... Read more
C. 4.25 ACRE (1.7 Hectares) of on the edge of Newton Abbot . Two separate plots 2.99 acre and 1.27 acre with outline planning approval. 22 houses with views to Seale-Hayne and 9 Detached Houses with v... Read more
One of the best redevelopment opportunities on the South Devon coast. A STUNNING 3.25 acre site with far reaching Sea, Estuary and Coastal views. Gently sloping with the current buildings four storeys... Read more
A rare opportunity to acquire a level town centre redevelopment site within close proximity to shops, seafront and overlooking an attractive public park.Planning application submitted for 35 Apartment... Read more
A Well-maintained and well-managed residential investment portfolio COMPRISING A TERRACE OF THREE HOUSES. Total of 15 bedrooms producing Gross rental income of c.100,000 PA. Acquisition fee will apply... Read more
A Well-maintained and well-managed residential investment portfolio COMPRISING TEN HOUSES (May consider splitting), all in good city addresses. Total of 44 bedrooms producing Gross rental income of c.... Read more
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
A Well-maintained and well-managed residential investment portfolio COMPRISING SIX HOUSES, all in good city addresses. Total of 24 bedrooms producing Gross rental income of c.£160,000 PA. ... 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.