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 (42,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 (42,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 (42,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 301 - 320 of 5896
€250,000
TSEA5147944
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Well-Presented 1-Bedroom Apartment in Los Boliches, Fuengirola
This charming ground-floor apartment offers a fantastic opportunity to enjoy the vibrant lifestyle of Los Boliches, with all amenities (...)
€725,000
TSEA5147932
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 138 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 138 Area: Marbella Region: Andalucía
FIRST LINE BEACH APARTMENT!
Magnificent duplex penthouse for sale in one of the best areas of San Pedro de Alcantara (Marbella). Nueva Alcantara, on the beachfront and of course with wonderful sea (...)
€550,000
TSEA5147926
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
3-Bedroom Penthouse in Prime Beachside Location
This spacious three-bedroom penthouse is located in Costalita in Estepona East. Upon entering, you are welcomed by a modern kitchen that flows into (...)
€495,000
TSEA5147920
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Live the Mediterranean Dream: Your Beachside Oasis in Calahonda Awaits
Discover the pinnacle of coastal living in this impeccable, ground-floor two-bedroom apartment, situated in a secure beachfront (...)
€540,000
TSEA5147887
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 130 Lot Size: 50 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 50 Area: Marbella West Region: Andalucía
Ground Floor Apartment, Nueva Andalucía, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 26 m², Garden/Plot 50 m².
Setting : Close To Schools, Urbanisation.
Orientation : East, (...)
€649,000
TSEA5147875
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 93 Lot Size: 250 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Lot Size: 250 Area: Fuengirola Region: Andalucía
Discover your new home in Torreblanca! This impressive detached house is an excellent investment opportunity, as it has a tourist license and is ready to move into. Located in the upper part of (...)
€425,000
TSEA5147836
- Hacienda del Sol, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
A beautifully located first-floor apartment in the highly sought-after Hacienda del Sol development. The apartment features a spacious master bedroom with an en-suite bathroom, a second bedroom, and (...)
€2,250,000
TSEA5147815
- Valtocado, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 6 M2: 556 Lot Size: 1,800 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 6 M2: 556 Lot Size: 1,800 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Detached Villa in Valtocado – Panoramic Sea & Mountain Views
This magnificent villa, set within the prestigious urbanisation of Valtocado, offers the perfect balance of elegance, space, (...)
€649,000
TSEA5147812
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 103 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: Benahavis Region: Andalucía
** Experience one of Marbella's most breathtaking panoramic Sea Views from this fully renovated apartment **
This spacious 103m² apartment has been completely renovated with high-quality finishes. (...)
€630,000
TSEA5147809
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 93 Lot Size: 139 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Lot Size: 139 Area: Fuengirola Region: Andalucía
Experience Contemporary Luxury in El Higuerón, Fuengirola
Discover this exclusive ground-floor apartment with a spacious private garden, designed in a modern and minimalist style in one of the most (...)
€415,000
TSEA5147797
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Fantastic 85m2 apartment with terrace. Spacious and bright, fully furnished and equipped with 2 bedrooms, 2 bathrooms, one en suite, on the beachfront in one of the most sought-after areas of the (...)
€199,000
TSEA5147791
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 26 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 26 Area: Benalmadena Region: Andalucía
Renovated Studio with Sea Views on the Top Floor – Puerto Marina, Benalmádena
Located on the seventh and top floor of a well-maintained building, this bright, renovated studio offers stunning (...)
€480,000
TSEA5147764
- Los Flamingos, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Imagine living in a spectacular penthouse in a very private and quiet complex, just at the entrance of Los Flamingos! This wonderful penthouse features 2 bedrooms and 2 bathrooms, a fully equipped (...)
€495,000
TSEA5147761
- Los Flamingos, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 110 Area: Estepona Region: Andalucía
Stunning Penthouse in an Exclusive and Peaceful Complex at the Entrance of Los Flamingos
This fantastic 3-bedroom, 3-bathroom penthouse offers the perfect blend of privacy, space, and breathtaking (...)
€585,000
TSEA5147521
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 110 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Marbella East Region: Andalucía
Spacious and bright ground floor apartment situated in a beachfront complex in Elviria.
The complex has a direct access to the beach, 2 open swimming pools (one is heated), beautiful well maintained (...)
€1,400,000
TSEA5147518
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 220 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 220 Area: Estepona Region: Andalucía
Modern Luxury Villa with Panoramic Golf & Sea Views in Estepona
This newly built modern villa in Valle Romano Golf, Estepona, boasts breathtaking panoramic views over both the golf course and (...)
€489,000
TSEA5147506
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 115 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Benahavis Region: Andalucía
Exclusive Apartment with Panoramic Views in Villa Padierna
Discover a rare opportunity to own a stunning apartment in the prestigious Villa Padierna community, Benahavís. With sweeping views over (...)
€495,000
TSEA5147467
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 81 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 81 Area: Fuengirola Region: Andalucía
???? Apartment for Sale – Paseo Marítimo, Fuengirola
Stunning fourth-floor apartment located on the beachfront, facing south with direct sea views.
The property features 2 bedrooms with built-in (...)
€2,250,000
TSEA5147461
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M2: 441 Lot Size: 1,384 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 4 M2: 441 Lot Size: 1,384 Area: Marbella West Region: Andalucía
Well located villa boarding the golf course in the low-density residential area of Nueva Andalucía, in the heart of the Golf Valley, about 10 minutes from both Marbella and Estepona and around 45 (...)
€5,390,000
TSEA5147437
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 588 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 588 Area: Marbella East Region: Andalucía
This exceptional duplex penthouse is located within Epic Marbella on the Golden Mile, one of the most prestigious addresses in Marbella. Designed to impress, the property spans 586 m², including 351 (...)
Current Featured Properties
€1,485,000
TSEA5115535
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 136 Lot Size: 195 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 136 Lot Size: 195 Area: Estepona Region: Andalucía
NEW DEVELOPMENT – Elegance and Exclusivity on the Costa del Sol!
Discover this new luxury project, a prestigious complex of 14 independent villas located in an exceptional setting in Estepona, (...)
€890,000
TSEA4939027
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
This is the opportunity of living in Spain, in the best equipped residential complex in Marbella, located in a privileged spot near the golf club and with premium quality specifi cations. You will (...)
€695,000
TSEA4940635
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Perfectly combines living in natural surroundings with the comfort of being only a short distance from the center of Estepona. As well as a coastline that stretches for 20km, the town has great (...)
