A spectacular barrel-vaulted, two-story foyer greets you upon entering this truly unique 3,450 sf home. Pocket French doors lead to a living room with inlaid hardwood floors. This room flows seamlessly into a formal dining room finished with extensive custom cherry millwork. A well-equipped eat-in kitchen opens to a spacious family room with a raised hearth fireplace, bay window seat, and direct access to a half bath and 400 sf outdoor deck. A laundry room and walk-in pantry complete the first floor. The second floor features a large primary bedroom with a tray ceiling, fireplace, walk-in closet with ample storage, and a luxurious master bath equipped with a steam shower and heated marble floor. Three additional bedrooms, two additional full baths, a linen closet, and a stairway to attic storage round out this floor. The main residence is enhanced by a ground-floor office with a separate exterior entrance, an in-ground pool, central air, central vacuum, a security system, and a Generac generator. A subsidiary apartment over the two-car garage has a kitchenette, living/dining area, bedroom, bathroom equipped with a deep whirlpool tub, and a separate entrance making it perfect for an in-law, au pair, or potential rental income. On the town line, this home has the convenience of a West Hartford location with much lower Farmington taxes providing easy access to shopping, dining, recreational and healthcare facilities.