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-saleprice'
AND
(
( mt1.meta_key = 'property-salestype' AND mt1.meta_value LIKE '{24ac2c663b31fb5b92d2db4af819cfa724950a82a4243c18a47d442a8ab1fc2e}for-sale{24ac2c663b31fb5b92d2db4af819cfa724950a82a4243c18a47d442a8ab1fc2e}' )
)
) 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
337 properties
for sale
View properties as: List | Grid | Map
4 Bedroom House
Popes Hill, Newnham, Gloucestershire, GL14 1LD
£1,500,000 Freehold
A beautifully presented four bedroom detached property in a rural location with approximately 10 acres of grounds, having superb views over open countryside and the River Severn..
4 Bedrooms 
2 Bathrooms 
3 Receptions
View Property Details
Contact Us
SSTC
5 Bedroom House
Merthyr Road, Llanfoist, Abergavenny, NP7 9LR
£875,000
**Video Tour Available** An individual and extensive five bedroom detached residence with neo-Georgian facade and contemporary interior..
5 Bedrooms
4 Bathrooms
3 Receptions
View Property Details
Contact Us
4 Bedroom House
Lea, Ross-on-Wye, Herefordshire, HR9 7LQ
£647,000 Freehold
Aldene Homes offer the first phase of four gated detached four bedroom houses all with double garages. Situated in a sought after village location, completion is due August/September 2021. Photographs are artists' impression,....
4 Bedrooms
0 Bathrooms
0 Receptions
View Property Details
Contact Us
4 Bedroom House
Lea, Ross-on-Wye, Herefordshire, HR9 7LQ
£645,000 Freehold
Aldene Homes offer the first phase of four gated detached four bedroom houses all with double garages. Situated in a sought after village location, completion is due August/September 2021. Photographs are artists' impression,....
4 Bedrooms
0 Bathrooms
0 Receptions
View Property Details
Contact Us
4 Bedroom House
The Talybont, The Cedars, Llangattock, NP8 1LD
£609,950 Freehold
***RESERVATIONS TAKEN FROM FRIDAY 12TH MARCH AT THE CRICKHOWELL BRANCH** Brand New four bedroom detached property (Talybont Design) in highly sought after location with superb views. Benefiting open plan living accommodation, ....
4 Bedrooms
2 Bathrooms
1 Receptions
View Property Details
Contact Us
SSTC
4 Bedroom House
The Talybont, The Cedars, Llangattock, NP8 1LD
£609,950 Freehold
***RESERVATIONS TAKEN FROM FRIDAY 12TH MARCH AT THE CRICKHOWELL BRANCH*** Brand New four bedroom detached property (Talybont Design) in highly sought after location with superb views. Benefiting open plan living accommodation,....
4 Bedrooms
2 Bathrooms
1 Receptions
View Property Details
Contact Us
SSTC
5 Bedroom House
29, Abergavenny, Monmouthshire, NP7 5RP
£600,000 Freehold
*Video Tour Available* Beautifully presented five bedroom detached property having four reception rooms, utility room, two en-suites and extensive gardens with two detached outbuildings. Photograph shows rear..
5 Bedrooms
4 Bathrooms
4 Receptions
View Property Details
Contact Us
SSTC
£600,000
Freehold
Rose Villa, 29, Oxford Street, Abergavenny,Monmouthshire, , NP7 5RP
View Property Details
SSTC
5 Bedroom Cottage
Llangenny, Crickhowell, Powys, NP8 1HD
£599,950 Freehold
**Virtual Tour Available** A beautifully presented five bedroom detached cottage having gardens and grounds of approximately 1.34 acres. Benefiting versatile accommodation to include two reception rooms, dining room, conservat....
5 Bedrooms
2 Bathrooms
3 Receptions
View Property Details
Contact Us
SSTC
4 Bedroom House
The Talybont, The Cedars, Llangottack, NP8 1LD
£595,000 Freehold
***RESERVATIONS TAKEN FROM FRIDAY 12TH MARCH AT THE CRICKHOWELL BRANCH***Brand New four bedroom detached property (Talybont Design) in highly sought after location with superb views. Benefiting open plan living accommodation, ....
4 Bedrooms
2 Bathrooms
1 Receptions
View Property Details
Contact Us
SSTC
4 Bedroom Bungalow
Lea, Ross-on-Wye, Herefordshire, HR9 7LQ
£577,500 Freehold
Individual four bedroom detached single storey family home with generous gardens, garage/games room and countryside views..
4 Bedrooms
3 Bathrooms
1 Receptions
View Property Details
Contact Us
