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 3841 - 3860 of 7575
€399,900
TSEA5012218
- 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
Coastal Chic Living in the Heart of Marbella- Casco Antiguo
Step into laid-back luxury with this fully reimagined 3-bedroom, 2-bathroom stunner, perfectly situated in Marbella Center—just a breezy (...)
€1,349,000
TSEA5012209
- Monte Halcones, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 192 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 192 Area: Benahavis Region: Andalucía
This beautifully renovated 4-bedroom, 3-bathroom townhouse is the perfect blend of Scandinavian design and Mediterranean living. It's bright, spacious, and thoughtfully designed, offers a warm and (...)
€395,000
TSEA5012191
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Duplex penthouse located in a rapidly expanding area between Fuengirola and Cala de Mijas (Chaparral-Calaburras golf course area), approximately 300 meters from Playamarina beach and El Charcón. It (...)
€299,000
TSEA5012188
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
This is an attractive well kept apartment with some of the most amazing sea and coastal views that must be seen to be appreciated. The apartment has two bedrooms and two bathrooms and is located in a (...)
€975,000
TSEA5012137
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 143 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 143 Area: Estepona Region: Andalucía
Discover this magnificent newly built apartment, located in the prestigious Las Mesas area of Estepona. Designed to combine comfort, modernity, and a privileged lifestyle, this property is ideal for (...)
€175,000
TSEA5012092
- Alora, Costa Del Sol, Älora
Beds: 4 Baths: 2 M2: 128 Area: Älora Region: Andalucía
Beds: 4 Baths: 2 M2: 128 Area: Älora Region: Andalucía
Your new home in Álora is waiting for you!
Are you looking for a spacious, bright home in a peaceful area of Álora? We present to you this fantastic ground-floor apartment, just a few steps from (...)
€685,000
TSEA5012065
- Perchel Sur, Costa Del Sol
Beds: 4 Baths: 2 M2: 134 Region: Andalucía
Beds: 4 Baths: 2 M2: 134 Region: Andalucía
Imagine waking up every morning with the sun gently lighting up your home, on the top floor of a well-kept building in the charming Plaza de la Misericordia. This apartment, located on the top floor (...)
€539,000
TSEA5011693
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 117 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 117 Area: Fuengirola Region: Andalucía
Brand-new 3-bedroom, 2-bathroom apartment in Las Lomas del Higuerón, combining modern sophistication with natural elegance. With the best market price in its category and sea views, this is a unique (...)
€690,000
TSEA5011273
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 77 Lot Size: 243 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 77 Lot Size: 243 Area: Estepona Region: Andalucía
Exceptional Frontline Luxury Beach Townhouse in Bahia Dorada
Discover the epitome of luxury coastal living with this newly reformed duplex townhouse, nestled right on the beachfront in the (...)
€390,000
TSEA5011234
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to this renovated penthouse in El Faro, a sought-after area known for its views of the Mediterranean Sea and nearby mountains. The property is part of a well-maintained and quiet (...)
€298,000
TSEA5011228
- Los Pacos, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 79 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 79 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 298,000 € to 446,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 79.00 m2 - 85.00 m2]
Are you looking for a home in a modern residential complex with spacious (...)
€1,265,000
TSEA5011201
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 220 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 220 Area: Benahavis Region: Andalucía
Luxury 4-Bedroom Penthouse for Sale in Marbella Club Hills
Welcome to this extraordinary 4-bedroom, 4-bathroom apartment located in the exclusive Marbella Club Hills development — a premium (...)
€1,100,000
TSEA5011174
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 3 M2: 218 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 3 M2: 218 Area: La Duquesa Region: Andalucía
A stunning detached villa with beautiful coastal views, recently updated throughout to a very high standard.This beautiful villa is found on the small, peaceful urbanisation of Jardines (...)
€949,000
TSEA5011114
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 4 M2: 218 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 4 M2: 218 Area: Sotogrande Region: Andalucía
Exceptional Living in Sotogrande
Welcome to a unique residential complex perched above the sea with panoramic views over lush golf courses. Designed by renowned Spanish architect Rafael de La-Hoz, (...)
€3,495,000
TSEA4719142
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 3 M2: 545 Lot Size: 2,956 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 3 M2: 545 Lot Size: 2,956 Area: Benahavis Region: Andalucía
New Development: Prices from 3,495,000 € to 3,495,000 €. [Beds: 5 - 5] [Baths: 3 - 3] [Built size: 545.00 m2 - 545.00 m2]
LICENSES APPROVED IN MONTE MAYOR, BENAHAVIS WITH BEAUTIFUL SEA VIEWS (...)
€3,695,000
TSEA4801192
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 6 M2: 562 Lot Size: 847 Area: Marbella Region: Andalucía
Beds: 6 Baths: 6 M2: 562 Lot Size: 847 Area: Marbella Region: Andalucía
New Development: Prices from 3,695,000 € to 3,695,000 €. [Beds: 6 - 6] [Baths: 6 - 6] [Built size: 562.00 m2 - 562.00 m2]
PROJECT AND LICENSES APPROVED - OFF-PLAN LUXURY ECOLOGICAL VILLA IN (...)
€795,000
TSEA5011090
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 114 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: San Pedro Region: Andalucía
Magnificent apartment in one of the most sought after areas of Nueva Alcantara, the beach side of San Pedro de Alcantara. Within the modern urbanization built in 2024.
The property offers a (...)
€1,040,000
TSEA5011087
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 136 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Benalmadena Region: Andalucía
New Development: Prices from 1,040,000 € to 1,145,000 €. [Beds: 3 - 4] [Baths: 2 - 2] [Built size: 136.00 m2 - 167.00 m2]
DESIGN and QUALITY in all its SPACES
An exclusive boutique project of (...)
€1,490,000
TSEA5011081
- Cádiz, Costa de la Luz
Beds: 9 Baths: 7 M2: 340 Region: Andalucía
Beds: 9 Baths: 7 M2: 340 Region: Andalucía
A beautiful and charming boutique hotel is currently operating for sale. It boasts a distinct personality, located in a building that faithfully reflects Cádiz architecture.
The accommodation is (...)
€1,350,000
TSEA5010958
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 3 M2: 162 Area: Marbella Region: Andalucía
Beds: 2 Baths: 3 M2: 162 Area: Marbella Region: Andalucía
Presenting a rare opportunity to own a luxury apartment in one of the most sought-after beachfront communities.
This stunning south-west facing, ground-floor apartment offers 132m² of sophisticated (...)
Current Featured Properties
€732,000
Middle Floor Apartment in Atalaya
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 121 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Area: Estepona Region: Andalucía
FANTASTIC LOCATION NEAR MARBELLA!!!
A new development of apartments (2 or 3 bedrooms available) in the privileged area of Atalaya. This area is close to all services and surrounded by golf (...)
€587,000
Middle Floor Apartment in Los Monteros
- Los Monteros, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
LUXURY TO ITS HIGHEST STANDARD!!!
A development of 39 luxury apartments. Located in the upper part of Los Monteros, this contemporary design development distributed over 5 floors plus an attic, has (...)
€4,950,000
TSEA4790245
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 488 Lot Size: 970 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 488 Lot Size: 970 Area: Marbella West Region: Andalucía
Nestled within the illustrious enclave of Nueva Andalucia, This new development provides residents a luxurious escape that embodies the true essence of luxury living. With its privileged location in (...)
