Sugar

Request a Valuation

Howards and all agreed referral partners can contact me with relevant information, offers and news.
By clicking Send you confirm that you agree to our website terms of use, our privacy policy and consent to cookies being stored on your computer.

Request a Callback

Howards and agreed referral partners can contact me with relevant information.

Survey Callback Request

Howards and agreed referral partners can contact me with relevant information.

Get Howards properties straight to your inbox

Howards and agreed referral partners can contact me with relevant information.

Hello, we'd love to hear what you thought of us...

Firstly, how likely would you be to recommend our company on a scale of 0 - 10? tick

0
1
2
3
4
5
6
7
8
9
10

Finally, if you have specific feedback, please select a category below... tick

Suggestion
Problem
Praise
Other

Please enter your feedback in the box below and then press 'Submit Feedback'.

SELECT *,CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) Price 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('350000',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 inner join wp_postmeta dept on dept.post_id = p.Id and (dept.meta_key = 'cp_department' and dept.meta_value ='RS') WHERE post_status='publish' and post_type='post' and (post_title LIKE '%%' or post_content like '%%') ORDER BY CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) desc

Homes Of Distinction currently available

Showing 01-10

Showing 01-10