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 101 - 120 of 1080 €1,100,000
TSEA5140939
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 112 Lot Size: 68 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Lot Size: 68 Area: Benahavis Region: Andalucía
The luxurious 3-bedroom ground floor apartment is located in Aqualina residences with a south-facing orientation and views of the swimming pool and the sea and offers the latest technology and (...)
€420,000
TSEA5140726
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 87 Lot Size: 148 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Lot Size: 148 Area: Casares Region: Andalucía
Fantastic corner ground-floor apartment in an elevated position, in perfect condition, with a spacious, open-plan modern kitchen. The living-dining room is very bright and luminous thanks to its (...)
€410,000
TSEA5140060
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 172 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 172 Area: San Pedro Region: Andalucía
It is the perfect opportunity in a privileged environment next to the golf course, to design the home of your dreams. Located in a gated community with all amenities, it offers security, exclusivity, (...)
€415,000
TSEA5139883
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 103 Lot Size: 18 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Lot Size: 18 Area: Marbella East Region: Andalucía
Beautiful 3 bedrooms and 2 bedroom groundfloor apartment in the hills above Elviria, La Mairena!
This sunny sea view garden apartment located in the east of Marbella, offers a great south
west (...)
€328,900
TSEA5139784
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 56 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 56 Area: Fuengirola Region: Andalucía
New Development: Prices from 328,900 € to 403,900 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 56.00 m2 - 63.00 m2]
Discover our two- and three-bedroom apartments and penthouses, each designed (...)
€450,000
TSEA5139157
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 1 Baths: 1 M2: 81 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 1 M2: 81 Area: Marbella East Region: Andalucía
Position is the key of this East-facing one bedroom two bathroom garden apartment overlooking the gardens and pools of the popular La Carolina Park complex. The extensive communal gardens, two (...)
€305,000
TSEA5139082
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 102 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 102 Area: Estepona Region: Andalucía
Spacious renovated apartment in Selwo – La Resina, featuring 3 bedrooms and 3 bathrooms.
It offers a sunny south-facing terrace with sea views. Located in a quiet community,
it includes communal (...)
€246,000
TSEA5139061
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 66 Lot Size: 15 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 66 Lot Size: 15 Area: Mijas and Mijas Costa Region: Andalucía
Ground Floor Apartment, Riviera del Sol, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 66 m², Terrace 10 m², Garden/Plot 15 m².
Setting : Suburban, Close To Golf, Close To Sea, Close To Town, (...)
€395,000
TSEA5139040
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 100 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 100 Area: Marbella West Region: Andalucía
Beautiful and modern apartment in the heart of Nueva Andalucía. Great location.
The apartment has two bedrooms and one bathroom. 145 m2 with a private terrace.
Fully equipped.
It doesn't have a (...)
€1,099,000
TSEA5138932
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 133 Lot Size: 110 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 133 Lot Size: 110 Area: San Pedro Region: Andalucía
New apartment for sale in a newly built building.
Fantastic ground floor apartment with private garden.
A resale of the new apartment. Take advantage of the opportunity!
It is a new residential (...)
€395,000
TSEA5138917
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Charming 2-Bedroom Apartment – 5 Minutes from the Beach
Enjoy relaxed coastal living in this beautifully renovated 2-bedroom, 2-bathroom apartment in the heart of Riviera del Sol. Bright and (...)
€610,000
TSEA5138908
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
NEW ON THE MARKET! Fantastic apartment that combines a modern and elegant style to create the perfect space for your future home.
The property welcomes you at the entrance with a bright, modern (...)
€259,000
TSEA5138674
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
Brand-New 2-Bedroom Apartment in Las Laguna de Mijas.
This spacious 2-bedroom apartment combines modern architecture, premium-quality finishes, and a practical layout, creating the perfect home on (...)
€650,000
TSEA5138050
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Discover an Exclusive Ground-Floor Apartment at ONE Residences
We are excited to introduce a unique opportunity to purchase a stunning ground-floor apartment in ONE Residences, a prestigious (...)
€450,000
TSEA5137945
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 127 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Benalmadena Region: Andalucía
Luxurious Ground Floor Apartment for Sale at Golf Resort Torrequebrada, Benalmadena
Overview
Discover an exceptional opportunity to own a beautiful apartment in the prestigious Golf Resort (...)
€340,000
TSEA5137936
- Rincón de la Victoria, Costa Del Sol East
Beds: 2 Baths: 1 M2: 75 Region: Andalucía
Beds: 2 Baths: 1 M2: 75 Region: Andalucía
Beachfront investment with guaranteed income if you want.
Secure your place on the Costa del Sol with a rare beachfront property that already delivers stable rental income. Rented until the end of (...)
€295,000
TSEA5137750
- Benavista, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 65 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 65 Area: Estepona Region: Andalucía
55 m2 of coziness!!! Recently renovated 2 bedroom 1 bathroom apartment in Benavista.
Very well located, walking distance to shops, restaurants and beach. Urbanisation offers a big communal pool and (...)
€375,000
TSEA5136754
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 70 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Marbella Region: Andalucía
New Development: Prices from 375,000 € to 550,000 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 70.00 m2 - 192.00 m2]
Welcome to your new home, located in Nueva Andalucía, just minutes from (...)
€365,000
TSEA5136481
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 103 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: Mijas and Mijas Costa Region: Andalucía
Elevated ground floor apartment (2 bed/2bath) in upper Calahonda. Open kitchen with a larger than usual washing room. The dining/living room with a fire place, gives access to a partly glassed in (...)
€249,000
TSEA5136109
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 72 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 72 Area: Estepona Region: Andalucía
Located in a privileged area, just a one-minute walk from Estepona's marina, with shops, supermarkets, restaurants, and public transport all within easy reach. The famous El Cristo Beach is less than (...)
Current Featured Properties
€476,700
TSEA4289707
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 118 Lot Size: 20 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Lot Size: 20 Area: Benahavis Region: Andalucía
A HOME YOU WILL NEVER WANT TO LEAVE!!!
The homes in this development are designed to offer you everything you need. On the ground floor you will have a garden and wine cellar, and on the top floor (...)
€365,000
TSEA4545550
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
CLOSE TO FABULOUS PUERTO BANUS AND THE BEACHES.
Offering homes from 90m2 to 150m2 with finishes of first QUALITY AND MODERN design. All have a large private terrace, garage space in the building (...)
€4,995,000
TSEA4445479
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 138 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Area: Marbella Region: Andalucía
This is a stunning modern apartment sporting sea views within the exclusive enclave of the Puente Romano Resort on the Marbella Golden Mile. The apartment exudes seaside sophistication, embracing its (...)
