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 421 - 440 of 5891
€360,000
TSEA5143873
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Your Oasis in La Cala de Mijas Awaits You!
Urbanización Ángel de Miraflores – Ground Floor with Private Garden and Communal Pool
We present to you this charming ground-floor apartment located in (...)
€545,000
TSEA5143834
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
This beautifully renovated 3-bedroom, 2-bathroom apartment is ideally situated just 150 meters from La Carihuela beach.
Designed with a smart layout and contemporary finishes, the interiors are both (...)
€185,000
TSEA5143828
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 1 Baths: 1 M2: 45 Area: San Pedro Region: Andalucía
Beds: 1 Baths: 1 M2: 45 Area: San Pedro Region: Andalucía
Ground floor apartment in the heart of San Pedro Alcantara with one bedroom. The location is unbeatable, very quiet and family-friendly. All kinds of services are close at hand, including schools, (...)
€685,000
TSEA5143825
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 5 M2: 287 Lot Size: 630 Area: Coin Region: Andalucía
Beds: 4 Baths: 5 M2: 287 Lot Size: 630 Area: Coin Region: Andalucía
STUNNING FOUR BEDROOM, FIVE BATHROOM VILLA
A must-see, substantially built and deceptively spacious, four-bedroom detached villa with four en-suite bathrooms, located within an exclusive and (...)
€475,000
TSEA5143807
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Top-Floor Living close to the Sea – Penthouse For Sale
Looking for something special? This bright and modern penthouse ticks all the boxes — stunning sea views, a spacious 40 m² terrace, and a (...)
€1,395,000
TSEA5143783
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 195 Lot Size: 420 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 195 Lot Size: 420 Area: San Pedro Region: Andalucía
Discover this spectacular modern design villa for sale! Located on a 420 m² plot and with 195 m² of usable area, this property offers an exclusive and sophisticated lifestyle. Upon entering, you'll (...)
€685,000
TSEA5143777
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 150 Lot Size: 20 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Lot Size: 20 Area: Casares Region: Andalucía
Discover Your Dream Home: Luxurious Brand-New Apartment in Casares Costa
Prime Location with Breathtaking Views: Enjoy stunning sea and mountain vistas from your private terrace in a south-facing (...)
€415,000
TSEA5143774
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 92 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 92 Area: Marbella Region: Andalucía
Stunning & Spacious 2-Bedroom Apartment in the Heart of Marbella
Discover your dream home in this beautiful 85 m² apartment (90 m² built) located in the vibrant Avenida General López (...)
€415,000
TSEA5143771
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 90 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 90 Area: Estepona Region: Andalucía
Top Floor Apartment, Estepona, Costa del Sol.
3 Bedrooms, 1 Bathroom, Built 90 m², Terrace 15 m².
Setting : Town, Close To Port, Close To Shops, Close To Sea, Close To Town, Close To Schools, (...)
€3,685,000
TSEA5143681
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 550 Lot Size: 1,805 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 550 Lot Size: 1,805 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 3,685,000 € to 3,685,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 550.00 m2 - 550.00 m2]
I am pleased to present a unique opportunity: the sale of an off-plan (...)
€675,000
TSEA5143657
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
This beautiful 3 bedroom 2 bathroom penthouse nestled in the heart of Nueva Andalucia must be seen. With an expansive terrace and solarium totally nearly 100 sqm means there is a multitude of outdoor (...)
€1,995,000
TSEA5143639
- 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
Bahía del Velerín is a prestigious community located between Marbella and Estepona. It boasts a beautiful pool area with a snack bar, lush tropical gardens, and 24/7 security. Set in a prime (...)
€2,995,000
TSEA5143633
- 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
Bahía del Velerín is a luxurious community between Marbella and Estepona. It has a fantastic pool area with a snack bar, tropical gardens and 24/7 security. The community is located at one of the (...)
€439,000
TSEA5143624
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 109 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 109 Area: Mijas and Mijas Costa Region: Andalucía
BACK ON THE MARKET !- Casa Banderas
Nice corner Garden Apartment with open Panoramic view towards Mijas Pueblo
2 Bedrooms/2 bathrooms with open plan kitchen
Very bright and close to all the (...)
€1,450,000
TSEA5143603
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 335 Lot Size: 956 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 335 Lot Size: 956 Area: Estepona Region: Andalucía
Step into a sunlit, character-filled family home where timeless Andalusian charm meets modern comfort. The ample sized open-plan kitchen, living, and dining area is flooded with light from (...)
€299,000
TSEA5143567
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 75 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 75 Area: Benalmadena Region: Andalucía
Apartment for sale in Benalmádena Costa - Puerto Marina
???? Beautiful apartment for sale in the heart of Benalmádena! Just a 1-minute walk from the famous Puerto Marina, this charming (...)
€359,000
TSEA5143450
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
This well-priced apartment in a popular complex offers a great opportunity to own a home on the Costa del Sol.
The property includes 2 bedrooms and 2 bathrooms, one of them en-suite, a fitted (...)
€630,000
TSEA5143432
- Río Real, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 107 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Area: Marbella East Region: Andalucía
This beautifully renovated two-bedroom apartment is situated in the iconic Torre de Río Real, one of Marbella's most renowned buildings. Located in the exclusive Río Real residential area in (...)
€3,995,000
TSEA5143360
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Discover a fully renovated, southwest-facing beachfront apartment in the prestigious Los Granados del Mar gated community. Perfectly positioned on the New Golden Mile between Marbella and Estepona, (...)
€3,200,000
TSEA5143342
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 718 Lot Size: 2,000 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 718 Lot Size: 2,000 Area: Benalmadena Region: Andalucía
New Development: Prices from 3,200,000 € to 3,200,000 €. [Beds: 4 - 4] [Baths: 5 - 5] [Built size: 718.00 m2 - 718.00 m2]
The villa is located in a privileged setting, within the exclusive (...)
Current Featured Properties
€2,995,000
TSEA5143633
- 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
Bahía del Velerín is a luxurious community between Marbella and Estepona. It has a fantastic pool area with a snack bar, tropical gardens and 24/7 security. The community is located at one of the (...)
€1,890,000
MORE THAN JUST A VILLA...A REFLECTION OF WHO YOU ARE !
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 602 Lot Size: 756 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 602 Lot Size: 756 Area: Benahavis Region: Andalucía
MORE THAN JUST A VILLA...A REFLECTION OF WHO YOU ARE!!!
A truly UNIQUE AND SPECIAL project. There is nowhere else quite like this. Designed especially for you where an authentic philosophy of life (...)
€829,900
TSEA5083897
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 140 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Area: Fuengirola Region: Andalucía
This brand new development stands out! An exclusive residential complex with spacious layouts and top-tier construction. The residences have been built with the highest-quality materials and feature (...)
