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 (61,68,69,70)
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 (61,68,69,70)
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 (61,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 281 - 300 of 757 €679,000
TSEA5061979
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 156 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 156 Area: Marbella West Region: Andalucía
Beautiful townhouse in frontline golf urbanization; it consists of several swimming pools and large landscaped areas. It is a closed and very careful community. Renovated Porches, Solarium , (...)
€650,000
TSEA5061826
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 160 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Estepona Region: Andalucía
Modern townhouse with panoramic sea views in Cancelada, Estepona
Exclusive location in the Oceana View urbanization .
Newly built townhouse located in the Oceana View urbanization, in Cancelada, (...)
€70,000
TSEA5061805
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 1 M2: 91 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 1 M2: 91 Area: Alhaurin el Grande Region: Andalucía
PROPERTY SOLD WITH LEGAL OWNERSHIP BUT NO RIGHT TO OCCUPY YET
Sold with USUFRUCT rights which is reflected in the price. You will be the Legal Owner, But Not Yet in Control. Great opportunity for (...)
€285,000
TSEA5061124
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
OPPORTUNITY! 4-bedroom house in Mijas Pueblo
Fantastic typical village house located a few meters from the center of Mijas, on a pedestrian street which provides comfort and security and distributed (...)
€380,000
TSEA5061115
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 4 M2: 216 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 4 M2: 216 Area: Alhaurin el Grande Region: Andalucía
Spacious 3-Bedroom Townhouse with Breathtaking Views – Alhaurín el Grande
Discover this beautifully presented three-bedroom, three-bathroom townhouse set in a tranquil and picturesque location in (...)
€795,000
TSEA5060986
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 110 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 110 Area: Marbella West Region: Andalucía
Elegant 3-Bedroom Townhouse with Golf & Mountain Views in Gated Nueva Andalucía Community
Situated in a secure gated community in the heart of Nueva Andalucía, this fully renovated 3-bedroom, (...)
€550,000
TSEA5060902
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 4 Baths: 3 M2: 159 Lot Size: 50 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 3 M2: 159 Lot Size: 50 Area: Algeciras Region: Andalucía
WONDERFUL TOWNHOUSE WITH SEA VIEWS, LA ALCAIDESA
Discover this beautiful townhouse located in an exclusive gated community in La Alcaidesa, with 24-hour security. Perfect both as a permanent (...)
€249,000
TSEA5060899
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 57 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 57 Area: Estepona Region: Andalucía
Charming townhouse in the heart of Estepona old town built in 1946.
On the lower level there is a kitchen / diner, on the first floor we have a lounge / or bedroom with a toilet, shower and sink (...)
€475,000
TSEA5059090
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 204 Lot Size: 150 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 204 Lot Size: 150 Area: Mijas and Mijas Costa Region: Andalucía
Nice townhouse on a great location with a lot of potential. You enter on the ground floor level. Here we have a semi open kitchen, living room that leads out to the sunny terrace overlooking the lush (...)
€925,000
TSEA5058775
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 4 M2: 296 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 4 M2: 296 Area: Mijas and Mijas Costa Region: Andalucía
Unique Triple-Townhouse Conversion on Mijas La Nueva – Versatile Living with Private Terraces and great views
Prime Location | 6 Bedrooms | 4 Bathrooms | Large Terrace | Dual-Level Living
Welcome (...)
€210,000
TSEA5058673
- Cómpeta, Costa Del Sol East
Beds: 7 Baths: 1 M2: 210 Region: Andalucía
Beds: 7 Baths: 1 M2: 210 Region: Andalucía
For Sale: Historic Business & Residential Property in Prime Cómpeta Location – Full Renovation Required
A rare opportunity to acquire a prominent historic townhouse in one of Cómpeta's best (...)
€195,000
TSEA5058370
- Coín, Costa Del Sol, Coin
Beds: 2 Baths: 2 M2: 133 Area: Coin Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Coin Region: Andalucía
Townhouse, Coín, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 133 m², Terrace 40 m².
Don't let it go without seeing it?
The best opportunity for investors, first-time buyers, and retirees to (...)
€299,000
TSEA5058187
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 110 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Manilva Region: Andalucía
***South Facing with Stunning Views*** This beautifully presented south-facing townhouse in the established urbanisation of Doña Pilar, Manilva, offers stunning sea and countryside views just five (...)
€205,000
TSEA5058103
- Puente Mayorga, Costa de la Luz
Beds: 3 Baths: 2 M2: 152 Region: Andalucía
Beds: 3 Baths: 2 M2: 152 Region: Andalucía
"Charming Semi-Detached Home with Stunning Roof Terrace & Sea Views – Steps from the Beach!
Discover this beautifully renovated semi-detached home in Puente Mayorga, offering spacious (...)
€490,000
TSEA5057005
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 193 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 193 Area: Mijas and Mijas Costa Region: Andalucía
This spacious townhouse, spread over three floors, offers the perfect combination of comfort, space, and natural surroundings. Ideal both as a permanent residence for families and as a second home (...)
€995,000
TSEA5056648
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 257 Lot Size: 315 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 257 Lot Size: 315 Area: Marbella West Region: Andalucía
A large townhouse located in the popular urbanisation of La Niña, Aloha Golf. The entrance has a nice feeling of privacy, almost like a villa that takes you to the hall of the property. From here (...)
€1,875,000
TSEA5056531
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 263 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 263 Area: Benahavis Region: Andalucía
An exquisitely totally reformed townhouse located in the popular urbansiation of El Mirador de La Quinta in Benahavis. As you enter the property, you are greeted with an abundance of light, high (...)
€385,000
TSEA5056510
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 200 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 200 Area: Estepona Region: Andalucía
Magnificent semi-detached house in Estepona in the Selwo area, Alpandeire street
The house has three floors:
Ground floor: toilet, living room with fireplace and with two heights, large kitchen and a (...)
€699,900
TSEA5055943
- Nagüeles, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 210 Lot Size: 40 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 210 Lot Size: 40 Area: Marbella Region: Andalucía
Terraced Home with Private Lift, Rooftop Solarium & 2-Car Garage – Prime Marbella Location
Nestled in one of Marbella's most prestigious and sought-after areas, this rare semi-detached home (...)
€1,475,000
TSEA5055829
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 348 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 348 Area: Estepona Region: Andalucía
4-Bedroom Townhouse in Prestigious Urbanisation Villas de Costalita in Estepona
Located near Saladillo Beach and just 15 minutes from Puerto Banús, 10 minutes from Estepona center and 20 minutes (...)
Current Featured Properties
€483,000
TSEA3980794
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
NESTLED BETWEEN STUNNING LANDSCAPE GARDENS!!
An exclusive development of 46 townhouses of 2, 3 and 4 bedrooms, some of them semi-detached, built in a contemporary style, in a privileged location two (...)
€653,000
TSEA4428304
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 384 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 384 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
€673,000
TSEA4107058
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
