Show HN: I built an extension for analyzing rental properties in Zillow (homescope.io)

67 points by thecalebf ↗ HN
Hey everyone, I build a Chrome Extension for real estate investors to be able to easily calculate the cash flow of a rental property right within Zillow.

As an aspiring real estate investor, I found spreadsheets and proprietary online calculators like Bigger Pockets to be complicated or slow. With Homescope, you can bring this within your workflow and estimate your operating expenses instantly.

90 comments

[ 3.3 ms ] story [ 145 ms ] thread
(comment deleted)
People do not have the funds, access to credit, political connections, and expertise to acquire sufficient land, go through the permitting process, and end up with an affordable housing neighborhood.

An app will not change that.

i disagree because land developers and land development programs already exist we simply need to coordinate a co-op effort.

using homes an investment leads to hoarding of resources.

Why does america have more empty homes than homeless people? Markets have failed because they're chasing imaginary rental demand instead of adapting to real demand.

If people could only own 1 residential property at a time this would not be an issue and the whole program thecalebf built would not be needed.

the program you built helps exacerbate a social ill, and while it's great technically it's horrible socially.

I hope this feedback helps you pivot to solve the more pressing problem in real estate.

Landlords provide a necessary service to the poorest in society. If there were no landlords, people who could not afford to purchase homes would have nowhere to live.

Landlords suffer from bad tenants, and also from bad government policies like rent control and the cancelling of rent during Covid (and nobody cancelled the mortgage bills for landlords, or the property tax). They are constantly portrayed as villains, often by the same people who benefit from the housing landlords provide.

What you call hoarding is the market at work, providing investment opportunities to landlords and housing to people who can’t afford to buy, all at the same time.

Housing is a service? Generally real estate businesses aren’t thought of that way.
Landlords dont provide any services. Construction workers build the house.

if there were no landlords people would still have 1 home and builders would get hired by the homeowner who could finally afford homeownership.

We have more empty homes in America than homeless people.

The market is not working because its failing to respond to the demand of more than 90% of the population for affordable housing despite us having more supply of housing than homeless people in need.

BREIT is above $50b [0], which is basically enough to buy up literally all of the inventory for many housing markets combined.

