This amazing two-family colonial home has been completely upgraded with high-quality finishes. Upon entering through custom double doors, you are welcomed into a sunny and bright grand foyer featuring large windows, two-story ceilings, and a sweeping staircase. The first floor includes 18-inch porcelain tiled floors, a spacious formal dining room ideal for family gatherings and holidays, a formal living room that can also serve as an office, a powder room, and a large custom kitchen with a substantial center island with seating for four. The family room boasts custom moldings, window treatments, a fireplace, and sliding doors that lead to a resort-like backyard. Step outside to your private paradise, complete with a custom heated saltwater pool, pavers, and an outdoor stereo system, creating the perfect environment for entertaining and relaxing on hot summer days. On the second floor, you will find a large primary bedroom suite that includes a double-door entry, a spacious walk-in closet, and a private bathroom with an oversized walk-in marble shower featuring a rain shower and a jacuzzi tub. This suite also has its own zone of radiant heating. Down the hall are three additional large bedrooms, each with custom window treatments, professionally organized closets, and a full bathroom. The fully finished basement is perfect for a home theater, recreation room, or gym. It also includes a laundry room, a half bath, ample storage, and a large garage. There is a side entrance to the apartment, which features brand-new appliances and high ceilings. Home is equipped with multi-zone hot water baseboard heating, radiant heat, central air conditioning, a security system, and an intercom system. The home is situated on a quiet street in the heart of Tottenville.