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,68,69,70)
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,68,69,70)
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,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 681 - 700 of 751
€235,000
TSEA4422358
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 2 M2: 142 Area: Manilva Region: Andalucía
Beds: 4 Baths: 2 M2: 142 Area: Manilva Region: Andalucía
This spacious townhouse located in the charming village of Manilva offers an exceptional opportunity. Situated near the center and the picturesque Santa Ana church, this property consists of TWO (...)
€850,000
TSEA4422289
- Marbella, Costa Del Sol, Marbella
Beds: 12 Baths: 2 M2: 256 Lot Size: 88 Area: Marbella Region: Andalucía
Beds: 12 Baths: 2 M2: 256 Lot Size: 88 Area: Marbella Region: Andalucía
Building to reform for sale in the famous area of "El Barrio" a few meters from the beach and close to all services such as supermarkets, bars, pharmacies, etc.
It consists of 265 m² (...)
€529,000
TSEA4410175
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 182 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 182 Area: Mijas and Mijas Costa Region: Andalucía
Townhouse house in one of the most luxurious urbanizations in Riviera del Sol, with a gym, swimming pools, playgrounds, two private parking spaces."
Located in the higher part of Riviera del (...)
€534,000
TSEA4408633
- Tolox, Costa Del Sol, Yunquera
Beds: 5 Baths: 1 M2: 296 Area: Yunquera Region: Andalucía
Beds: 5 Baths: 1 M2: 296 Area: Yunquera Region: Andalucía
Character Townhouse in Tolox steeped in history
. Beautiful Property
. Lots of original features
. Possible Tourism Options
. Immerse yourself in the popular village
. 16 Century, reformed (...)
€3,000,000
TSEA4407997
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 5 Baths: 5 M2: 385 Area: Marbella Region: Andalucía
Beds: 5 Baths: 5 M2: 385 Area: Marbella Region: Andalucía
Prestigious five-bedroom villa nestled in the upscale neighborhood Meisho Hills of Sierra Blanca, Marbella. This luxurious property offers a spacious and exquisitely designed living space, perfect (...)
€531,000
TSEA4360471
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 112 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Estepona Region: Andalucía
Three bedroom, two bathroom townhouse with a large patio in the old town of Estepona. The property has two floors, but can be expanded with three additional floors. Close to all amenities. The (...)
€499,000
TSEA4355638
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 200 Lot Size: 80 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Lot Size: 80 Area: Estepona Region: Andalucía
Townhouse, Estepona, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 0 m².
Setting : Commercial Area, Beachside, Close To Shops, Close To Town, Close To Schools.
Orientation : South.
Condition : (...)
€825,000
TSEA4340413
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
EVERYONE IS TALKING ABOUT MOVING TO MIJAS!!!
Located in La Cala de Mijas, one of the urban centers belonging to the municipality of Mijas. Just a 5-minute drive from the residential area, you can (...)
€450,000
TSEA4340158
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 117 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 117 Area: Marbella Region: Andalucía
House for sale in the old town, currently this property is being rented in two individual houses, one on the first floor and the other on the second, each with two bedrooms and a bathroom. Excellent (...)
€198,000
TSEA4339840
- Jimena de la Frontera, Costa de la Luz
Beds: 3 Baths: 2 M2: 116 Lot Size: 420 Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Lot Size: 420 Region: Andalucía
Wonderful Andalusian Cortijo in Jimena de la Frontera, Cádiz, restored and converted into 3 semi-detached houses.
One of these semi-detached houses is for sale. It consists of an original 226 m2 (...)
€850,000
TSEA4335847
- Nagüeles, Costa Del Sol, Marbella
Beds: 2 Baths: 3 M2: 251 Lot Size: 20 Area: Marbella Region: Andalucía
Beds: 2 Baths: 3 M2: 251 Lot Size: 20 Area: Marbella Region: Andalucía
Great house for rent in Nagueles, Marbella.
The house with elevator has 3 floors:
In the basement there is a garage, bathroom, and a room that can be used as a storage room or games room.
On the (...)
€705,000
TSEA4334569
- Rincón de la Victoria, Costa Del Sol East
Beds: 4 Baths: 3 M2: 273 Lot Size: 232 Region: Andalucía
Beds: 4 Baths: 3 M2: 273 Lot Size: 232 Region: Andalucía
Modern family house at a unique location 5 minutes from the beach and all the necessary shops, restaurants, sports venues of the town of Rincon de la Victoria.
These newly built homes include a (...)
€167,900
TSEA4328008
- Jimena de la Frontera, Costa de la Luz
Beds: 8 Baths: 3 M2: 380 Region: Andalucía
Beds: 8 Baths: 3 M2: 380 Region: Andalucía
Charming 8-bedroom country house in Jimena, ideal for managing an Airbnb, with an excellent location near all services. The property is a perfect retreat for those seeking a lucrative investment (...)
€757,500
TSEA4327588
- Málaga Centro, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 172 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 172 Area: Malaga Region: Andalucía
townhouse/ casa mata, Málaga historic centre, Costa del Sol.
3 Bedrooms, 1.5 Bathroom, Built 172 m², Terrace 40 m².
Possibility one floor more Recently. Refurbished. More pics to come
Setting : (...)
€129,000
TSEA4326226
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 1 M2: 218 Area: Coin Region: Andalucía
Beds: 4 Baths: 1 M2: 218 Area: Coin Region: Andalucía
Semi-detached house of 218 m2.
The property consists of 218 m2 built, located in a very good area of the village.
It is distributed on two floors, on the second floor we find living room, kitchen, (...)
€820,000
TSEA4325527
- Torre del Mar, Costa Del Sol East
Beds: 4 Baths: 2 M2: 250 Lot Size: 250 Region: Andalucía
Beds: 4 Baths: 2 M2: 250 Lot Size: 250 Region: Andalucía
This is a magnificent front line beach townhouse with spectacular views to the beach and the promenade. The property has a living room, a kitchen, 4 bedrooms, 2 bathrooms, a toilet, 3 terraces, a (...)
€485,000
TSEA4319359
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 145 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Area: Estepona Region: Andalucía
Magnificent semi-detached house with jacuzzi and sea views. The house has a very wide entrance where you can park the vehicle indoors, and another area where you can comfortably receive your guests (...)
€350,000
TSEA4293226
- Caleta de Vélez, Costa Del Sol East
Beds: 2 Baths: 1 M2: 95 Lot Size: 95 Region: Andalucía
Beds: 2 Baths: 1 M2: 95 Lot Size: 95 Region: Andalucía
This beautiful townhouse in 2nd line of the beach is 20 metres from the sea and fantastic bars. It has 2 bedrooms, a bathroom, a guest bathroom, a living room, a kitchen with dining area and a large (...)
€465,000
TSEA4292032
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
LARGE GARDEN, AMAZING VIEWS AND GYM!!!
In an incomparable enclave with magnificent views, a project of 40 semi-detached and semi-detached houses with 3 and 4 bedrooms with large terraces to enjoy (...)
€275,000
TSEA4253578
- Guadiaro, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 73 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 73 Area: Sotogrande Region: Andalucía
PLEASE BE ADVISED, THE GARAGE IN THE PICTURE DOES NOT BELONG TO THE HOUSE, IT BELONGS TO THE NEIGHBOUR. Lovely 3-bedroom traditional town house in Guadiaro.
The house has 3-bedrooms and 1 full (...)
Current Featured Properties
€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 (...)
€445,000
TSEA4989478
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
SECOND LINE BEACH 2 BED/2 BATH TOWNHOUSE – ESTEPONA PROMENADE!
Immaculately maintained and upgraded family townhouse less than 2 minutes walking distance from the emblematic Mirador de Estepona, (...)