I'm hoping there is some sensible legislation, as we can't rely on the Fed hiking the rate to the moon because cutting medicare to pay the interest on the national debt is not gonna go over well with voters :(

[0] https://www.wsj.com/articles/blackstone-property-fund-target...

You mean starting to live within our means and spend less? You mean the responsibility falling to the families and local church communities? Sounds great.
> BREIT is above $50b [0], which is basically enough to buy up literally all of the inventory for many housing markets combined.

That's a shocking figure, but there's multiple factors that makes it misleadingly shocking:

1. The $50B was raised over the last 5 years. The amount of cash they have sitting around to actually buy houses is much less.

2. I'm presuming that by "many housing markets" you mean different cities. Presumably the fund is interested in buying properties across the country, so it's not too surprising that the same amount of money can buy all the houses if they concentrated purchasing in a few select cities. It's like arguing that your local school district consumes too much food by pointing out that they can "buy up literally all the inventory for many supermarkets combined". That might be true, but it doesn't give me much information about scale.

3. The WSJ article says that fund buys "rental-apartment buildings, warehouses, office buildings, casinos and other property types". Comparing a pot of money designated for multiple purposes, against a subset of purposes is misleading.

> so these assholes sink

That's uncalled for. You're letting your envy through.

Except a lot of people agree with that sentiment. Just because something is a perfectly legal business model doesn't mean it's generally perceived as being ethical.
I can't speak for the person you replied to but for me:

> That's uncalled for.

Don't care.

> You're letting your envy through.

It's not envy. It's watching rampant real estate speculation, hoarding of properties by landlords--big and small--and the four-generations-and-counting idea that owning housing is the only "stable" asset in this country turn my city into a place where my adult kids can't afford to live, many of my friends have had to move away, and largely the only people populating many of the neighborhoods around me are from the mono-tech-culture.

All while the crisis of housing people who need it yet who have fallen off of the increasingly-shaky bottom rung of society continues unabated.

It's fucking terrible and I don't really have a spare thought for anyone who insists "oh, exploiting real estate, that's how I'm going to make money" is their way out. I reserve the right to think and express the idea that it's morally wrong and that tools that enable that behavior are, by equivalence, also wrong.

(Before someone says: "Well, your city could just zone for more housing." They could, but that a large quantity of "net worth" is wrapped up in people's housing makes that almost impossible from a political perspective. So we wind up with nothing but rented apartments next to loud arterials, safely away from the areas where the people who can afford to live or who have lucked into generationally living in detached housing are living.)

The root problem isn't housing. It's that globalization has led to fewer unskilled jobs. There's nothing for many people to do, and it's only going to get worse.

You're also completely discounting the massive volume of affordable housing outside of California and the major cities.

I was just looking for beach homes. You can get a 1600sqft ranch style home in Daytona, FL for $250,000. If I bought one, I suppose that would make me part of the speculation bubble "assholes" that deserve to "sink"?

I don't live on the West coast, and I don't know what y'alls problem is, but it seems to me like everyone is trying to pick and choose who lives where. Just build more.

> only people populating many of the neighborhoods around me are from the mono-tech-culture.

This is showing your California/Seattle/whatever tech bias yourself. By living there, you're a part of this thing you're complaining about! You're literally complaining about yourself. Do you not see the irony?

Sell your house so developers can build apartments on top of it. Or stop renting and paying taxes there. Vote in people that will level every single family home.

Stop complaining about people buying unless you're willing to give up yours too. It's their money.

Except you're wrong. There isn't a massive volume of affordable housing outside of California and major cities. It's very relative. I guarantee that people actually living in those "affordable" places don't consider that as affordable as someone on a tech salary would consider it.
There absolutely is.

The house I cited is affordable with a total household income of $70,000. There's a ton of inventory in this range.

Where's your data?

https://www.census.gov/housing/hvs/data/rates.html

My state's home ownership rate and population is on the rise YoY, as are many others.

https://www.pewresearch.org/fact-tank/2021/03/08/amid-a-pand...

It's on the rise nationwide since 2014.

Not everyone lives in a popular city or wants to.

Edit: Zaroth argues against this logic even better [0]

[0] https://news.ycombinator.com/item?id=32803776

This screams out to me as "I'm a part time landscaper and my home buying budget is 1 mil.". These types of data points are just bullshit. People making 70k a year are not realistically looking to buy a 350k house even though that's the upper limit of their supposed range. Most houses under 150k that I've seen are mostly in need of repair. In reality there is a slim window of affordability and livability and those homes are being bought up by real estate investors and turned into rentals. The on paper market and the actual market are two different things.
You make it sound like $1500 a month mortgage is affordable with the jobs you could get in those areas.

Taking Valdosta, GA as an example, the median household income there is $35,085.

http://www.city-data.com/city/Valdosta-Georgia.html

Drill down. The median age is only 27, and an unusually large percentage of the 16-18 labor force is working. Farming or going to Valdosta State. It's a college town, and they also grow a whole lot of onions.

> Valdosta State has approximately 11,270 students

> The current population of Valdosta, Georgia is 55,550

Interesting demographics, indeed.

They have a nice downtown, surprisingly big theme park, and lots of stuff for college age kids to do. So it's not a wasteland. It's also only three hours from Atlanta and Apalachicola.

In any case, there are cheaper homes in Valdosta.

https://www.trulia.com/p/ga/valdosta/4189-hamilton-cir-valdo...

Nothing you said changes the fact that that the medium income is $35,000.

Why do you think houses look so much affordable there?

(comment deleted)
I mean you seem set in yours as well. It's ok, we can agree to disagree.

But, I think you're cherry picking a bit. Of course I can pull up and look literally anywhere and find something. Take some of those and try to find enough comparables (and not just one or two) in the same place for there to be a healthy market for people who actually live there and can afford. Good Schools, Safe Neighborhoods, Good Job Opportunities? Even at 250k its still a stretch for people who actually live and work in these areas. Most of the median income in these small towns isn't anywhere near 70k even for working adults. Most people don't have the option or skills to just open a map and pick anywhere to move to and work a comfy remote tech salary job and most of the people who can have left those places for greater opportunity e.g. big cities.

I’m confused at who you’ve decided to be angry at for this effect you are observing.

To the extent that investors are buying up perfectly good properties and leaving them vacant then you should blame the investor for taking inventory off the market and draining the supply.

This was happening a lot in Vancouver I believe, with embezzled funds from China—funny money that wasn’t actually seeking a return on investment, just a safe place to hide. It’s a serious problem in some areas and should be stopped.

However an investor buying a property to rent it does not change the supply/demand curves for livable housing in that market. They mostly are lowering the transaction costs of moving into the area by providing rental options.

Investors bidding against each other for houses to rent will only serve to take the profit margin of renting and assign a greater proportion of that value to the current owner of the house.

The investor bidding war is fundamentally limited by the demand in the rental market. Rental rates go down as more properties are converted to rents, and up as more people want to move to the area.

So blame the area for being too desirable, or the renters for being willing to pay too much rent.

The housing investors have some marginal effects on transaction costs and increased market efficiency, but the price level is being set entirely outside the investor’s domain based on the demand of people to actually live in that area, the occupancy rate, and the rate of new construction.

(comment deleted)
I believe that it is undesirable to live in a society where the rich get richer, and the poor get further and further behind.

According to Zillow, my home -- which I own -- has gone up in value by nearly 50% in the last three years. Good for me I guess, but not good for people who are trying to rent or buy their first home. And I'm not even sure it's good for me -- long term, I want to live in a neighborhood where not everyone is rich.

Well because you have to live somewhere, you'll never be able to "cash out" on that house since you'll just have to buy another house which if it's aligned with your tastes will probably have also surged 50%.

In the meantime, your property tax either has gone up or will go up 50% so you're short-term poorer.

Zillow home estimates are worth zero. Hence them eating a huge loss on their own home flipping business.

Your house would almost assuredly not sell for the 50% price increase that Zillow is claiming. Their goal is to get you to spend time on their website and shop for houses, and somewhat plausible, eye popping numbers help.

Investing in real estate is not "speculating". I provide a home to young families who have become too large to live in an apartment but haven't saved enough money for a down payment to buy their own house. I also pay for all repairs, maintenance, taxes and fees. You should learn more about an industry before you insult the people working in it.
Come on. You buy up starter homes.
You are right about it not being speculation but you are wrong on how you see your tenants. You may have a family in there now that said “Oh, we are saving to buy a house soon, we just haven’t been able to save enough” which was my statement I used to give. The reality is I had student loans, credit card debt, an ex-wife that didn’t work and loved to shop.

You’re right about your liabilities. Repairs, etc. Most landlords don’t go so far. When I was renting for 20 years, I only had one landlord that offered to do repairs. All the rest of them said for me to do it and they’ll reimburse me which led to a bunch of back and forth as to why it broke and who was “at fault”.

I grew up poor. My family didn’t own a home. It took me until I was 40 to be able to save enough for 20% down.

(comment deleted)
You can save the song and dance. You’re not convincing any home-owners (or even potential renters) with your savior-complex lording.

Just be honest. You bought an asset you expect to increase in value, and renting allows you an easy manner to pay for that. If you’re renting at current market rates, which have screwed over current renter’s savings in almost every market in the country, you’re likely contributing to this family’s lack of savings. (Again, if were being transparent, all so you can see your asset appreciate).

Taxes, maintenance, etc. are a small price to pay for the earned appreciation. Even smaller when compared to the rent.

> I also pay for all repairs, maintenance, taxes and fees.

You may pay that when the bill comes due, but lets be honest, your tenet actually pays that over time. If you haven't calculated that into your rental then that would be bad business.

Are you really filling a gap, or just investing in an asset like any other instrument with disregard to restricting the market by reducing availability of affordable housing. I'm pretty sure it's the later.

It isn't always speculation and doesn't have to be speculation. Here's a model of what that might look like:

I buy a house for $500,000. I know property taxes + repairs/depreciation + the amount of time I spend interacting with tenets will cost ~3-4% the cost of my property per year. I know with the stock market, I can average returns of around 8%. So, in order to make the real estate property attractive, I need to rent it out for ~12% of the purchase price per year or since we usually discuss rent in a monthly rate, I need to charge tenets about 1% per month. In this example, $5,000 per month.

Where I live, apartments are selling for $500,000 but rent for similar apartments are closer to $2,000-$2500. Not $5,000. So, the owners of the property are getting 6% of the property value in rent per year which minus the 3-4% costs gives them a net profit of 2-3% the cost of the property. Why would anyone do this? Some might have bought the property at a lower value but they could always sell and invest in something more lucrative if they wanted. From an opportunity cost perspective, they aren't much different than someone buying in at the higher rate. So, from an actually logical viewpoint (let's not claim real estate investors are just too stupid to realize what they're doing), I see 2 possibilities:

1. They're speculating that the price will go up. My area has seen housing prices go up an average of 5% per year for the last 30+ years. If you are getting 2-3% ROI from rent and 5% ROI from housing price increase, that's 7-8% ROI which isn't bad. You're claiming real estate isn't speculative so let's take a look at the other option I can imagine to see if it paints a better picture.

2. They're highly leveraged. If you have 20x leverage at an interest rate of 2.5%, and subtract your interest payments from the 3% you made, you get 0.5% of the property value in profit when you only invested 5% giving you a 10% ROI. Again, not too bad a deal for the landlord. Different risk profile than stocks but about the similar returns. Unfortunately, this situation isn't very flattering to landlords IMO. In that case they're basically taking advantage of the fact that they have access to cheap credit and their tenets don't. That cheap credit by the way only existed because of the federal reserve and we'll all be paying it back in some form or another (possibly through high inflation rates possibly some other way).

I'm not saying landlords are evil or anything. This is the game that our government created and landlords are just playing the game. I am however saying that I don't think this game is good or sustainable and maybe our government should change the game. If that requires screwing over the people that have bought housing in the last few years, so be it. I'm not going to feel too bad for either the person that has been speculating on housing or the person that over leveraged themselves. If you aren't either of those people, housing prices collapsing shouldn't scare you that much. If you noticed, my argument is based on rent being too low in comparison to house prices. I can absolutely see a situation where home prices drop a significant amount but rent prices stay about the same. That scenario shouldn't hurt you if you aren't in either of the camps I listed above.

It is tenant, not tenet.

>I know property taxes + repairs/depreciation + the amount of time I spend interacting with tenets will cost ~3-4% the cost of my property per year. I know with the stock market, I can average returns of around 8%.

You do not know this, you are guessing this.

Sorry for mistyping a word. Don't think I can edit it now.

And yeah, I can't predict the future and I don't know the specific housing you're looking at so I can't know for a fact what those precise numbers will be. They are inline with historical and national averages though. I'm not just making them up out of no where and at the end of the day, any investment will have uncertainty.

Can you explain to me how purchasing housing with the intention of renting it out at 0.5% per month makes sense without either relying on high amounts of leverage or hoping it appreciates in value? That's the crux of my argument and I don't think that changes if you change the numbers I listed above by any reasonable amount. I mean even if you get property taxes, repairs, and property management costs down to 2% (a pretty lofty goal if you ask me), you're still only getting 4% ROI every year (and that assumes you have 0 vacancy ever). Why not just invest in government bonds at that point?

> Can you explain to me how purchasing housing with the intention of renting it out at 0.5% per month makes sense without either relying on high amounts of leverage or hoping it appreciates in value?

I do not disagree, the crux of real estate as an investment relies on being able to invest on margin without the lender being able to call back the loan, and of course, 1031 exchanges serving as a tax deferment vehicle.

If not for those two benefits, people would be better off buying VOO on margin.

Yes, real estate investors are the definitely the group most in need of empowerment... /s

Edit: The ethics of this project are questionable, assisting real estate investors at the expense of first time home buyers (indicated by the heavy focus of this tool on optimizing profit through rental income) is not what our society needs at the current moment, in my opinion, as it reduces the pool of available homes for sale and forces our society further into separation between people catapulting their wealth and those who just want an affordable house to actually live in with their families while adding an asset to their net worth.

This tool is more for smaller investors not really massive funds or companies like Blackstone.
Why should we want more landlords at all? Tools like this help to further the already terrible stratification and suck more money out of those who are on the lower end of the income spectrum and funnel it to those who do already have money
I am not here to defend any particular group, but I just don't think this comment is fair to anyone. At the end of the day anything that can help the market become more efficient is a good thing.
(comment deleted)
> At the end of the day anything that can help the market become more efficient is a good thing.

Efficient for whom? The person who has a one-off need for housing every few years? Or the person who already has the time, money, and connections to leverage money into bundling up more housing for themselves to loan out to that first group?

This also presumes that housing, at least primary residences, should be a market instead of a utility, which is not at all a given considering how the "market" is working out (or not) for a lot of people right now. Tools like this further increase that gap.

Looking at the Privacy Practices, I see PII info and authentication info. Can you speak to what exactly is collected and how?
Hey there, yes the only thing collected is authentication so email password signing in via Firebase. It isn’t used in any way other than auth. Hope that answers your question!
I've wanted this for a long time, and it makes a ton of sense. Thanks!
Let me know if you have all the tools you need :). Always open to add things to help make finding deals easier!
I have a friend who's been doing this. Some things that confuse me, if anybody can shed light:

1. Do other developed countries allow 20x leverage on cash to buy homes?

2. It seems like most real estate investors aren't pursuing commercial loans, but instead are using personal home-loans. Is there any regulation of this? ("Oh, I intended to live there, but then something happened")

3. How can banks afford to give out loans at interest rates that are less than inflation? Is this due to Federal Reserve rates, and if so - do other developed countries maintain such low interest rates + tax benefits for home purchases? It seems like the US government is propping up this entire industry, rather than letting a free market operate.

I'm going to qualify this with I'm not an expert but I do have some familiarity with the space.

1. While possible, loans where you put less than 20% down are tied to very high interest rates. Most people I know in the space avoid these or quickly refinance once the cash is available.

2. Commercial loans are difficult to get for an individual investor. If you're purchasing residential housing these aren't practical.

3. Banks interest rates are only tied to the federal interest rate.

1). Yes they do. Some even loan you 110% (Netherland..) of property value but mostly they loan you around 80%-90% of price. Usually bigger leverage means bigger interest.

