Comments

You must log in or register to comment.

iepure77 t1_ir5xp60 wrote

Percent reduction over what time frame? 1-30 September?

30

michigician OP t1_ir60898 wrote

Percent of active listings, active in September, 2022 that have received a price reduction.

28

coffeeismydoc t1_ir6e36k wrote

How do some regions have over 100%?

14

lart2150 t1_ir6p7fy wrote

I assume if there is a price reduction and then the property goes off market before the end of the month? not sure if the data is good in Alaska with that 1517.

9

michigician OP t1_ir6sdrx wrote

There is either error iinin the data, or I used the wrong data field. It is probably my error, using active listings as the denominator instead of total listings.

5

azunaki t1_ir7mqn9 wrote

Does it handle if a property receives more than one price reduction?

5

classicalL t1_ir858vm wrote

You ruin your credibility when you don't notice your figure has impossible values like 105 and 405 in it. At least bother to proof your post before you do it...

3

RD__III t1_ir67x0k wrote

The MLS tracks every time a listing has been posted, as well as any price reductions. They likely just went through every listing and counted any that had a "price reduction" input after the most recent "closed" input.

6

thedrcubed t1_ir61npu wrote

Just from my area it looks like the more desirable locations are the ones dropping in price which isn't surprising because they're the ones that had gotten way overpriced

27

michigician OP t1_ir66f6n wrote

This data is significant because it shows the market response by region to the increase in home financing cost over the past few months.

17

dog_eat_god t1_ir6jy9c wrote

This is great info. Please do this each month if you're able to.

3

bradland t1_ir79t1h wrote

The question is, how does this compare to prior periods? Are price reductions a normal part of the market mechanism? That is to say, is it all that unusual for someone to list a home at a high price, then drop the price to find the market fit?

3

AaronsLennon t1_ir7q69p wrote

While I question the formula used I can indeed confirm that price changes have not occured in 2020 or 2021. Homes sold immediately and for well over list price in my area. I.e. home were not on the market long enough for the seller to change the price.

Price changes are normal in an average market but these numbers are all new to anyone who has been watching the market for only the last 3 years.

2

FarfromaHero40 t1_ir8eoy0 wrote

Yes excellent work - am looking to buy 07-08/2023. Love the overall trend down to the granular.

1

euclitorous t1_ir6i2me wrote

I fail to see what this has to do with major league soccer

8

RedRabbit37 t1_ir7zeqn wrote

I mean their expansion efforts have clearly become ridiculous. I mean Las Vegas, Indianapolis, San Diego, Detroit and Phoenix: ok. But every populated county in the US? No wonder their value is going down. The playoffs will be a mess that’s for sure.

2

JohnnyAK907 t1_ir6sktf wrote

I wish these images had darker lines separating the states. I'm looking for my region and the color gradients make both my brain and eyes hurt.

6

TheMostInterestedMan t1_ir7h1uz wrote

Ah yes, Phoenix is representing well; the market was hot and overstated for way too long. In my immediate area since 2012, the total housing price increase is over 300% which is just ludicrous.

6

elementofpee t1_ir7rroz wrote

Bring it on. Let the Great Reset begin.

4

Dr3d_Recs t1_ir7u4y2 wrote

Good ol' Boise Idaho with 1094%. I'm assuming the "10" was supposed to be for a neighboring county, but still, 94% is insane!

4

chasekaws t1_ir7osxl wrote

Oh, you mean to tell me that charging $1.5 million for a 600 square-foot shack in California is not sustainable…

3

heathenbeast t1_ir67qj5 wrote

I was just browsing Trulia in my area last night and noted to the wife that many of the homes had Reduced their pricing at some point; some significantly.

2

Notor1ousNate t1_ir8hry6 wrote

🤷‍♂️ I know this isn’t accurate based solely on the handful of counties I service and their representation on the map. Either your data is WAY wrong or the way you got your number is WAY wrong. Listings in one of the counts colored at 50% or more listings reduced sold at 98% of list price for September.

2

imnotsoho t1_ird8u1h wrote

Both can be true if the house sells for listing price after reduction.

0

jkatz20740 t1_ir6de8o wrote

Would be interesting to see this data over time.

1

tico_pico t1_ir6eotm wrote

How did you scale the home price data to overlay the map below it?

1

michigician OP t1_ir6tiko wrote

The data is by county. There are a number of data fields that provide counts of listings: active listings, pending listings, and total listings. There are also data fields for increased price listings, and price reduction listings. This map is based on reduced price listings divided by active listings times 100.

I am going to check if using the total listings as the denominator eliminates the problem that some counties show more reduced price listings than active listings.

2

tico_pico t1_ir6uvcy wrote

Sorry, I meant the actual code behind the map itself. I am curious about the back end on how you actually created the map.

2

michigician OP t1_ir8lbip wrote

The software is QGIS. The County map is US Census Tiger Cartographic shapefile set by county. I have to make some changes to the realtor.com csv file, the county id numbers which start with 0 lose the initial 0 so I have to add the 0 and convert the field to text using Libreoffice Calc.

3

Likely_a_bot t1_ir6zsja wrote

Price reductions tend to follow fluid dynamics. The markets where we saw the high prices first will receive the reductions first, with the late comers like my market cooling down in the next few months.

1

badchad65 t1_ir7fpre wrote

So how would this compare to say, any other point in history? I see a lot of red, but there’s now way for me to tell if it’s abnormal or not.

1

Lethlnjektn t1_ir7n27f wrote

Is there a way to stop from seeing maps/charts/graphs like this constantly in my feed or do I have to unfollow the sub entirely? I see a thing similar to this one Every Single Day

1

RDMvb6 t1_ir7pqoe wrote

It’s important to note that in most areas even tho the price of the home is going down, the total monthly cost of ownership is going up because the decrease in purchase price is outweighed by the increase in interest cost. This is still not good news for people who are priced out of the home market.

1

Sure_Surprise_1661 t1_ir7uil4 wrote

Some very serious omissions here. From when to September? Is this a reduction in the median?

I see my home county at 40-50 but it the median went up 30-40.

This can be very deceptive.

1

willwork4pii t1_ir81hl3 wrote

now show us time on market vs this time last year

1

aureliao t1_ir8hlgc wrote

Neat data. You have a lot of good feedback here. I agree with other commenters - 1) The color scale should have better contrast. 2) you need to check your data as there are multiple areas with 100%+ and even multiple with 1000%+. 3) Strong state borders would make it easier to identify.

1

atlantachicago t1_ir8hn83 wrote

Ok, can we stop raising interest rates now?

1

miso_very_sorry t1_ir8j3ly wrote

Do you post this data regularly anywhere? Would love to monitor this over time.

1

StreakPro t1_ir8kpk4 wrote

This doesn’t really matter when the interest rates are double of what they were last year. You’re essentially paying the exact amount and then some.

1

Comfortable-Boot-915 t1_ir6jwh3 wrote

I downvoted because i didnt know what "MLS" is and its frustrating that the author either assumed we would know or didnt care to clarify. I liked the comment about major league soccer that hinted at this.

−8

grammar__cop t1_ir7kmn5 wrote

Tbf (to be fair), it doesn’t take much effort to google ‘mls home listings’.

0