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 (39)
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 (39)
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 (39)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 401 - 420 of 1067 €435,000
TSEA5067085
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 112 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Area: Marbella West Region: Andalucía
DON'T MISS OUT ON THIS GREAT OPPORTUNITY
Spacious 2-Bedroom Apartment with Large Terrace and Dual En-Suite Bedrooms in La Maestranza, Nueva Andalucía
Located in the highly sought-after gated (...)
€537,000
TSEA5066971
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 96 Lot Size: 33 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Lot Size: 33 Area: Algeciras Region: Andalucía
The project is located in La Alcaidesa.
La Alcaidesa, located between La Línea de la Concepción and San Roque, in the province of Cádiz, close to Sotogrande and the Rock of Gibraltar. It is an (...)
€890,000
TSEA5066959
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 135 Lot Size: 227 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 135 Lot Size: 227 Area: Estepona Region: Andalucía
Elegant and modern elevated ground-floor apartment with a large private terrace of 90 m² and partial sea views. Located in the sought-after area of Las Mesas, just a 10-minute walk from Estepona (...)
€482,000
TSEA5066908
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2 Baths: 2 M2: 78 Lot Size: 34 Area: Algeciras Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Lot Size: 34 Area: Algeciras Region: Andalucía
The project is located in La Alcaidesa.
La Alcaidesa, located between La Línea de la Concepción and San Roque, in the province of Cádiz, close to Sotogrande and the Rock of Gibraltar. It is an (...)
€202,400
TSEA5066878
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 81 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: La Duquesa Region: Andalucía
RENTED PROPERTY. OPPORTUNITY FOR INVESTORS.
What does a profitable property mean? Having a profitable property means that the owner is earning financial returns from their property through its (...)
€360,027
TSEA5066836
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
Brand-New Apartment in Fuengirola – 3 Bedrooms, 2 Bathrooms
Spacious 109 m² usable area, featuring a 22 m² rear patio, a 5 m² cover terrace, and a total built area of 139 m².
Discover this (...)
€480,000
TSEA5065519
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
This apartment stands out for its spaciousness (more than 100 m² built), its 3 bedrooms, 2 bathrooms, independent kitchen and a spacious living-dining room. It is perfectly oriented to take (...)
€1,250,000
TSEA5064955
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 203 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 203 Area: Marbella West Region: Andalucía
Fantastic corner apartement, all rooms has is own terasse, receive the sun all day, just been not just refurbished but with a personal style with all the best quality materiel, offer 3 bedroom 2 (...)
€696,500
TSEA5064091
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Charming Elevated Ground Floor 3-Bedroom Apartment with Sea and Garden Views – Nueva Andalucía
Welcome to this beautifully presented elevated ground floor apartment located in the exclusive Las (...)
€741,000
TSEA5063980
- La Cala de Mijas, 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
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
€535,000
TSEA5063977
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
€229,000
TSEA5063896
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 45 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 45 Area: Estepona Region: Andalucía
Ground Floor Apartment, Estepona, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 45 m². It is sold with a valid tourist license.
Welcome to this bright and well-distributed 1-bedroom apartment, (...)
€205,000
TSEA5063851
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 45 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 45 Area: Fuengirola Region: Andalucía
Fuengirola center, Costa del Sol- Brand new apartment, fantastic price. Ideal as a holiday apartment!
You will have the opportunity to own a beautiful modern apartment in the centre of Fuengirola, (...)
€280,000
TSEA5063596
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
100M FROM THE BEACH - 2 BEDROOMS 2 BATHROOMS SEAVIEW DUPLEX APARTMENT IN CALAHONDA BEACH
This unique stylish 2-bedroom, 2-bathroom apartment offers breathtaking sea views and an enviable location (...)
€470,000
TSEA5063590
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 1 M2: 72 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 1 M2: 72 Area: San Pedro Region: Andalucía
New Development: Prices from 470,000 € to 1,200,000 €. [Beds: 2 - 4] [Baths: 1 - 3] [Built size: 72.00 m2 - 129.00 m2]
THE DEVELOPMENT
This boutique development of 101 apartments in the new area (...)
€720,000
TSEA5063449
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 139 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Area: Benalmadena Region: Andalucía
An exclusive boutique complex of 28 apartments in the highly sought-after area of Torremuelle, Benalmádena. Each residence has been carefully designed to offer a superior living experience, with (...)
€320,000
TSEA5063368
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 72 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Area: Mijas and Mijas Costa Region: Andalucía
Ground Floor 2-Bedroom Apartment for Sale
Prime Location | 5-Min Walk to Pirata Beach | Gated Community
Welcome to this charming ground floor 2-bedroom, 2-bathroom apartment, located in the highly (...)
€720,000
TSEA5063311
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 138 Lot Size: 4 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 138 Lot Size: 4 Area: Benalmadena Region: Andalucía
New Development: Prices from 720,000 € to 1,200,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 138.00 m2 - 210.00 m2]
An exclusive boutique complex of 28 apartments in the highly sought-after (...)
€1,439,000
TSEA5063296
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 177 Lot Size: 85 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 177 Lot Size: 85 Area: Benalmadena Region: Andalucía
Conceived to integrate naturally into the Mediterranean landscape, this new residential complex is surrounded by green areas, open views of the sea and all the privileges of being part of the Resort (...)
€265,000
TSEA5063257
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 66 Lot Size: 27 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 66 Lot Size: 27 Area: Mijas and Mijas Costa Region: Andalucía
"Discover this beautifully renovated ground-floor apartment in the heart of RIVIERA DEL SOL- MIJAS, Málaga. priced at €289,000. Spanning 82m², this luxurious residence features 2 spacious (...)
Current Featured Properties
€482,000
TSEA5066908
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2 Baths: 2 M2: 78 Lot Size: 34 Area: Algeciras Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Lot Size: 34 Area: Algeciras Region: Andalucía
The project is located in La Alcaidesa.
La Alcaidesa, located between La Línea de la Concepción and San Roque, in the province of Cádiz, close to Sotogrande and the Rock of Gibraltar. It is an (...)
€399,000
TSEA4693576
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 86 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Torremolinos Region: Andalucía
LOCATED IN ONE OF THE BEST AREAS OF TORREMOLINOS!!!
Bringing to life a new residential concept in Torremolinos. Designed to enjoy the Mediterranean and the endless light of the Costa del Sol. A (...)
€855,000
TSEA4955536
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 3 M2: 177 Area: Casares Region: Andalucía
Beds: 4 Baths: 3 M2: 177 Area: Casares Region: Andalucía
A private beach right on your doorstep. Turquoise waters in a tropical setting. An exclusive Mediterranean-style residential complex. Homes with large terraces and high-quality finishes. 38 (...)
