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 1941 - 1960 of 5896 €267,000
TSEA5069647
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 70 m², Terrace 8 m².
Setting : Town, Commercial Area, Port, Village, Close To Port, Close To Shops, Close To Sea, (...)
€1,100,000
TSEA5069596
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 97 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Mijas and Mijas Costa Region: Andalucía
A rare opportunity to own a gorgeous beachfront penthouse located in the prestigious community of Calahonda. This stunning property boasts 2 spacious bedrooms and 2 beautifully renovated bathrooms (...)
€449,900
TSEA5069587
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 129 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 129 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 449,900 € to 729,900 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 129.00 m2 - 239.00 m2]
This gated residence consists of 48 homes (flats) in an exclusive location (...)
€450,000
TSEA5069575
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 65 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Marbella Region: Andalucía
Spacious flat in an unbeatable second line beach location in the heart of Marbella town centre. Surrounded by all kinds of services, the property is ideal both for year-round living and as a holiday (...)
€695,000
TSEA5069548
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 123 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 123 Area: Mijas and Mijas Costa Region: Andalucía
DUPLEX PENTHOUSE AT THE BEST PRICE WITH AMAZING SEA VIEWS
This fantastic property has 2 terraces with great sea views, 3 bedrooms, 2 bathrooms, 1 toilet, large living room - dining room and kitchen. (...)
€375,000
TSEA5069545
- Calypso, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 68 Lot Size: 150 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 68 Lot Size: 150 Area: Mijas and Mijas Costa Region: Andalucía
A typical charming Calypso bungalow. The property has 3 double bedrooms and 2 bathroom of which one ensuite. The semi open kitchen-living area with fireplace leads out to a large sunny terrace. On (...)
€449,000
TSEA5069542
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 2 M2: 121 Lot Size: 566 Area: Coin Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Lot Size: 566 Area: Coin Region: Andalucía
Detached house with infinity pool and views, opposite La Trocha – Coín.
Modern single-family home in a prime location, right across from La Trocha shopping center in Coín. Built on a 566 m² (...)
€3,200,000
TSEA5068387
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 400 Lot Size: 786 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 400 Lot Size: 786 Area: Marbella West Region: Andalucía
Detached Villa, Puerto Banús, Costa del Sol.
6 Bedrooms, 6 Bathrooms, Built 400 m², Terrace 200 m², Garden/Plot 786 m².
Setting : Port, Close To Shops, Close To Sea, Close To Town, Close To (...)
€1,499,000
TSEA5068378
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 6 M2: 415 Lot Size: 1,415 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 6 M2: 415 Lot Size: 1,415 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Villa with Sea Views in Mijas Pueblo – Ideal for Investors
High Yield | ???? 3 Units with the Possibility of Independent Living | ???? Panoramic Sea Views
Introducing an exceptional (...)
€1,450,000
TSEA5068309
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 4 M2: 389 Lot Size: 3,010 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 4 M2: 389 Lot Size: 3,010 Area: Sotogrande Region: Andalucía
Situated in one of the best streets of Sotogrande Alto, this family villa is built over 3 floors and set within a mature garden of over 3000m2.
Sotogrande is one of Southern Spain's most elegant and (...)
€410,000
TSEA5068306
- Rincón de la Victoria, Costa Del Sol East
Beds: 3 Baths: 2 M2: 147 Region: Andalucía
Beds: 3 Baths: 2 M2: 147 Region: Andalucía
For sale this apartment in Rincón de la Victoria, Añoreta Golf area.
Añoreta Golf is a quiet and well-connected area, ideal for living all year round or as a second residence.
The house is newly (...)
€6,500,000
TSEA5068216
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 1,085 Lot Size: 1,941 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 1,085 Lot Size: 1,941 Area: Benahavis Region: Andalucía
Nestled in the verdant folds of El Herrojo Alto, Benahavís—where the hills roll with a studied indifference and the Mediterranean glimmers like a secret too delicious to share—stands Villa La (...)
€350,000
TSEA5068024
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 73 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 73 Area: Fuengirola Region: Andalucía
This bright and spacious apartment is a fantastic opportunity to live or invest in one of the most sought-after areas of Fuengirola. Ideally located just 50 meters from the beach, it offers both (...)
€2,600,000
TSEA5067994
- Pinares de San Antón, Costa Del Sol
Beds: 4 Baths: 4 M2: 806 Lot Size: 921 Region: Andalucía
Beds: 4 Baths: 4 M2: 806 Lot Size: 921 Region: Andalucía
Nestled within the exclusive, verdant enclave of Pinares de San Antón, just a mere 7 minutes from the vibrant pulse of Málaga City Centre, Villa Haya stands as a testament to contemporary elegance (...)
€6,950,000
TSEA5067730
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 6 M2: 1,047 Lot Size: 909 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 6 M2: 1,047 Lot Size: 909 Area: Marbella West Region: Andalucía
Nestled gracefully upon the verdant slopes of Nueva Andalucía, this villa is a triumph of modern elegance and luxurious design, an embodiment of serene sophistication. As you approach the property, (...)
€625,000
TSEA5067373
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 124 Lot Size: 900 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Lot Size: 900 Area: Estepona Region: Andalucía
We offer this magnificent house for sale in the midst of a new development, located in the coastal town of Estepona, in the province of Malaga, five minutes from the well-known Laguna Beach, with (...)
€895,000
TSEA5067334
- Centro Histórico, Costa Del Sol
Beds: 4 Baths: 3 M2: 200 Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Region: Andalucía
This generously proportioned, newly renovated residence is perfectly positioned in the heart of Malaga's historic centre. Located on the second floor of a five-storey building with an elevator, the (...)
€2,600,000
TSEA5067310
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 435 Lot Size: 650 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 435 Lot Size: 650 Area: Benalmadena Region: Andalucía
This south-facing contemporary villa in Benalmádena Costa offers impressive 180º views of the sea and nearby mountains. Set on a 650 m² plot with 400 m² of built space distributed over three (...)
€1,950,000
TSEA5067226
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 300 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 300 Area: Marbella West Region: Andalucía
This unit is truly one of a kind. 3-bedroom apartment for sale in the prestigious Albatross Hill complex, located in the heart of Nueva Andalucía's Golf Valley. This elegant home offers the perfect (...)
€549,000
TSEA5067193
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 3 M2: 186 Lot Size: 860 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 3 M2: 186 Lot Size: 860 Area: Alhaurin el Grande Region: Andalucía
Discover this stunning villa just 2 km east of the vibrant village of Alhaurín el Grande. Set on a generous 860 m² flat plot, this beautiful property offers the perfect blend of comfort, pri-vacy, (...)
Current Featured Properties
€520,000
TSEA5106760
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 85 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, (...)
€369,000
TSEA4282294
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
YOU COULD NOT ASK FOR A BETTER LOCATION!!
Exclusive multi-family homes of 2 and 3 bedrooms located in the privileged surroundings of the Golden Mile of Estepona. The homes enjoy large terraces (...)
€893,000
TSEA4887208
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 175 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 175 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, (...)
