$620,000
Beds: 4
Baths: 3 full, 1 half
Sqft: 2,649
Sqft lot: 7,741
Acre lot: 0.18
Just Listed -

Courtesy of Josh Landers, RE/MAX Nexus 3038191638

Info
 Print
 Print
Status: Active
Property Type: Single Family Residence
Year Built: 2018
Days On Website: 1
BEST DEAL IN HERITAGE RIDGE! LOOK AT THE PRICE PER SQUARE FOOT! Awesome 2-story with stunning MOUNTAIN VIEWS on a corner lot. This 4 bedroom home is ready for new owners! Beautiful laminate floors throughout main level. Open kitchen w/ huge island, stainless appliances, quartz counters. Spacious Living room w/ fireplace. Upper level has 3 bedrooms & loft. Spacious primary suite w/ vaulted ceilings, well-appointed 5-pc bath, walk-in closet w/ custom shelves. Fully FINISHED BASEMENT w/ large rec room, 4th bedroom & full bath. Huge back yard and perfect garden w/ southern exposure. 3-car tandem garage w/ EV charger. Walk to the neighborhood pool & playground. Leased solar panel system. MOTIVATED SELLER! SOLD AS-IS.

Features

Building

  • Above Grade Finished Area: 1849
  • Below Grade Finished Area: 800
  • Building Area Total: 1849
  • Construction Materials: "Wood/Frame"
  • Has Improvements: No
  • Main Floor Sq Ft: 1000
  • Total Sq Ft: 2649
  • Upper Sq Ft: 849
  • Levels: "Two"
  • Living Area: 2649
  • Living Area Source: Assessor
  • Living Area Units: Square Feet
  • Stories: 2
  • Year Built: 2018

Appliances & Equipment

  • Appliances: "Gas Range/Oven", "Dishwasher", "Refrigerator", "Microwave"

Home Owner's Association

  • Association Fee: 195
  • Association Fee Frequency: Annually
  • Association Fee Includes: "Common Amenities"
  • Association YN: t
  • Has Association 2 Fee: No
  • Has Association 2 Reserve: No
  • Has Association Fee: Yes
  • Has Association Reserve: Yes
  • HOA 2 Transfer Fee: No
  • HOA Transfer Fee: Yes

Garage

  • Attached Garage YN: t
  • Covered Spaces: 3
  • Garage Spaces: 3
  • Garage YN: t
  • Garage Type: Attached

Basement

  • Basement: "Full", "Partially Finished"

Bathrooms

  • Bathrooms Full: 3
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 4
  • Baths Full Additional: 0
  • Baths Full Basement: 1
  • Baths Half Additional: 0
  • Baths Half Basement: 0
  • Baths Rough In: 0
  • Baths Three Quarters Additional: 0
  • Baths Three Quarters Basement: 0
  • Baths Three Quarters Lower: 0
  • Baths Three Quarters Upper: 0

Bedrooms

  • Bedrooms Total: 4
  • All Bedrooms Conform: t

Location

  • City: Berthoud
  • Country: US
  • County Or Parish: Larimer
  • Locale: Berthoud
  • Latitude: 40.29677
  • Longitude: -105.07905
  • MLS Area Major: Loveland/Berthoud
  • Postal Code: 80513
  • State Or Province: CO
  • Street Name: Tristan
  • Street Number: 597
  • Street Suffix: Pl
  • Subdivision Name: Heritage Ridge
  • Unparsed Address: 597 Tristan Pl Berthoud CO 80513

Community

  • Community Features: "Pool"

Cooling

  • Cooling: "Central Air"
  • Cooling YN: t

Utilities

  • Electric: "Electric", "Xcel Energy"
  • Gas: "Natural Gas", "Xcel Energy"
  • Is Water Meter Installed: Yes
  • Utilities: "Natural Gas Available", "Electricity Available"

Schools

  • Elementary School: Ivy Stockwell
  • High School: Berthoud
  • High School District: Thompson R2-J
  • Middle Or Junior School: Turner

Fence

  • Fencing: "Fenced"

Fireplaces

  • Fireplace Features: "Gas"
  • Fireplace YN: t

Heating

  • Heating: "Forced Air"
  • Heating YN: t

Taxes

  • Has Metro Tax District: Yes
  • Metro Tax District Name: Heritage Ridge
  • Metro Tax District Website: https://heritageridgemd.com
  • Tax Annual Amount: 6166
  • Tax Year: 2023

Water Features

  • Has Water Rights: No
  • Water Source: "City Water", "Town of Berthoud"

Interior Features

  • Interior Features: "Eat-in Kitchen", "Open Floorplan"

Listing

  • Listing Id: 1021759
  • Listing Terms: "Cash", "Conventional", "FHA", "VA Loan"
  • List Price: 620000
  • Mls Status: Active
  • Special Listing Conditions: "Private Owner"
  • Standard Status: Active

Lot

  • Lot Features: "Lawn Sprinkler System"
  • Lot Size Acres: 0.18
  • Lot Size Area: 7741
  • Lot Size Square Feet: 7741
  • Lot Size Units: Square Feet

Property

  • Parcel Number: R1665498
  • Property Condition: "Not New, Previously Owned"
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • View: "Mountain(s)"

Parking

  • Parking Features: "Tandem"

Exterior Features

  • Patio And Porch Features: "Patio"

Second Bedroom

  • Room Bedroom 2 Area: 110
  • Room Bedroom 2 Features: "Carpet"
  • Room Bedroom 2 Length: 11
  • Room Bedroom 2 Level: Upper
  • Room Bedroom 2 Width: 10

Third Bedroom

  • Room Bedroom 3 Area: 100
  • Room Bedroom 3 Features: "Carpet"
  • Room Bedroom 3 Length: 10
  • Room Bedroom 3 Level: Upper
  • Room Bedroom 3 Width: 10

Fourth Bedroom

  • Room Bedroom 4 Area: 121
  • Room Bedroom 4 Features: "Carpet"
  • Room Bedroom 4 Length: 11
  • Room Bedroom 4 Level: Basement
  • Room Bedroom 4 Width: 11

Dining Room

  • Room Dining Room Area: 121
  • Room Dining Room Features: "Laminate Floor"
  • Room Dining Room Length: 11
  • Room Dining Room Level: Main
  • Room Dining Room Width: 11

Kitchen

  • Room Kitchen Area: 195
  • Room Kitchen Features: "Laminate Floor"
  • Room Kitchen Length: 13
  • Room Kitchen Level: Main
  • Room Kitchen Width: 15

Primary Bedroom

  • Room Master Bathroom Features: "5 Piece Primary Bath"
  • Room Master Bedroom Area: 182
  • Room Master Bedroom Features: "Carpet"
  • Room Master Bedroom Length: 13
  • Room Master Bedroom Level: Upper
  • Room Master Bedroom Width

Windows

  • Window Features: "Double Pane Windows"

Property Map

Map View

$620,000 - 597 Tristan Pl, Berthoud, CO 80513

Street View

Directions

597 Tristan Pl
Berthoud, CO 80513
City: Berthoud

Nearby Schools

Local Sales

Photo of Sydney Sowy

Sydney Sowy

(210) 788-9633

Request Information

This content last updated on November 5, 2024 12:46AM. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.