Since 'Brownsrone' could refer to heroin. Maybe Holmes living in the Brownstone could indicate this life of baing an unpaid consultant with the NYPD along with a perfect apprentice and lots of interesting cases could just be a dream under the influence of heroin. The perfect escape from reality. Funny name for a home 'Brownstone'. Strange that a heroin addict should call brownstone home.
Just a thought...