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 '{373b13de5b5bfd37de3aa7227a73be48dd0feb62c9c92f33cd12b29077501cdd}for-rent{373b13de5b5bfd37de3aa7227a73be48dd0feb62c9c92f33cd12b29077501cdd}' )
)
) 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
12 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
3 Bedroom Cottage
Poolway Road, Poolway Road, Broadwell, GL16 7BE
£1,350 pcm (£312 pw) Long Let
Bidmead Cook are delighted to bring to the market, this beautiful 3 bedroom cottage situated in Broadwell, on the outskirts of Coleford. The property is extremely spacious and beautifully presented throughout. The property comp....
3 Bedrooms
2 Bathrooms
2 Receptions
View Property Details
Contact Us
LET
3 Bedroom House
Merthyr Road, Govilon, Abergavenny, NP7 9PT
£1,100 pcm (£254 pw) Long Let
Bidmead Cook are pleased to offer to rent a well-presented detached 3 bedroom property in the heart of Govilon..
3 Bedrooms
2 Bathrooms
3 Receptions
View Property Details
Contact Us
£1,100 pcm (£254 pw)
Long Let
Riverdale, Merthyr Road, Govilon,Abergavenny, , NP7 9PT
View Property Details
LET
3 Bedroom House
Bridge Street, Crickhowell, NP8 1AR
£900 pcm (£208 pw)
Bidmead cook are delighted to bring to the market this newly refurbished three bedroom detached property located within walking distance of Crickhowell town centre. The property is set is a very desirable area of the town with ....
3 Bedrooms
1 Bathrooms
2 Receptions
View Property Details
Contact Us
LET
3 Bedroom House
Bridge Street, Crickhowell, NP8 1AR
£900 pcm (£208 pw)
Bidmead cook are delighted to bring to the market this newly refurbished three bedroom detached property located within walking distance of Crickhowell town centre. The property is set is a very desirable area of the town with ....
3 Bedrooms
1 Bathrooms
2 Receptions
View Property Details
Contact Us
2 Bedroom House
Boating Lake Lane, Lydney, Gloucestershire, GL15 5GA
£725 pcm (£167 pw)
Smartly presented two bedroom, mid-terraced property situated in Lydney. Benefiting from kitchen with built-in appliances, double glazing, gardens and off road parking. Viewing recommended..
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
2 Bedroom House
Blaen Y Ddol, Bridgend, Pen-y-bont ar Ogwr, CF31 5AD
£695 pcm (£160 pw) Long Let
A well-presented two bedroom mid-terraced house in a cul-de- sac position in the popular location of Broadlands. Ideally located within a short distance to the local Primary school and amenities and a short drive to Bridgend t....
2 Bedrooms
0 Bathrooms
1 Receptions
View Property Details
Contact Us
£695 pcm (£160 pw)
Long Let
23, Blaen Y Ddol, Bridgend,Pen-y-bont ar Ogwr, , CF31 5AD
View Property Details
LET
2 Bedroom Cottage
Castle Road, Crickhowell, Powys, NP8 1AP
£695 pcm (£160 pw) Long Let
Bidmead Cook are delighted to offer on the rental market an ideally located 2 bedroom Cottage situated near Crickhowell town centre.
.
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
LET
2 Bedroom House
Windsor Street, Troedyrhiw, Merthyr Tydfil, CF48 4HE
£490 pcm (£113 pw) Long Let
Bidmead Cook offer this two bedroom property in the village of Troedyrhiw. Close to main A470 and the bus and train links.
The property comprises of entrance hallway through into good size living room , kithcen and downstairs....
2 Bedrooms
1 Bathrooms
1 Receptions
View Property Details
Contact Us
£490 pcm (£113 pw)
Long Let
5, Windsor Street, Troedyrhiw,Merthyr Tydfil, , CF48 4HE
View Property Details
0 Bedroom
Bethcar Street, Bethcar Street, NP23 6BB
£450 pcm (£104 pw)
Opportunity to rent a retail unit in what is believed to be the area designated as the "retail core" area of Ebbw Vale town centre, under the current UDP. .
The property has been used as an hairdreser and has one room to the....
0 Bedrooms
0 Bathrooms
0 Receptions
View Property Details
Contact Us