24168 Saint Mary Court Welcome home to this adorable & updated cape cod, walking distance to schools, parks, and all that downtown Farmington has to offer. And in a prime location for easy & convenient freeway access. This meticulously maintained home is where fresh, modern updates & style meet mid-century character & charm. This one is truly a turn-key gem, fully updated from mechanicals to aesthetics. The kitchen and dining room were fully gutted--walls torn down, in 2019, and the traditional bones were reimagined aligned with today's popular open-concept lifestyles, including a large kitchen island with gas cook-top, all new cabinets, granite counters, stainless steel appliances, and fresh lighting. Cork wide-plank floors flow mostly t/o the main floor and are sharp, comfortable, sound absorbing, and eco-friendly (2019). This redesigned open floor-plan still maintains cozy character with a bright window bench and built-in book shelves in the living room, and a sunroom off the family room with glass-paned folding doors, vaulted ceiling, skylights and windows galore! The second floor offers 4 bedrooms, some w/character filled slanted ceilings, and built-in cubbies, and new carpet in 2023.. Full bath refreshed in 2021. Primary bedroom with wood floors, ample closet space, and en-suite bath remodeled in 2019. There is a secret hiding behind the wall in the upper hall--plumbing for a second floor laundry, accessed from inside the primary closet. Outside this home boasts curb appeal and a backyard with Trex deck (2025) w/ privacy wall, & patio, perfect for entertaining! Major money updates include: 2025--new electrical, roof, skylights, gutters, Trex deck, concrete, and patio; 2024--furnace and a/c; new sewer line in 2020. Wallside windows w/transferrable warranty, Electrical lines to the home have been buried for a clean exterior appearance. Basement offers unfinished storage and is plumbed for a bath. Turn the key, unpack the boxes, and relax in your beautiful new home!