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 (41,39,40,41,162,163)
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 (41,39,40,41,162,163)
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 (41,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 781 - 800 of 3899 €259,000
TSEA5124058
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 100 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Casares Region: Andalucía
Beautifully Renovated 2-Bedroom Ground Floor Apartment in Casares del Sol
Set within the peaceful gated community this beautifully renovated 2-bedroom, 2-bathroom ground floor apartment offers the (...)
€999,000
TSEA5124016
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 129 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 129 Area: Benahavis Region: Andalucía
Stunning Luxury Penthouse with Breathtaking Sea & Golf Views – Priced to Sell Fast!
For Sale – Don't miss this rare opportunity to own a spectacular 3-bedroom, 2-bathroom penthouse in the (...)
€369,000
TSEA5123926
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 78 Lot Size: 60 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Lot Size: 60 Area: Estepona Region: Andalucía
South facing exceptionally spacious unique corner apartment with its own basement garage attached underneath the property, impressively situated within a prestigious Andalucían community in El (...)
€795,000
TSEA5123863
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 130 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 130 Area: Benahavis Region: Andalucía
Luxury Family Apartment in Alborada Homes – Benahavís
4 Bedrooms | 3 Bathrooms | 130 m² interior | 35 m² terrace | West-Facing
Welcome to Alborada Homes, a modern and elegant residential (...)
€595,000
TSEA5123860
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
A rare opportunity to buy this penthouse apartment, centrally located in the beautiful white village of Mijas Pueblo, with two allocated parking spaces and storeroom.
This stunning penthouse is (...)
€313,000
TSEA5123839
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 3 M2: 203 Area: Manilva Region: Andalucía
Beds: 3 Baths: 3 M2: 203 Area: Manilva Region: Andalucía
Renovated Villa with Sea Views in the Heart of Manilva
This spectacular three-bedroom villa offers a prime location in the heart of Manilva, combining tranquility and convenience, just minutes from (...)
€252,500
TSEA5123818
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 106 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Area: Manilva Region: Andalucía
Renovated apartment with front sea views, private terraces and 2 outdoor parking spaces
This 2-bedroom, 2-bathroom apartment has been recently renovated and features a main terrace with stunning (...)
€265,000
TSEA5123758
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 81 Lot Size: 81 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Lot Size: 81 Area: Fuengirola Region: Andalucía
Brand new ground floor apartment in the prestigious Detelina development, in Los Boliches. Recently built with high-quality appliances and appliances, it features an open-plan living room and (...)
€750,000
TSEA5123731
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Surrounded by nature and drenched in light, this exquisite apartment offers a lifestyle of peace, beauty, and elevated comfort in the heart of La Quinta—one of Benahavís' most prestigious (...)
€2,400,000
TSEA5123335
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 4 M2: 160 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 4 M2: 160 Area: Benahavis Region: Andalucía
Situated in one of La Quinta's most sought-after enclaves above San Pedro, this stunning apartment offers panoramic views over the Mediterranean and a refined lifestyle marked by space, privacy, and (...)
€795,000
TSEA5123236
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 251 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 251 Area: Mijas and Mijas Costa Region: Andalucía
Become the owner of a 3 bedrooms apartment with three bathroom, two of which en suite and a huge roof terrace of 155 sqm in an modern development. Offering green spaces, a gym, sauna, saltwater (...)
€259,000
TSEA5123224
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 97 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: La Duquesa Region: Andalucía
This well-presented 2-bedroom apartment enjoys gorgeous views of the mountains, surrounding landscape, and Duquesa Golf's fairways from its main terrace. To the south, the property overlooks the (...)
€410,000
TSEA5123200
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 131 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Area: Mijas and Mijas Costa Region: Andalucía
Presenting you wonderful three bedroom apartment with breathtaking golf views. The apartment recently painted, in a very good conditions, located in a gated beautiful community steps from Miraflores (...)
€365,000
TSEA5123194
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
New to the Market – Prime Estepona Location!
Don't miss this fantastic opportunity to own a beautiful 3-bedroom, 2-bathroom apartment right in the heart of Estepona for half the price, within easy (...)
€845,000
TSEA5123185
- 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
Located in one of the most exclusive areas of the city, this spectacular luxury apartment offers the best in spacious living, panoramic views, and high-end finishes.
Enjoy a private terrace, perfect (...)
€240,000
TSEA5123152
- Victoria Eugenia, Costa Del Sol
Beds: 3 Baths: 1 M2: 99 Region: Andalucía
Beds: 3 Baths: 1 M2: 99 Region: Andalucía
Middle Floor Apartment, Victoria Eugenia, Málaga Ciudad.
3 Bedrooms, 1 Bathroom, Built 99 m².
Setting : Town.
Orientation : South.
Condition : Good.
Climate Control : Air Conditioning.
Views : (...)
€775,000
TSEA5123101
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 176 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 176 Area: Torremolinos Region: Andalucía
Penthouse, Torremolinos, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 176 m².
Setting : Town, Urbanisation.
Condition : Excellent.
Pool : Communal.
Climate Control : Air Conditioning.
Features : (...)
€349,000
TSEA5123044
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
MARBELLA – ALOHA, NUEVA ANDALUCÍA
Top-Floor Corner Apartment with Panoramic Views
Holiday rental are allowed in the building
A rare opportunity to own a bright and spacious 2-bedroom, 2-bathroom (...)
€300,000
TSEA5122951
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 107 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Area: Mijas and Mijas Costa Region: Andalucía
FOR SALE – STUNNING APARTMENT WITH PANORAMIC SEA VIEWS IN UPPER CALAHONDA – MIJAS
Located in a beautiful Moorish-Andalusian style complex, peaceful and secure, this elegant apartment has been (...)
€358,000
TSEA5122936
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
This apartment truly has it all: breathtaking panoramic views, abundant natural light, spacious interiors, and absolute tranquility.
With nearly 150 m² of built area, this generously sized home (...)
Current Featured Properties
€527,000
TSEA4671382
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 86 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Manilva Region: Andalucía
PHASE 2 NOW FOR SALE! BRAND NEW IN A FANTASTIC DEVELOPMENT!!!
This is a development with 100 apartments in a magnificent residential area and in an extraordinary location.
The two and three-bedroom (...)
€424,000
TSEA4752082
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
IDEALLY SITUATED BETWEEN ESTEPONA AND PUERTO BANUS!!!
Your new home is more than just rooms and features, it must fit in with your lifestyle. We have created a floor-plan that is spacious designed to (...)
€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 (...)
