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. 20212 |
For sale at $1,500,000 USD or rent at $800 USD a day. Price is negotiable. Financing is available.
Amazing ocean view! For sale by owner. No commission! Spectacular mansion on the pacific coast, San Juan Del Sur, Nicaragua. Located in the middle of the bay, one block from the beach. 7 bedrooms, 7 bathrooms, large swimming pool with swim-up bar.Generously proportioned with 5000 square feet construction on a 13000 square...