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 (57,42,43,44,45)
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 (57,42,43,44,45)
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 (57,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 81 - 100 of 2651
€975,000
TSEA5150032
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 330 Lot Size: 1,000 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 330 Lot Size: 1,000 Area: Benalmadena Region: Andalucía
Welcome to a magnificent 4-bedroom, 3-bathroom residence in the charming city of Benalmadena. Spanning an impressive 400 square meters, this elegant home embodies the essence of coastal luxury with (...)
€2,300,000
TSEA5149999
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 500 Lot Size: 1,550 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 500 Lot Size: 1,550 Area: Marbella Region: Andalucía
EXCLUSIVE INVESTMENT OPPORTUNITY IN THE HEART OF MARBELLA!
Exceptional property combining a privileged location, spaciousness, comfort and great potential for appreciation. This is a magnificent (...)
€1,450,000
TSEA5149885
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 213 Lot Size: 10,545 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 213 Lot Size: 10,545 Area: Mijas and Mijas Costa Region: Andalucía
A Spectacular, Self-Sufficient, Country Villa with Mature Grounds and Income Potential
This stunning country estate is arguably one of, if not the best of its kind being fully self-sufficient with (...)
€1,850,000
TSEA5148709
- Istán, Costa Del Sol, Istan
Beds: 4 Baths: 5 M2: 234 Lot Size: 800 Area: Istan Region: Andalucía
Beds: 4 Baths: 5 M2: 234 Lot Size: 800 Area: Istan Region: Andalucía
This exceptional four-bedroom villa, occupies the best position within the prestigious gated community of Sierra Blanca Country Club. Offering 100% privacy and uninterrupted panoramic views across (...)
€4,195,000
TSEA5148511
- Las Brisas, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 341 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 341 Area: Marbella West Region: Andalucía
We're pleased to offer an off-market villa in one of the most desirable areas of Nueva Andalucía – Las Brisas – available exclusively through private introduction.
This south-facing villa, (...)
€2,025,000
TSEA5148343
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 3 M2: 168 Lot Size: 984 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 3 M2: 168 Lot Size: 984 Area: Marbella West Region: Andalucía
This charming villa is tucked away in a peaceful cul-de-sac within the exclusive gated community of Marbella Country Club, one of Nueva Andalucía's most desirable residential areas. Set on a flat (...)
€630,000
TSEA5148316
- Torre del Mar, Costa Del Sol East
Beds: 3 Baths: 3 M2: 267 Lot Size: 320 Region: Andalucía
Beds: 3 Baths: 3 M2: 267 Lot Size: 320 Region: Andalucía
Beautiful, renovated semi-detached house in the quiet residential area of Viña Malaga. The three-storey house has two entrances. It is divided into 3 bedrooms, 3 bathrooms, a guest toilet, 2 (...)
€1,148,000
TSEA5148238
- Entrerrios, Costa Del Sol
Beds: 6 Baths: 5 M2: 425 Region: Andalucía
Beds: 6 Baths: 5 M2: 425 Region: Andalucía
Exclusive independent villa for sale with traditional Andalusian "Cortijo" style, located in one of the most peaceful and sought-after areas of Mijas, in the Entrerríos area. This unique (...)
€945,000
TSEA5148199
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 142 Lot Size: 91 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 142 Lot Size: 91 Area: Marbella West Region: Andalucía
Elegant 4-Bedroom Semi-Detached House with Garden, Jacuzzi, Garage & Laundry Room in Marbella
Just 3 km from Puerto Banús and 1.5 km from the beach, this stylish, renovated semi-detached house (...)
€649,000
TSEA5147875
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 93 Lot Size: 250 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Lot Size: 250 Area: Fuengirola Region: Andalucía
Discover your new home in Torreblanca! This impressive detached house is an excellent investment opportunity, as it has a tourist license and is ready to move into. Located in the upper part of (...)
€2,250,000
TSEA5147815
- Valtocado, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 6 M2: 556 Lot Size: 1,800 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 6 M2: 556 Lot Size: 1,800 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Detached Villa in Valtocado – Panoramic Sea & Mountain Views
This magnificent villa, set within the prestigious urbanisation of Valtocado, offers the perfect balance of elegance, space, (...)
€1,400,000
TSEA5147518
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 220 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 220 Area: Estepona Region: Andalucía
Modern Luxury Villa with Panoramic Golf & Sea Views in Estepona
This newly built modern villa in Valle Romano Golf, Estepona, boasts breathtaking panoramic views over both the golf course and (...)
€2,250,000
TSEA5147461
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M2: 441 Lot Size: 1,384 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 4 M2: 441 Lot Size: 1,384 Area: Marbella West Region: Andalucía
Well located villa boarding the golf course in the low-density residential area of Nueva Andalucía, in the heart of the Golf Valley, about 10 minutes from both Marbella and Estepona and around 45 (...)
€2,950,000
TSEA5147371
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 7 Baths: 7 M2: 623 Lot Size: 1,400 Area: San Pedro Region: Andalucía
Beds: 7 Baths: 7 M2: 623 Lot Size: 1,400 Area: San Pedro Region: Andalucía
Detached Villa, Guadalmina Alta, Costa del Sol.
7 Bedrooms, 7 Bathrooms, Built 623 m², Terrace 60 m², Garden/Plot 1400 m².
Setting : Close To Golf, Close To Shops, Close To Schools.
Orientation : (...)
€650,000
TSEA5147359
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 134 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 134 Area: Mijas and Mijas Costa Region: Andalucía
This stunning, newly completed modern contemporary 3 bedroom semi-detached villa in urbanisation Alya offers stylish contemporary living in a sought-after residential area. Built to the highest (...)
€1,495,000
TSEA5147254
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 265 Lot Size: 1,757 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 265 Lot Size: 1,757 Area: Estepona Region: Andalucía
This magnificent villa represents a unique opportunity to acquire a tastefully renovated residence in one of the most sought-after areas of Estepona. Situated in the spacious and peaceful Don Pedro (...)
€675,000
TSEA5147164
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 182 Lot Size: 500 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 182 Lot Size: 500 Area: Fuengirola Region: Andalucía
Spacious 4-Bed, 3-Bath Villa in Torreblanca – Just 10 Minutes' Walk to the Beach
This 4-bedroom, 3-bathroom villa in Torreblanca is perfect for family living, holiday getaways, or rentals. The (...)
€235,000
TSEA5147152
- San Roque, Costa Del Sol, San Roque
Beds: 4 Baths: 3 M2: 270 Lot Size: 458 Area: San Roque Region: Andalucía
Beds: 4 Baths: 3 M2: 270 Lot Size: 458 Area: San Roque Region: Andalucía
Finca - Cortijo, San Roque, Costa del Sol.
4 Bedrooms, 3 Bathrooms, Built 270 m², Terrace 40 m², Garden/Plot 458 m².
Setting : Country, Close To Town.
Orientation : South.
Condition : Good.
Pool (...)
€1,350,000
TSEA5147149
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 5 Baths: 3 M2: 277 Lot Size: 1,440 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 3 M2: 277 Lot Size: 1,440 Area: Benalmadena Region: Andalucía
Nestled in an exceptional location that perfectly marries tranquil countryside living with the convenience of village life, this charming Andalusian-style villa is a true gem. Situated on a raised (...)
€3,150,000
TSEA5147011
- La Quinta, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 386 Lot Size: 765 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 386 Lot Size: 765 Area: Benahavis Region: Andalucía
Nestled in the prestigious La Quinta area of Benahavis, this stunning 303-square-meter villa (386 sqm including terraces) sits on an expansive 765-square-meter plot, offering an unparalleled blend of (...)
Current Featured Properties
€2,548,000
TSEA4300519
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 397 Lot Size: 833 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 397 Lot Size: 833 Area: Mijas and Mijas Costa Region: Andalucía
THE ULTIMATE LUXURY LIVING!!!
Experience the ultimate in luxury living with this latest development of three stunning, open plan villas located just steps from the sea. These spacious and bright (...)
€7,650,000
TSEA4570726
- Benahavís, Costa Del Sol, Benahavis
Beds: 7 Baths: 8 M2: 1,780 Lot Size: 2,500 Area: Benahavis Region: Andalucía
Beds: 7 Baths: 8 M2: 1,780 Lot Size: 2,500 Area: Benahavis Region: Andalucía
This luxury modern style 7-bedroom house for sale is set in Paraiso Alto, one of the most sought-after areas on the New Golden Mile, Benahavis, close to the golf courses, international schools, (...)
€885,000
TSEA5013214
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 142 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 142 Area: Fuengirola Region: Andalucía
Welcome to the residence, an exclusive retreat on the truly incomparable Costa del Sol. This groundbreaking project of villas with staggered construction on six levels not only symbolises (...)
