NOT LISTED FOR SALE

504 Crestland Ave Columbia, MO 65203

Estimated Value: $308,000 - $369,000

3 Beds
3 Baths
1,641 Sq Ft
$203/Sq Ft Est. Value

Last Sold June 26, 2020

Current estimated payment $2,057/month

30 Days on Market

Highlights

  • Traditional Architecture
  • Wood Flooring
  • Screened Porch
  • David H. Hickman High School Rated A-
  • No HOA
  • Formal Dining Room

About This Home

As of June 2020

Old SW charmer located only a mile from downtown COMO - lovingly maintaining the vintage details. The welcoming front entry is flanked by 2 majestic trees. You'll love the adorable kitchen with classic white cabinetry, hardwood flooring throughout, comfortable living room with fireplace, screen porch and deep-private-fenced backyard. Nicely sized bedrooms all have ample closets. Lower level family room to enjoy TV while finishing up the laundry! Half bath & great storage on this level that walks UP to the backyard. All brick construction! High efficiency HVAC! Single garage with newer garage door.

Last Agent to Sell the Property

Susan Horak

RE/MAX Boone Realty License #1999124573 Listed on: 05/27/2020

RE/MAX Boone Realty

Last Buyer's Agent

Julia Seitz

Modern Property Groups, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,097

Year Built

  • Built in 1940

Lot Details

  • Lot Dimensions are 74.40 x 150
  • West Facing Home
  • Wood Fence
  • Back Yard Fenced
  • Cleared Lot

Parking

  • 1 Car Detached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof

Interior Spaces

  • 2-Story Property
  • Ceiling Fan
  • Paddle Fans
  • Wood Burning Fireplace
  • Screen For Fireplace
  • Wood Frame Window
  • Family Room
  • Living Room with Fireplace
  • Formal Dining Room
  • Screened Porch
  • Partially Finished Basement
  • Interior and Exterior Basement Entry
  • Washer and Dryer Hookup

Kitchen

  • Electric Range
  • Dishwasher
  • Laminate Countertops
  • Disposal

Flooring

  • Wood
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms

Home Security

  • Storm Doors
  • Fire and Smoke Detector

Outdoor Features

  • Patio
  • Storage Shed

Schools

  • Russell Boulevard Elementary School
  • West Middle School
  • Hickman High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Heat Pump System
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Westridge Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1660500030190001

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,097

Year Built

Built in 1940

Lot Details

0

Parking

1

Listing Details

  • Directions: From Stadium turn north onto West Blvd left onto W Rollins right onto Crestland Ave
  • Lot Size: 74.40 x 150
  • Prop. Type: Residential
  • Year Built: 1940
  • BathsFull34Total: 1
  • BathsFull34UpperLevel: 1
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained
  • Subdivision Name: WESTRIDGE
  • Above Grade Finished Sq Ft: 1416.0
  • Architectural Style: 2 Story
  • Cooling:Central Electric: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Gas-Natural: Yes
  • Flooring:Laminate: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Baths-Half:Main Level2: 1
  • Baths-Half:Total2: 2
  • Rooms:Dining Room: Yes
  • Rooms:Family Room2: Yes
  • Rooms:Living Room: Yes
  • Foundation Type:Full Bsmt Part Fin: Yes
  • Cooling:Heat Pump(s): Yes
  • Foundation Access:Inside Entrance: Yes
  • Foundation Access:Outside Entrance: Yes
  • Dining:Formal Dining: Yes
  • TopoLot Description:Cleared: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Wood2: Yes
  • Heat Fuel:Electricity: Yes
  • Heat Type:Heat Pump(s)2: Yes
  • Patio:Concrete2: Yes
  • Garage Type Detached: Yes
  • Fence:Backyard: Yes
  • Fence Material:Wood5: Yes
  • Outbuildings:LawnStorage Shed: Yes
  • Baths-Half:Lower Level2: 1
  • Fence:Full: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Porch:Side2: Yes
  • Porch:Screened2: Yes
  • Special Features: None

