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 (40,36,37,38)
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 (40,36,37,38)
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 (40,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 141 - 160 of 1780
€495,000
TSEA5147467
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 81 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 81 Area: Fuengirola Region: Andalucía
???? Apartment for Sale – Paseo Marítimo, Fuengirola
Stunning fourth-floor apartment located on the beachfront, facing south with direct sea views.
The property features 2 bedrooms with built-in (...)
€345,000
TSEA5147416
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Charming two bedroom, two bathroom first floor apartment in quiet residential area close to golf, restaurants, shops and schools.
This south facing apartment is in fantastic condition and has (...)
€345,000
TSEA5147392
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Middle Floor Apartment, Selwo, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 132 m², Terrace 20 m².
Setting : Urbanisation.
Orientation : South West.
Condition : Excellent.
Pool : (...)
€775,000
TSEA5147380
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 127 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: San Pedro Region: Andalucía
Brand-new apartment in MARE Urbanización, San Pedro Alcántara
Discover this modern 3-bedroom, 2-bathroom apartment with 103 m² of interior space and a 30 m² sunny terrace, perfect for enjoying (...)
€295,000
TSEA5147170
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 77 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: La Duquesa Region: Andalucía
For sale, South East facing middle floor apartment in an established gated community within Los Hidalgos area of La Duquesa, Manilva Costa del Sol, located just 5 minutes from the beach.
This (...)
€649,000
TSEA5147071
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 103 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Estepona Region: Andalucía
Located in the prestigious Hacienda Señorio de Cifuentes, this stunning apartment offers the perfect balance between luxury, comfort, and nature. Surrounded by renowned golf courses and boasting (...)
€180,000
TSEA5147068
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 50 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Area: Mijas and Mijas Costa Region: Andalucía
Investment Opportunity Just 200 Meters from the Beach!
Beautiful renovated apartment for sale, ideal as a vacation rental or second home. Located in a quiet area with stunning sea views, this bright (...)
€460,000
TSEA5146993
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Nestled in the heart of Marbella's prestigious Golden Mile, this elegant ground floor apartment offers the perfect combination of modern comfort and Mediterranean charm. Just five minutes from the (...)
€679,000
TSEA5146972
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 141 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 141 Area: Fuengirola Region: Andalucía
Discover a unique opportunity to live in one of Fuengirola's most sought-after residential complexes with this spacious 4-bedroom first-floor apartment, fully furnished and ready to move in. Its (...)
€397,000
TSEA5146948
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 136 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 136 Area: Estepona Region: Andalucía
Wonderful apartment in El Paraíso Barronal
Your new home awaits you in a privileged location, right on the beach, just a three-minute walk from the sea.
The apartment is located in a beautiful (...)
€315,000
TSEA5146837
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 94 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Fuengirola Region: Andalucía
Charming Renovated Apartment in the Best Area of Torreblanca – Fuengirola
This beautiful apartment, located on the third floor with elevator, has been recently renovated with a romantic and cozy (...)
€333,000
TSEA5146729
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 79 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 79 Area: Estepona Region: Andalucía
Prime Frontline Beach Apartment on Estepona's Serene Playa de Guadalobón
Idyllic Beachfront Location: Positioned directly on Playa de Guadalobón, Estepona's tranquil western beach known for its (...)
€623,000
TSEA5146630
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 166 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 166 Area: Marbella East Region: Andalucía
Spectacular corner apartment a highly sought-after area of La Mairena, 3 spacious bedrooms, with east-west orientation and panoramic views of the sea and Mountains. photovoltaic energy. Gated (...)
€765,000
TSEA5146108
- Málaga Centro, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 137 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Malaga Region: Andalucía
Middle Floor Apartment, Málaga Historic Centre Soho, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 137 m².
Setting : Town, Close To Port, Close To Sea.
Condition : Excellent, Recently (...)
€330,000
TSEA5146021
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 142 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 142 Area: Mijas and Mijas Costa Region: Andalucía
Discover this spectacular apartment located in the idyllic destination of Mijas Golf, famous for its stunning views and high-quality golf courses.
The property features three spacious bedrooms (...)
€350,000
TSEA5145991
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 92 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Estepona Region: Andalucía
GREAT OPPORTUNITY IN ESTEPONA – BEL-AIR AREA
Spacious 2-bedroom apartment with large terraces in a gated community with pool, surrounded by all amenities and just minutes from the beach.
Looking (...)
€268,000
TSEA5145979
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 62 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 62 Area: Marbella Region: Andalucía
Discover your new home in the heart of Marbella! ✨
This charming apartment of 71 m² is located on the fourth floor of a building with an elevator, offering both comfort and accessibility. In (...)
€180,000
TSEA5145976
- Guaro, Costa Del Sol, Guaro
Beds: 2 Baths: 2 M2: 77 Area: Guaro Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Guaro Region: Andalucía
Middle Floor Apartment, Guaro, Inland Malaga
2 Bedrooms, 2 Bathrooms, Built 77 m².
Magnificent two-bedroom, two-bathroom apartment for sale, one en suite.
Like new. Fully furnished. Built-in (...)
€510,000
TSEA5145946
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 70 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Marbella Region: Andalucía
Unique Opportunity on Marbella's Seafront Promenade!
We are pleased to present this charming apartment located right on Marbella's Paseo Marítimo, within one of the most sought-after beachfront (...)
€645,000
TSEA5145910
- Malagueta, Costa Del Sol
Beds: 3 Baths: 1 M2: 303 Region: Andalucía
Beds: 3 Baths: 1 M2: 303 Region: Andalucía
OPPORTUNITY!! MAGNIFICENT MIXED-USE HOME 2 MINUTES FROM THE BEACH
The exclusively present this spectacular home, located in a prime location just a two-minute walk from the beach. It's just a (...)
Current Featured Properties
€489,950
TSEA4450030
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 100 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 (...)
€364,000
TSEA4895617
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 84 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 84 Area: Mijas and Mijas Costa Region: Andalucía
This is an impressive new development located in Calanova Golf, Mijas Costa, Malaga. This luxury project, with the exclusivity of being the only agency offering it, offers a variety of housing (...)
€860,000
TSEA4749715
- La Quinta, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 101 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Benahavis Region: Andalucía
AMAZING VIEWS FROM THE SOLARIUM! This 2-bed, 2-bath penthouse apartment sits in a BRAND NEW, EXCLUSIVE LUXURY DEVELOPMENT in a prestigious mountainside estate of low level apartments with manicured, (...)
