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 41 - 60 of 2008
€10,900,000
TSEA5153119
- Aloha, Costa Del Sol, Marbella West
Beds: 6 Baths: 7 M2: 702 Lot Size: 2,349 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 7 M2: 702 Lot Size: 2,349 Area: Marbella West Region: Andalucía
Aloha 40 is a true retreat set in the exclusive Aloha neighborhood at the heart of Marbella's Golf Valley. This impressive residence is located within a secure gated community and enjoys a privileged (...)
€5,900,000
TSEA5153068
- Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 5 M2: 429 Lot Size: 1,250 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 5 M2: 429 Lot Size: 1,250 Area: Marbella East Region: Andalucía
Marbella – Exceptional Contemporary Villa, Sold Furnished, in the Exclusive Rio Real Area, Next to the Golf
This stunning villa, fully renovated in 2023 with the finest materials, is south-facing (...)
€1,200,000
TSEA5152990
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 4 Baths: 3 M2: 413 Lot Size: 1,167 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 3 M2: 413 Lot Size: 1,167 Area: Sotogrande Region: Andalucía
Elegant Villa in Sotogrande Alto with Mediterranean Charm and Open Views
Located in one of the most peaceful and established areas of Sotogrande Alto, this villa combines traditional Mediterranean (...)
€1,390,000
TSEA5152159
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 346 Lot Size: 534 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 346 Lot Size: 534 Area: Marbella West Region: Andalucía
Modern beautiful newly renovated 3 floor villa located in the heart of Nueva Andalucia very close to famous padelclub Real Club Padel.
The villa has a private pool beautiful garden and parking. (...)
€2,195,000
TSEA5152036
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 382 Lot Size: 609 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 382 Lot Size: 609 Area: San Pedro Region: Andalucía
Welcome to this charming beachside villa with private pool in San Pedro!
Just 300 meters from the golden sands of the Mediterranean, this stunning 4-bedroom villa offers the perfect blend of coastal (...)
€595,000
TSEA5152030
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 6 Baths: 4 M2: 418 Lot Size: 4,905 Area: Alhaurin el Grande Region: Andalucía
Beds: 6 Baths: 4 M2: 418 Lot Size: 4,905 Area: Alhaurin el Grande Region: Andalucía
Exclusively with us! Attention investors and large families! This could be your opportunity! This is a very large country house with a built area of 368m2, a 50m2 pool, and a 4905m2 plot (...)
€615,000
TSEA5152024
- El Campamento, Costa de la Luz
Beds: 4 Baths: 3 M2: 276 Lot Size: 140 Region: Andalucía
Beds: 4 Baths: 3 M2: 276 Lot Size: 140 Region: Andalucía
Charming Renovated House with Private Pool and Stunning Gibraltar Views in Puente Mayorga - Campamento, San Roque!
Discover this delightful south-west facing home, perfectly positioned in the serene (...)
€2,500,000
TSEA5151808
- Cancelada, Costa Del Sol, Estepona
Beds: 5 Baths: 4 M2: 417 Lot Size: 880 Area: Estepona Region: Andalucía
Beds: 5 Baths: 4 M2: 417 Lot Size: 880 Area: Estepona Region: Andalucía
Contemporary villa with great sea views and south facing, with large windows so all rooms are light and airy. The villa is in the municipality of Estepona, set between the mountains and the sea.
The (...)
€3,100,000
TSEA5151661
- Cancelada, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 400 Lot Size: 900 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 400 Lot Size: 900 Area: Estepona Region: Andalucía
Luxury Villa in Cancelada – Costa del Sol
Exclusive detached villa, newly built, located in one of the most sought-after areas of the Costa del Sol. With a contemporary design and top-quality (...)
€1,350,000
TSEA5151160
- Marbesa, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 295 Lot Size: 630 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 295 Lot Size: 630 Area: Marbella East Region: Andalucía
This fully renovated villa is located in the sought-after residential area of Marbesa, Marbella East. Offering both privacy and convenience, the property is just minutes away from the beach, Marbella (...)
€1,495,000
TSEA5150923
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 4 M2: 292 Lot Size: 432 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 4 M2: 292 Lot Size: 432 Area: Marbella West Region: Andalucía
Rare Investment Opportunity – Nueva Andalucía Luxury Villa
A bargain with panoramic views, 5 min from Puerto Banús
This independent villa is a unique opportunity in Nueva Andalucía, one of (...)
€495,000
TSEA5150911
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
This beautiful, fully exterior apartment stands out for its excellent location and natural brightness throughout. Located in a peaceful residential area of Marbella, it is just 400 meters from the (...)
€380,000
TSEA5150857
- Arriate, Costa Del Sol, Ronda
Beds: 6 Baths: 3 M2: 220 Lot Size: 594 Area: Ronda Region: Andalucía
Beds: 6 Baths: 3 M2: 220 Lot Size: 594 Area: Ronda Region: Andalucía
-Newly built property with 3 apartments in Arriate, ready to move into and with a valid tourist license.
In the quiet family development of Los Arroyos de Arriate, this unique, recently built (...)
€4,999,500
TSEA5150824
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 6 M2: 485 Lot Size: 1,065 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 6 M2: 485 Lot Size: 1,065 Area: Marbella West Region: Andalucía
HIGHLIGHTS
Located in the prestigious Golf Valley of Nueva Andalucía, Centauro 15 is an exceptional villa that blends contemporary architecture with Balinese boho inspiration and lush tropical (...)
€4,975,000
TSEA5150767
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 8 M2: 475 Lot Size: 815 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 8 M2: 475 Lot Size: 815 Area: Marbella West Region: Andalucía
A Refined Retreat in Aloha / Las Brisas, Marbella
Welcome to a beautifully renovated luxury villa located in the prestigious Aloha / Las Brisas area of Marbella. This elegant home blends timeless (...)
€1,750,000
TSEA5150701
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 5 M2: 403 Lot Size: 1,250 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 5 M2: 403 Lot Size: 1,250 Area: Mijas and Mijas Costa Region: Andalucía
This large villa (400 m2) is located about 800 meters from the casino and beach, next to the Torrequebrada golf course (Benalmádena Costa).
On the main floor you will find a large living room with (...)
€495,000
TSEA5150500
- El Gastor, Costa de la Luz
Beds: 3 Baths: 2 M2: 225 Region: Andalucía
Beds: 3 Baths: 2 M2: 225 Region: Andalucía
Rustic Estate Facing the Zahara de la Sierra Reservoir – Ready to Move In
Overview
Experience Andalusian charm and absolute tranquility in this exclusive rustic estate, surrounded by nature and (...)
€4,200,000
TSEA5150443
- La Mairena, Costa Del Sol, Marbella East
Beds: 5 Baths: 6 M2: 503 Lot Size: 1,529 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 6 M2: 503 Lot Size: 1,529 Area: Marbella East Region: Andalucía
Exceptional Villa Nestled in the Hills of La Mairena
This unique three-level villa has been thoughtfully designed to embrace its privileged location and breathtaking scenery. From the moment you (...)
€222,900
TSEA5150437
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
**64 m² Studio Apartment for Sale – Riviera del Sol, Costa del Sol (Spain)**
This attractive ground floor studio is located in a gated and secure community, just 400 meters from the beach, (...)
€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 (...)
Current Featured Properties
€595,000
TSEA4927306
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 150 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 150 Area: Benahavis Region: Andalucía
ABSOLUTELY FABULOUS LA HEREDIA HOUSE RECENTLY REDUCED IN PRICE.
This stunning, detached, stand-alone house is one of the few original homes in the charming and picturesque village of La Heredia, (...)
€1,645,000
TSEA4719550
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M2: 418 Lot Size: 10,000 Area: Casares Region: Andalucía
Beds: 4 Baths: 4 M2: 418 Lot Size: 10,000 Area: Casares Region: Andalucía
STUNNING VILLA IN CASARES WITH BREATHTAKING VIEWS.
This magnificent villa is located in the beautiful landscape of Casares, offering a perfect blend of elegance and modern luxury. Set on a spacious (...)
€2,400,000
TSEA3878038
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 337 Lot Size: 70 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 337 Lot Size: 70 Area: Benahavis Region: Andalucía
MODULAR VILLAS IN AN UPSCALE COUNTRY CLUB RESORT!!!
A gated and secure community of villas with club house, spa and gym with verdant Mediterranean gardens and amazing panoramic sea views. located in (...)
