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
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
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
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1641 - 1660 of 7575 €1,250,000
TSEA5111329
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 163 Lot Size: 1,342 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 163 Lot Size: 1,342 Area: Benalmadena Region: Andalucía
Investor Opportunity – Prime Plot with Villa for Redevelopment in Benalmádena. This detached 3-bedroom, 2-bathroom villa offers a total built area of 238 m² and sits on a generous 1,342 m² (...)
€215,000
TSEA5111320
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 41 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 41 Area: Mijas and Mijas Costa Region: Andalucía
Investment Opportunity – Bright Apartment with Sea View and Afternoon Sun in Sought-After Riviera del Sol!
Welcome to this charming and well-planned home with stunning views of the Mediterranean (...)
€485,000
TSEA5111299
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 217 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 217 Area: Estepona Region: Andalucía
New Listing – 3-Bedroom Middle Floor Apartment in Las Olas, La Gaspara, Estepona
We are delighted to present another high-quality property in the desirable Las Olas urbanization in La Gaspara, (...)
€446,000
TSEA5111278
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 85 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Marbella East Region: Andalucía
Beautiful and comfortable apartment located in the Urbanization Hacienda San Manuel, on the first floor and with two elevators, facing south and close to Mercadona and Lydl, as well as a nursery, (...)
€330,000
TSEA5111269
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 2 M2: 92 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Alhaurin el Grande Region: Andalucía
Fantastic corner penthouse apartment with 3 balconies for sale in Las Brisas, Alhaurín Golf, Alhaurín el Grande.
Magnificent penthouse with superb views accessed by a lift or stairs. You enter (...)
€599,000
TSEA5111263
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 233 Lot Size: 20 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 233 Lot Size: 20 Area: Marbella West Region: Andalucía
SEMI-DETACHED VILLA IN NUEVA ANDALUCÍA – PRIME LOCATION NEAR PUERTO BANÚS
Discover this elegant 4-bedroom, 5-bathroom semi-detached villa, ideally situated in one of Marbella's most sought-after (...)
€375,000
TSEA5111128
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 115 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Marbella West Region: Andalucía
New to the market, 2-bedroom apartment in the heart of Nueva Andalucía, offering the perfect blend of comfort, convenience, and luxury. Ideally situated within walking distance to all amenities, (...)
€535,000
TSEA5111014
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 148 Lot Size: 148 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 148 Lot Size: 148 Area: Marbella East Region: Andalucía
This elegant three-bedroom apartment with 2 private parkings is situated in the sought-after area of La Mairena, Marbella East, offering a harmonious blend of comfort, style, and convenience. The (...)
€560,000
TSEA5110996
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 225 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 225 Area: Mijas and Mijas Costa Region: Andalucía
Stylish south east facing, three-bedroom semi detached townhouse located in Riviera del Sol. This property offers bright and spacious interiors filled with natural light and high ceilings. The (...)
€3,450,000
TSEA5110936
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 360 Lot Size: 1,003 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 360 Lot Size: 1,003 Area: Marbella West Region: Andalucía
Stunning villa for sale in the sought-after area of Nueva Andalucía Supermanzana H, offering an ideal combination of modern design, refined comfort, and a family-friendly atmosphere. This (...)
€790,000
TSEA5110927
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 154 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 154 Area: Marbella West Region: Andalucía
This beautifully presented townhouse, nestled in the heart of the sought-after Aloha Pueblo, offers the perfect blend of traditional Andalucian charm and modern comfort. Set across two levels with (...)
€1,595,000
TSEA5110864
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 5 M2: 503 Lot Size: 1,098 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 5 M2: 503 Lot Size: 1,098 Area: Mijas and Mijas Costa Region: Andalucía
Nestled in the exclusive and sought-after neighbourhood of Sierrezuela, just minutes from the heart of Fuengirola and its golden beaches, this beautifully appointed 6-bedroom, 5-bathroom villa is the (...)
€895,000
TSEA5110861
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M2: 338 Area: Casares Region: Andalucía
Beds: 4 Baths: 4 M2: 338 Area: Casares Region: Andalucía
Casares del Mar is located on the coast of Casares, just by the beach. The location is fantastic with a spectacular, unobstructed front line sea views and with private access to the beach.
This (...)
€575,000
TSEA5110855
- Los Flamingos, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 139 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Estepona Region: Andalucía
Discover your new home! This spectacular apartment for sale offers incredible panoramic views that will leave you breathless.
With a large terrace where you can enjoy unforgettable moments (...)
€485,000
TSEA5110846
- Riogordo, Costa Del Sol East
Beds: 3 Baths: 2 M2: 177 Lot Size: 2,243 Region: Andalucía
Beds: 3 Baths: 2 M2: 177 Lot Size: 2,243 Region: Andalucía
Charming Country Home with Independent Apartment, Stunning Gardens & Excellent Access — Riogordo (Málaga, Andalusia)
We are delighted to present this beautifully maintained country estate near (...)
€260,000
TSEA5110831
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Cozy Apartment with Sunny Southeast-Facing Terrace – Miraflores Golf Club
Charming and bright, this apartment features 2 spacious bedrooms, 2 modern bathrooms, and an independent fully-equipped (...)
€968,000
TSEA5110828
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 180 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: Benalmadena Region: Andalucía
Penthouse Duplex, Benalmadena, Costa del Sol.
3 Bedrooms, 3 Bathrooms, Built 180 m².
Setting : Close To Golf, Close To Shops, Close To Sea, Close To Town, Urbanisation.
Orientation : (...)
€1,150,000
TSEA5110819
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 120 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 120 Area: Benahavis Region: Andalucía
Luxurious Penthouse in Marbella Club Hills
Welcome to your new dream home, an unparalleled penthouse with 3 bedrooms and 3 bathrooms, located in the prestigious Marbella Club Hills. This exceptional (...)
€7,500,000
TSEA5110816
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 353 Lot Size: 1,036 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 353 Lot Size: 1,036 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular beachfront villa with panoramic views of the Mediterranean and direct access to the beach.
Recently completely renovated with a modern style, the villa is distributed over 2 spacious (...)
€466,620
TSEA5110804
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 88 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 88 Area: Marbella Region: Andalucía
We offers UNIQUE OPPORTUNITY IN THE HEART OF MARBELLA!
HIGHLIGHTS:
� Located in the very center of Marbella, just 200 meters from the beach.
* It has garage and terrace of 30 meters.
Discover (...)
Current Featured Properties
€1,060,000
TSEA5063608
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 201 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 201 Area: Benalmadena Region: Andalucía
An exclusive boutique complex of 28 apartments in the highly sought-after area of Torremuelle, Benalmádena. Each residence has been carefully designed to offer a superior living experience, with (...)
€1,149,000
TSEA4958080
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
LIGHT FLOODS INTO THE PROPERTY!!!
We will change weight for square meters, color for avant-garde architectural design, clarity for light and size for the best qualities and certified construction (...)
€444,000
TSEA4324165
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
LOCATED IN BEAUTIFUL ESTEPONA!!!
One of the most attractive corners of the Costa del Sol. The town has become one of the most sought-after spots on the Costa del Sol, thanks to its quality of life (...)
