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 (70,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 (70,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 (70,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 421 - 440 of 786 €220,000
TSEA5005558
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 4 Baths: 3 M2: 137 Lot Size: 176 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 3 M2: 137 Lot Size: 176 Area: Algeciras Region: Andalucía
EXCLUSIVE SEMI-DETACHED HOUSE IN A PRIVILEGED DEVELOPMENT – ALCAIDESA
BANK OPPORTUNITY
Opportunity for investors, flat for sale WITHOUT POSSESSION, the property comes from a (...)
€399,000
TSEA5005489
- Monda, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 221 Lot Size: 140 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 221 Lot Size: 140 Area: Marbella Region: Andalucía
Large Urban Townhouse with Studio
. Fabulous views of the village and Castillo de Monda
. So many options. Now 1 Bed but was originally a 3 bedroom property
. Separate studio
. Open plan (...)
€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 (...)
€360,000
TSEA5004820
- Benajarafe, Costa Del Sol East
Beds: 3 Baths: 2 M2: 104 Region: Andalucía
Beds: 3 Baths: 2 M2: 104 Region: Andalucía
If you're looking for a home by the sea, this villa in Benajarafe is a magnificent option!
Located in a residential area with a pool, just a few minutes' walk from the beach, its promenade, and its (...)
€675,000
TSEA5004523
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 143 Lot Size: 154 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 143 Lot Size: 154 Area: Marbella West Region: Andalucía
Spectacular semi-detached villa for sale in Nueva Andalucia, Marbella!
This modern, spacious, and very bright villa with 4 bedrooms, 2 bathrooms, and 1 toilet is located in a beautiful area, (...)
€1,991,000
TSEA5003710
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 359 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 359 Area: Marbella Region: Andalucía
NEWLY REFURBISHED
This beautifully presented contemporary townhouse has been recently renovated with high-quality materials offering luxury finishes and incredible use of space. This south-facing (...)
€699,000
TSEA5003200
- Nagüeles, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 226 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 226 Area: Marbella Region: Andalucía
Townhouse Ideal for Airbnb - High Demand Profitability in Marbella. Semi-detached villa located in the exclusive area of Marbella's golden mile Nagüeles. The property is distributed over four (...)
€650,000
TSEA5003194
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 160 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Estepona Region: Andalucía
**Stunning 3-Bedroom Apartment in Oceana Gardens**
Discover this elegant 3-bedroom, 2-bathroom apartment in the sought-after **Oceana Gardens** community. Offering breathtaking **sea and mountain (...)
€635,000
TSEA5003053
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 140 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Estepona Region: Andalucía
Located in a quiet residential area of Bel-Air, in the coveted New Golden Mile, this charming townhouse is perfect for those looking for spaciousness, comfort and a life close to the sea. It is (...)
€1,050,000
TSEA5002924
- Málaga Centro, Costa Del Sol, Malaga
Beds: 4 Baths: 4 M2: 143 Area: Malaga Region: Andalucía
Beds: 4 Baths: 4 M2: 143 Area: Malaga Region: Andalucía
Exclusive Beachfront Home with Unrivalled Sea Views in El Palo, Málaga
We present this exceptional beachfront property located in El Palo, one of Málaga's most iconic and sought-after coastal (...)
€2,599,500
TSEA5002918
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 255 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 255 Area: Estepona Region: Andalucía
Completely renovated townhouse frontline beach on the new Golden Mile
This property has been completely renovated from scratch with very high qualities. This Townhouse offers 4 bedrooms and 4 (...)
€985,000
TSEA5002420
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 300 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 300 Area: Estepona Region: Andalucía
Nestled in the charming and historic Estepona Old Town, this unique building offers an exceptional opportunity for those seeking a spacious property in a prime location. Boasting six bedrooms, four (...)
€850,000
TSEA5002369
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 204 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 204 Area: Sotogrande Region: Andalucía
Discover this luxury 3-bedroom townhouse in Los Carmenes de Almenara, Sotogrande Alto, offering a rare opportunity to enjoy golf-frontline living in one of Sotogrande's most prestigious gated (...)
€649,900
TSEA5002249
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 240 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 240 Area: Estepona Region: Andalucía
In the exclusive Señorío de Cortes urbanization, you will find this magnificent townhouse, which offers spacious living and breathtaking panoramic views.
The property features five bedrooms and (...)
€700,000
TSEA5002129
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 287 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 287 Area: Mijas and Mijas Costa Region: Andalucía
Charming Three-Bedroom Townhouse in Riviera del Sol
Discover this delightful three-bedroom townhouse in a sought-after gated community in Riviera del Sol, Mijas Costa. Perfectly positioned within (...)
€820,000
TSEA5002081
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 200 Lot Size: 76 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Lot Size: 76 Area: Benahavis Region: Andalucía
Recently refurbished townhouse in an established residential area. It is located very close to the borders of Estepona and Marbella, within the municipality of Benahavís. The house consists of two (...)
€165,000
TSEA5001709
- Palmones, Costa de la Luz
Beds: 3 Baths: 2 M2: 58 Region: Andalucía
Beds: 3 Baths: 2 M2: 58 Region: Andalucía
3 bedroom townhouse for sale near Los Barrios, Algeciras. Located in a charming gated community in Los Cortijillos, this inviting townhouse offers the perfect balance of comfort and convenience. Set (...)
€799,000
TSEA4995241
- Aloha, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 156 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 156 Area: Marbella West Region: Andalucía
Large and bright 3 bedroom 2 bathroom townhouse in Aloha with open views, Mountain, Golf, Sea. Recently renovated kitchen and bathrooms, a very large master bedroom with ensuite bathroom and extra (...)
€370,000
TSEA4995100
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 154 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 154 Area: Mijas and Mijas Costa Region: Andalucía
✨ Unique Opportunity in Las Lagunas!
This magnificent property is located in one of the most peaceful and sought-after areas of Las Lagunas, Care area.
This spacious house, ready to move in, (...)
€630,000
TSEA4994476
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 180 Lot Size: 60 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Lot Size: 60 Area: Estepona Region: Andalucía
WONDERFUL SEMI DETACHED HOUSE WITH SEA VIEWS, LARGE GARDEN, SOLARIUM and PRIVATE LIFT, Estepona.
Beautiful townhouse completely refurbished. Located in a quiet residential area of Estepona, next to (...)
Current Featured Properties
€580,000
TSEA4941487
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 183 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 183 Area: Mijas and Mijas Costa Region: Andalucía
Discover 19 stunning homes that combine nature and sea. With elegant details, spacious terraces and fitted kitchens, you will enjoy exceptional living in the heart of Mijas. Immerse yourself in a (...)
€720,000
TSEA4713529
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 116 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Branded Residence comprising of 58 incredible 2 and 3 bedroom frontline golf homes to be built to the highest specification overlooking the renowned La Cala Resort Golf course. Reaching the (...)
€495,000
TSEA5155090
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Located in the sought-after frontline beach development of Bahía Azul in Estepona West, this 2-bedroom townhouse offers an excellent opportunity to renovate and personalise a home in a prime coastal (...)
