9011 Sandpiper Dr, Longmont, CO, 80504

Welcome to this beautifully maintained single-family home in the highly desirable and growing area of Frederick/Firestone! No HOA and not in a metro tax district! This home offers 5 bedrooms & 3.5 baths - suitable for all lifestyles. The main level provides ample living space including a family room, office, dining room, breakfast bar, and bright kitchen with newer stainless-steel appliances. The open staircase leads to 3 spacious upstairs bedrooms (2 with walk-in closets), a double vanity full bath, as well as the primary bedroom complete with luxury ensuite bathroom (2 closets, 1 being a large walk-in). The convenience of an upper-level laundry room is a real treat in this home. In the large, finished basement you'll find a custom wet bar with space for a full-size refrigerator, an expansive living area, a beautiful 3/4 bathroom, bedroom with large closet, and under-stair storage. Updates and upgrades can be found throughout this unique home, including freshly painted cabinetry, newer carpet, turf lawn backyard, basketball court, large covered patio with full length shades (perfect for entertaining year-round), extended front porch, gazebo with firepit, living room fireplace, solar panels, security system, dual radon system, sprinklers, granite countertops, class 4 roof, and much more! Appliances included are a double gas oven w/ air fryer, refrigerator, microwave, dishwasher, and washer/dryer. The 3-car tandem stall garage offers overhead storage along with nearly 100ft of parking on the side for your recreational toys or professional vehicles. The secluded backyard is bordered by gorgeous mature trees and is perfect for entertaining or quiet relaxation. The No Name Creek neighborhood is well-maintained, quiet, and friendly. Two beautiful parks, 2 amazing golf courses, and unobstructed mountain views are within walking distance of the home. You will also enjoy the convenient and nearby access to I-25 & HWY 52, along with plenty of shopping & restaur...