Start of property details
Property Details
Absolutely stunning home! This spectacular walk out ranch custom home boasts 8, 000 square feet of pure luxury with high end finishes inside and out including exceptional woodwork! This gorgeous home features a main floor primary suite, second primary suite on the lower level, five ensuite bedrooms, a gourmet kitchen and four fireplaces. In addition the property features a beautiful, executive office, open floor plan, wine room, wide plank maple floors, a private movie theatre room and a 1, 000 square foot deck that is perfect for entertaining. A truly exceptional home!
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
Parking
Homeowner's Association
Exterior Features
Payment Calculator
Property History
Similar Properties
{"property_id":"denver_IR999223","AboveGradeFinishedArea":"4235","AccessibilityFeatures":null,"Appliances":"Bar Fridge, Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Self Cleaning Oven, Trash Compactor, Washer","ArchitecturalStyle":"Contemporary","AssociationAmenities":"Park","AssociationFee":"350.00","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Reserves","AssociationYN":"1","AttributionContact":"7203781217","Basement":"Full, Walk-Out Access","BasementYN":"1","BathroomsFull":"3","BathroomsHalf":"2","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"2","BelowGradeFinishedArea":"3942","BuilderModel":"Custom","BuilderName":null,"BuyerOfficeName":null,"BuyerFinancing":null,"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":null,"ExteriorFeatures":null,"Fencing":null,"FireplaceFeatures":"Family Room, Gas, Great 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":"Eat-in Kitchen, Five Piece Bath, Jet Action Tub, Open Floorplan, Pantry, Primary Suite, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar","InternetAddressDisplayYN":null,"LaundryFeatures":"In Unit","Levels":"One","ListAgentFullName":"Deborah Read Fowler","ListAgentEmail":null,"ListingTerms":"Cash, Conventional","LivingArea":null,"LotFeatures":"Rolling Slope, Sprinklers In Front","LotSizeArea":null,"LotSizeDimensions":null,"LotSizeSquareFeet":"39324.00","MainLevelBathrooms":"4","MainLevelBedrooms":"3","MiddleOrJuniorSchool":"Sunset","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Individual","ParkingFeatures":"Oversized","ParkingTotal":"3","PatioAndPorchFeatures":"Deck, Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyAttachedYN":"0","PropertyCondition":null,"PropertySubType":"Single Family Residence","public_remarks":"Absolutely stunning home! This spectacular walk out ranch custom home boasts 8, 000 square feet of pure luxury with high end finishes inside and out including exceptional woodwork! This gorgeous home features a main floor primary suite, second primary suite on the lower level, five ensuite bedrooms, a gourmet kitchen and four fireplaces. In addition the property features a beautiful, executive office, open floor plan, wine room, wide plank maple floors, a private movie theatre room and a 1, 000 square foot deck that is perfect for entertaining. A truly exceptional home!","Roof":"Spanish Tile","RoomsTotal":null,"SchoolDistrict":"St. Vrain Valley RE-1J","SecurityFeatures":"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":"13802.00","Utilities":"Electricity Available, Natural Gas Available","View":"Plains","ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/linkprotect.cudasvc.com\/url?a=https%3a%2f%2ftours.muntzstudios.com%2f2191110&c=E, 1, eCzgePdhLPmABpwGdYTdarQOi1AKJT5Qu3DNRChusjiGsu9p0e200XTVHFbafsARElOdSOR61bs9WKjGI2FK2CRqRCKYuqIgkPa64UYlVhzMc","WalkScore":null,"WaterBodyName":null,"WaterSource":"Public","WaterfrontFeatures":null,"WaterfrontYN":null,"WindowFeatures":"Bay Window(s), Double Pane Windows, Window Coverings","YearBuilt":"2003","Zoning":"A","ZoningDescription":null,"property_uid":"REC2035706382","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"IR999223","acreage":null,"acres":"0.90","address":null,"address_direction":null,"address_flg":"1","address_num":"6454","agent_id":"IRP16133","area":null,"baths_total":"7.00","bedrooms_total":"5","car_spaces":"3","city":"Niwot","coseller_id":null,"coagent_id":null,"days_on_market":null,"finished_sqft_total":"8177","geocode_address":"6454 Legend Ridge Trail","geocode_status":null,"lat":"40.09048","lon":"-105.14145","office_id":"IRCBLN","office_name":"Slifer Smith & Frampton-Niwot","orig_price":"2899000","photo_count":"40","previous_price":"2899000","price":"2849000","prop_img":"\/listing\/photos\/denver\/IR999223-0.jpeg","property_type":"Residential","sqft_total":"8470","state":"CO","street_type":"Trail","street_name":"Legend Ridge","sub_area":"Legend Ridge","unit":null,"zip_code":"80503","listing_dt":"2023-11-03","undercontract_dt":null,"openhouse_dt":"2024-05-04 17:00:00","price_change_dt":"2024-04-10","seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-04 03:48:52","create_dt":"2023-11-03 21:48:21","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}