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,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 (70,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 (70,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 721 - 740 of 743 €170,000
TSEA2755061
- Guaro, Costa Del Sol, Guaro
Beds: 1 Baths: 1 M2: 110 Area: Guaro Region: Andalucía
Beds: 1 Baths: 1 M2: 110 Area: Guaro Region: Andalucía
A property that could be your ‘little piece of heaven' with a little imagination this property could be amazing.
The views are wow, with the outdoor terrace is asking for a chill out seating (...)
€950,000
TSEA3651992
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 270 Lot Size: 250 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 270 Lot Size: 250 Area: San Pedro Region: Andalucía
Bright and spacious corner townhouse with a large garden of 250m.
Located in a sought-after area, near the Golf Club and the shopping center and 7 minutes from the beach.
The community has concierge (...)
€3,650,000
TSEA3645113
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 364 Lot Size: 106 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 364 Lot Size: 106 Area: Estepona Region: Andalucía
Townhouse, Estepona, Costa del Sol.
3 Bedrooms, 3 Bathrooms, Built 364 m², Terrace 108 m², Garden/Plot 106 m².
Setting : Beachfront, Beachside, Close To Port, Close To Sea, Close To Marina, (...)
€2,350,000
TSEA3575815
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 302 Lot Size: 30 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 302 Lot Size: 30 Area: Estepona Region: Andalucía
TOWNHOUSE IN FIRST LINE OF THE BEACH, ESTEPONA
Modern and luxurious townhouse with 4 bedrooms brand new on the beachfront on the New Golden Mile of Estepona, being only twenty minutes from Puerto (...)
€85,000
TSEA3536752
- Tolox, Costa Del Sol, Yunquera
Beds: 4 Baths: 1 M2: 124 Area: Yunquera Region: Andalucía
Beds: 4 Baths: 1 M2: 124 Area: Yunquera Region: Andalucía
CHARMING Town House
. Roof terrace with mountain views
. FANTASTIC Lock & Leave
. Immerse yourself in this lovely Spa Village
. Walking distance to shops and TAPAS bars
. ENJOY the (...)
€2,500,000
TSEA3534511
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 280 Lot Size: 30 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 280 Lot Size: 30 Area: Estepona Region: Andalucía
Townhouse, Estepona, Costa del Sol.
3 Bedrooms, 3 Bathrooms, Built 280 m², Terrace 90 m², Garden/Plot 30 m².
Setting : Beachfront, Town, Beachside, Close To Town, Marina, Urbanisation, Front Line (...)
€2,500,000
TSEA3532918
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 274 Lot Size: 20 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 274 Lot Size: 20 Area: Estepona Region: Andalucía
Semi-Detached House, Estepona, Costa del Sol.
3 Bedrooms, 3 Bathrooms, Built 249 m², Terrace 105 m².
Setting : Beachfront, Town, Beachside, Close To Port, Close To Marina, Urbanisation, Front Line (...)
€1,050,000
TSEA3504772
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 4 M2: 285 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 4 M2: 285 Area: Fuengirola Region: Andalucía
Is your dream living in your own Andalucian home with lots of privacy but still again walking distance from all the services?
This duplex townhouse is located in center of Fuengirols one of the most (...)
€150,000
TSEA3500422
- Algodonales, Costa de la Luz
Beds: 4 Baths: 2 M2: 170 Lot Size: 10,000 Region: Andalucía
Beds: 4 Baths: 2 M2: 170 Lot Size: 10,000 Region: Andalucía
Nice town house with 160m2 built and a plot of land in the back of approximately 10,000m2, ideal families and an ecological garden in the field, rural tourism, holiday home, etc ... has many (...)
€139,000
TSEA3455860
- Tolox, Costa Del Sol, Yunquera
Beds: 6 Baths: 2 M2: 153 Area: Yunquera Region: Andalucía
Beds: 6 Baths: 2 M2: 153 Area: Yunquera Region: Andalucía
Nice town house on the edge of the village in a fantastic location, with views of the mountain, and in a very quiet street but only a few steps from the town centre. The house has four floors and has (...)
€150,000
TSEA3362716
- Tolox, Costa Del Sol, Yunquera
Beds: 3 Baths: 2 M2: 156 Area: Yunquera Region: Andalucía
Beds: 3 Baths: 2 M2: 156 Area: Yunquera Region: Andalucía
MOVE-IN Ready
. Set in a pueblo close to the NATIONAL Park
. TRADITIONAL Spanish Environment
. Garage
. Double Glazing
. Close to many TAPAS Bars
Come and visit the hills of Tolox to view this (...)
€500,000
TSEA3362083
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 108 Lot Size: 150 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Lot Size: 150 Area: San Pedro Region: Andalucía
Unique Investment Opportunity – Possible 4-Story Project
Located in the heart of San Pedro de Alcántara, this semi-detached house offers enormous development potential, with the possibility of (...)
€470,000
TSEA3332302
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 2 M2: 129 Lot Size: 71 Area: Marbella Region: Andalucía
Beds: 5 Baths: 2 M2: 129 Lot Size: 71 Area: Marbella Region: Andalucía
Traditional Andalousian townhouse with charm in the heart of Marbella Old town, a stone's throw from the Orange Square and next to restaurants and shops.
The house is built on two floors, has an (...)
€479,000
TSEA3306343
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 120 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Benalmadena Region: Andalucía
Please be aware there is very limited outside space. Just a small patio. The upstairs terrace is converted to a enclosed gym area.
Townhouse, Arroyo de la Miel, Costa del Sol.
3 Bedrooms, 2 (...)
€1,550,000
TSEA2911550
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 4 M2: 254 Area: Marbella Region: Andalucía
Beds: 6 Baths: 4 M2: 254 Area: Marbella Region: Andalucía
Terraced house with a fantastic location next to the old town of Marbella.
The property consists of 6 bedrooms, 4 bathrooms, living room and kitchen. There is also a nice interior patio next to the (...)
€430,000
TSEA2785172
- Guaro, Costa Del Sol, Guaro
Beds: 7 Baths: 3 M2: 362 Area: Guaro Region: Andalucía
Beds: 7 Baths: 3 M2: 362 Area: Guaro Region: Andalucía
Welcome to the COUNTS House
. Steeped in history
. Character Property
. Popular Village
. CULTURE, CULTURE
. TRADITIONAL Spanish Environment
. Possible Rural Tourism Opportunity
Built around the (...)
€1,495,000
TSEA2771282
- Artola, Costa Del Sol, Marbella East
Beds: 6 Baths: 6 M2: 576 Lot Size: 1,080 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 6 M2: 576 Lot Size: 1,080 Area: Marbella East Region: Andalucía
This opulent and large family villa has been tailor-made and built up to high standards. The house is standing at the edge of a small gated community sharing a pool and part of the land with another (...)
€1,500,000
TSEA2731415
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 252 Lot Size: 113 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 252 Lot Size: 113 Area: Marbella Region: Andalucía
A rare opportunity to acquire a fabulous townhouse located in one of the nicest streets of the old town of Marbella, walking distance to all the amenities, bars, restaurants and the beaches.
The (...)
€289,000
TSEA2498606
- Monda, Costa Del Sol, Marbella
Beds: 5 Baths: 2 M2: 160 Area: Marbella Region: Andalucía
Beds: 5 Baths: 2 M2: 160 Area: Marbella Region: Andalucía
CHARACTER Town House
. Shady COURTYARD
. In the centre of the SOUGHT AFTER Village of Monda
. Walking distance to Bars and Restaurant
. IMMERSE yourself in a traditional Spanish environment
. (...)
€510,000
TSEA2300504
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 150 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 150 Area: Marbella West Region: Andalucía
Surrounded by 12.000 m2 of gardens for only 12 properties and in front of las Brisas Golf. This lovely , 3 bedrooms duplex with 2 bahrooms and guess toilet .Offers you communal pool and gardens, (...)
Current Featured Properties
€483,000
TSEA3980794
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
NESTLED BETWEEN STUNNING LANDSCAPE GARDENS!!
An exclusive development of 46 townhouses of 2, 3 and 4 bedrooms, some of them semi-detached, built in a contemporary style, in a privileged location two (...)
€1,299,000
TSEA4792552
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 374 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 374 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 (...)
€1,960,000
TSEA4893418
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 217 Lot Size: 18 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 217 Lot Size: 18 Area: Marbella Region: Andalucía
A community of 27 opulent semidetached homes with expansive rooms, private gardens, swimming pools, and prime sea views can be found in Marbella at The List Rio Real. Because to its multi-level (...)
