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 (36,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 (36,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 (36,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 3781 - 3800 of 3897 €475,000
TSEA4179376
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 112 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Marbella Region: Andalucía
Marina Terraces!
Has Tourist licence!
This 3-bedroom, 2-bathroom condo is move-in ready! It has everything you can imagine! Recently refurbished and with garage and storage!
housing: 112 m2 plus 32 (...)
€730,000
TSEA4178665
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
RENTED UNTIL 1 SEPTEMBER
Spectacular flat with partial sea views in Marina Banús. It has two bedrooms in the centre of PUERTO BANUS, the most exclusive area of Marbella, a few meters from the (...)
€1,100,000
TSEA4178443
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 140 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Marbella West Region: Andalucía
Puerto Banus, 3 bedrooms and 3 bathrooms apartment with sea views.
This south facing apartment is located in the heart of Puerto Banus, the famous marina of Marbella. It was recently completely (...)
€430,000
TSEA4175497
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 103 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Estepona Region: Andalucía
AMAZING GOLF DEVELOPMENT!!!
This is the new residential development in Estepona Golf, at the heart of the Costa del Sol, a privileged location close to wonderful beaches such as Bahía Dorada, or (...)
€375,000
TSEA4175446
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
IF YOU LOVE GOLF YOU WILL LOVE THIS DEVELOPMENT!!
This is the new residential development in Estepona Golf, at the heart of the Costa del Sol, a privileged location close to wonderful beaches such as (...)
€585,000
TSEA4164577
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 130 Lot Size: 210 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 210 Area: Marbella East Region: Andalucía
BEACHFRONT HOME FOR SALE - LIVE THE BEACH LIFE YOU'VE ALWAYS WANTED!!
This middle floor apartment located in Elviria, Marbella East is a great investment opportunity for those who love the beachfront (...)
€1,295,000
TSEA4159744
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 325 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 325 Area: Estepona Region: Andalucía
Check out this amazing ground floor apartment that has been fully renovated! It features 5 bedrooms and 5.5 bathrooms, with a spacious 400 m2 private garden. The apartment itself is 385 m2 and is (...)
€695,000
TSEA4158790
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 221 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 221 Area: Marbella Region: Andalucía
The apartment has a large entrance hall with a built-in wardrobe, to the right you have a large living room with a dining area, a storeroom/storage room and a view of the large terrace with (...)
€895,000
TSEA4154554
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 150 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Area: Benahavis Region: Andalucía
THE PROPERTY
I present to you an exquisite apartment with two bedrooms and two bathrooms in Reserva de Alcuzcuz, a prestigious location in Benahavis, which combines luxury, comfort and impressive (...)
€415,000
TSEA4148092
- San Roque, Costa Del Sol, San Roque
Beds: 2 Baths: 2 M2: 98 Area: San Roque Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: San Roque Region: Andalucía
OASIS OF TRANQUILITY CLOSE TO BEACHES.
New release! A great opportunity to buy an off plan apartment at an UNBEATABLE PRICE. The apartment style is light and bright with large open plan living (...)
€352,430
TSEA4132522
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 97 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Mijas and Mijas Costa Region: Andalucía
New residential in Mijas Costa, Malaga. The private urbanization has 54 homes with 2 and 3 bedrooms distributed in 3 blocks, 3 stories high, including penthouses with large terraces that will enjoy (...)
€560,000
TSEA4131643
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
This wonderful bright & spacious three bedroom two bathroom middle floor corner apartment situated within one of the best developments in Los Arqueros Golf and Country Club. The property further (...)
€1,100,000
TSEA4126801
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 180 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 180 Area: Marbella East Region: Andalucía
Great INvestment - return holiday rental 6%-7% per year - 2 AMAZING BEACHFRONT refurbished apartments earn directly income with existing bookings. Situated on top of each other- each 2 bedrooms 2 (...)
€732,000
Middle Floor Apartment in Atalaya
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 121 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Area: Estepona Region: Andalucía
FANTASTIC LOCATION NEAR MARBELLA!!!
A new development of apartments (2 or 3 bedrooms available) in the privileged area of Atalaya. This area is close to all services and surrounded by golf (...)
€535,000
TSEA4122289
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 111 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Area: Casares Region: Andalucía
PROVIDING MAXIMUM COMFORT!!!
This is a gated development with a total of 58 apartments with 2 or 3 bedrooms, distributed over 4 buildings which offer ground-floor homes with private gardens, (...)
€499,500
TSEA4117507
- Torre del Mar, Costa Del Sol East
Beds: 4 Baths: 2 M2: 170 Lot Size: 170 Region: Andalucía
Beds: 4 Baths: 2 M2: 170 Lot Size: 170 Region: Andalucía
Exclusive duplex penthouse in the heart of Torre del Mar, next to the promenade, and within walking distance of bars, restaurants and stores. It ́s also next to the emblematic Paseo Larios. The (...)
€510,000
TSEA4116655
- Málaga Este, Costa Del Sol, Malaga City
Beds: 2 Baths: 2 M2: 74 Area: Malaga City Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Malaga City Region: Andalucía
VIEWS THAT SEEM TO GO ON FOR MILES!!!!
This is an exclusive development with terraces and sea views enabling you to wake up to views of the Mediterranean horizon. A total of 41 south- and southeast (...)
€299,000
TSEA4116121
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Estepona Region: Andalucía
Middle Floor Apartment, Estepona, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 70 m², Terrace 6 m².
Setting : Beachfront, Beachside, Close To Port, Close To Sea, Close To Town, Close To Schools, (...)
€114,000
TSEA4114567
- Bel Air, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 61 Lot Size: 10 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 61 Lot Size: 10 Area: Estepona Region: Andalucía
Introducing Your Perfect Investment Opportunity: Studio Apartment in Modern Resort Complex
Welcome to your own slice of paradise in the heart of the Costa del Sol. Nestled within a modern resort (...)
€1,100,000
TSEA4112719
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 200 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 200 Area: Marbella West Region: Andalucía
Ideal location for this 4 bed duplex penthouse property located in the heart of the famous Puerto Banús, surrounded by shops, bars and restaurants and with beaches only a few minutes walk away, no (...)
Current Featured Properties
€379,000
TSEA5138899
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 51 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Estepona Region: Andalucía
This is not simply a place to live. It's a lifestyle ecosystem. From sunrise swims in your private pool to sunset walks along the coastal path, this is more than just a home — it's a (...)
€2,695,000
TSEA5143117
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Located between Marbella and Estepona, Bahía del Velerín is a prestigious community with a beautiful pool area, a snack bar, lush tropical gardens, and 24/7 security.
This fully renovated penthouse (...)
€287,000
TSEA4748761
- Valle Romano, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 73 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 73 Area: Estepona Region: Andalucía
The residential complex has a total of 135 properties with 1, 2 or 3 bedrooms in 6 low-rise buildings. The modern, attractive design features clean, contemporary lines. The privileged south-facing (...)
