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 (44,36,37,38)
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 (44,36,37,38)
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 (44,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 36
€164,000
TSEA5159569
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 36 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 36 Area: Benalmadena Region: Andalucía
Middle Floor Studio, Benalmadena Costa, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 36 m², Terrace 6 m².
Setting : Commercial Area, Close To Golf, Close To Port, Close To Shops, Close To Sea, (...)
€925,000
TSEA5151712
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 188 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 188 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 925,000 € to 1,119,950 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 188.00 m2 - 255.00 m2]
Building License Expected November 2025
Ideally located among fragrant (...)
€495,000
TSEA5150911
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
This beautiful, fully exterior apartment stands out for its excellent location and natural brightness throughout. Located in a peaceful residential area of Marbella, it is just 400 meters from the (...)
€872,000
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 (...)
€222,900
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, (...)
€899,950
TSEA5142595
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 153 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 153 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 899,950 € to 995,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 153.00 m2 - 169.00 m2]
LUXURY TOWNHOUSES IN MIJAS COSTA - Building License expected October (...)
€254,500
TSEA5141122
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 27 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 27 Area: Mijas and Mijas Costa Region: Andalucía
This beachfront studio apartment is an excellent opportunity for those seeking a property in a prime location. The apartment is south-east facing, offering spectacular views of the Mediterranean, the (...)
€569,000
TSEA5122012
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 116 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Malaga Region: Andalucía
This exclusive apartment is located in the beautiful area of Casares Playa, in Casares, Málaga. With a privileged location, this apartment offers a peaceful and relaxing environment. With 2 bedrooms (...)
€179,800
TSEA5110210
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 40 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 40 Area: Fuengirola Region: Andalucía
Your Sweet Seaside Retreat! Ideal Studio in a Prime Location Between Miramar and the Center of Fuengirola, walking distance to the beach
Discover this charming 40 m² studio, perfectly located (...)
€205,000
TSEA5075281
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 30 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 30 Area: Fuengirola Region: Andalucía
RENOVATED STUDIO 20 METERS FROM THE BEACH IN CARBAJAL, COMPLETELY RENOVATED AND FURNISHED WITH TOURIST LICENSE, LOCATED JUST ONE STEP FROM THE BEACH, BUS AND TAXI STOP AT THE DOOR, IDEAL FOR HOLIDAYS (...)
€405,000
TSEA5049157
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 230 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 230 Area: Estepona Region: Andalucía
New Development: Prices from 405,000 € to 593,750 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 230.00 m2 - 263.00 m2]
Welcome to the residential complex in Estepona, your new home on the Costa (...)
€318,000
TSEA4905772
- Torrox, Costa Del Sol East
Beds: 2 Baths: 3 M2: 147 Region: Andalucía
Beds: 2 Baths: 3 M2: 147 Region: Andalucía
New Development: Prices from 318,000 € to 379,000 €. [Beds: 2 - 2] [Baths: 3 - 3] [Built size: 147.00 m2 - 164.00 m2]
An exclusive new development of 21 townhouses with panoramic sea views, (...)
€925,000
TSEA5019559
- Torremuelle, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 214 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 214 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 925,000 € to 965,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 214.00 m2 - 214.00 m2]
A development located in a privileged environment, located in Torremuelle, (...)
€857,000
TSEA4449847
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 145 Lot Size: 51 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Lot Size: 51 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 857,000 € to 1,465,000 €. [Beds: 3 - 4] [Baths: 2 - 2] [Built size: 145.00 m2 - 165.00 m2]
Welcome to this project, an exclusive complex of sixty-nine villas that (...)
€653,000
TSEA4179187
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 73 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 73 Area: Manilva Region: Andalucía
New Development: Prices from 653,000 € to 673,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 127.00 m2 - 127.00 m2]
2 LAST UNITS FULLY FURNISHED!!!
Life is built on small pleasures and (...)
€620,000
TSEA4626643
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 189 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 189 Area: Istan Region: Andalucía
New Development: Prices from 620,000 € to 640,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 189.00 m2 - 197.00 m2]
23 exclusive townhouses with the best panoramic views at the highest part of (...)
€175,000
TSEA5034157
- Olletas, Costa Del Sol
Beds: 1 Baths: 1 M2: 36 Region: Andalucía
Beds: 1 Baths: 1 M2: 36 Region: Andalucía
Charming Fully Furnished Studio Apartment in Olletas, Málaga — Ready to Move In or Rent Out
This fully furnished and equipped studio is ideal as a primary residence or as a rental unit for (...)
€1,261,150
TSEA4600315
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,261,150 € to 1,819,182 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 268.00 m2 - 387.00 m2]
This exclusive project with an elegant Scandinavian design blends (...)
€1,069,000
TSEA4771840
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 157 Lot Size: 255 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 157 Lot Size: 255 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,069,000 € to 1,069,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 157.00 m2 - 157.00 m2]
KEY READY!
A unique development of exclusive four-bedroom town homes (...)
€1,700,000
TSEA5016151
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 255 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 255 Area: Marbella Region: Andalucía
New Development: Prices from 1,700,000 € to 1,700,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 255.00 m2 - 255.00 m2]
This is a brand new off plan project consisting of just 25 properties. (...)
