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 (41,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 (41,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 (41,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 641 - 660 of 3420 €1,349,000
TSEA5107366
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 310 Lot Size: 801 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 310 Lot Size: 801 Area: Mijas and Mijas Costa Region: Andalucía
NEW TO THE MARKET. DELIGHTFULL DETATCHED VILLA IN CALAHONDA. € 1,349,000.
THIS GATED PROPERTY HAS A LARGE CARPOOL LEVEL WITH THE ROAD AS WELL AS PLENTY OF SPACE FOR PARKING INSIDE THE PROPERTY (...)
€479,000
TSEA5107348
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
SPACIOUS DUPLEX APARTMENT IN PRIME CALAHONDA LOCATION – WALK TO EVERYTHING
This bright and well-maintained apartment offers an unbeatable location in the heart of Calahonda, just 10-15 minutes' (...)
€899,000
TSEA5107300
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 5 Baths: 3 M2: 270 Lot Size: 242 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 3 M2: 270 Lot Size: 242 Area: Benalmadena Region: Andalucía
Imagine a life where the golden sands and vibrant atmosphere of Puerto Marina are just a leisurely 2-minute stroll from your doorstep.
This stunning independent villa offers an unparalleled location (...)
€950,000
TSEA5107222
- El Candado, Costa Del Sol
Beds: 7 Baths: 3 M2: 479 Lot Size: 723 Region: Andalucía
Beds: 7 Baths: 3 M2: 479 Lot Size: 723 Region: Andalucía
I'm offering you a large villa with high ceilings, a ground floor, a basement, and a large garage for several vehicles. Located on a 723 m2 plot (according to land registry), of which 479 m2 are (...)
€320,000
TSEA5107129
- Los Pacos, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 72 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 72 Area: Mijas and Mijas Costa Region: Andalucía
Perfect renovation project in a prime location in Los Pacos!
This top-floor apartment offers an unbeatable location and incredible potential. It features two spacious bedrooms and a large, bright (...)
€645,000
TSEA5107057
- Valle del Sol, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 166 Lot Size: 1,150 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 166 Lot Size: 1,150 Area: Estepona Region: Andalucía
Located in the area of Valle del Sol, this rustic Spanish villa offers a peaceful retreat with mountain views. Featuring 3 spacious double bedrooms and 2 bathrooms, the villa showcases beamed (...)
€199,999
TSEA5106985
- Jimena de la Frontera, Costa de la Luz
Beds: 3 Baths: 1 M2: 110 Region: Andalucía
Beds: 3 Baths: 1 M2: 110 Region: Andalucía
Charming 3-Bedroom Detached Bungalow with Private Garden – Cádiz
Nestled in a peaceful residential area of Cádiz, this delightful 3-bedroom detached bungalow offers single-level living with (...)
€1,000,000
TSEA5106979
- La Capellania, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 330 Lot Size: 1,900 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 330 Lot Size: 1,900 Area: Fuengirola Region: Andalucía
Exclusive Detached Villa with 330 m² Built Area (as per Cadastre), of which 177 m² correspond to the main residence, 89 m² to other uses, and 64 m² to sports/pool area.
Distributed on a single (...)
€699,000
TSEA5106952
- Nagüeles, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 160 Lot Size: 400 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 160 Lot Size: 400 Area: Marbella Region: Andalucía
Charming Storybook Villa – Just Minutes from Puerto Banús
Discover an incredible opportunity to own a private villa brimming with charm and character, perfectly located only 5–7 minutes from (...)
€3,500,000
TSEA5106826
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 6 M2: 646 Lot Size: 2,246 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 6 M2: 646 Lot Size: 2,246 Area: Marbella West Region: Andalucía
Perfectly positioned between the renowned Los Naranjos and Las Brisas golf courses, this timeless Andalusian-style villa commands captivating panoramic views of the iconic La Concha Mountain. Nestled (...)
€495,000
TSEA5106811
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 80 Lot Size: 193 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 80 Lot Size: 193 Area: Mijas and Mijas Costa Region: Andalucía
Your Dream Spanish Retreat Awaits – Just Steps from the Beach in Calahonda!
Imagine waking up to the gentle sea breeze, strolling to golden sands for a morning swim, and enjoying lazy (...)
€924,000
TSEA5106775
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 115 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 115 Area: Estepona Region: Andalucía
Discover, an incredible new development in one of Estepona's most exclusive areas. This private residential complex features apartments, including flats, penthouses, and ground-floor units with 2, 3, (...)
€480,000
TSEA5106754
- El Presidente, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 135 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Estepona Region: Andalucía
Beachside Apartment In Prime Location
Located in the highly sought-after area of Atalaya Isdabe, within the prestigious El Presidente urbanization, this beautifully maintained apartment offers the (...)
€2,100,000
TSEA5106727
- Río Real, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 356 Lot Size: 99 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 356 Lot Size: 99 Area: Marbella East Region: Andalucía
Immerse Yourself in a Unique Lifestyle on the Costa del Sol.
Discover the exceptional lifestyle offered by this elegant semi-detached villa, located in one of Marbella's most prestigious (...)
€595,000
TSEA5106583
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 144 Lot Size: 6,300 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 144 Lot Size: 6,300 Area: Alhaurin el Grande Region: Andalucía
This beautiful refurbised country house is located in an idyllic setting surrounded by nature with fabulous views.
With easy access this property offers the perfect combination of Lotts of privacy (...)
€1,395,000
TSEA5106574
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 257 Lot Size: 2,626 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 257 Lot Size: 2,626 Area: Estepona Region: Andalucía
A rare gem on the New Golden Mile! This beautifully renovated finca combines the charm of country living with the convenience of being just a short stroll from the beach. Featuring 3 spacious (...)
€420,000
TSEA5106427
- Cómpeta, Costa Del Sol East
Beds: 3 Baths: 2 M2: 187 Lot Size: 4,200 Region: Andalucía
Beds: 3 Baths: 2 M2: 187 Lot Size: 4,200 Region: Andalucía
Beautiful Villa with Panoramic Views and Private Pool in the Countryside of Cómpeta
Discover this beautiful villa, set in the peaceful countryside of Cómpeta—one of the most sought-after areas (...)
€349,000
TSEA5106415
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Sun, Golf & Sea Views – Dream Penthouse in Calanova Golf
This beautifully maintained penthouse apartment is located in the sought-after area of Calanova Golf, just minutes from the sandy (...)
€2,400,000
TSEA5106406
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 328 Lot Size: 2,621 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 328 Lot Size: 2,621 Area: Marbella East Region: Andalucía
Contemporary villa with endless views in La Mairena.
Modern elegance, complete privacy, and breathtaking open panoramas. Set in one of the most peaceful and natural areas of La Mairena.
A newly (...)
€795,000
TSEA5106403
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 90 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Fuengirola Region: Andalucía
KEY READY CORNER APARTMENT WITH LARGE PRIVATE TERRACE AND SEA VIEWS 35000 EURO FURNITURE PACKAGE INCLUDED
A RARE OPPORTUNITY TO SECURE A COMPLETED DESIGNER FURNISHED HOME IN EXCLUSIVE HIGUERON READY (...)
Current Featured Properties
€6,900,000
EMPTY
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 890 Lot Size: 2,872 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 890 Lot Size: 2,872 Area: Marbella West Region: Andalucía
URB. LA CERQUILLA, NUEVA ANDALUCIA, MARBELLA
A great, recently renovated villa with a perfect fusion between contemporary design and Andalusian style. Located in the sought after residential area of (...)
€1,750,000
Deatched Villa Malaga
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 186 Lot Size: 535 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 186 Lot Size: 535 Area: Malaga Region: Andalucía
A unique development of 10 villas The development offers different housing solutions that adapt to the needs of each client, choose the layout from a wide variety of options. A modern and functional (...)
€1,400,000
TSEA4341787
- Las Chapas, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 187 Lot Size: 182 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 187 Lot Size: 182 Area: Marbella East Region: Andalucía
LIVING IN PARADISE!!!
Your dream come true. Set among rolling hills on the outskirts of Marbella and caressed by sea breezes and infinite sky. A total of 104 three and four-bedroom homes will exceed (...)
