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,42,43,44,45)
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,42,43,44,45)
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,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 281 - 300 of 6631
€500,000
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 (...)
€4,200,000
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 (...)
€450,000
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 (...)
€780,000
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 (...)
€880,000
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 (...)
€390,000
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 (...)
€600,000
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 (...)
€320,000
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 (...)
€230,000
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 (...)
€770,000
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 (...)
€975,000
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 (...)
€2,300,000
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 (...)
€695,000
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 (...)
€280,000
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 (...)
€875,000
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 (...)
€540,000
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 (...)
€359,000
TSEA5149888
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
This is a very attractive modern apartment located in an elevated spot above the beaches of Elviria and East Marbella. Located in the high end enclave of La Maiirena an area occupied by luxury (...)
€1,450,000
TSEA5149885
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 213 Lot Size: 10,545 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 213 Lot Size: 10,545 Area: Mijas and Mijas Costa Region: Andalucía
A Spectacular, Self-Sufficient, Country Villa with Mature Grounds and Income Potential
This stunning country estate is arguably one of, if not the best of its kind being fully self-sufficient with (...)
€580,000
TSEA5149873
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 84 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 84 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€343,000
TSEA5149855
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 50 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 50 Area: Malaga Region: Andalucía
Tourist-Licensed Apartment in the Heart of Málaga – La Merced Area
Turnkey investment with proven high returns!
Located just a few steps from the iconic Plaza de la Merced, this modern apartment (...)
Current Featured Properties
€2,750,000
TSEA4446295
- Manilva, Costa Del Sol, Manilva
Beds: 5 Baths: 7 M2: 480 Lot Size: 1,400 Area: Manilva Region: Andalucía
Beds: 5 Baths: 7 M2: 480 Lot Size: 1,400 Area: Manilva Region: Andalucía
SEIZE THE OPPORTUNITY: SPECTACULAR HOME WITH MODERN AMENITIES AWAITS!!
With 5 bedrooms and 7 bathrooms, it is perfect for a large family or for those who love to entertain guests. The property (...)
€490,000
TSEA4934416
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
An exclusive promotion of 25 units (1 to 3 bedrooms) in one of the expanding areas of Estepona. Located just minutes from the best beaches and offering access to a wide range of services, this (...)
€695,000
TSEA4940635
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Perfectly combines living in natural surroundings with the comfort of being only a short distance from the center of Estepona. As well as a coastline that stretches for 20km, the town has great (...)