Interior Features

  • Flooring: Wood, Laminate, Tile
  • Interior Amenities: High Spd Int Access, Washer/DryerConnectn, Ceiling/PaddleFan(s), Cable Ready, Storm Door(s), Smoke Detector(s), Garage Dr Opener(s), FireplaceScreenDr(s), Formal Dining, Counter-Laminate, Cabinets-Wood, Pantry
  • Basement YN: Yes
  • Full Bathrooms: 1
  • Half Bathrooms: 2
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 225.0
  • Fireplace Features: In Living Room, Wood Burning
  • Fireplace: Yes
  • Living Area: 1641.0
  • InteriorFeatures:Cable Ready: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:In Living Room: Yes
  • Fireplace:Wood Burning: Yes
  • KitchenFeatures:Range-Electric: Yes
  • InteriorFeatures:FireplaceScreenDr(s): Yes
  • InteriorFeatures:Storm Door(s): Yes
  • KitchenFeatures:Counter-Laminate: Yes

Exterior Features

  • Exterior Features: Driveway-Paved, Windows-Wood
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Full, Wood
  • Lot Features: Cleared
  • Direction Faces: West
  • Foundation Details: Poured Concrete
  • Other Structures: Lawn/Storage Shed
  • Patio And Porch Features: Concrete, Back, Side Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Wood: Yes

Garage/Parking

  • Garage Spaces: 1.0
  • Parking Features: Detached
  • General Property Description:Garage Capacity: 1
  • InteriorFeatures:Garage Dr Opener(s): Yes

Utilities

  • Utilities: Water-City, Gas-Natural, Sewage-City, Electric-City, Trash-City
  • Cooling: Heat Pump(s), Central Electric
  • Heating: Heat Pump(s), Forced Air, Electric, Natural Gas
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Elementary School: Russell Boulevard
  • Junior High Dist: Columbia
  • High School: Hickman
  • Middle Or Junior School: West

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 1660500030190001
  • Zoning Description: R-1 One- Family Dwelling*

Tax Info

  • Tax Annual Amount: 2096.93
  • Tax Year: 2019

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 27, 2020
Closed on
Jun 26, 2020
Sold by
Beck Mark Cordes and Mark Cordes Beck Revocbale Trs
Bought by
Piester Andrew and Piester Stephanie
Seller's Agent
Susan Horak
RE/MAX Boone Realty
Buyer's Agent
Julia Seitz
Modern Property Groups, LLC
List Price
$254,000
Sold Price
$254,000
Total Days on Market
30
Current Estimated Value
$333,648

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$79,648
Avg. Annual Appreciation
5.64%
Original Mortgage
$244,000
Interest Rate
3.2%
Mortgage Type
VA

Purchase Details

Listed on
Apr 3, 2017
Closed on
May 31, 2017
Sold by
Hanuscin Deborah L and Mower Matthew
Bought by
Beck Mark Cordes and The Mark Cordes Beck Revocable
Seller's Agent
Julie Wesley
House of Brokers Realty, Inc.
Buyer's Agent
Sara Jeffrey
House of Brokers Realty, Inc.
List Price
$220,000
Sold Price
$214,000
Premium/Discount to List
-$6,000
-2.73%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.74%
Original Mortgage
$203,300
Interest Rate
3.97%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 2, 2005
Sold by
Waters Andrew and Waters Suzette
Bought by
Hanuscin Deborah L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$168,300
Interest Rate
5.71%
Mortgage Type
New Conventional
Source: Public Records

