Unparalleled privacy & luxury awaits in this one-of-a-kind single-family 2.5 story home, nestled away in a cul-de-sac in perfect Middle Village location. First floor features a spacious living room with a cozy fireplace, open kitchen with stainless steel appliances, formal dining room, Brazilian floors throughout, and access to your oasis-like private yard with in-ground pool, outdoor fireplace, and access to your own private terrace for relaxation. Upstairs boasts 5 bedrooms with bamboo floors throughout and 1.5 bathrooms. Additional features include a full finished basement with full bath, radiant heat on the first floor & basement, central AC in the basement, first, & second floors, split system in the top floor master bedroom suite, private driveway & garage, and storage space throughout. Zoned for PS 49. Located close to the scenic Juniper Valley Park, transportation including the Q29, Q38 bus lines, express QM24, QM25, & QM34 buses to Manhattan, and M & R trains to Manhattan.