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,36,37,38)
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,36,37,38)
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,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 61 - 80 of 306 €2,200,000
TSEA5111350
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 323 Lot Size: 100 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 323 Lot Size: 100 Area: Marbella East Region: Andalucía
Exquisite Luxury Villa in Altos de Puente Romano, Marbella
A stunning architectural masterpiece in the prestigious Altos de Puente Romano, Marbella, this ultra-luxury villa offers an unparalleled (...)
€599,000
TSEA5111263
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 233 Lot Size: 20 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 233 Lot Size: 20 Area: Marbella West Region: Andalucía
SEMI-DETACHED VILLA IN NUEVA ANDALUCÍA – PRIME LOCATION NEAR PUERTO BANÚS
Discover this elegant 4-bedroom, 5-bathroom semi-detached villa, ideally situated in one of Marbella's most sought-after (...)
€990,000
TSEA5110603
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 3 M2: 267 Lot Size: 103 Area: Marbella Region: Andalucía
Beds: 6 Baths: 3 M2: 267 Lot Size: 103 Area: Marbella Region: Andalucía
A rustic town house, full of charm and character, consisting of two spacious independent apartments, one on each floor, both of which share a common entrance from the street through an elegant (...)
€385,000
TSEA5110435
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 128 Lot Size: 138 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Lot Size: 138 Area: Manilva Region: Andalucía
New Development: Prices from 385,000 € to 490,000 €. [Beds: 2 - 3] [Baths: 2 - 3] [Built size: 128.00 m2 - 207.00 m2]
VILLA 1
207.45 m² built on a 240 m² plot. It has 3 bedrooms, 3 (...)
€530,000
TSEA5110408
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M2: 220 Lot Size: 180 Area: Casares Region: Andalucía
Beds: 4 Baths: 4 M2: 220 Lot Size: 180 Area: Casares Region: Andalucía
MAGNIFICENT SEMI-DETACHED HOUSE WITH 4 BEDROOMS NEXT TO THE FINCA CORTESÍN GOLF COURSE
Located next to the Finca Cortesín Golf Course, one of the most prestigious golf courses in Spain, it has (...)
€179,800
TSEA5110210
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 40 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 40 Area: Fuengirola Region: Andalucía
Your Sweet Seaside Retreat! Ideal Studio in a Prime Location Between Miramar and the Center of Fuengirola, walking distance to the beach
Discover this charming 40 m² studio, perfectly located (...)
€1,050,000
TSEA5107402
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 3 M2: 404 Lot Size: 300 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 3 M2: 404 Lot Size: 300 Area: San Pedro Region: Andalucía
Semi-Detached House, San Pedro de Alcántara, Costa del Sol.
5 Bedrooms, 3 Bathrooms, Built 404 m², Terrace 20 m², Garden/Plot 300 m².
Setting : Town, Commercial Area, Village, Close To Shops, (...)
€495,000
TSEA5106811
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 80 Lot Size: 193 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 80 Lot Size: 193 Area: Mijas and Mijas Costa Region: Andalucía
Your Dream Spanish Retreat Awaits – Just Steps from the Beach in Calahonda!
Imagine waking up to the gentle sea breeze, strolling to golden sands for a morning swim, and enjoying lazy (...)
€2,100,000
TSEA5106727
- Río Real, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 356 Lot Size: 99 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 356 Lot Size: 99 Area: Marbella East Region: Andalucía
Immerse Yourself in a Unique Lifestyle on the Costa del Sol.
Discover the exceptional lifestyle offered by this elegant semi-detached villa, located in one of Marbella's most prestigious (...)
€395,000
TSEA5104066
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 128 Lot Size: 153 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Lot Size: 153 Area: Manilva Region: Andalucía
Brand new semi-detached house 500m from the beach located in Aldea Hills, Manilva. The house has a constructed area of approximately 150m2 and consists of 2 bedrooms, 2 bathrooms, a living (...)
€510,000
TSEA5103988
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 177 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 177 Area: Benalmadena Region: Andalucía
Welcome to your new home. This beautiful villa combines comfort and style in a space designed for maximum enjoyment.
Upon entering, you'll find an Andalusian patio that envelops you with its decor (...)
€2,695,000
TSEA5103814
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 170 Lot Size: 150 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 170 Lot Size: 150 Area: Marbella East Region: Andalucía
Semi-Detached Villa in Altos de Salamanca – Marbella's Golden Mile
Located within the prestigious gated community of Altos de Puente Romano, in the charming community of Altos de Salamanca, this (...)
€388,000
TSEA5083777
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 2 M2: 111 Lot Size: 197 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Lot Size: 197 Area: Nerja and Malaga East Region: Andalucía
New Development: Prices from 388,000 € to 464,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 111.00 m2 - 133.00 m2]
EXCLUSIVE 3-BEDROOM SINGLE-FAMILY HOMES
This project is tailored to the (...)
€429,000
TSEA5083201
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 150 Lot Size: 72 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 150 Lot Size: 72 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful and cosy semi detached villa in a nice gated community in Riviera del Sol. Close to shops and sea. Nice private garden with outdoor kitchen and barbeque. Easy access to AP7. The house has (...)
€420,000
TSEA5082994
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 140 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 140 Area: Casares Region: Andalucía
Corner House with Large Garden Just Steps from the Beach – Bahía de Casares
Located in a quiet residential area just a 6-minute walk from the sandy beach of Bahía de Casares, this charming (...)
€4,300,000
TSEA5081656
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 242 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 242 Area: Estepona Region: Andalucía
Discover an exceptional opportunity to own one of only two exclusive frontline villas in The Edge, Estepona's most sought-after luxury beachfront development.
This stunning 4-bedroom, 3-bathroom (...)
€2,595,000
TSEA5081200
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 430 Lot Size: 285 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 430 Lot Size: 285 Area: Marbella West Region: Andalucía
Elegant Semi-Detached Villa in Nueva Andalucia, Marbella
Set within the prestigious gated enclave of Peñablanca, this beautifully renovated semi-detached villa offers an exceptional blend of style, (...)
€349,500
TSEA5081167
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 111 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 111 Area: Fuengirola Region: Andalucía
Welcome to your next home, perfectly located in a southeasterly direction with an impressive view of both the city and the sea
A fantastic home with 2 spacious bedrooms and a stylish bathroom on the (...)
€479,900
TSEA5078107
- Lauro Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 174 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 174 Area: Mijas and Mijas Costa Region: Andalucía
Wonderful house has just been put up for sale in the scenic Golf Resort near Malaga.
The area and the course are a big favorite among golfers, who are attracted by 27 holes in top quality. In (...)
€599,000
TSEA5077930
- Lauro Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 203 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 203 Area: Mijas and Mijas Costa Region: Andalucía
Very spacious home in the scenic Golf Resort near Malaga.
The area and the golf course are a big favorite among golfers, who are attracted by the 27 holes in top quality.
Weekly tournaments and (...)
Current Featured Properties
€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 (...)
€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 (...)
€1,580,000
TSEA4639777
- 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 (...)
