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 (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
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.approved = 1 AND pm.cat_id IN (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
GROUP BY p.id
ORDER BY p.created DESC
Results 7561 - 7580 of 7581
TSEA358789
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 6 Baths: 6 M2: 700 Lot Size: 3,200 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 6 M2: 700 Lot Size: 3,200 Area: San Pedro Region: Andalucía
Beautiful cortijo style villa set in the prestigious golf estate of Guadalmina Baja, within walking distance to the beach and close to a SPA hotel, international schools and the commercial centre of (...)
TSEA326285
- La Quinta, Costa Del Sol, Benahavis
Beds: 8 Baths: 8 M2: 1,618 Lot Size: 15,000 Area: Benahavis Region: Andalucía
Beds: 8 Baths: 8 M2: 1,618 Lot Size: 15,000 Area: Benahavis Region: Andalucía
This luxury mansion is situated in La Vega del Colorado near La Quinta Golf, a gated community with 24h security. The property consists of 8 bedrooms (5 in the main house and another 3 in the (...)
TSEA186162
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 6 Baths: 4 M2: 922 Lot Size: 1,475 Area: Marbella Region: Andalucía
Beds: 6 Baths: 4 M2: 922 Lot Size: 1,475 Area: Marbella Region: Andalucía
Villa located in the "Altos Reales" urbanization located in Sierra Blanca. Sea views from the ground floor
Surrounded by nature with total privacy and tranquility on a 1500m2 plot.
Very (...)
House with large garden, terrace, pool and separate guest house
- Jubrique, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 330 Lot Size: 300,000 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 330 Lot Size: 300,000 Area: Estepona Region: Andalucía
Villa - Finca, Jubrique, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 250 m², Terrace 50 m², Garden/Plot 30000 m².
tiene una casa de invitados de 80 m2 independiente.
Setting : Country, Mountain (...)
TSEA151353
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 7 Baths: 5 M2: 211 Lot Size: 743 Area: Marbella West Region: Andalucía
Beds: 7 Baths: 5 M2: 211 Lot Size: 743 Area: Marbella West Region: Andalucía
Detached villa near cumbres del Rodeo in Nueva Andalucia, only a short drive to Puerto Banus and the town of San Pedro.
The property has had some renovation and offers 3 bedrooms on the ground floor, (...)
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 : (...)
TSEA111747
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 281 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 281 Area: San Pedro Region: Andalucía
Apartment - Penthouse, San Pedro de Alcántara, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 281 sqm, Terrace 120 sqm.
Setting : Next to San pedro Bulevar, Close To Golf, Close To Port, Close To (...)
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 (...)
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. (...)
TSEA143253
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 115 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: La Duquesa Region: Andalucía
Magnificent penthouse with spectacular sea views, located in an urbanization area at a short distance from Sotogrande harbour and close the beach. In impecable condiction, the apartment offers (...)
TSEA20329
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 2 M2: 250 Lot Size: 4,000 Area: Estepona Region: Andalucía
Beds: 5 Baths: 2 M2: 250 Lot Size: 4,000 Area: Estepona Region: Andalucía
Finca – Cortijo for sale in Estepona for €850,000. Charming rustic property featuring 5 bedrooms, 2 bathrooms, 250 m² built, 50 m² terrace, and a large fenced plot of 4,000 m². (...)
TSEA114829
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 400 Lot Size: 1,250 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 400 Lot Size: 1,250 Area: Benalmadena Region: Andalucía
Well presented 4 bedroom villa, with fitted kitchen, garage parking, private pool and garden. South West facing with views of the Mountains and the sea from the sunny terraces.
This spacious (...)
TSEA2223614
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 2 M2: 347 Lot Size: 1,100 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 2 M2: 347 Lot Size: 1,100 Area: Marbella East Region: Andalucía
Rustic style villa distributed over three floors, located in a quiet area of Elviria. The property has four bedrooms, two bathrooms and a toilet, a fully fitted kitchen and a spacious living room. It (...)
TSEA3119467
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 444 Lot Size: 1,010 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 444 Lot Size: 1,010 Area: Mijas and Mijas Costa Region: Andalucía
1761-V For sale. A Luxury villa of over 400m2 useful on 1010m2 of fenced plot. Consisting of living room, luxury fitted kitchen, 5 bedrooms with wardrobes, 3 bathrooms, 1 toilet and several (...)
TSEA3119527
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 86 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Malaga Region: Andalucía
2017-V MALAGA (Center) opportunity only in a building emblematic of the center of Malaga facing it Street Larios in a building historical of the century 18 protected i completely reformed in 2006 is (...)
TSEA3536257
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 8 M2: 800 Lot Size: 1,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 8 M2: 800 Lot Size: 1,000 Area: Mijas and Mijas Costa Region: Andalucía
698-V Alhaurin de la Torre. For sale a spectacular and luxurious villa of 800 m 2 built on 1.000m2 fenced plot, consists of at the Ground floor: hall, lounge/dining room area with fireplace, (...)
TSEA3611432
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 3 M2: 350 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 3 M2: 350 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
2936-V Villa in Alhaurin de la Torre located in a privileged environment. Villa located close to Costa del Sol area, from which you have a comfortable and easy access to all the services of (...)
TSEA1987700
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 8 Baths: 3 M2: 600 Lot Size: 1,225 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 8 Baths: 3 M2: 600 Lot Size: 1,225 Area: Mijas and Mijas Costa Region: Andalucía
221-V sell spectacular villa on 1225m2 fenced plot without pool, consisting of ground floor lounge, dining room with fireplace and home, complete with dining kitchen, pantry, 4 bedrooms 2 bathrooms, (...)
TSEA3119524
- Alora, Costa Del Sol, Älora
Beds: 5 Baths: 5 M2: 625 Lot Size: 70,000 Area: Älora Region: Andalucía
Beds: 5 Baths: 5 M2: 625 Lot Size: 70,000 Area: Älora Region: Andalucía
2278-V FANTASTIC FINCA FOR SALE on 70 000m2 of fenced plot, consists of many facilities in perfect condition, a house of 300m2 with living-dining room with fireplace, independent and furnished (...)
TSEA2778551
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 390 Lot Size: 6,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 390 Lot Size: 6,000 Area: Mijas and Mijas Costa Region: Andalucía
1490-V ALHAURIN DE LA TORRE. For sale a fantastic 2 independent villas on a 6.000m2 plot completely fenced. The main one consists of a living room with fireplace, dining room, 3 bedrooms with (...)
