Featured Real Estate Listings
mysql error: [1030: Got error 28 from storage engine] in EXECUTE("SELECT listing.id, file.path, listing_type.name_singular as type, listing.location_id,listing_status_id,listing_payment_state_id, city, city_id,rent_price_from,sell_price_from,listing_type_id,multi,category.name as category FROM listing
JOIN listing_category ON (listing_category.listing_id = listing.id)
JOIN category ON category.id=listing_category.category_id
JOIN listing_type ON listing_type.id = listing.listing_type_id
JOIN file ON listing.file_group_id = file.file_group_id AND file.main = true
ORDER BY last_visit_ts DESC LIMIT 25")
Listing No. 33482 |
For sale at $259,900 USD.
Beautiful house for sale in one of the most scenic areas in Costa Rica. Recently built villa in the majestic Turrialba Valley mountains,"gateway to the Caribbean" Perfect altitude for the perfect weather, The 3.0 acre property is part of a country gated community of eight large lots 7 lots are sold and 4 houses are built,a fifth will start next week.