Rare opportunity to own a fully detached colonial with a legal doctor's office on an oversized 108 x 100 lot (R2A zoning) in prime Little Neck, just off Northern Boulevard. The main residence features a gracious living room with fireplace, formal dining room, eat-in kitchen with breakfast nook, family room, three bedrooms plus an additional flex room, a finished walk-up attic with half bath, and a full finished basement-ideal for a home office, playrooms, guest quarters, a reading room and more. The professional office offers a separate entrance, reception, multiple exam rooms, break room, half bath and a finished lower level with additional exam, records or storage rooms. Enjoy a private, landscaped, fenced yard, patio, and a 2-car garage with attached covered access to the main residence. Exceptional, easily accessible location that delivers the perfect blend of residential privacy and professional convenience.