Start of property details
Property Details
Welcome home to your one-of-a-kind retreat! This stunning 2-story residence boasts a brand new finished basement, offering ample space for your lifestyle needs. Step into luxury with freshly painted exteriors, a new roof, and captivating west side casement windows that flood the interiors with natural light. Inside, you'll discover impeccable upgrades including new flooring, elegant granite countertops, and a central island adorned with cabinets, perfect for culinary enthusiasts. The vaulted ceilings add a sense of spaciousness and grandeur to the living areas, complemented by new blinds for privacy and style. The gourmet kitchen features a gas stove with electric capability, making cooking a delight, while the new concrete driveway leads to a 3-car tandem garage equipped with a storage bay, cabinets, shelving, and a workbench for all your organizational needs. Step outside to enjoy breathtaking mountain views from your covered patio, complete with a fan, ambient lighting, and retractable awnings for year-round comfort. The fenced and open space invites outdoor relaxation and entertainment, with garden beds for green thumbs and a covered dog run for furry friends. Additional highlights include a new water heater for efficiency, a shed with electricity for extra storage or hobbies, a concrete patio, newly poured sidewalk, and edging for seamless outdoor living. This home seamlessly blends luxury, functionality, and scenic beauty, making it a must-see for those seeking a distinctive and well-appointed living experience. Schedule your tour today and envision the possibilities of calling this exquisite property your own!
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
Green Energy
Utilities
Lot
Parking
Exterior Features
Homeowner's Association
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_1005792","AboveGradeFinishedArea":"1747","AccessibilityFeatures":"Level Lot","Appliances":"Gas Range\/Oven, Self Cleaning Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal","ArchitecturalStyle":"Contemporary\/Modern","AssociationAmenities":null,"AssociationFee":"250.00","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":"Common Amenities","AssociationYN":"1","AttributionContact":"9702837202","Basement":"Full, 90%+ Finished Basement, Built-In Radon","BasementYN":null,"BathroomsFull":"3","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"760","BuilderModel":null,"BuilderName":"Journey Homes","BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":"Park","ComplexName":null,"ConstructionMaterials":"Wood\/Frame, Brick\/Brick Veneer","Contingency":null,"Cooling":"Central Air, Ceiling Fan(s)","CountyOrParish":"Weld","CoveredSpaces":"3","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"East","DoorFeatures":null,"Electric":"Electric, Xcel","ElementarySchool":"Elwell, Knowledge Quest Academy","Exclusions":null,"ExteriorFeatures":"Lighting","Fencing":"Fenced","FireplaceFeatures":"Gas, Living Room","FireplaceYN":"1","FireplacesTotal":null,"Flooring":null,"FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":"Southern Exposure, HVAC","GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air","HighSchool":"Roosevelt","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Satellite Avail, High Speed Internet, Eat-in Kitchen, Separate Dining Room, Cathedral\/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island","InternetAddressDisplayYN":null,"LaundryFeatures":"Washer\/Dryer Hookups, Upper Level","Levels":"Two","ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Abuts Private Open Space, Within City Limits","LotSizeArea":"7700.00","LotSizeSquareFeet":"7700.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Milliken","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"8d5419e5189407678b1675e2c7f96b85","OfficePhone":"970-283-7202","OtherParking":null,"Ownership":null,"ParkingFeatures":"Garage Door Opener, Oversized, Tandem","ParkingTotal":null,"PatioAndPorchFeatures":"Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"Welcome home to your one-of-a-kind retreat! This stunning 2-story residence boasts a brand new finished basement, offering ample space for your lifestyle needs. Step into luxury with freshly painted exteriors, a new roof, and captivating west side casement windows that flood the interiors with natural light. Inside, you'll discover impeccable upgrades including new flooring, elegant granite countertops, and a central island adorned with cabinets, perfect for culinary enthusiasts. The vaulted ceilings add a sense of spaciousness and grandeur to the living areas, complemented by new blinds for privacy and style. The gourmet kitchen features a gas stove with electric capability, making cooking a delight, while the new concrete driveway leads to a 3-car tandem garage equipped with a storage bay, cabinets, shelving, and a workbench for all your organizational needs. Step outside to enjoy breathtaking mountain views from your covered patio, complete with a fan, ambient lighting, and retractable awnings for year-round comfort. The fenced and open space invites outdoor relaxation and entertainment, with garden beds for green thumbs and a covered dog run for furry friends. Additional highlights include a new water heater for efficiency, a shed with electricity for extra storage or hobbies, a concrete patio, newly poured sidewalk, and edging for seamless outdoor living. This home seamlessly blends luxury, functionality, and scenic beauty, making it a must-see for those seeking a distinctive and well-appointed living experience. Schedule your tour today and envision the possibilities of calling this exquisite property your own!","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Weld RE-5J","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"City Sewer","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"2872.00","Utilities":"Natural Gas Available, Electricity Available, Cable Available","View":"Mountain(s), Foothills View, Plains View","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, Town of Johnstown","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Window Coverings, Double Pane Windows","YearBuilt":"2013","Zoning":"SFR","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"a01e9b69bdd2f5bf0a4b0fd5c9f4dff7","listing_status":"under-contract","mls_status":"Pending","mls_id":"boulder","listing_num":"1005792","acreage":null,"acres":"0.18","address":null,"address_direction":null,"address_flg":"1","address_num":"208","agent_id":"P03604","area":"Greeley\/Weld","baths_total":"4.00","bedrooms_total":"4","car_spaces":"3","city":"Johnstown","coseller_id":null,"coagent_id":null,"days_on_market":"10","finished_sqft_total":"2507","geocode_address":null,"geocode_status":null,"lat":"40.33248","lon":"-104.95092","office_id":"TOPCO","office_name":"TopCO Realty","orig_price":"545000","photo_count":"40","previous_price":null,"price":"545000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/a507990626ab3460454896b7938e6241\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"1747","state":"CO","street_type":"Ave","street_name":"Sycamore","sub_area":"Clearview PUD 4th Fg","unit":null,"zip_code":"80534","listing_dt":"2024-03-27","undercontract_dt":null,"openhouse_dt":"2024-04-06 17:00:00","price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-02 09:33:16","create_dt":"2024-03-27 22:30:09","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}