NOT LISTED FOR SALE

237 N 54th Ave Greeley, CO 80634

Kelly Farm Neighborhood

Estimated Value: $589,120 - $676,000

3 Beds
2 Baths
3,485 Sq Ft
$186/Sq Ft Est. Value

Last Sold July 31, 2013

Last sale price $260,000 $75 Per Sq Ft

Est. 150% increase in value since last sale

Current estimated payment $3,777/month

10 Days on Market

Highlights

  • Open Floorplan
  • Clubhouse
  • Contemporary Architecture
  • Mountain View
  • Deck
  • Cathedral Ceiling

About This Home

As of July 2013

Super value in Kelly Farm! This stylish ranch is ready to impress! 3 Large rooms, 2 full baths, full unfinished walkout basement. Big kitchen and dining area with wood floors and Alder cabinetry. Large master with 5-piece bath and walk-in closet. Main floor laundry, see through fireplace, vaulted ceilings, central air and professional landscaping. See this one today! Under contract...multiple offers received

Last Agent to Sell the Property

Steve Baker

Sears Real Estate Listed on: 06/21/2013

Sears Real Estate

Co-Listed By

Derek Andersen

Andersen Real Estate

Last Buyer's Agent

Ryan Andre

Sears Real Estate

Sears Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,546

Year Built

  • Built in 2002

Lot Details

  • 9,491 Sq Ft Lot
  • South Facing Home
  • Southern Exposure
  • Partially Fenced Property
  • Level Lot
  • Sprinkler System
  • Property is zoned RL

HOA Fees

  • $13 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Oversized Parking
  • Garage Door Opener

Home Design

  • Contemporary Architecture
  • Composition Roof
  • Stucco
  • Stone

Interior Spaces

  • 3,485 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Ceiling Fan
  • Double Sided Fireplace
  • Gas Log Fireplace
  • Double Pane Windows
  • Window Treatments
  • Living Room with Fireplace
  • Dining Room
  • Mountain Views

Kitchen

  • Electric Oven or Range
  • Self-Cleaning Oven
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms
  • Primary bathroom on main floor

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Unfinished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Accessible Home Design

  • Garage doors are at least 85 inches wide

Outdoor Features

  • Deck
  • Exterior Lighting

Schools

  • Mcauliffe Elementary School
  • Franklin Middle School
  • Northridge High School

Utilities

  • Forced Air Heating and Cooling System
  • Satellite Dish
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R8474200

Community Details

Overview

  • Association fees include common amenities, management
  • Kelly Farm Subdivision

Amenities

  • Clubhouse

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,546

Year Built

Built in 2002

Lot Details

0

HOA Fees

$13 per month

Parking

2

Listing Details

  • Year Built: 2002
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.22
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Co List Office Mls Id: 1SEAR
  • Subdivision Name: Kelly Farm
  • Above Grade Finished Sq Ft: 1794
  • Architectural Style: Contemporary/Modern, Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Efficiency: Southern Exposure
  • Building Stories: 1
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3485
  • Special Features: None
  • Stories: 1

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Self Cleaning Oven, Dishwasher, Microwave, Disposal
  • Accessibility Features: Level Lot, Main Floor Bath, Main Level Bedroom, Main Level Laundry
  • Has Basement: Full, Unfinished, Walk-Out Access
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 1691
  • Fireplace Features: Gas, Gas Logs Included, Double Sided, Living Room, Dining Room
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Satellite Avail, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Walk-In Closet(s)
  • Living Area: 1794
  • Window Features: Window Coverings, Double Pane Windows
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: No
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 144
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom2 Area: 165
  • Room Bedroom3 Level: Main
  • Master Bedroom Master Bedroom Width: 17
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Room Living Room Area: 304
  • Living Room Features: Carpet
  • Room Kitchen Area: 182
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 255
  • Room Dining Room Area: 182
  • Master Bathroom Features: 5 Piece Primary Bath

