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 (70,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 (70,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 (70,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 121 - 140 of 677 €569,000
TSEA5122012
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 116 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Malaga Region: Andalucía
This exclusive apartment is located in the beautiful area of Casares Playa, in Casares, Málaga. With a privileged location, this apartment offers a peaceful and relaxing environment. With 2 bedrooms (...)
€360,000
TSEA5121952
- Torrox Costa, Costa Del Sol East
Beds: 4 Baths: 3 M2: 170 Region: Andalucía
Beds: 4 Baths: 3 M2: 170 Region: Andalucía
Modern 4-Bedroom House with Sea Views and Rooftop Terrace – Costa del Sol
This stylish and well-maintained home offers 4 bedrooms, 3 bathrooms, and three south-facing terraces, including a (...)
€179,000
TSEA5121838
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 74 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 74 Area: Nerja and Malaga East Region: Andalucía
Recentely renovated corner townhouse situated in the heart of Velez Malaga, in the Plaza San Francisco near the town hall. Only 6 km from the beautiful beach in Torre Del Mar.
- Total indoor area: (...)
€678,000
TSEA5121835
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Stunning Renovated Townhouse in the Heart of Estepona's Old Town – Just Steps from the Beach.
Located in a prime south-facing corner position, this beautifully renovated townhouse combines (...)
€265,000
TSEA5121439
- Almogía, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 102 Lot Size: 93 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Lot Size: 93 Area: Malaga Region: Andalucía
Once-in-a-Lifetime Country House in Montorosso, Almogía – Ibiza Vibes in the Andalusian Hills
Fully Furnished | Saltwater Pool | Move-in Ready
Escape to your own private paradise in this (...)
€3,450,000
TSEA5121085
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 290 Lot Size: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 290 Lot Size: 120 Area: Estepona Region: Andalucía
Situated on the frontline of the New Golden Mile, between Puerto Banús and Estepona, this exceptional townhouse offers a unique blend of coastal luxury, privacy, and resort-style amenities. Located (...)
€239,000
TSEA5120764
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 58 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 58 Area: Nerja and Malaga East Region: Andalucía
Totally renovated for sale in the Historic Center of Vélez-Málaga
This beautiful house is located in the picturesque old town of Vélez-Málaga, just a few steps from the main cathedral and the (...)
€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 (...)
€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 (...)
€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 (...)
€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 (...)
€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 (...)
Current Featured Properties
€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 (...)
€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, (...)
€1,095,000
EMPTY
- La Heredia, Costa Del Sol, Benahavis
Beds: 5 Baths: 4 M2: 333 Lot Size: 179 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 4 M2: 333 Lot Size: 179 Area: Benahavis Region: Andalucía
Located in the sought-after community of La Perla de la Heredia, on the Ronda road near Marbella, this exceptional five-bedroom townhouse offers a blend of comfort, style, and convenience. South to (...)
