SELECT * FROM rentals WHERE rental_id='118' and visible=1 ORDER BY price ASC
This lovely and beautiful home is located east of Cuenca, has all wood throughout the floor and ceiling, 2 fireplaces, handcrafted stone and wrought iron The house has three bedrooms (possibly 4) with full a bathroom each, Jacuzzi in the master bedroom and a beautiful BQ area in the back patio. This house is half of a block away from the Tomebamba River and fifteen minutes walking time to the large shopping mall. Size: 1795 sf land and 2461 sf built space.
BEAUTIFUL RUSTIC-ELEGANT HOUSE WITH TERRACE. ON THE RIVER
Luxury apartment bay view