Start of property details
Property Details
The best of Boulder living awaits in this stunning 5BD / 4.5BA modern farmhouse featuring three levels of premium finishes and elegant custom details, a seamless indoor-outdoor layout, exceptional storage and a sought-after Newlands location. Built in 2016, this 4, 857 SqFt showplace delivers designer style and bespoke quality with soaring ceilings, 6"oak floors, Lvl 5 smooth-finish drywall, oversized windows trimmed with wood shutters, Harmoni cabinetry and Rocky Mountain hardware. A wraparound covered porch and gracious foyer introduce the sprawling great room featuring a generous footprint for seating and dining alongside a gas fireplace. Prepare to fall in love with the open gourmet kitchen featuring custom cabinetry, a 10-foot-long reclaimed pine island / breakfast bar, Ann Sacks tile backsplashes and Thermador appliances. A butler's pantry with Miele coffee maker, storage pantry and pet station complete the space, while the adjacent mudroom ensures effortless arrivals and departures. A beautiful study and powder room complete the main floor. Above, discover the rare convenience of four spacious and bright upstairs bedrooms with walk-in closets, including the stunning owner's retreat with an en suite spa bathroom, a secondary suite and two more bedrooms with a Jack-and-Jill bath. An upper-level utility room makes laundry day a breeze. Fun and games await on the fantastic lower level finished with polished concrete floors, a wall of cabinetry, 400+ bottle temp controlled wine cellar, a media lounge and a well-stocked bar area. A bed and bath on this level are perfect for guests. Outdoor entertaining is irresistible on this flat 7, 803 SqFt lot surrounded by split-wood fencing and mature landscaping. Enjoy al fresco dining on the covered patio or garden in the raised, irrigated planter beds. Extensive upgrades include Lutron lighting and shade controls, Sonos audio and a Generac generator. Outstanding location close to NoBo Park and Rec Center, trails, and Ideal Market.
Property Highlights
Location
Property Details
Building
Community
Local Schools
Interior Features
Bedrooms and Bathrooms
Rooms and Basement
Area and Spaces
Appliances
Interior Features
Heating and Cooling
Building Details
Construction
Materials
Terms
Terms
Taxes
Tax
Heating, Cooling & Utilities
Utilities
Lot
Parking
Exterior Features
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_1008696","AboveGradeFinishedArea":"3278","AccessibilityFeatures":null,"Appliances":"Gas Range\/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal","ArchitecturalStyle":"Farm House, Contemporary\/Modern","AssociationAmenities":null,"AssociationFee":null,"AssociationFeeFrequency":null,"AssociationFeeIncludes":null,"AssociationYN":"0","AttributionContact":"3033458619","Basement":"Full, 90%+ Finished Basement, Built-In Radon, Sump Pump","BasementYN":null,"BathroomsFull":"3","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"1579","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Wood\/Frame, Composition Siding, Painted\/Stained","Contingency":null,"Cooling":"Evaporative Cooling, Ceiling Fan(s)","CountyOrParish":"Boulder","CoveredSpaces":"2","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"East","DoorFeatures":null,"Electric":"Electric, Xcel Energy","ElementarySchool":"Foothill","Exclusions":null,"ExteriorFeatures":null,"Fencing":"Fenced, Wood","FireplaceFeatures":"Insert, Living Room, Masonry","FireplaceYN":"1","FireplacesTotal":null,"Flooring":"Wood Floors","FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Radiant","HighSchool":"Boulder","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Study Area, Satellite Avail, High Speed Internet, Eat-in Kitchen, Separate Dining Room, Cathedral\/Vaulted Ceilings, Open Floorplan, Pantry, Jack & Jill Bathroom, Kitchen Island, 9ft+ Ceilings","InternetAddressDisplayYN":null,"LaundryFeatures":"Upper Level","Levels":"Two","ListingTerms":"Cash, Conventional","LivingArea":null,"LotFeatures":"Curbs, Sidewalks, Lawn Sprinkler System, Level","LotSizeArea":"7659.00","LotSizeSquareFeet":"7659.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Casey","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"7d6511333e56d8d5a8564b3171087d35","OfficePhone":"303-487-5472","OtherParking":null,"Ownership":null,"ParkingFeatures":"Garage Door Opener, Alley Access","ParkingTotal":null,"PatioAndPorchFeatures":"Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"The best of Boulder living awaits in this stunning 5BD\/4.5BA modern farmhouse featuring three levels of premium finishes and elegant custom details, a seamless indoor-outdoor layout, exceptional storage and a sought-after Newlands location. Built in 2016, this 4, 857 SqFt showplace delivers designer style and bespoke quality with soaring ceilings, 6\"oak floors, Lvl 5 smooth-finish drywall, oversized windows trimmed with wood shutters, Harmoni cabinetry and Rocky Mountain hardware. A wraparound covered porch and gracious foyer introduce the sprawling great room featuring a generous footprint for seating and dining alongside a gas fireplace. Prepare to fall in love with the open gourmet kitchen featuring custom cabinetry, a 10-foot-long reclaimed pine island\/breakfast bar, Ann Sacks tile backsplashes and Thermador appliances. A butler's pantry with Miele coffee maker, storage pantry and pet station complete the space, while the adjacent mudroom ensures effortless arrivals and departures. A beautiful study and powder room complete the main floor. Above, discover the rare convenience of four spacious and bright upstairs bedrooms with walk-in closets, including the stunning owner's retreat with an en suite spa bathroom, a secondary suite and two more bedrooms with a Jack-and-Jill bath. An upper-level utility room makes laundry day a breeze. Fun and games await on the fantastic lower level finished with polished concrete floors, a wall of cabinetry, 400+ bottle temp controlled wine cellar, a media lounge and a well-stocked bar area. A bed and bath on this level are perfect for guests. Outdoor entertaining is irresistible on this flat 7, 803 SqFt lot surrounded by split-wood fencing and mature landscaping. Enjoy al fresco dining on the covered patio or garden in the raised, irrigated planter beds. Extensive upgrades include Lutron lighting and shade controls, Sonos audio and a Generac generator. Outstanding location close to NoBo Park & Rec Center, trails, and Ideal Market.","Roof":"Composition, Metal","RoomsTotal":null,"SchoolDistrict":"Boulder Valley Dist RE2","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"City Sewer","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"20835.00","Utilities":"Natural Gas Available, Electricity Available, Cable Available","View":"Foothills View","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, City of Boulder","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Window Coverings, Wood Frames","YearBuilt":"2016","Zoning":"RES","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"866dbbc393386d46eaaf2d4446f8dfec","listing_status":"active","mls_status":"Active","mls_id":"boulder","listing_num":"1008696","acreage":null,"acres":"0.18","address":null,"address_direction":null,"address_flg":"1","address_num":"3191","agent_id":"P28992","area":"Boulder","baths_total":"5.00","bedrooms_total":"5","car_spaces":"2","city":"Boulder","coseller_id":null,"coagent_id":null,"days_on_market":"2","finished_sqft_total":"4683","geocode_address":null,"geocode_status":null,"lat":"40.03269","lon":"-105.28591","office_id":"CBR02","office_name":"Compass - Boulder","orig_price":"4485000","photo_count":"40","previous_price":null,"price":"4485000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/99b7fe2a1dac6e17a8bd0881235281b0\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"3278","state":"CO","street_type":"St","street_name":"9th","sub_area":"Newlands","unit":null,"zip_code":"80304","listing_dt":"2024-05-03","undercontract_dt":null,"openhouse_dt":"2024-05-05 19:00:00","price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-18 18:33:53","create_dt":"2024-05-03 15:30:16","marketing_headline_txt":null,"use_marketing_description_txt":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}