Aribnb listings using licences issued for other businesses

Airbnb hosts seem to be getting around the new licensing requirements by using licences issued for other businesses, including licences for massage therapist, computer services and health services.

Listing IDLicenceLicence TypeRoom TypeName
44810418-587591Apartment House Strataentire_homeModern Charm in Downtown Vancouver
73289518-586073Apartment House Strataentire_homeBest Location in Downtown - Bright Beautiful 1bdr
675974418-601280Apartment House Strataentire_homeAmazing Location, Great View
2338192318-602677Apartment House Strataentire_homeLuxurious Yaletown 2 bed with gorgeous water views
2397681418-604969Apartment House Strataentire_homeStudio Condo in Olympic Village (brand new)
2397657418-604969Apartment House Strataentire_homeBrand new condo Olympic Village
2623590618-587598Apartment House Strataentire_home?Downtown w/ parking, in-suite laundry, amenities?
83833618-535826Apartment House Strataentire_home3 BEDROOM, 3 LEVEL TOWNHOUSE
129139418-549007Secondary Suite - Permanententire_homeClean New Kits 3 bedroom/ 2bath!
1978828918-439405Duplexprivate_roomKitsilano Hidden Gem
Now can sleep up to 4
2401663318-547315Non-profit Housingentire_home#319 Self-contained, double-occupancy suite
901453418-454788Multiple Dwellingprivate_roomBEAUTIFUL SHAUNGHNESSY MANSION
2259813118-550192Secondary Suite - Permanententire_homeModern Lower Level Suite on Quiet Street
1652204818-517152Secondary Suite - Permanententire_homecozy 1 bedroom suite near main street
1403862318-475851Secondary Suite - Permanententire_homeModern Family Home across from Park & Tennis Cour
2392554918-602680Apartment House Strataentire_homeFabulous One Bed w/ Coal Harbour View
2819993418-453877Massage Therapistprivate_roomAMAZING Unobstructed Ocean/Marina/Mountain Views!
2594193818-454906Multiple Dwellingentire_home??????????????
2168199918-579426One-Family Dwellingentire_homeHigh end apartment Downtown-Great Amenities!!
218811318-554147Apartment House Strataentire_home5 star Luxury ShangriLa hotel condo
1808940118-587593Apartment House Strataentire_homeStudio With Parking in the Heart of Downtown
504032018-601276Apartment House Strataentire_homeGorgeous 1-Bdr Walk Everywhere!
2048430818-609687Apartment House Strataentire_homeSpacious Studio Downtown Apartment w/Parking
2074742618-466370Residential/Commercialprivate_roomBed & Breakfast, historic house. Heart of Downtown
1998175718-602672Apartment House Strataentire_homeSpectacular modern 2 bedroom with stunning view !
2076142318-466370Residential/Commercialprivate_roomSummer B&B. Vancouver Downtown Best location!
2074694418-466370Residential/Commercialprivate_roomThe Cozy renovated Loft in Van Dowtown 3bed/1bath
2659690418-466370Residential/Commercialprivate_roomCozy room w/own washroom in Vancouver downtown
2076207818-466370Residential/Commercialprivate_roomB&B. Summer Special - Van Downtowns Heart
2338297418-449035Health Servicesentire_homeSacred Space Heritage Loft in Gastown Downtown
1887920118-586104Apartment House Strataentire_homePacific Rose Retreat - Modern condo DT Vancouver
899083518-549515Computer Servicesprivate_roomLuxury Condo at Metropolitan Towers
681264818-438653Pre-1956 Dwellingentire_homeONE BR TOP FLOOR SUITE IN HOUSE NEAR DOWNTOWN
1577120718-485830Apartment House Strataentire_home1 Bed Den Office in-suite laundry Pool Gym Hot Tub
139729118-606759Apartment House Strataprivate_roomBright bedroom in shared condo
2072694918-466370Residential/Commercialentire_homeYour ideal and cozy Guesthouse Vancouver Downtown
1807948318-611528Apartment House Strataentire_homeStylish 420 Friendly Work Remotely with Parking
1399219418-492336Multiple Dwellingentire_homeCute, cozy 2 Bedroom Garden Suite
580809418-491535Apartment House Strataentire_homeSpectacular View in Yaletown & Park
1519169518-466508Residential/Commercialentire_homeChic Fraser Street Apartment
1719589318-475073Secondary Suite - Permanententire_homeLast Minute Limited Availability 3bd/2bath
1710568518-587595Apartment House Strataentire_homeComfort & Charm, Parking, 15min to Downtown
2106639018-466370Residential/Commercialprivate_roomPromo! Charming private room in Vancouver
2318802518-466370Residential/Commercialprivate_roomBeautiful Private room - Victorian Downtown house
2265428918-608301Duplexprivate_roomVancouver on 12 & Commercial - PRIVATE BATHROOM
2282053818-608301Duplexprivate_roomVANCOUVER HOME - #3 New House - 12 & Commercial

