Start of property details
Property Details
Appraised for $675, 000 and listed for $625, 000 - that's $50, 000 below appraised value! Enjoy all that the Northern Colorado Front Range has to offer with life in this beautiful turnkey townhome in the highly desirable Highland Meadows Golf Course Neighborhood, offering resort-style amenities. This home is perfect for full or part-time living with the convenience of LOW-MAINTENANCE LIVING as exterior maintenance, snow removal and lawn care are included with the reasonable HOA fee. This handsome END UNIT offers additional windows for plenty of natural light and boasts an incredible curb appeal + patio VIEWS of the Indian Peaks mountain range and golf course driving range. The spacious layout offers MAIN-LEVEL LIVING, with the primary suite and laundry on the main level and only two steps up from the attached oversized two-car garage, which includes a utility sink + it is a SOUTH-FACING DRIVEWAY! The kitchen is stunning with quartz countertops, SS appliances + a large island that overlooks the living area with vaulted ceilings and a gas fireplace. The high-quality FINISHED BASEMENT has 9' walls, beautiful and durable LVP flooring + the ability to easily split the large family room into an additional 4th conforming bedroom with an ensuite 3 / 4 bathroom and walk-in closet. The main-level primary suite includes an ensuite bathroom with luxury finishes such as wood-look porcelain tile flooring, a spacious double vanity and walk-in closet. The upper level includes a BONUS FLEX SPACE perfect for an OFFICE, play / hobby area, or a murphy bed for additional guests. The HOA includes water, sewer, trash, recycling, lawn care, snow removal, hazard insurance, exterior maintenance, basic cable and high-speed internet (Comcast). The Metro District includes access to the Highland Meadows pool, exterior (public) tennis courts, and a new clubhouse with a fitness center, hot tub, sauna, and outdoor entertaining area. All appliances, including the clothes washer and dryer, are included!
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
Exterior Features
Homeowner's Association
Pool Features
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_1001380","AboveGradeFinishedArea":"1833","AccessibilityFeatures":"Main Floor Bath, Main Level Bedroom, Stall Shower, Main Level Laundry","Appliances":"Electric Range\/Oven, Self Cleaning Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Water Purifier Owned, Disposal","ArchitecturalStyle":"Patio Home, Contemporary\/Modern","AssociationAmenities":null,"AssociationFee":"330.00","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Common Amenities, Trash, Snow Removal, Maintenance Grounds, Management, Utilities, Maintenance Structure, Cable TV, Water\/Sewer, Hazard Insurance","AssociationYN":"1","AttributionContact":"9706852441","Basement":"Full, 75%+Finished Basement, Built-In Radon, Radon Unknown","BasementYN":null,"BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"1056","BuilderModel":null,"BuilderName":"Landmark Homes","BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":"Clubhouse, Tennis Court(s), Hot Tub, Pool, Sauna, Fitness Center, Park, Hiking\/Biking Trails","ComplexName":null,"ConstructionMaterials":"Wood\/Frame, Stone, Composition Siding","Contingency":null,"Cooling":"Central Air, Ceiling Fan(s)","CountyOrParish":"Larimer","CoveredSpaces":"2","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"North, South","DoorFeatures":"Storm Door(s)","Electric":"Electric, PV REA","ElementarySchool":"Riverview PK-8","Exclusions":"See the contract prep guide for a full list of inclusions and exclusions.","ExteriorFeatures":"Lighting, Tennis Court(s)","Fencing":"Fenced, Metal Post Fence","FireplaceFeatures":"Gas, Living Room","FireplaceYN":"1","FireplacesTotal":null,"Flooring":"Wood Floors","FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air","HighSchool":"Mountain View","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Study Area, High Speed Internet, Eat-in Kitchen, Cathedral\/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, 9ft+ Ceilings","InternetAddressDisplayYN":null,"LaundryFeatures":"Washer\/Dryer Hookups, Main Level","Levels":"Two","ListingTerms":"Cash, Conventional, FHA, VA Loan, 1031 Exchange","LivingArea":null,"LotFeatures":"Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Corner Lot, On Golf Course, Near Golf Course, Within City Limits","LotSizeArea":"3580.00","LotSizeSquareFeet":"3580.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Riverview PK-8","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"41c228c0251aedb6f534f47332594933","OfficePhone":"970-225-5152","OtherParking":null,"Ownership":null,"ParkingFeatures":"Garage Door Opener, Oversized","ParkingTotal":null,"PatioAndPorchFeatures":"Patio","PoolFeatures":"Private","PoolYN":null,"PoolPrivateYN":"1","PropertyCondition":"Not New, Previously Owned","PropertySubType":"Attached Dwelling","public_remarks":"Appraised for $675, 000 & listed for $625, 000 - that's $50, 000 below appraised value! Enjoy all that the Northern Colorado Front Range has to offer with life in this beautiful turnkey townhome in the highly desirable Highland Meadows Golf Course Neighborhood, offering resort-style amenities. This home is perfect for full or part-time living with the convenience of LOW-MAINTENANCE LIVING as exterior maintenance, snow removal & lawn care are included with the reasonable HOA fee. This handsome END UNIT offers additional windows for plenty of natural light & boasts an incredible curb appeal + patio VIEWS of the Indian Peaks mountain range and golf course driving range. The spacious layout offers MAIN-LEVEL LIVING, with the primary suite & laundry on the main level & only two steps up from the attached oversized two-car garage, which includes a utility sink + it is a SOUTH-FACING DRIVEWAY! The kitchen is stunning with quartz countertops, SS appliances + a large island that overlooks the living area with vaulted ceilings & a gas fireplace. The high-quality FINISHED BASEMENT has 9' walls, beautiful & durable LVP flooring + the ability to easily split the large family room into an additional 4th conforming bedroom with an ensuite 3\/4 bathroom & walk-in closet. The main-level primary suite includes an ensuite bathroom with luxury finishes such as wood-look porcelain tile flooring, a spacious double vanity & walk-in closet. The upper level includes a BONUS FLEX SPACE perfect for an OFFICE, play\/hobby area, or a murphy bed for additional guests. The HOA includes water, sewer, trash, recycling, lawn care, snow removal, hazard insurance, exterior maintenance, basic cable & high-speed internet (Comcast). The Metro District includes access to the Highland Meadows pool, exterior (public) tennis courts, and a new clubhouse with a fitness center, hot tub, sauna, and outdoor entertaining area. All appliances, including the clothes washer & dryer, are included!","Roof":"Composition, Metal","RoomsTotal":null,"SchoolDistrict":"Thompson R2-J","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"District Sewer","SpaFeatures":"Private","SpaYN":"1","SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"Legal Conforming, Townhou","TaxAnnualAmount":"4143.00","Utilities":"Natural Gas Available, Electricity Available, Cable Available, Underground Utilities","View":"Mountain(s), Foothills View","ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/sallteam.com\/listing-videos\/6362-pumpkin-ridge-dr-1-windsor-co","WalkScore":null,"WaterBodyName":null,"WaterSource":"District Water, FTC\/Lvlnd Water Dist","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Window Coverings, Double Pane Windows","YearBuilt":"2017","Zoning":"Res","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"19c0bcfc107fa400f4bf98bd3a178eb9","listing_status":"sold","mls_status":"Closed","mls_id":"boulder","listing_num":"1001380","acreage":null,"acres":"0.08","address":null,"address_direction":null,"address_flg":"1","address_num":"6362","agent_id":"P29495","area":"Loveland\/Berthoud","baths_total":"4.00","bedrooms_total":"3","car_spaces":"2","city":"Windsor","coseller_id":null,"coagent_id":"P25415","days_on_market":"160","finished_sqft_total":"2689","geocode_address":null,"geocode_status":null,"lat":"40.45742","lon":"-104.980085","office_id":"JCSRE","office_name":"C3 Real Estate Solutions, LLC","orig_price":"625000","photo_count":"40","previous_price":null,"price":"625000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/867043ac0e34cef58d67f62014edcb57\/83dcefb7.jpeg","property_type":"Attached Dwelling","sqft_total":"1833","state":"CO","street_type":"Dr","street_name":"Pumpkin Ridge","sub_area":"Highland Meadows","unit":"1","zip_code":"80550","listing_dt":"2024-01-09","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":"P06063","sold_dt":"2024-03-20","sold_price":"620000","webapi_update_dt":null,"update_dt":"2024-03-21 19:30:25","create_dt":"2024-01-09 22:30:06","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}