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 (61,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 (61,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 (61,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 341 - 360 of 757 €765,000
TSEA5046961
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 226 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 226 Area: Benahavis Region: Andalucía
Stylish Townhouse in Los Arqueros
Los Almendros – Los Arqueros Golf, Benahavís
3 Bedrooms + 1 Guest/Multi-purpose room/ Apartment
3 ½ Bathrooms | Private garage | Multiple (...)
€550,000
TSEA5046070
- Bel Air, Costa Del Sol, Estepona
Beds: 5 Baths: 4 M2: 275 Area: Estepona Region: Andalucía
Beds: 5 Baths: 4 M2: 275 Area: Estepona Region: Andalucía
We present to you a stunning townhouse in COSTALITA on the New Golden Mile
5 bedrooms, 3.5 bathrooms, and 2 private underground parking spaces — the perfect
choice for a family or anyone who (...)
€480,000
TSEA5045056
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 2 M2: 216 Lot Size: 50 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 2 M2: 216 Lot Size: 50 Area: San Pedro Region: Andalucía
Magnificent townhouse with independent entrance located in a quiet residential area. The house is very well oriented and sunny all year round. It is a two-minute walk from supermarkets: Mercadona, (...)
€740,000
TSEA5045011
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 215 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 215 Area: Estepona Region: Andalucía
Beautiful modern townhouse built in October 2019, located in a quiet neighborhood in the heart of Estepona. The property has a plot of 84 m² and a built area of 232 m² distributed in three bedrooms (...)
€450,000
TSEA5044714
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 171 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 171 Area: Fuengirola Region: Andalucía
Lovely townhouse for sale in Los Boliches close to all amenities and walking distance to the beach. This property offers 4 bedrooms and 4 bathrooms, lounge dining and underground parking space. Nice (...)
€682,000
TSEA5044267
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 3 M2: 251 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 3 M2: 251 Area: Torremolinos Region: Andalucía
We present to you this exclusive townhouse located in a quiet and well-maintained family-friendly residential complex in Torremolinos — a perfect setting for those who value peace without giving up (...)
€470,000
TSEA5044264
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 3 Baths: 1 M2: 213 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 1 M2: 213 Area: Benalmadena Region: Andalucía
Three-bedroom semi-detached house for sale in a quiet and safe residential area. The house comes with a private garage and a communal garden and pool, perfect for enjoying the sun and nature.
House (...)
€549,000
TSEA5043595
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 278 Lot Size: 78 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 278 Lot Size: 78 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive townhouse in Riviera del Sol with panoramic views and elegant interior
We present this townhouse located in the prestigious gated community Estrellas del Golf, surrounded by golf courses. (...)
€1,166,550
TSEA5042740
- Cancelada, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 306 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 306 Area: Estepona Region: Andalucía
Unique Opportunity for Sale in Cancelada, Estepona! Corner Townhouse Just Minutes from Puerto Banús and Marbella
Discover this fantastic corner townhouse located in one of the best areas of (...)
€1,975,000
TSEA5042473
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 344 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 344 Area: Marbella East Region: Andalucía
This spacious and light-filled 3-bedroom, 3-bathroom townhouse offers a rare combination of generous interior space, stunning views, and outdoor living in one of Marbella's most sought-after (...)
€515,000
TSEA5042206
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 130 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Marbella West Region: Andalucía
Charming Townhouse with Investment Potential in the Heart of Nueva Andalucía
Discover this cozy and charming property located in the sought-after area of Nueva Andalucía, just a 10-minute walk (...)
€675,000
TSEA5041882
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 135 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 135 Area: Fuengirola Region: Andalucía
Townhouse, Fuengirola, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 135 m², Terrace 40 m².
Setting : Town, Close To Shops.
Orientation : East.
Condition : Good.
Pool : Communal.
Climate Control : (...)
€399,000
TSEA5041846
- Torreguadiaro, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 112 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Sotogrande Region: Andalucía
Ticking All Boxes In Torreguadiaro
This is a rare find - a 3 bedroom townhouse in Torreguadiaro that's affordable and allows you to comfortably walk to everything.
The property is 112m2 built as (...)
€349,000
TSEA5041840
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 1 M2: 87 Lot Size: 71 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 1 M2: 87 Lot Size: 71 Area: Marbella East Region: Andalucía
Lovely townhouse full of character in the heart of Elviria. Located just a 5-minute walk from the Elviria shopping center and a mere 10 minutes to the beach, this gated complex is perfect for (...)
€460,000
TSEA5041777
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 46 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 46 Area: Mijas and Mijas Costa Region: Andalucía
Charming Corner Townhouse by the Beach – Riviera del Sol
Situated in a sought-after beachfront urbanisation in Riviera del Sol, this delightful corner townhouse offers the perfect blend of (...)
€550,000
TSEA5041237
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 98 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 98 Area: Marbella Region: Andalucía
Mediterranean-Style Townhouse with Breathtaking Sea Views in Altos de Los Monteros
Welcome to this charming Mediterranean-style townhouse, nestled in an exclusive gated community of just 25 homes in (...)
€1,590,000
TSEA5040688
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 261 Lot Size: 200 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 261 Lot Size: 200 Area: Marbella Region: Andalucía
Semi-Detached House for Sale in Hill Club, Sierra Blanca, Marbella
Discover this stunning semi-detached house in the exclusive area of Hill Club, in Sierra Blanca, Marbella. With a constructed area (...)
€495,000
TSEA5040073
- Monda, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 342 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 342 Area: Marbella Region: Andalucía
Traditional Andalusian Home with Guest Apartment – Prime Location in Monda Village
Welcome to this beautifully restored village home, full of authentic charm and modern comfort, located right in (...)
€699,000
TSEA5039860
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 138 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Area: Benahavis Region: Andalucía
This charming townhouse is located in El Alto, an exclusive gated community perched at the top of the hill, offering a peaceful retreat far from the noise and hustle of daily life. The urbanisation (...)
€479,000
TSEA5039452
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 110 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 110 Area: Fuengirola Region: Andalucía
This 110-square-meter property offers an excellent investment opportunity just steps from the sea. The home features four spacious bedrooms, ideal for families or those seeking comfort and (...)
Current Featured Properties
€584,250
TSEA5065531
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 151 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 151 Area: Estepona Region: Andalucía
Welcome to the residential complex in Estepona, your new home on the Costa del Sol.
The residential development is an exclusive promotion of 87 single-family homes ready to move into, located in the (...)
€715,000
TSEA4798984
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 175 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 175 Area: Estepona Region: Andalucía
BOUTIQUE COLLECTION OF FRONT-LINE GOLF TOWNHOUSES!
Situated on the front line of Estepona Golf Course, your new residence is steps away from the clubhouse and fairways of one of the best golf courses (...)
€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 (...)
