Built in 1894 and once home to the Shamrock Tavern and then a millwork shop, this Lower Garden District spot is up for grabs for $650,000. The 4,400-square-foot space has a ground floor commercially-zoned space that probably needs some work (depending on what the buyer wants to turn it into, of course), and three very decent looking apartments with hardwood floors, high ceilings, and a wrap-around balcony. Two of the apartments are two-bedrooms, and there's one loft-style one-bedroom set-up. Located on the corner of Constance and Thalia Streets, just a block off of Magazine, the place was on the market for $275,000 in its unrenovated state (the barroom signs were still covered) before selling in 2008 for $245,000. Those already getting their hopes up for a Shamrock Tavern revival should simmer down. The building is zoned B1A, which means no cocktail lounges allowed.
· Listing: 1245 Constance St. [Keller Williams]