I know the Westgreen house is on a major thoroughfare through Katy so it will have a downward adjustment compared to comps that are on less busy streets.  

We did that on a Seattle property a few years ago and were able to avoid digging up the planters, sidewalks and street which saved a ton of money.

Before buying call the city to ask what that street allows for, do not ask about the specific house or you can open a can of warms.Hire also a Fire consultant that knows the bylaws in the area.If you really want to buy an illegal unit and legalize it later, then also hire an experienced architect/engineer that is used to legalize rentals.The most "friendly" area for illegal units is Downtown Toronto, there is an extreme need for apartments , if they would shut down all illegal units, there would be thousands of tenants on the street.If you still think about buying an illegal unit and keep it as is, make sure you comply with Fire cod - that is non negotiable - and have an exit strategy in case you are sooner or later shutdown by the city.If you get shutdown and cannot or want to legalize it, you will have to change doors or exits, remove kitchens, etc... etc....

showed up at an Open House you were holding and stood on the street outside and told them "This guy is full of crap, I can get you a WAAY better deal, here's my card", what would you think of them?

We started with our vacation rental property and now looking into buy and hold properties.We have a great 1bd/1bth condo in Kihei, Maui that is not exactly water front, but we are directly across the street from Kamaole II beach (about 50 yard walk or so).

It is off street parking but shared with other tenants which I think is a turn off.

I had a house recently where the subject and listing comp (which was a listing in pre-foreclosure) were on the same street and when I drove down the street which was a culdesac, it was like a block party of angry homeowners.

Drive every street.

The land goes from basically the house to the next house on Burns Street and back to near the end of Tracy Street.

I understand your attitude, especially when people learn from gurus and then go hit the streets as if they have an education in RE.Most don't have a clue, they have gone down the wrong road trying to learn RE as some assembly line system and really, they cause problems in the market submitting contracts as if doing so is just some simple formality they need to do to tie up a property.