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,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 (39,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 (39,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 901 - 920 of 1810
€444,000
TSEA4425733
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
New Development: Prices from 444,000 € to 540,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 120.00 m2 - 123.00 m2]
Our architecture is more than what you see. We believe in design that (...)
€369,000
TSEA4161460
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 74 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 74 Area: Fuengirola Region: Andalucía
New Development: Prices from 369,000 € to 369,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 74.00 m2 - 74.00 m2]
Let me introduce you to this elegant new apartment development, set on the (...)
€308,800
TSEA4938337
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 54 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 54 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 308,800 € to 399,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 54.00 m2 - 79.00 m2]
We welcome you to this Residential complex, a large multi-family building that (...)
€272,729
TSEA4765210
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 272,729 € to 432,502 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 83.00 m2 - 107.00 m2]
It consists of 3 buildings with panoramic views of the sea, an innovative and (...)
€870,000
TSEA5018227
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 131 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 131 Area: Marbella East Region: Andalucía
New Development: Prices from 870,000 € to 1,350,000 €. [Beds: 2 - 3] [Baths: 2 - 3] [Built size: 131.00 m2 - 207.00 m2]
This project is a complex of 21 luxurious residences in Marbella, (...)
€675,000
TSEA5034646
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 110 Lot Size: 70 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Lot Size: 70 Area: Benahavis Region: Andalucía
FANTASTIC 3-BEDROOM GROUND FLOOR APARTMENT WITH LARGE GARDEN
Located in a quiet and safe residential area, surrounded by nature, this apartment is very well connected to the AP7 motorway, which (...)
€317,500
TSEA4957132
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 1 Baths: 1 M2: 86 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 1 M2: 86 Area: Torremolinos Region: Andalucía
New Development: Prices from 317,500 € to 631,500 €. [Beds: 1 - 4] [Baths: 1 - 3] [Built size: 86.00 m2 - 192.00 m2]
A magnificent project, consisting of 61 homes with 1, 2, 3 and 4 bedrooms, (...)
€499,000
TSEA4585324
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 108 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Istan Region: Andalucía
New Development: Prices from 499,000 € to 610,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 108.00 m2 - 114.00 m2]
32 exclusive apartments with the best panoramic views at the highest part of (...)
€720,000
TSEA4808206
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 112 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Area: Estepona Region: Andalucía
New Development: Prices from 720,000 € to 2,000,000 €. [Beds: 2 - 4] [Baths: 2 - 4] [Built size: 112.00 m2 - 195.00 m2]
57 Exclusive Sea-View Apartments in Estepona's Prestigious New Golden (...)
€195,000
TSEA5034316
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 2 Baths: 1 M2: 54 Area: Manilva Region: Andalucía
Beds: 2 Baths: 1 M2: 54 Area: Manilva Region: Andalucía
Ground-floor apartment for sale in San Luis de Sabinillas, La Duquesa, Manilva.
It consists of 2 bedrooms, 1 bathroom, a fully equipped kitchen with a laundry area. The property is small, but has (...)
€995,000
TSEA5034214
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 125 Lot Size: 70 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 125 Lot Size: 70 Area: Marbella Region: Andalucía
In the heart of the Golden Mile, one of the most sought-after residential areas. Discover your new home in Marbella! This beautiful, recently renovated ground-floor apartment boasts 150 m² of built (...)
€345,000
TSEA4600363
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 67 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 67 Area: Fuengirola Region: Andalucía
New Development: Prices from 345,000 € to 495,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 67.00 m2 - 125.00 m2]
New development for sale in the center of Fuengirola just 200 m to the beach, (...)
€699,000
TSEA5034076
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 300 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 300 Area: Mijas and Mijas Costa Region: Andalucía
For sale: a stylish and modern townhouse with 4 spacious bedrooms and 3 well-appointed bathrooms, perfectly positioned on the sunny south side — ensuring light, warmth, and comfort, especially in (...)
€1,258,290
TSEA4831858
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 202 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 202 Area: Estepona Region: Andalucía
New Development: Prices from 1,258,290 € to 1,674,135 €. [Beds: 3 - 5] [Baths: 3 - 5] [Built size: 202.00 m2 - 305.00 m2]
Introducing an exclusive residential complex located in the coveted New (...)
€459,700
TSEA4913176
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
New Development: Prices from 459,700 € to 559,700 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 75.00 m2 - 101.00 m2]
Welcome to this development, an exclusive residential complex that redefines (...)
€690,000
TSEA5032801
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 152 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 152 Area: Estepona Region: Andalucía
Stylish Corner Townhouse with Panoramic Mountain Views in Cancelada – New Build with Solarium, Terrace & High-End Upgrades
Welcome to this stunning corner townhouse with panoramic mountain (...)
€335,000
TSEA5032750
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 1 Baths: 2 M2: 55 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 2 M2: 55 Area: Torremolinos Region: Andalucía
New Development: Prices from 335,000 € to 790,000 €. [Beds: 1 - 3] [Baths: 2 - 2] [Built size: 55.00 m2 - 87.00 m2]
This project is located in one of the most sought-after areas of the city — (...)
€850,000
TSEA3467524
- San Roque, Costa Del Sol, San Roque
Beds: 1 Baths: 1 M2: 133 Area: San Roque Region: Andalucía
Beds: 1 Baths: 1 M2: 133 Area: San Roque Region: Andalucía
New Development: Prices from 850,000 € to 1,400,000 €. [Beds: 1 - 3] [Baths: 1 - 3] [Built size: 133.00 m2 - 224.00 m2]
This development is reimagining the traditional concept of a village and (...)
€295,000
TSEA5018287
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 295,000 € to 460,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 74.00 m2 - 106.00 m2]
Your ideal home on the Costa del Sol
We are pleased to exclusively present (...)
€340,000
TSEA4652383
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 340,000 € to 470,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 80.00 m2 - 98.00 m2]
The innovative and sustainable collection of homes in Las Lagunas de Mijas. (...)
Current Featured Properties
€695,000
TSEA4622989
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 78 Lot Size: 53 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Lot Size: 53 Area: Fuengirola Region: Andalucía
EMBRACE SPANISH LIFE TO THE FULLEST. Beautifully styled contemporary apartments and sky villas, extensive green areas and a PANORAMIC OVERVIEW of the Mediterranean sea is what sets this development (...)
€480,000
TSEA4791484
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
We are delighted to introduce this fabulous new development in in the beautiful area of Arroyo Enmedio in Estepona – an exclusive new development featuring 48 two and 3-bedroom apartments and (...)
€1,250,000
TSEA4926508
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 119 Lot Size: 6 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 119 Lot Size: 6 Area: Marbella Region: Andalucía
The development epitomizes the zenith of contemporary life in Marbella, renowned for its serene ambiance and breathtaking panoramic vistas that stretch from the lush pine canopies to the shimmering (...)
