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 (31,68,69,70)
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 (31,68,69,70)
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 (31,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 401 - 420 of 4730
€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 (...)
€395,000
TSEA5143597
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 114 Lot Size: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Lot Size: 100 Area: Mijas and Mijas Costa Region: Andalucía
Townhouse for sale in Las Lagunas de Mijas
Spacious townhouse for sale located in one of the fastest growing areas of Las Lagunas, at a very competitive price and well below that of any apartment in (...)
€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, (...)
€189,900
TSEA5143306
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 74 Lot Size: 74 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Lot Size: 74 Area: Nerja and Malaga East Region: Andalucía
Charming townhouse for sale located in the picturesque old town of Vélez-Málaga, one of the areas with the most history and charm of the Axarquía of Malaga. The property, distributed over two (...)
€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 (...)
€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 (...)
€549,000
TSEA5143066
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 200 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
This very spacious 3 double bedroom, 3 bathroom townhouse is spread over 4 floors and offers a family a fabulous opportunity to enjoy holidays or residence in high-end quality surroundings. (...)
€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 (...)
€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 (...)
Current Featured Properties
€720,000
TSEA4939045
- 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
This new development is integrated in a privileged natural environment with views over the bay of Estepona and the mountains of Marbella, very close to the sea and very well connected. A project of (...)
€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 (...)
€403,000
TSEA4686217
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 105 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Casares Region: Andalucía
Located in the area of Doña Julia Golf, this new development emerges as an oasis of elegance and tranquility on the Costa del Sol, much more than a simple residential area. A refuge for lovers (...)
