SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )  INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )  INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) WHERE 1=1  AND ( 
  wp_postmeta.meta_key = 'property-saleprice' 
  AND 
  ( 
    ( mt1.meta_key = 'property-propertyownabletype' AND mt1.meta_value = 'Sales' ) 
    AND 
    ( mt2.meta_key = 'property-saleprice' AND CAST(mt2.meta_value AS SIGNED) BETWEEN '0' AND '9999999999999' ) 
    AND 
    ( mt3.meta_key = 'property-bedrooms' AND CAST(mt3.meta_value AS SIGNED) BETWEEN '0' AND '9999999999999' )
  )
) AND wp_posts.post_type = 'property' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 0, 10

Refine Search

Sales Lettings

Request a Valuation

1 properties for sale

View properties as: List | Grid | Map

Sort By

SOLD

3 Bedroom Ground & First Floor Apartment

Magpie Hall Lane, Bromley, BR2 8JE

£315,000 Asking Price Of

(Video Available) 123 Estate agent are pleased to offer this ground and first floor spacious three bedroom apartment which is well positioned for local amenities, popular schools and bus links into Bromley town centre. The prop....

3 Bedrooms 1 Bathrooms 1 Receptions

View Property Details Contact Us