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 (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
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.approved = 1 AND pm.cat_id IN (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
GROUP BY p.id
ORDER BY p.created DESC
Results 7281 - 7300 of 7581
TSEA3939268
- Tolox, Costa Del Sol, Yunquera
Beds: 6 Baths: 3 M2: 270 Lot Size: 488 Area: Yunquera Region: Andalucía
Beds: 6 Baths: 3 M2: 270 Lot Size: 488 Area: Yunquera Region: Andalucía
This property consists of a plot of almost 500m in the center of Tolox.
It has a parking area for several vehicles, a BBQ area and an area to build a swimming pool.
It consists of a complete ground (...)
TSEA3936313
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 106 Lot Size: 218 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Lot Size: 218 Area: Estepona Region: Andalucía
LAST THREE BED AVAILABLE, GET IN TOUCH TODAY BEFORE IT IS GONE!!!
Brand new project, 90 dwellings of 1, 2 and 3 bedrooms, all of them with garage space and storage room. It is an exclusive (...)
TSEA3936250
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Lot Size: 53 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Lot Size: 53 Area: Estepona Region: Andalucía
BRAND NEW DEVELOPMENT IN ESTEPONA.
Don't miss out on an opportunity to buy in this development of 90 dwellings of 1, 2 and 3 bedrooms, all of them with garage space and storage room. It is an (...)
TSEA3923743
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
GREAT LOCATION CLOSE TO CHARMING ESTEPONA.
The apartments are specially designed to fully enjoy the charm of the Mediterranean lifestyle. A well thought out floor plan, bathrooms with lovely (...)
TSEA3923275
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 93 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Estepona Region: Andalucía
CHARMING SPACIOUS APARTMENTS!!!
The apartments are specially designed to fully enjoy the charm of the Mediterranean lifestyle, but they are also designed with a Northern European vision. A well (...)
TSEA3922510
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
LAST OPPORUNITY TO ACQUIRE!!!!
One of the last opportunities to acquire a newly built property in the centre of Estepona, seaside and just 1 minute from the beach. A dream lifestyle which can be (...)
TSEA3922444
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 188 Lot Size: 3,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 188 Lot Size: 3,000 Area: Mijas and Mijas Costa Region: Andalucía
Detached Villa, Mijas, Costa del Sol.
5 Bedrooms, 3 Bathrooms, Built 188 m², Garden/Plot 3000 m².
Setting : Close To Shops, Close To Sea, Close To Town.
Orientation : South.
Condition : Good.
Pool (...)
TSEA3920965
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 368 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 368 Area: Fuengirola Region: Andalucía
Prime location!
Duplex penthouse located in Fuengirola
Within walking distance to all amenities, beachside, great access to the highway
Amazing views overlooking the sohail castle, the river and (...)
TSEA3916660
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
ELEGANT AND MODERN DEVELOPMENT IN THE HEART OF THE COSTA DEL SOL!!!!
This development is nestled in an incomparable natural environment where the sea, the mountain, the golf and all the services of (...)
TSEA3910831
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 500 Lot Size: 570 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 500 Lot Size: 570 Area: Mijas and Mijas Costa Region: Andalucía
**Two Exceptional Detached Villas Under Construction in Cerros del Águila**
**Three-Bedroom Contemporary Smart Villas**
Nestled in the hills between Fuengirola and La Cala de Mijas, Cerros del (...)
TSEA3908188
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 10 Baths: 8 M2: 489 Lot Size: 128 Area: Fuengirola Region: Andalucía
Beds: 10 Baths: 8 M2: 489 Lot Size: 128 Area: Fuengirola Region: Andalucía
Turnkey building for sale, building licence already obtained, work ends in septiembre 2025. Located in an absolutely privileged area, second line beach in the well known Plaza Picasso. In the centre (...)
TSEA3903181
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 7 Baths: 7 M2: 260 Lot Size: 7,300 Area: Nerja and Malaga East Region: Andalucía
Beds: 7 Baths: 7 M2: 260 Lot Size: 7,300 Area: Nerja and Malaga East Region: Andalucía
Investors, take a look at this! If you are looking to start a holiday rental business, this property is ideal. The project is calculated to earn more than € 60,000 per year in benefits. It consists (...)
TSEA3901831
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 6 Baths: 6 M2: 1,389 Lot Size: 3,099 Area: Sotogrande Region: Andalucía
Beds: 6 Baths: 6 M2: 1,389 Lot Size: 3,099 Area: Sotogrande Region: Andalucía
Bespoke Villa Created with Passion and without Compromise on Quality and Engineering.
A luxurious home situated in the tranquillity and privacy of Sotogrande Alto. Ten years in the making and built (...)
TSEA3896224
- Jimena de la Frontera, Costa de la Luz
Beds: 4 Baths: 2 M2: 200 Lot Size: 550 Region: Andalucía
Beds: 4 Baths: 2 M2: 200 Lot Size: 550 Region: Andalucía
WITH POOL, GARDEN, TERRACE AND FABULOUS VIEWS FOR SALE IN SAN PABLO DE BUCEITE FANTASTIC VILLAGE HOUSE.
San Pablo de Buceite is a beautiful town in the province of Cádiz on the border with the (...)
TSEA3895192
- La Mairena, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 553 Lot Size: 3,719 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 553 Lot Size: 3,719 Area: Marbella East Region: Andalucía
Elegant Modern Villa with Panoramic Sea Views in La Mairena, Marbella
Nestled in the hills of La Mairena on the Costa del Sol, this stunning contemporary villa offers a rare combination of (...)
TSEA3892798
- El Burgo, Costa Del Sol, Yunquera
Beds: 13 Baths: 13 M2: 536 Area: Yunquera Region: Andalucía
Beds: 13 Baths: 13 M2: 536 Area: Yunquera Region: Andalucía
Historic hotel in El Burgo between the famous tourist destination of Ronda and the famous hiking trail Camino del Rey
Top Floor Apartment in Nueava Andalucia
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
LAST PENTHOUSE REMAINING!!!!
Situated in a privileged position on a hill with the best panoramic views over the "Viejo del Angel" water reservoir, the Marbella coastline and the golf (...)
TSEA3888898
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 574 Lot Size: 4,188 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 574 Lot Size: 4,188 Area: Benahavis Region: Andalucía
Presenting a State of the Art Contemporary luxury villa nestled on a secluded and serene plot, offering breathtaking golf and partial sea views. This south-east facing property gracefully perches on (...)
TSEA3898675
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 141 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Area: Estepona Region: Andalucía
2 bedroom apartment located in the hotel complex called Paraiso Beach, located in the Paraiso Barronal Urbanization, Cancelada, between Marbella and Estepona, Malaga
The apartment has 2 bedrooms and (...)
TSEA3886300
- Periana, Costa Del Sol East
Beds: 14 Baths: 5 M2: 500 Lot Size: 509 Region: Andalucía
Beds: 14 Baths: 5 M2: 500 Lot Size: 509 Region: Andalucía
Are you looking for an ideal place to set up a hotel or a Bed & Breakfast? Look no further! This is perfect. Here you can start an exciting and thriving hotel business, being the only guest (...)
