SELECT * FROM rentals WHERE rental_id='208' and visible=1 ORDER BY price ASC
This residential condominium with 3 bedrooms and 2 bathrooms is located in Cuenca, Azuay Ecuador, in the canton of Cuenca.
The riverfront property enjoys beautiful city, mountain and garden views, and is located in the highlands of Ecuador.
The land area of this house is 2,100.00 square meter (22,604.12 square feet), and it has a living space of 190.00 square meter (2,045.13 square feet).
This condo comes mostly furnished (includes stove, oven, microwave, living room set, 2 bed & matthress)
$ 950 all inclusive
APARTMENT FOR RENT IN FRONT OF THE RIVER
Luxury apartment bay view