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 (42,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 (42,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 (42,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 441 - 460 of 5891
€1,995,000
TSEA5143321
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 336 Lot Size: 1,028 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 336 Lot Size: 1,028 Area: Marbella West Region: Andalucía
Nestled in a quiet cul-de-sac and within walking distance of shops and local services, this villa offers an ideal setting for relaxed family living in Nueva Andalucía. Recently renovated with taste (...)
€295,000
TSEA5143276
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Exclusive Apartment with Terrace and Parking in a Luxury Residential Complex – 5 Minutes from the Beach and Town Centre
Located in one of the most exclusive residential areas, this apartment (...)
€410,000
TSEA5143219
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 150 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Manilva Region: Andalucía
Stunning Seafront Apartment in Sotogrande with Gibraltar Views
Discover this spacious and bright 150 m² apartment in the heart of Sotogrande, offering breathtaking views of the sea and the iconic (...)
€795,000
TSEA5143135
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 191 Lot Size: 773 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 191 Lot Size: 773 Area: Estepona Region: Andalucía
Charming Andalusian Villa in Arena Beach, Estepona
This beautifully renovated independent villa combines traditional Andalusian charm with a fresh, contemporary style, creating the perfect home for (...)
€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 (...)
€2,395,000
TSEA5143105
- 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
This southwest-facing, fully renovated 3-bedroom, 2-bathroom apartment offers an exceptional blend of style, comfort, and panoramic views over subtropical gardens and the Mediterranean Sea. The (...)
€220,000
TSEA5143093
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 48 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 48 Area: Mijas and Mijas Costa Region: Andalucía
New to the market!
One bedroom, one bathroom apartment for sale in La Cala De Mijas
A very rare opportunity to purchase a 1 bedroom, 1 bathroom property, on a beautiful urbanisation in La Cala de (...)
€410,000
TSEA5143036
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 111 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: La Duquesa Region: Andalucía
Discover Paradise: Stunning Penthouse with Panoramic Sea Views and Direct Beach Access
Breathtaking Views and Space: Enjoy 180º panoramic sea views from a massive 110 m² terrace, complemented by (...)
€249,500
TSEA5143003
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
Middle Floor Apartment, Benalmadena, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 49 m².
Possibility of turistic licence
Setting : Town, Urbanisation.
Condition : Excellent.
Features : Covered (...)
€1,550,000
TSEA5142997
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 8 M2: 277 Lot Size: 2,484 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 8 M2: 277 Lot Size: 2,484 Area: Mijas and Mijas Costa Region: Andalucía
UNIQUE OPPORTUNITY JUST OUTSIDE MIJAS PUEBLO!
This breathtaking group of properties don´t come onto the market too often. If you are looking to have a place where all of your loved ones can come (...)
€629,000
TSEA5142994
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Spacious Ground-Floor Apartment with Private Garden
This bright and spacious ground-floor apartment offers the perfect balance between comfort, style, and outdoor living. With 3 bedrooms and 2 (...)
€319,000
TSEA5142985
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 143 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 143 Area: Mijas and Mijas Costa Region: Andalucía
Discover this spectacular frontline golf penthouse. With a completely renovated and tastefully decorated design, this home features two spacious bedrooms and two full bathrooms, perfect for enjoying (...)
€325,000
TSEA5142982
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 85 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Benalmadena Region: Andalucía
Discover your new home in this spectacular, fully renovated apartment, just a 5-minute walk from the beach! With a charming terrace offering stunning sea views, this space is perfect for enjoying the (...)
€375,000
TSEA5142817
- Costalita, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 83 Lot Size: 40 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Lot Size: 40 Area: Estepona Region: Andalucía
Quaint 2 bedroom attached single level bungalow.
The home is located beachside of the A7 just steps away from Saladillo beach in Costalita.
The house features an open plan lounge, dining, kitchen and (...)
€309,000
TSEA5142808
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Middle Floor, 2 Bed, 2 Bath Apartment in Mijas, Costa del Sol
Discover this charming middle-floor apartment located in the picturesque area of Mijas, Costa del Sol. This property offers an ideal (...)
€850,000
TSEA5142802
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 5 Baths: 4 M2: 317 Lot Size: 600 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 4 M2: 317 Lot Size: 600 Area: Benalmadena Region: Andalucía
Discover this detached villa in one of the most exclusive areas of Benalmádena Costa, perfectly positioned for its privileged location and exceptional potential.
Set on a 600 m² plot, the villa (...)
€429,000
TSEA5142796
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 77 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Marbella East Region: Andalucía
This is a great apartment for sale tight in the famous port of Cabopino in East Marbella. Originally this was a very large 1 bedroom apartment, but the owner has cleverly converted it into a two (...)
€390,000
TSEA5142793
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 59 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 59 Area: Estepona Region: Andalucía
Elegant Penthouse with Rooftop Jacuzzi and Breathtaking Sea Views
This beautifully renovated penthouse is located in the sought-after Sun Gardens urbanization in Estepona East. The community offers (...)
€300,000
TSEA5142781
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 119 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 119 Area: Estepona Region: Andalucía
Fully Renovated Duplex Penthouse with Enclosed Terrace & Private Parking
Experience comfort and exclusivity in this fully renovated duplex penthouse, where the owners have added numerous extras (...)
€1,275,000
TSEA5142778
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 219 Lot Size: 930 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 219 Lot Size: 930 Area: Fuengirola Region: Andalucía
Key-Ready 3-Bedroom Villa with Panoramic Views in Torreblanca, Fuengirola!
Step into your perfect Mediterranean retreat with this stunning, modern and key-ready villa in the lovely area of (...)
Current Featured Properties
€599,000
TSEA4851742
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
This development offers 36 beautiful single-storey homes with large rooms, the option of 2 or 3 bedrooms, 2 bathrooms and large terraces with beautiful panoramic views. They have a fully equipped (...)
€995,000
TSEA4777597
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
LIGHT FLOODS INTO THE PROPERTY!!!
We will change weight for square meters, color for avant-garde architectural design, clarity for light and size for the best qualities and certified construction (...)
€1,485,000
TSEA5115535
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 136 Lot Size: 195 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 136 Lot Size: 195 Area: Estepona Region: Andalucía
NEW DEVELOPMENT – Elegance and Exclusivity on the Costa del Sol!
Discover this new luxury project, a prestigious complex of 14 independent villas located in an exceptional setting in Estepona, (...)
