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

Raveley Street
Kentish Town,NW5 2HX
Asking Price £1,200,000

A very substantial light and sunny upper maisonette arranged over the upper three floors of this extended Victorian residence set...

Mercers Road
Tufnell Park,N19 4PU
Asking Price £1,650,000

A very well presented mid terrace 3 storey Victorian house on the south side of this popular residential turning in...

Burghley Road
Kentish Town,NW5 1UG
Offers in excess of £2,500,000

A grandly proportioned (2670 sq ft) semi-detached Victorian family home offering elegant accommodation over four spacious floors including an impressive...

Lawn Road
Belsize Park,NW3 2XS
Asking Price £1,350,000

An exceptionally bright and generously proportioned apartment occupying the entire first floor of a large double fronted Victorian house in...