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 (40,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 (40,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 (40,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 181 - 200 of 1780
€630,000
TSEA5143432
- Río Real, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 107 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Area: Marbella East Region: Andalucía
This beautifully renovated two-bedroom apartment is situated in the iconic Torre de Río Real, one of Marbella's most renowned buildings. Located in the exclusive Río Real residential area in (...)
€2,395,000
TSEA5143105
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
This southwest-facing, fully renovated 3-bedroom, 2-bathroom apartment offers an exceptional blend of style, comfort, and panoramic views over subtropical gardens and the Mediterranean Sea. The (...)
€249,500
TSEA5143003
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
Middle Floor Apartment, Benalmadena, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 49 m².
Possibility of turistic licence
Setting : Town, Urbanisation.
Condition : Excellent.
Features : Covered (...)
€325,000
TSEA5142982
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 85 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Benalmadena Region: Andalucía
Discover your new home in this spectacular, fully renovated apartment, just a 5-minute walk from the beach! With a charming terrace offering stunning sea views, this space is perfect for enjoying the (...)
€309,000
TSEA5142808
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Middle Floor, 2 Bed, 2 Bath Apartment in Mijas, Costa del Sol
Discover this charming middle-floor apartment located in the picturesque area of Mijas, Costa del Sol. This property offers an ideal (...)
€429,000
TSEA5142796
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 77 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Marbella East Region: Andalucía
This is a great apartment for sale tight in the famous port of Cabopino in East Marbella. Originally this was a very large 1 bedroom apartment, but the owner has cleverly converted it into a two (...)
€575,000
TSEA5142745
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
Andalusian Charm Meets Modern Comfort in the Heart of Nueva Andalucía
Welcome to La Maestranza, a unique residential complex built in the style of a traditional Spanish village, complete with (...)
€769,000
TSEA5142685
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 155 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 155 Area: Estepona Region: Andalucía
Elegant 2-Bedroom Apartment for Sale in Bahía de la Plata – Frontline Beach, Estepona
Bright Two Bedroom First-Floor Corner Apartment with Sunny Terrace, Sea Views & Privacy in Prime (...)
€490,000
TSEA5142649
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
EXCLUSIVE MODERN PROPERTY IN ONE OF ESTEPONA'S MOST SOUGHT-AFTER AREAS, WITH HIGH-QUALITY FINISHES, TWO PARKING SPACES AND A STORAGE ROOM.Prime location in one of Estepona's most desirable and (...)
€230,000
TSEA5142619
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Loveley one bedroom property , which could be good for a permenant living or a holiday home. apartment located between Mijas Pueblo ( pictures Andalusian village ) and Fuengirola (very busy sea side (...)
€359,000
TSEA5142613
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 64 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 64 Area: Benalmadena Region: Andalucía
Beautiful apartment for sale in Puerto Marina, Benalmadena
???? APARTMENT FOR SALE IN PUERTO MARINA, BENALMÁDENA! ???? Unbeatable location, next to the marina. ✨ With a holiday rental license – (...)
€320,000
TSEA5142562
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 73 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 73 Area: La Duquesa Region: Andalucía
Stylish south facing two bedroom, two bathroom apartment located within this much sought after urbanisation of Vistalmar, between Sotogrande and La Duquesa marina. Set within a secure gated and quiet (...)
€605,000
TSEA5142559
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Stunning Renovated Apartment in the Heart of Marbella!
Discover elegance and comfort in this magnificently renovated 78 m² apartment, perfectly situated in the vibrant center of Marbella. Nestled (...)
€424,000
TSEA5142502
- Centro Histórico, Costa Del Sol
Beds: 1 Baths: 1 M2: 45 Region: Andalucía
Beds: 1 Baths: 1 M2: 45 Region: Andalucía
Fantastic investment opportunity in the heart of Málaga's historic center. Just 35 meters from the charming Plazuela San Juan de Dios, this first-floor apartment (no elevator) is located in a (...)
€1,070,000
TSEA5142214
- Puerto Banús, 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
Discover this exclusive third-floor apartment in a prestigious frontline beach development, ideally situated in the heart of Puerto Banús, Marbella.
The apartment offers two bedrooms, two bathrooms, (...)
€449,900
TSEA5142202
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 160 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Marbella West Region: Andalucía
Spacious 3-Bedroom Apartment Just Minutes from Puerto Banús and the Beach
Only a couple of minutes from the glamour of Puerto Banús and Marbella's golden beaches, this spacious apartment (154 m² (...)
€574,000
TSEA5142196
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 137 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Mijas and Mijas Costa Region: Andalucía
Dreaming of life in idyllic Mijas Pueblo?
Welcome to your new home – an exclusive and modernly renovated 3-bedroom duplex apartment located in the heart of this charming whitewashed village.
This (...)
€430,000
TSEA5142190
- Diana Park, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 142 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 142 Area: Estepona Region: Andalucía
Cortijo del Mar, Estepona. Located within this wonderful and secure urbanisation with large lagoon swimming pool, chiringuito area, lush tropical gardens and 24 hour security. Within walking (...)
€530,000
TSEA5142139
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 91 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 91 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 91 m².
Setting : Beachfront, Town, Beachside, Close To Sea.
Orientation : South.
Condition : Excellent.
Climate (...)
€530,000
TSEA5142130
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
This bright apartment combines comfort and location in an exclusive setting in the Resina/Selwo area. Located in a private residential complex surrounded by gardens and tranquility, it is perfect for (...)
Current Featured Properties
€542,000
TSEA4378108
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
FANTASTIC OPPORTUNITY IN BEAUTIFUL ESTEPONA.
This new development is located in Estepona just a short walk to the fabulous port and historic old town. The properties will be 2, 3 and 4 beds, with (...)
€565,000
TSEA5116939
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 130 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: San Pedro Region: Andalucía
The origin of a new way of living in Marbella
The first residential project in a new district set to transform the lifestyle in Marbella.
More than just a new development, this development is the (...)
€646,151
TSEA5130664
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 133 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Estepona Region: Andalucía
This new development is integrated in a privileged natural environment with views over the bay of Estepona and the mountains of Marbella, very close to the sea and very well connected. A project of (...)
