NOT LISTED FOR SALE

424 Celtic Rd Johnstown, CO 80534

Estimated Value: $754,313 - $823,000

6 Beds
4.5 Baths
3,427 Sq Ft
$227/Sq Ft Est. Value

Last Sold August 07, 2012

Last sale price $346,000 $101 Per Sq Ft

Est. 125% increase in value since last sale

Current estimated payment $4,544/month

23 Days on Market

Highlights

  • Fitness Center
  • Mountain View
  • Deck
  • Open Floorplan
  • Clubhouse
  • Cathedral Ceiling

About This Home

As of August 2012

Grand entry to this gorgeous 2 Story w/curved staircase & wrought iron (2nd staircase from family room). Built in cherry hutch in dining room upgraded 42" cherry cabinets in kitchen along w/granite slab counter-tops. 12x16 deck off the master bedroom. 30x16 deck off the kitchen. Mountain views! Partially finished basement w/22x16 bedroom & 3/4 bath. 20" Porcelain tiles in entry, dining and kitchen. 4-car garage is plumbed for gas heat.3-zone forced air heating. Home sold for $462,935 on 9/7/07.

Last Agent to Sell the Property

David Fredlake

Northern Colorado Realty Listed on: 06/09/2012

Co-Listed By

Margo Fredlake

Prime Property Management

Last Buyer's Agent

Sarah Long

RE/MAX Alliance-Loveland

RE/MAX Alliance-Loveland

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,930

Year Built

  • Built in 2007

Lot Details

  • 10,150 Sq Ft Lot
  • Partially Fenced Property
  • Wood Fence
  • Level Lot
  • Sprinkler System

HOA Fees

  • $40 Monthly HOA Fees

Parking

  • 4 Car Attached Garage
  • Tandem Parking

Home Design

  • Brick Veneer
  • Wood Frame Construction
  • Composition Roof

Interior Spaces

  • 3,427 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Dining Room
  • Home Office
  • Loft
  • Mountain Views
  • Radon Detector
  • Washer and Dryer Hookup

Kitchen

  • Eat-In Kitchen
  • Electric Oven or Range
  • Kitchen Island
  • Disposal

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • Jack-and-Jill Bathroom
  • Primary bathroom on main floor
  • Walk-in Shower

Finished 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

  • Pioneer Ridge Elementary School
  • Milliken Middle School
  • Roosevelt High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R3993806

Community Details

Overview

  • Association fees include common amenities
  • Built by Advocate Homes
  • Grand View Estates Subdivision

Amenities

  • Sauna
  • Clubhouse

Recreation

  • Community Playground
  • Fitness Center
  • Community Pool
  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,930

Year Built

Built in 2007

Lot Details

0

HOA Fees

$40 per month

Parking

4

Listing Details

  • Year Built: 2007
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.23
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Co List Office Mls Id: 9RMNA
  • Subdivision Name: Grand View Estates
  • Directions: From I-25 and Hwy 60, N on Carlson Blvd, E on Brunner, N on Sloan, N on Celtic Rd to Property
  • Above Grade Finished Sq Ft: 2968
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • Special Features: None
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Disposal
  • Accessibility Features: Main Floor Bath, Main Level Bedroom, Stall Shower
  • Has Basement: Full, 25%+Finished Basement, Walk-Out Access, Built-In Radon
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 1530
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Interior Amenities: Study Area, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Loft, Jack & Jill Bathroom, Kitchen Island
  • Living Area: 3427
  • Window Features: Window Coverings, Double Pane Windows
  • Room Bedroom4 Area: 140
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Tile Floor
  • Room Bedroom4 Level: Upper
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 182
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 144
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 15
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Bedroom5 Level: Main
  • Room Bedroom5 Features: Carpet
  • Room Bedroom5 Area: 228
  • Room Kitchen Features: Tile Floor
  • Room Living Room Area: 195
  • Living Room Features: Carpet
  • Room Kitchen Area: 306
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 315
  • Room Dining Room Area: 180
  • Master Bathroom Features: Luxury Features Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Composition
  • Builder Name: Advocate Homes
  • Fencing: Partial, Wood
  • Lot Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Level
  • View: Mountain(s)
  • Waterfront: No
  • Construction Type: Wood/Frame, Brick/Brick Veneer
  • Exterior Features: Lighting
  • Patio And Porch Features: Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 4
  • Garage Spaces: 4
  • Parking Features: >8' Garage Door, Oversized, Tandem
  • IRESDS_Garage Sq Ft: 830
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Electric, Xcel
  • Heating: Forced Air, Zoned
  • 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, Town of Johnstown
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities
  • Community Features: Clubhouse, Pool, Sauna, Playground, Fitness Center, Park
  • Senior Community: No
  • Association Fee: 40
  • Association Fee Frequency: Monthly
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Pioneer Ridge
  • HighSchool: Roosevelt
  • Junior High Dist: Weld RE-5J
  • Middle Or Junior School: Milliken

