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 (70,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 (70,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 (70,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 81 - 100 of 677 €235,000
TSEA5135368
- San Enrique, Costa Del Sol, Sotogrande
Beds: 2 Baths: 1 M2: 109 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 1 M2: 109 Area: Sotogrande Region: Andalucía
Single-story home. It has 109 m² of built area and a 100 m² outdoor patio, with a garage.
Fully furnished kitchen, appliances such as a refrigerator, washing machine, gas stove, and hot water (...)
€545,000
TSEA5134963
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 4 M2: 242 Lot Size: 30 Area: Manilva Region: Andalucía
Beds: 4 Baths: 4 M2: 242 Lot Size: 30 Area: Manilva Region: Andalucía
Unique Townhouse with Stunning Panoramic Sea Views.
This bright property is spread over four levels.
Ground Floor
A spacious living/dining area, a large fully fitted kitchen, a guest toilet, and two (...)
€540,000
TSEA5134789
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 177 Lot Size: 41 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 177 Lot Size: 41 Area: Fuengirola Region: Andalucía
This exceptional large corner townhouse offers space, comfort, and versatility for the entire family.
On the lower level, you'll find a generous 52 m² entertainment room, ideal for conversion into (...)
€475,000
TSEA5134435
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Discover this bright and welcoming semi-detached townhouse featuring:
Accommodations: 3 spacious bedrooms, 2 full bathrooms, and an additional guest toilet.
Orientation & Views: South-facing (...)
€425,000
TSEA5134426
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 5 Baths: 3 M2: 143 Lot Size: 168 Area: Nerja and Malaga East Region: Andalucía
Beds: 5 Baths: 3 M2: 143 Lot Size: 168 Area: Nerja and Malaga East Region: Andalucía
Property with apartment and premises in the center of Nerja, an exceptional investment opportunity.
This is a golden opportunity to acquire a two-story property in the center of Nerja,
where you (...)
€2,790,000
TSEA5134270
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 383 Lot Size: 765 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 383 Lot Size: 765 Area: Estepona Region: Andalucía
Located in the exclusive and secure community of Resina Golf in Estepona, this fully renovated villa offers an exceptional standard of luxury living. With meticulous attention to detail and high-end (...)
€850,000
TSEA5133667
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 180 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 180 Area: Estepona Region: Andalucía
This is a rare opportunity to own a beautifully renovated townhouse in one most desirable beachfront communities if Estepona West area — Bermuda Beach. Offering direct access to a peaceful, (...)
€650,000
TSEA5133313
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 100 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 100 Area: San Pedro Region: Andalucía
This three-bedroom townhouse in Guadalmina Pueblo is one of those rare finds you don't come across often — especially in such a prime Marbella location. It does need a full renovation, but that's (...)
€580,000
TSEA5133244
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 483 Lot Size: 1,550 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 483 Lot Size: 1,550 Area: Mijas and Mijas Costa Region: Andalucía
Independent Villa in the Urbanización Pinos de Alhaurín.
REDUCED!!!!!!!!
Owner open to offers.
Málaga Home Sales sells, EXCLUSIVELY, excellent independent villa with a large garden, and lots of (...)
€349,000
TSEA5133154
- Diana Park, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
Townhouse to Renovate in Nueva Atalaya – Excellent Investment Opportunity
Type: Townhouse
Condition: To renovate
Built area: 109 m²
Bedrooms: 3
Bathrooms: 2
Terrace / Porch: Yes
Location: Nueva (...)
€540,000
TSEA5132767
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 240 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 240 Area: Benahavis Region: Andalucía
This beautifully appointed town house is situated in the desirable Paraiso Park, Benahavis, Malaga. Offering a harmonious blend of comfort and convenience, the property boasts three spacious bedrooms (...)
€799,000
TSEA5132674
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 285 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 285 Area: Benahavis Region: Andalucía
Situated in the exclusive, frontline golf complex of Las Encinas in La Quinta, Benahavís, this beautifully renovated three-level townhouse combines modern elegance with breathtaking views of the La (...)
€1,050,000
TSEA5131978
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Prestigious 3-Level Townhouse in the Luxury EDEN Complex – La Cala de Mijas, Just Steps from the Sea
An exceptional townhouse in one of the most prestigious developments in La Cala de Mijas – (...)
€865,000
TSEA5131813
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 538 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 538 Area: Benahavis Region: Andalucía
This elegant townhouse is tucked away in the serene and exclusive gated community of Los Almendros, part of the renowned Los Arqueros Golf community. Boasting three floors of versatile living space, (...)
€995,000
TSEA5131651
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 235 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 235 Area: Benahavis Region: Andalucía
Spacious 4-Bedroom Townhouse with Spectacular Sea Views in the exclusive gated development of La Quinta Hills, Benahavis
Welcome to this exceptionally large and partially reformed townhouse boasting (...)
€525,000
TSEA5131234
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 268 Lot Size: 250 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 268 Lot Size: 250 Area: Mijas and Mijas Costa Region: Andalucía
This semi-detached house has a charming and functional design, ideal for a family looking for comfort and privacy. Large double glazed aluminum windows, with mirrored glass.
Its distribution offers (...)
€259,000
TSEA5131009
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 2 M2: 105 Lot Size: 62 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Lot Size: 62 Area: Alhaurin el Grande Region: Andalucía
Alhaurin el Grande is a fabulous location for anyone wanting to enjoy outdoor country living. Only 25 minutes away from the beaches and Malaga or Marbella center. The charming pueblo offers more less (...)
€519,000
TSEA5130940
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 129 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 129 Area: Marbella West Region: Andalucía
This charming townhouse is situated in the well-maintained urbanization of Sol Europa Golf, conveniently located near the well-known and highly popular Los Naranjos Golf Course in Nueva Andalucía, (...)
€449,000
TSEA5130934
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 84 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 84 Area: Fuengirola Region: Andalucía
Located in the prestigious Pueblo López urbanization, this property offers an unbeatable location right in the center of Fuengirola, just steps from the Town Hall, shopping areas, schools, and all (...)
€389,000
TSEA5130523
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 100 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 100 Area: Estepona Region: Andalucía
Cosy townhouse 3bed 3bath in Estepona, near Laguna Village.
Townhouse has a private garden, solarium, terrace. Urbanisation has a communal pool.
Facing: South and West
Current Featured Properties
€950,000
TSEA4430956
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 240 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 240 Area: Estepona Region: Andalucía
Exceptional very spacious townhouse located in frontline beach residential complex Belgravia club, Estepona.
This spectacular home has fantastic sea views and the location is unbeatable, just a few (...)
€465,000
TSEA4292032
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
LARGE GARDEN, AMAZING VIEWS AND GYM!!!
In an incomparable enclave with magnificent views, a project of 40 semi-detached and semi-detached houses with 3 and 4 bedrooms with large terraces to enjoy (...)
€570,000
TSEA4975855
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
LA PERLA DE LA HEREDIA , BENAHAVIS.
This charming townhouse is located in the cozy village of La Perla de la Heredia, just off Ronda Road. It faces south to southwest, offering lovely views of the (...)
