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,68,69,70)
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,68,69,70)
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,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 821 - 840 of 1524 €298,000
TSEA5014546
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 52 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: Benalmadena Region: Andalucía
Discover the home of your dreams on the Costa del Sol!
This spectacular 53 m² apartment is in perfect condition and offers everything you need to live comfortably and enjoy the sun.
Key (...)
€799,000
TSEA5014522
- Málaga Centro, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 262 Lot Size: 15 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 262 Lot Size: 15 Area: Malaga Region: Andalucía
YOUR DREAM HOME NEXT TO LA CONCHA MOUNTAIN, MARBELLA !!!!
Discover this exclusive townhouse located in one of Marbella's most privileged areas, at the foot of the majestic La Concha Mountain. (...)
€1,250,000
TSEA5013634
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 160 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Marbella East Region: Andalucía
Nestled on the prestigious Golden Mile, this Townhouse is a true gem with stunning panoramic sea and mountain views.
The complex is situated within the prestigious Marbella Hill Club, known for its (...)
€339,000
TSEA5013574
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 86 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 86 Area: Marbella Region: Andalucía
A wonderful 86 m² apartment is for sale in the El Mirador area of Marbella, a quiet and well-connected location with easy access to the highway and surrounded by all amenities: bus stops, schools, (...)
€345,000
TSEA5012869
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Apartment in the lower part of Riviera del Sol. It has 2 bedrooms and 1 bathroom, a kitchen open to the living-dining room, a large terrace with sea views, and a balcony off the bedroom. Communal (...)
€1,695,000
TSEA5012860
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 330 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 330 Area: Marbella Region: Andalucía
A Seamless Blend of Andalusian Heritage and Nordic Sophistication on the Golden Mile
Nestled in the prestigious residential area of Marbella's Golden Mile, this beautifully newly renovated (...)
€1,349,000
TSEA5012209
- Monte Halcones, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 192 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 192 Area: Benahavis Region: Andalucía
This beautifully renovated 4-bedroom, 3-bathroom townhouse is the perfect blend of Scandinavian design and Mediterranean living. It's bright, spacious, and thoughtfully designed, offers a warm and (...)
€975,000
TSEA5012137
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 143 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 143 Area: Estepona Region: Andalucía
Discover this magnificent newly built apartment, located in the prestigious Las Mesas area of Estepona. Designed to combine comfort, modernity, and a privileged lifestyle, this property is ideal for (...)
€175,000
TSEA5012092
- Alora, Costa Del Sol, Älora
Beds: 4 Baths: 2 M2: 128 Area: Älora Region: Andalucía
Beds: 4 Baths: 2 M2: 128 Area: Älora Region: Andalucía
Your new home in Álora is waiting for you!
Are you looking for a spacious, bright home in a peaceful area of Álora? We present to you this fantastic ground-floor apartment, just a few steps from (...)
€685,000
TSEA5012065
- Perchel Sur, Costa Del Sol
Beds: 4 Baths: 2 M2: 134 Region: Andalucía
Beds: 4 Baths: 2 M2: 134 Region: Andalucía
Imagine waking up every morning with the sun gently lighting up your home, on the top floor of a well-kept building in the charming Plaza de la Misericordia. This apartment, located on the top floor (...)
€690,000
TSEA5011273
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 77 Lot Size: 243 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 77 Lot Size: 243 Area: Estepona Region: Andalucía
Exceptional Frontline Luxury Beach Townhouse in Bahia Dorada
Discover the epitome of luxury coastal living with this newly reformed duplex townhouse, nestled right on the beachfront in the (...)
€390,000
TSEA5011234
- El Faro, 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
Welcome to this renovated penthouse in El Faro, a sought-after area known for its views of the Mediterranean Sea and nearby mountains. The property is part of a well-maintained and quiet (...)
€1,265,000
TSEA5011201
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 220 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 220 Area: Benahavis Region: Andalucía
Luxury 4-Bedroom Penthouse for Sale in Marbella Club Hills
Welcome to this extraordinary 4-bedroom, 4-bathroom apartment located in the exclusive Marbella Club Hills development — a premium (...)
€949,000
TSEA5011114
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 4 M2: 218 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 4 M2: 218 Area: Sotogrande Region: Andalucía
Exceptional Living in Sotogrande
Welcome to a unique residential complex perched above the sea with panoramic views over lush golf courses. Designed by renowned Spanish architect Rafael de La-Hoz, (...)
€1,040,000
TSEA5011087
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 136 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Benalmadena Region: Andalucía
New Development: Prices from 1,040,000 € to 1,145,000 €. [Beds: 3 - 4] [Baths: 2 - 2] [Built size: 136.00 m2 - 167.00 m2]
DESIGN and QUALITY in all its SPACES
An exclusive boutique project of (...)
€370,000
TSEA5010688
- Guaro, Costa Del Sol, Guaro
Beds: 7 Baths: 2 M2: 306 Lot Size: 241 Area: Guaro Region: Andalucía
Beds: 7 Baths: 2 M2: 306 Lot Size: 241 Area: Guaro Region: Andalucía
Spacious 7-Bedroom Townhouse with Garage, Garden, Wine Cellar & Panoramic Roof Terrace in Guaro Village.
Nestled in the charming village of Guaro, this expansive three-level townhouse offers (...)
€370,000
TSEA5010571
- Diana Park, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 108 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Estepona Region: Andalucía
Semi-detached house for sale in residential complex, in the Atalaya area of Estepona, in an area very close to San Pedro Alcántara, Marbella and Puerto Banús.It is located on the new Golden Mile, a (...)
€1,595,000
TSEA5010322
- La Heredia, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 308 Lot Size: 181 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 308 Lot Size: 181 Area: Benahavis Region: Andalucía
STUNNING 5-BEDROOM TOWNHOUSE WITH PANORAMIC SEA, MOUNTAIN AND GOLF VIEWS
Located in the award winning village of La Heredia, close to Benahavis on the Ronda road, this beautiful 5-bedroom townhouse (...)
€185,000
TSEA5010259
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 42 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 42 Area: Mijas and Mijas Costa Region: Andalucía
BEAUTIFUL VIEWS IN MIJAS - AMAZING!! 1 BEDROOM APARTMENT WITH A FABULOUS SUNNY ROOF TOP TERRACE! ENJOYING PANORAMIC VIEWS OF THE MEDITERRANEAN COASTLINE! LOCATED IN THE BEAUTIFUL WHITE WASHED VILLAGE (...)
€69,900
TSEA5010256
- Riogordo, Costa Del Sol East
Beds: 4 Baths: 1 M2: 170 Lot Size: 103 Region: Andalucía
Beds: 4 Baths: 1 M2: 170 Lot Size: 103 Region: Andalucía
Investment opportunity in the heart of Riogordo, Malaga.
Traditional Andalusian house for sale located in one of the quietest streets of the picturesque village of Riogordo.
The property has a (...)
Current Featured Properties
€1,299,000
TSEA4792552
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 374 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 374 Area: Mijas and Mijas Costa Region: Andalucía
EVERYONE IS TALKING ABOUT MOVING TO MIJAS!!!
Located in La Cala de Mijas, one of the urban centers belonging to the municipality of Mijas. Just a 5-minute drive from the residential area, you can (...)
€649,000
TSEA3990796
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 91 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Casares Region: Andalucía
LAST CHANCE TO BUY! SEA VIEWS THAT YOU DREAM ABOUT!!!
Last 2 beds starting from 360,495€ and one last 3 bed at 558,000€!
Designed in a contemporary style, the apartments and penthouses have been (...)
€445,000
TSEA4989478
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
SECOND LINE BEACH 2 BED/2 BATH TOWNHOUSE – ESTEPONA PROMENADE!
Immaculately maintained and upgraded family townhouse less than 2 minutes walking distance from the emblematic Mirador de Estepona, (...)
