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 (62,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67)
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 (62,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67)
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 (62,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Bar - (121), Restaurant - (121), Hotel - (121), Night Club - (121), Hostel - (121), Guesthouse - (121), Bed & Breakfast - (121), Shop - (121), Office - (121), Garage - (121), Mobile Home - (121), Mooring - (121), Business - (121), Farm - (121), Stables - (121), Cafe - (121), Other - (121), Storage Room - (121), Parking Space - (121)Properties
Results 1 - 20 of 121
€1,800,000
TSEA5150827
- Periana, Costa Del Sol East
Beds: 7 Baths: 9 M2: 1,133 Lot Size: 140,000 Region: Andalucía
Beds: 7 Baths: 9 M2: 1,133 Lot Size: 140,000 Region: Andalucía
HIGHLIGHTS
Casa Rosa is far more than a home: it is a captivating theatrical backdrop infused with Tuscan charm, designed to host grand family celebrations or to enjoy everyday family life. This (...)
€1,300,000
TSEA5135335
- Capuchinos, Costa Del Sol
Beds: 7 Baths: 5 M2: 420 Region: Andalucía
Beds: 7 Baths: 5 M2: 420 Region: Andalucía
Investment Opportunity in the Heart of Málaga
Residential building with ground floor + 4 upper levels, located in one of the city's most promising areas. It consists of 6 apartments (2 per floor) (...)
€535,000
TSEA5134762
- Casabermeja, Costa Del Sol, Antequera
Beds: 4 Baths: 4 M2: 24,000 Area: Antequera Region: Andalucía
Beds: 4 Baths: 4 M2: 24,000 Area: Antequera Region: Andalucía
Unique Opportunity! Rural home + business just 20 min from Málaga
Privileged location: nature, tranquility and spectacular views, only 36 km from the airport.
It has 24,000m2 of land according to (...)
€1,100,000
TSEA5131039
- Málaga Centro, Costa Del Sol, Malaga
Beds: 5 Baths: 5 M2: 360 Area: Malaga Region: Andalucía
Beds: 5 Baths: 5 M2: 360 Area: Malaga Region: Andalucía
UNIQUE INVESTMENT OPPORTUNITY – 5 TOURIST APARTMENTS IN THE HEART OF MÁLAGA
For sale: 5 independent, fully refurbished tourist apartments, each with its own active tourist rental license, ready (...)
€1,278,000
TSEA5121865
- Cancelada, Costa Del Sol, Estepona
Beds: 12 Baths: 12 M2: 303 Area: Estepona Region: Andalucía
Beds: 12 Baths: 12 M2: 303 Area: Estepona Region: Andalucía
We present this fully operational property with an official tourist license, located in one of the most sought-after areas of the Costa del Sol. Set in the charming village of Cancelada, within the (...)
€375,000
TSEA5117002
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 1 M2: 236 Area: Estepona Region: Andalucía
Beds: 4 Baths: 1 M2: 236 Area: Estepona Region: Andalucía
Fantastic commercial premises for sale in Bahía Dorada, Estepona
Fantastic commercial premises of 236 m² for sale, located in the well established urbanisation of Bahía Dorada, just a few steps (...)
€1,350,000
TSEA5116615
- Benamocarra, Costa Del Sol East
Beds: 1 Baths: 2 M2: 676 Lot Size: 5,857 Region: Andalucía
Beds: 1 Baths: 2 M2: 676 Lot Size: 5,857 Region: Andalucía
Gas station in Benamocarra with a restaurant and Mechanic´s workshop.
1. Annual fuel sales: approximately 1,000,000 liters (with an average of 45 to 50 cars refueling daily).
2. Gross profit per (...)
€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 (...)
€199,000
TSEA5107873
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 1 M2: 102 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 1 M2: 102 Area: Mijas and Mijas Costa Region: Andalucía
"Great Investment Opportunity in Mijas, on the Border with Fuengirola!
Commercial premises with project and license for change of use to residential. Located on a quiet street, just steps away (...)
€4,500,000
TSEA5105944
- Monda, Costa Del Sol, Marbella
Beds: 10 Baths: 8 M2: 8,000 Area: Marbella Region: Andalucía
Beds: 10 Baths: 8 M2: 8,000 Area: Marbella Region: Andalucía
farm with many possibilities of 15 hectares in Coin near Monda, it has a bullring, farmhouse, celebration halls
€545,000
TSEA5104330
- Monda, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 85 Lot Size: 31,000 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 85 Lot Size: 31,000 Area: Marbella Region: Andalucía
Avocado & Dragon Fruit Farm – Your Own Mountain Retreat
. Nestled in nature
. Income-generating property
. Spectacular panoramic views
. Greenhouses (2 total)
. Secluded
. You'll (...)
€1,697,000
TSEA5080597
- Málaga, Costa Del Sol, Malaga
Beds: 6 Baths: 6 M2: 504 Area: Malaga Region: Andalucía
Beds: 6 Baths: 6 M2: 504 Area: Malaga Region: Andalucía
Looking for a well-located building, just steps from the Historic Center? We have what you're looking for!
This 2007 building is located on a quiet street with an excellent location and easy access (...)
€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 (...)
€2,300,000
TSEA5075203
- Villanueva De La Concepcion, Costa Del Sol, Malaga
Beds: 13 Baths: 13 M2: 935 Lot Size: 50,000 Area: Malaga Region: Andalucía
Beds: 13 Baths: 13 M2: 935 Lot Size: 50,000 Area: Malaga Region: Andalucía
LUXURY BOUTIQUE HOTEL WITH HELIPAD - TENNIS COURT - HEATED POOL.
This boutique hotel in Villanueva de la Concepción, near the Torcal Mountains, offers 11 beautifully renovated rooms and (...)
€4,250,000
TSEA5073775
- Casares, Costa Del Sol, Casares
Beds: 6 Baths: 5 M2: 2,000 Lot Size: 45,000 Area: Casares Region: Andalucía
Beds: 6 Baths: 5 M2: 2,000 Lot Size: 45,000 Area: Casares Region: Andalucía
A Unique, Multi-Faceted Estate - Diverse development potential, sitting on a plot of 45,000m2.
Tucked between gentle hills and a river, this discreet rural estate offers a rare combination of (...)
€850,000
TSEA5066983
- San Martín de Tesorillo, Costa Del Sol, Sotogrande
Beds: 1 Baths: 1 M2: 100 Lot Size: 40,000 Area: Sotogrande Region: Andalucía
Beds: 1 Baths: 1 M2: 100 Lot Size: 40,000 Area: Sotogrande Region: Andalucía
Awesome plot, easy accessible and close to san martin de tesorillo on the road to Jimena.
Gorgeous located plot with water and electric. Working business and has avocados and oranges. 40000M2 of (...)
€1,295,000
TSEA5060893
- Gaucín, Costa Del Sol, Gaucin
Beds: 7 Baths: 7 M2: 695 Lot Size: 277 Area: Gaucin Region: Andalucía
Beds: 7 Baths: 7 M2: 695 Lot Size: 277 Area: Gaucin Region: Andalucía
FOR SALE: Boutique Hotel in Gaucín, Andalusia
A rare opportunity in one of Andalusia's most charming white villages
Set in the heart of Gaucín, this unique boutique hotel offers a rare blend of (...)
€480,000
TSEA5052310
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 80 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Area: Marbella West Region: Andalucía
Discover this spectacular office for sale in the heart of Nueva Andalucía! Located in the prestigious Alzambra Commercial Centre, this property is ideal for entrepreneurs and professionals looking (...)
€1,000,000
TSEA5050369
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 216 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 216 Area: San Pedro Region: Andalucía
Investment Opportunity in the Heart of San Pedro de Alcántara – Ideal for Boutique Hotel or Apartment Conversion
Prime Central Location
Located right in the town center of San Pedro de (...)
€449,000
TSEA5048020
- Arcos de la Frontera, Costa de la Luz
Beds: 4 Baths: 6 M2: 272 Lot Size: 159 Region: Andalucía
Beds: 4 Baths: 6 M2: 272 Lot Size: 159 Region: Andalucía
strong>Imposing Boutique hotel for sale in Arcos de la Frontera</strong>
Exquisite conversion of a traditional three-story building in the picturesque town of Arcos de la Frontera, (...)
