This exquisite brick-front Colonial home in sought-after Farmington Village offers a luxurious lifestyle with its stunning blend of elegance and comfort. Spanning over 6200 sq ft, the interior features five spacious bedrooms and four- and one-half bathrooms, including an expansive primary bedroom featuring a double-sided fireplace, an ensuite bath with a lavish soaking tub, and a walk-in tiled shower. The updated gourmet kitchen, complete with quartz countertops, 42” soft close cabinets, as well as high-end Wolf appliances, including a double "steam" wall oven and induction stove top in the huge center island. And a Sub-Zero refrigerator too - perfect for the culinary enthusiasts! Off the formal entry foyer, you will find French doors leading to an elegant office/den with a full wall of built-in bookcases (which could be converted to a main-level guest bedroom if need be). Enjoy cozy evenings by the brick fireplace in the family room or entertain in the rear sunroom overlooking a beautifully landscaped .42-acre lot featuring extensive hardscaping and a serene, fenced rear yard that backs to trees for added privacy. Gorgeous hardwood floorings enhance elegance throughout, while crown moldings and recessed lighting add a touch of refinement. A fully finished basement offers additional living space, complete with a second kitchen and full bath, ideal for an in-law or au pair suite. Additional upgrades include: Dual staircases, 9' ceilings throughout, multiple zone HVAC w/ "gas heat", main level laundry, architectural shingle roof, newer high-end water heater, top of the line full house water filter treatment system, as well as a reverse osmosis system, central vac, landscape irrigation sprinkler system, and a side-load 3-car garage with ample off-street parking. The walk-in entry community pool offers a refreshing escape along with a kiddie pool, tennis courts, and clubhouse. With its thoughtful design and high-end finishes, this home is a true sanctuary, inviting you to create lasting memories in a setting that feels like a retreat.