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 (40,68,69,70)
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 (40,68,69,70)
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 (40,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1501 - 1520 of 2510 €307,500
TSEA5008474
- Tarifa, Costa de la Luz
Beds: 1 Baths: 1 M2: 50 Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Region: Andalucía
Charming Apartment for Sale in the Heart of Tarifa
Located in the historic center on a quiet street, just steps away from Tarifa's best restaurants, bars, shops and the beach. This apartment blends (...)
€398,000
TSEA5008441
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 89 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 89 Area: Casares Region: Andalucía
STUNNING VIEWS OF THE MOUNTAINS AND SEA!!!
This brand new development consists of 47 apartments with 2 and 3 bedrooms, distributed in 3 blocks with ground floor and 2 floors. All of them with garage (...)
€375,000
TSEA5008408
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 214 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 214 Area: Manilva Region: Andalucía
Large modern south facing un-furnished townhouse in a small development of only 46 houses.
Townhouse, Manilva, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 150 m², Terrace 44 m².
Setting : (...)
€359,000
TSEA5008114
- Tolox, Costa Del Sol, Yunquera
Beds: 7 Baths: 2 M2: 180 Area: Yunquera Region: Andalucía
Beds: 7 Baths: 2 M2: 180 Area: Yunquera Region: Andalucía
Magestic village house built in 1830, the third oldest house in Tolox and located right in the historic center of the town. The house is spread over three floors, maintaining all the authenticity of (...)
€295,000
TSEA5008093
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 93 Lot Size: 152 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Lot Size: 152 Area: Mijas and Mijas Costa Region: Andalucía
Lovely 2 bedroom apartment in Mijas Golf, only a stone's throw from the new Championship Golf Course! You have the best of everything with 3 terraces to choose giving you the option of sun or shade (...)
€995,000
TSEA5008084
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 158 Lot Size: 100 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 158 Lot Size: 100 Area: Marbella West Region: Andalucía
EXCLUSIVE - Luxury 3-bedroom townhouse with sea, golf and mountain views
Completely renovated 3-bedroom townhouse situated in a prestigious urbanization in the heart of Nueva Andalucia´s golf (...)
€325,000
TSEA5007967
- Martiricos, Costa Del Sol
Beds: 3 Baths: 1 M2: 73 Region: Andalucía
Beds: 3 Baths: 1 M2: 73 Region: Andalucía
Middle Floor Apartment, Martiricos, Málaga Ciudad.
3 Bedrooms, 1 Bathroom, Built 73 m².
Setting : Town, Commercial Area, Close To Sea, Close To Schools.
Orientation : East, South.
Condition : (...)
€399,000
TSEA5007868
- Marbesa, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 110 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Marbella East Region: Andalucía
This charming apartment in Marbesa, Marbella, 500 meters from the beach. It is located in a consolidated and very quiet urbanization in one of the nicest areas of Marbella East, close to the port of (...)
€477,000
TSEA5007817
- Perchel Sur, Costa Del Sol
Beds: 3 Baths: 2 M2: 130 Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Region: Andalucía
Imagine waking up every morning to the sea breeze on your skin. Living just 200 meters from the beach, in one of Málaga's most authentic—and up-and-coming—neighborhoods. Welcome to your new home (...)
€730,000
TSEA5007421
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 165 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 165 Area: Marbella West Region: Andalucía
Located in the prestigious community of Los Naranjos de Marbella, this spacious semi-detached house offers a privileged setting with landscaped gardens, communal pool and a Mercadona supermarket. (...)
€564,000
TSEA4648951
- 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
New Development: Prices from 564,000 € to 564,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 101.00 m2 - 101.00 m2]
This modern and functional gated residential complex offers 41 stylish 1, 2, (...)
€435,000
TSEA5007064
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 98 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Malaga Region: Andalucía
Floor 6 Apartment, Málaga Centre Victoria area, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 98 m².
Setting : Town.
Condition : Excellent, Recently Renovated.
Climate Control : Air (...)
€829,000
TSEA5006989
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 198 Lot Size: 30 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 198 Lot Size: 30 Area: Manilva Region: Andalucía
Fantastic sea views: Luxury townhouse in Bahia de Las Rocas
The townhouse project Golden View offers exclusive living comfort and breathtaking views of the sea as far as Gibraltar and the Atlas (...)
€266,000
TSEA5006899
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 113 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 113 Area: Malaga Region: Andalucía
GREAT FLAT TWO MINUTES AWAY FROM PLAZA COSTA DEL SOL AND SAN MIGUEL STREET!
Beautiful flat of 113 m² constructed, 78 m² useful and 15 m² of terrace, on the 1st floor of the San Enrique building, (...)
€398,320
TSEA5006848
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 132 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Malaga Region: Andalucía
Apartment in Fuengirola Just One Minute from the Beach
We are delighted to present this extraordinary opportunity, perfect for families or investors seeking a modern home in one of the most (...)
€1,095,000
EMPTY
- La Heredia, Costa Del Sol, Benahavis
Beds: 5 Baths: 4 M2: 333 Lot Size: 179 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 4 M2: 333 Lot Size: 179 Area: Benahavis Region: Andalucía
Located in the sought-after community of La Perla de la Heredia, on the Ronda road near Marbella, this exceptional five-bedroom townhouse offers a blend of comfort, style, and convenience. South to (...)
€1,750,000
TSEA5006665
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 138 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 138 Area: Marbella West Region: Andalucía
Nestled within the prestigious Benabola building in Puerto Banús, this exclusive frontline apartment captures the essence of luxury living on the Costa del Sol. Positioned directly in front of (...)
€495,000
TSEA5006434
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 93 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Estepona Region: Andalucía
Modern Apartment in Mirador del Golf, Estepona
This stylish and modern apartment in the exclusive Mirador del Golf in Estepona West offers a unique opportunity for those seeking peace, nature, and a (...)
€299,000
TSEA5006302
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 50 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Area: Fuengirola Region: Andalucía
Cozy apartment with 2 terraces for sale in Fuengirola close to all amenities. Set in a excellent quality building, this sunny one bed apartment offers a large terrace with morning sun ideal for (...)
€649,000
TSEA5006290
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 122 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Benahavis Region: Andalucía
JUST LISTED ! (One of the bigger apartments)
Maybe the best view Los Arqueros can offer and one of the best on the Costa del Sol.
Providing additional privacy and security the gated community is (...)
Current Featured Properties
€416,000
TSEA4804681
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
BRAND NEW DEVELOPMENT - GOLFERS PARADISE!!!
Located in one of the best areas of the Costa del Sol. This magnificent residential complex is located in one of the growing areas of Estepona, just 300 (...)
€415,000
New homes for a fantastic price!
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 83 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 83 Area: Marbella West Region: Andalucía
MINUTES TO PUERTO BANUS, FANTASTIC VALUE IN NUEVA ANDALUCIA.
The property of YOUR DREAMS for you and your family is in a new neighbourhood, surrounded by all the services you may need: schools, (...)
€389,000
TSEA5137942
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Now available –
This stunning modern apartment in Estepona offers an unbeatable combination of comfort, style, and location. Situated on the 6th floor, this bright and spacious property enjoys (...)
