Welcome to this extraordinary 4,600 sq. ft. red brick estate in the high desirable Millidgeville, where elegance meets timeless architecture and million dollar water views define the lifestyle. Perfectly located just minutes from UNB, the hospital, schools, yacht club, and golf course etc. The grand foyer with a sweeping spiral staircase and 20 foot ceilings makes a dramatic first impression. Sunlight floods through oversized windows, accenting marble floors, gleaming hardwood, and refined details. A formal dining room and family room flank the foyer, while the living room with built-in bar flows seamlessly to the breakfast area and kitchen. All opening to an oversized deck with breathtaking water views. This home offers 4 bedrooms and 4.5 baths, including two primary bedrooms with spa-inspired ensuites. The main-level suite features a private office, while a conveniently located laundry on the same floor enhances everyday ease, together creating a thoughtful layout ideal for in-law accommodation, multi generational living, or single level comfort. Upstairs, the second primary boasts dual a private balcony, and stunning river vistas. Nearly 2,000 sq. ft. walk-out basement includes a cold room and full bath, with endless potential for customization or expansion. A triple wide driveway, double insulated garage, 400 AMP service, and landscaped yard with fenced garden complete this rare offering. Truly a once-in-a-generation opportunity! Book your private showing today! (id:63267)