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,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 (39,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 (39,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 881 - 900 of 1810
€689,900
TSEA4914382
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
New Development: Prices from 689,900 € to 1,599,900 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 105.00 m2 - 160.00 m2]
This development stands out as an exclusive residential complex with (...)
€549,000
TSEA4405957
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2 Baths: 2 M2: 87 Area: Algeciras Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Algeciras Region: Andalucía
New Development: Prices from 549,000 € to 1,245,000 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 87.00 m2 - 136.00 m2]
With so many amenities to enjoy all year round, 300+ days of sunshine, and (...)
€485,000
TSEA5036320
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 79 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 79 Area: Estepona Region: Andalucía
New Development: Prices from 485,000 € to 949,000 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 79.00 m2 - 129.00 m2]
This development is located in Estepona, one of the most popular and (...)
€525,000
TSEA4913860
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Estepona Region: Andalucía
New Development: Prices from 525,000 € to 720,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 87.00 m2 - 107.00 m2]
New residential project of 2 and 3 bedroom apartments located in Estepona (...)
€429,990
TSEA5036299
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 3 M2: 200 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 3 M2: 200 Area: Mijas and Mijas Costa Region: Andalucía
This amazing townhouse in Lauro golf resort offers an amazing amount of space, stunning views and a great gated community within proximity of Malaga city center.
The property is located frontline (...)
€370,000
TSEA4885012
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 86 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Manilva Region: Andalucía
New Development: Prices from 370,000 € to 571,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 86.00 m2 - 118.00 m2]
This is a development with 100 apartments in a magnificent residential area (...)
€743,000
TSEA4885018
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 119 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 119 Area: Estepona Region: Andalucía
New Development: Prices from 743,000 € to 1,338,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 119.00 m2 - 143.00 m2]
The residence offers an exceptional collection of 21 homes, which (...)
€585,000
TSEA5036284
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 176 Lot Size: 28 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 176 Lot Size: 28 Area: Marbella East Region: Andalucía
LARGE CORNER APARTMENT WITH GARDEN AND TERRACE, parking space and storage room in El Manantial de Santa María, Elviria ·
This bright apartment, in good condition, loved and well-kept by current (...)
€620,000
TSEA4720933
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 91 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 91 Area: Estepona Region: Andalucía
New Development: Prices from 620,000 € to 1,250,000 €. [Beds: 2 - 3] [Baths: 3 - 3] [Built size: 91.00 m2 - 109.00 m2]
BOUTIQUE RESIDENTIAL COMPLEX — 15 EXCLUSIVE APARTMENTS
Located just 220 (...)
€570,000
TSEA4591552
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 570,000 € to 880,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 76.00 m2 - 97.00 m2]
BOUTIQUE RESIDENTIAL COMPLEX — 36 APARTMENTS
EVEN GROUND FLOORS WITH SEA (...)
€349,950
TSEA4905535
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 75 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Fuengirola Region: Andalucía
New Development: Prices from 349,950 € to 879,950 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 75.00 m2 - 335.00 m2]
An exclusive new residential complex
Consisting of two buildings with 74 (...)
€1,495,000
TSEA4967602
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 129 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 129 Area: Benahavis Region: Andalucía
New Development: Prices from 1,495,000 € to 4,950,000 €. [Beds: 2 - 5] [Baths: 2 - 5] [Built size: 129.00 m2 - 402.00 m2]
An exceptional high-end gated community of 16 villas and 50 (...)
€584,500
TSEA3607109
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 111 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: Casares Region: Andalucía
New Development: Prices from 584,500 € to 1,062,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 111.00 m2 - 151.00 m2]
This development stands on a hill, in what is considered the "Best (...)
€420,000
TSEA4793359
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 78 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Casares Region: Andalucía
New Development: Prices from 420,000 € to 708,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 78.00 m2 - 118.00 m2]
The development is located within the Casares Costa Golf course and it has (...)
€537,000
TSEA5011204
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2 Baths: 2 M2: 84 Area: Algeciras Region: Andalucía
Beds: 2 Baths: 2 M2: 84 Area: Algeciras Region: Andalucía
New Development: Prices from 537,000 € to 849,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 84.00 m2 - 136.00 m2]
The project is located in La Alcaidesa.
La Alcaidesa, located between La (...)
€695,000
TSEA5034877
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 92 Lot Size: 76 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Lot Size: 76 Area: Fuengirola Region: Andalucía
Welcome to an extraordinary new chapter in luxury living an exclusive enclave of 160 state-of-the-art apartments nestled within the prestigious Higueron Resort, one of Costa del Sol's crown jewels. (...)
€710,000
TSEA5034796
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 3 M2: 200 Lot Size: 70 Area: Marbella Region: Andalucía
Beds: 2 Baths: 3 M2: 200 Lot Size: 70 Area: Marbella Region: Andalucía
EL CAPRICHO - CORNER TOWNHOUSE WITH OWN SWIMMING POOL
GUADALPIN AREA - MARBELLA - GOLDEN MILE
Great property in the sought after area of El Capricho (Nagueles bajo). Exceptional location given the (...)
€279,000
TSEA4451011
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 98 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Manilva Region: Andalucía
New Development: Prices from 279,000 € to 473,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 98.00 m2 - 133.00 m2]
This innovative real estate project consists of 60 multi-family dwellings, (...)
€464,000
TSEA4777519
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 99 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 99 Area: Algeciras Region: Andalucía
New Development: Prices from 464,000 € to 743,000 €. [Beds: 3 - 4] [Baths: 2 - 3] [Built size: 99.00 m2 - 147.00 m2]
After the great success of phase 1, we are launching the second phase, the (...)
€205,000
TSEA5034682
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
Charming 1-Bedroom Apartment with Sea Views in Pueblo Los Olivos, Riviera del Sol
Nestled in the well-maintained community of Pueblo Los Olivos, this bright and inviting 1-bedroom, 1-bathroom (...)
Current Featured Properties
€404,400
TSEA5018557
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 97 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Area: Benalmadena Region: Andalucía
This brand new development is located on Calle Menta in Benalmadena (Málaga). It is the new residential in Benalmadena, Málaga. The private urbanization has 70 homes of 2 and 3 bedrooms, in (...)
€720,000
TSEA4939045
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
This new development is integrated in a privileged natural environment with views over the bay of Estepona and the mountains of Marbella, very close to the sea and very well connected. A project of (...)
€535,000
TSEA5063977
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
