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 2641 - 2660 of 3911
€329,500
TSEA4742488
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 95 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Manilva Region: Andalucía
New Development: Prices from 329,500 € to 503,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 95.00 m2 - 136.00 m2]
2 bedroom homes next to the sea in Manilva
When you decide to take a few (...)
€480,000
TSEA4907815
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
New Development: Prices from 480,000 € to 542,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 91.00 m2 - 109.00 m2]
This is a development of 51 homes with terrace of 2, 3 and 4 bedrooms (...)
€549,000
TSEA4969039
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 123 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 123 Area: Marbella East Region: Andalucía
SHORT TERM RENTAL AVAILABLE IN THE COMPLEX!!
Spacious Apartment in a Quiet Community with Tropical Gardens – Las Lomas del Marbella Club on The Golden Mile.
Located in an exclusive low-density (...)
€120,000
TSEA4968961
- Manilva, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 69 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 69 Area: Manilva Region: Andalucía
GREAT INVESTMENT OPPORTUNITY
Nice and cosy apartment for sale in Manilva. The apartment has one bedroom, one bathroom, equipped kitchen and living room. It is situated in an authentic Andalusian (...)
€206,000
TSEA4968868
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 55 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 55 Area: Fuengirola Region: Andalucía
Ground Floor Apartment, Fuengirola, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 55 m², Terrace 6 m².
Setting : Town, Beachside, Village, Close To Port, Close To Shops, Close To Sea, Close To (...)
€465,000
TSEA4968784
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 108 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Benalmadena Region: Andalucía
Spectacular flat of recent construction in an exclusive urbanization of Benalmadena!
It stands out for its contemporary design, high quality finishes and a distribution designed for maximum (...)
€769,000
TSEA4968763
- Higueron, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 131 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Area: Fuengirola Region: Andalucía
Best pool area and desirable sea views highlight this modern apartment in Higuerón West.
This particular apartment enjoys what many consider the best pool area in all of Higueron West. Beyond the (...)
€590,000
TSEA4968712
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 81 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Marbella West Region: Andalucía
Discover the perfect blend of luxury and convenience with this spectacular 2-bedroom, 2-bathroom penthouse in the prestigious La Dama de Noche Urbanization. Enjoy breathtaking mountain views and (...)
€430,000
TSEA4968664
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Exceptional apartment on the beachfront with spectacular sea views.
With its south orientation we will enjoy many hours of sunshine while admiring the blue of the Mediterranean.
Great opportunity for (...)
€575,000
TSEA4968553
- Higueron, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 92 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Fuengirola Region: Andalucía
This beautiful 2 bedroom and 2 bathroom apartment is located in the highly sought-after Higueron West, on the border of Fuengirola and Benalmadena. The bright and airy home boasts stunning views of (...)
€499,000
TSEA4968496
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 82 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 82 Area: Marbella West Region: Andalucía
For Sale: Fully Renovated 3-Bedroom Apartment in Aloha Royal, Nueva Andalucía, Marbella – €499,000
A rare opportunity to own a fully renovated, modern 3-bedroom, 2-bathroom apartment in the (...)
€585,000
TSEA4968484
- Centro Histórico, Costa Del Sol
Beds: 2 Baths: 2 M2: 125 Region: Andalucía
Beds: 2 Baths: 2 M2: 125 Region: Andalucía
Welcome to a new luxury building located in the heart of Malaga's Centro Histórico.
This totlay renovated floor apartment is a true gem. This luxurious residence offers a perfect blend of (...)
€225,000
TSEA4968064
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Excellent apartment with 2 bedrooms and 1 bathroom, living room and kitchen. It has 61 m2 built and the building is from 2006. Elevator. Located next to the main square of Los Pacos with all services (...)
€499,000
TSEA4967974
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 133 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 133 Area: Estepona Region: Andalucía
Brand new apartment for sale. Consists of 3 bedrooms, 2 bathrooms, living room with open plan kitchen and terrace with sea views. The orientation is south and the apartment is very bright. The (...)
€295,000
TSEA4967902
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 57 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 57 Area: Estepona Region: Andalucía
Charming partly renovated apartment in Estepona's old town.
Tucked away on a peaceful street, yet just a three-minute walk from the bustling main street with its lively shops, bars, and restaurants. (...)
€495,000
TSEA4967893
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
LUXURIOUS DUPLEX PENTHOUSE WITH PANORAMIC SEA & MOUNTAINS VIEWS IN SELWO, ESTEPONA
2 parking spaces + 1 storage room included!
Welcome to this stunning duplex penthouse nestled in the tranquil (...)
€650,000
TSEA4967812
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 133 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Marbella Region: Andalucía
Two-Bedroom Apartment in Los Altos de Marbella
Nestled in the exclusive gated community of Los Monteros Hill Club, this elegant two-bedroom apartment offers breathtaking panoramic views over the (...)
€375,000
TSEA4967605
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 121 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 121 Area: Marbella East Region: Andalucía
Exclusive 2 bed, 2 bath apartment with panoramic sea views in Elviria
Imagine waking up every morning to stunning panoramic sea views. Located in the highly sought-after Elviria area, this (...)
€580,000
TSEA4967548
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 105 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Marbella West Region: Andalucía
This stylish two-bedroom apartment enjoys a privileged west-facing orientation, offering breathtaking views of both the sea and the surrounding mountains. Located in the heart of Puerto Banús, this (...)
€690,000
TSEA4967503
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
This fully renovated 2-bedroom apartment for sale in Nueva Andalucía, Marbella is an exceptional opportunity to own a stylish home in the heart of the prestigious Golf Valley. Perfectly located (...)
Current Featured Properties
€708,000
TSEA4766230
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 96 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 96 Area: Estepona Region: Andalucía
Apartments and penthouse apartments with 2, 3 and 4 bedrooms in Selwo, Estepona this is a place where the sea and nature become one, with stunning Mediterranean sea views.
Located in an exceptional (...)
€599,000
TSEA4742524
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 113 Lot Size: 48 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 113 Lot Size: 48 Area: Estepona Region: Andalucía
Located on the Costa del Sol, this boutique complex of 24 homes overlooks the Mediterranean and offers a wonderful spectacle of light and tranquility. Live the lifestyle you deserve in this dreamlike (...)
€587,000
Middle Floor Apartment in Los Monteros
- Los Monteros, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
LUXURY TO ITS HIGHEST STANDARD!!!
A development of 39 luxury apartments. Located in the upper part of Los Monteros, this contemporary design development distributed over 5 floors plus an attic, has (...)
