I love your request to "give it to you straight" however as Realtors, we have to be careful about making comments that would be considered "steering".
For any of my clients with this type of concern, I would say definitely think about re-sale. Statistics show that homes close to a busy intersection or close to commercial property are going to typically take longer to sell and they will be priced a little lower to compete with other properties that may not have these type of "deal breakers" for buyers.
But on the other hand, I am a firm believer that if you are in love with a home and it fits you, sometimes you compromise things like the location or a busy street. You really have to trust your gut but just know that when it does come time to sell that home and move on to your next, this will be an obstacle to overcome! Some folks like a challenge and this might be one for you!!
Best of luck in finding your next home!!
BUT, being that close to Federal will always be an issue, when prices go up, the price will always be lower on a home that backs to a busy street because other buyers will be thinking the same thing you are...."do I really want to live 40 feet from Federal?"
I think like you, buy now..win later BUT maybe this row home isn't it because Federal ins't moving anytime soon. I would keep looking, there are great deals out there but look at the up sides and down side, the changeables and the unchangeables, and you can find a great mix for you to take a chance on.
I am a huge fan of all of NW Denver, grew up there, lived there off and on, and would be happy to talk to you more about the area.
My advice would have to mirror Mr. Kosena's thoughts. Also, you mention that the home is only one house away from Federal. It is all about location, location, location. Although, areas do boom, you will also notice that homes on the outer edges near major roadways will not necessarily have the same increase. I am not sure if the home you are speaking of backs to Federal or has a visual view of Federal, but those could be factors that could severely impact the value of the home. Many buyers with dogs or kids will stay away from homes too close to major roadways and opt for homes that have more interior locations.
Always think about resale, you don't necessarily want to speculate, but look at the pro's and con's now as they may be very similar in the future.