SELECT * FROM rentals WHERE rental_id='150' and visible=1 ORDER BY price ASC
This amazing apartment located just 6 blocks north from the central Parque Calderon is available for rent at an incredible price of $450 ALL INCLUSIVE!!
This place is a 1 level walk up while still being very private and calm.
For this price you get central gas and hot water, and all basic services as well... You'll also find a dryer and washer and a nice well-equipped kitchen, brand new items and all you can think of. Out of the window you get a nice view of a beautifully decorated courtyard.
Being so close to the central park opens a lot of options for tourism if you're just in town for a little while, but also has its benefits for a long-term stay. This place is a great deal.
The complex where this unit sits is a brand-new building that shows charm and colonial architecture all throughout, giving peacefulness and a tranquil ambiance in every way.
GREAT CENTRAL PLACE, FURNISHED FOR RENT! AT AN AMAZING PRICE.
Luxury apartment bay view