To meaningfully protect our long term rental market from being decimated by Airbnb and other short term accommodation platforms, we must take the following steps:

  1. Introduce licence auto-verification, so, we can nip unlicensed units and licence cheats in the bud
  2. Introduce a tough new bylaw and agreements that hold platforms accountable for the hosts’ actions
  3. Make Airbnb fines lienable, so that the city can place liens against egregious violators who refuse to pay the fines

 

I believe Vancouver should take care of those who take care of our city and our citizens. I dream of a place where those who contribute to our communities are able to afford to live in the city. I’m running for city councillor to see that dream come true. Please help me by donating and volunteering to my campaign.

Airbnb violating MoU with City of Vancouver by not deactivating listings without licences

Update 6-Sep-2018:

After I published my blog post, some of the hosts have obtained licences and Airbnb has deactivated the remaining listings.

Airbnb is required to deactivate listings that don’t have a licence and keep them deactivated until such time the hosts get licences for them. But my Airbnb data scanner has picked up at least six listings that popped up today without a licence.

This is a clear violation of Section 1.3 of the Memorandum of Understanding Airbnb signed with the City, which states

1.3 For Hosts that have listed or list an STRA with Airbnb prior to April 18, 2018, Airbnb will give such Hosts until August 31, 2018 to input a STRA Licence Number. Thereafter, Airbnb will deactivate the listings of such Hosts from its platform until such time that a Host inputs a STRA Licence Number.

Airbnb is violating an MoU which is extremely favourable to the company. This just goes to show how little respect these predatory corporations have for the City of Vancouver.

To meaningfully protect our long term rental market from being decimated by Airbnb and other short term accommodation platforms, we must take the following steps:

  1. Introduce licence auto-verification, so, we can nip unlicensed units and licence cheats in the bud
  2. Introduce a tough new bylaw and agreements that hold platforms accountable for the hosts’ actions
  3. Make Airbnb fines lienable, so that the city can place liens against egregious violators who refuse to pay the fines

 

I believe Vancouver should take care of those who take care of our city and our citizens. I dream of a place where those who contribute to our communities are able to afford to live in the city. I’m running for city councillor to see that dream come true. Please help me by donating and volunteering to my campaign.

Landbanking hurting housing affordability in Vancouver

The numbered company 1161137 B. C. LTD bought 7239 Oak Street in May 2015 for $1.9M. The company held onto the land the city upzoned the neighbourhood under the Cambie Corridor Project. Once that was done, they assembled it with another nearby property, and have relisted the properties at $5.7M each.

This is just one example of landbanking, where speculators hoard large swathes of land, wait for a the city to increase density, and sell it to developers while making exhorbitant profits. Small local developers who want to build homes for working Vancouverites simply cannot afford to pay these sky high prices. The only people who can, are the likes of Westbank, Onni, Concord Pacific and Aquilini, who then build luxury condos that are meant as safety deposit boxes in the sky for the global rich.

Often the landbankers use corporations, sometimes numbered corporations, to do their landbanking. I analyzed homes that came for sale over the course of the last 12 months, and found at least 81 instances of corporations buying land and selling them within three years.

