597 Tristan Place

Berthoud, CO 80513

$627,000
Last Sold Price
4
Beds
4
Baths
2,649 Sq. Ft.
$237 / Sq. Ft.
2,649
Sq. Ft.
$237
per Sq. Ft.

Description

Stunning Corner Lot 4 Bedroom Home with Finished Basement and Mountain Views! Custom Designer Upgrades Throughout the Home! Natural light spills throughout the home. Master Bedroom has built-in shelves in the walk-in closet, barn doors, mountain views, and a luxury master bath! New High-End Carpet and Carpet Pad along with LVP Installed. To make your life easier the laundry room is upstairs with LG High Capacity Washer and Dryer. Designer lighting in the dining room. The kitchen is a home chef's...Stunning Corner Lot 4 Bedroom Home with Finished Basement and Mountain Views! Custom Designer Upgrades Throughout the Home! Natural light spills throughout the home. Master Bedroom has built-in shelves in the walk-in closet, barn doors, mountain views, and a luxury master bath! New High-End Carpet and Carpet Pad along with LVP Installed. To make your life easier the laundry room is upstairs with LG High Capacity Washer and Dryer. Designer lighting in the dining room. The kitchen is a home chef's dream kitchen with a gas cooktop, split oven with convection cooking, quartz countertops, upgraded Samsung Black Stainless Steel Kitchen Appliances, glass tile backsplash, and a kitchen island that is perfect to visit while cooking. The kitchen opens to a spacious living room with a fireplace perfect to curl up with a good book or enjoy a family evening at home. The basement has a large family room along with a 4th bedroom and bath. The large backyard is great for entertaining and enjoying our gorgeous sunsets. Sunrun Solar installed in the home with is compatible with electric car charging system and with a battery bank that can generate enough electricity to sustain a home for up to a week. Ecobee Smart Thermostat installed as well as Ring Security Doorbell and August Keyless Door Locks. Amazing treelined neighborhood close to pool and walking trails. Enjoy great restaurants and shopping!
  1. Listed by Matt Stover • Keller Williams Realty Success

Property Details for 597 Tristan Place

Structure Type
House
Architectural Style
Contemporary
View
Mountain(s)
Levels
Two
Stories
2
Subdivision Name
Heritage Ridge
Association
Yes
Multiple Associations
No

Location

Listing Courtesy of Keller Williams Realty Success, Matt Stover

Sold By Brokers Guild Homes, Mateo Gomez

Add your commute
LISTING UPDATED: 03/31/2022 09:33 AM

Property Details for 597 Tristan Place

StatusClosed
MLS #6048944
Days on Compass4
Taxes$4,658 / year
HOA Fees$195 / year
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential-Detached
Year Built2018
Lot Size0.18 AC / 7,741 SF
CountyLarimer County

Location

Listing Courtesy of Keller Williams Realty Success, Matt Stover

Sold By Brokers Guild Homes, Mateo Gomez

Add your commute

Building Information for 597 Tristan Place

Stories-Year Built2018Building Size-Lot Size0.18 AC / 7,741 SF

Payment Calculator

$3,826 per month

30 year fixed, 7.25% Interest

Principal and Interest

$3,422

Property Taxes

$388

HOA Dues

$16

The Payment Calculator is for illustrative purposes only.

Property Information for 597 Tristan Place

Interior Area & SqFt
Interior Area & SqFt
  • Building Area Total (SqFt Total): 2649
  • Sqft Total: 2649
  • Living Area (SqFt Finished): 2649
  • Above Grade Finished Area: 1849
  • Living SqFt: 1849
  • Sq Ft Apx: 800
  • Below Grade Unfinished Area: 0
  • Area Source: Public Records
  • PSF Total: 237
  • PSF Above Grade: 339
  • PSF Finished: 237
  • Master on Main: No
  • Room and Floor: Primary Bedroom-Upper-1, Primary Bathroom (Full)-Upper-1, Bedroom-Upper-1, Bedroom-Upper-2, Bathroom (Full)-Upper-1, Laundry-Upper-1, Loft-Upper-1, Living Room-Main-1, Kitchen-Main-1, Dining Room-Main-1, Bathroom (1/2)-Main-1, Bedroom-Basement-1, Family Room-Basement-1, Bathroom (Full)-Basement-1
  • Room Count: 14
  • Basement: Bath/Stubbed, Finished, Interior Entry/Standard
  • Heating: Forced Air
  • Cooling: Central Air
  • Interior Features: Eat-in Kitchen, Five Piece Bath, Kitchen Island, Primary Suite, Open Floorplan, Pantry, Quartz Counters, Smoke Free, Walk-In Closet(s)
  • Security Features: Security System, Smart Locks, Video Doorbell
  • Flooring: Carpet, Tile
  • Window Features: Double Pane Windows
  • Appliances: Cooktop, Dishwasher, Double Oven, Dryer, Microwave, Oven, Refrigerator, Self Cleaning Oven, Washer
