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

Price
To
Property Type
No. Of Bedrooms
 
Advanced Search

Shepherds Hill
Highgate,N6 5AH
Asking Price £1,500,000

A truly exceptional four bedroom top floor duplex apartment converted in 2011 from this well presented detached house. This high...

Brecknock Road
Tufnell Park,N19 5AB
Asking Price £875,000

On the upper reaches of Kentish Town and bordering Tufnell Park, an extremely spacious three storey upper maisonette approaching 1200...

Harman Drive
Hocroft Estate,NW2 2EB
Guide Price £2,250,000

An unmodernised semi-detached family house situated within a wide corner plot on the south side of this quiet cul-de-sac within...

Haverstock Hill
Belsize Park,NW3 4RR
Asking Price £599,950

A newly refurbished apartment arranged over the fourth (top) floor of an attractive art deco style purpose built block in...