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 (63,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 (63,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 (63,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 81 - 100 of 2642
€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
€443,000
TSEA4027225
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
4 UNITS LEFT
DREAM AWAY LAZY EVENINGS BY LOOKING AT A STUNNING VIEW!!!
Off-plan development of contemporary semi-detached houses in Riviera del Sol, Mijas, with views over the Mediterranean. The 3 (...)
€1,990,000
TSEA4979719
- Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 504 Lot Size: 903 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 504 Lot Size: 903 Area: Marbella East Region: Andalucía
Villa Fantastica is a luxurious property located in the breathtaking surroundings of Marbella. The villa boasts 4 bedrooms, 4 bathrooms, and a built area of 504 square meters. Its exceptional German (...)
€3,295,000
TSEA4446508
- Manilva, Costa Del Sol, Manilva
Beds: 5 Baths: 7 M2: 825 Lot Size: 1,200 Area: Manilva Region: Andalucía
Beds: 5 Baths: 7 M2: 825 Lot Size: 1,200 Area: Manilva Region: Andalucía
INVEST IN LUXURY LIVING: PREMIER HOME AVAILABLE NOW IN MANILVA!!!
This stunning villa is situated in an enviable location above the beaches of Manilva & Sotogrande, offering breathtaking views (...)