Exterior Features

  • Roof: Composition
  • Fencing: Partial, Other
  • Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Sloped
  • View: Mountain(s)
  • Waterfront: No
  • Construction Type: Stone, Stucco
  • Direction Faces: South
  • Exterior Features: Lighting
  • Patio And Porch Features: Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: Garage Door Opener, >8' Garage Door, Oversized
  • IRESDS_Garage Sq Ft: 472
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, Xcel
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, City of Greeley
  • Gas Company: Natural Gas, Atmos

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Management
  • Community Features: Clubhouse, Pool
  • Senior Community: No
  • Association Fee: 150
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Mcauliffe
  • HighSchool: Northridge
  • Junior High Dist: Greeley 6
  • Middle Or Junior School: Franklin

Lot Info

  • Zoning: RL
  • Lot Size Sq Ft: 9491
  • Parcel #: R8474200
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2011
  • Tax Annual Amount: 1546

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 21, 2013
Closed on
Jul 31, 2013
Sold by
Distelhorst Michael C
Bought by
Hansen Curtis M and Hansen Terra L
Seller's Agent
Steve Baker
Sears Real Estate
Buyer's Agent
Ryan Andre
Sears Real Estate
List Price
$249,900
Sold Price
$260,000
Premium/Discount to List
$10,100
4.04%
Current Estimated Value
$649,280

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$389,280
Avg. Annual Appreciation
7.53%
Original Mortgage
$247,715
Interest Rate
3.93%
Mortgage Type
VA

Purchase Details

Closed on
Aug 29, 2002
Sold by
Master Home Source Corp
Bought by
Distelhorst Michael C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$251,750
Interest Rate
6.47%
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Hansen Curtis M $260,000 Land Title Guarantee Company
Distelhorst Michael C $265,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hansen Curtis M $300,000
Closed Hansen Curtis M $32,000
Closed Hansen Curtis M $247,715
Previous Owner Distelhorst Michael C $25,000
Previous Owner Distelhorst Michael C $280,000
Previous Owner Distelhorst Michael C $251,750
Previous Owner Master Home Source Corp $192,600
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/28/2019 01/28/19 Off Market $260,000 -- --
07/31/2013 07/31/13 Sold $260,000 +4.0% $75 / Sq Ft
07/01/2013 07/01/13 Pending -- -- --
06/21/2013 06/21/13 For Sale $249,900 -- $72 / Sq Ft
Source: IRES MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $3,049 $38,120 $7,190 $30,930
2024 $3,049 $38,120 $7,190 $30,930
2023 $2,908 $39,840 $6,220 $33,620
2022 $2,748 $31,360 $6,390 $24,970
2021 $2,835 $32,270 $6,580 $25,690
2020 $2,559 $29,220 $5,010 $24,210
2019 $2,327 $26,500 $5,010 $21,490
2018 $2,004 $24,070 $5,400 $18,670
2017 $2,014 $24,070 $5,400 $18,670
2016 $1,596 $21,450 $4,380 $17,070
2015 $1,590 $21,450 $4,380 $17,070
2014 $1,468 $19,330 $3,580 $15,750
Source: Public Records

Agents Affiliated with this Home

  • Steve Baker

    Seller's Agent in 2013

    Steve Baker

    Sears Real Estate

    (970) 330-7700

    9 in this area

    403 Total Sales

    Steve Baker
    Section Image
  • Derek Andersen

    Seller Co-Listing Agent in 2013

    Derek Andersen

    Andersen Real Estate

    (970) 381-9491

    8 in this area

    231 Total Sales

    Derek Andersen
    Section Image
  • Ryan Andre

    Buyer's Agent in 2013

    Ryan Andre

    Sears Real Estate

    (970) 330-7700

    4 in this area

    197 Total Sales

    Ryan Andre
    Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 711836

IRES MLS

APN: R8474200

Colorado Weld County Greeley 80634 Kelly Farm

237 N 54th Ave, Greeley, CO

This home is located at 237 N 54th Ave, Greeley, CO 80634 since 21 June 2013 and is currently estimated at $649,280, approximately $186 per square foot. This property was built in 2002. 237 N 54th Ave is a home located in Weld County with nearby schools including S. Christa McAuliffe STEM Academy, Franklin Middle School, and Northridge High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

IRES MLS Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.

Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Information deemed reliable but not guaranteed by the MLS.

Nearby Homes