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 (43,36,37,38)
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 (43,36,37,38)
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 (43,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 101 - 120 of 306 €684,000
TSEA5056561
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 134 Lot Size: 194 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Lot Size: 194 Area: Mijas and Mijas Costa Region: Andalucía
SEMI-DETACHED HOUSE WITH A FANTASTIC VIEW OF THE SEA
Newly built semi-detached house in Reviera Del Sol with a fantastic panoramic view and a really good location. The house was completed in (...)
€799,000
TSEA5056513
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 6 Baths: 4 M2: 242 Area: Benalmadena Region: Andalucía
Beds: 6 Baths: 4 M2: 242 Area: Benalmadena Region: Andalucía
Prime Benalmádena Costa Residence with Guest Apartment, Pool, and Sea Views
Nestled in a prestigious, palm-lined urbanisation in the heart of Benalmádena Costa, this expansive and exceptionally (...)
€700,000
TSEA5052358
- Playamar, Costa Del Sol, Torremolinos
Beds: 4 Baths: 3 M2: 242 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 3 M2: 242 Area: Torremolinos Region: Andalucía
This spacious 240 m² property, with 80 m² per floor, is distributed as follows:
Basement: Open-plan space ideal for multiple uses, such as a double garage, gym, games room, etc. It also has a (...)
€739,000
TSEA5052313
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 183 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 183 Area: Mijas and Mijas Costa Region: Andalucía
Elegant 3-Bedroom Semi-Detached House with Private Pool, Golf Views & Dream Location – Marbella
Discover a place where quality of life meets unbeatable location. This brand new, fully (...)
€922,500
TSEA5051599
- Estepona, Costa Del Sol, Estepona
Beds: 7 Baths: 5 M2: 236 Lot Size: 100 Area: Estepona Region: Andalucía
Beds: 7 Baths: 5 M2: 236 Lot Size: 100 Area: Estepona Region: Andalucía
Beautiful semi-detached house in Estepona town close to all services, shops, restaurants, schools, sports
area, etc. and a short walk from the beach. The property is built on 3 levels divided into (...)
€524,000
TSEA5051467
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 196 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 196 Area: Mijas and Mijas Costa Region: Andalucía
Magnificent semi-detached villa in Alhaurin de la Torre
5 bedrooms and 4 bathrooms
Garden and space for a private pool
Ground floor (INDEPENDENT ENTRANCE):
The interior is accessed through six glass (...)
€2,150,000
TSEA5050399
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 4 M2: 326 Lot Size: 29 Area: Marbella Region: Andalucía
Beds: 3 Baths: 4 M2: 326 Lot Size: 29 Area: Marbella Region: Andalucía
A Unique Gem in the Heart of Marbella
Discover an exclusive urban oasis with Residencial Paraíba, an ambitious luxury project consisting of five unique homes: four semi-detached houses and one (...)
€199,000
TSEA5049922
- Periana, Costa Del Sol East
Beds: 5 Baths: 2 M2: 231 Lot Size: 181 Region: Andalucía
Beds: 5 Baths: 2 M2: 231 Lot Size: 181 Region: Andalucía
Nestled in the charming mountain village of Periana, this spacious semi-detached house is a true gem with Andalusian flair. Spread over two floors, the home offers five bedrooms, a bathroom with a (...)
€199,999
TSEA5049916
- Torrox, Costa Del Sol East
Beds: 2 Baths: 1 M2: 69 Lot Size: 7,103 Region: Andalucía
Beds: 2 Baths: 1 M2: 69 Lot Size: 7,103 Region: Andalucía
This charming country house in Torrox is situated on a plot of over 7,000 m2 and offers ideal conditions for horse lovers and those who want to enjoy life in the countryside. The house features an (...)
€730,000
TSEA5049256
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 123 Lot Size: 416 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Lot Size: 416 Area: Estepona Region: Andalucía
Located right on the seafront, this villa offers unmatched panoramic views, where you can admire the African coast from one of the most privileged spots in Andalusia. The gated community has private (...)
€1,750,000
TSEA5044372
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 409 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 409 Area: Malaga Region: Andalucía
Brand-New Villa for Sale – Pinares de San Antón, Málaga
Price: €1,750,000
An exclusive, newly built detached villa with modern design, located in one of Málaga's most prestigious and elevated (...)
€472,500
TSEA5044114
- Rincón de la Victoria, Costa Del Sol East
Beds: 3 Baths: 2 M2: 123 Lot Size: 139 Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Lot Size: 139 Region: Andalucía
This inviting semi detached house is situated in the sought-after area of Rincon de la Victoria, Malaga, offering a harmonious blend of comfort and convenience. With a built area of 123m² and a plot (...)
€790,000
TSEA5040226
- Nagüeles, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 181 Lot Size: 84 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 181 Lot Size: 84 Area: Marbella Region: Andalucía
ELEGANT CORNER SEMI-DETACHED HOME IN LAS CUMBRES DE NAGÜELES – 3 BEDROOMS WITH PRIVATE GARDEN
Experience the perfect blend of comfort, privacy, and style in this beautiful corner semi-detached (...)
€269,000
TSEA5040172
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 1 M2: 79 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 1 M2: 79 Area: Alhaurin el Grande Region: Andalucía
Semi-detached country house located on a 2,250 m² rustic plot just a few minutes from the village of Alhaurin. The land is completely fenced, fairly flat, planted with various fruit trees and (...)
€1,468,000
TSEA4980559
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 167 Lot Size: 329 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 167 Lot Size: 329 Area: Estepona Region: Andalucía
New Development: Prices from 1,468,000 € to 1,638,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 167.00 m2 - 174.00 m2]
Luxury 2, 3 and 4 bedroom apartments, and 3 bedroom semi-detached (...)
€499,000
TSEA5037478
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 130 Lot Size: 196 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Lot Size: 196 Area: Mijas and Mijas Costa Region: Andalucía
Semi-Detached Riviera del Sol Home with Garden and Jacuzzi
This beautifully presented semi-detached house is located in an exclusive urbanisation in Riviera del Sol, just a few minutes drive from (...)
€595,000
TSEA5037202
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 217 Lot Size: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 217 Lot Size: 149 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 595,000 € to 700,000 €. [Beds: 3 - 3] [Baths: 4 - 4] [Built size: 217.00 m2 - 250.00 m2]
Exclusive new build semi-detached villas in La Cala Golf, Mijas.
Experience (...)
€695,000
TSEA5037103
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 205 Lot Size: 270 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 205 Lot Size: 270 Area: Sotogrande Region: Andalucía
This large 3 bedroom, 3 1/2 bathroom semi-detached sea view house in the exclusive Los Cortijos de la Reserva offers something truly unique - almost 205m2 of space with a large rectangular garden of (...)
€1,490,000
TSEA3424711
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 369 Lot Size: 263 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 369 Lot Size: 263 Area: Benahavis Region: Andalucía
New Development: Prices from 1,490,000 € to 1,690,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 369.00 m2 - 371.00 m2]
This development is an entirely unique concept with emphasis on cutting (...)
€645,000
TSEA5034751
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 2 Baths: 2 M2: 193 Lot Size: 334 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 2 M2: 193 Lot Size: 334 Area: Sotogrande Region: Andalucía
This large 2 bedroom, 2 1/2 bathroom semi-detached house with sea views in the exclusive Los Cortijos de la Reserva offers something truly unique - almost 200m2 of space with a huge wrap around (...)
Current Featured Properties
€443,000
TSEA4027225
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
4 UNITS LEFT
DREAM AWAY LAZY EVENINGS BY LOOKING AT A STUNNING VIEW!!!
Off-plan development of contemporary semi-detached houses in Riviera del Sol, Mijas, with views over the Mediterranean. The 3 (...)
€1,300,000
TSEA4639768
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
€1,100,000
TSEA4638103
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 138 Lot Size: 34 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Lot Size: 34 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
