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,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
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.approved = 1 AND pm.cat_id IN (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
GROUP BY p.id
ORDER BY p.created DESC
Results 321 - 340 of 7581
TSEA5150464
- Higueron, Costa Del Sol
Beds: 3 Baths: 2 M2: 118 Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Region: Andalucía
Welcome to this newly built 3-bedroom corner apartment on the second floor of the sought-after Lomas 2 – completed in 2025 and ready for immediate move-in. Here, spacious interiors, fantastic (...)
TSEA5150455
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 248 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 248 Area: Estepona Region: Andalucía
New Development: Prices from 872,000 € to 1,075,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 248.00 m2 - 259.00 m2]
An exclusive residential complex: 36 apartments with 2 and 3 bedrooms, and (...)
TSEA5150452
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
New Development: Prices from 500,000 € to 969,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 94.00 m2 - 133.00 m2]
An exclusive residential complex: 36 apartments with 2 and 3 bedrooms, and 15 (...)
TSEA5150443
- La Mairena, Costa Del Sol, Marbella East
Beds: 5 Baths: 6 M2: 503 Lot Size: 1,529 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 6 M2: 503 Lot Size: 1,529 Area: Marbella East Region: Andalucía
Exceptional Villa Nestled in the Hills of La Mairena
This unique three-level villa has been thoughtfully designed to embrace its privileged location and breathtaking scenery. From the moment you (...)
TSEA5150437
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
**64 m² Studio Apartment for Sale – Riviera del Sol, Costa del Sol (Spain)**
This attractive ground floor studio is located in a gated and secure community, just 400 meters from the beach, (...)
TSEA5150431
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 95 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Marbella West Region: Andalucía
5 minutes walk to Centro Plaza in Nueva Andalucia and 20 minues to Puerto Banus this bright and spacious middle-floor apartment offers two bedrooms and two bathrooms, combining comfort with stunning (...)
TSEA5150281
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 285 Lot Size: 143 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 285 Lot Size: 143 Area: Marbella East Region: Andalucía
Located in the very heart of the Golden Mile, just 1,500 meters from the beach and surrounded by an exclusive and tranquil environment, this magnificent semi-detached house is situated in Nagüeles (...)
TSEA5150107
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 120 Lot Size: 30 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 30 Area: Marbella West Region: Andalucía
BRAND NEW TO THE MARKET!!!
This is a super Bright & Spacious 3 Bedroom Apartment in the Heart of Puerto Banús.
How can you be in the heart of it all, yet be so quiet?..
This exceptional (...)
TSEA5150092
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 225 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 225 Area: Estepona Region: Andalucía
Renovation Project: Stunning South-Facing Townhouse Near the Beach and Laguna Village – Motivated Seller!
Seize this fantastic renovation opportunity with endless potential in a spacious 5-bedroom, (...)
TSEA5150083
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 189 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 189 Area: Mijas and Mijas Costa Region: Andalucía
Exceptional 3-Bedroom Ground Floor Apartment with Expansive Terraces Surrounded by Tropical Gardens
This truly unique and one-of-a-kind property offers an extraordinary living experience. Originally (...)
TSEA5150074
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 6 Baths: 5 M2: 382 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 5 M2: 382 Area: San Pedro Region: Andalucía
We offers a unique opportunity in the heart of San Pedro de Alcántara.
We present this spacious and bright semi-detached house with a floor area of 382 square meters, distributed over 4 floors (...)
TSEA5150062
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Located in the heart of Marbella, this cozy 1-bedroom, 1-bathroom apartment is an excellent opportunity for both primary residence and investment. Facing east, it enjoys pleasant natural light and (...)
TSEA5150041
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 40 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 40 Area: Mijas and Mijas Costa Region: Andalucía
Your perfect getaway on the Costa del Sol awaits!
We are pleased to present this fantastic brand-new apartment (built in 2023) located in Mijas, right in the heart of the Costa del Sol — one of the (...)
TSEA5150035
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 200 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Area: Fuengirola Region: Andalucía
Welcome to your dream home on the stunning Costa del Sol! This amazing villa offers an unparalleled living experience with its 4 spacious bedrooms and 3 luxurious bathrooms. The villa is part of a (...)
TSEA5150032
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 330 Lot Size: 1,000 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 330 Lot Size: 1,000 Area: Benalmadena Region: Andalucía
Welcome to a magnificent 4-bedroom, 3-bathroom residence in the charming city of Benalmadena. Spanning an impressive 400 square meters, this elegant home embodies the essence of coastal luxury with (...)
TSEA5149999
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 500 Lot Size: 1,550 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 500 Lot Size: 1,550 Area: Marbella Region: Andalucía
EXCLUSIVE INVESTMENT OPPORTUNITY IN THE HEART OF MARBELLA!
Exceptional property combining a privileged location, spaciousness, comfort and great potential for appreciation. This is a magnificent (...)
TSEA5149942
- San Roque Club, Costa Del Sol
Beds: 3 Baths: 3 M2: 193 Region: Andalucía
Beds: 3 Baths: 3 M2: 193 Region: Andalucía
This elegant penthouse, fully renovated and beautifully decorated in a modern style, offers a unique living space in the exclusive setting of San Roque Club. With stunning sea views and surrounded by (...)
TSEA5149936
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 71 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Casares Region: Andalucía
Penthouse with Solarium and Panoramic Sea Views in Casares Playa
This exclusive penthouse with a private solarium in Casares Playa combines space, natural light, and a privileged location on the (...)
TSEA5149927
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 147 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 147 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular 3 bedrooms apartment with panoramic views of the sea facing the Calanova Golf Course.
The property is located in the middle of the complex, it enjoys fantastic views and privacy.
It has a (...)
TSEA5149918
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Manilva Region: Andalucía
This stunning apartment is located in Los Granados de Duquesa, Manilva, Málaga, a prime beachfront location. Thoughtfully designed and in excellent condition, this property offers a luxurious and (...)
