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 20, 10
55 properties
to let
View properties as: List | Grid | Map
3 Bedroom End Terraced House
Lower Gravel Road, Bromley, BR2 8LJ
£1,850
LONG LET. A fantastic three bedroom house arranged two floors, presented to a high specification throughout and boasting a large modern kitchen diner, first floor bathroom and a private Garden.
Situated in bromley common close....
3 Bedrooms
1 Bathrooms
1 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
3 Bedroom Terraced House
Salisbury Road, Bromley, Kent, BR2 9PU
£1,800
VIRTUAL VIEWING AVAILABLE 123estateAgent are very pleased to offer on a long let this extended three bedroom Victorian terrace house situated just moments from local shops and bus routes. The property boasts a kitchen diner and....
3 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
3 Bedroom Terraced House
Salisbury Road, Bromley, Kent, BR2 9PU
£1,800
VIRTUAL VIEWING AVAILABLE 123estateAgent are very pleased to offer on a long let this extended three bedroom Victorian terrace house situated just moments from local shops and bus routes. The property boasts a kitchen diner and....
3 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
1 Bedroom Apartment
Harbour Way, London, E14 9DX
£1,725
(Video Available) We are pleased to offer for rent this brand new modern apartment. Offering a large reception with kitchen, double bedroom with fitted wardrobes, modern bathroom and separate washing room.
The apartment further....
1 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
1 Bedroom Apartment
Harbour Way, London, E14 9DX
£1,725
(Video Available) We are pleased to offer for rent this brand new modern apartment. Offering a large reception with kitchen, double bedroom with fitted wardrobes, modern bathroom and separate washing room.
The apartment further....
1 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
3 Bedroom Semi Detached House
Bolderwood Way, West Wickham, BR4 9PH
£1,650
123 estateAgent are pleased to offer to let this three bedroom chalet style house to rent in West Wickham. The property is within walking distance to the main high street shops.
Located within the Langley Catchment area, situ....
3 Bedrooms
1 Bathrooms
2 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 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 Apartment
Gainsborough Court, Bromley, BR2 9NB
£1,450
123estateAgent are pleased to offer this very spacious, fully furnished two bedroom apartment located in an ideal location offering easy access to Bromley south rail station and high street. The property has recently modernised....
2 Bedrooms
2 Bathrooms
1 Receptions
View Property Details
Contact Us