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 241 - 260 of 895 €279,000
TSEA5078200
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 4 Baths: 2 M2: 245 Lot Size: 114 Area: Alhaurin el Grande Region: Andalucía
Beds: 4 Baths: 2 M2: 245 Lot Size: 114 Area: Alhaurin el Grande Region: Andalucía
Located in the heart of Alhaurin el Grande, sits this spacious and deceptively large four bedroom townhouse, presented in move in ready condition. This property, will appeal to a wide range of (...)
€720,000
TSEA5077666
- Aloha, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 229 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 229 Area: Marbella West Region: Andalucía
A beautifully renovated corner townhouse in the prestigious neighborhood of Nueva Andalucía. Spanning 229 m² of refined living space with an additional 80 m² of sun-drenched terraces, this stylish (...)
€375,000
TSEA5077363
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Opportunity in Benahavís – 3-Bedroom Townhouse Ideal for Living or Investment
Located in the charming and historic village of Benahavís, this beautifully presented 3-bedroom, 2-bathroom townhouse (...)
€140,000
TSEA5077348
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 35 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 35 Area: Fuengirola Region: Andalucía
Excellent investment or business opportunity.
35 m² commercial premises located on one of the pedestrian streets in the heart of Fuengirola, just 500 m from the train and bus stations, and (...)
€349,000
TSEA5077342
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 116 Lot Size: 20 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Lot Size: 20 Area: Estepona Region: Andalucía
Beautifully Reformed 3-Bedroom Townhouse in Bel Air
Step into this bright and airy reformed townhouse, offering 3 spacious bedrooms and 2 modern bathrooms in the sought-after area of Bel Air. (...)
€546,000
TSEA5076790
- El Hornillo, Costa Del Sol East
Beds: 3 Baths: 3 M2: 187 Region: Andalucía
Beds: 3 Baths: 3 M2: 187 Region: Andalucía
For sale: a beautiful and spacious three-story townhouse located in the area of Calle Labiernago del Hornillo.
On the main floor, you'll find a bright and airy open-plan living room and (...)
€190,000
TSEA5076622
- Tolox, Costa Del Sol, Yunquera
Beds: 5 Baths: 1 M2: 177 Lot Size: 55 Area: Yunquera Region: Andalucía
Beds: 5 Baths: 1 M2: 177 Lot Size: 55 Area: Yunquera Region: Andalucía
This charming semi-detached chalet in Tolox, Málaga, is just what you need. With 177 m² spread over 3 floors, this house offers 5 spacious bedrooms, 1 large bathroom, and a fully equipped kitchen. (...)
€520,000
TSEA5076397
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 155 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 155 Area: Estepona Region: Andalucía
Magnificent semi-detached house located in Cancelada village, yet sufficiently secluded to avoid any noise or heavy traffic.
We walk to all the town's amenities, banks, shops, restaurants, etc. (...)
€945,000
TSEA5076373
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 421 Lot Size: 35 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 421 Lot Size: 35 Area: Marbella West Region: Andalucía
Elegant Family Townhouse in the Heart of Nueva Andalucía, Marbella´s Golf ValleyWelcome to this beautifully maintained and spacious townhouse, ideally situated in the prestigious Golf Valley of (...)
€226,000
TSEA5076229
- Algodonales, Costa de la Luz
Beds: 6 Baths: 3 M2: 220 Region: Andalucía
Beds: 6 Baths: 3 M2: 220 Region: Andalucía
Spacious two-story house in the town of Algodonales, Cádiz. Total measuring 255 m2; 220 m2 plus an 18 m2 patio, terrace, and a 17 m2 balcony close to all amenities.
The ground floor consists of 3.5 (...)
€110,000
TSEA5075734
- Cuevas Bajas, Costa Del Sol, Antequera
Beds: 4 Baths: 1 M2: 136 Lot Size: 186 Area: Antequera Region: Andalucía
Beds: 4 Baths: 1 M2: 136 Lot Size: 186 Area: Antequera Region: Andalucía
Charming Village House in Cuevas Bajas (Antequera)
Two-story home located in the heart of Cuevas Bajas, just 20 minutes from the growing Antequera Dry Port. A quiet area, well connected, with all (...)
€1,850,000
TSEA5075620
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 273 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 273 Area: Marbella West Region: Andalucía
Beautifully designed three-story townhouse for sale in Nueva Andalucía's Golf Valley. Recently renovated, the property blends Mediterranean charm with the clean lines and functionality of modern (...)
€173,900
TSEA5075500
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 1 M2: 108 Area: Coin Region: Andalucía
Beds: 3 Baths: 1 M2: 108 Area: Coin Region: Andalucía
TOWNHOUSE FOR SALE
Investment opportunity in the heart of Coín!
We present you this charming townhouse located in a very central area, within walking distance to all the stores, services and (...)
€2,300,000
TSEA5075203
- Villanueva De La Concepcion, Costa Del Sol, Malaga
Beds: 13 Baths: 13 M2: 935 Lot Size: 50,000 Area: Malaga Region: Andalucía
Beds: 13 Baths: 13 M2: 935 Lot Size: 50,000 Area: Malaga Region: Andalucía
LUXURY BOUTIQUE HOTEL WITH HELIPAD - TENNIS COURT - HEATED POOL.
This boutique hotel in Villanueva de la Concepción, near the Torcal Mountains, offers 11 beautifully renovated rooms and (...)
€553,000
TSEA5074165
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 5 Baths: 3 M2: 243 Area: Fuengirola Region: Andalucía
Beds: 5 Baths: 3 M2: 243 Area: Fuengirola Region: Andalucía
Townhouse Under Construction
Unique opportunity to finish and customize a spacious townhouse in a prime location.
This partially built property includes:
* Ground floor with front porch, (...)
€660,000
TSEA5074087
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 160 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Marbella West Region: Andalucía
INVESTMENT OPPORTUNITY! NUEVA ANDALUCIA, WALKING DISTANCE TO AMENITIES
Townhouse, located in Nueva Andalucía, is just a short walk from the beach in Puerto Banus and only a minute's drive from the (...)
€379,900
TSEA5073976
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 173 Lot Size: 222 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 173 Lot Size: 222 Area: Benalmadena Region: Andalucía
Exquisite 3-Bedroom Townhouse in an Exclusive Community
Discover this beautiful, recently renovated 3-bedroom townhouse that combines modern luxury with a sustainable lifestyle. With solar panels on (...)
€1,160,000
TSEA5073889
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 307 Lot Size: 10 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 307 Lot Size: 10 Area: Marbella Region: Andalucía
Situated in the prestigious Oasis de Nagüeles urbanization on Marbella's sought-after Golden Mile, this spacious 5-level townhouse offers a unique opportunity to create your ideal home in one of the (...)
€495,000
TSEA5073847
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 4 Baths: 3 M2: 179 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 3 M2: 179 Area: Sotogrande Region: Andalucía
Beautiful Townhouse in Sotogrande with Terrace and Solarium
Elegant townhouse in impeccable condition, ready to move in, located in a peaceful and family-friendly residential area of Sotogrande (...)
€4,250,000
TSEA5073775
- Casares, Costa Del Sol, Casares
Beds: 6 Baths: 5 M2: 2,000 Lot Size: 45,000 Area: Casares Region: Andalucía
Beds: 6 Baths: 5 M2: 2,000 Lot Size: 45,000 Area: Casares Region: Andalucía
A Unique, Multi-Faceted Estate - Diverse development potential, sitting on a plot of 45,000m2.
Tucked between gentle hills and a river, this discreet rural estate offers a rare combination of (...)
Current Featured Properties
€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 (...)
€720,000
TSEA4713529
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 116 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Branded Residence comprising of 58 incredible 2 and 3 bedroom frontline golf homes to be built to the highest specification overlooking the renowned La Cala Resort Golf course. Reaching the (...)
€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 (...)
