TO LET: A TWO BEDROOM MID TERRACED HOUSE located with easy access to Llanelli Train Station and Trostre Retail Park. The Accommodation within comprises of Lounge, Kitchen, Two bedrooms and a Family Bathroom. Externally the property has a rear garden. NO smokers, NO pets - EPC: D Bond - £595 - Council tax band : B
SELECT * FROM `properties` WHERE `category_id` = '2' AND `bedrooms` = '2'
AND `price` >= '0' AND `price` <= '9999999'
AND (`full_address` LIKE '%%')
ORDER BY `price` ASC