2. Not really and honestly banks usually don't care if you pay in time.

3. Now I'm talking from experience as resident of some European country. When you are giving a loan to someone to purchase a property as a bank you are not loaning your own money. You loan this money usually from central bank and then "re-loan" it for higher interest to customer. Most of the mortgages in Europe are with fixed interest for some period therefore inflation doesn't really bothers you because bank loaned this money from central bank in times where you get the mortgage when interests were low.

It worth noting that these "central bank money" is not giveaway of free cash flow. If another bank have surplus of cash on the end of the day they can lend it to the bank for some interest rate so they can make at least something out of it. This is the way how government controls inflation. When they set higher rates of interest banks usually rise their interest rates because it's simply is easier to let them sit in central banks.
Are you referring to the commercial paper market? Because that’s more of an overnight thing.
Lenders in the US offer loans for investors that are still not commercial loans. They have a higher interest rate than a loan against your primary residence. There is regulation preventing you from using a primary residence loan for an investment property, and lenders will enforce it.

Commercial loans are not typically used for things with 4 units or less, however they are required for non-residential builds and for multifamily >4 units.

I thought in the US if you lived in a home for several years you could move out and start renting it out without refinancing for some reason. Do you have a resource for more info about this?
You can't get a primary mortgage for a rental. There is a time term in the note, like you have to occupy for at least two years.

