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 2501 - 2520 of 2656 €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 (...)
€995,000
TSEA3794389
- Cortes de la Frontera, Costa Del Sol, Ronda
Beds: 3 Baths: 2 M2: 246 Lot Size: 12,100 Area: Ronda Region: Andalucía
Beds: 3 Baths: 2 M2: 246 Lot Size: 12,100 Area: Ronda Region: Andalucía
This lovely finca style in Cortes de la Frontera offers the perfect combination of size, quality, tranquility and much more only kilometers inland from the busy coast. Take flight from your home town (...)
€1,750,000
TSEA3792964
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 17 Baths: 10 M2: 773 Lot Size: 4,078 Area: Torremolinos Region: Andalucía
Beds: 17 Baths: 10 M2: 773 Lot Size: 4,078 Area: Torremolinos Region: Andalucía
Unique Property with Tremendous Potential in an Exclusive Location!
Strategically situated between Málaga and Torremolinos, this property boasts an expansive plot of 4,078 m², surrounded by olive (...)
€875,000
TSEA3787210
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 9 Baths: 10 M2: 1,089 Lot Size: 3,965 Area: Alhaurin el Grande Region: Andalucía
Beds: 9 Baths: 10 M2: 1,089 Lot Size: 3,965 Area: Alhaurin el Grande Region: Andalucía
¡GREAT INVESTMENT OPPORTUNITY! This private villa is about 70% completed and could also be used as a Boutique hotel or bed & breakfast. There are lots of possibilities with a build size of (...)
€185,000
TSEA3784570
- Torrox, Costa Del Sol East
Beds: 2 Baths: 1 M2: 80 Lot Size: 30,000 Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Lot Size: 30,000 Region: Andalucía
The property is 15 minutes from the coast and consists of a farmhouse of 82 m2 and a plot of land on terraces of 30,000 m2 of land, has good views of the sea and the mountains, very quiet area. (...)
€1,295,000
TSEA3780094
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M2: 382 Lot Size: 610 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 4 M2: 382 Lot Size: 610 Area: Marbella West Region: Andalucía
Location! Location! Location!
Large Mediterranean Villa with south orientation sea Views located in the upper part of Nueva Andalucía. The property has very easy access from the Main Street in (...)
€795,000
TSEA3767719
- Arcos de la Frontera, Costa de la Luz
Beds: 6 Baths: 4 M2: 400 Lot Size: 2,435 Region: Andalucía
Beds: 6 Baths: 4 M2: 400 Lot Size: 2,435 Region: Andalucía
What a perfect location for Golf enthusiasts in Arcos Garden !!
This beautiful south facing villa is opposite the 17th hole of Arcos Golf, the Exclusive and spectacular golf course surrounded by a (...)
€4,500,000
TSEA3761173
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 5 Baths: 5 M2: 450 Lot Size: 950 Area: Marbella Region: Andalucía
Beds: 5 Baths: 5 M2: 450 Lot Size: 950 Area: Marbella Region: Andalucía
This marvellous five bedroom family villa sits in the most prestigious resident hills of Marbella, in a quiet and private area, in Cascada de Camojan. Its design and decoration, in a mixture of (...)
€4,500,000
TSEA3749149
- Las Brisas, Costa Del Sol, Marbella West
Beds: 6 Baths: 5 M2: 390 Lot Size: 1,653 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 5 M2: 390 Lot Size: 1,653 Area: Marbella West Region: Andalucía
Wonderful property with mountain views, near the Las Brisas Golf course!
Fabulous villa, built and designed in a contemporary style, with luxury purposes, high quality materials, designed to offer a (...)
€689,000
TSEA3731638
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 3 M2: 426 Lot Size: 6,864 Area: Coin Region: Andalucía
Beds: 4 Baths: 3 M2: 426 Lot Size: 6,864 Area: Coin Region: Andalucía
Finca with AFO!!
Great Finca very well built on a fully usable plot with plenty of water.
The property has very good road access located a short distance to Coin and is distributed over 3 floors as (...)
€1,595,000
TSEA3712520
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 344 Lot Size: 440 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 344 Lot Size: 440 Area: San Pedro Region: Andalucía
INDEPENDENT HOUSE NEXT TO THE CENTER OF SAN PEDRO DE ALCÁNTARA
Independent villa, a few minutes walk from the center of San Pedro de Alcántara, the boulevard and all kinds of services (schools, (...)
€6,895,000
World class design-led villas with spectacular views
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía
400,000€ discount if you purchase before completion! This is a sustainable luxury development of 18 individually designed villas situated in the 200-hectare country club estate of Real de La (...)
€8,450,000
TSEA3704048
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 5 Baths: 5 M2: 1,104 Lot Size: 24,500 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 5 M2: 1,104 Lot Size: 24,500 Area: San Pedro Region: Andalucía
Impressive Luxury Villa in 24.500 m2 plot in Guadalmina.
Located in one of the best areas on Costa del Sol, close to golf and San Pedro de Alcántara and just a short ride to the beach.
The (...)
€560,000
TSEA3688946
- Los Barrios, Costa Del Sol, Algeciras
Beds: 4 Baths: 3 M2: 478 Lot Size: 1,216 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 3 M2: 478 Lot Size: 1,216 Area: Algeciras Region: Andalucía
Beautiful villa in classic Andalusian style,
on a plot of 1216 m2 with south east exposure, the villa has a constructed area of 478 m2,
completely renovated, equipped with hot and cold air (...)
€1,590,000
TSEA3687812
- Entrerrios, Costa Del Sol
Beds: 3 Baths: 3 M2: 1,018 Lot Size: 72,000 Region: Andalucía
Beds: 3 Baths: 3 M2: 1,018 Lot Size: 72,000 Region: Andalucía
Reduced from 1.710.000 to 1.590.000 for a quick sale
Large rustic finca right next to the river with a plot of 72.000m2!
This property has easy access to the road, is about 7km from the coast and its (...)
€280,000
TSEA3679934
- Yunquera, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 98 Lot Size: 130,000 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 98 Lot Size: 130,000 Area: Marbella Region: Andalucía
The perfect place for growing avocado trees and start a new business. According to experts, the best in the province of Malaga. Thirteen hectares with several water wells and the right to seventy (...)
€650,000
TSEA3672731
- Coín, Costa Del Sol, Coin
Beds: 5 Baths: 3 M2: 400 Lot Size: 6,575 Area: Coin Region: Andalucía
Beds: 5 Baths: 3 M2: 400 Lot Size: 6,575 Area: Coin Region: Andalucía
Stunning country house with wonderful views, with a profit of € 30,000 from the own avocado plantation, per year.
The construction area of this house is 362m2 built, it has 158m2 basement, (...)
€2,650,000
TSEA3670745
- Atalaya, Costa Del Sol, Estepona
Beds: 7 Baths: 7 M2: 920 Lot Size: 3,244 Area: Estepona Region: Andalucía
Beds: 7 Baths: 7 M2: 920 Lot Size: 3,244 Area: Estepona Region: Andalucía
Cozy independent Andalusian style villa in Atalaya, Estepona, close to all services and golf courses. The villa is divided into two parts and each of them has its independent access and entrance. In (...)
€1,350,000
TSEA3668675
- Casares Playa, Costa Del Sol, Casares
Beds: 4 Baths: 2 M2: 310 Lot Size: 2,200 Area: Casares Region: Andalucía
Beds: 4 Baths: 2 M2: 310 Lot Size: 2,200 Area: Casares Region: Andalucía
Beautiful RUSTIC STYLE FINCA with 2,200m plot in CASARES PLAYA, recently RENOVATED giving it a modern touch throughout, such as the kitchen and bathrooms. This magnificent property is excellently (...)
€3,350,000
TSEA3667556
- Marbesa, Costa Del Sol, Marbella East
Beds: 5 Baths: 6 M2: 390 Lot Size: 779 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 6 M2: 390 Lot Size: 779 Area: Marbella East Region: Andalucía
TOTALLY NEW ULTRA MODERN BEACHSIDE VILLA WITH SEA VIEWS IN MARBESA, ELVIRIA BEACH.
Fabulous brand new modern villa situated in the residential area of Marbesa Beach, one of the areas of Elviria, (...)
Current Featured Properties
€6,395,000
Detached Villa in Benahavis
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 498 Lot Size: 2,406 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 498 Lot Size: 2,406 Area: Benahavis Region: Andalucía
A PROPERTY IN A DIFFERENT LEAGUE!!
400,000€ discount if you purchase before completion! This is a sustainable luxury development of 18 individually designed villas situated in the 200-hectare (...)
€1,400,000
TSEA4954306
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 372 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 372 Area: Estepona Region: Andalucía
An exclusive development of seventeen designer villas located in the Estepona golf course, where luxury and sustainability come together to create unique, welcoming homes with expansive open spaces (...)
€7,900,000
TSEA4328788
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 12 M2: 348 Lot Size: 814 Area: Marbella Region: Andalucía
Beds: 7 Baths: 12 M2: 348 Lot Size: 814 Area: Marbella Region: Andalucía
This is a collection of six exclusive luxury villas in the Cascada de Camojan urbanization, in the surroundings of Sierra Blanca, in the heart of Marbella's Golden Mile. The homes will be located (...)
