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 30, 10
55 properties
to let
View properties as: List | Grid | Map
2 Bedroom Conversion Apartment
Glebe Knoll, Bromley, BR2 0DA
£1,450
123estateAgents are pleased to offer a two bedroom ground floor apartment set within an exclusive gated community and within walking distance to Bromley town centre and Shortlands/Bromley North British Rail. The property benefi....
2 Bedrooms 
2 Bathrooms 
1 Receptions
View Property Details
Contact Us
2 Bedroom Ground Floor Apartment
5, Bromley, BR2 0DA
£1,450
We are pleased to offer for let this ground floor two bedroom gated apartment. The property consists of a lounge dining area with double doors leading to a patio area and communal garden, modern kitchen with integrated washing ....
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
2 Bedroom Terraced House
Pope Road, Bromley, BR2 9QA
£1,400
123 estateAgent are pleased to offer this well presented two bedroom terraced house offered part furnished, close to Chatterton Village local shops and restaurants. The property benefits from two receptions, modern kitchen whic....
2 Bedrooms
1 Bathrooms
2 Receptions
View Property Details
Contact Us
2 Bedroom Terraced House
Pope Road, Bromley, BR2 9QA
£1,400
123 estateAgent are pleased to offer this well presented two bedroom terraced house offered part furnished, close to Chatterton Village local shops and restaurants. The property benefits from two receptions, modern kitchen whic....
2 Bedrooms
1 Bathrooms
2 Receptions
View Property Details
Contact Us
2 Bedroom
Canon Road, Bromley, BR1 2SJ
£1,350
(Video Available)123 Estate Agent are pleased to offer to rent a two/three bedroom Victorian semi detached house, located in the popular area of Bromley. The property has one/two reception rooms, Modern fitted kitchen, two bedr....
2 Bedrooms
1 Bathrooms
2 Receptions
View Property Details
Contact Us
2 Bedroom Ground Floor Apartment
5, Bromley, BR2 0DA
£1,350
(Virtual Viewing Available) 123stateAgents are pleased to offer for let this ground floor two bedroom gated apartment. The property consists of a lounge dining area with double doors leading to a patio area and communal garden,....
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
3 Bedroom Terraced House
Petersham Drive, Orpington, BR5 2QG
£1,350
(Video Available) We are pleased to present this three bedroom terraced house situated in a residential cul-de-sac location within easy reach of a number of local schools and transport links. The property features to the ground....
3 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
2 Bedroom Terraced House
Herbert Road, Bromley, BR2 9SH
£1,350
123 estateAgent are pleased to offer this well presented two bedroom terraced house, close to Chatterton Village local shops and restaurants. The property benefits from a through lounge, kitchen which leads to a large well main....
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
3 Bedroom Terraced House
Petersham Drive, Orpington, BR5 2QG
£1,350
(Video Available) We are pleased to present this three bedroom terraced house situated in a residential cul-de-sac location within easy reach of a number of local schools and transport links. The property features to the ground....
3 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
2 Bedroom Terraced House
Herbert Road, Bromley, BR2 9SH
£1,350
123 estateAgent are pleased to offer this well presented two bedroom terraced house, close to Chatterton Village local shops and restaurants. The property benefits from a through lounge, kitchen which leads to a large well main....
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