You can use a cash -out refi on your primary and use those proceeds for a rental (but you'll need lots of equity).

One can also get non-commercial loans to buy rentals but the terms (eg LTV, rate) are steeper than for primary.

You can turn a primary residence conventional mortgage property into a rental after 1 year of owner occupancy. FHA and VA are the same.
Regarding only #3,

Banks can afford to give out loans that are less than inflation because they are creating money out of thin air to lend to you. Sure, the lent money is collateralized behind a property but it’s new money. It doesn’t really matter how much of a return they get as long as the return is higher than the default rate percentage and the return (after factoring in defaults) is positive.

There used to be restrictions like a 10% reserve ratio. But that’s been lifted in the US in 2020.

Big banks can also borrow money from the central bank to lend out. Current federal rate is 2.25%-2.5% and mortgages are about 5.9%. Thus banks keep the interest rate spread. Using those numbers, a $300,000 loan at a 30yr fixed rate is a bank product that will thus earn the bank $178,959.73 in interest. No wonder banks are the most wealthy class of businesses!

(comment deleted)
>"We make analyzing a rental property so easy Grandma can do it!"

There are lots of grandmas who are engineers, scientists, doctors, and inventors. There are plenty of ways to land that message without carrying forward the spirit of 1950s Madison Ave. Plus, that copy doesn't tell anything about the product, it's fluff.

"Analyze deal potential without leaving Zillow"

"Automatically analyze rental properties as you browse"

"View critical deal metrics as you browse"

etc

> There are lots of grandmas who are engineers, scientists, doctors, and inventors.

And there are a 100x multiple of grandmas who are not any of those things.

Your virtue has been signaled. It’s just a figure of speech.

Grandma already owns all the property nowadays.
I've been thinking about making something like this. I can't wait to take a close look at it.
Also if Zillow is hiring new grad engineers reach out :)
Do you have any information that explores this topic deeper? Mortgages are a forcing function for retirement savings and help people in retirement that were not able to manage their income.

