Kenton Kwok

Real Estate Market Urban vs Suburbs, 1 year into Covid: SQL Analysis

TL:DR People are leaving city for suburbs SF market slows, Suburban market is HOT Lower demand for SF >> prices flattened Very low supply in suburbs >> 25% increase in price Real estate businesses like brokerages and OpenDoor may struggle in certain suburban markets Analyzed data with SQL (Ex: Table Creation, Queries, Aggregate Functions, Joins, Inline Queries) using SQLite (in appendix) Background Through the pandemic, we have seen a large scale exodus away from cities to suburbs. Quarantine has emphasised the living pains of high density, expensive, and cramped city life, while the attractive social attractions and city culture have been restricted. Work/school/life at home has been especially stressful to… Read More »Real Estate Market Urban vs Suburbs, 1 year into Covid: SQL Analysis

ADU Garage Conversion

Accessory dwelling units (ADUs) are one of the best ways to add value to a property, especially in the Bay Area, where there is a perpetual shortage of housing. I have found that one great way to add an ADU is by converting an existing garage to an ADU. This converts inhabitable space into a complete unit with kitchen, bathroom, and bedroom. One project I did was the planning and execution of a garage conversion. ADUs have all the complexities of a whole house, constrained by a small package. They require all the same electrical codes, kitchen and bathroom complications, and structural analysis a large house needs just to name… Read More »ADU Garage Conversion

Housing Data Trends for SF

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Lobortis mattis aliquam faucibus purus. Condimentum lacinia quis vel eros donec ac odio tempor. Sit amet cursus sit amet dictum sit. Egestas erat imperdiet sed euismod nisi porta lorem mollis aliquam. At imperdiet dui accumsan sit amet nulla facilisi. Ac felis donec et odio pellentesque diam volutpat commodo sed. Proin fermentum leo vel orci porta non pulvinar. Sit amet massa vitae tortor condimentum lacinia quis. Erat pellentesque adipiscing commodo elit at imperdiet dui accumsan sit.

Bike Powered Irrigation Pump

Testing a Tech MVP: A Home Renovation Contractor Booking Platform

Brickplank: A product development project TL:DR I did a side project on an area I am familiar with: connecting homeowner and contractor Market Opportunity: Right now it’s huge $100B market, but a fragmented (leader has only ~5% share), with confusing process to find a good contractor and untapped potential What did I do: I wanted to think about the market, design a product strategy, and push a MVP in a scalable content aggregator, using a Python crawler, NLP, and a basic website RETRO: MVP failed to pick up traffic due to unrefined content from my automated process. Still see huge market opportunity in lead generation business. Intro I’ve been working… Read More »Testing a Tech MVP: A Home Renovation Contractor Booking Platform

Mushroom Foraging

I’m an avid home cook, so I first got started hunting for gourmet mushrooms, like porcini and morels. Over time, I started to appreciate and notice the beauty and amazing variation of mushrooms, besides their culinary aspects. They are seemingly everywhere, while hiding in plain sight. They are very ephemeral, they will fruit for just one week out of the whole year, before rotting away. They make the most boring rainy days fascinating. They make the most mundane forested hike an amazing discovery. I often go on 1/4 mile hikes, with probably more elevation gain from squatting looking at mushrooms. Every hike is treasure hunt and a unique adventure.

Antique Telephones

I have been collecting telephones for years and have amassed over 100 telephones. Vintage telephone have a simple lasting beauty that I really enjoy. The telephone was the first technology that truly and effectively connected the world. For over a 100 years, it enabled transcontinental business, ideas, and human connection. Bell System, the leading telephone business, grew to be the largest business empire before anti-trust actions broke it up in the 80’s. In addition to telephones, I collect typewriters, fountain pens, and other interesting antiques. I collect, clean, and restore these beautiful pieces of history and restore them to their former glory. Almost all of my pieces have been restored… Read More »Antique Telephones