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
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
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
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1581 - 1600 of 7575 €570,000
TSEA5114494
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 93 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Fuengirola Region: Andalucía
Just 350 metres from the beach, this beautifully crafted 2-bedroom, 2-bathroom apartment offers the perfect blend of contemporary style and everyday comfort. Located in an exclusive development of (...)
€625,000
TSEA5114377
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
This is a fabulous 3 bedroom apartment in the front line beach complex of Las Mimosas in La Cala de Mijas. Set on the first floor with views over the beautiful gardens, pools and Mediterranean, this (...)
€340,000
TSEA5114362
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 86 Lot Size: 190 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Lot Size: 190 Area: Mijas and Mijas Costa Region: Andalucía
Charming End-of-Terrace Townhouse in Mijas Golf
This beautifully presented townhouse is located in a small, exclusive urbanisation of just four homes, offering a peaceful setting with a communal (...)
€535,000
TSEA5114350
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 145 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 145 Area: Mijas and Mijas Costa Region: Andalucía
Stunning Ground Floor Apartment in Frontline Beach Community – Las Mimosas, La Cala de Mijas
Experience coastal living at its finest with this beautifully maintained 2-bedroom, 2-bathroom ground (...)
€845,000
TSEA5114314
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
Exclusive Ground Floor Apartment in Embrujo Playa, Between the Glamour of Puerto Banús and the Charm of San Pedro.
Welcome to a property that brings together everything that makes living in (...)
€298,000
TSEA5114308
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 92 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 92 Area: Benalmadena Region: Andalucía
We are pleased to offer you this exclusive apartment in Torrequebrada, with south-facing orientation, in an exceptional location and a quiet area. This magnificent property, with 92 m² built and 77 (...)
€765,000
TSEA5114287
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Stylish Townhouse with Scenic Views in Aloha Pueblo, Nueva Andalucía
Nestled in the heart of the prestigious Aloha Pueblo community in Nueva Andalucía, this thoughtfully refurbished townhouse (...)
€2,487,000
TSEA5114272
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 478 Lot Size: 838 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 478 Lot Size: 838 Area: Benahavis Region: Andalucía
This charming villa in the heart of the beautiful Benahavis village enjoys panoramic views from every room and is full of character. It has has complete privacy, is extremely quiet and is only a few (...)
€750,000
TSEA5114269
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 99 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 99 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse, Riviera del Sol, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 99 m², Terrace 23 m².
Setting : Close To Sea, Close To Town, Urbanisation.
Orientation : West, North West.
Condition : (...)
€250,000
TSEA5114215
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 119 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 119 Area: Malaga Region: Andalucía
Fantastic house for sale located in the coveted neighborhood of San José del Viso, an area undergoing rapid expansion and with all the amenities at your fingertips.
This bright home features 3 (...)
€415,000
TSEA5114212
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 99 Lot Size: 109 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 99 Lot Size: 109 Area: Malaga Region: Andalucía
Charming Casa Mata (Townhouse) with rooftop terrace in a sought-after neighbourhood.
Discover the potential of this bright and spacious casa mata located in a tranquil street, just a short walk from (...)
€845,000
TSEA5113885
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 117 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Marbella West Region: Andalucía
Nestled in the heart of Marbella's sought-after Golf Valley in Nueva Andalucía, this completely renovated duplex penthouse corner unit offers a rare opportunity to experience refined Mediterranean (...)
€950,000
TSEA5113849
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 4 Baths: 3 M2: 230 Lot Size: 273 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 3 M2: 230 Lot Size: 273 Area: Sotogrande Region: Andalucía
Town House for sale in La Finca, Sotogrande with 4 bedrooms, 3 bathrooms, 1 toilet and with orientation south/east, with communal swimming pool, private garage (2 parking spaces) and private garden. (...)
€904,000
TSEA5113795
- Almayate Alto, Costa Del Sol East
Beds: 3 Baths: 3 M2: 196 Lot Size: 31,295 Region: Andalucía
Beds: 3 Baths: 3 M2: 196 Lot Size: 31,295 Region: Andalucía
This impressive finca near Almayate spans almost 32,000 m2 of land and offers ample space for peace, self-sufficiency or small-scale farming projects. At its heart lies a charming house of approx. (...)
€559,000
TSEA5113768
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 157 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 157 Area: Estepona Region: Andalucía
Discover this beautifully presented ground floor apartment, offering the perfect blend of space, comfort, and prime location. The property features a generous open-plan living and dining area that (...)
€190,000
TSEA5113753
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 80 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 80 Area: Manilva Region: Andalucía
Middle Floor Apartment, San Luis de Sabinillas, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 80 m², Terrace 9 m².
Setting : Beachfront, Town, Commercial Area, Beachside, Village, Close To Shops, (...)
€385,000
TSEA5113744
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 60 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 60 Area: Malaga Region: Andalucía
Located 150m from Plaza de La Constitución!
This spacious and modern 2 bed apartment with elevator is conveniently located near various transportation options, including a taxi station, train (...)
€455,000
TSEA5113729
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 198 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 198 Area: Mijas and Mijas Costa Region: Andalucía
PRICED FOR A QUICK SALE - IN THE MIDDLE OF LA CALA DE MIJAS - JUST A FEW METERS FROM THE BEACH!!!
Welcome to this beautifully renovated three-bedroom duplex located in the heart of Cala de Mijas. (...)
€349,000
TSEA5113708
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Amazing single-story townhouse, with the possibility of building another floor above (this information pending confirmation).
With a front and rear porch.
It has a fireplace.
Open-plan kitchen. (...)
€470,000
TSEA5112667
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
With its smart and functional layout, this apartment offers two spacious bedrooms and two bathrooms — one of them en-suite — along with a separate kitchen and an independent utility room that (...)
Current Featured Properties
€1,900,000
TSEA5005987
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 8 M2: 480 Lot Size: 1,878 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 8 M2: 480 Lot Size: 1,878 Area: Benahavis Region: Andalucía
ELEGANT VILLA WITH LARGE PLOT WITH SEA VIEWS AND SPA AREA
Fantastic villa with an elegant Mediterranean style, located in a quiet and private area next to San Pedro de Alcántara, La Quinta, Monte (...)
€7,975,000
TSEA4712791
- La Mairena, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 1,254 Lot Size: 49,832 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 1,254 Lot Size: 49,832 Area: Marbella East Region: Andalucía
ASTONISHING LUXURY VILLA WITH SEA VIEWS IN LA MAIRENA
Astonishing luxury villa nestled in a secluded oasis of tranquility, close to La Mairena, offering unparalleled privacy amidst unspoiled natural (...)
€890,000
Ground Floor Apartment in San Pedro de Alcántara
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 200 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Area: San Pedro Region: Andalucía
START LIVING YOUR BEST LIFE!!!
A luxury residential Project in Guadalmina Alta, Marbella (Malaga), this is a perfect location for you to enjoy the famous Mediterranean lifestyle. The living room (...)
