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 (39)
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 (39)
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 (39)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 721 - 740 of 1067
€570,000
TSEA4884904
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 150 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 570,000 € to 1,799,000 €. [Beds: 2 - 3] [Baths: 2 - 3] [Built size: 150.00 m2 - 364.00 m2]
This development is situated in a prime location nestled between the (...)
€810,000
TSEA4980541
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Luxury Apartment on the Beach with direct Gate Access.
The apartment is located in a modern, bright, quiet, family friendly community. No Noisy neighbours – a villa one side and a protected nature (...)
€600,000
TSEA4979887
- Río Real, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 187 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 187 Area: Marbella East Region: Andalucía
Discover this beautiful apartment located in one of the most emblematic areas of Marbella, in the prestigious urbanization of Rio Real. A home that combines spaciousness, comfort and the essence of (...)
€275,000
TSEA4979293
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Lot Size: 38 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Lot Size: 38 Area: Estepona Region: Andalucía
In this small gated community of only 18 apartments we have this beautiful, frontline golf, 2 bed 2 bath ground floor, south west facing apartment in Estepona Golf. 40m2 private garden, peaceful (...)
€995,000
TSEA4978693
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Stunning Ground Floor Apartment for Sale in La Cala de Mijas, Costa del Sol
Discover your dream coastal living experience in this exceptional ground floor apartment perfectly located in the (...)
€435,000
TSEA4977019
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 106 Lot Size: 24 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Lot Size: 24 Area: Casares Region: Andalucía
Discover this stunning brand new, key ready corner 3-bedroom garden apartment nestled in the charming region of Casares Costa.
As you step inside, you are welcomed by a bright and airy layout that (...)
€599,000
TSEA4976164
- Higueron, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 162 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Fuengirola Region: Andalucía
Luxury Ground Floor Apartment with 3 Bedrooms in El Higuerón, Las Lomas 2
READY TO MOVE IN!
Discover the perfect combination of luxury, comfort, and modern architecture in this stunning (...)
€485,000
TSEA4976056
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Welcome to this exclusive and elegant apartment that offers and spacious residence for you and your family.
Located in the area of Cancelada between Estepona and Marbella, just 5 minutes driving (...)
€125,000
TSEA4975960
- Manilva, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 60 Lot Size: 50 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Lot Size: 50 Area: Manilva Region: Andalucía
BEST PRICE AROUND ! EASY, NO HASSLE * YEARLY RETURN * 60 DAYS FREE USE
***Very nice Tourist Apartment located in the urbanization of Bahía de las Rocas, Village Club site in Terrazas Costa del Sol (...)
€769,000
TSEA4975849
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
RESALE PROPERTY
Luxury 2-Bedroom Apartment with Private Plunge Pool
Experience a new standard of luxury living in this exquisite 2-bedroom apartment, where avant-garde design meets seamless (...)
€669,000
TSEA4975819
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
RESALE PROPERTY
Luxury 2-Bedroom Apartment with Private Plunge Pool
Experience a new standard of luxury living in this exquisite 2-bedroom apartment, where avant-garde design meets seamless (...)
€420,000
TSEA4975681
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 5 Baths: 3 M2: 302 Lot Size: 150 Area: Algeciras Region: Andalucía
Beds: 5 Baths: 3 M2: 302 Lot Size: 150 Area: Algeciras Region: Andalucía
Stunning flat located in an idyllic location in the urbanisation of La Alcaidesa within walking distance to Sotogrande.
The property with a total area of 342 m2 is distributed as follows: the main (...)
€390,000
TSEA4975354
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 88 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Casares Region: Andalucía
URB. ALCAZABA HILLS
ESTEPONA
Nice and cozy groundfloor apartment in urb. Alcazaba Hills, next to the Alcazaba Lagoon. South facing, quiet and private with views to the gardens and (...)
€4,500,000
TSEA4975186
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 6 Baths: 7 M2: 575 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 7 M2: 575 Area: Marbella West Region: Andalucía
Nestled in the prestigious Gray D'Albion complex in Marbella - Puerto Banus, this exceptional ground floor duplex offers an unparalleled beachfront living experience. With six spacious bedrooms and (...)
€309,000
TSEA4974811
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 116 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Marbella East Region: Andalucía
Exceptionally large two bedroom ground floor corner apartment.
Superb panoramic views.
Quality fittings throughout.
Small garden room extension.
Situated in thriving community with wonderful sub (...)
€260,000
TSEA4974757
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 48 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 48 Area: Estepona Region: Andalucía
Location, Location, Location! If you are looking for a property in the heart of Old Town Estepona, just yards away from the sandy beaches with all shops, bars and restaurants on the doorstep then (...)
€710,000
TSEA4974682
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 143 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 143 Area: Marbella West Region: Andalucía
Ground floor apartment with three bedrooms and two bathrooms, featuring a large living room and direct access to a spacious garden, with ample bedrooms. One of the three bedrooms is currently (...)
€1,795,000
TSEA4974301
- Ojén, Costa Del Sol, Ojen
Beds: 3 Baths: 3 M2: 193 Area: Ojen Region: Andalucía
Beds: 3 Baths: 3 M2: 193 Area: Ojen Region: Andalucía
Experience unmatched luxury and sophistication in this stunning ground floor apartment situated within the prestigious Los Pinsapos building, nestled in the highly desirable Palo Alto, Ojen area. (...)
€850,000
TSEA4974064
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 100 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Malaga Region: Andalucía
Just a few steps from the historic Atarazanas Market, this duplex penthouse offers a rare mix of character and modern design. The building has been fully renovated, preserving its charm while (...)
€320,000
TSEA4972939
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
This fantastic home in Mijas is perfect for those seeking comfort and tranquility while staying close to all essential services. It is a recently renovated ground-floor property, ready to move into, (...)
Current Featured Properties
€855,000
TSEA4955536
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 3 M2: 177 Area: Casares Region: Andalucía
Beds: 4 Baths: 3 M2: 177 Area: Casares Region: Andalucía
A private beach right on your doorstep. Turquoise waters in a tropical setting. An exclusive Mediterranean-style residential complex. Homes with large terraces and high-quality finishes. 38 (...)
€4,995,000
TSEA4445479
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 138 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Area: Marbella Region: Andalucía
This is a stunning modern apartment sporting sea views within the exclusive enclave of the Puente Romano Resort on the Marbella Golden Mile. The apartment exudes seaside sophistication, embracing its (...)
€689,900
TSEA4624537
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
This brand new development stands out! An exclusive residential complex with spacious layouts and top-tier construction. The residences have been built with the highest-quality materials and feature (...)
