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-rentprice'
AND
(
( mt1.meta_key = 'property-propertyownabletype' AND mt1.meta_value = 'Lettings' )
AND
( mt2.meta_key = 'property-rentprice' 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
23 properties
to let
View properties as: List | Grid | Map
LET
4 Bedroom Semi Detached House
Princes Plain, Bromley, BR2 8LF
£2,250 PCM
(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
LET AGREED
1 Bedroom Apartment
Dollar Bay Place, London, E14 9AD
£1,990 PCM
(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
LET AGREED
3 Bedroom Detached House
Sidcup Road, London, SE9 3AL
£1,900 PCM
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
LET AGREED
2 Bedroom Apartment
340, London, E1W 3ET
£1,850 PCM
(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
LET AGREED
3 Bedroom Terraced House
Salisbury Road, Bromley, Kent, BR2 9PU
£1,800 PCM
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
LET AGREED
1 Bedroom Apartment
Harbour Way, London, E14 9DX
£1,725 PCM
(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
LET AGREED
3 Bedroom Semi Detached House
Bolderwood Way, West Wickham, BR4 9PH
£1,650 PCM
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
LET AGREED
2 Bedroom Conversion Apartment
Glebe Knoll, Bromley, BR2 0DA
£1,450 PCM
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
LET AGREED
2 Bedroom Apartment
Gainsborough Court, Bromley, BR2 9NB
£1,450 PCM
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
LET AGREED
2 Bedroom Ground Floor Apartment
5, Bromley, BR2 0DA
£1,450 PCM
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