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 (56,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 (56,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 (56,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 2701 - 2720 of 3902 €1,149,000
TSEA4958080
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
LIGHT FLOODS INTO THE PROPERTY!!!
We will change weight for square meters, color for avant-garde architectural design, clarity for light and size for the best qualities and certified construction (...)
€395,000
TSEA4958074
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 105 m².
Setting : Town, Commercial Area, Beachside, Village, Close To Port, Close To Shops, Close To Sea, Close To (...)
€440,000
TSEA4958065
- Rincón de la Victoria, Costa Del Sol East
Beds: 2 Baths: 2 M2: 120 Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Region: Andalucía
Our project offers only 21 two and three bedroom homes available, in an exclusive enclave designed for those clients who value peace, tranquillity and the absence of noise. Conceived to guarantee the (...)
€1,850,000
TSEA4957975
- Sotogrande Marina, Costa Del Sol, Sotogrande
Beds: 4 Baths: 4 M2: 446 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 4 M2: 446 Area: Sotogrande Region: Andalucía
Luxury Penthouse in a Prime Location – Sotogrande Puerto Discover this exclusive penthouse in Puerto de Sotogrande, offering breathtaking panoramic views of the sea, the Marina, and Gibraltar. (...)
€230,000
TSEA4957924
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 1 Baths: 1 M2: 46 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Torremolinos Region: Andalucía
Excelent opportunity!
La Carihuela beach, by Aldi supermercado, 1-bedroom apartment for Sale, fully furnished.
Touristic license in place, already with booking for summer.
Finished October (...)
€555,000
TSEA4957705
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 86 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Benahavis Region: Andalucía
Nestled in an idyllic setting, this luxurious 2-bedroom, 2-bathroom apartment is a sanctuary of style and comfort. Recently refurbished to an impeccable standard, this property exudes elegance and (...)
€530,000
TSEA4957516
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 112 Lot Size: 22 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Lot Size: 22 Area: Estepona Region: Andalucía
Exclusive 3-Bedroom Apartment with Private Garden in Bel Air, Cancelada!
Discover this stunning 3-bedroom, 2-bathroom apartment on the ground floor, offering the perfect blend of comfort and luxury. (...)
€630,000
TSEA4957453
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 132 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 132 Area: Estepona Region: Andalucía
Top floor duplex apartment located in Bel-Air. It has three bedrooms, two bathrooms and a toilet, with two large terraces with good views. Parking space and storage room. Gated complex with swimming (...)
€275,000
TSEA4957447
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 70 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 70 Area: Benahavis Region: Andalucía
A practical hassle-free investment.
This property offers the perfect blend of resort hotel services and amenities with the independence of an apartment. Enjoy access to multiple swimming pools, lush (...)
€350,000
TSEA4374559
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 88 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Casares Region: Andalucía
New Development: Prices from 350,000 € to 350,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 88.00 m2 - 88.00 m2]
This development is a complex of 47 apartments with 1, 2 and 3 bedrooms. Each (...)
€659,500
TSEA4957246
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 72 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Area: Fuengirola Region: Andalucía
Luxury and Exclusivity in the Heart of Fuengirola
Live just 100 meters from the beach. Discover an exclusive residential complex designed to offer maximum comfort, luxury, and modernity on the Costa (...)
€595,000
TSEA4957219
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 91 Lot Size: 236 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 91 Lot Size: 236 Area: Fuengirola Region: Andalucía
Just completed before Christmas, this brand-new corner ground-floor apartment offers a perfect blend of modern comfort and outdoor living in the heart of the Costa del Sol.
Designed to make the most (...)
€297,000
TSEA4957129
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 104 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: La Duquesa Region: Andalucía
This magnificent middle-floor apartment is located in one of the most sought-after areas of the Costa del Sol, right in the heart of Puerto de la Duquesa. It is close to the beach and offers a wide (...)
€435,000
TSEA4957060
- Marbesa, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 110 Lot Size: 40 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Lot Size: 40 Area: Marbella East Region: Andalucía
In the area of Cabopino - Marbesa, this charming property stands out for its elegance, comfort and excellent location, just a 10-minute walk from the spectacular beaches and dunes of Cabopino. With a (...)
€371,100
TSEA4956715
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 1 M2: 70 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 1 M2: 70 Area: Marbella West Region: Andalucía
Discover your new home in the heart of Nueva Andalucía! This magnificent penthouse offers spectacular views of the sea from its large 18 square meter terrace, perfect for enjoying unforgettable (...)
€140,000
TSEA4956556
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 50 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Area: Estepona Region: Andalucía
round Floor Apartment in Estepona, Costa del Sol – Unbeatable Price! ????????
This cozy 1-bedroom, 1-bathroom ground floor apartment offers 50 m² of living space in a prime location, just 50 (...)
€288,000
TSEA4956442
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Discover your ideal coastal retreat in this 2-bedroom duplex flat in Torrequebrada. Enjoy partial sea views from your private roof terrace, perfect for relaxation and entertaining. The flat features (...)
€290,000
TSEA4956136
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 144 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 144 Area: Alhaurin el Grande Region: Andalucía
We present this fantastic opportunity in one of the most exclusive and peaceful areas of Alhaurín el Grande. Located in a secure, gated community, this property offers everything you need to enjoy a (...)
€560,000
TSEA4956106
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 110 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Marbella West Region: Andalucía
Discover this delightful two-bedroom, two-bathroom apartment located in a sought-after urbanisation. Perfectly situated in Marbella, this residence offers a blend of modern comfort and Mediterranean (...)
€720,000
TSEA4955935
- 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
Exclusive Beachfront Apartment in Fuengirola – Spectacular Sea Views
Discover this stunning 3-bedroom, 2-bathroom apartment located on the first line of the beach in Fuengirola, offering (...)
Current Featured Properties
€287,000
TSEA4748761
- Valle Romano, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 73 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 73 Area: Estepona Region: Andalucía
The residential complex has a total of 135 properties with 1, 2 or 3 bedrooms in 6 low-rise buildings. The modern, attractive design features clean, contemporary lines. The privileged south-facing (...)
€945,000
TSEA4749712
- La Quinta, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 237 Lot Size: 93 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 237 Lot Size: 93 Area: Benahavis Region: Andalucía
THE BEST OF THE BUNCH! A Batch of Luxury Apartments inside a private privileged development, Every detail is designed to minimise the impact on the environment whilst providing an estate worthy of (...)
€907,852
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 Area: Estepona Region: Andalucía
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
A luxury resort style apartment complex with the best in leisure facilities. This new development has been landscaped to create TOP QUALITY with (...)
