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 761 - 780 of 3420 €500,000
TSEA5079931
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
We offer for sale this fantastic brand new 2 bedroom penthouse in Oceana Gardens. The south west facing property consists of 2 bedrooms, the master bedroom with en-suite bathroom and access to the (...)
€1,290,000
TSEA5079925
- Rincón de la Victoria, Costa Del Sol East
Beds: 5 Baths: 4 M2: 603 Lot Size: 2,197 Region: Andalucía
Beds: 5 Baths: 4 M2: 603 Lot Size: 2,197 Region: Andalucía
Welcome to this magnificent villa, a true gem nestled in the most exclusive residential area of Rincón de la Victoria.
Located in the lower part of Cotomar, this property offers a privileged (...)
€340,000
TSEA5079898
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Top Floor Apartment, Estepona, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 10 m².
Setting : Commercial Area, Village, Close To Port, Close To Shops, Close To Sea, Close To (...)
€4,900,000
TSEA5079865
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 4 Baths: 6 M2: 562 Lot Size: 1,342 Area: Marbella Region: Andalucía
Beds: 4 Baths: 6 M2: 562 Lot Size: 1,342 Area: Marbella Region: Andalucía
Exquisite Andalusian-Style Family Villa in Prestigious Sierra Blanca, Marbella
Nestled in the heart of the exclusive gated community of Urbanización Marbella Sierra Blanca, this elegant (...)
€650,000
TSEA5079733
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 100 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Marbella East Region: Andalucía
Stylish Loft-Style Penthouse in Las Lomas del Marbella Club
This unique loft-style penthouse is located in the highly sought-after Las Lomas del Marbella Club, one of Marbella's most prestigious (...)
€680,000
TSEA5079727
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 210 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 210 Area: San Pedro Region: Andalucía
Located on the front line of the Guadalmina Alta golf course, in a quiet and sought-after area, this characterful duplex penthouse offers both space and privacy. It is part of a small, peaceful (...)
€4,595,000
TSEA5079424
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 476 Lot Size: 1,164 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 476 Lot Size: 1,164 Area: Marbella West Region: Andalucía
Set in a peaceful and prestigious location, Villa Provence is a remarkable 5-bedroom residence that masterfully blends the romantic charm of Provençal French architecture with the clean lines and (...)
€595,000
TSEA5079418
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 150 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 150 Area: Estepona Region: Andalucía
This exceptional penthouse, offered exclusively through sole agency, is situated in the sought-after Playa del Angel area of Estepona Town, Malaga. Boasting a prime front line beach position, the (...)
€525,000
TSEA5079235
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 133 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Benahavis Region: Andalucía
Discover the pinnacle of sophisticated living in the tranquil haven of Las Lomas del Conde Luque, Benahavis. This exquisite 2-bedroom, 2-bathroom penthouse, epitomizes the essence of luxury and (...)
€795,000
TSEA5079190
- Limonar, Costa Del Sol
Beds: 3 Baths: 1 M2: 92 Region: Andalucía
Beds: 3 Baths: 1 M2: 92 Region: Andalucía
Penthouse with magnificent terrace in one of the most exclusive and sought after neighbourhoods in the city of Malaga. Located in El Limonar, a quiet and residential area, but at the same time next (...)
€1,250,000
TSEA5079163
- El Rosario, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 275 Lot Size: 1,091 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 275 Lot Size: 1,091 Area: Marbella East Region: Andalucía
Spacious Villa with Private Pool in a Privileged Location in El Rosario – Your Ideal Lifestyle Awaits!
Situated on a flat plot in the quiet and secure residential area of El Rosario, Marbella, (...)
€4,000,000
TSEA5078890
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 4 Baths: 5 M2: 436 Lot Size: 2,707 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 5 M2: 436 Lot Size: 2,707 Area: Sotogrande Region: Andalucía
New Development: Prices from 4,000,000 € to 4,000,000 €. [Beds: 4 - 4] [Baths: 5 - 5] [Built size: 436.00 m2 - 436.00 m2]
Conceived for those seeking more than just a residence, this villa is a (...)
€575,000
TSEA5078869
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 1 M2: 85 Lot Size: 15,780 Area: Coin Region: Andalucía
Beds: 3 Baths: 1 M2: 85 Lot Size: 15,780 Area: Coin Region: Andalucía
Finca with house, swimming pool and avocado production in the idyllic area of Barranco Blanco with AFO licence.
We present you this exclusive rustic finca located in Barranco Blanco, one of the most (...)
€636,300
TSEA5078656
- El Padron, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 430 Lot Size: 4,919 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 430 Lot Size: 4,919 Area: Estepona Region: Andalucía
The villa is located just 1.9 km from the beach, making it ideal for enjoying the coastal setting. Activities in the surrounding area include hiking, beach walks, and water sports. The area also has (...)
€1,495,000
TSEA5078626
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 339 Lot Size: 1,050 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 339 Lot Size: 1,050 Area: Benahavis Region: Andalucía
Located in the prestigious enclave of El Paraiso Alto, Benahavis, this exquisite villa offers an unparalleled lifestyle in the heart of Malaga's Costa del Sol. This remarkable property, classified as (...)
€1,375,000
TSEA5078377
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 330 Lot Size: 819 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 330 Lot Size: 819 Area: Mijas and Mijas Costa Region: Andalucía
Villa for sale in , Mijas Costa with 4 bedrooms, 4 bathrooms and 1 toilet, with private swimming pool, carport garage (2 parking spaces) and private garden. Regarding property dimensions, it has 330 (...)
€850,000
TSEA5078308
- La Capellania, Costa Del Sol, Fuengirola
Beds: 4 Baths: 4 M2: 195 Lot Size: 435 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 4 M2: 195 Lot Size: 435 Area: Fuengirola Region: Andalucía
This is a lovely family villa in a very desirable area, La Capellania, Benalmadena, located on a short Cul De Sac in a very quiet and secure residential area with stunning sea and mountain views. The (...)
€737,000
TSEA5078263
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 184 Lot Size: 69 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 184 Lot Size: 69 Area: Casares Region: Andalucía
Discover this exclusive new development consisting of 99 apartments and penthouses, each with 2 or 3 bedrooms, designed to help you find where you truly belong. Situated in the prime location of (...)
€349,000
TSEA5078227
- Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 2 M2: 188 Lot Size: 3,429 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 2 M2: 188 Lot Size: 3,429 Area: Nerja and Malaga East Region: Andalucía
Nestled in the rolling hills of Andalusia, between the picturesque white villages of Riogordo and Comares, this charming property offers peace, privacy, and natural beauty, combined with modern (...)
€1,185,000
TSEA5078149
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 5 M2: 358 Lot Size: 640 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 5 M2: 358 Lot Size: 640 Area: Mijas and Mijas Costa Region: Andalucía
Spacious Family Villa with Sea Views, Private Pool & Prime Location near the Beach ! Walk to Bikini Beach by the Castle Fuengirola .
Are you looking for a family home that blends space, privacy, (...)
Current Featured Properties
€1,300,000
TSEA4639768
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
€670,000
TSEA4686511
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 119 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 119 Area: Casares Region: Andalucía
Located in the area of Doña Julia Golf, this new development emerges as an oasis of elegance and tranquility on the Costa del Sol, much more than a simple residential area. A refuge for lovers (...)
€1,500,000
TSEA4563568
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 581 Lot Size: 1,420 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 581 Lot Size: 1,420 Area: Mijas and Mijas Costa Region: Andalucía
Situated on a plot of 1,420 m², this single-family home offers unparalleled panoramic views of the sea and the mountains. Surrounded by a landscaped garden area, the property has large terraces at (...)
