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

Chetwynd Road
Dartmouth Park,NW5 1DA
Guide Price £799,950

A spacious split level apartment arranged over the upper floors of this Victorian conversion situated in the heart of the...

King Henrys Road
Primrose Hill,NW3 3QX
Guide Price £1,150,000

An exceptional newly refurbished apartment in a sought after road between Primrose Hill Village and Swiss Cottage. The flat is...

Lissenden Gardens
Dartmouth Park,NW5 1LZ
Guide Price £950,000

A substantial (1142 sq ft) three bedroom apartment set on the ground floor of this desirable purpose built block in...

Langdon Park Road
Highgate,N6 5PT
Guide Price £1,695,000

A well presented, high-ceilinged Victorian family house retaining a wealth of character features including ornate fireplaces, intricate ceiling cornicing, exposed...