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 (162,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 (162,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 (162,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 141 - 160 of 2639
€5,995,000
TSEA5143663
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 314 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 314 Area: Marbella East Region: Andalucía
BEACHFRONT ELEGANCE ON THE GOLDEN MILE!
Discover this exceptional semi-detached home in the exclusive Oasis Club, one of the most desirable beachfront communities on Marbella's Golden Mile. Recently (...)
€190,000
TSEA5143645
- Jimena de la Frontera, Costa de la Luz
Beds: 4 Baths: 2 M2: 176 Region: Andalucía
Beds: 4 Baths: 2 M2: 176 Region: Andalucía
Semi-Detached House, Jimena de la Frontera, Costa de la Luz.
4 Bedrooms, 2 Bathrooms, Built 176 m², Terrace 16 m².
Setting : Village, Mountain Pueblo, Close To Schools, Close To Skiing, Close To (...)
€1,450,000
TSEA5143603
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 335 Lot Size: 956 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 335 Lot Size: 956 Area: Estepona Region: Andalucía
Step into a sunlit, character-filled family home where timeless Andalusian charm meets modern comfort. The ample sized open-plan kitchen, living, and dining area is flooded with light from (...)
€3,200,000
TSEA5143342
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 718 Lot Size: 2,000 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 718 Lot Size: 2,000 Area: Benalmadena Region: Andalucía
New Development: Prices from 3,200,000 € to 3,200,000 €. [Beds: 4 - 4] [Baths: 5 - 5] [Built size: 718.00 m2 - 718.00 m2]
The villa is located in a privileged setting, within the exclusive (...)
€1,995,000
TSEA5143321
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 336 Lot Size: 1,028 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 336 Lot Size: 1,028 Area: Marbella West Region: Andalucía
Nestled in a quiet cul-de-sac and within walking distance of shops and local services, this villa offers an ideal setting for relaxed family living in Nueva Andalucía. Recently renovated with taste (...)
€980,000
TSEA5143186
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 296 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 296 Area: Benalmadena Region: Andalucía
Exclusive House with Sea Views in Torremuelle, Benalmádena
Discover this spectacular 477 m² (terraces included) house, located in one of the most privileged and peaceful areas of Benalmádena, (...)
€795,000
TSEA5143135
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 191 Lot Size: 773 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 191 Lot Size: 773 Area: Estepona Region: Andalucía
Charming Andalusian Villa in Arena Beach, Estepona
This beautifully renovated independent villa combines traditional Andalusian charm with a fresh, contemporary style, creating the perfect home for (...)
€225,000
TSEA5143039
- Almogía, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 145 Lot Size: 4,100 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 145 Lot Size: 4,100 Area: Malaga Region: Andalucía
Tucked away in the countryside just outside Almogía, this charming end-of-terrace home (one of only three in the row) is made for quiet, rural living. The ground floor centres on a good-sized (...)
€1,550,000
TSEA5142997
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 8 M2: 277 Lot Size: 2,484 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 8 M2: 277 Lot Size: 2,484 Area: Mijas and Mijas Costa Region: Andalucía
UNIQUE OPPORTUNITY JUST OUTSIDE MIJAS PUEBLO!
This breathtaking group of properties don´t come onto the market too often. If you are looking to have a place where all of your loved ones can come (...)
€375,000
TSEA5142817
- Costalita, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 83 Lot Size: 40 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Lot Size: 40 Area: Estepona Region: Andalucía
Quaint 2 bedroom attached single level bungalow.
The home is located beachside of the A7 just steps away from Saladillo beach in Costalita.
The house features an open plan lounge, dining, kitchen and (...)
€850,000
TSEA5142802
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 5 Baths: 4 M2: 317 Lot Size: 600 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 4 M2: 317 Lot Size: 600 Area: Benalmadena Region: Andalucía
Discover this detached villa in one of the most exclusive areas of Benalmádena Costa, perfectly positioned for its privileged location and exceptional potential.
Set on a 600 m² plot, the villa (...)
€1,275,000
TSEA5142778
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 219 Lot Size: 930 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 219 Lot Size: 930 Area: Fuengirola Region: Andalucía
Key-Ready 3-Bedroom Villa with Panoramic Views in Torreblanca, Fuengirola!
Step into your perfect Mediterranean retreat with this stunning, modern and key-ready villa in the lovely area of (...)
€1,790,000
TSEA5142733
- Atalaya, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 300 Lot Size: 471 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 300 Lot Size: 471 Area: Estepona Region: Andalucía
Off-Plan Modern Golf Villa – El Campanario
Seize the chance to own a brand-new frontline golf villa with direct views over El Campanario's fairways. This off-plan contemporary residence combines (...)
€899,950
TSEA5142595
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 153 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 153 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 899,950 € to 995,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 153.00 m2 - 169.00 m2]
LUXURY TOWNHOUSES IN MIJAS COSTA - Building License expected October (...)
€975,000
TSEA5141941
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 321 Lot Size: 1,324 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 321 Lot Size: 1,324 Area: Marbella East Region: Andalucía
Fantastic opportunity; a four bedroom, south west facing villa in Elviria, close to all amenities, only a ten minute drive from Marbella Town, Puerto Banús, and close to the beach. The villa is (...)
€450,000
TSEA5141758
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 246 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 246 Area: Mijas and Mijas Costa Region: Andalucía
Discover the perfect balance between country charm and modern comfort in this registered home set on a generous 900 m² rustic plot. The main floor offers 4 bright bedrooms, including an impressive (...)
€475,500
TSEA5141713
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 151 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 151 Area: Mijas and Mijas Costa Region: Andalucía
Semi-Detached House, Riviera del Sol, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 151 m².
Setting : Close To Golf.
Orientation : South West.
Condition : Good.
Pool : Communal.
Climate Control : (...)
€208,000
TSEA5141512
- San Enrique, Costa Del Sol, Sotogrande
Beds: 4 Baths: 2 M2: 104 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 2 M2: 104 Area: Sotogrande Region: Andalucía
Renovated Apartment in San Enrique (Sotogrande, Costa del Sol)
In the quiet, residential area of San Enrique (Sotogrande), surrounded by amenities and with excellent connections to La Línea, (...)
€570,000
TSEA5141206
- Valle de Abdalajis, Costa Del Sol, Älora
Beds: 4 Baths: 2 M2: 155 Lot Size: 9,573 Area: Älora Region: Andalucía
Beds: 4 Baths: 2 M2: 155 Lot Size: 9,573 Area: Älora Region: Andalucía
CCharming single-story chalet in Valle de Abdalajís, Málaga, offering 155 m² of living space on a 9,573 m² plot. The 288 m² property features a 39 m² porch, 4 spacious bedrooms with fitted (...)
€5,799,000
TSEA5141032
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 522 Lot Size: 1,545 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 522 Lot Size: 1,545 Area: Benahavis Region: Andalucía
SNEAK PEEK AT CASA ARTOLA: A statement of lifestyle and exclusivity in the hills of Benahavís.
Set on a generous 1,550 m² south-facing plot, CASA ARTOLA captures the essence of refined
Andalusian (...)
Current Featured Properties
€8,096,900
TSEA4372201
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 583 Lot Size: 1,150 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 583 Lot Size: 1,150 Area: Benahavis Region: Andalucía
This is a luxury residential complex of 53 unique 4, 5 villas sitting gently on the side of a hill, with every villa standing on a different height. The prestigious position is over looking the (...)
€1,779,000
TSEA4938817
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 5 M2: 222 Area: Estepona Region: Andalucía
Beds: 4 Baths: 5 M2: 222 Area: Estepona Region: Andalucía
LAST UNITS ACT NOW! We offer you an exclusive development composed of 8 single family homes with 4 bedrooms, distributed over two floors, with large terraces, garden and private pool. Located in a (...)
€1,900,000
TSEA5005987
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 8 M2: 480 Lot Size: 1,878 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 8 M2: 480 Lot Size: 1,878 Area: Benahavis Region: Andalucía
ELEGANT VILLA WITH LARGE PLOT WITH SEA VIEWS AND SPA AREA
Fantastic villa with an elegant Mediterranean style, located in a quiet and private area next to San Pedro de Alcántara, La Quinta, Monte (...)
