ENGLISH SPOKEN ESTATE AGENT IN TENERIFE

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