EXCEEDINGLY UNIQUE OPPORTUNITY! This beautifully updated 3,800-square-foot residence offers an exceptional combination of style, space, flexibility, and income potential--plus two stunning 2-bedroom rental apartments and an impressive 1,600-square-foot heated garage / warehouse / hobby space. The main residence has been tastefully renovated with fresh neutral tones, gleaming hardwood and ceramic floors throughout--no carpeting! The gourmet kitchen features high-end built-in Monogram appliances and honed stone counters, while all bathrooms showcase luxurious, top-of-the-line finishes. Beyond the formal living room is a huge family/dining gathering space featuring modern tile flooring, tongue-and-groove walls, a fireplace, and an abundance of windows that fill the room with natural light. The first-floor primary suite includes a spacious bedroom, den/study/exercise area, luxurious bath, and walk-in closet. The second floor offers three additional bedrooms plus a large vaulted bonus space with endless possibilities--create an additional apartment, oversized home office, recreation room, or another impressive primary suite. A dry basement provides excellent storage, while the attached 2-car garage includes substantial additional workshop/storage space--nearly the size of a four-car garage. Enjoy summer days relaxing on the covered front porch, or head to the rear deck overlooking the beautifully landscaped yard and in-ground pool. And then there is the HUGE 50' x 32' heated multi-car garage, complete with two 12' x 14' overhead doors and a half bath. Above the garage are two 2-bedroom apartments (approx 800-square-foot each), these units with their own private driveway and parking. Both the main residence and detached garage/apartment have new roofs within the past two years. Whether you're looking to escape the city, accommodate extended family, generate rental income, or pursue a business venture - whatever your need, this property will not disappoint!