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 (162,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 (162,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 (162,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (11), Middle Floor - (11), Penthouse - (11), Top Floor Apartment - (11), Penthouse Duplex - (11)Properties
Results 81 - 100 of 3894
€350,000
TSEA5155966
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 85 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Casares Region: Andalucía
Great opportunity in Hacienda de Casares! Beautiful penthouse with panoramic sea views!
With all the amenities you need and just 5 minutes from the beach. The home is in a prime location, surrounded (...)
€510,000
TSEA5155954
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
???? Attention investors
New listing in Puerto Banús, Marbella!
Spacious 114 m² apartment with terrace and private parking space, located in one of the most exclusive and peaceful complexes in the (...)
€255,000
TSEA5155915
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
For sale: ground-floor apartment with two terraces, one at the entrance of the home and another at the front, totaling approximately 30 m2.
The apartment has a constructed area of 99 m2, of (...)
€599,000
TSEA5155873
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 116 Lot Size: 56 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Lot Size: 56 Area: Mijas and Mijas Costa Region: Andalucía
New on the market!!
Welcome to your dream getaway!
Located on the ground floor of the prestigious Casa Banderas complex, this modern 3-bedroom, 2-bathroom apartment offers the perfect blend of (...)
€316,000
TSEA5155780
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Beautiful renovated 114 m2 apartment with 2 bedrooms and 2 bathrooms in a residential area very close to Estepona beach.
The property stands out for its brightness, freshness, and charm, offering a (...)
€725,000
TSEA5155720
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 145 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Area: Benahavis Region: Andalucía
Experience Scandinavian elegance with panoramic views of the Mediterranean
This 144 sqm residence has been exquisitely renovated with an emphasis on clean lines, refined design, and top-tier (...)
€560,000
TSEA5155711
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 3 M2: 128 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 3 M2: 128 Area: Marbella West Region: Andalucía
Fantastic Investment Opportunity in Prime Golf Valley Location, Señorio de Aloha.
This 2-bedroom duplex penthouse is ideally situated in the heart of Nueva Andalucía's Golf Valley, just a short (...)
€399,000
TSEA5155435
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 113 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Fuengirola Region: Andalucía
HIGHLIGHTS
Pine Hill Residences represents a unique opportunity to enjoy life on the Costa del Sol in a modern and exclusive setting. This development combines a strategic location, just minutes from (...)
€900,000
TSEA5155387
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 154 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 154 Area: Benahavis Region: Andalucía
Beautiful large fully renovated penthouse located in a gated complex in La Quinta, close to the famous Westin Hotel. The property comprises of a spacious living area with open plan kitchen, 4 (...)
€492,000
TSEA5155384
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 88 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Estepona Region: Andalucía
This first-floor apartment, located in the exclusive Paseo Maritimo area in the center of Estepona, stands out for its side sea views and direct access to the promenade. Fully renovated and ready to (...)
€445,000
TSEA5155378
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Situated in the very centre of Marbella, just a few steps from the beach, this beautifully refurbished apartment offers the rare combination of luxury, comfort, and unbeatable location. Perfect as a (...)
€360,000
TSEA5155372
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 72 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 72 Area: Estepona Region: Andalucía
This beautiful, newly built (2023) apartment is stylishly furnished and ideally located at the edge of Estepona's historic old town. Offering 2 spacious bedrooms and 2 contemporary bathrooms, the (...)
€895,000
TSEA5155318
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 238 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 238 Area: Benalmadena Region: Andalucía
Penthouse for sale in , Benalmadena with 3 bedrooms, 2 bathrooms, 1 on suite bathroom and with orientation south, with communal swimming pool, private garage (1 parking spaces) and communal garden. (...)
€499,000
TSEA5155288
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Luxury 2 bed, 2 bath apartment, a short flat walk to La Cala town & beach and many other local amenities. La Cala is booming and this stylish apartment is a great opportunity.
In a small, (...)
€850,000
TSEA5155237
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Stunning 2-Bedroom Apartment with Sea Views in Estepona.
This exquisite 2-bedroom, 2-bathroom property perfectly blends elegance, comfort, and location. With a bright, open-plan living and dining (...)
€215,000
TSEA5155156
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Investment Opportunity – Las Lagunas de Mijas
Discover this excellent property located in the heart of Las Lagunas de Mijas, within a well-connected residential area and just steps away from all (...)
€284,500
TSEA5155150
- Málaga Este, Costa Del Sol, Nerja and Malaga East
Beds: 3 Baths: 1 M2: 73 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 1 M2: 73 Area: Nerja and Malaga East Region: Andalucía
8th Floor Apartment, Málaga East el Palo, Costa del Sol.
2.5 Bedrooms, 1 Bathroom, Built 73 m².
With turistic licence
Setting : Town, Close To Sea.
Condition : Excellent, Recently (...)
€2,600,000
TSEA5155126
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 201 Lot Size: 30 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 201 Lot Size: 30 Area: Marbella West Region: Andalucía
Welcome to this newly renovated duplex ground floor apartment in the heart of Nueva Andalucia, Marbella.
This property is very unique because of its spacious rooms , terraces , private garden and (...)
€546,500
TSEA5155111
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 74 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 74 Area: Malaga Region: Andalucía
Middle Floor Apartment, Málaga Historic Centre Uncibay area, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 74 m².
Video
Setting : Town.
Condition : Excellent, Recently Renovated.
Features : Lift, (...)
€276,000
TSEA5155093
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 75 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 75 Area: Fuengirola Region: Andalucía
Modern Fully Renovated Apartment with Parking – Fuengirola
This stylish apartment, recently reformed to a high standard, is perfectly located in Fuengirola with excellent transport connections and (...)
Current Featured Properties
€349,950
TSEA4335331
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 86 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Fuengirola Region: Andalucía
This new development is located in the north of Fuengirola, in the Los Pacos neighborhood: a residential, multicultural and multilingual area with a cosmopolitan atmosphere, close to the beach and (...)
€470,000
Oasis of tranquility close to beaches
- San Roque, Costa Del Sol, San Roque
Beds: 3 Baths: 2 M2: 115 Area: San Roque Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: San Roque Region: Andalucía
OASIS OF TRANQUILITY CLOSE TO BEACHES.
New release! A great opportunity to buy an off plan apartment at an UNBEATABLE PRICE. The apartment style is light and bright with large open plan living (...)
€3,695,000
TSEA5080774
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 187 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 187 Area: Estepona Region: Andalucía
This fully remodelled 4 bedroom and 3-bathroom apartment is an amazing opportunity for people who are looking for luxury and comfort in a stunning beachfront location. The spacious living and dining (...)