Similar Homes in Columbia, MO

  • 368 Crown Point, Columbia, MO 65203

    $370,000

    • 4 Beds
    • 2 Baths
    • 2,106 Sq Ft
    • 368 Crown Point
    • Columbia, MO

    This four-bedroom, two-bathroom home boasts a convenient off-Broadway location, a large fully fenced backyard, a lower-level ensuite with separate entrance, and so much more! The downstairs flex space has potential as an airbnb, mother-in-law suite, or a separate fourth bedroom. The dishwasher and gas range are new. The exterior of the home is clad in brick on all four sides, and main and upper

    Cale Childers Century 21 Access

    Section Image
  • 1509 W Rollins Rd, Columbia, MO 65203

    $350,000

    • 4 Beds
    • 4 Baths
    • 2,125 Sq Ft
    • 1509 W Rollins Rd
    • Columbia, MO

    Hello and WELCOME to 1509 W Rollins Road! It's an inviting 1.5 story home in Columbia's Sunset Hills, just past Russell Elementary. This 4-bed, 2-full bath, 2 half-bath home offers over 2,100 finished sq ft, a walkout basement, formal dining room, two fireplaces, and a screened-in deck perfect for quiet mornings or bug-free summer nights. Upstairs are 4 beds and 2 full baths. The primary suite is

    Billy Dexheimer North Star Real Estate

    Section Image
  • 1000 Yale, Columbia, MO 65203

    $365,000

    • 4 Beds
    • 3 Baths
    • 2,207 Sq Ft
    • 1000 Yale
    • Columbia, MO

    Charming 4-bed, 3-bath split-level in desirable College Park-just minutes from shopping and the University of Missouri. This well-maintained & UPDATED home offers tons of storage, pretty tile in the semi-private main bath & custom shower connects the hall and primary suite. Built-in bookshelves in the living room and main-level den with a Cozy SEE-THRU fireplace. The kitchen features a gas stove

    Julie Wesley House of Brokers Realty, Inc.

    Section Image
  • 1402 Jean Rae Dr, Columbia, MO 65203

    $275,000

    • 3 Beds
    • 2 Baths
    • 1,527 Sq Ft
    • 1402 Jean Rae Dr
    • Columbia, MO

    This spacious 3-bedroom, 2-bathroom residence offers comfort, convenience, and room to breathe—both inside and out. Unwind in the stunning sunroom or enjoy the peace and privacy of the park-like backyard, perfect for relaxing evenings or entertaining guests.Inside, you'll love the soaring ceilings in the living room that create an open, airy feel. The home features a rare combination of three

    Dalton Rice House of Brokers Realty, Inc.

    Section Image
  • 3912 Bragg Ct, Columbia, MO 65202

    $264,900

    • 3 Beds
    • 2.5 Baths
    • 1,558 Sq Ft
    • 3912 Bragg Ct
    • Columbia, MO

    Check out this 2-story new construction home built by Hemme Construction in The Cottages of Northridge! Located in Northern Columbia, this new development is close to shops and restaurants and is located in the Blue Ridge Elementary, Oakland Middle School, and Battle High School districts. These 16 lots sit on a quiet street, ensuring privacy and safety for your family. The main level features a

    Orie Hemme Copper Creek Realty

    Section Image
  • 2020 Martinshire Dr, Columbia, MO 65203

    $289,000

    • 3 Beds
    • 2 Baths
    • 1,780 Sq Ft
    • 2020 Martinshire Dr
    • Columbia, MO

    This lovely 2-bedroom split design, 2-full bath home features a 2-car garage and offer easy access to the MKT Trail. Conveniently located near the University, it's perfect for students, faculty, or anyone who enjoys a active lifestyle. Relax or entertain on the deck while taking in the peaceful backyard.''SELL AS IS''

    Martha Tomlin-McCrary Weichert, Realtors - First Tier

    Section Image
  • 2503 Lynnwood Dr, Columbia, MO 65203

    $373,000

    • 4 Beds
    • 3 Baths
    • 2,729 Sq Ft
    • 2503 Lynnwood Dr
    • Columbia, MO

    Much to appreciate with this Southwest Columbia home! Inside, you'll find a practical setup offering a huge formal dining room that transitions to the updated kitchen, offering stainless appliances and a spacious bar. Off the kitchen, note the vaulted ceilings as you step into a cozy family room with gorgeous stonework surrounding a oversized fireplace. Main level features 3 spacious bedrooms

    Ryan Martin Real Broker LLC

    Section Image
  • 1801 Jackson St, Columbia, MO 65202

    $289,500

    • 4 Beds
    • 2 Baths
    • 2,073 Sq Ft
    • 1801 Jackson St
    • Columbia, MO

    Agent-owned with extensive updates over the last 3 years! Renovated kitchen and baths with all-new cabinetry, refinished hardwoods (resealed in 2025), new luxury vinyl tile, carpet, full interior paint, updated lighting, trim, and fixtures. Kitchen features GE stainless appliances, subway tile backsplash, and under-cabinet lighting. Exterior updates include siding replacement, radon mitigation

    Rihana Hawk CoMo Realty

    Section Image
  • 200 Sondra Ave, Columbia, MO 65202

    $309,900

    • 4 Beds
    • 2 Baths
    • 1,712 Sq Ft
    • 200 Sondra Ave
    • Columbia, MO

    Ranch Home with a basement four bedrooms two baths sits on a 80x 150 lot with a fenced back yard, shed and two car garage. its just down the street from Como park. Near the Highway, and the neighborhood has a great dog park and wonderful neighbors. Has a nice size Deck in back and a cute front porch. apox 2000 sq ft with everything you may need.Main Level : 2 bedrooms 1 Bath, Dining room,

    Pamela Chyba ListWithFreedom.com INC

    Section Image
