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 (47,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 (47,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 (47,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 281 - 300 of 895 €2,590,000
TSEA5066890
- Centro Histórico, Costa Del Sol
Beds: 16 Baths: 5 M2: 600 Region: Andalucía
Beds: 16 Baths: 5 M2: 600 Region: Andalucía
Exclusive Commercial Premises in the Heart of Málaga's Historic Center
Located on one of the main streets of the historic center and just a few meters from the majestic Cathedral, this impressive (...)
€169,000
TSEA5066803
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 50 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Area: Manilva Region: Andalucía
Discover this beautifully maintained Andalusian-style townhouse nestled in the heart of San Luis de Sabinillas. Spread over three levels and offering sea views from every floor, this property is the (...)
€550,000
TSEA5066731
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 247 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 247 Area: Estepona Region: Andalucía
Stylish 4-Bedroom Townhouse for Sale in Montevideo Hills, El Paraíso - Estepona East.
Nestled in the prestigious Montevideo Hills community, this elegant 4-bedroom townhouse offers the perfect (...)
€584,250
TSEA5065531
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 151 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 151 Area: Estepona Region: Andalucía
Welcome to the residential complex in Estepona, your new home on the Costa del Sol.
The residential development is an exclusive promotion of 87 single-family homes ready to move into, located in the (...)
€125,000
TSEA5065522
- Jimena de la Frontera, Costa de la Luz
Beds: 2 Baths: 1 M2: 70 Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Region: Andalucía
Cozy village house OF 2 FLOORS very close to the castle. Terrace with spectacular views of the Natural Park of the Alcornocales. Kitchen equipped. Chimney. Furnished. Electrical installation and new (...)
€1,250,000
TSEA5065156
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 180 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 180 Area: Mijas and Mijas Costa Region: Andalucía
Modern Elegance with Panoramic Sea Views – El Chaparral
Discover the perfect blend of style, comfort, and location in this stunning 3-bedroom townhouse, part of the exclusive development in Mijas (...)
€470,250
TSEA5065117
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Welcome to the residential complex in Estepona, your new home on the Costa del Sol.
The residential development is an exclusive promotion of 87 single-family homes ready to move into, located in the (...)
€675,000
TSEA5065051
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 231 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 231 Area: Mijas and Mijas Costa Region: Andalucía
An Exceptional Property in Calahonda with Breathtaking Views and Impeccable Design
This beautifully renovated property in Calahonda is truly one-of-a-kind, offering panoramic views of the sea, golf (...)
€450,000
TSEA5064871
- Churriana, Costa Del Sol, Malaga
Beds: 4 Baths: 2 M2: 216 Area: Malaga Region: Andalucía
Beds: 4 Baths: 2 M2: 216 Area: Malaga Region: Andalucía
House for Sale in Central Churriana with Plenty of Natural Light, Garden, and Pool Potential
Looking for a house for sale in Churriana, right in the centre, spacious and full of light? This is your (...)
€780,000
TSEA5064592
- Aloha, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 165 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 165 Area: Marbella West Region: Andalucía
Charming 3-Bedroom Townhouse for Sale in Aloha Pueblo - Sea, Golf and Mountain Views!
Located in the heart of sought-after Aloha Pueblo, Nueva Andalucía, this beautifully presented 3-bedroom (...)
€530,000
TSEA5064532
- Bel Air, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 201 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 201 Area: Estepona Region: Andalucía
Fantastic 5 bedroom townhouse in a well maintained, family friendly community, in one of the most sought after areas in the New Golden Mile.
This beautiful, large and bright property is walking (...)
€750,000
TSEA5064310
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 242 Lot Size: 139 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 242 Lot Size: 139 Area: Estepona Region: Andalucía
4-story residential building in the heart of Estepona, just 600 meters from the beach.
The building has 4 floors, including a top terrace. On the ground floor, there is a large 4-meter-tall garage (...)
€119,000
TSEA5063953
- Benamargosa, Costa Del Sol East
Beds: 3 Baths: 2 M2: 112 Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Region: Andalucía
EXCLUSIVA LISTING
Benamargosa is a charming little pueblo with services, cafes and restaurants and it is only 13 kilometers from Velez-Malaga. Malaga centro only 47 km and Torre del Mar beach 17 (...)
€298,000
TSEA5063878
- Tolox, Costa Del Sol, Yunquera
Beds: 3 Baths: 2 M2: 221 Area: Yunquera Region: Andalucía
Beds: 3 Baths: 2 M2: 221 Area: Yunquera Region: Andalucía
Charming Multi-Level Property with Panoramic Mountain Views in Tolox
Nestled in the hills of Tolox, within the stunning Sierra de las Nieves Natural Park, this unique property offers a blend of (...)
€595,000
TSEA5063821
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 148 Lot Size: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Lot Size: 110 Area: Estepona Region: Andalucía
Delightful three bedroom, two bathroom (plus cloakroom) townhouse in much sought after area.
This townhouse has been well maintained by the current owners who have redecorated and replaced the (...)
€495,000
TSEA5063383
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 165 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 165 Area: Estepona Region: Andalucía
EL PARAISO-Residencial Agra: a beautifully furnished, newly built three-bedroom, three-bathroom townhouse. Located in a secure gated complex with access to a well-maintained community pool, this (...)
€448,000
TSEA5063266
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 171 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 171 Area: Benalmadena Region: Andalucía
Just 600 metres from the beach and steps away from Bonanza Square!
This spacious semi-detached house with private garage is ideally located in the heart of Benalmádena. The property is in excellent (...)
€533,000
TSEA5063110
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 182 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 182 Area: Benalmadena Region: Andalucía
Spacious 182 m² townhouse located in the peaceful Torremar urbanization, in the Capellanía area of Benalmádena, just a 5-minute walk from the Altos del Higuerón shopping center and with (...)
€430,000
TSEA5062999
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 105 Lot Size: 105 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Lot Size: 105 Area: Mijas and Mijas Costa Region: Andalucía
This beautifully maintained townhouse is a dream come true for golf enthusiasts, located right on the prestigious Mijas Golf course, you simply can't get any closer. With uninterrupted panoramic (...)
€565,000
TSEA5062453
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 2 M2: 318 Area: Manilva Region: Andalucía
Beds: 4 Baths: 2 M2: 318 Area: Manilva Region: Andalucía
Located in a peaceful setting on the Costa del Sol, just a short walk from La Duquesa golf course and only ten minutes' walk from the golden sands of El Castillo beach, this beautifully refurbished (...)
Current Featured Properties
€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, (...)
€673,000
TSEA4107058
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
€483,000
TSEA3980794
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
NESTLED BETWEEN STUNNING LANDSCAPE GARDENS!!
An exclusive development of 46 townhouses of 2, 3 and 4 bedrooms, some of them semi-detached, built in a contemporary style, in a privileged location two (...)
