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 (50)
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 (50)
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 (50)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 20
€1,300,000
TSEA5111383
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 4 Baths: 6 M2: 688 Lot Size: 474 Area: Alhaurin el Grande Region: Andalucía
Beds: 4 Baths: 6 M2: 688 Lot Size: 474 Area: Alhaurin el Grande Region: Andalucía
A Rare Opportunity to Own One of Malaga's Most Iconic Restaurants — With Two Beautiful Apartments Included
Welcome to Santiago's Kitchen, a celebrated fine dining restaurant located in the heart (...)
€1,680,000
TSEA5078299
- El Paraiso, Costa Del Sol, Estepona
Beds: 7 Baths: 4 M2: 756 Area: Estepona Region: Andalucía
Beds: 7 Baths: 4 M2: 756 Area: Estepona Region: Andalucía
FOR SALE: TWO RESTAURANTS ON THE SAME PLOT – UNIQUE OPPORTUNITY IN EL PARAÍSO, ESTEPONA
Prime Location: Avenida de la Playa 5, El Paraíso – Estepona (Málaga)
Total built area: 756 m²
Asking (...)
€6,900,000
TSEA5017921
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 2 M2: 373 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 2 M2: 373 Area: Benahavis Region: Andalucía
Exclusive Investment Opportunity in Benahavís, Costa del Sol
This is an exclusive listing with YourEstateInTheSun.com.
All agent inquiries must go through YourEstateInTheSun.com as the primary (...)
€1,500,000
TSEA5017663
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 200 Lot Size: 208 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Lot Size: 208 Area: Marbella Region: Andalucía
Restaurant located in a beautiful residential area of the most exclusive and one of the most charming corners of Marbella and the entire Costa del Sol.
This urbanization is just a few minutes drive (...)
€360,000
TSEA5005453
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 99 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 99 Area: Marbella West Region: Andalucía
Commercial premises with an Italian restaurant for sale in Nueva Andalucia.
Buy the premises and renegotiate the lease with the current tenant or negotiate a transfer valued at €150,000 and take (...)
€1,260,000
TSEA4956124
- Málaga, Costa Del Sol, Malaga
Beds: 4 Baths: 1 M2: 960 Lot Size: 58,000 Area: Malaga Region: Andalucía
Beds: 4 Baths: 1 M2: 960 Lot Size: 58,000 Area: Malaga Region: Andalucía
Seize the opportunity to own an extraordinary country estate in the breathtaking Montes de Málaga, just 10 minutes from the city center and 25 minutes from the airport.
Spanning an impressive 970 (...)
€1,600,000
TSEA4952035
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 561 Lot Size: 300 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 561 Lot Size: 300 Area: Estepona Region: Andalucía
Anyone looking for a long established business with combined living premises MUST see this property.
This fantastic traditional Andalucian building has been an established Restaurant in this (...)
€360,000
TSEA4929094
- Torremolinos Centro, Costa Del Sol, Torremolinos
Beds: 1 M2: 276 Lot Size: 276 Area: Torremolinos Region: Andalucía
Beds: 1 M2: 276 Lot Size: 276 Area: Torremolinos Region: Andalucía
Generous Restaurant for Sale in Well Located in Torremolinos Málaga
This restaurant for sale is situated in the municipality of Torremolinos. Torremolinos is a popular town in the province of (...)
€750,000
TSEA4903516
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 2 M2: 87 Lot Size: 67 Area: Marbella Region: Andalucía
Beds: 1 Baths: 2 M2: 87 Lot Size: 67 Area: Marbella Region: Andalucía
Fantastic restaurant for sale in the old town of Marbella.
Located on one of the best streets.
Currently it has only one floor and also a pleasant upper terrace.
In the case of wanting to use it as (...)
€309,900
TSEA4898146
- Coín, Costa Del Sol, Coin
Beds: 1 Baths: 2 M2: 100 Area: Coin Region: Andalucía
Beds: 1 Baths: 2 M2: 100 Area: Coin Region: Andalucía
OPPORTUNITY IN COÍN! COMMERCIAL PROPERTY WITH GREAT POTENTIAL
We are offering this spacious 2-story commercial property for sale, perfect for starting your business or converting it into a home, (...)
€475,000
TSEA4839229
- Guaro, Costa Del Sol, Guaro
Beds: 5 Baths: 5 M2: 595 Lot Size: 4,884 Area: Guaro Region: Andalucía
Beds: 5 Baths: 5 M2: 595 Lot Size: 4,884 Area: Guaro Region: Andalucía
Restaurant with included living quarters on the road from COIN to TOLOX, near GUARO. A popular route for cyclists, motorcyclists and nature enthusiasts.
A typical Spanish roadside restaurant - a so (...)
€425,000
TSEA4742224
- Benajarafe, Costa Del Sol East
Beds: 1 Baths: 2 M2: 188 Lot Size: 188 Region: Andalucía
Beds: 1 Baths: 2 M2: 188 Lot Size: 188 Region: Andalucía
Discover an exceptional opportunity to open your own restaurant on the stunning coast of Chilches Costa! With a built area of 188 m2, this restaurant offers plenty of space to bring your culinary (...)
€329,000
TSEA4661497
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 152 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 152 Area: Estepona Region: Andalucía
APARTMENT + BAR - UNIQUE INVESTMENT OPPORTUNITY IN ESTEPONA'S THRIVING HOSPITALITY SCENE
Welcome to an exciting investment opportunity nestled in the vibrant locale of Estepona, near La Panera and (...)
€200,000
TSEA4382182
- Cancelada, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 540 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 540 Area: Estepona Region: Andalucía
Restaurant, Show Club and Karaoke for LEASE
A huge local divided into 4 rooms.
The main room is a Show Club with a stage, DJ setup, tables with sofas and a large bar.
2 bathrooms
2 restaurant rooms (...)
€2,000,000
TSEA4190944
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 4 M2: 1,500 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 4 M2: 1,500 Area: Sotogrande Region: Andalucía
Restaurant, Sotogrande, Costa del Sol.
3 Bedrooms, 4 Bathrooms, Built 1500 m², Terrace 200 m².
Setting : Commercial Area, Close To Golf, Close To Port, Close To Shops, Close To Sea, Close To Town, (...)
€275,000
TSEA4190938
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 3 Baths: 1 M2: 90 Area: Manilva Region: Andalucía
Beds: 3 Baths: 1 M2: 90 Area: Manilva Region: Andalucía
bar restaurante en pleno funcionamiento con gran facturación, a escasos metros de la playa de sabinillas, totalmente equipado para empezar a trabajar, todas la licencias en regla, amplia terraza de (...)
€1,100,000
TSEA4104844
- Cabopino, Costa Del Sol, Marbella East
Beds: 5 Baths: 2 M2: 165 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 2 M2: 165 Area: Marbella East Region: Andalucía
PROPERTY IN FULL DOMAIN.
Restaurant for sale consists of 5 commercial premises (Bar, Equipped kitchen, Two indoor salines for dinners, A local for storage,) approximately 40 m2 each and a property (...)
€675,000
TSEA4095229
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 4 M2: 286 Lot Size: 2,500 Area: Casares Region: Andalucía
Beds: 3 Baths: 4 M2: 286 Lot Size: 2,500 Area: Casares Region: Andalucía
The restaurant is very well established for over 20 years and has excellent turnover and very good profit and is currently set up to provide forty or fifty covers per service, though is capable of (...)
€1,150,000
TSEA3795283
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 567 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 567 Area: Benahavis Region: Andalucía
This is an investment opportunity to purchase this amazing piece of Real Estate, under the Municipal of Benahavis. The property has been ran as a very successfull Restaurant for over 40 years, but (...)
€975,000
TSEA3319975
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 520 Lot Size: 2,188 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 520 Lot Size: 2,188 Area: Estepona Region: Andalucía
Estepona: Unique finca type property offered for sale, currently run as an events location and restaurant with living accommodation above. The ground floor has large outside area with bar, bbq area (...)