AddressOwnerList PriceList DateDate BoughtPrice BoughtYear Built
4777 2ND AVE W VANCOUVERJoyful Holdings Ltd$18,880,00012/03/201812/12/2017$14,128,0001930
1880 MARINE DR SW VANCOUVERGLASENBRIDGE INVESTMENTS LTD$14,800,00008/01/201808/03/2015$8,890,0002003
7843 CAMBIE ST VANCOUVERWDG INVESTMENT LTD.$12,000,00031/01/201821/06/2017$7,238,0001959
5676 ASH ST VANCOUVERCEETU ASH 5676 DEVELOPMENT (BT) LTD$10,000,00018/06/201803/02/2017$5,400,0001953
5530 BAILLIE ST VANCOUVERCeetu 5530 Baillie Development (BT) Ltd.$7,500,00019/06/201808/05/2017$5,000,0001961
1188 57TH AVE W VANCOUVER1188 ENTERPRISES LTD.$6,980,00028/08/201802/03/2016$3,760,0002008
1685 NELSON ST VANCOUVER1685 NELSON STREET HOLDINGS INC.$6,788,00016/02/201815/06/2017$4,280,0001905
506 63RD AVE W VANCOUVER1163755 BC LTD$6,298,00001/06/201805/02/2016$2,838,0001992
6388 MARGUERITE ST VANCOUVERGOLDEN MUSTANG HOLDING CORP.$6,158,00011/06/201821/05/2015$4,330,0001926
5909 ATHLONE ST VANCOUVERALIIA DEVELOPMENTS LTD$5,999,99926/06/201821/09/2015$4,185,0001931
1860 BARCLAY ST VANCOUVERWEST END PROPERTIES LTD.$5,980,00023/03/201809/03/2016$3,100,0001901
6618 ASH ST VANCOUVERMODERN GREEN TECHNOLOGY LTD.$5,900,00020/03/201816/06/2015$3,450,0002011
7239 OAK ST VANCOUVER1161137 B. C. LTD.,$5,680,00007/08/201819/05/2015$1,875,0001944
1075 DOUGLAS CRES VANCOUVER1063263 B.C. LTD., INC.NO. BC1063263$5,680,00010/05/201805/01/2016$3,250,0001910
2659 35TH AVE W VANCOUVERCANADA JENO ENTERPRISES LTD.$5,180,00018/01/201829/02/2016$4,388,0001915
1841 MARINE DR SE VANCOUVER1096238 B.C. LTD.$4,990,00022/11/201729/09/2016$1,777,0001912
3531 37TH AVE W VANCOUVERK-BROS DEVELOPMENTS CORPORATION$4,880,00029/01/201814/12/2015$4,350,0001924
1405 40TH AVE W VANCOUVERQINGHUI HOLDINGS LTD.$4,690,00016/08/201820/04/2016$4,300,0001926
2439 EDDINGTON DR VANCOUVER2439 EDDINGTON HOLDINGS LTD.$4,628,00027/08/201819/01/2016$3,379,0001989
4689 MACKENZIE ST VANCOUVER1079931 B.C. LTD., INC.NO. BC1079931$4,580,00020/09/201728/09/2017$4,450,0002007
6069 CARTIER ST VANCOUVER1039181 BC LTD$4,528,00007/02/201816/06/2015$3,100,0001937
3884 26TH AVE W VANCOUVERALTAS GLOBAL BUSINESS DEVELOPMENT INC.$4,500,00001/03/201826/06/2016$3,900,0001925
2926 35TH AVE W VANCOUVERSONA DEVELOPMENT LTD$4,498,00009/02/201821/01/2016$3,800,0001988
3489 PUGET DR VANCOUVER1076872 B.C. LTD.$4,380,00030/10/201703/05/2016$3,860,0001952
2628 MARINE DR SW VANCOUVER1064867 BC LTD$4,288,00012/03/201823/03/2016$3,300,0001950
565 50TH AVE W VANCOUVER1145891 B.C. LTD., INC. NO. BC$4,280,00004/06/201805/01/2016$3,250,0001958
2706 2ND AVE W VANCOUVERCHUNGHUA INVESTMENT (CANADA) CO LTD$4,190,00012/09/201716/11/2016$3,800,0001913
3887 14TH AVE W VANCOUVER1164167 B.C. LTD$4,160,00014/08/201801/06/2015$3,200,0001927
4626 12TH AVE W VANCOUVERCHUNGHWA INVESTMENT (CANADA) CO. LTD.$4,150,00019/01/201820/12/2016$3,880,0001935
1739 52ND AVE W VANCOUVERCHANG CHENG INVESTMENT LTD$3,588,00024/01/201825/05/2015$2,468,0002004
8375 FRENCH ST VANCOUVER1079098 BC LTD$3,500,00022/06/201812/04/2016$2,220,0001947
3594 38TH AVE W VANCOUVERKANDA HOLDINGS LTD$3,488,00019/01/201808/08/2017$2,900,0001944
3536 1ST AVE W VANCOUVER8828 Holdings Ltd$3,339,00007/09/201717/09/2017$3,250,0001912
291 63RD AVE W VANCOUVERNEW TRADITION CONSTRUCTION LTD.$2,998,90001/03/201828/10/2016$2,010,0001959
4624 15TH AVE W VANCOUVERSEASKY HOLDING LTD, INC NO BC1029992$2,998,00006/02/201829/02/2016$2,850,0001944
4107 12TH AVE W VANCOUVERCIS HOMES LTD.$2,988,00010/10/201708/03/2017$2,700,0001920
2796 21ST AVE W VANCOUVERM LALL PROPERTIES LTD. INC. NO. BC 1028006$2,838,00019/02/201816/06/2016$2,598,0001940
2040 PANDORA ST VANCOUVER1074608 B.C. LTD.,$2,800,00020/09/201705/05/2016$2,000,0001913
2054 PANDORA ST VANCOUVER1074608 B.C. LTD.,$2,800,00020/09/201705/05/2016$2,000,0001912
2867 19TH AVE W VANCOUVERNew Tradition Construction LTD$2,699,90008/02/201829/06/2017$2,412,0001944
1370 10TH AVE E VANCOUVER1071932 B.C. LTD.$2,699,00029/03/201825/04/2016$1,750,0001910
292 63RD AVE W VANCOUVERRealution Investments Corp.$2,682,58009/07/201816/06/2015$1,650,0001994
3656 BLENHEIM ST VANCOUVERTakara Investments Ltd.$2,680,00005/04/201816/05/2016$2,380,0001928
1737 2ND AVE E VANCOUVER1890310 Ontario Inc.$2,650,00020/11/201712/01/2015$1,718,0001910
4586 8TH AVE W VANCOUVER1054618 B.C. LTD$2,550,00030/01/201825/11/2015$2,100,0001987
1826 12TH AVE W VANCOUVER1047469 BC LTD$2,499,90027/04/201824/03/2015$1,932,0001922
3077 16TH AVE W VANCOUVERRPQG HOLDINGS LTD.$2,480,00002/04/201808/12/2016$1,895,0001947
1578 58TH AVE E VANCOUVER1086844 B.C. LTD.$2,398,00007/02/201823/08/2016$1,650,0001954
266 21ST AVE E VANCOUVERHasson Holdings Inc$2,398,00020/11/201729/02/2016$2,265,0001928
2152 PARKER ST VANCOUVERHORST DAMMHOLZ REALTY LTD., INC. NO.$2,288,88801/02/201818/05/2017$1,580,0001982
2506 TRINITY ST VANCOUVERMARMAN DEVELOPMENTS LTD$2,275,00007/09/201702/03/2015$1,333,0001999
1275 24TH AVE E VANCOUVER1108940 BC Ltd. & Hucha Holdings Inc.$2,198,00023/04/201812/05/2016$1,560,0001926
6296 EAGLES DR VANCOUVERPARKHEIGHTS ENTERPRISES LTD$2,188,00005/10/201720/12/2017$2,150,0002007
845 17TH AVE W VANCOUVER1040394 B.C. LTD.$2,170,00020/03/201820/07/2015$1,767,0001944
2806 ETON ST VANCOUVERMARMAN DEVELOPMENTS LTD.$2,080,00004/06/201822/01/2016$2,000,0001951
2792 KITCHENER ST VANCOUVER1009503 B.C. LTD$1,988,00012/06/201822/07/2015$1,272,0001987
6108 KNIGHT ST VANCOUVERHuynh Holdings Inc.$1,988,00028/01/201806/03/2017$1,420,0001967
3369 NANAIMO ST VANCOUVERVLK HOLDINGD INC$1,899,00006/08/201822/03/2016$1,715,0001948
6708 BROOKS ST VANCOUVER6708 BROOKS STREET HOLDING INC$1,799,00005/02/201831/03/2017$1,600,0001958
2020 6TH AVE E VANCOUVER1126254 B.C. LTD.$1,798,00018/06/201813/05/2017$1,550,0001930
527 28TH AVE E VANCOUVERHASSON HOLDING INC.$1,798,00020/11/201702/05/2015$1,300,0001956
1151 UNION ST VANCOUVERUnion Street Investments Ltd$1,789,00022/05/201812/05/2015$810,0001905
1821 UPLAND DR VANCOUVERSONA DEVELOPMENT LTD.$1,788,00012/03/201810/05/2017$1,700,0001950
775 39TH AVE E VANCOUVER39TH ST PROPERTIES LTD., INC.NO. BC1073714$1,749,00019/09/201702/03/2016$1,635,0001986
1910 19TH AVE E VANCOUVERHomeward Bound Park View Dev. Inc$1,699,00018/03/201806/10/2016$1,359,0001923
6975 VIVIAN ST VANCOUVERCHRISTA VINA INVESTMENT LTD.$1,688,00030/04/201806/04/2016$1,645,0001957
1249 11TH AVE E VANCOUVERCAMBRIDGE MORTGAGE INVESTMENT CORP$1,550,00010/10/201718/12/2017$1,420,0001910
1969 8TH AVE E VANCOUVER1041540 BC LTD.$1,549,00027/09/201717/01/2018$1,528,1221930
1372 49TH AVE E VANCOUVERKINGDOM INVESTMENTS INC.$1,498,00005/06/201810/09/2017$1,307,0001946
305 40TH AVE E VANCOUVER11162017 BC LTD$1,498,00028/11/201729/06/2017$1,300,0001947
695 12TH AVE E VANCOUVERQuantum One Investments INC$1,450,00026/02/201823/03/2017$1,030,0001950
2712 PANDORA ST VANCOUVERTAYVA INVESTMENTS INC$1,449,00020/11/201719/05/2016$1,295,0001908
4539 BEATRICE ST VANCOUVERHUYNH HOLDINGS INC.$1,440,00006/10/201706/10/2017$1,440,0001910
2052 49TH AVE E VANCOUVERBIRING BROTHERS CONSTRUCTION LTD.$1,399,00007/05/201802/05/2017$1,320,0001927
1022 ODLUM DR VANCOUVER1071251 BC LTD$1,398,00017/04/201804/04/2016$980,0001906
2771 MANITOBA ST VANCOUVER1099481 BC LTD INC.$1,379,90022/06/201805/04/2017$1,007,0001996
3658 TURNER ST VANCOUVERFOUR SEASONS NAILS & SPA LTD$1,369,00031/08/201830/03/2016$1,230,0001926
765 39TH AVE E VANCOUVER0971933 BC LTD$1,350,00008/08/201807/04/2016$1,249,0001950
811 12TH AVE E VANCOUVERA Q HOLDINGS LTD.$1,349,90009/07/201805/05/2015$750,0001936
3406 MONS DR VANCOUVER2781 Capital Inc.$1,300,00030/10/201707/05/2016$1,400,0001948
2059 CHARLES ST VANCOUVERCKL INVESTMENTS LTD$1,268,80025/09/201728/01/2017$940,0001949
3650 GEORGIA ST E VANCOUVERG-HO HOLDINGS LTD, INC NO BC1107764$1,249,00026/01/201825/07/2017$980,0001934

