25-11 Ditmars Boulevard 11

This charming century -old Ditmars Boulevard Colonial revival house is on the market for the first time in nearly two decades. The prettiest house on this coveted block, a short walk from Astoria Park and P.S. 122 has been stylishly gut-renovated and retains many of its original details. This prime turnkey property , a rare urban retreat, features a magnificent flowering cherry sidewalk tree that is an Instagram showstopper. Pass through the front cast-iron gate and come up the steps to the columned front porch, which is shaded by a pair of mature crepe myrtle trees with white flowers and red berries. From the glass knobs on Douglas fir doors to the semi-custom shelving in the illuminated closets, every detail of the single-family house has been thoroughly researched and thought out. The solid-wood front door with the brass knocker brings you into the spacious living room, which has a closet, oak hardwood floors and a central wooden staircase. The formal dining room is off the chef"s kitchen, which has an addition with a breakfast nook. It has marble floors, high-end appliances and custom cabinetry. If the kitchen looks familiar, its because it was featured in the iconic "bring home the milk " scene in the 2009 Tony Scott film, "The taking of Pelham 123." Denzel Washington was in the kitchen and phoned in his lines from the primary bedroom upstairs. A copy of the script he left behind is included in the sales price. Open the sliding glass doors to the balcony that leads to the back yard where you'll see the golden blooms of the spirea and the pink rose of Sharon trees. Walk down the stairs and pick a couple of figs to eat on the covered patio. The attached one-car garage provides entry to the street-level basement, which is finished with the same level of detail, including Douglas fir doors with glass knobs and illuminated closets, as the rest of the house. Upstairs, there are 3 bedrooms and a full spa-like bath that has a soaking tub, a marble floor in a classic black and white basketweave pattern, an English pedestal sink and mirrored Robern medicine cabinet. This oasis away from it all yet in the middle of everything is only six blocks from the N/W subway and a half block from the Q69 bus stop. Special features : Pella windows (architect series), Sub-zero refrigerator, Viking range and microwave, Miele dishwasher, custom kitchen cabinetry and granite countertops.