SQL: SELECT * FROM `properties` LEFT JOIN `pp_geocode` ON `properties`.`p_property_ref` = `pp_geocode`.`ppge_propertyref` WHERE 1 = 1 AND `p_propertyclass` = ? AND ( `p_restricted` = 0 OR `p_restricted` = 2 ) AND ( (`p_status` LIKE 'Sold' AND `p_sellingprice` > 3000000) OR (`p_generic6` LIKE 'Sold B&R' AND `p_sellingprice` > 3000000) OR (`p_status` NOT LIKE 'Sold') )

Search For A Property

Property Type
No. Of Bedrooms
Advanced Search

York Rise
Dartmouth Park,NW5 1SB
Asking Price £1,850,000

This highly impressive end of terrace 3 storey Victorian family home has been superbly modernised in a contemporary style throughout....

Hodford Road
Golders Green,NW11 8NL
Asking Price £1,375,000

On the market for the first time in 65 years, an attractive semi-detached family house well positioned within this highly...

Eton College Road
Chalk Farm,NW3 2DQ
Guide Price £450,000

An excellent first floor apartment located in a popular purpose built mansion block in a sought after position moments from...

Rosslyn Hill
Hampstead,NW3 5UJ
Guide Price £4,950,000

A magnificent eight bedroom Victorian family house retaining much of the original character featuring grand entertaining and receptions areas, secure...