I'm trying to put together some documentation showing that a zoning change would negatively impact that value of some neighboring properties. To do this, I want the average sale price within a zip code, along with the average $/Sq Foot.
Does anyone know if that data exists anywhere? The average sale price is on zillow, but not the price per square foot (or the average size of the homes sold).
This one may help - I have used it for COLA comparisons and a good high level look at what an area actually is.
MLS or County records.
I haven't really dug into it, but Zillow supposedly offers their "Home Value Index" in a $/sqft that's sortable by zip code:
https://www.zillow.com/research/data/
You'll have to download the excel file to really see what's there
Thanks STM. Unfortunately, it appears that the Square Footage details aren't there in aggregate. I believe they used to have it, but I can no longer find it.
SWIMBO deals with this for work. All she knows of is the hunt and peck method using a reality site. I believe you can search areas by home size. Most of those sites are geared more towards value, rather than size. I'll talk to SWMBO after she's done to make sure what I've told you is correct.
She's asking what size are you looking for?
You probably only have to show the effect on property taxes. If taxes go up, values go down, and vic versa. I know it's not as direct, but it will likely be easier.
Ok, sounds like I'm not clear with what I'm looking for. I am looking average price/square foot for a zip code, broken down by month of sale.
Ideally, I would get an excel file with every sale within this zip code in the past 5 years, with (1) the price it sold for, (2) the square footage of the house, and (3) the square footage of the lot. Additional "nice to have" items would be the number of beds and baths.
I can get the average sale price. That is easy. Unfortunately, it doesn't really help me too much on its own, because a 2 bedroom bungalow that is effectively a teardown is going to be valued much differently than a 6 bedroom McMansion, but both are included in the average. However, if I can include the average $/Square Foot into my analysis, I can see how far off the average sold homes that are next to a parking lot are.
I'll be finding the sales of homes next to parking lots manually.
mtn said:I'm trying to put together some documentation showing that a zoning change would negatively impact that value of some neighboring properties. To do this, I want the average sale price within a zip code, along with the average $/Sq Foot.
Does anyone know if that data exists anywhere? The average sale price is on zillow, but not the price per square foot (or the average size of the homes sold).
And you are going to do what with the data. City/counties/states give a rats ass about individual property values when dictating zoning. If the net gain on the other side of the equation is better unless you have a ot of pull or a lot of attorneys your not making them change their collective minds.
wearymicrobe said:mtn said:I'm trying to put together some documentation showing that a zoning change would negatively impact that value of some neighboring properties. To do this, I want the average sale price within a zip code, along with the average $/Sq Foot.
Does anyone know if that data exists anywhere? The average sale price is on zillow, but not the price per square foot (or the average size of the homes sold).
And you are going to do what with the data. City/counties/states give a rats ass about individual property values when dictating zoning. If the net gain on the other side of the equation is better unless you have a ot of pull or a lot of attorneys your not making them change their collective minds.
I'm going to email it to every member of the city council. Last ditch effort here. Have to convince 2 who were either absent (2 of them) or voted against our position (6 of them).
It isn't technically a zoning change, it is a conditional use permit, which has to meet certain criteria. One of the criteria is that it doesn't harm the property value of the neighboring properties. I call BS on their statement that it won't, but without data to back this up, I've got nothing to really give me any fighting chance on this.
Wouldn't the RMLS data contain what you are after? Do you know a realtor in the area you want to study? Not all realtors will be data nerds but eventually you would find one who could filter for what you want and export it.
RX Reven' said:MLS or County records.
This is the one. The county assessor's data is technically public information. It can be a pain to get, depending on the place, but it'll have the data you want.
EDIT: I actually think I'm wrong. The assessor is only concerned with the price of the parcel, not any buildings on it, IIRC.
Just Curious: what's the proposed zoning change?
Zoning change or variance? Something to keep in mind is what direction the neighborhood is going? Is there growth that might make the road its on busier? Residential property costs a city more money than it brings in on average. Commercial is when the city starts to make some money, industrial even more.
Does the town have a 5 year or 10 year plan somewhere? How does this variance fit in the plan?
There are a lot of old houses sitting on re-zoned commercial property that will sell for more because of the zoning. Look at the land price per sqft on commercial property in your research. Residential is more about price/sqft of the house. Apples and oranges there.
Hopefully this will keep you from being surprised by someone throwing these numbers at you.
You can check loopnet or crexi to find commercial and industrial prices in you area.
You can get close with the Zillow Data. https://www.zillow.com/research/data/
One of the reports does break pull just a certain number of bedrooms. I've been watching that closely to determine when to get back into the market.
bmw88rider said:You can get close with the Zillow Data. https://www.zillow.com/research/data/
One of the reports does break pull just a certain number of bedrooms. I've been watching that closely to determine when to get back into the market.
Which one? I can't figure it out.
OHSCrifle said:Just Curious: what's the proposed zoning change?
Giving conditional use permits to 3 lots that would put a parking lot next to my in-laws and behind my in-laws. It does not change the lots to commercial, but allows them to put the parking lots there.
A whole lotta obfuscation and curious legal interpretations going on here. Corruption going back 40 years that has led to all of it; the corrupt parties are no longer involved (though are friends with the business owner), though they may end up getting sued by either the neighbors (including my in-laws), the city, or the business. Frankly, my in-laws house should have never been built and their house, along with the house next door to them and the landlocked lot behind them that they'd been trying to buy for 25 years and is now going to be a parking lot, should have been part of the townhomes that were built at the same time.
Throw in numerous flooding issues, plans changing on the fly without notice, possible asbestos abatement issues, and the assumed loss of value for my in-laws (and increase in value for the business owners lots)... It has been a gigantic mess.
My in-laws should have moved years ago, but were stubborn. I told them in 2017 that I was not going to be involved in the fight, because I knew it was going to come, but here I am putting in hours and hours of research into it, basically for the last 6 months.
I predict that either way, this ends up going to court. I personally think that the city should claim eminent domain, buy up all the lots in question including my in-laws (and a reverse mortgage type of purchase for their neighbors who are literally in their 90s with cancer), and put up public parking and expand the adjacent park.
I'm always trying to make lemonade in situations like this. Is there a chance your inlaws will end up with a more valuable property? It runs about 10% of the cost to construct to scrape a building off of a lot. They may have the last piece of a puzzle for a developer. Have any of the other lots changed hands in the last year?
jgrewe said:I'm always trying to make lemonade in situations like this. Is there a chance your inlaws will end up with a more valuable property? It runs about 10% of the cost to construct to scrape a building off of a lot. They may have the last piece of a puzzle for a developer. Have any of the other lots changed hands in the last year?
No chance their property value goes up, for a few reasons.
In reply to mtn :
Zillow Home Value Index (ZHVI) You can then select the house type and what level you want to look at. It will be a big file though. 30-40 MB.
You'll need to log in to post.
