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 (70,36,37,38)
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 (70,36,37,38)
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 (70,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 181 - 200 of 677 €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 (...)
€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 (...)
€1,450,000
TSEA5079052
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 276 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 276 Area: Marbella West Region: Andalucía
Nestled in Nueva Andalucia, this townhouse is a recently renovated, special corner unit with
a unique interior design. This three-floor property offers an open-plan kitchen with Siemens
appliances on (...)
€1,190,000
TSEA5078884
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 200 Lot Size: 25 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Lot Size: 25 Area: Marbella East Region: Andalucía
Nestled within one of Bahía de Marbella's most sought-after beachfront urbanizations, this stunning townhouse offers an unparalleled coastal living experience. Imagine waking up to the sound of the (...)
Current Featured Properties
€640,000
TSEA4551028
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 3 M2: 193 Area: Istan Region: Andalucía
Beds: 3 Baths: 3 M2: 193 Area: Istan Region: Andalucía
STUNNING MOUNTAIN AND SEA VIEWS!!!
This new development encompasses precisely this combination of the best of the mountains and coast on Costa del Sol. Originally the location of an ancient oil mill (...)
€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 (...)
€673,000
TSEA4107058
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
