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 101 - 120 of 2008
€2,390,000
TSEA5144125
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 296 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 296 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular villa that perfectly blends Mediterranean style with contemporary design, combining traditional charm with modern comfort and top-quality finishes. Located in the prestigious Buena Vista (...)
€985,000
TSEA5144044
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 6 Baths: 4 M2: 218 Area: Fuengirola Region: Andalucía
Beds: 6 Baths: 4 M2: 218 Area: Fuengirola Region: Andalucía
Corner villa in Puebla Lucía, the most exclusive residential area in Fuengirola
In the heart of Fuengirola, within the prestigious and gated community of Puebla Lucía, lies this bright (...)
€850,000
TSEA5143966
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 3 M2: 132 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 3 M2: 132 Area: Nerja and Malaga East Region: Andalucía
Cartujano Villas – Luxury and Privacy Just Steps from Burriana Beach
Discover Cartujano Villas, an exclusive collection of only four detached villas in the heart of Nerja, just a short walk from (...)
€995,000
TSEA5143927
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 3 M2: 580 Lot Size: 701 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 3 M2: 580 Lot Size: 701 Area: Nerja and Malaga East Region: Andalucía
This historic property is a large renovated old Mill, previously a working flour mill for the Larios family until approximately 60 years ago named Molino San Jose. The villa has three bedrooms, three (...)
€1,695,000
TSEA5143909
- La Mairena, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 254 Lot Size: 2,750 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 254 Lot Size: 2,750 Area: Marbella East Region: Andalucía
Spacious Family Villa with Panoramic Views in La Mairena
This beautifully presented villa in La Mairena was originally built in 2009 and tastefully renovated in 2021, bringing it up to modern (...)
€1,869,000
TSEA5143879
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M2: 210 Area: Casares Region: Andalucía
Beds: 4 Baths: 4 M2: 210 Area: Casares Region: Andalucía
Luxury villa with unrivalled Mediterranean views – Camarate del Golf, Casares Costa
In the privileged setting of Camarate del Golf, one of the most exclusive residential areas of Casares Costa, (...)
€685,000
TSEA5143825
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 5 M2: 287 Lot Size: 630 Area: Coin Region: Andalucía
Beds: 4 Baths: 5 M2: 287 Lot Size: 630 Area: Coin Region: Andalucía
STUNNING FOUR BEDROOM, FIVE BATHROOM VILLA
A must-see, substantially built and deceptively spacious, four-bedroom detached villa with four en-suite bathrooms, located within an exclusive and (...)
€1,395,000
TSEA5143783
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 195 Lot Size: 420 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 195 Lot Size: 420 Area: San Pedro Region: Andalucía
Discover this spectacular modern design villa for sale! Located on a 420 m² plot and with 195 m² of usable area, this property offers an exclusive and sophisticated lifestyle. Upon entering, you'll (...)
€3,685,000
TSEA5143681
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 550 Lot Size: 1,805 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 550 Lot Size: 1,805 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 3,685,000 € to 3,685,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 550.00 m2 - 550.00 m2]
I am pleased to present a unique opportunity: the sale of an off-plan (...)
€1,450,000
TSEA5143603
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 335 Lot Size: 956 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 335 Lot Size: 956 Area: Estepona Region: Andalucía
Step into a sunlit, character-filled family home where timeless Andalusian charm meets modern comfort. The ample sized open-plan kitchen, living, and dining area is flooded with light from (...)
€3,200,000
TSEA5143342
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 718 Lot Size: 2,000 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 718 Lot Size: 2,000 Area: Benalmadena Region: Andalucía
New Development: Prices from 3,200,000 € to 3,200,000 €. [Beds: 4 - 4] [Baths: 5 - 5] [Built size: 718.00 m2 - 718.00 m2]
The villa is located in a privileged setting, within the exclusive (...)
€1,995,000
TSEA5143321
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 336 Lot Size: 1,028 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 336 Lot Size: 1,028 Area: Marbella West Region: Andalucía
Nestled in a quiet cul-de-sac and within walking distance of shops and local services, this villa offers an ideal setting for relaxed family living in Nueva Andalucía. Recently renovated with taste (...)
€795,000
TSEA5143135
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 191 Lot Size: 773 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 191 Lot Size: 773 Area: Estepona Region: Andalucía
Charming Andalusian Villa in Arena Beach, Estepona
This beautifully renovated independent villa combines traditional Andalusian charm with a fresh, contemporary style, creating the perfect home for (...)
€1,550,000
TSEA5142997
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 8 M2: 277 Lot Size: 2,484 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 8 M2: 277 Lot Size: 2,484 Area: Mijas and Mijas Costa Region: Andalucía
UNIQUE OPPORTUNITY JUST OUTSIDE MIJAS PUEBLO!
This breathtaking group of properties don´t come onto the market too often. If you are looking to have a place where all of your loved ones can come (...)
€375,000
TSEA5142817
- Costalita, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 83 Lot Size: 40 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Lot Size: 40 Area: Estepona Region: Andalucía
Quaint 2 bedroom attached single level bungalow.
The home is located beachside of the A7 just steps away from Saladillo beach in Costalita.
The house features an open plan lounge, dining, kitchen and (...)
€850,000
TSEA5142802
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 5 Baths: 4 M2: 317 Lot Size: 600 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 4 M2: 317 Lot Size: 600 Area: Benalmadena Region: Andalucía
Discover this detached villa in one of the most exclusive areas of Benalmádena Costa, perfectly positioned for its privileged location and exceptional potential.
Set on a 600 m² plot, the villa (...)
€1,275,000
TSEA5142778
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 219 Lot Size: 930 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 219 Lot Size: 930 Area: Fuengirola Region: Andalucía
Key-Ready 3-Bedroom Villa with Panoramic Views in Torreblanca, Fuengirola!
Step into your perfect Mediterranean retreat with this stunning, modern and key-ready villa in the lovely area of (...)
€1,790,000
TSEA5142733
- Atalaya, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 300 Lot Size: 471 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 300 Lot Size: 471 Area: Estepona Region: Andalucía
Off-Plan Modern Golf Villa – El Campanario
Seize the chance to own a brand-new frontline golf villa with direct views over El Campanario's fairways. This off-plan contemporary residence combines (...)
€975,000
TSEA5141941
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 321 Lot Size: 1,324 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 321 Lot Size: 1,324 Area: Marbella East Region: Andalucía
Fantastic opportunity; a four bedroom, south west facing villa in Elviria, close to all amenities, only a ten minute drive from Marbella Town, Puerto Banús, and close to the beach. The villa is (...)
€450,000
TSEA5141758
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 246 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 246 Area: Mijas and Mijas Costa Region: Andalucía
Discover the perfect balance between country charm and modern comfort in this registered home set on a generous 900 m² rustic plot. The main floor offers 4 bright bedrooms, including an impressive (...)
Current Featured Properties
€1,779,000
TSEA4938817
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 5 M2: 222 Area: Estepona Region: Andalucía
Beds: 4 Baths: 5 M2: 222 Area: Estepona Region: Andalucía
LAST UNITS ACT NOW! We offer you an exclusive development composed of 8 single family homes with 4 bedrooms, distributed over two floors, with large terraces, garden and private pool. Located in a (...)
€1,250,000
TSEA5115490
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
NEW DEVELOPMENT – Elegance and Exclusivity on the Costa del Sol!
Discover this new luxury project, a prestigious complex of 14 independent villas located in an exceptional setting in Estepona, (...)
€1,380,000
TSEA4670587
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 149 Lot Size: 1,016 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 149 Lot Size: 1,016 Area: Mijas and Mijas Costa Region: Andalucía
Itś a energy-saving house in one level that combines an energy-efficient construction with materials of the highest quality and smart use of the surfaces. This smart, cost-effective villa with solar (...)