Bed & Bath Summary
Bedrooms
  • Bedrooms Total: 4
  • Upper Level Bedrooms: 3
  • Main Level Bedrooms: 0
  • Lower Level Bedrooms: 0
  • Basement Level Bedrooms: 1
Bathrooms
  • Bathrooms Total: 4
  • Upper Level Bathrooms: 2
  • Main Level Bathrooms: 1
  • Lower Level Bathrooms: 0
  • Basement Level Bathrooms: 1
  • Bathrooms Full: 3
  • Bathrooms Three Quarter: 0
  • Bathrooms Half: 1
  • Bathrooms One Quarter: 0
Detailed Room Info
Room 1
  • Room Type: Primary Bedroom
  • Room Level: Upper
  • Room Description: Walk In Closet with Shelves
Room 2
  • Room Type: Primary Bathroom (Full)
  • Room Level: Upper
Room 3
  • Room Type: Bedroom
  • Room Level: Upper
Room 4
  • Room Type: Bathroom (Full)
  • Room Level: Upper
Room 5
  • Room Type: Bedroom
  • Room Level: Upper
Room 6
  • Room Type: Laundry
  • Room Level: Upper
  • Room Description: LG High Capacity Washer
Room 7
  • Room Type: Loft
  • Room Level: Upper
Room 8
  • Room Type: Living Room
  • Room Level: Main
Room 9
  • Room Type: Kitchen
  • Room Level: Main
Room 10
  • Room Type: Dining Room
  • Room Level: Main
Room 11
  • Room Type: Bathroom (1/2)
  • Room Level: Main
Room 12
  • Room Type: Bedroom
  • Room Level: Basement
Room 13
  • Room Type: Family Room
  • Room Level: Basement
Room 14
  • Room Type: Bathroom (Full)
  • Room Level: Basement
Parking
Parking
  • Attached Garage: Yes
  • Parking Type: Garage (Attached)
  • Parking Description: Garage (Attached)-3
  • Parking Details: 3
  • Parking Total: 1
  • Garage Spaces: 3
  • Offstreet Spaces: 0
  • Parking Count: 3
  • Carport Spaces: 0
  • Reserved Spaces: 0
  • RV Spaces: 0
Association Information
Association Information
  • Association Fee Total Annual: $195
  • Senior Community: No
Site & Location Information
School Information
  • Elementary School: Ivy Stockwell
  • Elementary School District: Thompson R2-J
  • Middle Or Junior School: Turner
  • High School: Berthoud
  • High School District: Thompson R2-J
Site & Location Information
  • Lot Size Acres: 0
  • Lot Size Square Feet: 7741
  • Lot Features: Corner Lot, Landscaped, Level, Sprinklers In Front
  • Fencing: Full
  • Property Exclusions: Sellers Personal Property
Building Information
Green Features
  • Green Verification Count: 0
Outbuildings
  • Out Building Count: 0
  • Horse: No
Building Information
  • Builder Name: Saint Aubyn Homes LLC
  • Construction Materials: Frame, Wood Siding
  • Roof: Composition
  • Exterior Features: Private Yard
  • Patio And Porch Features: Covered, Front Porch, Patio
  • Builder Model: McKinley
  • Livable Structure Count: 0
Water & Utilities
Water & Utilities
  • Water Included: Yes
  • Water Source: Public
  • Sewer: Community

Property History for 597 Tristan Place

DateEvent & SourcePriceAppreciation
DateEvent & SourcePrice

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 597 Tristan Place

Taxable ValueLand$10,780Additions$28,669Total$39,449
Tax Record2023$6,166 ($514 / month)
Home Facts
Beds4Total Finished SqFt1,849 SqFtAbove Grade Finished SqFt1,849 SqFtStories2Lot Size7,754 SqFtStyleSingle Family ResidenceYear Built2018CountyLARIMERAPN94234-36-008

Schools near 597 Tristan Place

This home is within Thompson R2-J School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Charter - K to 12
Rating
School
Distance
Ivy Stockwell Elementary School
PublicK to 5

Turner Middle School
Public6 to 8

Berthoud High School
Public9 to 12

Loveland Classical School
CharterK to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Sorry, we can't find any similar homes at this time. Please check back later.

Similar Sold Homes

Sorry, we can't find any similar sold homes at this time. Please check back later.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Keller Williams Realty Success, Matt Stover

The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Compass are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified. This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought. The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL. All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin. METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis. © 2024 METROLIST, INC., DBA RECOLORADO® - All Rights Reserved 6455 S. Yosemite St., Suite 300 Greenwood Village, CO 80111 USA. ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.