Joyful Holdings, the company at the top of my list, belongs to a Hong Kong property tycoon known as the “King of Shell Companies,” whose name appears in the Offshore Leaks database of tax haven clients1)https://thinkpol.ca/2018/03/13/hong-kong-tycoon-linked-offshore-tax-havens-flipping-18m-vancouver-house-shell-company/. Vision Vancouver donor2)https://contributions.electionsbc.gov.bc.ca/pcs/SIGSearchResults.aspx?Contributor=ceetu&EndorsedSK=0&Endorsed=(ALL)&EventSK=0&EventAlias=(ALL)&FilerTypeSK=0&FilerType=(ALL)&Class=0&OfficeSK=0&Office=(ALL)&JurisdictionTypeSK=0&JurisdictionType=(ALL)&JurisdictionSK=0&Jurisdiction=(ALL)&FilerSK=0&Filer=(ALL)&DateTo=&DateFrom=&DFYear=&DFMonth=&DFDay=&DTYear=&DTMonth=&DTDay= Ceetu appears twice on the list.

We need stop landbankers from artificially driving up land prices, and then free up the land they’re holding onto to build more affordable housing. The city needs to work with the province to introduce a landbanking tax that makes landbanking an unprofitable venture.

I believe Vancouver should take care of those who take care of our city and our citizens. I dream of a place where those who contribute to our communities are able to afford to live in the city. I’m running for city councillor to see that dream come true. Please help me by donating and volunteering to my campaign.

