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 (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
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.approved = 1 AND pm.cat_id IN (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
GROUP BY p.id
ORDER BY p.created DESC
Results 461 - 480 of 7575
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 (...)
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 (...)
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 (...)
TSEA5145973
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 303 Lot Size: 1,149 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 303 Lot Size: 1,149 Area: Benalmadena Region: Andalucía
SPECTACULAR AND MODERN VILLA WITH SEA VIEWS
We are delighted to present this very special villa with its unique, modernist-inspired design, located in one of the most privileged and growing areas of (...)
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 (...)
TSEA5145928
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 106 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Marbella East Region: Andalucía
Beautiful duplex Penthouse centrally located in Elviria, in the complex Parque Elviria. It needs some renovations but has great potential due to its proximity to the beach, shops, restaurants, etc., (...)
TSEA5145922
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Beautiful flat located in the Pino Golf community in Elviria. Spacious ground floor flat facing west, overlooking the communal gardens and swimming pool.
It has two bedrooms, one of which is en (...)
TSEA5145916
- Bel Air, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
A stunning duplex penthouse offering an abundance of space, natural light, and privacy. Impeccably maintained, this home combines modern comfort with elegant design, creating an inviting and serene (...)
TSEA5145913
- El Paraiso, Costa Del Sol, Estepona
Beds: 6 Baths: 5 M2: 458 Lot Size: 1,271 Area: Estepona Region: Andalucía
Beds: 6 Baths: 5 M2: 458 Lot Size: 1,271 Area: Estepona Region: Andalucía
Discover a fantastic opportunity to create your dream home in the sought-after area of El Paraiso, Estepona. This spacious 6-bedroom, 5-bathroom villa is ready for a complete reform and is perfectly (...)
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 (...)
TSEA5145895
- Hacienda Las Chapas, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 456 Lot Size: 1,664 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 456 Lot Size: 1,664 Area: Marbella East Region: Andalucía
FOR INVESTORS!
VILLA WITH SEA VIEWS & RENOVATION POTENTIAL IN HACIENDA LAS CHAPAS.
Located in the prestigious gated community of Hacienda Las Chapas, this villa presents an excellent investment (...)
TSEA5145856
- Valtocado, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 112 Lot Size: 3,533 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Lot Size: 3,533 Area: Mijas and Mijas Costa Region: Andalucía
For Sale – Authentic Andalusian Finca with Sea Views, Private Pool, Casita & Wellness Features in Mijas
Perched in the hills above the Costa del Sol, this exquisite Andalusian finca offers the (...)
TSEA5145838
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 2 M2: 98 Area: Coin Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Coin Region: Andalucía
Stylishly renovated Townhouse in the heart of Coín village.
This beautifully renovated townhouse combines modern style with traditional charm, offering a high-quality finish throughout. Perfectly (...)
TSEA5145832
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 327 Lot Size: 1,005 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 327 Lot Size: 1,005 Area: Mijas and Mijas Costa Region: Andalucía
Set in the peaceful surroundings of Mijas Golf, this frontline golf villa offers a blend of privacy, comfort, and Mediterranean charm. With a 1,005 m² plot and 327 m² built, the property is (...)
TSEA5145820
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Modern duplex apartment in Puerto Banús with stunning sea views, just steps from the beach, restaurants, luxury boutiques, and all amenities. Featuring two bedrooms (one en-suite), two (...)
TSEA5145808
- La Línea, Costa Del Sol, San Roque
Beds: 3 Baths: 2 M2: 150 Area: San Roque Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: San Roque Region: Andalucía
Incredible 3-Bedroom Chalet for Sale in Venta Melchor with Views of Gibraltar
This magnificent home has been designed to make the most of natural light, allowing it to flow through every room and (...)
TSEA5145799
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
A lovely elevated ground floor apartment in the exclusive area of Selwo, Estepona.
Enjoy the stunning views across the sea to Africa from your covered terrace, or have a cooling dip in the communal (...)
TSEA5145790
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 68 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 68 Area: Mijas and Mijas Costa Region: Andalucía
Unique Opportunity in Lower Riviera del Sol – Ground Floor Corner Apartment
Don't miss the chance to own this charming south-west facing ground floor corner apartment in the highly sought-after (...)
TSEA5145751
- Campanillas, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 113 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Marbella Region: Andalucía
We present an innovative residential project that redefines the concept of living in Malaga. The development features a variety of homes, from one-bedroom apartments to four-bedroom penthouses, all (...)
TSEA5145739
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 240 Lot Size: 500 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 240 Lot Size: 500 Area: Fuengirola Region: Andalucía
This exclusive luxury villa, combines modern architecture with top-quality construction and a carefully designed layout. The home is filled with natural light thanks to large floor-to-ceiling windows (...)
