SELECT pm.[autoid], pm.[media_token],pm.[propertyid],pm.[lang],pm.[address_visible],pm.[allocation_license],pm.[area_build],pm.[area_buildable],pm.[area_ground],pm.[available],pm.[bedrooms],pm.[box], pm.[building_license],pm.[building_name],pm.[building_type],pm.[building_typevalue],pm.[buyer],pm.[category],pm.[certificate_as_built],pm.[certificate_electricity],pm.[certificate_epc],pm.[city],pm.[cityvalue],pm.[comment_address],pm.[comment_area],pm.[comment_ki],pm.[comment_price],pm.[community_tax],pm.[condition],pm.[conditionvalue],pm.[construction_value],pm.[construction_year],pm.[country],pm.[countryvalue],pm.[currency],pm.[date_changed],pm.[date_changed_fortissimmo],pm.[date_created],pm.[date_created_fortissimmo],pm.[date_price_changed],pm.[date_publication],pm.[date_sold],pm.[depth_ground],pm.[depth_house],pm.[description],pm.[direction_garden],pm.[direction_gardenvalue],pm.[district],pm.[district_value],pm.[elevator],pm.[epc_value],pm.[floor],pm.[floor_number],pm.[furniture], pm.[ground_value], pm.[headtype], pm.[headtypevalue], pm.[indexed_ki], pm.[introducer], pm.[investment], pm.[key], pm.[ki_name], pm.[latitude], pm.[longitude], pm.[miscellaneous_charges], pm.[monthly_cost], pm.[new_building], pm.[non_indexed_ki], pm.[notary], pm.[notary_buyer], pm.[notary_document], pm.[number], pm.[office], pm.[owner], pm.[pets_allowed], pm.[presale_right], pm.[price], pm.[price_class], pm.[price_visible], pm.[project], pm.[publicity], pm.[reason], pm.[ref_parent], pm.[reference], pm.[regions], pm.[registration_cost], pm.[renovation_year], pm.[rentable_guarantee], pm.[renter], pm.[responsible_sales_rep], pm.[state], pm.[statevalue], pm.[street], pm.[syndicus], pm.[tax], pm.[title], pm.[town_planning], pm.[town_planning_violation], pm.[town_planningvalue], pm.[transaction], pm.[transactionvalue], pm.[type], pm.[typevalue], pm.[width_ground], pm.[width_house], pm.[zip], pm.[k_level], pm.[e_level], pm.[EPC_Reference], pm.[EPB_Reference], pm.[EPC_Date], [EPC_Date_Expire], pm.[Co2], pm.[floors_total], pm.[price_total], pm.[clicks], pm.[o_level_sensitivity], pm.[o_level_zone], pm.[SortID], pm.[infrastructure_value], pm.[furniture_value], pm.[notary_document_salary], pm.[notary_document_cost], pm.[registration_percent],pm.[heritage_protected],pm.[heritage_inventoried],pm.[taxes_percent],pm.[price_square_meter],pm.[certificate_electricity_conform], propcount.nrunits FROM tblProperty_Management pm CROSS APPLY(select count(propertyid) as nrunits FROM tblProperty_Management WHERE lang = 'EN' and ref_parent = pm.propertyid and media_token= pm.media_token ) propcount WHERE pm.media_token='FXLIQIPHRSOGNQYKPNRTGLTDMIPGSPHYYUGOOELWJCNGWLUZJU' AND pm.lang='EN' and pm.project = 1 and pm.[transaction] IN (1,2)
34
Terrazas del Duque (15)
Benimar (1)
Villas del Duque (6)
Los Balandros (6)
San Remo (6)
Club del Mar (1)
Bellamar (5)
Residencial El Duque (2)
Oasis de la Caleta
Paraíso del Palm-Mar (8)
Terrazas del Faro (5)
Baobab Suites (18)
Sunset Golf Villas (3)
Anayet
Balcon del Duque
Altamira (2)
The Terraces of Abama (3)
Magnolia Golf Resort (3)
Bahia la Caleta
Abama Belle Vue
Las Casas del Lago (1)
Riviera Resort
Villa16 (2)
Laderas del Palm mar (6)
Las Olas (8)
Cape Salema (1)
El Mocan (3)
Insigne (2)
Adeje Park
Sybaris (1)
Arcadias (5)
Villas del Tenis (2)
Plaza Abama (1)
Green South Villas