Exceptional investment opportunity in Schenectady's Historic Stockade District! Situated at desirable Lawrence Circle and directly across from Arthur's Market & Café, this well-maintained duplex features two spacious 2-bedroom, 1.5-bath units, each with separate utilities and private laundry. Rarely found in the Stockade, this property offers off-street parking and is not located in a flood zone. Located in one of the oldest residential neighborhoods in the United States, the Stockade is known for its beautifully preserved architecture, tree-lined streets, rich history, and vibrant sense of community. Its timeless charm has even served as a backdrop for productions including HBO's The Gilded Age. Just one block from Riverside Park and the Mohawk River, residents and guests enjoy easy access to walking paths, restaurants, breweries, shops, and downtown Schenectady's entertainment district. The vacant 45 Front Street unit offers flexibility for an owner-occupant, long-term tenant, or expanded short-term rental operation. The adjoining 47 Front Street unit is currently operating as a successful Airbnb and will be delivered fully furnished, providing a rare turnkey opportunity for buyers looking to continue a proven short-term rental business from day one. The property benefits from strong visitor demand generated by Union College, Proctors Theatre, downtown events and weddings, Rivers Casino, GE Vernova, Ellis Hospital, and travelers seeking weekend getaways from New York City, Boston, New Jersey, and beyond. Whether you're looking to offset your mortgage by living in one unit while generating income from the other, expand your investment portfolio, or operate a turnkey Airbnb in one of the Capital Region's most iconic neighborhoods, this versatile property offers exceptional opportunity, character, and location.