A Rare Waterfront Retreat with Unforgettable Views. Perched above the bay at the water's edge, this custom-built home captures breathtaking views of bridges, passing boats, sparkling city lights, and dramatic coastal sunsets. Thoughtfully designed with timeless elegance and everyday comfort in mind, it offers the perfect balance of luxury and warmth. The upper level features a stunning primary suite with panoramic water views, a private balcony, spa-inspired ensuite with clawfoot tub, walk-in shower, and spacious walk-in closet. Two additional generous bedrooms, a full bath, and a convenient laundry room complete the level. On the main floor, the open-concept kitchen and dining area showcase custom cabinetry, a Dacor propane cooktop, double wall ovens, large island, pantry, trash compactor, and travertine flooring. The inviting living room features a propane fireplace insert and a wall of windows that perfectly frame the spectacular waterfront scenery. Outdoor living is equally impressive with a spacious entertaining deck that flows to a wraparound deck and covered porch, creating the perfect setting to relax or host family and friends. The beautifully landscaped backyard offers lush lawns, mature landscape, and a covered BBQ area with a built-in propane hookup. A detached triple garage with electric openers, ductless heat pump, and covered side storage adds exceptional functionality. Situated on ¾ of an acre in the sunny, sought-after Glasgow neighborhood, this remarkable property offers an unmatched waterfront lifestyle where every day begins and ends with an extraordinary view.