SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND p.approved = 1 AND pm.cat_id IN (36,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND `p`.`featured` IN ('1') AND p.approved = 1 AND pm.cat_id IN (36,39,40,41,162,163)
GROUP BY p.id
ORDER BY RAND()
SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND p.approved = 1 AND pm.cat_id IN (36,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 3901 - 3902 of 3902 €799,000
TSEA143253
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 115 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: La Duquesa Region: Andalucía
Magnificent penthouse with spectacular sea views, located in an urbanization area at a short distance from Sotogrande harbour and close the beach. In impecable condiction, the apartment offers (...)
€600,000
TSEA3119527
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 86 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Malaga Region: Andalucía
2017-V MALAGA (Center) opportunity only in a building emblematic of the center of Malaga facing it Street Larios in a building historical of the century 18 protected i completely reformed in 2006 is (...)
Current Featured Properties
€400,000
TSEA4805725
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 56 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 56 Area: Estepona Region: Andalucía
This new development in the Estepona Centre comprising 43 one, two and three bedroom apartments and penthouses, terraces and magnificent communal areas. It boasts excellent finishes, a prime location (...)
€924,000
TSEA5106775
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 115 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 115 Area: Estepona Region: Andalucía
Discover, an incredible new development in one of Estepona's most exclusive areas. This private residential complex features apartments, including flats, penthouses, and ground-floor units with 2, 3, (...)
€395,000
TSEA5116924
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 108 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: San Pedro Region: Andalucía
The origin of a new way of living in Marbella
The first residential project in a new district set to transform the lifestyle in Marbella.
More than just a new development, this development is the (...)
