Start of property details
Property Details
Welcome to this beautiful two-story home in the serene community of Hidden Pointe in Castle Pines North. Located near the picturesque Coyote Ridge Park and just a short drive from the breathtaking Daniel's Park this property is a nature lover's dream. As you approach this exquisite residence you'll be greeted by a newly upgraded exterior boasting fresh paint that enhances its curb appeal. The new roof adds both beauty and peace of mind ensuring your investment is well-protected for years to come. Upon entering you'll step onto gleaming new hardwood floors that grace the main level creating a bright and welcoming atmosphere. The abundance of natural light that pours through large windows further enhances the home's inviting ambiance with new interior paint. The heart of this home is the kitchen featuring a spacious island and top-of-the-line appliances. It's a chef's dream ideal for preparing gourmet meals or hosting gatherings with friends and family. For those who appreciate the environment the home boasts an owned solar system and new HVAC system adding to its eco-friendly appeal and reducing utility costs. Upstairs the custom primary 5-piece bathroom is a masterpiece offering a spa-like retreat within your own home. It's a sanctuary of relaxation and indulgence. Step outside into the private backyard where mature landscaping creates a tranquil oasis. The lush greenery and well-maintained yard provide a perfect backdrop for outdoor activities or simply unwinding in peace. Nestled in a cul-de-sac this home offers a sense of seclusion and peace. The neighborhood itself is a haven boasting scenic trails and charming playgrounds where friends and family can play and explore. This exquisite Castle Pines North home is a true masterpiece of luxury living. With its brand new upgrades and serene surroundings it offers a haven of comfort and style. Don't miss the opportunity to make this extraordinary property your own and experience the beauty and charm it has to offer.
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
Payment Calculator
Property History
Similar Properties
{"property_id":"denver_7790794","AboveGradeFinishedArea":"3200","AccessibilityFeatures":null,"Appliances":"Bar Fridge, Convection Oven, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Gas Water Heater, Humidifier, Microwave, Refrigerator, Washer","ArchitecturalStyle":"Traditional","AssociationAmenities":"Park, Playground, Trail(s)","AssociationFee":"170.00","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Recycling, Trash","AssociationYN":"1","AttributionContact":"[email protected], 303-947-7743","Basement":"Cellar, Interior Entry, Partial","BasementYN":"1","BathroomsFull":"3","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"1173","BuilderModel":null,"BuilderName":"Sanford Homes","BuyerFinancing":"Conventional","CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Brick, Frame, Wood Siding","Contingency":"None Known","Cooling":"Central Air","CountyOrParish":"Douglas","CoveredSpaces":null,"CurrentFinancing":null,"DaysOnMarket":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"Northwest","DoorFeatures":null,"Electric":null,"ElementarySchool":"Timber Trail","Exclusions":"Seller's personal belongings, 2 freezers in garage (refrigerator in garage will stay), pull up bar in garage, reverse osmosis water faucet (soap dispenser to be put in it's place), white curtains in guest bedroom.","ExteriorFeatures":"Private Yard, Rain Gutters","Fencing":"Partial","FireplaceFeatures":"Gas Log, Great Room","FireplaceYN":null,"FireplacesTotal":"1","Flooring":"Carpet, Tile, Vinyl, Wood","FoundationDetails":"Slab","GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air, Solar","HighSchool":"Rock Canyon","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Breakfast Nook, Built-in Features, Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, Granite Counters, High Ceilings, High Speed Internet, Jack & Jill Bathroom, Kitchen Island, Primary Suite, Radon Mitigation System, Smart Thermostat, Solid Surface Counters, Stone Counters, Walk-In Closet(s), Wet Bar, Wired for Data","LaundryFeatures":"In Unit","Levels":"Two","ListAgentFullName":"Michele Gwin","ListAgentEmail":null,"ListingTerms":"Cash, Conventional, FHA, Jumbo, VA Loan","LivingArea":null,"LotFeatures":"Cul-De-Sac, Irrigated, Landscaped, Many Trees, Master Planned, Sloped, Sprinklers In Front, Sprinklers In Rear","LotSizeArea":"10890.00","LotSizeDimensions":null,"LotSizeSquareFeet":"10890.00","MainLevelBathrooms":"1","MainLevelBedrooms":"0","MiddleOrJuniorSchool":"Rocky Heights","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Individual","ParkingFeatures":"Concrete","ParkingTotal":"3","PatioAndPorchFeatures":"Covered, Front Porch, Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":null,"PropertySubType":"Single Family Residence","public_remarks":"Welcome to this beautiful two-story home in the serene community of Hidden Pointe in Castle Pines North. Located near the picturesque Coyote Ridge Park and just a short drive from the breathtaking Daniel's Park this property is a nature lover's dream. As you approach this exquisite residence you'll be greeted by a newly upgraded exterior boasting fresh paint that enhances its curb appeal. The new roof adds both beauty and peace of mind ensuring your investment is well-protected for years to come. Upon entering you'll step onto gleaming new hardwood floors that grace the main level creating a bright and welcoming atmosphere. The abundance of natural light that pours through large windows further enhances the home's inviting ambiance with new interior paint. The heart of this home is the kitchen featuring a spacious island and top-of-the-line appliances. It's a chef's dream ideal for preparing gourmet meals or hosting gatherings with friends and family. For those who appreciate the environment the home boasts an owned solar system and new HVAC system adding to its eco-friendly appeal and reducing utility costs. Upstairs the custom primary 5-piece bathroom is a masterpiece offering a spa-like retreat within your own home. It's a sanctuary of relaxation and indulgence. Step outside into the private backyard where mature landscaping creates a tranquil oasis. The lush greenery and well-maintained yard provide a perfect backdrop for outdoor activities or simply unwinding in peace. Nestled in a cul-de-sac this home offers a sense of seclusion and peace. The neighborhood itself is a haven boasting scenic trails and charming playgrounds where friends and family can play and explore. This exquisite Castle Pines North home is a true masterpiece of luxury living. With its brand new upgrades and serene surroundings it offers a haven of comfort and style. Don't miss the opportunity to make this extraordinary property your own and experience the beauty and charm it has to offer.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Douglas RE-1","SecurityFeatures":"Carbon Monoxide Detector(s), Smart Cameras, Smoke Detector(s)","seller_office_id":null,"SeniorCommunityYN":"0","Sewer":"Public Sewer","SkiFeatures":null,"SpaFeatures":null,"SpaYN":null,"SpecialListingConditions":"None","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"House","TaxAnnualAmount":"4140.00","Utilities":"Electricity Connected, Natural Gas Connected","View":null,"ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/www.listingsmagic.com\/sps\/tour-slider\/index.php?property_ID=252622&ld_reg=Y","WalkScore":null,"WaterBodyName":null,"WaterSource":"Public","WaterfrontFeatures":null,"WaterfrontYN":null,"WindowFeatures":"Bay Window(s), Double Pane Windows, Window Coverings, Window Treatments","YearBuilt":"2000","Zoning":null,"ZoningDescription":null,"property_uid":"REC2034720170","listing_status":"sold","mls_status":"Closed","mls_id":"denver","listing_num":"7790794","acreage":null,"acres":"0.25","address":null,"address_direction":null,"address_flg":"1","address_num":"470","agent_id":"056149","area":null,"baths_total":"5.00","bedrooms_total":"4","car_spaces":"3","city":"Castle Pines","coseller_id":null,"coagent_id":"56149T","days_on_market":null,"finished_sqft_total":"4373","geocode_address":"470 Yarrow Place","geocode_status":null,"lat":"39.48795025","lon":"-104.89391245","office_id":"REM39","office_name":"RE\/MAX Professionals","orig_price":"1049000","photo_count":"36","previous_price":"1049000","price":"1035000","prop_img":"\/listing\/photos\/denver\/7790794-0.jpeg","property_type":"Residential","sqft_total":"4433","state":"CO","street_type":"Place","street_name":"Yarrow","sub_area":"Hidden Pointe","unit":null,"zip_code":"80108","listing_dt":"2023-09-14","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":"2023-10-12","seller_id":"067466","sold_dt":"2023-12-01","sold_price":"1045000","update_dt":"2023-12-01 19:32:10","create_dt":"2023-09-13 20:18:04","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}