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 (41,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 (41,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 (41,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 241 - 260 of 3899
€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, (...)
€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 (...)
€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 (...)
€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 (...)
€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 (...)
€345,000
TSEA5147416
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Charming two bedroom, two bathroom first floor apartment in quiet residential area close to golf, restaurants, shops and schools.
This south facing apartment is in fantastic condition and has (...)
€345,000
TSEA5147392
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Middle Floor Apartment, Selwo, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 132 m², Terrace 20 m².
Setting : Urbanisation.
Orientation : South West.
Condition : Excellent.
Pool : (...)
€775,000
TSEA5147380
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 127 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: San Pedro Region: Andalucía
Brand-new apartment in MARE Urbanización, San Pedro Alcántara
Discover this modern 3-bedroom, 2-bathroom apartment with 103 m² of interior space and a 30 m² sunny terrace, perfect for enjoying (...)
€660,000
TSEA5147296
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
In the prestigious Phase I of the Residential Complex "Ipanema, by Kronos Homes", located in the municipality of Mijas, lies this exclusive penthouse, which combines modern design, (...)
€295,000
TSEA5147170
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 77 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: La Duquesa Region: Andalucía
For sale, South East facing middle floor apartment in an established gated community within Los Hidalgos area of La Duquesa, Manilva Costa del Sol, located just 5 minutes from the beach.
This (...)
€480,000
TSEA5147146
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 102 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Marbella East Region: Andalucía
Master en-suite with full bathroom, dressing room, and direct access to the terrace through double-glazed sliding doors.
Second double bedroom with built-in wardrobe, access to the terrace, and (...)
€375,000
TSEA5147125
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 66 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 66 Area: Marbella Region: Andalucía
BEACHSIDE GROUND FLOOR APARTMENT – REFORM OPPORTUNITY IN MARBELLA DEL MAR
Fantastic opportunity in the sought-after Marbella del Mar complex, set directly on the beachfront and only 10 minutes' (...)
Current Featured Properties
€404,400
TSEA5018557
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 97 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Area: Benalmadena Region: Andalucía
This brand new development is located on Calle Menta in Benalmadena (Málaga). It is the new residential in Benalmadena, Málaga. The private urbanization has 70 homes of 2 and 3 bedrooms, in (...)
€382,000
TSEA4753921
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
New homes in Mijas!
This development is a modern residential of 75 new homes in Mijas, designed to enjoy a warm and balanced lifestyle. A project surrounded by nature, with incredible sea and (...)
€995,000
TSEA4777597
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
LIGHT FLOODS INTO THE PROPERTY!!!
We will change weight for square meters, color for avant-garde architectural design, clarity for light and size for the best qualities and certified construction (...)