References   [ + ]

1. https://thinkpol.ca/2018/03/13/hong-kong-tycoon-linked-offshore-tax-havens-flipping-18m-vancouver-house-shell-company/
2. https://contributions.electionsbc.gov.bc.ca/pcs/SIGSearchResults.aspx?Contributor=ceetu&EndorsedSK=0&Endorsed=(ALL)&EventSK=0&EventAlias=(ALL)&FilerTypeSK=0&FilerType=(ALL)&Class=0&OfficeSK=0&Office=(ALL)&JurisdictionTypeSK=0&JurisdictionType=(ALL)&JurisdictionSK=0&Jurisdiction=(ALL)&FilerSK=0&Filer=(ALL)&DateTo=&DateFrom=&DFYear=&DFMonth=&DFDay=&DTYear=&DTMonth=&DTDay=

Only 5% of Vancouver Airbnb listings deactivated

 

City of Vancouver’s short term accommodation bylaw fully came into force today. There was much talk of “2,000” Airbnb units being deactivated. But did it really happen?

 

It appears that Airbnb has deactivated approximately 5% of the listings that were active on August 31.

 

I took a random sample 832 of City of Vancouver hosts on Airbnb August 31 between 4pm and 6pm Pacific Time.

 

218 out of the 832 (27%) of them were without licences and facing deactivation. I ran a follow up today between 1pm and 2pm. Here’s what I found

 

