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 (42,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 (42,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 (42,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 61 - 80 of 2008
€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 (...)
€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 (...)
€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 : (...)
€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 (...)
€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 (...)
€550,000
TSEA5146912
- Ronda, Costa Del Sol, Ronda
Beds: 3 Baths: 2 M2: 229 Area: Ronda Region: Andalucía
Beds: 3 Baths: 2 M2: 229 Area: Ronda Region: Andalucía
✨ Charming country house with private pool and tourist license 10 minutes from Ronda ✨
We present a unique country house that combines nature, comfort, and versatility in a privileged setting. (...)
€770,000
TSEA5146741
- Pizarra, Costa Del Sol, Cartama
Beds: 11 Baths: 6 M2: 515 Area: Cartama Region: Andalucía
Beds: 11 Baths: 6 M2: 515 Area: Cartama Region: Andalucía
Exclusive estate with 5 independent homes in Pizarra – Property with valid AFO
Are you looking for a large family estate or a unique investment opportunity in the heart of the Guadalhorce (...)
€1,695,000
TSEA5146693
- Elviria, Costa Del Sol, Marbella East
Beds: 5 Baths: 4 M2: 259 Lot Size: 1,003 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 4 M2: 259 Lot Size: 1,003 Area: Marbella East Region: Andalucía
Charming villa with a rustic touch, reformed (2002) with very good construction quality. Located in a residential area of Elviria. Beautiful views, sea, golf and mountain. Air aconditioning (...)
€2,550,000
TSEA5146249
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 534 Lot Size: 1,700 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 534 Lot Size: 1,700 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular south facing five bedroom villa in El Chaparral, Mijas Costa. Set within an extensive private plot that offers total tranquillity and magnificent panoramic views of the coast and the (...)
€1,750,000
TSEA5146186
- Setenil de las Bodegas, Costa de la Luz
Beds: 6 Baths: 6 M2: 616 Lot Size: 5,101 Region: Andalucía
Beds: 6 Baths: 6 M2: 616 Lot Size: 5,101 Region: Andalucía
A Rare Blend of Heritage & Modern Innovation Experience a truly extraordinary property, a beautifully converted historic watermill set against the dramatic backdrop of rural Andalusia. Just 24 km (...)
Current Featured Properties
€2,250,000
TSEA4707427
- El Madroñal, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 255 Lot Size: 1,666 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 255 Lot Size: 1,666 Area: San Pedro Region: Andalucía
Welcome to your dream retreat! This magnificent 4 bedroom, 4 bathroom villa is located in the popular gated community of El Madroñal. Located at entrance number 1, making the villa easily accesible, (...)
€1,490,000
Control your home with your smart device!
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 371 Lot Size: 323 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 371 Lot Size: 323 Area: Benahavis Region: Andalucía
ULTIMATE IN DESIGNER LIVING IN BEAUTIFUL MARBELLA!!!
Villas in a unique project with an emphasis on design to meet the requirements of the most demanding client. Located on a privileged plot, the (...)
€7,975,000
TSEA4712791
- La Mairena, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 1,254 Lot Size: 49,832 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 1,254 Lot Size: 49,832 Area: Marbella East Region: Andalucía
ASTONISHING LUXURY VILLA WITH SEA VIEWS IN LA MAIRENA
Astonishing luxury villa nestled in a secluded oasis of tranquility, close to La Mairena, offering unparalleled privacy amidst unspoiled natural (...)
