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 1181 - 1200 of 7575 €2,700,000
TSEA5126596
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 280 Lot Size: 808 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 280 Lot Size: 808 Area: Marbella West Region: Andalucía
This lovely four-bedroom, newly renovated villa is located in the residential area of Nueva Andalucía, within the secure, gated community of Marbella Country Club.
The property features stunning (...)
€346,000
TSEA5126557
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 85 Lot Size: 30 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 30 Area: Marbella East Region: Andalucía
Renovated townhouse with sea views in Reserva de Marbella
Located in one of the quietest areas of Reserva de Marbella, this townhouse offers the perfect combination of comfort, natural light, and (...)
€3,350,000
TSEA5126548
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 222 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 222 Area: Marbella West Region: Andalucía
Stunning Fully Renovated 4-Bedroom Apartment in Playas del Duque – Puerto Banús
Located in the heart of Puerto Banús, this beautifully renovated 4-bedroom, 4-bathroom apartment offers an (...)
€1,490,000
TSEA5126542
- Costalita, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 144 Lot Size: 186 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Lot Size: 186 Area: Estepona Region: Andalucía
**Top location:**
✔ Absolutely first beach line on the "New Golden Mile"
✔ Marvellous sea view & direct access to the beach promenade & beach
✔ Quiet, exclusive (...)
€185,000
TSEA5126527
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 70 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 70 Area: Benahavis Region: Andalucía
Charming Apartment in La Pacheca – Benahavís
Located in the peaceful and picturesque urbanisation La Pacheca, just minutes from the charming village center of Benahavís, this delightful apartment (...)
€1,550,000
TSEA5126509
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 4 M2: 311 Lot Size: 836 Area: Marbella Region: Andalucía
Beds: 5 Baths: 4 M2: 311 Lot Size: 836 Area: Marbella Region: Andalucía
Charming villa with huge potential in Urb El Mirador, Marbella
Looking for a renovation project close to Marbella center? This detached villa in El Mirador is a opportunity to create your (...)
€599,500
TSEA5126506
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 112 Lot Size: 62 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Lot Size: 62 Area: Benahavis Region: Andalucía
We are delighted to present this beautiful 3-bedroom, 2-bathroom apartment, located in an elevated ground floor position that combines privacy, comfort, and exceptional outdoor living. With its (...)
€399,000
TSEA5126488
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 82 Lot Size: 35 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Lot Size: 35 Area: Marbella West Region: Andalucía
Welcome to this fantastic ground-floor apartment in the sought-after area of Señorio de Gonzaga, located in the heart of charming Nueva Andalucía – Aloha.
This ground-floor apartment is situated (...)
€575,000
TSEA5126461
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 149 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 149 Area: Benalmadena Region: Andalucía
We're delighted to present this contemporary 2-bedroom, 2-bathroom apartment, located in a modern development built in 2020 in the serene hills of Benalmádena. Designed for comfort and lifestyle, (...)
€1,420,000
TSEA5126443
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 220 Lot Size: 638 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Lot Size: 638 Area: San Pedro Region: Andalucía
Exclusive Luxury Villa for Sale – Elegance, Comfort, and Prime Location
Discover this impressive luxury villa located in one of the most exclusive areas of the Costa del Sol. With elegant (...)
€545,000
TSEA5126437
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 117 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 117 Area: Marbella Region: Andalucía
Middle Floor Apartment, Marbella, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 117 m², Terrace 27 m².
Setting : Town, Suburban, Commercial Area, Beachside, Close To Shops, Close To (...)
€660,000
TSEA5126431
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 193 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 193 Area: Marbella West Region: Andalucía
Duplex, Nueva Andalucía, Costa del Sol.
4 Bedrooms, 3 Bathrooms, Built 193 m², Terrace 48 m².
Private internal elevator.
Setting : Close To Golf, Close To Port, Close To Shops, Close To Sea, (...)
€310,000
TSEA5126425
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Spacious 3-Bedroom Apartment with Sea Views in Urb. Los Olivos, Riviera del Sol
Nestled in the tranquil and well-maintained urbanization of Los Olivos in Riviera del Sol, this stunning 3-bedroom, (...)
€295,000
TSEA5126407
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 99 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: La Duquesa Region: Andalucía
Princesa Kristina area - South facing elevated spacious apartment with amazing sea views. Spacious, apartments with private terraces, fully equipped kitchens, and access to a communal outdoor (...)
€495,000
TSEA5126401
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 52 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: Marbella Region: Andalucía
Penthouse with 80 m² Terrace to Renovate – Great Potential in the Heart of Marbella Center
Located on the 7th floor of a well-known building on Ricardo Soriano, Marbella's main avenue, this (...)
€279,000
TSEA5126332
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 194 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 194 Area: Casares Region: Andalucía
Located in the peaceful and sought-after urbanization of Hacienda Casares, near the prestigious Doña Julia golf course, this 3-bedroom, 2-bathroom apartment stands out for its excellent condition (...)
€1,590,000
TSEA5126305
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 160 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Marbella East Region: Andalucía
Welcome to Balcon de Puente Romano – a gated community on Marbella's prestigious Golden Mile.
This 3-bedroom ground-floor property offers a sophisticated single-level living, complemented by a (...)
€1,550,000
TSEA5126302
- Jimena de la Frontera, Costa de la Luz
Beds: 4 Baths: 2 M2: 301 Lot Size: 104,000 Region: Andalucía
Beds: 4 Baths: 2 M2: 301 Lot Size: 104,000 Region: Andalucía
p> A truly exceptional Country Estate situated midway between the picturesque white villages of San Martin de Tesorillo and Jimena de la Frontera—a property that redefines the concept of rural (...)
€790,000
TSEA5126278
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 129 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 129 Area: Marbella East Region: Andalucía
Beautiful south-facing apartment with magnificent sea views, located in the sought-after community of Pinos de Nagüeles, in Marbella's prestigious Golden Mile. Within walking distance to the beach, (...)
€298,000
TSEA5126218
- Sedella, Costa Del Sol East
Beds: 3 Baths: 2 M2: 254 Lot Size: 254 Region: Andalucía
Beds: 3 Baths: 2 M2: 254 Lot Size: 254 Region: Andalucía
This extraordinary property blends over 400 years of history with contemporary living comfort. In 2022, it underwent a full renovation with great attention to detail and a strong focus on quality and (...)
Current Featured Properties
€440,000
TSEA5071168
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 110 Lot Size: 34 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Lot Size: 34 Area: Casares Region: Andalucía
Discover this exclusive new development consisting of 99 apartments and penthouses, each with 2 or 3 bedrooms, designed to help you find where you truly belong. Situated in the prime location of (...)
€404,400
TSEA5018557
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 97 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Area: Benalmadena Region: Andalucía
This brand new development is located on Calle Menta in Benalmadena (Málaga). It is the new residential in Benalmadena, Málaga. The private urbanization has 70 homes of 2 and 3 bedrooms, in (...)
€400,000
TSEA4805725
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 56 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 56 Area: Estepona Region: Andalucía
This new development in the Estepona Centre comprising 43 one, two and three bedroom apartments and penthouses, terraces and magnificent communal areas. It boasts excellent finishes, a prime location (...)
