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 (42,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 (42,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 (42,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 2221 - 2240 of 5891
€1,390,000
TSEA5053051
- Los Alamos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 120 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Torremolinos Region: Andalucía
Eng.: A stunning beach apartment in an exclusive, newly built gated community on the 1st line of the beach. This elegantly furnished 3-bedroom apartment offers a unique opportunity for those looking (...)
€385,000
TSEA5052661
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 118 Lot Size: 30 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 118 Lot Size: 30 Area: Mijas and Mijas Costa Region: Andalucía
Enjoy your coming holidays in this contemporary ground floor apartment with a large private garden. Entering the apartment you have three bedrooms on the left of the hallway which leads you to the (...)
€699,000
TSEA5052613
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 102 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Fuengirola Region: Andalucía
Step into elegance with this beautiful 2 bedroom/2 bathroom property in the sought-after Higuerón West development!
Enjoy not only one, but two spacious terraces with breathtaking views of the (...)
€745,000
TSEA5052601
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 457 Lot Size: 2,692 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 457 Lot Size: 2,692 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful large detached villa in colonial style.
Exclusive mansion, ready to move in and located in the quiet, green surroundings of Pinos de Alhaurin.
* Walking and cycling distance to the (...)
€699,000
TSEA5052598
- Pueblo Nuevo de Guadiaro, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 270 Lot Size: 981 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 270 Lot Size: 981 Area: Sotogrande Region: Andalucía
Spectacular, villa located in one of the most privileged areas of Pueblo Nuevo de Guadiaro.
Surrounded by all amenities such as shops, schools, restaurants, and leisure areas, this home offers the (...)
€399,000
TSEA5052592
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 131 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 131 Area: Mijas and Mijas Costa Region: Andalucía
Located in one of Calahonda's most prestigious and tranquil residential complexes, this elegant ground floor apartment offers a unique combination of comfort, privacy, and privileged surroundings, (...)
€399,000
TSEA5052544
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse with Huge Terrace in Miraflores
This two-bedroom penthouse is located in a well-kept gated complex in the heart of Miraflores, just a 15-minute walk from El Bombo beach in La Cala. What (...)
€750,000
TSEA5052439
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 2 M2: 180 Lot Size: 388 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 2 M2: 180 Lot Size: 388 Area: Marbella West Region: Andalucía
House for sale in Nueva Andalucía.
On a 388 m2 plot, the upper floor features a house with 4 bedrooms, 2 bathrooms, a kitchen, a living room, and access to the terrace with access to the private (...)
€495,000
TSEA5052409
- Perchel Norte, Costa Del Sol
Beds: 2 Baths: 2 M2: 72 Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Region: Andalucía
In the heart of the Perchel Norte neighborhood, one of Málaga's most well-connected and up-and-coming areas, this brand-new apartment awaits you. Located on the first floor of a modern building with (...)
€1,650,000
TSEA5052349
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 232 Lot Size: 715 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 232 Lot Size: 715 Area: Mijas and Mijas Costa Region: Andalucía
Stunning luxury villa located in the lower part of Calahonda, in an exclusive cul-de-sac surrounded by villas and in a very quiet residential area, just 800 meters from the beach, close to a (...)
€1,514,000
TSEA5052343
- Málaga Este, Costa Del Sol, Nerja and Malaga East
Beds: 4 Baths: 4 M2: 221 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 4 M2: 221 Area: Nerja and Malaga East Region: Andalucía
Located in one of the most sought after areas of Malaga, this spectacular property is situated on the emblematic Paseo Marítimo Pablo Ruiz Picasso, 50 metres from the beach, offering unrivalled (...)
€2,500,000
TSEA5052340
- Manilva, Costa Del Sol, Manilva
Beds: 6 Baths: 8 M2: 661 Area: Manilva Region: Andalucía
Beds: 6 Baths: 8 M2: 661 Area: Manilva Region: Andalucía
Modern luxury villa set within a vast private and peaceful estate offering breathtaking sea and mountain views featuring a stunning 16 x 6 meter private infinity pool surrounded by sun and shaded (...)
€251,300
TSEA5052304
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 53 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 53 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 251,300 € to 368,900 €. [Beds: 1 - 1] [Baths: 1 - 1] [Built size: 53.00 m2 - 66.00 m2]
A modern apartment complex is an innovative development of 116 one-bedroom (...)
€1,355,000
TSEA5052238
- Málaga Este, Costa Del Sol, Nerja and Malaga East
Beds: 6 Baths: 5 M2: 514 Lot Size: 842 Area: Nerja and Malaga East Region: Andalucía
Beds: 6 Baths: 5 M2: 514 Lot Size: 842 Area: Nerja and Malaga East Region: Andalucía
Detached Villa, Málaga Este, Costa del Sol.
6 Bedrooms, 5 Bathrooms, Built 514 m², Garden/Plot 842 m².
Setting : Close To Schools, Urbanisation.
Orientation : North, East, South, West.
Condition (...)
€299,000
TSEA5052229
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Located right in the heart of Riviera del Sol, between La Cala de Mijas and Marbella, this well-proportioned 2 bedroom, 2 bathroom penthouse offers a fantastic opportunity in a prime spot on the (...)
€349,000
TSEA5052187
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 99 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: Estepona Region: Andalucía
"**Beautiful apartment with stunning mountain views**
Tranquility awaits you in this exceptional property, located in the best position within an exclusive gated community. With panoramic views (...)
€240,000
TSEA5052148
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 60 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 60 Area: Casares Region: Andalucía
Lovely 2-bed apartment with terrace, private garden and sea and golf views in Casares Costa.
The living room is bright and leads to a covered large terrace with stunning sea views, that is currently (...)
€695,000
TSEA5052046
- Los Alamos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 152 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 152 Area: Torremolinos Region: Andalucía
We present this fantastic apartment located in one of the most sought-after areas of Los Álamos, Torremolinos, right on the beachfront.
The property features three bedrooms, two full bathrooms, and (...)
€949,500
TSEA5051941
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 172 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 172 Area: Marbella West Region: Andalucía
This renovated apartment is located in Alcores del Golf, a south-facing property with plenty of natural light and a clean, minimalistic design. The open-plan layout connects the living area with a (...)
€1,350,000
TSEA5051689
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 180 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: Marbella Region: Andalucía
Step into the epitome of boutique luxury living with this stunning duplex penthouse in Altos de Los Monteros, Marbella. Nestled in an exclusive residential enclave with only five residences, this (...)
Current Featured Properties
€420,000
TSEA5034892
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
The exclusive residential complex invites you to a modern lifestyle infused with traditional Andalusian charm, all within a community designed for those who appreciate quality and natural beauty. At (...)
€585,000
TSEA4164577
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 130 Lot Size: 210 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 210 Area: Marbella East Region: Andalucía
BEACHFRONT HOME FOR SALE - LIVE THE BEACH LIFE YOU'VE ALWAYS WANTED!!
This middle floor apartment located in Elviria, Marbella East is a great investment opportunity for those who love the beachfront (...)
€845,250
TSEA4581460
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 106 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Area: San Pedro Region: Andalucía
The development in San Pedro de Alcantara is made up of 35 homes with 2 and 3 bedrooms, with duplexes with terraces-solariums. Garages in the basement and commercial premises on the ground floor, in (...)
