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,39,40,41,162,163)
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,39,40,41,162,163)
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,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 1981 - 2000 of 5896 €490,000
TSEA5066830
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2 Baths: 2 M2: 127 Area: Algeciras Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Algeciras Region: Andalucía
Middle Floor Apartment, La Alcaidesa, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 127 m², Terrace 20 m².
Setting : Frontline Golf, Beachside, Close To Golf, Close To Shops, Close To Sea, Close (...)
€895,000
TSEA5066818
- Cártama, Costa Del Sol, Cartama
Beds: 4 Baths: 4 M2: 483 Lot Size: 9,214 Area: Cartama Region: Andalucía
Beds: 4 Baths: 4 M2: 483 Lot Size: 9,214 Area: Cartama Region: Andalucía
A Sanctuary of Serenity in the Heart of Nature
Upon arrival at this estate, time seems to stand still. The house, surrounded by vibrant gardens and fruit trees, instantly conveys a sense of peace, (...)
€445,000
TSEA5066815
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 108 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 108 m².
Setting : Town, Village, Close To Port, Close To Shops, Close To Schools, Urbanisation.
Orientation : South (...)
€1,150,000
TSEA5066809
- Centro Histórico, Costa Del Sol
Beds: 3 Baths: 3 M2: 172 Region: Andalucía
Beds: 3 Baths: 3 M2: 172 Region: Andalucía
Exclusive Renovated Apartment in the Heart of Málaga
Located just steps away from the iconic Calle Marqués de Larios, this spectacular 170 m² apartment perfectly combines elegance, comfort, and (...)
€248,000
TSEA5066800
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 91 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 91 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic apartment located in Mijas Golf.
Discover this charming apartment located in the exclusive residential area in the heart of the Mijas Golf Course.
Ideal for golf lovers – just a few steps (...)
€298,000
TSEA5066785
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 2 Baths: 1 M2: 82 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 1 M2: 82 Area: Sotogrande Region: Andalucía
Refurbished Apartment in Prime Village Location
Modern 2-bedroom apartment just a 1-minute walk to restaurants, bars, shops, and a supermarket. The bus station is only meters away, and Sotogrande (...)
€1,500,000
TSEA5066653
- Málaga Centro, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 159 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 159 Area: Malaga Region: Andalucía
Spectacular apartment in an unbeatable location, set on the beachfront promenade of Pablo Ruiz Picasso. Perched on the 12th floor, the residence boasts breathtaking views of the Mediterranean (...)
€3,350,000
TSEA5066647
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 879 Lot Size: 1,786 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 879 Lot Size: 1,786 Area: Sotogrande Region: Andalucía
Tucked away on a quiet cul-de-sac in Sotogrande's tranquil F Zone, this striking new villa is currently under construction and set for completion in May 2025. Designed with modern living in mind, the (...)
€545,000
TSEA5066359
- Málaga Centro, Costa Del Sol, Malaga
Beds: 5 Baths: 2 M2: 145 Area: Malaga Region: Andalucía
Beds: 5 Baths: 2 M2: 145 Area: Malaga Region: Andalucía
Magnificent corner flat situated in a prime area of Malaga just 10 minutes' walk from Plaza de la Merced and the historic centre. This elegant luminous home boasts two open-air terraces and one (...)
€3,600,000
TSEA5066233
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 9 Baths: 10 M2: 1,084 Lot Size: 3,557 Area: Sotogrande Region: Andalucía
Beds: 9 Baths: 10 M2: 1,084 Lot Size: 3,557 Area: Sotogrande Region: Andalucía
Substantial family villa in Sotogrande Alto offering golf views over the San Roque Golf Course towards the Mediterranean Sea.
Situated in a quiet location, this southeast-.facing villa comprises, (...)
€925,000
TSEA5066077
- Málaga Centro, Costa Del Sol, Malaga
Beds: 6 Baths: 3 M2: 190 Area: Malaga Region: Andalucía
Beds: 6 Baths: 3 M2: 190 Area: Malaga Region: Andalucía
Perched on the eighth floor of an 11-storey building, this remarkable 6-bedroom flat offers an exceptional living experience in the coveted neighborhood of La Malagueta. With magnificent sweeping (...)
€6,000,000
TSEA5066002
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 930 Lot Size: 2,000 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 930 Lot Size: 2,000 Area: Sotogrande Region: Andalucía
Contemporary five-bedroom villa designed to offer next-level luxury situated in the heart of Sotogrande. Imagination and expertise come together in this property. Designed by celebrated by a renowned (...)
€14,900,000
TSEA5065969
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 250 Lot Size: 500 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 250 Lot Size: 500 Area: Marbella East Region: Andalucía
Contemporary 2nd line beach villa in Puente Romano, Golden Mile-Marbella. Built on 2 levels, this property comprises a good size open plan living/ dining room with (...)
€50,000,000
TSEA5065927
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 9 Baths: 8 M2: 1,590 Lot Size: 4,893 Area: Marbella East Region: Andalucía
Beds: 9 Baths: 8 M2: 1,590 Lot Size: 4,893 Area: Marbella East Region: Andalucía
A very spacious & unique villa situated in an unrivalled front line beach position in one of Spain's most privileged location, Marbella's exclusive Golden Mile. The villa is set on a double plot (...)
€1,125,000
TSEA5065738
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 309 Lot Size: 1,925 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 309 Lot Size: 1,925 Area: Sotogrande Region: Andalucía
Charming Andalusian-style villa in Central Sotogrande, a tranquil residential area situated only 10 minutes' drive to The Royal Golf Club of Sotogrande, the Sotogrande marina and the beach.
The (...)
€480,000
TSEA5065519
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
This apartment stands out for its spaciousness (more than 100 m² built), its 3 bedrooms, 2 bathrooms, independent kitchen and a spacious living-dining room. It is perfectly oriented to take (...)
€530,000
TSEA5065441
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 147 Lot Size: 2,500 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 147 Lot Size: 2,500 Area: Mijas and Mijas Costa Region: Andalucía
Are you looking for peace and quiet without giving up proximity to the city and the coast? This charming detached house in El Romeral is a unique opportunity that combines the best of both worlds: (...)
€2,150,000
TSEA5065318
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 350 Lot Size: 550 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 350 Lot Size: 550 Area: Marbella West Region: Andalucía
Discover this beautifully renovated and uniquely designed villa with a private guest apartment, lift, and extraordinary panoramic sea and city views, situated in the heart of Nueva Andalucía, (...)
€1,200,000
TSEA5065273
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 255 Lot Size: 495 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 255 Lot Size: 495 Area: Estepona Region: Andalucía
This never-lived-in, newly completed 4-bedroom villa is a stunning example of contemporary luxury living, set within an exclusive development of just eight designer homes. Ideally positioned (...)
€749,000
TSEA5065222
- Algarrobo, Costa Del Sol East
Beds: 3 Baths: 2 M2: 283 Lot Size: 8,200 Region: Andalucía
Beds: 3 Baths: 2 M2: 283 Lot Size: 8,200 Region: Andalucía
The perfect view paired with the right southwest orientation, which together gives the superlative to absolute happiness. A villa which leaves nothing to be desired, built to a very high standard (...)
Current Featured Properties
€560,000
TSEA4887199
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 93 Lot Size: 29 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Lot Size: 29 Area: Casares Region: Andalucía
This residential complex of 36 homes with 2 and 3 bedrooms and an exceptional range of services. Each home is carefully designed using soft, organic lines that blend naturally into the surroundings, (...)
€424,000
TSEA4752082
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
IDEALLY SITUATED BETWEEN ESTEPONA AND PUERTO BANUS!!!
Your new home is more than just rooms and features, it must fit in with your lifestyle. We have created a floor-plan that is spacious designed to (...)
€965,000
TSEA4955521
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 167 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 167 Area: Casares Region: Andalucía
A private beach right on your doorstep. Turquoise waters in a tropical setting. An exclusive Mediterranean-style residential complex. Homes with large terraces and high-quality finishes. 38 (...)
