Welcome to this extraordinary home, perfectly positioned on a quiet street corner. This home offers an unmatched layout tailored for extended multi-generational living or flexible lifestyle needs. Spanning approximately 4,700 square feet of combined living space, this remarkable property seamlessly combines classic charm with incredible functionality. The main house features 4 bedrooms, 2 full baths, and 1 half bath alongside an attached, fully independent in-law residence also boasting 4 bedrooms, 2 full baths, and 1 half bath! Enter the main house and welcomed by a sunlit living room enhanced by bright skylights and rich hardwood floors! Two cozy fireplaces (one gas, one wood). This home has an ideal indoor-outdoor flow leading to a wonderful 3-season room and alow-maintenance composite deck that is perfect for morning coffee or evening relaxation! Designed for funtionality and comfort, the attached in-law residence features hardwood flooring on the first floor, a convenient walk-in pantry, its own private entrance, and a dedicated deck overlooking the back yard that is perfect for entertaining! A separate one-car garage to complement the main residence's two-car garage! Both sides of the home feature finished basements that offer endless possibilities for home theaters, gyms, or playrooms, along with abundant storage options throughout. Situated nicely on a corner lot, this home combines tranquil neighborhood living with unbeatable convenience! Located just minutes from downtown Marlborough, Apex Entertainment, and major commuter routes including Route 9, 290, 495 and the Mass Pike.