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 (43,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 (43,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 (43,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 221 - 240 of 4194
€580,000
TSEA5149873
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 84 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 84 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€343,000
TSEA5149855
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 50 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 50 Area: Malaga Region: Andalucía
Tourist-Licensed Apartment in the Heart of Málaga – La Merced Area
Turnkey investment with proven high returns!
Located just a few steps from the iconic Plaza de la Merced, this modern apartment (...)
€370,000
TSEA5149840
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€475,000
TSEA5149831
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
The spacious apartment to reform with 2-bedroom, 2-bathroom (one en suite) is located in an exclusive frontline beach complex in Calahonda. Situated on the third floor with lift access, it boasts a (...)
€370,000
TSEA5149801
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€425,000
TSEA5148742
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
ELVIRIA. LOVELY APARTMENT WITH GREAT POTENTIAL SITUATED ON THE TOP FLOOR IN THE CENTRAL URBANIZATION OF PARQUE ELVIRIA. THE APARTMENT IS 105 m2 INCLUDING TERRACES. THE APARTMENT HAS 3 BEDROOMS AND 2 (...)
€400,000
TSEA5148733
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 1 Baths: 1 M2: 71 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 1 M2: 71 Area: Marbella East Region: Andalucía
Beautiful one bedroom apartment with spacious lounge dining room, fitted kitchen and terrace. Property has air conditioning, marble floors, 1 storage room and a parking space in the underground (...)
€185,000
TSEA5148727
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Discover the charm of this beautiful and spacious studio, which was originally a cozy one-bedroom apartment. Located in a prime location, you'll enjoy spectacular sea views from the comfort of your (...)
€315,000
TSEA5148703
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 78 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 78 Area: Torremolinos Region: Andalucía
FLAT FOR SALE IN TORREMOLINOS
Beautiful, sunny flat for sale, built in 2007 with high-quality finishes, located on the second floor of a building with a lift and only seven neighbours, completely (...)
€315,000
TSEA5148673
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
spacious 3 bed 2 bath apartment centrally located
large communal pool
in need of some updating
located close to shops and restaurants
Middle Floor Apartment, Las Lagunas, Costa del Sol.
3 (...)
€285,000
TSEA5148664
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic apartment located in Las Lagunas.
Discover this fantastic 126 m2 apartment located in the coveted area of Las Lagunas.
The property features three bedrooms, all equipped with (...)
€595,000
TSEA5148604
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 152 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 152 Area: Mijas and Mijas Costa Region: Andalucía
Bright and Spacious 3 Bed Corner Apartment with Stunning Views, Private Terrace and Premium Facilities
Welcome to this inviting 3-bedroom apartment in the sought-after Las Olas complex in (...)
€535,000
TSEA5148583
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
This four-bedroom flat, situated in the heart of Marbella, Malaga, presents an exceptional opportunity for those seeking a well-located property with substantial potential. Set within a gated (...)
€174,500
TSEA5148568
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 60 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Manilva Region: Andalucía
*** Walk Everywhere Apartment - No Car Necessary! ***
Charming apartment ideally located in the centre of San Luis de Sabinillas.
**** NOTE: This is a 1 bedroom and 1 bath apartment, however, it (...)
€590,000
TSEA5148544
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
For sale: an exclusive apartment located in one of the most sought-after residential areas of Nueva Alcántara, San Pedro de Alcántara. This property stands out for its spacious layout, prime (...)
€459,000
TSEA5148505
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 114 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Fuengirola Region: Andalucía
Fantastic Apartment with Sea Views on the Second Line of the Beach
In the Torreblanca area.
Spacious and bright apartment in a high-quality building of approximately 130 m2, just steps from the (...)
€238,000
TSEA5148484
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 1 M2: 60 Area: Ojen Region: Andalucía
Beds: 2 Baths: 1 M2: 60 Area: Ojen Region: Andalucía
Middle Floor Apartment, Ojén, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 60 m².
Setting : Town, Close To Schools.
Orientation : South West.
Condition : Good.
Climate Control : Air Conditioning, (...)
€743,000
TSEA5148427
- Los Alamos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 102 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 102 Area: Torremolinos Region: Andalucía
Looking to live by the sea in a prime location?
Close proximity to parks, schools, supermarkets, restaurants, and bars.
Easy access to the highway, with quick connections along the coast.
Just a (...)
€344,900
TSEA5148319
- Torre del Mar, Costa Del Sol East
Beds: 3 Baths: 2 M2: 96 Lot Size: 96 Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Lot Size: 96 Region: Andalucía
This modern apartment in the center of Torre del Mar combines comfort, brightness, and an unbeatable location. The property offers 3 bedrooms, one of them currently used as a laundry room, adding (...)
€630,000
TSEA5148316
- Torre del Mar, Costa Del Sol East
Beds: 3 Baths: 3 M2: 267 Lot Size: 320 Region: Andalucía
Beds: 3 Baths: 3 M2: 267 Lot Size: 320 Region: Andalucía
Beautiful, renovated semi-detached house in the quiet residential area of Viña Malaga. The three-storey house has two entrances. It is divided into 3 bedrooms, 3 bathrooms, a guest toilet, 2 (...)
Current Featured Properties
€369,000
TSEA4282294
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
YOU COULD NOT ASK FOR A BETTER LOCATION!!
Exclusive multi-family homes of 2 and 3 bedrooms located in the privileged surroundings of the Golden Mile of Estepona. The homes enjoy large terraces (...)
€381,000
TSEA4436188
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 97 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Malaga Region: Andalucía
New luxury development in the heart of Málaga. As a special recipient of this email, you have the unique opportunity to be among the first to secure your place in this exciting community.
This (...)
€2,250,000
TSEA4943188
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 142 Lot Size: 186 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 142 Lot Size: 186 Area: Malaga Region: Andalucía
This residential complex is where the contemporary and the traditional come together. For this reason, we will find renovated buildings, alongside newly built buildings or buildings protected as (...)
