NOT LISTED FOR SALE

5400 Arrowhead Dr Greeley, CO 80634

Estimated Value: $884,000 - $913,000

6 Beds
4.5 Baths
4,512 Sq Ft
$199/Sq Ft Est. Value

Last Sold September 27, 2024

Last sale price $858,500 $190 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $4,964/month

Highlights

  • Parking available for a boat
  • 1.97 Acre Lot
  • Wood Frame Window
  • Barn or Stable
  • Wood Flooring
  • Enclosed Patio or Porch

About This Home

As of September 2024

Bring your horses and toys!! Discover your next home in this exceptional colonial-style farmhouse, perfectly situated on a stunning nearly 2-acre lot with spectacular southern views. Boasting 6 bedrooms and 4.5 baths, this property offers all the space and comfort you need. Highlights include: Gourmet Chef's Kitchen: Designed by William Ohs, featuring high-end Wolf Pro-Oven/Range, Sub-Zero fridge, 2 dishwashers, 2 large islands with granite countertops-perfect for entertaining and meal prep-a dinette, bar seating, a window seat, and ample storage. Elegant Main Level: Gleaming hardwood floors throughout, formal living and dining rooms, a cozy family room, and a charming enclosed porch with three walls of windows. Finished Basement: Complete with a kitchenette, recreation room, two additional bedrooms, and a full bath. Oversized Attached 3-Car Garage: Provides plenty of room for vehicles and storage. Impressive Outbuildings: Includes a large shed and barn, one with 3 horse stalls, room for up to 6 cars, a tack room, and an additional covered parking area. Fully Fenced Yard: Ensures privacy and security for you and your horses. Irrigation water $650 per year. This home combines functionality and charm, offering a unique opportunity for those seeking a rural lifestyle with modern amenities. Don't miss out on this exceptional property designed for both comfort and convenience-make this extraordinary property your new home today!

Last Agent to Sell the Property

Mark Despain

Listed on: 08/06/2024

Last Buyer's Agent

Mark Despain

Listed on: 08/06/2024

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,559

Year Built

  • Built in 1994

Lot Details

  • 1.97 Acre Lot
  • Fenced
  • Sprinkler System

HOA Fees

  • $4 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Parking available for a boat

Home Design

  • Wood Frame Construction
  • Composition Roof

Interior Spaces

  • 4,512 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Ceiling Fan
  • Bay Window
  • Wood Frame Window
  • Family Room
  • Dining Room
  • Recreation Room with Fireplace

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Outdoor Features

  • Enclosed Patio or Porch
  • Outdoor Storage

Schools

  • Prairie Heights Middle School
  • Greeley West High School

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Barn or Stable

Utilities

  • Evaporated cooling system
  • Zoned Heating
  • Baseboard Heating
  • Hot Water Heating System
  • Septic System

Community Details

  • Arrowhead Association, Phone Number (303) 710-1542
  • Arrowhead Subdivision

Listing and Financial Details

  • Assessor Parcel Number R2732486

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,559

Year Built

Built in 1994

Lot Details

0

HOA Fees

$4 per month

Parking

3

Listing Details

  • Inclusions: Gas Range/Oven,Dishwasher,Refrigerator,Clothes Washer,Clothes Dryer,Microwave,Disposal
  • Year Built: 1994
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: Yes
  • Lot Size Acres: 1.97
  • Subdivision Name: Arrowhead
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 4512
  • Special Features: VirtualTour
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: 2 or more H20 Heaters, Gas Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
  • Has Basement: Full, Sump Pump
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 6
  • Fireplace Features: Family/Recreation Room Fireplace
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Eat-in Kitchen, Separate Dining Room, Pantry, Stain/Natural Trim, Walk-In Closet(s), Wet Bar, Kitchen Island
  • Window Features: Wood Frames, Bay Window(s)
  • Bedroom Features: Wood Floor
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: Yes
  • Room Bedroom4 Level: Upper
  • Living Room Living Room Level: Main
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom3 Level: Upper
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Bedroom5 Level: Basement
  • Room Bedroom5 Features: Wood Floor
  • Room Family Room Level: Main
  • Room Kitchen Features: Wood Floor
  • Family Room Features: Wood Floor
  • Living Room Features: Wood Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: 5 Piece Primary Bath

Exterior Features

  • Roof: Composition
  • Fencing: Fenced, Other
  • Lot Features: Lawn Sprinkler System
  • View: No
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Home Warranty: No
  • Construction Type: Wood/Frame
  • Other Structures: Storage
  • Patio And Porch Features: Patio, Enclosed
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: RV/Boat Parking, Oversized
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Evaporative Cooling, Ceiling Fan(s)
  • Electric: Electric, Xcel
  • Heating: Hot Water, Baseboard, Zoned Heat
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electricity On Property: No
  • Sewer: Septic
  • Water Source: City Water, City
  • Gas Company: Natural Gas, Atmos