Lot Info

  • Zoning: Resi
  • Lot Size Sq Ft: 10150
  • Parcel #: R3993806
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2010
  • Tax Annual Amount: 3930

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 9, 2012
Closed on
Aug 7, 2012
Sold by
Banner Investments Llc
Bought by
Mcmullen James R and Mcmullen Karen M
Seller's Agent
David Fredlake
Northern Colorado Realty
Buyer's Agent
Sarah Long
RE/MAX Alliance-Loveland
List Price
$349,900
Sold Price
$346,000
Premium/Discount to List
-$3,900
-1.11%
Total Days on Market
23
Current Estimated Value
$779,328

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$433,328
Avg. Annual Appreciation
6.58%
Original Mortgage
$328,700
Interest Rate
3.68%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jun 9, 2012
Closed on
Jun 18, 2012
Sold by
Beldon Jeremy Jay and Beldon Karen Elisabeth
Bought by
Banner Investments Llc
Seller's Agent
David Fredlake
Northern Colorado Realty
Buyer's Agent
Sarah Long
RE/MAX Alliance-Loveland
List Price
$349,900
Sold Price
$346,000
Premium/Discount to List
-$3,900
-1.11%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$328,700
Interest Rate
3.68%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 7, 2007
Sold by
Advocate Land Co Inc
Bought by
Beldon Jeremy Jay and Beldon Karen Elisabeth

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$48,500
Interest Rate
6.42%
Mortgage Type
Credit Line Revolving
Source: Public Records

Similar Homes in Johnstown, CO

  • 4123 Shirley Dr, Johnstown, CO 80534

    $612,416

    • 5 Beds
    • 4 Baths
    • 2,775 Sq Ft
    • 4123 Shirley Dr
    • Johnstown, CO

    Eligible for 3.99 7/6 ARM or 4.99% fixed rate when using builder's preferred lender - terms and conditions apply - ask for details*******Contact Lennar today about Special Financing for this home - terms and conditions apply**Available NOW! This gorgeous Stonehaven 2-story in Ledge Rock features 5 beds (4 upper / 1 main), 4 baths, great room, spacious kitchen, mudroom, 3 car garage (2 + 1 tandem)

    Tom Ullrich RE/MAX Professionals

    Section Image
  • 4163 Shirley Dr, Johnstown, CO 80534

    $599,387

    • 5 Beds
    • 4 Baths
    • 2,775 Sq Ft
    • 4163 Shirley Dr
    • Johnstown, CO

    **This home eligible for 3.99% FHA / VA OR 4.50% conventional loan rate when using builder's preferred lender - terms and conditions apply - ask for details*****Contact Lennar today about Special Financing for this home - terms and conditions apply**Available NOW! This gorgeous Stonehaven 2-story in Ledge Rock features 5 beds (4 upper / 1 main), 4 baths, great room, spacious kitchen, mudroom, 3

    Tom Ullrich RE/MAX Professionals

    Section Image
  • 1442 Mallard Dr, Johnstown, CO 80534

    $749,900

    • 6 Beds
    • 4.5 Baths
    • 4,332 Sq Ft
    • 1442 Mallard Dr
    • Johnstown, CO

    Nestled in a quiet, desirable neighborhood, this beautifully maintained home offers the perfect blend of comfort, style, and convenience. Boasting 6 bedrooms and 5 bathrooms across 4322 sq ft, this residence features a spacious open floor plan with abundant natural light and modern finishes throughout. The heart of the home is the updated kitchen, complete with granite countertops, Bosch &

    Lisa Spears RE/MAX Town and Country

    Section Image
  • 4327 Lacewood Ln, Johnstown, CO 80534

    $665,000

    • 5 Beds
    • 4 Baths
    • 3,455 Sq Ft
    • 4327 Lacewood Ln
    • Johnstown, CO

    This beautifully maintained ranch-style home offers a bright, open floor plan with 5 bedrooms and 4 bathrooms. The main level features a luxurious primary suite, a second bedroom, and a dedicated office, all enhanced by rich wood flooring. The spacious, modern kitchen is a chef's dream, complete with premium KitchenAid appliances, ample cabinetry, expansive countertops, a large center island, a

    Amy Black Elevations Real Estate, LLC

    Section Image

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
Mcmullen James R $346,000 Land Title Guarantee Company
Banner Investments Llc -- None Available
Beldon Jeremy Jay $462,935 Title America
Advocate Land Co Inc -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mcmullen James R $400,000
Open Rearden Minerals Llc $500,000,000
Closed Mcmullen James R $216,000
Closed Mcmullen James R $300,000
Closed Mcmullen James R $328,700
Previous Owner Beldon Jeremy Jay $48,500
Previous Owner Beldon Jeremy Jay $370,300
Previous Owner Twin Silos Llc $1,543,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/28/2019 01/28/19 Off Market $346,000 -- --
08/07/2012 08/07/12 Sold $346,000 -1.1% $101 / Sq Ft
07/08/2012 07/08/12 Pending -- -- --
06/09/2012 06/09/12 For Sale $349,900 -- $102 / 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
2024 $4,410 $47,370 $9,380 $37,990
2023 $4,142 $48,900 $5,750 $43,150
2022 $4,194 $39,100 $5,800 $33,300
2021 $4,520 $40,230 $5,970 $34,260
2020 $3,768 $34,500 $5,580 $28,920
2019 $2,947 $34,500 $5,580 $28,920
2018 $2,929 $34,260 $5,540 $28,720
2017 $2,977 $34,260 $5,540 $28,720
2016 $2,532 $29,130 $3,060 $26,070
2015 $2,567 $29,130 $3,060 $26,070
2014 $2,421 $28,350 $2,850 $25,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 683623

IRES MLS

APN: R3993806