This house is located at 5 Adams Street, Northwest. The listing says:
“Here is an opportunity to move into million dollar neighborhood for under 600k! This property is perfect for homeowner or investor! The property is zoned R-4 and can be converted into condos or you can build up to 40 feet high as well. Property is being sold as-is.”
You can see more photos here.
This 3 bed/1 full/2 half bath is going for $599,000.