If home values would not increase, what should happen to everyone that wasn't able to save for retirement and can't rely on home equity?

Housing as a savings for retirement only works if you retire at the right time. Many people in 2008 could not retire because of the housing crash.

Right now, money that would go into other investments is going into having to buy inflated housing. So while this might help people who are currently retiring, it hurt the people looking to use it as a method to rite in the future.

Forbes has some good insights here:

https://www.forbes.com/sites/adammillsap/2020/02/28/treating...

I agree with all the article's points, but for all of its reasons, housing needs to be an investment.

The down payment is a significant portion of net worth. For this down payment to not grow in value, is detrimental to end of life needs.

What is the alternative? Socialized housing?

while I agree housing is a terrible investment, its still an investment for people that aren't investing. People will pay their mortgage than set money aside for into investment vehicles.
Zillow has sent cease and desist letters, and sometimes sued people using the data from their site. You might be okay if you're not in the US though.
IMO the appropriate response to this is to open source it, once the source is out in the wild then there's not much they can do about it.
That puts Open Source in an antagonistic position, which is overall harmful to the ecosystem.
The extension isn't storing any data from Zillow. Bigger Pocket's proprietary calculator pulls the data from Zillow as well. I think as long as you aren't storing or trying to make it proprietary it is better.
I installed the extension but when I click on it (in Zillow) all I see is an EMPTY popout panel ...
Hey, interesting. Make sure you have a home opened and it should populate with the charts. If that doesn't work feel free to send me an email at caleb at homescope.io and I can help you out :)
Nice tool! Curious why it doesn’t auto populate Zillows estimated rent value?
This is great! Beautifully designed and effective. I'll definitely be trying this out.
Thank you. Let me know if it meets your needs :)