Start of property details
Property Details
Enjoy living the Colorado lifestyle in this beautiful remodeled low maintenance home in Boulder County. Whether its entertaining friends and family or spending time at home, this contemporary yet comfortable 5 bedroom 4 bath home is here for you to enjoy. As soon as you enter you will know you found something extraordinary. This home flows seamlessly from one room to the other and the kitchen is a culinary enthusiast's dream equipped with high-end Bosh appliances and beautiful quartz countertops. The two car garage is equipped with a workbench and the home offers plenty of storage space. Enjoy the proximity to downtown Longmont, walk to the recreation center and stroll the nearby park. Beautiful mature trees adorn the streets in this sought after community.
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
Payment Calculator
Property History
Similar Properties
{"property_id":"denver_IR975400","AboveGradeFinishedArea":"1874","AccessibilityFeatures":null,"Appliances":"Dishwasher, Microwave, Refrigerator, Self Cleaning Oven","ArchitecturalStyle":null,"AssociationAmenities":"Park","AssociationFee":"95.00","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":null,"AssociationYN":"1","AttributionContact":"9702954760","Basement":"Full","BasementYN":"1","BathroomsFull":"3","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"860","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"BuyerFinancing":"Cash","CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Wood Frame","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Boulder","CoveredSpaces":null,"CurrentFinancing":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":null,"ElementarySchool":"Burlington","Exclusions":"Garage Refrigerator\/Freezer, Basement Mini Refrigerator, Living Room TV and Soundbar","ExteriorFeatures":null,"Fencing":null,"FireplaceFeatures":"Gas","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":"Forced Air","HighSchool":"Niwot","HorseAmenities":null,"HorseYN":null,"Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Eat-in Kitchen, Walk-In Closet(s)","InternetAddressDisplayYN":null,"LaundryFeatures":null,"Levels":"Two","ListAgentFullName":"LeeAnne Hazzard","ListAgentEmail":null,"ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":null,"LotSizeArea":null,"LotSizeDimensions":null,"LotSizeSquareFeet":"3701.00","MainLevelBathrooms":"1","MainLevelBedrooms":"0","MiddleOrJuniorSchool":"Sunset","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Individual","ParkingFeatures":null,"ParkingTotal":"2","PatioAndPorchFeatures":null,"PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyAttachedYN":null,"PropertyCondition":null,"PropertySubType":"Single Family Residence","public_remarks":"Enjoy living the Colorado lifestyle in this beautiful remodeled low maintenance home in Boulder County. Whether its entertaining friends and family or spending time at home, this contemporary yet comfortable 5 bedroom 4 bath home is here for you to enjoy. As soon as you enter you will know you found something extraordinary. This home flows seamlessly from one room to the other and the kitchen is a culinary enthusiast's dream equipped with high-end Bosh appliances and beautiful quartz countertops. The two car garage is equipped with a workbench and the home offers plenty of storage space. Enjoy the proximity to downtown Longmont, walk to the recreation center and stroll the nearby park. Beautiful mature trees adorn the streets in this sought after community.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"St. Vrain Valley RE-1J","SecurityFeatures":null,"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":"2953.00","Utilities":"Electricity Available, Natural Gas Available","View":null,"ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"Public","WaterfrontFeatures":null,"WaterfrontYN":null,"WindowFeatures":"Window Coverings","YearBuilt":"2004","Zoning":"RES","ZoningDescription":null,"property_uid":"REC2029086895","listing_status":"sold","mls_status":"Closed","mls_id":"denver","listing_num":"IR975400","acreage":null,"acres":"0.08","address":null,"address_direction":null,"address_flg":"1","address_num":"512","agent_id":"IRP29703","area":null,"baths_total":"4.00","bedrooms_total":"5","car_spaces":"2","city":"Longmont","coseller_id":null,"coagent_id":null,"days_on_market":null,"finished_sqft_total":"2734","geocode_address":"512 Sierra Avenue","geocode_status":null,"lat":"40.1429","lon":"-105.10104","office_id":"IRRNEX","office_name":"RE\/MAX Nexus","orig_price":"699900","photo_count":"31","previous_price":null,"price":"699900","prop_img":"\/images\/property\/denver\/IR975400-1.jpeg","property_type":"Residential","sqft_total":"2734","state":"CO","street_type":"Avenue","street_name":"Sierra","sub_area":"QUAIL RIDGE REPLAT D","unit":null,"zip_code":"80501","listing_dt":"2022-09-14","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":"2022-09-24","seller_id":"IRP31929","sold_dt":"2022-11-10","sold_price":"690000","webapi_update_dt":null,"update_dt":"2024-02-04 09:34:23","create_dt":"2022-09-14 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}