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 (56)
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 (56)
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 (56)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 8 of 8
€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 (...)
€745,000
TSEA5014006
- Málaga, Costa Del Sol, Malaga
Beds: 7 Baths: 2 M2: 806 Area: Malaga Region: Andalucía
Beds: 7 Baths: 2 M2: 806 Area: Malaga Region: Andalucía
Unique opportunity in Málaga! Spectacular commercial space for sale in a prime location, bordering two streets, one of which is Héroe de Sostoa. This spacious space features a 438 m² commercial (...)
€1,900,000
TSEA4433290
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 1 M2: 700 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 1 M2: 700 Area: San Pedro Region: Andalucía
Interesting local commercial for sale in the hearth of San Pedro de Alcántara,
€299,999
TSEA4246231
- Algarrobo, Costa Del Sol East
Beds: 1 Baths: 1 M2: 194 Lot Size: 194 Region: Andalucía
Beds: 1 Baths: 1 M2: 194 Lot Size: 194 Region: Andalucía
We present you this fantastic and spacious local located in one of the busiest areas. It ́s on the main road that runs through Malaga. This property has endless possibilities. It also has the (...)
€325,000
TSEA4095334
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 135 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Marbella East Region: Andalucía
Freehold This is an interesting property with lots of investment potential it has a small shop downstairs on the main square of Cabopino and also a studio apartment on the upper level.
€849,000
TSEA4076791
- Torre del Mar, Costa Del Sol East
Beds: 1 Baths: 2 M2: 80 Lot Size: 152 Region: Andalucía
Beds: 1 Baths: 2 M2: 80 Lot Size: 152 Region: Andalucía
One of the best locations for a charming and well maintained business premises with guaranteed business success. In the tourist town of Torre del Mar, we offer this fantastic business premises, just (...)
€980,000
TSEA3730702
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 2 M2: 220 Area: Marbella Region: Andalucía
Beds: 5 Baths: 2 M2: 220 Area: Marbella Region: Andalucía
Fantastic Local in Marbella with a wonderful location practically on the beachfront fully finished and renovated ready to
Entering, this place would be very interesting for a dental clinic or for a (...)
€140,000
TSEA3575893
- La Mairena, Costa Del Sol, Marbella East
Beds: 1 Baths: 1 M2: 53 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 1 M2: 53 Area: Marbella East Region: Andalucía
Office in La Mairena next to German college. Currently rented at €700 per month.
Shop, La Mairena, Costa del Sol.
Built 53 m².
Setting : Close To Schools.
Condition : Excellent.
Climate Control (...)
