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 (57,39,40,41,162,163)
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 (57,39,40,41,162,163)
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 (57,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (2652), Middle Floor - (2652), Penthouse - (2652), Top Floor Apartment - (2652), Penthouse Duplex - (2652)Properties
Results 201 - 220 of 3911
€695,000
TSEA5149942
- San Roque Club, Costa Del Sol
Beds: 3 Baths: 3 M2: 193 Region: Andalucía
Beds: 3 Baths: 3 M2: 193 Region: Andalucía
This elegant penthouse, fully renovated and beautifully decorated in a modern style, offers a unique living space in the exclusive setting of San Roque Club. With stunning sea views and surrounded by (...)
€280,000
TSEA5149936
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 71 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Casares Region: Andalucía
Penthouse with Solarium and Panoramic Sea Views in Casares Playa
This exclusive penthouse with a private solarium in Casares Playa combines space, natural light, and a privileged location on the (...)
€875,000
TSEA5149927
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 147 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 147 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular 3 bedrooms apartment with panoramic views of the sea facing the Calanova Golf Course.
The property is located in the middle of the complex, it enjoys fantastic views and privacy.
It has a (...)
€540,000
TSEA5149918
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Manilva Region: Andalucía
This stunning apartment is located in Los Granados de Duquesa, Manilva, Málaga, a prime beachfront location. Thoughtfully designed and in excellent condition, this property offers a luxurious and (...)
€359,000
TSEA5149888
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
This is a very attractive modern apartment located in an elevated spot above the beaches of Elviria and East Marbella. Located in the high end enclave of La Maiirena an area occupied by luxury (...)
€580,000
TSEA5149873
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 84 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 84 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€343,000
TSEA5149855
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 50 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 50 Area: Malaga Region: Andalucía
Tourist-Licensed Apartment in the Heart of Málaga – La Merced Area
Turnkey investment with proven high returns!
Located just a few steps from the iconic Plaza de la Merced, this modern apartment (...)
€370,000
TSEA5149840
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€475,000
TSEA5149831
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
The spacious apartment to reform with 2-bedroom, 2-bathroom (one en suite) is located in an exclusive frontline beach complex in Calahonda. Situated on the third floor with lift access, it boasts a (...)
€370,000
TSEA5149801
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€425,000
TSEA5148742
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
ELVIRIA. LOVELY APARTMENT WITH GREAT POTENTIAL SITUATED ON THE TOP FLOOR IN THE CENTRAL URBANIZATION OF PARQUE ELVIRIA. THE APARTMENT IS 105 m2 INCLUDING TERRACES. THE APARTMENT HAS 3 BEDROOMS AND 2 (...)
€400,000
TSEA5148733
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 1 Baths: 1 M2: 71 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 1 M2: 71 Area: Marbella East Region: Andalucía
Beautiful one bedroom apartment with spacious lounge dining room, fitted kitchen and terrace. Property has air conditioning, marble floors, 1 storage room and a parking space in the underground (...)
€185,000
TSEA5148727
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Discover the charm of this beautiful and spacious studio, which was originally a cozy one-bedroom apartment. Located in a prime location, you'll enjoy spectacular sea views from the comfort of your (...)
€315,000
TSEA5148703
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 78 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 78 Area: Torremolinos Region: Andalucía
FLAT FOR SALE IN TORREMOLINOS
Beautiful, sunny flat for sale, built in 2007 with high-quality finishes, located on the second floor of a building with a lift and only seven neighbours, completely (...)
€315,000
TSEA5148673
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
spacious 3 bed 2 bath apartment centrally located
large communal pool
in need of some updating
located close to shops and restaurants
Middle Floor Apartment, Las Lagunas, Costa del Sol.
3 (...)
€285,000
TSEA5148664
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic apartment located in Las Lagunas.
Discover this fantastic 126 m2 apartment located in the coveted area of Las Lagunas.
The property features three bedrooms, all equipped with (...)
€595,000
TSEA5148604
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 152 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 152 Area: Mijas and Mijas Costa Region: Andalucía
Bright and Spacious 3 Bed Corner Apartment with Stunning Views, Private Terrace and Premium Facilities
Welcome to this inviting 3-bedroom apartment in the sought-after Las Olas complex in (...)
€535,000
TSEA5148583
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
This four-bedroom flat, situated in the heart of Marbella, Malaga, presents an exceptional opportunity for those seeking a well-located property with substantial potential. Set within a gated (...)
€174,500
TSEA5148568
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 60 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Manilva Region: Andalucía
*** Walk Everywhere Apartment - No Car Necessary! ***
Charming apartment ideally located in the centre of San Luis de Sabinillas.
**** NOTE: This is a 1 bedroom and 1 bath apartment, however, it (...)
€590,000
TSEA5148544
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
For sale: an exclusive apartment located in one of the most sought-after residential areas of Nueva Alcántara, San Pedro de Alcántara. This property stands out for its spacious layout, prime (...)
Current Featured Properties
€665,000
TSEA4358878
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 112 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Fuengirola Region: Andalucía
A DEVELOPMENT THAT YOU WILL WANT TO VIEW!!!
Spectacular new development of 60 luxury apartments in the most sought-after area of El Higuerón, in a gated exclusive community with gym, heated pool, (...)
€542,000
TSEA4378108
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
FANTASTIC OPPORTUNITY IN BEAUTIFUL ESTEPONA.
This new development is located in Estepona just a short walk to the fabulous port and historic old town. The properties will be 2, 3 and 4 beds, with (...)
€527,000
TSEA4671382
- 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
PHASE 2 NOW FOR SALE! BRAND NEW IN A FANTASTIC DEVELOPMENT!!!
This is a development with 100 apartments in a magnificent residential area and in an extraordinary location.
The two and three-bedroom (...)
