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 (47,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 (47,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 (47,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 881 - 895 of 895 €399,000
TSEA3069349
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 328 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 328 Area: Mijas and Mijas Costa Region: Andalucía
Rent or sell large local distributed in 328 meters all on one floor.
Unbeatable area, a few steps from the center of Fuengirola next to the hospital.
He has been rented for 15 years by a professional (...)
€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 (...)
€1,272,000
TSEA2907905
- Monda, Costa Del Sol, Marbella
Beds: 7 Baths: 9 M2: 900 Lot Size: 900 Area: Marbella Region: Andalucía
Beds: 7 Baths: 9 M2: 900 Lot Size: 900 Area: Marbella Region: Andalucía
Edificio con proyecto de Apart Hotel. En el corazón del acogedor pueblo de Monda. Tiene 3 apartamentos dobles, y otros 4 individuales. Todos con cocina equipada, baño y televisión. Reformado en (...)
€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,195,000
TSEA2645156
- Alora, Costa Del Sol, Älora
Beds: 7 Baths: 6 M2: 580 Lot Size: 17,000 Area: Älora Region: Andalucía
Beds: 7 Baths: 6 M2: 580 Lot Size: 17,000 Area: Älora Region: Andalucía
Large B&B Business.
. Large client base
. SUCCESSFUL business
. Amazing views
. Apartment, Studios x 2, Suite, Bedroom
. OWNER Accommodation
. Stables
. RAILWAY Station close by
. Great (...)
€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
. (...)
€1,900,000
TSEA2322323
- Coín, Costa Del Sol, Coin
Beds: 6 Baths: 2 M2: 893 Lot Size: 75,000 Area: Coin Region: Andalucía
Beds: 6 Baths: 2 M2: 893 Lot Size: 75,000 Area: Coin Region: Andalucía
EQUESTRIAN Centre
. Loads of POTENTIAL
. Excellent communication links
. Close to the popular town of Coin
. Close to many TAPAS Bars
. Walking distance to local bar-restaurant
. (...)
€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 (...)
€850,000
TSEA2102066
- Guaro, Costa Del Sol, Guaro
Beds: 14 Baths: 14 M2: 626 Lot Size: 57,300 Area: Guaro Region: Andalucía
Beds: 14 Baths: 14 M2: 626 Lot Size: 57,300 Area: Guaro Region: Andalucía
RURAL Hotel
. BUSINESS Opportunity
. 4 x 2 bedroom Townhouses
. 5 x 1 bedroom apartments
. Reception Area
. Storage Room and Water Deposit 35m2
. Separate House with 2 bedooms 69m2
. (...)
€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 : (...)
€385,000
Prime investment project only 15 minutes from Ronda
- Ronda, Costa Del Sol, Ronda
Beds: 1 Baths: 1 M2: 1,100 Lot Size: 75,000 Area: Ronda Region: Andalucía
Beds: 1 Baths: 1 M2: 1,100 Lot Size: 75,000 Area: Ronda Region: Andalucía
A prime investment project located only 15 minutes from Ronda. The finca consists of 7.5 hectares of olive plantation (approx 600 producing trees) and borders the National park of Grazalema. There (...)
€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
€5,200,000
3 Bed ground floor apartment in Marbella
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 447 Lot Size: 135 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 447 Lot Size: 135 Area: Marbella Region: Andalucía
PRE LAUNCH, ACT FAST AS THESE WILL GO QUICKLY!!!
The brand new off plan development, of 64 apartments and 32 townhouses. Uniquly located on one of the last avaialable plots on the marbella coast. (...)
€1,595,000
TSEA5010322
- La Heredia, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 308 Lot Size: 181 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 308 Lot Size: 181 Area: Benahavis Region: Andalucía
STUNNING 5-BEDROOM TOWNHOUSE WITH PANORAMIC SEA, MOUNTAIN AND GOLF VIEWS
Located in the award winning village of La Heredia, close to Benahavis on the Ronda road, this beautiful 5-bedroom townhouse (...)
€3,650,000
TSEA4450162
- 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
Discover coastal living in this exquisite townhome, ideally situated with views of the serene ocean waves . Boasting breathtaking views of both sunrises and sunsets, this home is a true masterpiece (...)
