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 (48,42,43,44,45)
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 (48,42,43,44,45)
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 (48,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 2581 - 2600 of 2656 €4,250,000
TSEA3229714
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 6 Baths: 6 M2: 561 Lot Size: 806 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 6 M2: 561 Lot Size: 806 Area: San Pedro Region: Andalucía
Spacious beachside villa in popular San Pedro, a short drive west of Marbella and Puerto Banús, and within walking distance of the beach promenade, shops and restaurants. This house is set in (...)
€997,000
TSEA3229033
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 286 Lot Size: 3,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 286 Lot Size: 3,000 Area: Mijas and Mijas Costa Region: Andalucía
THREE PROPERTIES ON ONE PLOT
. Close to the popular town of Alhaurin de la Torre
. Flat Plot
. Possible RENTAL INCOME
. Vibrant town with many FIESTAS
. Great selection of RESTAURANTS near by
There (...)
€6,000,000
TSEA3224398
- Archidona, Costa Del Sol, Antequera
Beds: 6 Baths: 3 M2: 300 Area: Antequera Region: Andalucía
Beds: 6 Baths: 3 M2: 300 Area: Antequera Region: Andalucía
PARADISE IN SOUTHERN SPAIN
In the hearttland of southern Spain, Andalucia, Malaga (Archidona, Villanueva de Tapia) is located this area of peace, thanquility, relax and a place where the olive (...)
€955,000
TSEA3218227
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 417 Lot Size: 605 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 417 Lot Size: 605 Area: Mijas and Mijas Costa Region: Andalucía
Modern new construction project in Lomas de Mijas.
The project, as sold here, includes a modern style house with spacious rooms, large windows and the best construction qualities. All this on a plot (...)
€900,000
TSEA3220219
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 5 M2: 355 Lot Size: 24,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 5 M2: 355 Lot Size: 24,000 Area: Mijas and Mijas Costa Region: Andalucía
NOW WITH ALL PAPERWORK LEGALISED
This is a great investment opportunity in two properties near Mijas. These two villas are located in the valleys of Mijas with easy access to the main road and (...)
€245,000
TSEA3210646
- Almogía, Costa Del Sol, Malaga
Beds: 3 M2: 476 Lot Size: 37,508 Area: Malaga Region: Andalucía
Beds: 3 M2: 476 Lot Size: 37,508 Area: Malaga Region: Andalucía
Large plot of rustic land near to Almogía with a house, large storehouse and corral needing a complete reform.
The property has great potential (It does not have a bathroom or fitted kitchen at the (...)
€2,990,000
TSEA3202114
- Málaga, Costa Del Sol, Malaga
Beds: 5 Baths: 4 M2: 968 Lot Size: 1,800 Area: Malaga Region: Andalucía
Beds: 5 Baths: 4 M2: 968 Lot Size: 1,800 Area: Malaga Region: Andalucía
We present this magnificent and exclusive Villa in the prestigious urbanization of Málaga - Pinares de San Antón. Panoramic views of the sea, a unique and quiet environment to enjoy the fresh air (...)
€699,000
TSEA3195034
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 338 Lot Size: 6,020 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 338 Lot Size: 6,020 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful Villa in perfect condition with wonderful sea and countryside views and 100% privacy and tranquility, located in secure development, 6km from Mijas Pueblo and Fuengirola 12km.
€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 (...)
€988,000
TSEA3113020
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 375 Lot Size: 438 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 375 Lot Size: 438 Area: Torremolinos Region: Andalucía
Beatifully appointed quality built Villa. The construction was carried out by the owner´s strict supervision. Built to very high end qualtity with no costs spared.
The villa has good insulation, (...)
€995,000
TSEA3087802
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 420 Lot Size: 640 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 420 Lot Size: 640 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic villa that is located in a prestigious urbanization in Fuengirola. The property enjoys privacy, tranquility and panoramic views of the sea, mountains and surroundings. Very spacious with a (...)
€1,200,000
TSEA3085945
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 140 Lot Size: 12,000 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Lot Size: 12,000 Area: Casares Region: Andalucía
Great finca with three bedrooms, two bathrooms, lots of land and private pool. Just on the entrance of Casares village, no difficult roads, easy access, great quiet location and it has the most (...)
€5,200,000
TSEA3083107
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 7 Baths: 6 M2: 1,032 Lot Size: 6,106 Area: Sotogrande Region: Andalucía
Beds: 7 Baths: 6 M2: 1,032 Lot Size: 6,106 Area: Sotogrande Region: Andalucía
Discover Paradise in Sotogrande Alto! Dream Villa: Luxury, Privacity, and Exclusivity
Welcome to a property that defies all expectations and redefines the concept of luxury in Sotogrande Alto. This (...)
€850,000
TSEA3036125
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 2 M2: 360 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 2 M2: 360 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
A large villa in a quiet street in El Coto set back from the tree lined street with off street gated parking. The house has a living/dining room with a large covered and glassed in terrace (...)
€1,925,000
TSEA3035819
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 465 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 465 Area: Benahavis Region: Andalucía
Modern villa with stunning sea views for sale at La Quinta, Benahavis, Costa del Sol. Recently built, in excellent conditions. Located in one of the most prestigious areas of Costa del Sol, very (...)
€5,950,000
TSEA3021947
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 6 Baths: 6 M2: 1,508 Lot Size: 2,858 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 6 M2: 1,508 Lot Size: 2,858 Area: San Pedro Region: Andalucía
BREATHTAKING VILLA FOR SALE IN GUADALMINA BAJA
This extremely stylish villa is situated within one of the most prestigious beachside areas of Marbella, within 10 minutes from the beach, shops and (...)
€1,820,000
TSEA3012995
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 381 Lot Size: 2,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 381 Lot Size: 2,000 Area: Mijas and Mijas Costa Region: Andalucía
Extreme luxury villa in Mijas Pueblo.
Have 2000 plot m2.
Space for put a pool with views to the sea/mountain.
Possibility to make a big guest house
Garage for 4/5/6 cars.
Possibility to have Fruit (...)
€900,000
TSEA3012014
- Campo Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 334 Lot Size: 1,243 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 334 Lot Size: 1,243 Area: Mijas and Mijas Costa Region: Andalucía
Large Villa located in Campo Mijas at short distance to services and with 100% privacy!!
It is distributed in 2 floors as follows:
Ground floor: Entrance hall, large living room with fireplace and (...)
€899,000
TSEA3010718
- Coín, Costa Del Sol, Coin
Beds: 5 Baths: 4 M2: 255 Lot Size: 6,032 Area: Coin Region: Andalucía
Beds: 5 Baths: 4 M2: 255 Lot Size: 6,032 Area: Coin Region: Andalucía
Extraordinary country abode. This magnificent dwelling is unique and inspiring. Designed with vulpine ingenuity and an artistic eye the accommodation within is both appealing and practical. The (...)
€2,300,463
TSEA2984450
- Los Almendros, Costa Del Sol, Marbella West
Beds: 5 Baths: 3 M2: 1,383 Lot Size: 4,017 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 3 M2: 1,383 Lot Size: 4,017 Area: Marbella West Region: Andalucía
New Bank repossession. A detached 5 bedroom villa with a total built area of 1,383m² situated on a plot of 4017m² and located in Los Almendros, within the municipality of Benahavís, in a quiet (...)
Current Featured Properties
€595,000
TSEA4927306
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 150 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 150 Area: Benahavis Region: Andalucía
ABSOLUTELY FABULOUS LA HEREDIA HOUSE RECENTLY REDUCED IN PRICE.
This stunning, detached, stand-alone house is one of the few original homes in the charming and picturesque village of La Heredia, (...)
€2,450,000
TSEA4952755
- Los Flamingos, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 675 Lot Size: 1,383 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 675 Lot Size: 1,383 Area: Estepona Region: Andalucía
Classic-Style Villa with Modern Elegance in Los Flamingos Golf – A Unique Opportunity! Located in the prestigious residential area of Los Flamingos, this villa offers sea views, privacy, and (...)
€4,600,000
TSEA4679626
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 5 M2: 474 Lot Size: 11 Area: Estepona Region: Andalucía
Beds: 4 Baths: 5 M2: 474 Lot Size: 11 Area: Estepona Region: Andalucía
Located in a picturesque and coveted setting amidst nature's splendour, This luxury development comprises a collection of twelve sophisticated and exclusive villas boasting contemporary aesthetics. (...)