Table1: What happened to the listings without licenses on Aug 31

New State Number Percentage
Deactivated 45 21%
Converted 30+ Days 163 75%
Licence obtained last minute 10 5%
Total 218 100%

 

That means approximately 5% of Airbnb listings that were active in my sample have been delisted. If we go by Jens von Bergmann’s figure of 4,700 total listings1)https://doodles.mountainmath.ca/blog/2018/08/21/airbnb-and-str-licences/, that works out to about 250 listings being taken off the platform.

 

But the number of people who are cheating the system far exceed the number of listings yanked from the platform. I’m currently collecting data post-purge, and here’s what I have found with my fresh sample of 1,634 listings collected so far today.

 

Table 2: Summary of problems with licences

 

Status Count Percentage
Licence used multiple times 459 28%
“Exempt” but less than 30 nights 73 4%
Obviously fake 17 1%
Not found in CoV database 152 9%
Valid 933 57%
Total 1634 100%

 

459  listings, or 28%, share a licence with one or more other listings. This means that Airbnb and City have done nothing to crackdown on commercial operators.

 

Licences for 152, or 9%, did not appear in the City of Vancouver business license database.

 

73 out of the  832 listings in my sample, or 4%, claimed to be “Exempt” even though they were for less than 30 days. Further 17 listings, or 1%, had obviously fake license numbers such as 00-0000. This means 11% of the listings are either fake or are claiming to be exempt when they probably aren’t.

 

In summary, the “great purge” did not happen. Even amongst the listings with licences, 43% are problematic.

 

A lot of these problems can be solved by introducing license auto-verification2)https://rezel.ca/2018/06/automated-short-term-rental-accommodation-licence-integrity-checking-system-astralics/.

Data

I’m happy to share my SQL database if anyone wants to play around with it. Just get in touch with me.

Bonus

Here’s a nify two-liner to extract City of Vancouver short term rental licences from the Open Data portal Json file.

import json
stral = [f['properties']['LicenceNumber'] for f in json.load(open("/path/to/Politics/business_licences.json"))['features'] if f['properties']["BusinessType"] is not None and 'Short-Term Rental' in f['properties']["BusinessType"]]

References   [ + ]

1. https://doodles.mountainmath.ca/blog/2018/08/21/airbnb-and-str-licences/
2. https://rezel.ca/2018/06/automated-short-term-rental-accommodation-licence-integrity-checking-system-astralics/