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 (43)
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 (43)
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 (43)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 281 - 295 of 295 €800,000
TSEA4076965
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 4 M2: 220 Lot Size: 145 Area: Marbella Region: Andalucía
Beds: 5 Baths: 4 M2: 220 Lot Size: 145 Area: Marbella Region: Andalucía
Semi-Detached House, Marbella, Costa del Sol. walking to old town
5 Bedrooms, 4 Bathrooms, Built 220 m², Terrace 50 m², Garden/Plot 145 m².
Setting : Close To Schools, Urbanisation.
Orientation (...)
€443,000
TSEA4027225
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
4 UNITS LEFT
DREAM AWAY LAZY EVENINGS BY LOOKING AT A STUNNING VIEW!!!
Off-plan development of contemporary semi-detached houses in Riviera del Sol, Mijas, with views over the Mediterranean. The 3 (...)
€170,000
TSEA3997588
- Cómpeta, Costa Del Sol East
Beds: 4 Baths: 2 M2: 156 Lot Size: 156 Region: Andalucía
Beds: 4 Baths: 2 M2: 156 Lot Size: 156 Region: Andalucía
We present you a great property, to either invest or simply live in Large traditional town house located in the upper part of Cómpeta near the Plaza del Carmen. It is close to pharmacies, various (...)
€180,000
TSEA3944029
- Cómpeta, Costa Del Sol East
Beds: 2 Baths: 1 M2: 124 Lot Size: 12,000 Region: Andalucía
Beds: 2 Baths: 1 M2: 124 Lot Size: 12,000 Region: Andalucía
If you are looking for a country house that you can design according to your taste and needs, this is the perfect property for you - an old Andalusian farmhouse with lots of charm and character. (...)
€260,000
TSEA3896224
- Jimena de la Frontera, Costa de la Luz
Beds: 4 Baths: 2 M2: 200 Lot Size: 550 Region: Andalucía
Beds: 4 Baths: 2 M2: 200 Lot Size: 550 Region: Andalucía
WITH POOL, GARDEN, TERRACE AND FABULOUS VIEWS FOR SALE IN SAN PABLO DE BUCEITE FANTASTIC VILLAGE HOUSE.
San Pablo de Buceite is a beautiful town in the province of Cádiz on the border with the (...)
€279,000
TSEA3886300
- Periana, Costa Del Sol East
Beds: 14 Baths: 5 M2: 500 Lot Size: 509 Region: Andalucía
Beds: 14 Baths: 5 M2: 500 Lot Size: 509 Region: Andalucía
Are you looking for an ideal place to set up a hotel or a Bed & Breakfast? Look no further! This is perfect. Here you can start an exciting and thriving hotel business, being the only guest (...)
€169,000
TSEA3812308
- Torrox, Costa Del Sol East
Beds: 3 Baths: 2 M2: 120 Lot Size: 120 Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 120 Region: Andalucía
Traditional village house in a quiet and charming location in the historic center of Torrox. The main square, the health center, banks and stores are within 15 minutes walking distance. There is a (...)
€650,000
TSEA3794710
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 3 M2: 450 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 3 M2: 450 Area: Alhaurin el Grande Region: Andalucía
A magnificent house located in Alhaurin el Grande town centre, Costa del Sol
Consisting of four floors with the possibility of making a pool on the top floor
- Ground floor: entrance hall and (...)
€790,000
TSEA3591829
- Frigiliana, Costa Del Sol East
Beds: 3 Baths: 3 M2: 162 Lot Size: 309 Region: Andalucía
Beds: 3 Baths: 3 M2: 162 Lot Size: 309 Region: Andalucía
GREAT OPPORTUNITY! Bright and spacious house located in the sought after area of Puerto Blanquillo in Frigiliana, with un interrupted views over the valley towards Nerja and the Mediterranean Sea. (...)
€191,000
TSEA3574294
- Cómpeta, Costa Del Sol East
Beds: 4 Baths: 1 M2: 92 Lot Size: 40 Region: Andalucía
Beds: 4 Baths: 1 M2: 92 Lot Size: 40 Region: Andalucía
Great town house in Cómpeta. If you are looking for a home in a quiet place, without noise or pollution, with good views, with all the services of a city at hand and at a very reasonable price, this (...)
€212,100
TSEA2964851
- Salares, Costa Del Sol East
Beds: 3 Baths: 4 M2: 300 Lot Size: 300 Region: Andalucía
Beds: 3 Baths: 4 M2: 300 Lot Size: 300 Region: Andalucía
Brand-new semi-detached house in Salares. The house has a large living room with fireplace and access to a terrace, spacious and fully equipped kitchen, it has three bedrooms with fitted wardrobes (...)
€148,400
TSEA2425934
- Riogordo, Costa Del Sol East
Beds: 2 Baths: 1 M2: 167 Lot Size: 167 Region: Andalucía
Beds: 2 Baths: 1 M2: 167 Lot Size: 167 Region: Andalucía
Nice village house in Riogordo. Central location. Authentic country house. On the ground floor is a commercial space of 63.95m2. The house has 2 floors. It has living room with fireplace, 2 bedrooms (...)
€446,000
TSEA3105226
- Algarrobo, Costa Del Sol East
Beds: 8 Baths: 3 M2: 300 Lot Size: 450 Region: Andalucía
Beds: 8 Baths: 3 M2: 300 Lot Size: 450 Region: Andalucía
Fantastic opportunity to purchase a complete building of new construction in Algarrobo town. The building itself, gives to two streets, the ground floor consists of one apartment: living room, large (...)
€270,000
TSEA3016463
- Árchez, Costa Del Sol East
Beds: 4 Baths: 5 M2: 200 Lot Size: 200 Region: Andalucía
Beds: 4 Baths: 5 M2: 200 Lot Size: 200 Region: Andalucía
Fantastic House in excellent condition in Archez. It has a large living/dining room, kitchen, four bedrooms and five bathrooms. It is recently built and sold partially furnished. It also has a large (...)
€3,000,000
TSEA2662976
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 421 Lot Size: 60 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 421 Lot Size: 60 Area: Marbella Region: Andalucía
MEISHO HILLS is an emblematic project of modern luxury properties located in a unique and exclusive urbanization of Sierra Blanca. The complex offers spectacular views to the sea and mountain and a (...)
Current Featured Properties
€1,100,000
TSEA4638103
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 138 Lot Size: 34 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Lot Size: 34 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
€1,675,000
TSEA4939003
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 221 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 221 Area: Marbella Region: Andalucía
This is the opportunity of living in Spain, in the best equipped residential complex in Marbella, located in a privileged spot near the golf club and with premium quality specifi cations. You will (...)
€1,300,000
TSEA4639768
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
