OK... STALE listings...

"Piss or get off the pot!" (My grandma)

"Pish or get off the pot!" (My grandpa)

I'll see your three years and raise you, 4 months.

http://streeteasy.com/nyc/sale/91856-condo-135-east-54th-street-midtown-new-york

w67: I think you are off-base about 290 WEA. My understanding is that #14A apartment was legitimately off the market for two+ years after the owners bought elsewhere, then changed plans.

Do you think it's still in contract?
http://streeteasy.com/nyc/sale/32128-multi-122-pierrepont-street-brooklyn-heights-brooklyn

"Sh*t or get off the toilet.

3yrs on market....

http://streeteasy.com/nyc/sale/557596-coop-290-west-end-avenue-upper-west-side-new-york

Please feel free to add... : ) "

I think this one belongs on the price slashers thread as well. 33% off original ask now? Ouch...

You guys want to know the challenge in cleaning up the data and the reason why we designed the methodology of our new analytics to focus on fresh stuff, not stale stuff, here take a look

http://streeteasy.com/nyc/sales/midtown-all-manhattan/status:pending|has_address:1?page=42

Sorted by NEWEST, in contract, must have address...start at the very end Page 42 and check out the list. These would all be counted as PENDING if not for proper cleansing. The issues go way deeper than this too, u can imagine now why we took 10 months to come up with proper solution to properly measure this market, as it changes!

Well they are certainly not counted in our own analysis and market reports either.

The goal is to be as complete as possible, in terms of listing coverage, but at the same time, keep bad listings out. Those are at odds.

There are lots of listings we don't let into the site at all because of data quality issues/impossibilities, and many we purge manually later. But obviously even with the many checks we do, and we are constantly adding more, there will be some which are included in the site, but nevertheless "unlikely".

We use completely different criteria for choosing what we include in our analytics data sets. Anyone who wants to produce a statistic should too.

great to hear..thx to SE for ongoing data integrity efforts...question..do you guys see some listings switching daily between listing states? Active-offmkt-active-csgn-active-offmkt-active-csgn-etc..etc..??

what the heck are these? no way it can be the brokers that change the status 3-4x a day, everyday?

SE, I've noticed on that on a rental listings, you sometimes (very infrequently) put it as UNAVAILABLE even though it is available & being marketed by the broker's site. These are very clearly exclusive brokers at major firms that I'm talking about.

Can you explain what goes into marking a property as UNAVAILABLE?

i cant speak for SE, but I can tell you there are times internally when a PERM OFF MKT status update is automatically triggered for a listing. there are a few other internal triggers that we discovered that can sometimes play havoc with listing states. The whole core of the sharing system needs an upgrade, imho.

Unavailable means that's it is no longer on the market, but we can't conclusively say more.

Unfortunately this industry seems to have never seen a listing status that it did not like. Now we have a dozen.

Take an example where a sales listings is removed from the market. In some cases the broker will say definitively what has happened (it sold, was delisted, etc.), other times, they don't say, and we are left with "unavailable". If we later find that the listing sold or was temporarily off-market, etc., then we update the status. But we don't believe in guessing. We would much rather tell you that we don't know more.

We also gets lots of information that is very specific, but plain wrong. Over time we have learned to test everything. If we have multiple sources of info and they differ, then we often need to manually review the information, ask the brokers involved, etc., and in those cases "unavailable" is what we say until we know...

Streeteasy, you do a great job and the unavailable status makes a lot more sense now.

Streeteasy pls talk to ud about buying his 'new platform'. The mkt is too fragmented as is, no need to bifurcate the data mkt. You can give him a tab, buy out his 'in cost' for the data platform and give him warrants for upside if se gets bgt or IPO. Or you can talk to sam miller. Time to start consolidating.

As to shit or get off. You guys are missing my point entirely. The fact these ninnies decided NOT to sell, is much a function of bubble mentality as to 'legit' reason to not list. Did the maxim of 'maximize' profits die over the 2 yrs these ninnies went 'off' mkt? Mr thinkz not, they were told by every person, 2007 was a blip 'it'll come back.' well it didn't and it ain't. As nyc re drifts lower (and it will), there will be less and less of these 'rent out, try again' mentality. Do you really think if they thought I would sell for $2.5mm in 3 yrs they would not have been happy to get ahead of the mkt and sell for $3mm at 2007? In a bubble, as prices increase supply decreases as more and more ppl decide to 'hold' for better prices, weird huh?

"Unfortunately this industry seems to have never seen a listing status that it did not like. Now we have a dozen. "

This is very true. We broke down the market into only 4 possible states: ACTIVE, OFF MKT, PENDING, and SOLD. But in the real world, ACTIVE can comprise the following listing states: active, anxious, desperate, off accepted, contract out, etc.. There is no need. I would bet that if there is an improvement down the road, it cuts down possible listing states to 6 or fewer. Multiple sources for same listing data clearly shows that improvements are needed. We find internal triggers to be responsible for alot of off mkt status changes. Determining all the situations when you can legitimately keep it 1 STATE or ANOTHER and when not, was quite challenging. Manual review and checking with the listing agent becomes the only alternative..but it doesnt have to be this way. This industry can change for the better and start to enforce data integ breaches, and deep down, I think these will come with time. I hope.

As to W67th, lol - thx for idea..yes, buy me please for $5m..I didnt even release yet?? But I dig..We always consider SE good friends, they did an amazing job with cleaning this data - especially with syncing up listing side with sold side - and they built a very successful community here. Clearly they know what they are doing.

w67: We get your point, and you're basically right. You're just off regarding the situation at 290 WEA. Your inferences about what went down there are reasonable, but I'm pretty sure you're wrong.