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 3941 - 3960 of 7575
€2,350,000
TSEA5007925
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Stylish Beachfront Living on the New Golden Mile
If you are after a relaxed, high-end lifestyle by the sea, this fully renovated beachfront apartment may be just the thing. Tucked away in one of (...)
€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 (...)
€795,000
TSEA5007526
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 182 Lot Size: 294 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 182 Lot Size: 294 Area: Benalmadena Region: Andalucía
This beautiful corner house is the epitome of comfort, elegance, and breathtaking views. Featuring 3 spacious bedrooms, each with access to its own private terrace, you'll be able to enjoy panoramic (...)
€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. (...)
€2,750,000
TSEA5007400
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 157 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 157 Area: Marbella East Region: Andalucía
Situated in the exclusive and tranquil community of Monte Paraiso on Marbella's prestigious Golden Mile, Marismas 1 is an exceptional duplex apartment refurbished by the renowned Oak Estates. (...)
€1,090,000
TSEA5007214
- Málaga, Costa Del Sol, Malaga
Beds: 7 Baths: 3 M2: 282 Lot Size: 282 Area: Malaga Region: Andalucía
Beds: 7 Baths: 3 M2: 282 Lot Size: 282 Area: Malaga Region: Andalucía
PRICE REDUCED!!! Magnificent corner house with panoramic sea views and 10 minutes from downtown.
*Some images are 3D recreations of how certain rooms would look refurbished.
We are pleased to (...)
€680,000
TSEA3607124
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 680,000 € to 930,000 €. [Beds: 1 - 2] [Baths: 1 - 2] [Built size: 92.00 m2 - 101.00 m2]
Stylish residential complex of 82 apartments in Mijas, built across two (...)
€721,000
TSEA4087276
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 169 Lot Size: 22 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 169 Lot Size: 22 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 721,000 € to 891,000 €. [Beds: 3 - 4] [Baths: 2 - 3] [Built size: 169.00 m2 - 170.00 m2]
TURNKEY!
This exclusive gated community offers 80 modern townhouses with 3 (...)
€5,200,000
TSEA4087282
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 436 Lot Size: 94 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 436 Lot Size: 94 Area: Marbella Region: Andalucía
New Development: Prices from 5,200,000 € to 5,600,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 436.00 m2 - 447.00 m2]
Located on the beachfront in Marbella, this development offers 64 (...)
€3,350,000
TSEA4153846
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 260 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 260 Area: Marbella Region: Andalucía
New Development: Prices from 3,350,000 € to 5,400,000 €. [Beds: 3 - 3] [Baths: 2 - 3] [Built size: 260.00 m2 - 312.00 m2]
Located on the beachfront in Marbella, this development offers 64 (...)
€381,000
TSEA4787134
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 98 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Casares Region: Andalucía
New Development: Prices from 381,000 € to 573,000 €. [Beds: 2 - 4] [Baths: 2 - 3] [Built size: 98.00 m2 - 179.00 m2]
This modern residential development comprises 134 homes with 2, 3, and 4 (...)
€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, (...)
€1,785,000
TSEA5007175
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 6 Baths: 7 M2: 465 Lot Size: 683 Area: Fuengirola Region: Andalucía
Beds: 6 Baths: 7 M2: 465 Lot Size: 683 Area: Fuengirola Region: Andalucía
Welcome to this spacious and charming home located in the popular area of Torreblanca in Fuengirola. This tasteful villa offers a total of 10 rooms, of which 6 bedrooms and 7 bathrooms. The (...)
€1,280,000
TSEA5007166
- Málaga, Costa Del Sol, Malaga
Beds: 5 Baths: 4 M2: 460 Lot Size: 1,100 Area: Malaga Region: Andalucía
Beds: 5 Baths: 4 M2: 460 Lot Size: 1,100 Area: Malaga Region: Andalucía
MAGNIFICENT VILLA WITH SEA VIEWS, FIVE MINUTES FROM THE SEA.
Century 21 Victoria is pleased to present this exclusive spectacular villa located in the best area of Malaga, Pinares de San Anton, 18 (...)
€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 (...)
€770,000
TSEA5006980
- San Roque, Costa Del Sol, San Roque
Beds: 5 Baths: 4 M2: 480 Lot Size: 1,000 Area: San Roque Region: Andalucía
Beds: 5 Baths: 4 M2: 480 Lot Size: 1,000 Area: San Roque Region: Andalucía
FANTASTIC 5-BEDROOM VILLA NEAR SOTOGRANDE
This property is located in a quiet residential area surrounded by nature. Close to Sotogrande and Gibraltar, both just a 15-minute drive away, and the (...)
€413,000
TSEA5003467
- Torrox, Costa Del Sol East
Beds: 4 Baths: 5 M2: 146 Lot Size: 181 Region: Andalucía
Beds: 4 Baths: 5 M2: 146 Lot Size: 181 Region: Andalucía
New Development: Prices from 413,000 € to 423,000 €. [Beds: 4 - 4] [Baths: 5 - 5] [Built size: 146.00 m2 - 147.00 m2]
We present to you this residential, an exciting new development currently (...)
€870,000
TSEA5003437
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 4 M2: 112 Lot Size: 137 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 4 M2: 112 Lot Size: 137 Area: Nerja and Malaga East Region: Andalucía
New Development: Prices from 870,000 € to 990,000 €. [Beds: 3 - 3] [Baths: 4 - 4] [Built size: 112.00 m2 - 112.00 m2]
We would like to tell you about this exciting new development promotion in (...)
Current Featured Properties
€318,250
TSEA4930297
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 54 Lot Size: 39 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 54 Lot Size: 39 Area: Mijas and Mijas Costa Region: Andalucía
We welcome you to this new development in Mijas a large multi-family building that offers 76 homes distributed over five floors plus an attic. The residential complex has common areas that include a (...)
€7,500,000
TSEA4797559
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 693 Lot Size: 340 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 693 Lot Size: 340 Area: Marbella East Region: Andalucía
YOU REALLY WILL WANT TO SEE THIS DEVELOPMENT!!!
The most exceptional new development, is currently underway on Marbella's fabled Golden Mile. With the most exclusive location, sublime design and just (...)
€570,000
TSEA4975855
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
LA PERLA DE LA HEREDIA , BENAHAVIS.
This charming townhouse is located in the cozy village of La Perla de la Heredia, just off Ronda Road. It faces south to southwest, offering lovely views of the (...)
