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 (39,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 (39,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 (39,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 61 - 80 of 1080
€495,000
TSEA5147920
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Live the Mediterranean Dream: Your Beachside Oasis in Calahonda Awaits
Discover the pinnacle of coastal living in this impeccable, ground-floor two-bedroom apartment, situated in a secure beachfront (...)
€540,000
TSEA5147887
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 130 Lot Size: 50 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 50 Area: Marbella West Region: Andalucía
Ground Floor Apartment, Nueva Andalucía, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 26 m², Garden/Plot 50 m².
Setting : Close To Schools, Urbanisation.
Orientation : East, (...)
€630,000
TSEA5147809
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 93 Lot Size: 139 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Lot Size: 139 Area: Fuengirola Region: Andalucía
Experience Contemporary Luxury in El Higuerón, Fuengirola
Discover this exclusive ground-floor apartment with a spacious private garden, designed in a modern and minimalist style in one of the most (...)
€585,000
TSEA5147521
- Elviria, 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
Spacious and bright ground floor apartment situated in a beachfront complex in Elviria.
The complex has a direct access to the beach, 2 open swimming pools (one is heated), beautiful well maintained (...)
€375,000
TSEA5147125
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 66 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 66 Area: Marbella Region: Andalucía
BEACHSIDE GROUND FLOOR APARTMENT – REFORM OPPORTUNITY IN MARBELLA DEL MAR
Fantastic opportunity in the sought-after Marbella del Mar complex, set directly on the beachfront and only 10 minutes' (...)
€110,000
TSEA5147050
- Manilva, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 44 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 44 Area: Manilva Region: Andalucía
Tourist Apartment for Sale in the PierVacanz Complex – Manilva (Málaga)
For Tourist Use Only – Not for Residential Living
Apartment for sale in the prestigious PierVacanz holiday complex, just (...)
€850,000
TSEA5146921
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 146 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 146 Area: Marbella East Region: Andalucía
This magnificent ground floor apartment is located in the heart of Marbella's famous Golden Mile — one of the most prestigious and sought-after areas on the Costa del Sol. A unique blend of (...)
€649,000
TSEA5146732
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 150 Lot Size: 20 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Lot Size: 20 Area: Casares Region: Andalucía
New apartment with a modern design, premium finishes, and fully furnished, ready to move in. It comes with three parking spaces and the option to acquire an additional one, along with a pre-installed (...)
€1,950,000
TSEA5146711
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 115 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Marbella Region: Andalucía
Beautiful apartment in a gated community Playa Esmeralda, located on beachfront, in Golden Mile, Marbella. The apartment has 2 bedrooms, 2 bathrooms (one in-suite), living room with access to the (...)
€497,000
TSEA5146264
- Rincón de la Victoria, Costa Del Sol East
Beds: 2 Baths: 2 M2: 107 Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Region: Andalucía
New Development: Prices from 497,000 € to 658,000 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 107.00 m2 - 164.00 m2]
Luxury modern-style development comprising 41 homes of the highest (...)
€425,000
TSEA5145922
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Beautiful flat located in the Pino Golf community in Elviria. Spacious ground floor flat facing west, overlooking the communal gardens and swimming pool.
It has two bedrooms, one of which is en (...)
€380,000
TSEA5145799
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
A lovely elevated ground floor apartment in the exclusive area of Selwo, Estepona.
Enjoy the stunning views across the sea to Africa from your covered terrace, or have a cooling dip in the communal (...)
€269,000
TSEA5145790
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 68 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 68 Area: Mijas and Mijas Costa Region: Andalucía
Unique Opportunity in Lower Riviera del Sol – Ground Floor Corner Apartment
Don't miss the chance to own this charming south-west facing ground floor corner apartment in the highly sought-after (...)
€495,495
TSEA5145751
- Campanillas, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 113 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Marbella Region: Andalucía
We present an innovative residential project that redefines the concept of living in Malaga. The development features a variety of homes, from one-bedroom apartments to four-bedroom penthouses, all (...)
€468,000
TSEA5145220
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Ground-Floor corner-Apartment with Panoramic Sea & Mountain Views –
The Perfect Investment,short-term rentals allowed and completely hassle-free!
Wake up to the Mediterranean, step onto (...)
€599,000
TSEA5145043
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 123 Lot Size: 128 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Lot Size: 128 Area: Mijas and Mijas Costa Region: Andalucía
Brand new fully furnished 3 bed apartment with a large sunny garden. This property has 3 spacious bedrooms and 2 bathrooms. The community offers luxury facilities that include an indoor pool, (...)
€780,000
TSEA5144722
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 142 Lot Size: 146 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 142 Lot Size: 146 Area: Marbella Region: Andalucía
Welcome to your dream getaway on the Costa del Sol — a bright and spacious apartment designed for effortless beachside living, just a 12-minute walk from the world-famous Puerto Banús.
Located (...)
€699,000
TSEA5144080
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 159 Lot Size: 21 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 159 Lot Size: 21 Area: Estepona Region: Andalucía
Welcome to your sun-kissed paradise on the sought-after New Golden Mile of Estepona, renowned for its sunny skies, golden sands and crystal-clear waters.
With just 25 stunning apartments, you'll get (...)
€569,000
TSEA5144038
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Welcome to your sun-kissed paradise on the sought-after New Golden Mile of Estepona, renowned for its sunny skies, golden sands and crystal-clear waters.
With just 25 stunning apartments, you'll get (...)
€360,000
TSEA5143873
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Your Oasis in La Cala de Mijas Awaits You!
Urbanización Ángel de Miraflores – Ground Floor with Private Garden and Communal Pool
We present to you this charming ground-floor apartment located in (...)
Current Featured Properties
€1,241,100
TSEA4964773
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 174 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 174 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
€418,500
TSEA4355662
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
A NEW DEVELOPMENT WHERE YOU WILL WANT TO LIVE!!!
This new development is a modern and functional gated residential complex, and an ideal place to live. The development consists of 46, two and three (...)
€467,250
TSEA3923275
- 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
CHARMING SPACIOUS APARTMENTS!!!
The apartments are specially designed to fully enjoy the charm of the Mediterranean lifestyle, but they are also designed with a Northern European vision. A well (...)
