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 (42,39,40,41,162,163)
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 (42,39,40,41,162,163)
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 (42,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 2161 - 2180 of 5891 €360,000
TSEA5057485
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 147 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 147 Area: Estepona Region: Andalucía
Stylish and bright apartment on the first floor with lift, just 200 metres from the beach.
This move-in-ready property is located in a quiet, well-maintained urbanisation with lush communal gardens (...)
€425,000
TSEA5057473
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 101 Lot Size: 62 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Lot Size: 62 Area: Estepona Region: Andalucía
LOCATED IN BEAUTIFUL ESTEPONA!!!
One of the most attractive corners of the Costa del Sol. The town has become one of the most sought-after spots on the Costa del Sol, thanks to its quality of life (...)
€585,000
TSEA5057452
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Magnificent 3 bedroom ground floor flat in the beautiful urbanisation of Marina Castillo, on the beachfront. A very nice flat, good qualities, with air conditioning hot/cold and home automation. The (...)
€995,000
TSEA5056699
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 154 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 154 Area: Benahavis Region: Andalucía
This stylish 3-bedroom apartment is located in the prestigious Marbella Club Hills development, nestled in the peaceful hills above Marbella. Surrounded by nature and offering absolute tranquility, (...)
€1,400,000
TSEA5056666
- Marbella, Costa Del Sol, Marbella
Beds: 8 Baths: 6 M2: 450 Lot Size: 500 Area: Marbella Region: Andalucía
Beds: 8 Baths: 6 M2: 450 Lot Size: 500 Area: Marbella Region: Andalucía
Charming villa located in the heart of Marbella, just a 15-minute walk from the beach and the promenade. This well-maintained property is close to supermarkets, schools, and only 1.5 km from the La (...)
€375,000
TSEA5056615
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 90 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: Marbella Region: Andalucía
LOVELY 3 BEDROOM 3 BATHROOM POSITIONED ON THE 1ST FLOOR OF THE APARTMENT BLOCK AND ALSO HAS LIFT ACCESS STRAIGHT TO YOUR FRONT DOOR.
❗️THE PROPERTY IS LOCATED ON THE BEACH SIDE OF THE A7 (...)
€399,000
TSEA5056552
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Charming First Floor Apartment in the Prestigious Gated Community in El Paraiso, Estepona
We present a unique opportunity to acquire a home in one of the most peaceful and beautiful areas of (...)
€1,795,000
TSEA5056534
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 3 M2: 207 Area: Marbella Region: Andalucía
Beds: 2 Baths: 3 M2: 207 Area: Marbella Region: Andalucía
Luxury Living Near Sierra Blanca | Gated Community | Turnkey Property
This exceptional 2-bedroom, 2-bathroom + guest toilet ground-floor apartment presents a rare opportunity to own a refined (...)
€350,000
TSEA5056525
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Investment opportunity in Aloha. This apartment has two NOTA SIMPLE and can be converted into two properties: a studio and a one-bedroom apartment. The apartment has two kitchens, two bedrooms, a (...)
€899,000
TSEA5056471
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 135 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 135 Area: Marbella East Region: Andalucía
Discover this magnificent property totally exterior, located in one of the most coveted areas of Marbella: the prestigious Golden Mile. Just 100 meters from the beach, this fabulous duplex penthouse (...)
€320,000
TSEA5056441
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
New Development: Prices from 320,000 € to 616,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 75.00 m2 - 109.00 m2]
Our company is a real estate investment and development group with 80 years (...)
€420,000
TSEA5056393
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 42 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 42 Area: Marbella Region: Andalucía
Ground Floor Apartment, Marbella, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 42 m², Terrace 12 m².
Setting : Beachfront, Close To Sea.
Orientation : East, South East, South.
Condition : Fair.
€1,200,000
TSEA5056330
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 6 Baths: 3 M2: 391 Lot Size: 751 Area: Alhaurin el Grande Region: Andalucía
Beds: 6 Baths: 3 M2: 391 Lot Size: 751 Area: Alhaurin el Grande Region: Andalucía
A spacious and very elegant classic-style villa in impeccable condition and built with high-quality materials, located in the well-known "La Paca" residential area.
It is distributed as (...)
€625,000
TSEA5056312
- 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
Middle Floor Apartment, Estepona, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 90 m², Terrace 20 m².
Setting : Beachfront, Town, Commercial Area, Beachside, Close To Shops, Close To Sea, Close To (...)
€1,720,000
TSEA5056297
- Pinares de San Antón, Costa Del Sol
Beds: 5 Baths: 5 M2: 759 Lot Size: 1,252 Region: Andalucía
Beds: 5 Baths: 5 M2: 759 Lot Size: 1,252 Region: Andalucía
Exclusive property with spectacular panoramic sea views 488 m² built on a 1118 m² plot designed to offer maximum comfort privacy and connection with the natural surroundings
Independent access with (...)
€790,000
TSEA5056135
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 195 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 195 Area: Estepona Region: Andalucía
Incredible 3 bedroom apartment with sea views in the prestigious beachfront urbanization Riviera Andaluza in Estepona, within walking distance to the port and the town center of Estepona. The (...)
€225,000
TSEA5055958
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 59 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 59 Area: Mijas and Mijas Costa Region: Andalucía
Discover this excellent one-bedroom apartment nestled in the serene residential area of Mijas Golf. Spanning 59 m², this inviting space features a brand new bathroom and a fully equipped kitchen, (...)
€375,000
TSEA5055940
- 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
Ground floor apartment with private garden in urbanization facing the sea
A ground floor apartment of 90 m² built is offered for sale, located in a consolidated and quiet urbanization on the (...)
€185,000
TSEA5055928
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 32 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 32 Area: Benalmadena Region: Andalucía
Studio apartment with small Bedroom
32m² interior + 5m² covered west-facing terrace.
Community with swimming pool and garden.
Parking not included, but resales of interior parking frequently comes (...)
€530,000
TSEA5055919
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 146 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 146 Area: Marbella Region: Andalucía
We offers OPPORTUNITY FLAT + OFFICE / APARTMENT 3 KM FROM THE BEACH, IN RICARDO SORIANO, MARBELLA.
The property is to be completely refurbished. The images are digital renders for illustrative (...)
Current Featured Properties
€447,000
TSEA5032276
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 107 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 107 Area: Estepona Region: Andalucía
This development is placed in an excellent location.
Situated on an elevated plot that also benefits from being in front of a park and a sports area, guaranteeing sea views.
The development offers 2, (...)
€2,295,000
EMPTY
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
The development is located in a prime enclave, surrounded by parks and landscaped areas, close to a wide variety of sports, healthcare, commercial spaces, and universities. Just 10 minutes from the (...)
€599,000
TSEA4851742
- 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
This development offers 36 beautiful single-storey homes with large rooms, the option of 2 or 3 bedrooms, 2 bathrooms and large terraces with beautiful panoramic views. They have a fully equipped (...)
