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 (39,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 (39,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 (39,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 821 - 840 of 1810
€397,400
TSEA5043700
- Río Real, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 134 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Marbella East Region: Andalucía
RENTED PROPERTY. OPPORTUNITY FOR INVESTORS.
What does a profitable property mean? Having a profitable property means that the owner is obtaining economic benefits from their property through its (...)
€535,000
TSEA5043688
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 129 Lot Size: 42 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 129 Lot Size: 42 Area: Benalmadena Region: Andalucía
RESIDENCE NOT ACCEPTING TOURIST RENTALS
Tastefully decorated, it has an equipped kitchen, a living room, a terrace of more than 50m2 with a magnificent view of the sea. The first bedroom has a 140 (...)
€450,000
TSEA5043685
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Stylish Ground Floor Apartment with Spacious Garden in Aranya Estepona!
Discover this beautiful 2-bedroom ground floor apartment in the new development Aranya Estepona, ideally located on the (...)
€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 (...)
€470,000
TSEA5042464
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 217 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 217 Area: Marbella West Region: Andalucía
Located in one of the most exclusive and peaceful developments in Nueva Andalucía, this elegant ground floor apartment offers the perfect blend of comfort, privacy, and Mediterranean style. It (...)
€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 (...)
€416,000
TSEA5042008
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 62 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 62 Area: San Pedro Region: Andalucía
In an exceptional location in San Pedro Alcántara, just a short walk from the beach and with views of the sea and the impressive La Concha peak. Discover a new way of living in San Pedro Alcántara (...)
€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 (...)
€333,000
TSEA5041834
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 1 Baths: 1 M2: 51 Area: San Pedro Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: San Pedro Region: Andalucía
In an exceptional location in San Pedro Alcántara, just a short walk from the beach and with views of the sea and the impressive La Concha peak. Discover a new way of living in San Pedro Alcántara (...)
€998,000
TSEA5041783
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 161 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 161 Area: Benahavis Region: Andalucía
Luxury and spacious 3 bedrooms, 3 bathrooms apartment with nice sea views, situated in a private gated urbanization: Buenavista de La Quinta. This apartment is located in a small complex of 6 (...)
€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 (...)
€795,000
TSEA5041636
- Nagüeles, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 185 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 185 Area: Marbella Region: Andalucía
Experience luxury and comfort in one of Marbella's most exclusive areas!
This elegant ground-floor apartment is located in a prestigious gated community in Sierra Blanca – Nagüeles, just 3 minutes (...)
€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 (...)
€560,000
TSEA5041213
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 120 Lot Size: 66 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 66 Area: Estepona Region: Andalucía
Welcome to Vanian Gardens, one of Estepona's premier residential communities.
This stunning 3-bedroom, 2-bathroom apartment offers a perfect combination of style, space, and comfort. Featuring a (...)
€484,000
TSEA5041186
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 120 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: La Duquesa Region: Andalucía
Ground Floor Apartment, La Duquesa, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 120 m², Terrace 34 m².
Setting : Beachfront, Beachside, Port, Close To Golf, Close To Port, Close To Sea, Close To (...)
€424,000
TSEA5040955
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
New Development: Prices from 424,000 € to 736,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 100.00 m2 - 137.00 m2]
Our architecture is more than what you see. We believe in design that (...)
Current Featured Properties
€445,000
TSEA4989478
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
SECOND LINE BEACH 2 BED/2 BATH TOWNHOUSE – ESTEPONA PROMENADE!
Immaculately maintained and upgraded family townhouse less than 2 minutes walking distance from the emblematic Mirador de Estepona, (...)
€629,900
TSEA5076349
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 200 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Area: Mijas and Mijas Costa Region: Andalucía
This is an exclusive collection of luxury homes, comprising 48 high-end apartments nestled in the heart of the Costa del Sol. This unique development offers an elevated standard of living, boasting (...)
€530,000
TSEA4761718
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 4 Baths: 2 M2: 120 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 2 M2: 120 Area: Algeciras Region: Andalucía
We´re happy to present a new flagship project in La Alcaidesa, San Roque, just 10 minutes from Sotogrande, with spectacular views of the Mediterranean Sea, the golf course and Gibraltar.
Superb (...)
