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 (46,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 (46,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 (46,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 761 - 771 of 771 €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 (...)
€1,200,000
TSEA2670191
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 6 M2: 578 Lot Size: 880 Area: Marbella Region: Andalucía
Beds: 5 Baths: 6 M2: 578 Lot Size: 880 Area: Marbella Region: Andalucía
Located within walking distance of less than 100 m. to the best beach in Marbella , Elviria with its fine sand dunes with kilometers of beach to walk and swim.
For sale including Basic and Execution (...)
€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, (...)
€1,250,000
TSEA2269028
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 431 Lot Size: 100 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 431 Lot Size: 100 Area: Marbella East Region: Andalucía
Stunning Andalucian style townhouse located on the famous golden mile in Marbella. A wonderfull designed architecture with Mediterranean taste, surrounded by lush tropical gardens and polos in areas (...)
€580,000
TSEA134059
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 130 Lot Size: 350 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 130 Lot Size: 350 Area: Estepona Region: Andalucía
Townhouse - Semi Detached, Estepona, Costa del Sol.
4 Bedrooms, 2.5 Bathrooms, Built 130 m², Terrace 30 m², Garden/Plot 350 m².
Setting : Close To Shops, Close To Sea.
Orientation : (...)
€750,000
5 bedroom townhouse in excellent condition with terrace, garden and private parking
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 400 Lot Size: 200 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 400 Lot Size: 200 Area: Estepona Region: Andalucía
Townhouse - Terraced, Estepona, Costa del Sol.5 Bedrooms, 3 Bathrooms, Built 400 sqm, Terrace 100 sqm, Garden/Plot 200 sqm. Setting : Town, Commercial Area, Village, Close To Shops, Close To Schools. (...)
Current Featured Properties
€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 (...)
€673,000
TSEA4107058
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 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, (...)
€2,080,000
TSEA4893667
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 280 Lot Size: 20 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 280 Lot Size: 20 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 (...)
