849 Union Avenue in North Boulder offers a modern farmhouse for sale just one block from Wonderland Lake, Foothills Community Park, and miles of trails, combining contemporary design with an ideal Boulder location near Broadway shops, restaurants, and top-rated schools. Built in 2021, this 4-bedroom, 5-bathroom home features vaulted ceilings, expansive windows, wide-plank oak floors, and a floor-to-ceiling stone fireplace that anchors the open-concept living space. The chef's kitchen includes black walnut cabinetry, a large island, walk-in pantry, and a Nana-style pass-through window connecting seamlessly to the outdoor patio for indoor-outdoor living. A formal dining room and light-filled informal dining area provide flexible entertaining spaces. The main level also includes a bedroom with en-suite bath, ideal for guests or a private office. Upstairs, the primary suite offers a private deck, spa-like bathroom with soaking tub, walk-in shower, and dual vanities, along with two additional en-suite bedrooms and a lofted flex space. The unfinished lower level is a full height daylight level offering future potential for additional living space. Solar adds efficiency, while a two-car attached garage and mudroom support everyday functionality. Surrounded by greenery and mountain views, this North Boulder home delivers modern living with direct access to outdoor recreation and neighborhood amenities.