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 (31,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 (31,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 (31,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 361 - 380 of 6631
€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 (...)
€660,000
TSEA5147296
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
In the prestigious Phase I of the Residential Complex "Ipanema, by Kronos Homes", located in the municipality of Mijas, lies this exclusive penthouse, which combines modern design, (...)
€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 (...)
€295,000
TSEA5147170
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 77 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: La Duquesa Region: Andalucía
For sale, South East facing middle floor apartment in an established gated community within Los Hidalgos area of La Duquesa, Manilva Costa del Sol, located just 5 minutes from the beach.
This (...)
€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 (...)
€480,000
TSEA5147146
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 102 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Marbella East Region: Andalucía
Master en-suite with full bathroom, dressing room, and direct access to the terrace through double-glazed sliding doors.
Second double bedroom with built-in wardrobe, access to the terrace, and (...)
€375,000
TSEA5147125
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 66 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 66 Area: Marbella Region: Andalucía
BEACHSIDE GROUND FLOOR APARTMENT – REFORM OPPORTUNITY IN MARBELLA DEL MAR
Fantastic opportunity in the sought-after Marbella del Mar complex, set directly on the beachfront and only 10 minutes' (...)
€649,000
TSEA5147071
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 103 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Estepona Region: Andalucía
Located in the prestigious Hacienda Señorio de Cifuentes, this stunning apartment offers the perfect balance between luxury, comfort, and nature. Surrounded by renowned golf courses and boasting (...)
€180,000
TSEA5147068
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 50 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Area: Mijas and Mijas Costa Region: Andalucía
Investment Opportunity Just 200 Meters from the Beach!
Beautiful renovated apartment for sale, ideal as a vacation rental or second home. Located in a quiet area with stunning sea views, this bright (...)
€470,000
TSEA5147062
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 104 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 104 Area: Marbella Region: Andalucía
Charming penthouse in the heart of Marbella, 400 metres from the city's best beaches, the Paseo Marítimo and a minute's walk from Marbella's Old Town.
This duplex penthouse consists of two very (...)
€5,950,000
TSEA5147056
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 221 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 221 Area: Marbella West Region: Andalucía
In the heart of Puerto Banús, within the prestigious residential complex Los Granados, stands this spectacular duplex penthouse, an exceptional property that redefines seafront luxury.
From its (...)
€110,000
TSEA5147050
- Manilva, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 44 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 44 Area: Manilva Region: Andalucía
Tourist Apartment for Sale in the PierVacanz Complex – Manilva (Málaga)
For Tourist Use Only – Not for Residential Living
Apartment for sale in the prestigious PierVacanz holiday complex, just (...)
€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 (...)
€875,000
TSEA5146996
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 210 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 210 Area: Benahavis Region: Andalucía
This elegant duplex, set in the prestigious La Quinta area of Benahavís, offers a rare blend of modern comfort and Mediterranean charm. Recently renovated and in excellent condition, the home spans (...)
€460,000
TSEA5146993
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Nestled in the heart of Marbella's prestigious Golden Mile, this elegant ground floor apartment offers the perfect combination of modern comfort and Mediterranean charm. Just five minutes from the (...)
€679,000
TSEA5146972
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 141 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 141 Area: Fuengirola Region: Andalucía
Discover a unique opportunity to live in one of Fuengirola's most sought-after residential complexes with this spacious 4-bedroom first-floor apartment, fully furnished and ready to move in. Its (...)
€397,000
TSEA5146948
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 136 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 136 Area: Estepona Region: Andalucía
Wonderful apartment in El Paraíso Barronal
Your new home awaits you in a privileged location, right on the beach, just a three-minute walk from the sea.
The apartment is located in a beautiful (...)
€850,000
TSEA5146921
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 146 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 146 Area: Marbella East Region: Andalucía
This magnificent ground floor apartment is located in the heart of Marbella's famous Golden Mile — one of the most prestigious and sought-after areas on the Costa del Sol. A unique blend of (...)
Current Featured Properties
€305,000
TSEA4707214
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
New development for sale in the center of Fuengirola just 200 m to the beach, historic center, near the Fuengirola Marina. There are 6 apartments with 2 and 3 bedrooms, with 2 bathrooms, terrace and (...)
€459,000
TSEA5058583
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 104 Lot Size: 43 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 104 Lot Size: 43 Area: Estepona Region: Andalucía
Imagine living surrounded by nature, in a setting designed for peace, comfort, and above all, a true passion for golf. This unique residential development features 1, 2, and 3-bedroom homes, located (...)
€1,250,000
TSEA4926508
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 119 Lot Size: 6 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 119 Lot Size: 6 Area: Marbella Region: Andalucía
The development epitomizes the zenith of contemporary life in Marbella, renowned for its serene ambiance and breathtaking panoramic vistas that stretch from the lush pine canopies to the shimmering (...)
