Unfortunately it's unlikely one individual Realtor would be licensed in California, New York and Massachusetts but any of the big nation-wide brokerages like Re/Max or Keller Williams have offices in each of those states.If you would like a specific referral to an experienced or specialized agent in those localities, I would be happy to introduce you to Realtors I know through the relocation team at my brokerage.
The New York DMV's website has this page to help you apply for a duplicate title:http://nysdmv.custhelp.com/app/answers/detail/a_id/7/kw/replacement%20title/session/L3RpbWUvMTMzOTgyNzU0MS9zaWQvblNpbUNOLWs%3D
That problem comes up every once in a while when Zillow either has an issue with their server (IT stuff) or when the site is temporarily down for maintenance (also IT stuff). It's always very temporary. I bet you're happily searching again by now :)
Inventory in Columbia City is just barely above the lowest number we've seen since last year, which most buyers don't like, however...List price to sold price is the best it's been since prices fell a few years ago. As of June 4th, sale price in Columbia city was 100.22% of list price (for the previous month), which makes it the first time since prices fell that sellers in the area actually (statistically, combined) sold for more * so that's encouraging for sellers. And just so buyers keep it in mind too: Columbia City is one of the least expensive areas in terms of $/sqf in the city of Seattle.
Previous to being in real estate, I was a paralegal. Martindale.com is the search tool a lot of attorneys use to locate attorneys in other areas of practice. You can search by location and specialty. There were 11 attorneys in the directory search results for "real estate washington, dc".
It's not international yet - not even in Canada!Here's a link to a list of international or Ecuador-specific real estate sites:http://www.internationalrealestatedirectory.com/country/ecuador.htm
I think this Zillow video from the FAQ page is the best place to start:How to move the home location on the map: http://youtu.be/pr1Ff2eM324
If a house is listed for sale with a Realtor, the sellers usually sign an agreement that the listing will "expire" in a certain number of months if it's not sold. The sellers and Realtor have the choice to sign another agreement, but sometimes sellers don't renew the listing or decide to rent it out instead etc.In short: the sellers changed their mind about selling, even if temporarily.
My house has the same "problem," as does anyone with changes/upgrades/updates to their home which aren't easily quantified. Zillow arrives at a Zestimate by using recent sales of properties which are similar in some very basic ways: sqf, bedrooms, bathrooms, lot size, age of original construction etc. So two neighboring homes of the same size, age etc. but whose interiors are completely different (one nearly trashed, the other lovingly upgraded with high-end finishes) would probably have very similar Zestimates to each other.If you claim your home on Zillow, you can add the year of your remodel, but in my case it didn't change the Zestimate.
There are two bits of information from the Zillow FAQ pages I think could help you, depending on why the address is mislabeled. Below I cut and paste the link to a Zillow video and also the text of a FAQ regarding the source of incorrect location information. Also you can "claim" your home (in its current, mislabeled condition) on Zillow and then go to the property detail page and click the "Edit" dropdown menu. From there you can submit an error for review by Zillow staff. Good luck!How to move the home location on the map: http://youtu.be/pr1Ff2eM324I see some land parcels outlined on the map -- where does Zillow get this information? Can I correct an incorrect parcel drawing?Our parcel information, which outlines the lot on which your house sits, comes from various public sources, such as the county. To correct an incorrect parcel drawing, you will have to contact your county assessor's office.