TSEA5138848 - The Spanish Estate Agent

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

Subcategories

Detached - (3910), Semi Detached - (3910), Terraced - (3910)

Advanced Search

Results 741 - 752 of 752

Properties

Results 741 - 752 of 752

€500,000

TSEA3362083 - San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M²: 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 M²: 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 M²: 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 M²: 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 M²: 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 M²: 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 M²: 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 M²: 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 M²: 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 M²: 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 M²: 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 M²: 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. (...)

Page 38 of 38

Current Featured Properties

€2,080,000

TSEA4893667 - Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M²: 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 (...)

€950,000

TSEA4430956 - Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M²: 240 Area: Estepona Region: Andalucía

Exceptional very spacious townhouse located in frontline beach residential complex Belgravia club, Estepona. This spectacular home has fantastic sea views and the location is unbeatable, just a few (...)

€980,000

TSEA4621648 - Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M²: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía

This exclusive project with an elegant Scandinavian design blends harmoniously with the surrounding nature. The architecture of the townhouses follows seamlessly the undulating shapes of the (...)

Intellectual Property :: Real Estate Component by theThinkery.net. v3.3.5