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 (47,68,69,70)
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 (47,68,69,70)
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 (47,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 321 - 340 of 895 €385,000
TSEA5056510
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 200 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 200 Area: Estepona Region: Andalucía
Magnificent semi-detached house in Estepona in the Selwo area, Alpandeire street
The house has three floors:
Ground floor: toilet, living room with fireplace and with two heights, large kitchen and a (...)
€699,900
TSEA5055943
- Nagüeles, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 210 Lot Size: 40 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 210 Lot Size: 40 Area: Marbella Region: Andalucía
Terraced Home with Private Lift, Rooftop Solarium & 2-Car Garage – Prime Marbella Location
Nestled in one of Marbella's most prestigious and sought-after areas, this rare semi-detached home (...)
€1,475,000
TSEA5055829
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 348 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 348 Area: Estepona Region: Andalucía
4-Bedroom Townhouse in Prestigious Urbanisation Villas de Costalita in Estepona
Located near Saladillo Beach and just 15 minutes from Puerto Banús, 10 minutes from Estepona center and 20 minutes (...)
€595,000
TSEA5055076
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 145 Lot Size: 60 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Lot Size: 60 Area: Estepona Region: Andalucía
This beautifully renovated townhouse offers modern design and comfort. It includes three bedrooms, two bathrooms, and a guest toilet. The master bedroom has an ensuite with underfloor heating, which (...)
€999,999
TSEA5054731
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 3 M2: 174 Area: Marbella Region: Andalucía
Beds: 7 Baths: 3 M2: 174 Area: Marbella Region: Andalucía
Historic House in the Heart of Marbella's Old Town –
Located on one of the most iconic streets in Marbella's historic center, this charming three-story home with a rooftop terrace features (...)
€375,000
TSEA5053303
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
Renovated Traditional Townhouse with Rooftop Solarium & Investment Potential
Mijas Pueblo location & Panoramic views
Located on the characterful cobbled streets near Bar Niño and the (...)
€496,000
TSEA5053300
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 2 M2: 174 Area: Estepona Region: Andalucía
Beds: 5 Baths: 2 M2: 174 Area: Estepona Region: Andalucía
Unique opportunity in the heart of Estepona!
Are you looking for a home that combines comfort, style, and a privileged location? This is your chance!
Located just meters from the Town Hall and the (...)
€2,695,000
TSEA5053147
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 266 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 266 Area: Marbella East Region: Andalucía
This brand new renovation project is a beautifully crafted 5-bedroom, 5-bathroom Town Villa located on Marbella's prestigious Golden Mile. Blending contemporary Scandinavian elegance with (...)
€480,000
TSEA5052310
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 80 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Area: Marbella West Region: Andalucía
Discover this spectacular office for sale in the heart of Nueva Andalucía! Located in the prestigious Alzambra Commercial Centre, this property is ideal for entrepreneurs and professionals looking (...)
€456,000
TSEA5052049
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 1 M2: 170 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 1 M2: 170 Area: Benalmadena Region: Andalucía
Located in the heart of Arroyo de la Miel, on a quiet street that ensures both peace and privacy, this bright and charming townhouse offers the perfect blend of central location and a tranquil (...)
€520,000
TSEA5051917
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 81 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Estepona Region: Andalucía
Nestled in a sought-after and well-maintained urbanization in Los Altos del Paraíso, this beautifully presented 2-bedroom, 2-bathroom townhouse offers the perfect blend of comfort, style, and (...)
€530,000
TSEA5051554
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 240 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 240 Area: Estepona Region: Andalucía
Spacious 5-Bedroom Townhouse with Stunning Sea Views
Discover this exceptional townhouse in one of the coast's most sought-after areas, just minutes from the beautiful beaches of Costalita. Located (...)
€437,000
TSEA5051536
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
We present this exclusive semi-detached single-family home, located in one of the quietest and most sought-after areas of Mijas, specifically in Calahonda, a privileged residential area that combines (...)
€437,000
TSEA5051479
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
We present this exclusive semi-detached single-family home, located in one of the quietest and most sought-after areas of Mijas, specifically in Calahonda, a privileged residential area that combines (...)
€299,000
TSEA5051473
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 60 Lot Size: 116 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 60 Lot Size: 116 Area: Mijas and Mijas Costa Region: Andalucía
Recently Renovated and Ready to Fall in Love – Charming Home with Large Terrace and Expansion Potential in Mijas Pueblo
We present to you a unique property, fully renovated with style and (...)
€649,900
TSEA5051341
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 220 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Area: Mijas and Mijas Costa Region: Andalucía
We present this stunning townhouse with 3 bedrooms and 3 bathrooms, located in the exclusive Monte Alto complex in La Cala Golf, Mijas – one of the most sought-after areas on the Costa del Sol. (...)
€689,400
TSEA5051299
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 128 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Marbella West Region: Andalucía
Charming Family Home in Los Naranjos de Marbella: Your Ideal Retreat
Discover this beautiful 3-bedroom house in the highly sought-after urbanization of Los Naranjos de Marbella. Its location is (...)
€1,195,000
TSEA5051224
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 174 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 174 Area: San Pedro Region: Andalucía
Welcome to a newly renovated townhouse located just a few meters from the beaches of San Pedro. The house is surrounded by schools, shops, sports facilities, restaurants, and all essential services. (...)
€437,000
TSEA5051197
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
We present this exclusive semi-detached single-family home, located in one of the quietest and most sought-after areas of Mijas, specifically in Calahonda, a privileged residential area that combines (...)
€442,500
TSEA5051176
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
We present this exclusive semi-detached single-family home, located in one of the quietest and most sought-after areas of Mijas, specifically in Calahonda, a privileged residential area that combines (...)
Current Featured Properties
€599,000
TSEA4765870
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
These impressive homes, set over 4 floors provide 3 bedrooms, 2.5 bathrooms, an ample basement area, private parking, garden, solarium and multiple terraces. The blend of sleek design with the (...)
€949,000
TSEA5155048
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 363 Lot Size: 150 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 363 Lot Size: 150 Area: San Pedro Region: Andalucía
Located in the well-established urbanisation of Tiro de Pichón, this traditional Andalusian townhouse offers 4 bedrooms and 3 bathrooms, set on a 240m2 plot with a built area of 309m2 plus (...)
€470,250
TSEA5065117
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Welcome to the residential complex in Estepona, your new home on the Costa del Sol.
The residential development is an exclusive promotion of 87 single-family homes ready to move into, located in the (...)
