Steeped in an enviable locale in Heritage Ridge, this newer ranch residence excites. Stunning curb appeal lends a warm welcome into this impeccably designed home. Flooded with natural light and large windows, the living space has flawless livability with chic floors, stylish finishes, precise detailing and masterful upgrades at every turn. A truly open living space connects to a chef’s kitchen which features high-end appliances, counter seating for four, a real pantry, a gas range and shaker cabinets. A wall of windows and a large patio door affords easy access onto the flourishing back patio and green space. Back in the home, the primary suite beckons peaceful rejuvenation with vaulted ceilings, a double vanity, large shower, soaking tub and a custom walk-in closet that will comfortably fit the all-season wardrobe for two. The main floor also includes two additional spacious bedrooms, another full bath with a double vanity and a laundry room. The lower level plays host a large flex space, 2 conforming bedrooms, another full bath and storage galore. Relish in the convenience of an oversized 3-car attached garage, custom blinds, fresh paint, storage galore and professional landscaping. Enjoy walkability to all of your favorite Heritage Ridge amenities including the pool and parks and easy access to downtown Berthoud. This opportunity is not to be missed.
For sale
Price cut: $15K (6/16)
$620,000
577 Tristan Place, Berthoud, CO 80513
5beds
3,204sqft
Single Family Residence
Built in 2018
6,927 Square Feet Lot
$-- Zestimate®
$194/sqft
$42/mo HOA
What's special
Stylish finishesPrecise detailingPrimary suiteMasterful upgradesGreen spaceVaulted ceilingsFresh paint
- 172 days |
- 658 |
- 36 |
Zillow last checked:
Listing updated:
Listed by:
Scott Noble 845-750-3283 scott@milehimodern.com,
Milehimodern
Source: REcolorado as distributed by MLS GRID,MLS#: 6664283
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 3
- Main level bathrooms: 2
- Main level bedrooms: 3
Bedroom
- Features: Primary Suite
- Level: Main
Bedroom
- Level: Main
Bedroom
- Level: Main
Bedroom
- Level: Basement
Bedroom
- Level: Basement
Bathroom
- Features: Primary Suite
- Level: Main
Bathroom
- Level: Main
Bathroom
- Level: Basement
Dining room
- Level: Main
Kitchen
- Level: Main
Laundry
- Level: Main
Living room
- Level: Main
Living room
- Level: Basement
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer
- Laundry: In Unit
Features
- Ceiling Fan(s), Eat-in Kitchen, Granite Counters, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Quartz Counters, Vaulted Ceiling(s), Walk-In Closet(s)
- Flooring: Carpet, Tile, Wood
- Windows: Window Coverings
- Basement: Finished,Full,Sump Pump
Interior area
- Total structure area: 3,204
- Total interior livable area: 3,204 sqft
- Finished area above ground: 1,602
- Finished area below ground: 1,602
Property
Parking
- Total spaces: 3
- Parking features: Exterior Access Door, Oversized, Oversized Door
- Attached garage spaces: 3
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Front Porch, Patio
- Exterior features: Lighting, Private Yard, Rain Gutters
- Fencing: Full
Lot
- Size: 6,927 Square Feet
- Features: Landscaped
Details
- Parcel number: R1665496
- Zoning: Res
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Frame, Stone, Wood Siding
- Foundation: Concrete Perimeter
- Roof: Composition
Condition
- Year built: 2018
Details
- Builder name: Saint Aubyn Homes LLC
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Available
Community & HOA
Community
- Security: Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell
- Subdivision: Heritage Ridge
HOA
- Has HOA: Yes
- Amenities included: Park, Pool, Trail(s)
- Services included: Reserve Fund, Insurance, Maintenance Grounds
- HOA fee: $500 annually
- HOA name: Heritage Ridge Metropolitan District
- HOA phone: 970-484-0101
Location
- Region: Berthoud
Financial & listing details
- Price per square foot: $194/sqft
- Tax assessed value: $624,400
- Annual tax amount: $6,716
- Date on market: 1/22/2026
- Listing terms: Cash,Conventional,Other
- Exclusions: Seller's Personal Property And/Or Staging Items.
- Ownership: Individual
- Electric utility on property: Yes
- Road surface type: Paved
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/16/2026 | Price change | $620,000-2.4%$194/sqft |
Source: | ||
| 4/29/2026 | Price change | $635,000-0.8%$198/sqft |
Source: | ||
| 3/2/2026 | Price change | $639,999-1.5%$200/sqft |
Source: | ||
| 1/22/2026 | Listed for sale | $649,900+3.2%$203/sqft |
Source: | ||
| 7/28/2022 | Sold | $630,000+35.2%$197/sqft |
Source: Public Record Report a problem | ||
| 11/5/2020 | Sold | $466,000-1.9%$145/sqft |
Source: | ||
| 10/5/2020 | Pending sale | $474,999$148/sqft |
Source: ERA Tradewind Real Estate, LLC #918780 Report a problem | ||
| 10/2/2020 | Price change | $474,999-1%$148/sqft |
Source: ERA Tradewind Real Estate, LLC #918780 Report a problem | ||
| 9/11/2020 | Pending sale | $479,990$150/sqft |
Source: ERA Tradewind Real Estate, LLC #918780 Report a problem | ||
| 8/3/2020 | Price change | $479,990-4%$150/sqft |
Source: ERA Tradewind Real Estate, LLC #918780 Report a problem | ||
| 7/21/2020 | Listed for sale | $499,950+12.8%$156/sqft |
Source: ERA Tradewind Real Estate, LLC #918780 Report a problem | ||
| 3/5/2019 | Sold | $443,250$138/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $6,716 +24.6% | $41,835 -1% |
| 2023 | $5,391 -2.2% | $42,241 +31.3% |
| 2022 | $5,510 +10.4% | $32,165 -2.8% |
| 2021 | $4,993 +56.5% | $33,091 +10.4% |
| 2020 | $3,190 +27886.4% | $29,980 +52.9% |
| 2019 | $11 | $19,613 +51513.2% |
| 2018 | $11 | $38 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Principal & interest
$1,547Mortgage insurance
$0Property taxes
$170Home insurance
$105HOA fees
$0Utilities
Not includedAll calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 80513
Nearby schools
GreatSchools rating
- 6/10Ivy Stockwell Elementary SchoolGrades: K-5Distance: 0.4 mi
- 5/10Turner Middle SchoolGrades: 6-8Distance: 0.8 mi
- 7/10Berthoud High SchoolGrades: 9-12Distance: 0.5 mi
Schools provided by the listing agent
- Elementary: Ivy Stockwell
- Middle: Turner
- High: Berthoud
- District: Thompson R2-J
Source: REcolorado as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- $648,5005 bd4 ba1.5k sqft587 Tristan Pl, Berthoud, CO 80513Off Market
Save - $489,7003 bd2 ba1.2k sqft567 Tristan Pl, Berthoud, CO 80513Off Market
Save - $629,6004 bd4 ba2.6k sqft597 Tristan Pl, Berthoud, CO 80513Off Market
Save 
- $573,0005 bd3 ba2.7k sqft436 Ellie Way, Berthoud, CO 80513Sold
Save 
- $524,1003 bd2 ba1.8k sqft444 Ellie Way, Berthoud, CO 80513Off Market
Save - $578,8003 bd2 ba2.3k sqft434 Ellie Way, Berthoud, CO 80513Off Market
Save - $518,7003 bd2 ba1.8k sqft568 Tristan Pl, Berthoud, CO 80513Off Market
Save - $560,3004 bd2 ba2.2k sqft578 Tristan Pl, Berthoud, CO 80513Off Market
Save
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
Similar homes
- $665,0004 bd3 ba3.3k sqft1525 Mount Meeker Ave, Berthoud, CO 80513For Sale
Save 
MLS ID #1057576, Dominic Miller, Compass-Denver. IRES as distributed by MLS GRID - $759,0005 bd4 ba4.5k sqft1018 Gabriella Lane, Berthoud, CO 80513For Sale
Save 
MLS ID #6213973, Bernadette Reed, RE/MAX Professionals. REcolorado as distributed by MLS GRID - $639,9005 bd4 ba2.9k sqft1404 Sunrise Hill Drive, Berthoud, CO 80513New Construction
Save 
REcolorado as distributed by MLS GRID - $550,0003 bd2 ba2.9k sqft3308 Auklet Drive, Berthoud, CO 80513For Sale
Save 
MLS ID #2257814, Andrew Rottner, Redfin Corporation. REcolorado as distributed by MLS GRID - $625,0003 bd3 ba2k sqft220 Wark Avenue, Berthoud, CO 80513For Sale
Save
MLS ID #1833062, Christopher Naggar, Engel & Volkers Denver. REcolorado as distributed by MLS GRID - $459,9003 bd3 ba2.3k sqft287 Dipper Court, Berthoud, CO 80513For Sale
Save
MLS ID #4490121, Allen Dale Trumm, Keller Williams Avenues Realty. REcolorado as distributed by MLS GRID - from $539,9903 bd3 ba2.2k sqftRainier Plan, Farmstead, Berthoud, CO 80513New Construction
Save Dream Finders Homes - $620,0005 bd4 ba3.2k sqft2908 Hydra Drive, Loveland, CO 80537For Sale
Save
MLS ID #3283125, Bridget Osborne, eXp Realty, LLC. REcolorado as distributed by MLS GRID - $625,0005 bd4 ba3.6k sqft266 Kirkland Ln, Johnstown, CO 80534For Sale
Save
MLS ID #1059943, Kim Tomlinson, RE/MAX Alliance-Loveland. IRES as distributed by MLS GRID - $619,0004 bd3 ba3.1k sqft2410 Pineywoods St, Mead, CO 80542For Sale
Save
MLS ID #1060761, Krista Koth, Compass - Boulder. IRES as distributed by MLS GRID - $627,0005 bd4 ba3.6k sqft13611 Wrangler Way, Mead, CO 80542For Sale
Save
MLS ID #3891050, Jon-Simon Marquez, Compass - Denver. REcolorado as distributed by MLS GRID - $600,0004 bd4 ba2.9k sqft1811 Canvasback Drive, Johnstown, CO 80534For Sale
Save
MLS ID #8092586, Lisa Daniel, HomeSmart. REcolorado as distributed by MLS GRID - $749,0003 bd3 ba3.2k sqft2611 Prairie Flax St, Berthoud, CO 80513For Sale
Save
MLS ID #1059410, Dillan Ward, RE/MAX Alliance-FTC South. IRES as distributed by MLS GRID - $--3 bd3 ba2.3k sqft16857 McKay Dr, Mead, CO 80542Auction
Save Auction.com 2 - $620,0005 bd3 ba2.1k sqft729 Mathews Circle, Erie, CO 80516For Sale
Save
MLS ID #8394854, Cheryl Singleton, 8z Real Estate. REcolorado as distributed by MLS GRID - $635,0004 bd4 ba3.2k sqft6718 Thistle Ridge Avenue, Firestone, CO 80504For Sale
Save
MLS ID #8116763, Michelle Nguyen, Your Castle Real Estate Inc. REcolorado as distributed by MLS GRID - $620,0005 bd3 ba3.1k sqft5175 Clarence Drive, Windsor, CO 80550For Sale
Save
MLS ID #5134827, Holly Vejrostek, LPT Realty. REcolorado as distributed by MLS GRID - $690,0005 bd4 ba3.5k sqft4204 Martinson Dr, Loveland, CO 80537For Sale
Save
MLS ID #1062834, Aubrie Larsen, Better Homes and Gardens Real Estate - Neuhaus. IRES as distributed by MLS GRID - $715,0005 bd4 ba3.4k sqft2719 Saltbrush Drive, Loveland, CO 80538For Sale
Save
MLS ID #5708351, Brandi Miller, Berkshire Hathaway HomeServices Colorado, LLC - Highlands Ranch Real Estate. REcolorado as distributed by MLS GRID - $650,0003 bd3 ba2.6k sqft4305 Lyric Falls Drive, Loveland, CO 80538For Sale
Save
MLS ID #5198783, Rey Armendariz, Redfin Corporation. REcolorado as distributed by MLS GRID
- Request a tour
as early as today at 3:30 pm
Contact agent
- Colorado
- Larimer County
- Berthoud
- 80513
- 577 Tristan Place