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 (36,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 (36,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 (36,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 3821 - 3840 of 3897 €159,000
TSEA3998092
- Canillas de Aceituno, Costa Del Sol East
Beds: 4 Baths: 2 M2: 137 Lot Size: 137 Region: Andalucía
Beds: 4 Baths: 2 M2: 137 Lot Size: 137 Region: Andalucía
We present to you a cozy and spacious flat located in the municipality of Canillas de Aceituno. A property close to schools, shops, bars and restaurants. It has all the essential and basic amenities (...)
€168,000
TSEA3998089
- Algarrobo, Costa Del Sol East
Beds: 3 Baths: 1 M2: 120 Lot Size: 120 Region: Andalucía
Beds: 3 Baths: 1 M2: 120 Lot Size: 120 Region: Andalucía
We are pleased to present you with a great investment opportunity, an extensive apartment located in Algarrobo village to renovate, with a constructed area of 120 m2, which maintains proximity to the (...)
€649,000
TSEA3990796
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 91 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Casares Region: Andalucía
LAST CHANCE TO BUY! SEA VIEWS THAT YOU DREAM ABOUT!!!
Last 2 beds starting from 360,495€ and one last 3 bed at 558,000€!
Designed in a contemporary style, the apartments and penthouses have been (...)
€890,000
Ground Floor Apartment in San Pedro de Alcántara
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 200 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Area: San Pedro Region: Andalucía
START LIVING YOUR BEST LIFE!!!
A luxury residential Project in Guadalmina Alta, Marbella (Malaga), this is a perfect location for you to enjoy the famous Mediterranean lifestyle. The living room (...)
€380,000
TSEA3979039
- Caleta de Vélez, Costa Del Sol East
Beds: 2 Baths: 2 M2: 90 Lot Size: 90 Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Lot Size: 90 Region: Andalucía
Beautiful duplex flat in first line beach, with wonderful views to the sea. It has an open plan kitchen, which opens onto a small balcony. It is next to the cosy living room. On the same floor there (...)
€533,000
TSEA3978817
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 229 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 229 Area: La Duquesa Region: Andalucía
Magnificent FIRST FLOOR APARTMENT with spectacular sea views, located in an urbanization area at a short distance from Sotogrande harbour and close the beach. In impecable condiction, the apartment (...)
€449,000
TSEA3974668
- Los Flamingos, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Lot Size: 23 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 23 Area: Estepona Region: Andalucía
A beautifully furnished 2 bedroom apartment in Hoyo 19 which is located in the wonderful and exclusive development of Los Flamingos Golf Resort Resort in Benahavis. The apartment has hot and cold air (...)
€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 (...)
€438,000
TSEA3969424
- Los Monteros, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 87 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Marbella East Region: Andalucía
SO PEACEFUL YOU WON'T HEAR A PIN DROP!!!
Come and see this fabulous development of 39 luxury apartments located in the upper part of Los Monteros. This contemporary design development distributed (...)
€875,000
TSEA3968908
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 195 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 195 Area: Marbella Region: Andalucía
Very large penthouse in the center of Marbella. Sought after location with all services and amenities at door step and just a stroll to the beach. This ample and full of light top floor apartment (...)
€518,000
TSEA3955906
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 118 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 118 Area: Estepona Region: Andalucía
ELEGANT AND MODERN IN THE HEART OF COSTA DEL SOL. This development is nestled in an incomparable natural environment where the sea meets the mountain and there is golf and all the services of (...)
€1,100,000
TSEA3950773
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 159 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 159 Area: Estepona Region: Andalucía
Ggreat property in Alhambra del Golf ready to move in. High standards, perfect location, beach side, three bedrooms 3 baths, garage and storage. Closed gated secured complex. Beach side of the main (...)
€1,110,000
TSEA3948409
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 151 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 151 Area: Fuengirola Region: Andalucía
THE ESSENCE OF THE MEDITERRANEAN LIFESTYLE.
Located in the northern area of the Torreblanca del Sol, in the municipality of Fuengirola. An open block multi-family building with a total of 30 (...)
€635,000
TSEA3948304
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 92 Lot Size: 86 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Lot Size: 86 Area: Fuengirola Region: Andalucía
EVERY DETAIL HAS BEEN TAKEN CARE OF!!!
Located in the northern area of the Torreblanca del Sol Development, in the municipality of Fuengirola. An open block multi-family building with a total of 30 (...)
€299,000
TSEA3936313
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 106 Lot Size: 218 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Lot Size: 218 Area: Estepona Region: Andalucía
LAST THREE BED AVAILABLE, GET IN TOUCH TODAY BEFORE IT IS GONE!!!
Brand new project, 90 dwellings of 1, 2 and 3 bedrooms, all of them with garage space and storage room. It is an exclusive (...)
€266,000
TSEA3936250
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Lot Size: 53 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Lot Size: 53 Area: Estepona Region: Andalucía
BRAND NEW DEVELOPMENT IN ESTEPONA.
Don't miss out on an opportunity to buy in this development of 90 dwellings of 1, 2 and 3 bedrooms, all of them with garage space and storage room. It is an (...)
€577,500
TSEA3923743
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
GREAT LOCATION CLOSE TO CHARMING ESTEPONA.
The apartments are specially designed to fully enjoy the charm of the Mediterranean lifestyle. A well thought out floor plan, bathrooms with lovely (...)
€467,250
TSEA3923275
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 93 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Estepona Region: Andalucía
CHARMING SPACIOUS APARTMENTS!!!
The apartments are specially designed to fully enjoy the charm of the Mediterranean lifestyle, but they are also designed with a Northern European vision. A well (...)
€570,000
TSEA3922510
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
LAST OPPORUNITY TO ACQUIRE!!!!
One of the last opportunities to acquire a newly built property in the centre of Estepona, seaside and just 1 minute from the beach. A dream lifestyle which can be (...)
€1,275,000
TSEA3920965
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 368 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 368 Area: Fuengirola Region: Andalucía
Prime location!
Duplex penthouse located in Fuengirola
Within walking distance to all amenities, beachside, great access to the highway
Amazing views overlooking the sohail castle, the river and (...)
Current Featured Properties
€1,225,000
TSEA5020480
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 4 M2: 207 Lot Size: 103 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 4 M2: 207 Lot Size: 103 Area: Marbella East Region: Andalucía
This project is a complex of 21 luxurious residences in Marbella, embracing the natural surroundings and creating an ecosystem of peace and harmony. A boutique development offering the perfect (...)
€375,000
TSEA4175446
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
IF YOU LOVE GOLF YOU WILL LOVE THIS DEVELOPMENT!!
This is the new residential development in Estepona Golf, at the heart of the Costa del Sol, a privileged location close to wonderful beaches such as (...)
€329,000
TSEA5074063
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
This development consists of 79 luminous 2 and 3 bedroom apartments and penthouses.
Located only 3 minutes away from the picturesque village La Cala de Mijas, with an abundance of bars, shops, (...)
