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,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 (31,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 (31,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (2652), Middle Floor - (2652), Penthouse - (2652), Top Floor Apartment - (2652), Penthouse Duplex - (2652)Properties
Results 321 - 340 of 3992
€727,500
TSEA5144161
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 99 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 99 Area: Torremolinos Region: Andalucía
Middle Floor Apartment, Torremolinos las torres de playamar, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 99 m².
with turistic licence
Community fee all included
Setting : Beachfront, Town, Close (...)
€359,000
TSEA5144158
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Discover your oasis in lower Riviera del Sol, Mijas Costa!
Charming apartment, which without a doubt, is located in the best complex of Riviera del Sol. It is a rare pearl and situated in the lower (...)
€699,000
TSEA5144080
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 159 Lot Size: 21 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 159 Lot Size: 21 Area: Estepona Region: Andalucía
Welcome to your sun-kissed paradise on the sought-after New Golden Mile of Estepona, renowned for its sunny skies, golden sands and crystal-clear waters.
With just 25 stunning apartments, you'll get (...)
€569,000
TSEA5144038
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Welcome to your sun-kissed paradise on the sought-after New Golden Mile of Estepona, renowned for its sunny skies, golden sands and crystal-clear waters.
With just 25 stunning apartments, you'll get (...)
€535,000
TSEA5144026
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Magnificent apartment with large terrace and sea views!!!!, Close to everything!!!, In the heart of the most wanted LA CALA de Mijas!!!
With a large terrace and sea views to enjoy year-round, (...)
€680,000
TSEA5143975
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Exclusivity, Design & Location: Your New Home on the Costa del Sol
Introducing a unique residence, fully renovated to perfection, set in one of the most sought-after areas of the Costa del Sol. (...)
€1,595,000
TSEA5143915
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 388 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 388 Area: Marbella Region: Andalucía
*Luxurious 3-Bedroom Duplex Penthouse in Prestigious Sierra Blanca*
Discover this expansive 3-bedroom duplex penthouse located in the highly sought-after area of Sierra Blanca. This exquisite (...)
€1,100,000
TSEA5143897
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 121 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 121 Area: Benahavis Region: Andalucía
This stunning top floor apartment., set within the prestigious La Quinta Golf resort, offers an elegant & sophisticated interior with breathtaking panoramic views.
Having been renovated recently (...)
€495,000
TSEA5143876
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Discover this stunning, fully furnished apartment in the heart of Estepona, offering modern luxury and comfort. Recently renovated with top-quality materials, it features a spacious three-bedroom (...)
€360,000
TSEA5143873
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Your Oasis in La Cala de Mijas Awaits You!
Urbanización Ángel de Miraflores – Ground Floor with Private Garden and Communal Pool
We present to you this charming ground-floor apartment located in (...)
€545,000
TSEA5143834
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
This beautifully renovated 3-bedroom, 2-bathroom apartment is ideally situated just 150 meters from La Carihuela beach.
Designed with a smart layout and contemporary finishes, the interiors are both (...)
€185,000
TSEA5143828
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 1 Baths: 1 M2: 45 Area: San Pedro Region: Andalucía
Beds: 1 Baths: 1 M2: 45 Area: San Pedro Region: Andalucía
Ground floor apartment in the heart of San Pedro Alcantara with one bedroom. The location is unbeatable, very quiet and family-friendly. All kinds of services are close at hand, including schools, (...)
€475,000
TSEA5143807
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Top-Floor Living close to the Sea – Penthouse For Sale
Looking for something special? This bright and modern penthouse ticks all the boxes — stunning sea views, a spacious 40 m² terrace, and a (...)
€685,000
TSEA5143777
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 150 Lot Size: 20 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Lot Size: 20 Area: Casares Region: Andalucía
Discover Your Dream Home: Luxurious Brand-New Apartment in Casares Costa
Prime Location with Breathtaking Views: Enjoy stunning sea and mountain vistas from your private terrace in a south-facing (...)
€415,000
TSEA5143774
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 92 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 92 Area: Marbella Region: Andalucía
Stunning & Spacious 2-Bedroom Apartment in the Heart of Marbella
Discover your dream home in this beautiful 85 m² apartment (90 m² built) located in the vibrant Avenida General López (...)
€415,000
TSEA5143771
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 90 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 90 Area: Estepona Region: Andalucía
Top Floor Apartment, Estepona, Costa del Sol.
3 Bedrooms, 1 Bathroom, Built 90 m², Terrace 15 m².
Setting : Town, Close To Port, Close To Shops, Close To Sea, Close To Town, Close To Schools, (...)
€675,000
TSEA5143657
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
This beautiful 3 bedroom 2 bathroom penthouse nestled in the heart of Nueva Andalucia must be seen. With an expansive terrace and solarium totally nearly 100 sqm means there is a multitude of outdoor (...)
€1,995,000
TSEA5143639
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Bahía del Velerín is a prestigious community located between Marbella and Estepona. It boasts a beautiful pool area with a snack bar, lush tropical gardens, and 24/7 security. Set in a prime (...)
€2,995,000
TSEA5143633
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Bahía del Velerín is a luxurious community between Marbella and Estepona. It has a fantastic pool area with a snack bar, tropical gardens and 24/7 security. The community is located at one of the (...)
€439,000
TSEA5143624
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 109 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 109 Area: Mijas and Mijas Costa Region: Andalucía
BACK ON THE MARKET !- Casa Banderas
Nice corner Garden Apartment with open Panoramic view towards Mijas Pueblo
2 Bedrooms/2 bathrooms with open plan kitchen
Very bright and close to all the (...)
Current Featured Properties
€323,000
TSEA4644049
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 99 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: Casares Region: Andalucía
This new development offers various golf courses within a radius of just 15 minutes, including the Casares Costa Golf complex, where the spectacular Finca Cortesín Golf & SPA is located, next to (...)
€577,500
TSEA3923743
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
GREAT LOCATION CLOSE TO CHARMING ESTEPONA.
The apartments are specially designed to fully enjoy the charm of the Mediterranean lifestyle. A well thought out floor plan, bathrooms with lovely (...)
€559,700
TSEA4889500
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 101 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Estepona Region: Andalucía
We are pleased to present this new development located in the heart of the historic center of Estepona. It combines the charm of urban living with the modernity and comfort of a contemporary home. (...)
