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 (47,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 (47,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 (47,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 261 - 280 of 895 €650,000
TSEA5073772
- Estepona, 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
Beachfront Townhouse – Estepona
Discover this charming townhouse located in a sought-after beachfront urbanization in Estepona, with direct access to the seaside promenade. An unbeatable location (...)
€395,000
TSEA5073355
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 120 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 120 Area: Benalmadena Region: Andalucía
Spacious townhouse spread over three floors, ideal for families seeking comfort, natural light, and an unbeatable location.
Ground floor:
Accessed through a large patio with a separate office or (...)
€399,000
TSEA5073259
- Alora, Costa Del Sol, Älora
Beds: 4 Baths: 3 M2: 362 Area: Älora Region: Andalucía
Beds: 4 Baths: 3 M2: 362 Area: Älora Region: Andalucía
Unique Townhouse with Panoramic Views in the Heart of Álora
Located in the charming center of Álora, this beautifully renovated townhouse offers nearly 400 m² of living space spread across five (...)
€425,000
TSEA5073238
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 147 Lot Size: 11 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 147 Lot Size: 11 Area: Manilva Region: Andalucía
Charming Townhouse in Bahía de las Rocas, Sotogrande
3 Bedrooms | Stunning Sea Views | Private Garden | Underground Parking & Storage
This elegant and modern townhouse enjoys panoramic views of (...)
€530,000
TSEA5072896
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 3 M2: 128 Area: Manilva Region: Andalucía
Beds: 3 Baths: 3 M2: 128 Area: Manilva Region: Andalucía
New Development: Prices from 530,000 € to 590,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 128.00 m2 - 131.00 m2]
EXCLUSIVE TURNKEY PROJECT
Between Estepona and Sotogrande, in the (...)
€148,500
TSEA5072533
- Cómpeta, Costa Del Sol East
Beds: 5 Baths: 2 M2: 156 Lot Size: 78 Region: Andalucía
Beds: 5 Baths: 2 M2: 156 Lot Size: 78 Region: Andalucía
Were pleased to present this charming and spacious townhouse in the upper part of Cómpeta, just a short walk from Plaza del Carmen. Nearby, youll find everything you need for daily life: a (...)
€620,000
TSEA5072410
- Artola, Costa Del Sol, Marbella East
Beds: 5 Baths: 4 M2: 178 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 4 M2: 178 Area: Marbella East Region: Andalucía
Prime location in the sought-after Artola Alta area, directly overlooking Cabopino Golf and only a 12-minute walk (approx. 900 meters) to the beautiful Cabopino´s Beach and the Cabopino (...)
€399,000
TSEA5072362
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 149 Lot Size: 138 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Lot Size: 138 Area: La Duquesa Region: Andalucía
**Renovated Townhouse in Hacienda Guadalupe - Your New Home Awaits!**
Discover this stunning renovated townhouse, located in the coveted Hacienda Guadalupe development, just minutes from Puerto de (...)
€559,990
TSEA5072329
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 177 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 177 Area: Benalmadena Region: Andalucía
Townhouse with sea views in Torremuelle, steps away from the British College.
Discover this spacious townhouse in the exclusive urbanization Arcadia 16, located in Torremuelle, one of the most (...)
€475,000
TSEA5071120
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 140 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Estepona Region: Andalucía
Charming 3-Bedroom Townhouse with Sea Views in Puerto Romano
Nestled in the tranquil residential enclave of Puerto Romano, this 3-bedroom townhouse offers the perfect blend of comfort, charm, and (...)
€460,000
TSEA5070208
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 267 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 267 Area: Mijas and Mijas Costa Region: Andalucía
Discover your dream home in this beautiful terraced house located in the heart of Andalucía, Málaga. Alhaurin de la torre, this spacious 267m² property offers a perfect blend of comfort and (...)
€215,000
TSEA5070166
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 60 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Benalmadena Region: Andalucía
**Townhouse in the Heart of Arroyo de la Miel**
Discover this charming townhouse in the heart of Arroyo de la Miel! With 60 m² built, this home is perfect for families looking to enjoy an authentic (...)
€290,000
TSEA5070118
- Istán, Costa Del Sol, Istan
Beds: 4 Baths: 2 M2: 120 Lot Size: 80 Area: Istan Region: Andalucía
Beds: 4 Baths: 2 M2: 120 Lot Size: 80 Area: Istan Region: Andalucía
Exclusive Opportunity in the Heart of Istán!
Charm and Profitability Come Together. Discover a real estate gem in the historic center of Istán, a town that radiates authentic Andalusian charm, (...)
€1,200,000
TSEA5069854
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 204 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 204 Area: Marbella West Region: Andalucía
Discover this beautifully maintained corner townhouse located in the exclusive gated community of Altos de Aloha, Nueva Andalucía. With 4 bedrooms and 4 bathrooms, this property is ideal for (...)
€550,000
TSEA5069740
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 162 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Estepona Region: Andalucía
CHARMING TOWNHOUSE WITH TERRACE, PRIVATE GARAGE, AND SOUTH-FACING ORIENTATION
Located in a peaceful residential development in Estepona, just a few minutes' drive from all amenities, shops, and (...)
€495,000
TSEA5069701
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 155 Lot Size: 30 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 155 Lot Size: 30 Area: Estepona Region: Andalucía
SUPERB 3 BEDROOM TOWNHOUSE - WALKING DISTANCE TO THE BEACH
A charming 3-bedroom, 2-bathroom townhouse nestled within the exclusive, gated community of Riviera Beach in Cancelada Estepona. A private (...)
€695,000
TSEA5069578
- Torrox Costa, Costa Del Sol East
Beds: 3 Baths: 2 M2: 110 Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Region: Andalucía
If you dream of owning a home on the Costa del Sol in Spain, now is the time to take a look.
At El Mirador Spa & Resort we now only a few homes for sale out of the 37 architect-designed luxury (...)
€895,000
TSEA5067379
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 233 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 233 Area: Marbella East Region: Andalucía
Town House for sale in Camojan Blanco, Marbella with 4 bedrooms, 4 bathrooms, 4 en suite bathrooms and with orientation south, with communal swimming pool and private garden. Regarding property (...)
€520,000
TSEA5067157
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 84 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 84 Area: Fuengirola Region: Andalucía
Sun, sea, and the good life lovers! Are you ready to discover your personal paradise on the Costa del Sol?
Imagine this: waking up to the sound of the waves, enjoying a coffee under the Andalusian (...)
€850,000
TSEA5066983
- San Martín de Tesorillo, Costa Del Sol, Sotogrande
Beds: 1 Baths: 1 M2: 100 Lot Size: 40,000 Area: Sotogrande Region: Andalucía
Beds: 1 Baths: 1 M2: 100 Lot Size: 40,000 Area: Sotogrande Region: Andalucía
Awesome plot, easy accessible and close to san martin de tesorillo on the road to Jimena.
Gorgeous located plot with water and electric. Working business and has avocados and oranges. 40000M2 of (...)
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 (...)
€483,000
TSEA3980794
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
NESTLED BETWEEN STUNNING LANDSCAPE GARDENS!!
An exclusive development of 46 townhouses of 2, 3 and 4 bedrooms, some of them semi-detached, built in a contemporary style, in a privileged location two (...)
€730,000
Townhouse in Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 164 Lot Size: 25 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 164 Lot Size: 25 Area: Estepona Region: Andalucía
STYLISH AND ENERGY EFFICIENT IN BEAUTIFUL ESTEPONA.
This boutique development of ten 4-bed, 3-bath luxury villas offer private gardens with beautiful sea, golf and mountain views. With unique (...)
