A rare opportunity to own a beautifully restored Queen Anne Duplex in Oakland's coveted Grand Lake neighborhood, where historic character, thoughtful craftsmanship, and modern infrastructure come together in remarkable fashion. Originally renovated to the studs in the 1990s, this architectural gem underwent a comprehensive restoration that included a new concrete foundation, updated plumbing and electrical systems, and new windows throughout. The striking blue exterior, welcoming covered porch, and mature gardens create an unforgettable first impression.The vacant owner's residence spans approximately 2,184 square feet and offers 3 bedrooms and 1.5 baths. Refinished oak hardwood floors, designer lighting, and abundant natural light enhance the home's timeless appeal. The sun-drenched dining room doubles as a sunroom, creating a warm and inviting gathering space. A contemporary loft-style bedroom opens to a spectacular rooftop deck with sweeping hill views. Adding to the home's unique legacy, piano keys are inlaid within the hardwood flooring, which is a tribute to the musician-owner who handcrafted many of the home's details, including the custom cabinetry milled in the on-site workshop. Local lore recalls rooftop music gatherings beneath the stars, lending a rich creative spirit that still resonates throughout the property. The updated lower unit offers 2 bedrooms, 1 bath, approximately 1,284 square feet, and is occupied by a tenant paying market rent. Recent improvements include a remodeled kitchen, updated bath, and contemporary lighting. Modern amenities include a leased solar system with battery backup, a two-car garage, workshop space, and additional tandem driveway parking. The two car garage + workshop have great ADU or third unit potential! A charming rear deck provides the perfect setting for outdoor dining, entertaining, and relaxed evenings with friends. Ideally situated moments from Grand Lake and Lakeshore's beloved shops, cafés, restaurants, and farmers market, as well as the iconic Morcom Rose Garden, this exceptional duplex offers a rare blend of historic beauty, income potential, and modern sustainability in one of Oakland's most sought-after neighborhoods.