This stunning 2012-built all-brick duplex combines modern construction with premium income potential on a mid-block location in Little Neck. Featuring an oversized 25x52 building footprint on a generous 40x100 lot, this immaculate two-family home offers 3BR/2BA over 3BR/2BA with finished basement and separate entrance - ideal for owner-occupants seeking rental income or investors looking to maximize returns. Eastern exposure floods the home with natural light, while central air, separate utilities including 2 electric and 2 gas meters, and detached garage enhance operational efficiency. The finished basement with walk-out access provides valuable additional living and storage space for the units above. Excellent transportation includes the LIRR for direct Manhattan access, multiple bus routes (Q36, Q12, N20G, N20X, QM3), and easy highway access via the LIE (I-495) Little Neck Parkway interchange, and Northern Boulevard. The home sits within School District #26, featuring PS 221 and MS 67, while being close to shopping and recreational amenities. This turnkey property in excellent condition represents an exceptional opportunity that you don't want to miss!