Start of property details
Property Details
Remarkable views of Boulder's Foothills! This elegant Tudor, 6 bedroom, 9 bath + bonus room backs to open space and has a private, in-ground pool and spa + solar. Stunning kitchen with 2 Subzeros, 2 stainless steel sinks, 2 dishwashers, double oven + warming drawer, 6 burner Viking stovetop, 2 granite top islands and cherry cabinets. Main floor has abundant natural light and new hardwood floors, private office with 2 workstations, formal dining + large living room. Fully finished, walkout basement with state of the art, 8 person movie theater, exercise room, 2 bedrooms with en suite's, rough-in for basement bar or kitchen and plentiful storage. Beautiful backyard has a large grass area, 3 season outdoor porch, entertaining area with fireplace + outdoor fire pit - A perfect sanctuary for Niwot's incredible sunsets over Colorado's mountains. Award winning schools.
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
HOA
Tax
Heating, Cooling & Utilities
Utilities
Lot
Exterior Features
Parking
Homeowner's Association
Pool Features
Payment Calculator
Property History
Similar Properties
{"property_id":"denver_IR985250","AboveGradeFinishedArea":"6283","AccessibilityFeatures":null,"Appliances":"Bar Fridge, Dishwasher, Disposal, Double Oven, Freezer, Humidifier, Microwave, Oven, Refrigerator, Self Cleaning Oven, Trash Compactor","ArchitecturalStyle":"Tudor","AssociationAmenities":"Park, Trail(s)","AssociationFee":"300.00","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Reserves, Trash","AssociationYN":"1","AttributionContact":"3032493248","Basement":"Daylight, Walk-Out Access","BasementYN":"1","BathroomsFull":"7","BathroomsHalf":"0","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"2","BelowGradeFinishedArea":"2534","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"BuyerFinancing":"Conventional","CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Stone, Stucco","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Boulder","CoveredSpaces":null,"CurrentFinancing":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":null,"ElementarySchool":"Niwot","Exclusions":"Washer and Dryer, all other exclusions - Inquire with listing agent.","ExteriorFeatures":"Balcony, Gas Grill, Spa\/Hot Tub","Fencing":"Fenced, Partial","FireplaceFeatures":"Family Room, Primary Bedroom","FireplaceYN":null,"FireplacesTotal":null,"Flooring":"Tile, Wood","FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air","HighSchool":"Niwot","HorseAmenities":null,"HorseYN":null,"Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Central Vacuum, Eat-in Kitchen, Five Piece Bath, Jet Action Tub, Kitchen Island, Open Floorplan, Pantry, Vaulted Ceiling(s), Walk-In Closet(s)","InternetAddressDisplayYN":null,"LaundryFeatures":"In Unit","Levels":"Two","ListAgentFullName":"Ashley Stringer","ListAgentEmail":null,"ListingTerms":"Cash, Conventional","LivingArea":null,"LotFeatures":"Level, Open Space, Sprinklers In Front","LotSizeArea":null,"LotSizeDimensions":null,"LotSizeSquareFeet":"36375.00","MainLevelBathrooms":"2","MainLevelBedrooms":"0","MiddleOrJuniorSchool":"Sunset","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Individual","ParkingFeatures":"Oversized, Oversized Door","ParkingTotal":"4","PatioAndPorchFeatures":"Deck, Patio","PoolFeatures":"Private","PoolYN":null,"PoolPrivateYN":null,"PropertyAttachedYN":null,"PropertyCondition":null,"PropertySubType":"Single Family Residence","public_remarks":"Remarkable views of Boulder's Foothills! This elegant Tudor, 6 bedroom, 9 bath + bonus room backs to open space & has a private, in-ground pool & spa + solar. Stunning kitchen w\/ 2 Subzeros, 2 stainless steel sinks, 2 dishwashers, double oven + warming drawer, 6 burner Viking stovetop, 2 granite top islands & cherry cabinets. Main floor has abundant natural light & new hardwood floors, private office w\/ 2 workstations, formal dining + large living room. Fully finished, walkout basement w\/ state of the art, 8 person movie theater, exercise room, 2 bedrooms w\/ en suite's, rough-in for basement bar or kitchen & plentiful storage. Beautiful backyard has a large grass area, 3 season outdoor porch, entertaining area w\/ fireplace + outdoor fire pit - A perfect sanctuary for Niwot's incredible sunsets over Colorado's mountains. Award winning schools.","Roof":"Spanish Tile","RoomsTotal":null,"SchoolDistrict":"St. Vrain Valley RE-1J","SecurityFeatures":"Fire Alarm, Fire Sprinkler System, Smoke Detector(s)","seller_office_id":null,"SeniorCommunityYN":null,"Sewer":"Public Sewer","SkiFeatures":null,"SpaFeatures":null,"SpaYN":null,"SpecialListingConditions":null,"StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"House","TaxAnnualAmount":"14007.00","Utilities":"Electricity Available, Natural Gas Available","View":"City, Mountain(s), Plains","ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/vimeo.com\/817963063","WalkScore":null,"WaterBodyName":null,"WaterSource":"Public","WaterfrontFeatures":null,"WaterfrontYN":null,"WindowFeatures":"Double Pane Windows, Skylight(s), Window Coverings","YearBuilt":"2003","Zoning":"RES","ZoningDescription":null,"property_uid":"REC2031987851","listing_status":"sold","mls_status":"Closed","mls_id":"denver","listing_num":"IR985250","acreage":null,"acres":"0.84","address":null,"address_direction":null,"address_flg":"1","address_num":"8906","agent_id":"IRP18874","area":null,"baths_total":"9.00","bedrooms_total":"6","car_spaces":"4","city":"Niwot","coseller_id":null,"coagent_id":null,"days_on_market":null,"finished_sqft_total":"8817","geocode_address":"8906 Little Raven Trail","geocode_status":null,"lat":"40.09007","lon":"-105.14624","office_id":"IRCLND","office_name":"Slifer Smith & Frampton-Bldr","orig_price":"3350000","photo_count":"40","previous_price":"3200000","price":"2950000","prop_img":"\/listing\/photos\/denver\/IR985250-0.jpeg","property_type":"Residential","sqft_total":"8950","state":"CO","street_type":"Trail","street_name":"Little Raven","sub_area":"Legend Ridge FLG2","unit":null,"zip_code":"80503","listing_dt":"2023-04-12","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":"2023-07-24","seller_id":"IRP01671","sold_dt":"2023-11-16","sold_price":"2700000","webapi_update_dt":null,"update_dt":"2024-02-04 09:34:23","create_dt":"2023-04-12 00:00:00","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}