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 (46,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 (46,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 (46,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 201 - 220 of 771 €345,000
TSEA5085484
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 110 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Malaga Region: Andalucía
For sale, a charming corner house that exudes the allure of traditional popular architecture in Málaga. This property is located in the Molinillo neighborhood, in the central district of Málaga. (...)
€495,000
TSEA5084074
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 131 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 131 Area: Estepona Region: Andalucía
Located within the exclusive El Campanario area of Estepona, this elegant corner townhouse is part of a peaceful development of just 47 homes. Designed with traditional Andalusian architecture, the (...)
€570,000
TSEA5083384
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 140 Lot Size: 250 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 140 Lot Size: 250 Area: Benalmadena Region: Andalucía
Spectacular semi-detached corner townhouse in Benalmadena!
In a unique setting on the Costa del Sol, with a privileged location between Malaga and Marbella we have this house in Benalmadena village a (...)
€450,000
TSEA5081449
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 200 Lot Size: 40 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 200 Lot Size: 40 Area: Estepona Region: Andalucía
Super opportunity! Large nice half corner townhouse in watergardens cancelada. This house is in original state and can be reformed in an absolute beauty.
To get to the property you enter the gated (...)
€425,000
TSEA5081407
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 127 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Casares Region: Andalucía
Discover this charming 3-bedroom townhouse located in Marina de Casares, one of the most pleasant and peaceful residential areas of Casares Playa. With a built area of 127 m² and an additional 91 (...)
€410,000
TSEA5081350
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 119 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 119 Area: Torremolinos Region: Andalucía
Eng.: Unbeatable location: Just a 2-minute walk to the train station and several supermarkets. Close to schools and all essential services.
Features:
- Part of a gated community with a pool and (...)
€379,000
TSEA5081050
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 108 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 108 Area: Fuengirola Region: Andalucía
Cozy 3-Story Townhouse in Good Condition with Urban Views and Private Patio with Barbecue in the Torreblanca Area
Charming 3-story townhouse for sale, located in a quiet community of seven homes. (...)
€420,000
TSEA5081047
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 143 Lot Size: 36 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 143 Lot Size: 36 Area: Mijas and Mijas Costa Region: Andalucía
Very bright detached house situated on a plot of almost 114 square meters and with a constructed area of about 190 square meters, distributed on three floors
Ground floor
large living room with (...)
€350,000
TSEA5080942
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 141 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Area: Mijas and Mijas Costa Region: Andalucía
???? Charming Two-Story Townhouse in El Coto, Campo de Mijas
Discover this delightful two-story townhouse located in one of the most peaceful and sought-after areas of El Coto, in Campo de Mijas. A (...)
€285,000
TSEA5080864
- Torrox Costa, Costa Del Sol East
Beds: 2 Baths: 1 M2: 70 Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Region: Andalucía
Great location of this townhouse in Torrox Costa, close to the beach and to all amenities. Also a public school is just a few minutes away. The townhouse offers a patio at the entrance, a large (...)
€435,000
TSEA5080747
- Montemar, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 96 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 96 Area: Torremolinos Region: Andalucía
Set in peaceful Montemar, this beautifully kept 4-bedroom townhouse delivers easy Costa living with everything on your doorstep. The ground floor offers a generous semi open-plan kitchen—fully (...)
€1,595,000
TSEA5080336
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 385 Lot Size: 178 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 385 Lot Size: 178 Area: Marbella West Region: Andalucía
Discover this charming and unique townhouse for sale in Aloha, located within the exclusive gated community of Aloha Real in the heart of Nueva Andalucía, Marbella. Perfectly positioned along the (...)
€1,150,000
TSEA5080309
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 204 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 204 Area: Marbella East Region: Andalucía
Discover a residence that beautifully blends traditional Andalusian charm with modern-day sophistication, located in the highly sought-after Lomas del Marbella Club Pueblo. Just under one kilometre (...)
€1,350,000
TSEA5080300
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 3 M2: 210 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 3 M2: 210 Area: Marbella East Region: Andalucía
Tucked away in the enchanting and prestigious enclave of Lomas del Marbella Club Pueblo less than a kilometer from Marbella's golden coastline. This tastefully renovated 3-bedroom townhouse blends (...)
€640,000
TSEA5080234
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 187 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 187 Area: Estepona Region: Andalucía
Large Family Townhouse in Estepona – Prime Location on Calle Juan Blanco
Discover this beautifully maintained 3-bedroom, 3-bathroom townhouse, perfectly positioned in the heart of Estepona. (...)
€760,000
TSEA5080183
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 160 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 160 Area: Estepona Region: Andalucía
Luxurious renovated townhouse on the beach side – ready to move in within weeks
Welcome to this beautiful townhouse, located on the sought-after beach side of the coast, where comfort, style and (...)
€425,000
TSEA5080153
- Guadiaro, Costa Del Sol, Sotogrande
Beds: 4 Baths: 4 M2: 150 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 4 M2: 150 Area: Sotogrande Region: Andalucía
CHARMING RUSTIC VILLAGE HOUSE WITH EXCEPTIONAL QUALITIES AND MOUNTAIN & SEA VIEWS
Located in the village of Guadiaro, this beautiful rustic-style townhouse stands out for its superb finishes, (...)
€580,000
TSEA5080009
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 66 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 66 Area: Mijas and Mijas Costa Region: Andalucía
Discover the essence of coastal living in this stylish 2-bedroom, 2-bathroom townhouse, located in the prestigious Doña Lola resort, set directly on the beachfront in Calahonda. With 57 m² of (...)
€870,000
TSEA5079868
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 334 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 334 Area: Marbella Region: Andalucía
Spacious semi-detached house with terrace, garden, swimming pool and double garage in one of the best residential areas of Marbella
Located in a quiet gated community with landscaped gardens and (...)
€350,000
TSEA5079100
- Campo Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 141 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Area: Mijas and Mijas Costa Region: Andalucía
Unique opportunity! Semi-detached house located in the prime area of the El Coto residential development, in a quiet location yet close to all amenities.
This fantastic two-story home, with a (...)
Current Featured Properties
€747,000
Townhouse in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 141 Lot Size: 24 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 141 Lot Size: 24 Area: Mijas and Mijas Costa Region: Andalucía
TOWNHOUSES IN LA CALA DE MIJAS.
Ideally located next to El Chaparral Golf Course, a few metres from the beach, very close to the lively, bustling entertainment area of La Cala de Mijas and the (...)
€375,000
TSEA5155180
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 113 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Benahavis Region: Andalucía
3-bed Townhouse in Benahavís Pueblo – Costa del Sol
Set in the picturesque heart of Benahavís Pueblo, one of Andalusia's most sought-after whitewashed villages, this beautifully presented (...)
€980,000
TSEA4621648
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
This exclusive project with an elegant Scandinavian design blends harmoniously with the surrounding nature. The architecture of the townhouses follows seamlessly the undulating shapes of the (...)