See All Homes in Columbia

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
Piester Andrew -- None Available
Beck Mark Cordes -- Boone Central Title Co
Hanuscin Deborah L -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Piester Andrew $243,573
Closed Piester Andrew $244,000
Previous Owner Beck Mark Cordes $203,300
Previous Owner Hanuscin Deborah L $159,300
Previous Owner Hanuscin Deborah L $156,200
Previous Owner Hanuscin Deborah L $168,300
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/26/2020 06/26/20 Sold -- -- --
05/28/2020 05/28/20 Pending -- -- --
04/27/2020 04/27/20 For Sale $254,000 +15.5% $155 / Sq Ft
05/31/2017 05/31/17 Sold -- -- --
04/03/2017 04/03/17 Pending -- -- --
04/03/2017 04/03/17 For Sale $220,000 -- $132 / Sq Ft
Source: Columbia Board of REALTORS®

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 $2,316 $34,333 $4,237 $30,096
2023 $2,297 $34,333 $4,237 $30,096
2022 $2,124 $31,787 $4,237 $27,550
2021 $2,128 $31,787 $4,237 $27,550
2020 $2,097 $29,425 $4,237 $25,188
2019 $2,097 $29,425 $4,237 $25,188
2018 $1,955 $0 $0 $0
2017 $1,983 $27,246 $4,237 $23,009
2016 $1,983 $27,246 $4,237 $23,009
2015 $1,829 $27,246 $4,237 $23,009
2014 -- $27,246 $4,237 $23,009
Source: Public Records

Agents Affiliated with this Home

  • Susan Horak

    Seller's Agent in 2020

    Susan Horak

    RE/MAX

    (573) 447-2146

    384 Total Sales

    Susan Horak
    Section Image

  • J

    Buyer's Agent in 2020

    Julia Seitz

    Modern Property Groups, LLC

  • J

    Buyer's Agent in 2020

    JULIA AMES

    RE/MAX

  • Julie Wesley

    Seller's Agent in 2017

    Julie Wesley

    House of Brokers Realty, Inc.

    (573) 446-6500

    381 Total Sales

    Julie Wesley
    Section Image

  • J

    Seller Co-Listing Agent in 2017

    JulieAnne Mattson

    House of Brokers Realty, Inc.

    (573) 289-4440

    96 Total Sales

    JulieAnne Mattson
    Section Image

  • S

    Buyer's Agent in 2017

    Sara Jeffrey

    House of Brokers Realty, Inc.

    (573) 529-4932

    31 Total Sales

    Sara Jeffrey
    Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 392212

Columbia Board of REALTORS®

APN: 16-605-00-03-019-00-01

Missouri Boone County Columbia 65203

504 Crestland Ave, Columbia, MO

This home is located at 504 Crestland Ave, Columbia, MO 65203 since 27 May 2020 and is currently estimated at $333,648, approximately $203 per square foot. This property was built in 1940. 504 Crestland Ave is a home located in Boone County with nearby schools including Russell Boulevard Elementary School, West Middle School, and David H. Hickman 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.

Columbia Board of REALTORS® IDX information is provided exclusively for 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 is deemed reliable but not guaranteed.

Nearby Homes