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 ) WHERE 1=1 AND (
wp_postmeta.meta_key = 'price'
AND
(
( mt1.meta_key = 'price' AND CAST(mt1.meta_value AS SIGNED) BETWEEN '0' AND '9999999999999' )
AND
( mt2.meta_key = 'property-bedrooms' AND CAST(mt2.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 10, 10
55 properties
to let
View properties as: List | Grid | Map
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
2 Bedroom First Floor Apartment
Weston Road, Bromley, BR1 3RH
£315,000 Asking Price Of
Within walking distance to Bromley Town Centre is this extremely spacious very well presented two bedroom apartment with two great benefits of a share of the freehold and garage en-bloc. Located on a residential road the proper....
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
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
2 Bedroom First Floor Conversion
199, Bromley, BR1 2RG
£290,000 Guide Price
Guide Price £290,000 to £300,000
(Video Available) 123 Estate Agents are pleased to offer this well presented first floor Victorian conversion apartment offered with a share of freehold, allocated and visitor parking, well main....
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
2 Bedroom First Floor Maisonette
King Henrys Drive, New Addington, Croydon, CR0 0AG
£285,000 Asking Price Of
123estateAgent are pleased to offer for sale this well presented first floor two double bedroom maisonette. Located close to transport links. schools and local amenities. This property offers a great first time buy, investment ....
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
4 Bedroom Semi Detached House
Princes Plain, Bromley, BR2 8LF
£2,250
(AVAILABLE NOW) We are proud to offer for let this beautifully four bedroom semi detached house on Bromley Common. The accommodation provides a master bedroom with modern separate shower room WC, three further bedrooms and a mo....
4 Bedrooms
2 Bathrooms
1 Receptions
View Property Details
Contact Us
1 Bedroom Apartment
Dollar Bay Place, London, E14 9AD
£1,990
(Video Viewings Available) Boasting breathtaking views across the O2 from a private Winter Garden, this 1 bedroom 20th floor (waterfront apartment features 24hr Concierge, communal Garden, residents' Gymnasium and Residents lou....
1 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
1 Bedroom Apartment
Dollar Bay Place, London, E14 9AD
£1,990
(Video Viewings Available) Boasting breathtaking views across the O2 from a private Winter Garden, this 1 bedroom 20th floor (waterfront apartment features 24hr Concierge, communal Garden, residents' Gymnasium and Residents lou....
1 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
3 Bedroom Detached House
Sidcup Road, London, SE9 3AL
£1,900
Available Now! 3D virtual viewing available on request.
Recently redecorated three bedroom detached house, offering convenient access to all local amenities, including popular local schools and transport links. Benefits to not....
3 Bedrooms
1 Bathrooms
2 Receptions
View Property Details
Contact Us
2 Bedroom Apartment
340, London, E1W 3ET
£1,850
(Video Available) A fantastic 2 bedroom flat situated in one of the most prestigious developments overlooking the river Thames and wonderful gardens. It has been completely refurbished with porcelain and glass walls to the two ....
2 Bedrooms
2 Bathrooms
1 Receptions
View Property Details
Contact Us
