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 (69,36,37,38)
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 (69,36,37,38)
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 (69,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 78
€164,000
TSEA5159569
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 36 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 36 Area: Benalmadena Region: Andalucía
Middle Floor Studio, Benalmadena Costa, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 36 m², Terrace 6 m².
Setting : Commercial Area, Close To Golf, Close To Port, Close To Shops, Close To Sea, (...)
€685,000
TSEA5156278
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
For sale: a stunning 4-bedroom, 3-bathroom townhouse located in the exclusive Riviera del Sol urbanization. The property is in perfect condition, ready to move into, with spacious, bright interiors (...)
€395,000
TSEA5156059
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 95 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 95 Area: Mijas and Mijas Costa Region: Andalucía
Location! Location! Location! Nestled in the heart of Mijas Pueblo, this stunning townhouse is a true gem of the village. Completely renovated to the highest standards, this property boasts (...)
€459,000
TSEA5155246
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 86 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Fuengirola Region: Andalucía
Exclusive Townhouse in Pueblo López, the Heart of Fuengirola ✨
Imagine living right in the center of Fuengirola, with everything at your fingertips, yet enjoying the peace and charm of a true (...)
€699,000
TSEA5155012
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 182 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 182 Area: Estepona Region: Andalucía
For sale, beautiful modern 3-bedroom semi-detached house with a large garage.
Excellent location in the centre of Estepona, just 300 metres walk from Calle Terraza, close to all amenities and the (...)
€498,000
TSEA5152081
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 1 M2: 220 Lot Size: 113 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 1 M2: 220 Lot Size: 113 Area: Nerja and Malaga East Region: Andalucía
In El Condal, Nerja, this spacious townhouse with a private pool offers comfortable and practical living, with well-planned spaces and several areas to enjoy both indoors and outdoors.
The property (...)
€495,000
TSEA5150911
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
This beautiful, fully exterior apartment stands out for its excellent location and natural brightness throughout. Located in a peaceful residential area of Marbella, it is just 400 meters from the (...)
€222,900
TSEA5150437
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
**64 m² Studio Apartment for Sale – Riviera del Sol, Costa del Sol (Spain)**
This attractive ground floor studio is located in a gated and secure community, just 400 meters from the beach, (...)
€599,000
TSEA5148580
- Málaga Centro, Costa Del Sol, Malaga
Beds: 6 Baths: 5 M2: 157 Area: Malaga Region: Andalucía
Beds: 6 Baths: 5 M2: 157 Area: Malaga Region: Andalucía
Townhouse for sale in Malaga - Charming and modern
Discover this magnificent, fully renovated townhouse located on Salamanca's market square in the heart of Malaga. With a floor area of 1,700 sq ft, (...)
€495,000
TSEA5148283
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 2 M2: 142 Lot Size: 222 Area: Manilva Region: Andalucía
Beds: 4 Baths: 2 M2: 142 Lot Size: 222 Area: Manilva Region: Andalucía
This exceptional 4-bedroom, 3-bathroom semi-detached offers a rare opportunity to live right on the beachfront, with panoramic views of the sea and the pristine, unspoiled Manilva coastline. The (...)
€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 (...)
€254,500
TSEA5141122
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 27 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 27 Area: Mijas and Mijas Costa Region: Andalucía
This beachfront studio apartment is an excellent opportunity for those seeking a property in a prime location. The apartment is south-east facing, offering spectacular views of the Mediterranean, the (...)
€1,100,000
TSEA5139940
- Costabella, Costa Del Sol, Marbella East
Beds: 5 Baths: 4 M2: 171 Lot Size: 31 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 4 M2: 171 Lot Size: 31 Area: Marbella East Region: Andalucía
Townhouse with Panoramic Sea Views in Costabella, Marbella East
Discover this outstanding residence in the exclusive enclave of Costabella, Marbella East, where elegance and tranquillity meet the (...)
€525,000
TSEA5139019
- Higueron, Costa Del Sol
Beds: 4 Baths: 2 M2: 149 Lot Size: 15 Region: Andalucía
Beds: 4 Baths: 2 M2: 149 Lot Size: 15 Region: Andalucía
DETACHED TOWNHOUSE IN URBANIZATION OF HIGUERON, HIGH ZONE, CONSISTS OF TWO FLOORS, IN THE GROUND FLOOR A LARGE KITCHEN WITH LAUNDRY ROOM, GUEST TOILET, LIVING-DINING ROOM, WITH WOOD CHIMENY AND LARGE (...)
€520,000
TSEA5137855
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 179 Lot Size: 35 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 179 Lot Size: 35 Area: Mijas and Mijas Costa Region: Andalucía
Modern 3-Bedroom House in Lower Riviera del Sol – Safe, Connected & Close to the Beach
Unique opportunity in the highly sought-after lower part of Riviera del Sol: a bright and modern (...)
€170,000
TSEA5132677
- Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 2 M2: 112 Lot Size: 306 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 2 M2: 112 Lot Size: 306 Area: Nerja and Malaga East Region: Andalucía
Nestled in the picturesque hills of Comares, this charming townhouse with its own plot is a real gem for those seeking authentic Andalusia. The house offers plenty of space and flexible layout (...)
€637,000
TSEA5132503
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 120 Area: Estepona Region: Andalucía
VERY NICE SEMI-DETACHED HOUSE WITH SEA VIEWS FOR SALE IN ESTEPONA!! This corner townhouse is located in the sought-after, secure, private development of Galera Park. Located 200 meters from the (...)
€1,170,000
TSEA5131579
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 158 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 158 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Semi-Detached Villa in Cala Serena Village – Newly built, Stunning Sea Views & Luxury Living
Welcome to a home where modern design meets Mediterranean charm. This elegant newly built (...)
€690,000
TSEA5126974
- La Mairena, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 197 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 197 Area: Marbella East Region: Andalucía
Corner townhouse with panoramic views in La Mairena, Marbella East
This spacious corner townhouse is located in a quiet residential area in La Mairena, nestled in the hills above Elviria. Surrounded (...)
€2,395,000
TSEA5126059
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 280 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 280 Area: Marbella East Region: Andalucía
Exclusive townhouse in the Golden Mile, located in the prestigious Monte Marbella Club, in Lomas de Puente Romano.
Fully renovated with high-quality materials and elegant design, this property (...)
Current Featured Properties
€461,000
TSEA5038750
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 104 Lot Size: 32 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 104 Lot Size: 32 Area: Fuengirola Region: Andalucía
Located in the town of Fuengirola, in the prestigious Torreblanca area, This is an exclusive residential complex consisting of 19 townhouses that offers everything you need for a dream life on the (...)
