174 Howard Street NW Discover an exceptional investment opportunity that seamlessly blends luxury, versatility, and outstanding income potential. Thoughtfully renovated from top to bottom, this expansive residence is designed with a duplex-style layout, making it ideal for owner-occupants, multi-generational living, or investors seeking strong cash flow. The upper level features a beautifully appointed 4-bedroom, 2-bath residence with spacious living areas, while the fully finished terrace level offers an equally impressive 4-bedroom, 2-bath living space complete with its own private living area, providing outstanding flexibility. FHA buyers can enjoy the opportunity to live in one residence while generating rental income from the other to help offset their mortgage, while investors will appreciate the property's potential for room-by-room rentals, corporate housing, or other income-producing strategies. Extensive renovations provide peace of mind and modern appeal, including a new HVAC system, new roof, new siding, updated electrical and plumbing, new flooring, beautifully renovated kitchens and bathrooms, fresh interior paint, and stylish contemporary finishes throughout.Completely move-in ready with significant capital improvements already completed, this rare offering delivers the perfect combination of modern living, flexibility, and exceptional long-term investment potential.