Start of property details
Property Details
Amazing Niwot home with unparalleled elegant finishes and premium, unobstructed mountain views. Beautifully landscaped, newly constructed outdoor living space perfect for entertaining includes pool, hot tub, 2 custom water features, fire pit, natural stone patio, and covered deck area featuring an outdoor kitchen. Outdoor space also includes custom designed putting / chipping green, in ground trampoline, swing set, and landscaped garden beds. Ranch style four bedroom home with large windows, lots of light and modern upgrades. Master bedroom has a luxury bathroom and an oversized walk in closet with separate laundry facilities. All bedrooms have walk in closets and en suite bathrooms. Additional room above the garage is a perfect second office or playroom. Large, spacious basement with a fully equipped 850 sq ft gym, custom built in kids play structure (with climbing wall), elegant bar, and entertaining space. Basement area also features 1500 sq ft of unfinished space that can be used as storage or future improvements. Large lot backs to neighborhood open space providing spacious feel and privacy. Neighborhood offers maintained trail system that connects to Boulder trails. Premium location close to Boulder, Longmont and Lafayette and within a short drive to multiple top rated public and private schools.
Open House Announcements
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_IR1006424","AboveGradeFinishedArea":"5243","AccessibilityFeatures":null,"Appliances":"Bar Fridge, Dishwasher, Disposal, Double Oven, Dryer, Microwave, Oven, Refrigerator, Washer","ArchitecturalStyle":null,"AssociationAmenities":"Trail(s)","AssociationFee":"350.00","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Reserves, Trash","AssociationYN":"1","AttributionContact":"3034947700","Basement":"Full","BasementYN":"1","BathroomsFull":"4","BathroomsHalf":"3","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"2803","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"BuyerFinancing":null,"CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Stone, Stucco, Wood Frame","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Boulder","CoveredSpaces":null,"CurrentFinancing":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":null,"ElementarySchool":"Niwot","Exclusions":null,"ExteriorFeatures":"Gas Grill, Spa\/Hot Tub","Fencing":null,"FireplaceFeatures":null,"FireplaceYN":null,"FireplacesTotal":null,"Flooring":"Tile","FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Radiant","HighSchool":"Niwot","HorseAmenities":null,"HorseYN":null,"Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Walk-In Closet(s)","InternetAddressDisplayYN":null,"LaundryFeatures":"In Unit","Levels":"One","ListAgentFullName":"Greg Hult","ListAgentEmail":null,"ListingTerms":"Cash, Conventional","LivingArea":null,"LotFeatures":"Level, Open Space, Sprinklers In Front","LotSizeArea":null,"LotSizeDimensions":null,"LotSizeSquareFeet":"32374.00","MainLevelBathrooms":"5","MainLevelBedrooms":"3","MiddleOrJuniorSchool":"Sunset","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Individual","ParkingFeatures":"Oversized","ParkingTotal":"4","PatioAndPorchFeatures":"Deck, Patio","PoolFeatures":"Private","PoolYN":null,"PoolPrivateYN":null,"PropertyAttachedYN":"0","PropertyCondition":null,"PropertySubType":"Single Family Residence","public_remarks":"Amazing Niwot home with unparalleled elegant finishes and premium, unobstructed mountain views. Beautifully landscaped, newly constructed outdoor living space perfect for entertaining includes pool, hot tub, 2 custom water features, fire pit, natural stone patio, and covered deck area featuring an outdoor kitchen. Outdoor space also includes custom designed putting\/chipping green, in ground trampoline, swing set, and landscaped garden beds. Ranch style four bedroom home with large windows, lots of light and modern upgrades. Master bedroom has a luxury bathroom and an oversized walk in closet with separate laundry facilities. All bedrooms have walk in closets and en suite bathrooms. Additional room above the garage is a perfect second office or playroom. Large, spacious basement with a fully equipped 850 sq ft gym, custom built in kids play structure (with climbing wall), elegant bar, and entertaining space. Basement area also features 1500 sq ft of unfinished space that can be used as storage or future improvements. Large lot backs to neighborhood open space providing spacious feel and privacy. Neighborhood offers maintained trail system that connects to Boulder trails. Premium location close to Boulder, Longmont and Lafayette and within a short drive to multiple top rated public and private schools.","Roof":"Spanish Tile","RoomsTotal":null,"SchoolDistrict":"St. Vrain Valley RE-1J","SecurityFeatures":"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":"30148.00","Utilities":"Electricity Available, Natural Gas Available","View":"Mountain(s)","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"Public","WaterfrontFeatures":null,"WaterfrontYN":null,"WindowFeatures":"Window Coverings","YearBuilt":"2006","Zoning":"Res","ZoningDescription":null,"property_uid":"REC2037822018","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"IR1006424","acreage":null,"acres":"0.74","address":null,"address_direction":null,"address_flg":"1","address_num":"6549","agent_id":"IRP17259","area":null,"baths_total":"7.00","bedrooms_total":"4","car_spaces":"4","city":"Niwot","coseller_id":null,"coagent_id":null,"days_on_market":null,"finished_sqft_total":"8046","geocode_address":"6549 Legend Ridge Trail","geocode_status":null,"lat":"40.09278","lon":"-105.1442","office_id":"IRPRMBD","office_name":"Berkshire Hathaway-Boulder","orig_price":"4985000","photo_count":"38","previous_price":null,"price":"4985000","prop_img":"\/listing\/photos\/denver\/IR1006424-0.jpeg","property_type":"Residential","sqft_total":"10028","state":"CO","street_type":"Trail","street_name":"Legend Ridge","sub_area":"Legend Ridge","unit":null,"zip_code":"80503","listing_dt":"2024-04-04","undercontract_dt":null,"openhouse_dt":"2024-05-04 17:00:00","price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-03 06:48:33","create_dt":"2024-04-04 20:04:19","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}