Condo/Co-op/Association

  • Senior Community: No
  • Association Fee: 50
  • Association Fee Frequency: Annually
  • Association Name: Arrowhead
  • Phone: 303-710-1542
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Other
  • HighSchool: Greeley West
  • Junior High Dist: Greeley 6
  • Middle Or Junior School: Prairie Heights

Lot Info

  • Zoning: RES
  • Current Use: Horses
  • Horse Amenities: Barn with 3+ Stalls
  • Lot Size Sq Ft: 85813
  • Parcel #: R2732486
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 3559

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 6, 2024
Closed on
Sep 27, 2024
Sold by
Barbara C Schulthess Revocable Trust and Schulthess Barbara C
Bought by
Widel Kenneth and Widel Linda
Seller's Agent
Mark Despain
Buyer's Agent
Mark Despain
List Price
$865,000
Sold Price
$858,500
Premium/Discount to List
-$6,500
-0.75%
Views
4
Current Estimated Value
$898,410

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$39,910
Avg. Annual Appreciation
3.59%

Purchase Details

Closed on
Mar 26, 2014
Sold by
Morgan Barbara C Schulthess
Bought by
Schulthess Barbara C

Purchase Details

Listed on
Aug 15, 2013
Closed on
Oct 21, 2013
Sold by
Wilson Brett T and Wilson Brenda L
Bought by
Schulthess Morgan Barbara C
Seller's Agent
Eric Kronwall
RE/MAX Advanced Inc.
Buyer's Agent
Randy Moser
Sears Real Estate
List Price
$485,000
Sold Price
$425,000
Premium/Discount to List
-$60,000
-12.37%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.31%
Original Mortgage
$318,750
Interest Rate
4.62%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 9, 2004
Sold by
Deutsche Bank National Trust Co
Bought by
Wilson Brett T and Wilson Brenda L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$300,000
Interest Rate
4.12%
Mortgage Type
Unknown

Purchase Details

Closed on
Nov 7, 2003
Sold by
Redfern Ronald E
Bought by
Deutsche Bank National Trust

Purchase Details

Closed on
May 10, 2001
Sold by
Redfern Ronald E
Bought by
Redfern Ronald E and Redfern Jodie R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$340,000
Interest Rate
8.35%

Purchase Details

Closed on
Sep 9, 1994
Sold by
Meek Inc
Bought by
Redfern Ronald E and Redfern Jodie R

Purchase Details

Closed on
Nov 30, 1993
Sold by
Lake Arrowhead Inc
Bought by
Meek Inc
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Widel Kenneth $858,500 8Z Title
Schulthess Barbara C -- None Available
Schulthess Morgan Barbara C $425,000 Fidelity National Title Insu
Wilson Brett T $375,000 --
Deutsche Bank National Trust $376,485 --
Redfern Ronald E -- --
Redfern Ronald E -- --
Redfern Ronald E $187,500 --
Meek Inc $39,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Schulthess Morgan Barbara C $318,750
Previous Owner Wilson Brett T $300,000
Previous Owner Redfern Ronald E $340,000
Closed Redfern Ronald E $50,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
09/27/2024 09/27/24 Sold $858,500 -0.8% $190 / Sq Ft
08/08/2024 08/08/24 For Sale $865,000 +103.5% $192 / Sq Ft
01/28/2019 01/28/19 Off Market $425,000 -- --
10/21/2013 10/21/13 Sold $425,000 -12.4% $94 / Sq Ft View Prior Sale
09/21/2013 09/21/13 Pending -- -- --
08/15/2013 08/15/13 For Sale $485,000 -- $107 / 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,157 $53,010 $11,390 $41,620
2024 $3,157 $53,010 $11,390 $41,620
2023 $3,559 $47,720 $12,110 $35,610
2022 $3,613 $41,060 $12,570 $28,490
2021 $3,749 $42,240 $12,930 $29,310
2020 $3,612 $40,840 $9,890 $30,950
2019 $3,620 $40,840 $9,890 $30,950
2018 $3,549 $42,230 $5,800 $36,430
2017 $3,572 $42,230 $5,800 $36,430
2016 $2,575 $34,460 $4,540 $29,920
2015 $2,583 $34,460 $4,540 $29,920
2014 $2,272 $29,740 $5,670 $24,070
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 1015928

IRES MLS

APN: R2732486