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
1 properties
for sale
View properties as: List | Grid | Map
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