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
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
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
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1601 - 1620 of 7575
€480,000
TSEA5112640
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 130 Lot Size: 99 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 99 Area: Algeciras Region: Andalucía
Ground Floor Apartment, La Alcaidesa, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 15 m², Garden/Plot 99 m².
Setting : Beachside, Close To Golf, Close To Shops, Close To Sea, (...)
€538,000
TSEA5112604
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 155 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 155 Area: Mijas and Mijas Costa Region: Andalucía
Spacious Duplex Penthouse in Benalmádena Costa – Excellent Location and Investment Potential
This four-bedroom duplex penthouse is located in one of the most desirable areas of Benalmádena (...)
€575,000
TSEA5112466
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Layout: 2 bedrooms | 2 bathrooms
Size: 90 m² interior + 50 m² terrace
This elevated ground-floor apartment is located in a brand-new development in the desirable area of Las Mesas, Estepona. (...)
€350,000
TSEA5112463
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 55 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: Marbella Region: Andalucía
Middle Floor Apartment, Marbella, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 55 m², Terrace 8 m².
Setting : Town, Commercial Area, Beachside, Port, Close To Golf, Close To Port, Close To Shops, (...)
€1,100,000
TSEA5112457
- El Candado, Costa Del Sol
Beds: 5 Baths: 3 M2: 316 Region: Andalucía
Beds: 5 Baths: 3 M2: 316 Region: Andalucía
Independent Villa in El Candado – Stunning Sea Views and Private Pool
Welcome to this magnificent villa located in El Candado, one of Málaga's most sought-after residential areas. Nestled in a (...)
€529,000
TSEA5112445
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
Welcome to the beautiful two-bedroom apartment at Magna Marbella.
It has a bright lounge-dining area that leads to an east-facing terrace with open views of the mountains and partial sea views, (...)
€1,680,000
TSEA5112403
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 223 Lot Size: 1,000 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 223 Lot Size: 1,000 Area: Estepona Region: Andalucía
"INVESTMENT OPPORTUNITY IN EL SALADILLO"
Finca - Cortijo, Estepona, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 223 m², Terrace 20 m², Garden/Plot 10000 m².
Setting : Town, (...)
€875,000
TSEA5112391
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 258 Lot Size: 71 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 258 Lot Size: 71 Area: Malaga Region: Andalucía
This beautifully maintained 2009 terraced home in the tranquil Terrazas de Miraflores community is perfect for investors, commuters, and families alike. Located just ten minutes from Málaga's (...)
€190,000
TSEA5112382
- La Trinidad, Costa Del Sol
Beds: 1 Baths: 1 M2: 42 Region: Andalucía
Beds: 1 Baths: 1 M2: 42 Region: Andalucía
Discover your new home at Trinidad Street! This charming one-bedroom apartment is the perfect option for those looking for a first home or an investment with great potential. With 42 m² of built (...)
€330,000
TSEA5112367
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 65 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Marbella West Region: Andalucía
Located just 1 kilometre from the iconic Puerto Banús, this three-level, Southwest orientated, corner, 1 bedroom townhouse is perfect as a Marbella base. This is a fantastic opportunity at a (...)
€403,000
TSEA5112346
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
Penthouse with Sea Views – Atalaya, Estepona
This exclusive 2-bedroom, 2-bathroom penthouse apartment, with 110 m² of built area and a 25 m² terrace, is located in a private development in (...)
€249,950
TSEA5112319
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
A lovely 2 bedroom apartment just metres from the beaches of El Faro in Mijas Costa. The sea views from the lounge, master bedroom and terrace are simply stunning. This is a first floor apartment but (...)
€299,000
TSEA5112307
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 95 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Benahavis Region: Andalucía
*** Frontline Golf ***
Modern ground floor 2 bed 2 bath apartment
A practical hassle-free investment and holiday home!
This property offers the perfect blend of resort hotel services and amenities (...)
€649,000
TSEA5112292
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
Incredible Frontline Apartment in Cabopino Port – A Rare Gem on the Costa del Sol
This is your chance to own something truly special – a frontline apartment in the iconic Puerto Cabopino, one of (...)
€349,990
TSEA5112283
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 60 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Marbella Region: Andalucía
This is a very attractively situated apartment in Marbella located second line beach and from its elevated position it enjoys great views to the sea and lots of natural light. The apartment has been (...)
€240,000
TSEA5112277
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 1 M2: 93 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 1 M2: 93 Area: Benahavis Region: Andalucía
Apartment for sale. Benahavis
Property located in one of the most popular areas of the Costa del Sol, just minutes from all kinds of services: supermarkets, schools, restaurants and green areas. An (...)
€380,000
TSEA5112271
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 127 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Alhaurin el Grande Region: Andalucía
Set in one of the most sought-after areas of Alhaurín Golf, this beautifully presented and much-loved townhouse offers the perfect blend of comfort, style, and convenience. Ideal for permanent (...)
€198,000
TSEA5112223
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 1 Baths: 1 M2: 81 Area: La Duquesa Region: Andalucía
Beds: 1 Baths: 1 M2: 81 Area: La Duquesa Region: Andalucía
Your seaside oasis awaits you in Manilva, Málaga!
This charming tourist apartment, with an area of 81 m², offers a carefully planned layout. With 1 bedroom, a bright living-dining room integrated (...)
€590,000
TSEA5112061
- Tarifa, Costa de la Luz
Beds: 2 Baths: 1 M2: 110 Region: Andalucía
Beds: 2 Baths: 1 M2: 110 Region: Andalucía
2-bedroom apartment in Tarifa facing the sought-after Los Lances beach, just 200 meters from it, with sea views from its terrace. It has 110 m2 distributed over 2 spacious bedrooms, 1 bathroom, and a (...)
€1,550,000
TSEA5112058
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 6 M2: 456 Lot Size: 1,467 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 6 M2: 456 Lot Size: 1,467 Area: Sotogrande Region: Andalucía
Luxury Villa on the Sotogrande Coast
Detached two-story villa in the coastal area of Sotogrande. On the first floor, we find a spacious entrance hall leading to 3 large bedrooms, a kitchen, (...)
Current Featured Properties
€1,250,000
TSEA5020213
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 225 Lot Size: 354 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 225 Lot Size: 354 Area: Estepona Region: Andalucía
DESIGN AND FUNCTIONALITY, This new construction offers a two-story home and office with spacious rooms, access to a sun terrace and private garden on the ground floor, It is fully equipped with a (...)
€2,200,000
Detached Villa in Benahavis
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 288 Lot Size: 1,058 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 288 Lot Size: 1,058 Area: Benahavis Region: Andalucía
IN THE HILLS ABOVE THE COAST.!!
This new build, luxury villa is located in Puerto del Capitan close to the valley of Benahavis. Ideally oriented towards the west with afternoon and evening sun, this (...)
€3,890,000
Detached Villa in Nueva Andalucia
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 229 Lot Size: 1,008 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 229 Lot Size: 1,008 Area: Marbella West Region: Andalucía
THE ULTIMATE LUXURY LIVING!!!
Combining luxury and nature in an exceptional environment. Two unique villas built on one floor and designed to enjoy the Mediterranean lifestyle in a relaxed way, (...)
