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 ) WHERE 1=1 AND (
wp_postmeta.meta_key = 'property-rentprice'
AND
(
( mt1.meta_key = 'property-salestype' AND mt1.meta_value LIKE '{95bef5d5c305efe874aff6d6b8694e3fdf0139cea7dca2d473f7db0d47de81fe}for-rent{95bef5d5c305efe874aff6d6b8694e3fdf0139cea7dca2d473f7db0d47de81fe}' )
)
) 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
7 properties
to let
View properties as: List | Grid | Map
LET
4 Bedroom House
Kingswood Road, Monmouth, Sir Fynwy, NP25 5BX
£1,500 pcm (£346 pw) Long Let
Beautifully presented modern detached home, extended and upgraded offering family living in style, with landscaped gardens. Internally, the well-presented accommodation comprises; Lounge, superb open plan Kitchen/Dining room me....
4 Bedrooms
3 Bathrooms
2 Receptions
View Property Details
Contact Us
LET
0 Bedroom Flat/Apartment
Colchester Close, Westbury-on-Severn, Gloucestershire, GL14 1PU
£600 pcm (£138 pw) Long Let
Spacious 2 bedroom flat situated in Westbury on Severn..
0 Bedrooms
0 Bathrooms
0 Receptions
View Property Details
Contact Us
£600 pcm (£138 pw)
Long Let
8, Colchester Close, Westbury-on-Severn,Gloucestershire, , GL14 1PU
View Property Details
LET
2 Bedroom Cottage
Windsor Street, Troedyrhiw, Merthyr Tydfil, CF48 4HE
£550 pcm (£127 pw)
Bidmead Cook + Williams are pleased to offer this newly renovated cottage in the village of Troedyrhiw.
Property consists of entrance in to kitchen and through to utility area and a downstairs bathroom. Living room with patio ....
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
£550 pcm (£127 pw)
Pontyrhun Cottage, Windsor Street, Troedyrhiw,Merthyr Tydfil, , CF48 4HE
View Property Details
LET
1 Bedroom Flat/Apartment
73, Merthyr Tydfil, CF47 8UN
£525 pcm (£121 pw) Long Let
Bidmead Cook + Williams are pleased to offer this newly renovated flat at the top of Merthyr Town centre. Bidmead Cook + Williams are pleased to offer this newly renovated flat at the top of Merthyr Town centre.
Flat comprise....
1 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
LET
3 Bedroom House
Canning Street, Cwm, Ebbw Vale, NP23 7RN
£525 pcm (£121 pw)
Bidmead Cook Frythomas are pleased to offer for rent this Three Bedroom property. The property comprises: Lounge/diningroom, fitted kitchen, utility, gas central heating, double glazing.
COUNCIL TAX A.
3 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
LET
2 Bedroom Maisonette
22, Aberfan, Merthyr Tydfil, CF48 4QN
£525 pcm (£121 pw) Long Let
Bidmead Cook offer this two bedroom maisonette in the village of Aberfan.
Property comprises of open plan kitchen living room area to the ground floor and bathroom and two bedrooms to first floor.
Shared access via side of pr....
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
£525 pcm (£121 pw)
Long Let
Flat 3, 22, Aberfan Road, Aberfan,Merthyr Tydfil, , CF48 4QN
View Property Details
0 Bedroom
Unit 31H Pant Industrial Estate, Pant, Merthyr Tydfil, CF48 2SR
£500 pcm (£115 pw) Long Let
Bidmead Cook offer this First Floor Office above a Repair Centre in Pant Industrial Estate.
Facilities include parking, toilets, canteen, separate entrance and roller shutters.
(There is an option available to rent the entire....
0 Bedrooms
0 Bathrooms
0 Receptions
View Property Details
Contact Us
£500 pcm (£115 pw)
Long Let
Office 1, Unit 31H Pant Industrial Estate, Pant,Merthyr Tydfil, , CF48 2SR
View Property Details