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. 34686 |
For sale at €2,050,000 EUR. Price is negotiable. Financing is available.
Gorgeous building in Grand Barcelona -> touristic apartments Gorgeous building to reconvert into touristic apartments Building in Barcelona area, without tenants, inhabited –at present– by the owners, designed in 1930 by a renowned architect, Mr. Antoni Puig i Gairalt He moved from Noucentisme, to the Art Deco, and the Rationalism styles.