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 (40,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 (40,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 (40,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 1401 - 1420 of 3894 €399,995
TSEA5074024
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 135 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 135 Area: Mijas and Mijas Costa Region: Andalucía
This bright and spacious corner apartment is ideally located just a 5-minute walk from the prestigious Miraflores Golf Club House. Featuring a generous living and dining area, a fully fitted kitchen, (...)
€339,000
TSEA5074018
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Magnificent ground floor apartment in the exclusive gated community of Las Acacias, Estepona.Are you looking for a home in a dream residential environment, surrounded by tranquility and beauty? This (...)
€633,500
TSEA5074012
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 85 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 85 Area: Fuengirola Region: Andalucía
Floor 5 Apartment, Fuengirola, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 85 m².
Possibility of turistic licence
Setting : Beachfront, Town, Beachside, Urbanisation.
Condition : Excellent.
Pool : (...)
€475,000
TSEA5074006
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 229 Lot Size: 181 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 229 Lot Size: 181 Area: Mijas and Mijas Costa Region: Andalucía
Spacious Ground Floor Apartment with Stunning Sea Views in La Cala de Mijas – Ideal Investment Opportunity
This bright and spacious 3-bedroom ground floor apartment is located in the highly (...)
€325,000
TSEA5073991
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
This development consists of 79 luminous 2 and 3 bedroom apartments and penthouses.
Located only 3 minutes away from the picturesque village La Cala de Mijas, with an abundance of bars, shops, (...)
€236,000
TSEA5073814
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 37 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 37 Area: Fuengirola Region: Andalucía
OPPORTUNITY!
Apartment with 1 bedroom for sale for personal use or investment in a 4-star hotel in Fuengirola.
Furnished property with equipped kitchen and bathroom, east-facing with sea, beach, and (...)
€2,290,000
TSEA5073796
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 4 M2: 173 Area: Malaga Region: Andalucía
Beds: 3 Baths: 4 M2: 173 Area: Malaga Region: Andalucía
Exclusive property for sale with panoramic views on the 16th floor of the Mediterranean Sea in the city of Malaga. The towers are considered to be the most important project on the peninsular (...)
€382,000
TSEA5073766
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 382,000 € to 465,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 93.00 m2 - 107.00 m2]
This development is the vision of renowned architect — an architectural (...)
€435,000
TSEA5073709
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 132 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 132 Area: Marbella East Region: Andalucía
Located in the highly desirable area of Cabopino, this bright and spacious 2-bedroom, 2-bathroom apartment offers the perfect blend of comfort, convenience, and coastal living—just a 7-minute walk (...)
€1,750,000
TSEA5073538
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 200 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Area: Marbella West Region: Andalucía
Amazing unique property in the heart of Nueva Andalucia. Perfectly situated, the property boasts breathtaking views of La Concha and offers a tranquil retreat with a very large terrace with charming (...)
€410,000
TSEA5073391
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Lot Size: 10 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Lot Size: 10 Area: Estepona Region: Andalucía
Your Place in the Sun – Stylish 2-Bed Garden Apartment in Prime Location in Estepona Celere Sea VIews
Imagine waking up each day in your own beautifully furnished, light-filled apartment, (...)
€585,000
TSEA5073358
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
Modern & Spacious 2-Bedroom Penthouse in Vanian Green Village – Urb. Selwo, Estepona
Located in the desirable Vanian Green Village – Phase 2, this stylish and spacious two-bedroom penthouse (...)
€299,000
TSEA5073298
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
In the popular area Torrequebrada, we find this bright and well-planned home featuring two bedrooms, a stylish bathroom, and two generous terraces to enjoy.
The layout is classic and functional, (...)
€535,000
TSEA5073283
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 219 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 219 Area: Casares Region: Andalucía
Located in a charming residential complex composed of 8 small three-story blocks, this exceptional penthouse offers a spacious living room, a fully fitted kitchen with a separate utility room, 3 (...)
€330,000
TSEA5073268
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 91 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to an elegant and well-designed penthouse of high standard, located at the top of the well-maintained urbanization Vitania in La Cala de Mijas. Here you enjoy complete privacy, unobstructed (...)
€639,000
TSEA5073265
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 126 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 126 Area: Estepona Region: Andalucía
Penthouse in the Heart of Estepona Old Town – with Two Spacious Terraces
Welcome to this unique penthouse located in the heart of Estepona's picturesque and vibrant Old Town. The property features (...)
€1,500,000
TSEA5073250
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 146 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 146 Area: Algeciras Region: Andalucía
Corner Penthouse with Panoramic Views in The Links II – La Alcaidesa
This stunning 3-bedroom corner penthouse in The Links II offers one of the best views on the coast. On clear days, it offers a (...)
€315,000
TSEA5073241
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 2 Baths: 1 M2: 90 Area: Manilva Region: Andalucía
Beds: 2 Baths: 1 M2: 90 Area: Manilva Region: Andalucía
Wake up every morning to stunning views of the Mediterranean Sea! ????
Discover this beautiful beachfront apartment in Sabinillas, right next to the charming seafront promenade.
Featuring 2 bedrooms (...)
€350,000
TSEA5073196
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 120 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Marbella Region: Andalucía
3-Bedroom Apartment for Sale with 2 Bathrooms, Garage, and Storage in an Idyllic Location
Spacious three-bedroom apartment
Two full bathrooms
Private garage included
Large storage room
Located in a (...)
€570,000
TSEA5073175
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Modern 2-Bedroom Corner Apartment with Sea & Mountain Views – La Cala de Mijas
Situated in the heart of La Cala de Mijas, this well-appointed 2-bedroom, 2-bathroom corner apartment offers a (...)
Current Featured Properties
€220,000
TSEA4871923
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 42 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 42 Area: Estepona Region: Andalucía
Cozy and Immaculately presented studio apartment in a frontline beach urbanisation beween San Pedro and Estepona, very close to Velerín and with a great offer of chiringuitos and a wonderful beach (...)
€630,000
TSEA4245991
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 70 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Benalmadena Region: Andalucía
BREATHTAKING VIEWS OF THE SEA!!!
This is an exclusive, private development situated in a privileged location in Benalmádena. Thanks to its elevated position, all homes boast panoramic views of the (...)
€425,000
TSEA5057473
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 101 Lot Size: 62 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Lot Size: 62 Area: Estepona Region: Andalucía
LOCATED IN BEAUTIFUL ESTEPONA!!!
One of the most attractive corners of the Costa del Sol. The town has become one of the most sought-after spots on the Costa del Sol, thanks to its quality of life (...)
