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 (56,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 (56,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 (56,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 141 - 160 of 752 €490,000
TSEA5120017
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 89 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Marbella West Region: Andalucía
Nestled in the heart of the sought-after El Naranjal urbanisation, this delightful townhouse blends traditional Andalusian character with modern comfort. Located within a secure gated community (...)
€645,000
TSEA5119801
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 31 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 31 Area: Benahavis Region: Andalucía
Elegant Corner Townhouse in La Heredia de Monte Mayor — Uninterrupted Sea Views & Complete Privacy
In the heart of the prestigious Monte Mayor estate lies this stylish corner townhouse, (...)
€270,000
TSEA5119090
- Tolox, Costa Del Sol, Yunquera
Beds: 5 Baths: 3 M2: 400 Lot Size: 20 Area: Yunquera Region: Andalucía
Beds: 5 Baths: 3 M2: 400 Lot Size: 20 Area: Yunquera Region: Andalucía
Townhouse, Tolox, Costa del Sol.
5 Bedrooms, 3 Bathrooms, Built 400 m², Terrace 40 m², Garden/Plot 20 m².
Setting : Town, Mountain Pueblo, Close To Shops, Close To Schools.
Orientation : (...)
€4,200,000
TSEA5118889
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 500 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 500 Area: Marbella Region: Andalucía
Meisho Hills – Luxury residence in the heart of Sierra Blanca, Marbella
We present a unique property located in the prestigious Meisho Hills residential area, in the heart of the exclusive Sierra (...)
€419,000
TSEA5118289
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 1 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 1 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
This two-level townhouse is situated in a secure, gated community with excellent amenities and services in the vicinity. It is conveniently located within walking distance of the Los Olivos shopping (...)
€325,000
TSEA5118244
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 76 Lot Size: 161 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 76 Lot Size: 161 Area: Nerja and Malaga East Region: Andalucía
Discover this delightful 2-bedroom townhouse located in a peaceful and well-connected area of Nerja. The home features a bright and airy open-plan living and dining area that flows seamlessly into a (...)
€3,195,000
TSEA5118193
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 3 Baths: 4 M2: 480 Area: Marbella Region: Andalucía
Beds: 3 Baths: 4 M2: 480 Area: Marbella Region: Andalucía
3 bedrooms and 3 en suite bathrooms plus 1 guest toilet, It has sea views from the ground floor, first floor and the solarium. private garage for two cars and storage room. underfloor
heating system (...)
€349,000
TSEA5118124
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 84 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 84 Area: Benalmadena Region: Andalucía
A corner with soul in Capellanía – Benalmádena, next to Higuerón
Discover this charming house with Andalusian essence, located in one of the most sought-after and peaceful areas of (...)
€698,000
TSEA5117764
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 125 Lot Size: 45 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Lot Size: 45 Area: Mijas and Mijas Costa Region: Andalucía
Discover your dream home in beautiful La Cala de Mijas. This charming, newly finished property is built on two floors and features, on the entrance floor; spacious living/dining area, open plan fully (...)
€530,000
TSEA5117650
- Benajarafe, Costa Del Sol East
Beds: 2 Baths: 1 M2: 150 Lot Size: 101 Region: Andalucía
Beds: 2 Baths: 1 M2: 150 Lot Size: 101 Region: Andalucía
Welcome to your own slice of paradise. This charming Casa Mata, a traditional Andalusian fisherman's home, is nestled just 10 meters from the shoreline — offering the rare luxury of an oasis just a (...)
€395,000
TSEA5116993
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 170 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 170 Area: Manilva Region: Andalucía
Beachfront Townhouse in Martagina, Manilva
3 Bedrooms | Sea Views | Spacious Layout
Discover this charming townhouse located in the sought-after La Borboleta development, a beachfront gated (...)
€890,000
TSEA5116168
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 140 Lot Size: 1,824 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 140 Lot Size: 1,824 Area: Fuengirola Region: Andalucía
Discover a rare and exciting investment opportunity in the prestigious C. Las Tortolas Torreblanca neighborhood of Fuengirola. With Fuengirola Town Hall approval already in place, this 1,824 sqm plot (...)
€900,000
TSEA5115724
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 3 M2: 218 Area: Marbella Region: Andalucía
Beds: 2 Baths: 3 M2: 218 Area: Marbella Region: Andalucía
Discover contemporary Mediterranean living in this sleek and stylish townhouse located in the heart of Marbella East, set within an exclusive gated community just moments from world-class golf (...)
€175,000
TSEA5115529
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M2: 60 Area: Coin Region: Andalucía
Beds: 4 Baths: 2 M2: 60 Area: Coin Region: Andalucía
Traditional Village Home in the Heart of Coín – Rare Opportunity in a Prime Location
Nestled in one of the most desirable and well-established areas of Coín, this traditional Spanish home offers (...)
€1,495,000
TSEA5115499
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 261 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 261 Area: San Pedro Region: Andalucía
Spacious, bright, and just moments from the shore —a beautifully updated family home where beachside living meets everyday ease.
Just 350 metres from the sea in one of San Pedroʼs most (...)
€560,000
TSEA5115493
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 288 Lot Size: 300 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 288 Lot Size: 300 Area: Mijas and Mijas Costa Region: Andalucía
PRICE REDUCED! Stunning Contemporary Townhouse in Prime Monte Alto, La Cala Golf - Now €560,000!
Discover exceptional value in the highly sought-after Monte Alto urbanization, nestled within the (...)
€610,000
TSEA5115250
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 130 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Marbella Region: Andalucía
Renovated 3-Bedroom Townhouse in Xarblanca, Marbella
Located in the exclusive and quiet private development of Xarblanca, in the area of the Marbella bus station, this cozy, fully renovated townhouse (...)
€340,000
TSEA5114362
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 86 Lot Size: 190 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Lot Size: 190 Area: Mijas and Mijas Costa Region: Andalucía
Charming End-of-Terrace Townhouse in Mijas Golf
This beautifully presented townhouse is located in a small, exclusive urbanisation of just four homes, offering a peaceful setting with a communal (...)
€765,000
TSEA5114287
- Nueva Andalucía, 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
Stylish Townhouse with Scenic Views in Aloha Pueblo, Nueva Andalucía
Nestled in the heart of the prestigious Aloha Pueblo community in Nueva Andalucía, this thoughtfully refurbished townhouse (...)
€250,000
TSEA5114215
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 119 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 119 Area: Malaga Region: Andalucía
Fantastic house for sale located in the coveted neighborhood of San José del Viso, an area undergoing rapid expansion and with all the amenities at your fingertips.
This bright home features 3 (...)
Current Featured Properties
€653,000
TSEA4428304
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 384 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 384 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
€825,000
TSEA4340413
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
EVERYONE IS TALKING ABOUT MOVING TO MIJAS!!!
Located in La Cala de Mijas, one of the urban centers belonging to the municipality of Mijas. Just a 5-minute drive from the residential area, you can (...)
€985,000
TSEA4713565
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 166 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 166 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Branded Residence comprising of 58 incredible 2 and 3 bedroom frontline golf homes to be built to the highest specification overlooking the renowned La Cala Resort Golf course. Reaching the (...)
