NOT LISTED FOR SALE

1504 Glencairn Ct Columbia, MO 65203

The Highlands Neighborhood

Estimated Value: $293,000 - $306,000

3 Beds
2 Baths
1,488 Sq Ft
$201/Sq Ft Est. Value

Last Sold February 14, 2020

Current estimated payment $1,872/month

102 Days on Market

Highlights

  • Deck
  • Ranch Style House
  • Cul-De-Sac
  • Mill Creek Elementary School Rated A-
  • First Floor Utility Room
  • Skylights

About This Home

As of February 2020

Open floor plan with great natural light from the brand new skylights. Roof was replaced in September 2019. Fresh paint for the new owner. Master suite has spacious closet and bath. Live on a nice cul-de-sac and walking distance to the neighborhood park.

Last Agent to Sell the Property

Denise Payne

Weichert, Realtors - First Tier License #2004007456 Listed on: 10/08/2019

Weichert, Realtors - First Tier

Last Buyer's Agent

Joel Gast

House of Brokers Realty, Inc. License #2015005923

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,838

Year Built

  • Built in 1987

Lot Details

  • Cul-De-Sac
  • Southeast Facing Home

HOA Fees

  • $17 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Ranch Style House
  • Brick Veneer
  • Concrete Foundation
  • Slab Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Vinyl Construction Material

Interior Spaces

  • 1,488 Sq Ft Home
  • Ceiling Fan
  • Paddle Fans
  • Skylights
  • Wood Burning Fireplace
  • Screen For Fireplace
  • Vinyl Clad Windows
  • Living Room with Fireplace
  • Combination Kitchen and Dining Room
  • First Floor Utility Room
  • Utility Room

Kitchen

  • Electric Cooktop
  • Dishwasher
  • Laminate Countertops
  • Disposal

Flooring

  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms
  • Bathtub with Shower

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Home Security

  • Storm Doors
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Front Porch

Schools

  • Mill Creek Elementary School
  • John Warner Middle School
  • Rock Bridge High School

Utilities

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

Community Details

  • Built by Stohldrier
  • Highlands Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1690300030570001

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,838

Year Built

Built in 1987

Lot Details

0

HOA Fees

$17 per month

Parking

2

Listing Details

  • Directions: Forum to Southhampton to left on Royal Lytham, right on Glencairn, right on Glencairn Court
  • Lot Size: 40 x 130.91 irr
  • Prop. Type: Residential
  • Bedroom 2 Level: Main
  • Dining Room Level: Main
  • Kitchen Level: Main
  • Living Room Level: Main
  • Primary Bedroom Level: Main
  • Year Built: 1987
  • BathsFull34MainLevel: 2
  • BathsFull34Total: 2
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained, Curbs and Gutters, Cul-de-sac
  • Subdivision Name: HIGHLANDS
  • Above Grade Finished Sq Ft: 1488.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Material:Poured Concrete: Yes
  • Deck:Back: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Gas-Natural: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Rooms:Dining Room: Yes
  • Rooms:Living Room: Yes
  • Dining:KitDin Combo: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Ceramic: Yes
  • StreetRoads:Cul-de-sac: Yes
  • Exterior Finish:Vinyl2: Yes
  • Porch:Front2: Yes
  • Foundation Type:Slab: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Special Features: None

Interior Features

  • Bedroom 3 Level: Main
  • Utility Room Level: Main
  • Flooring: Carpet, Ceramic Tile, Tile
  • Interior Amenities: High Spd Int Access, Tub/Shower, Laundry-Main Floor, Walk in Closet(s), Washer/DryerConnectn, Main Lvl Master Bdrm, Skylight(s), Ceiling/PaddleFan(s), Cable Ready, Storm Door(s), Smoke Detector(s), Garage Dr Opener(s), FireplaceScreenDr(s), Kit/Din Combo, Counter-Laminate, Cabinets-Wood
  • Basement YN: No
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: In Living Room, Wood Burning
  • Fireplace: Yes
  • Living Area: 1488.0
  • InteriorFeatures:Cable Ready: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • Fireplace:In Living Room: Yes
  • Fireplace:Wood Burning: Yes
  • KitchenFeatures:Range-Electric: Yes
  • InteriorFeatures:FireplaceScreenDr(s): Yes
  • InteriorFeatures:Storm Door(s): Yes
  • KitchenFeatures:Cooktop-Electric: Yes
  • KitchenFeatures:Counter-Laminate: Yes
  • InteriorFeatures:Skylight(s): Yes

Exterior Features

  • Builder Name: Stohldrier
  • Exterior Features: Driveway-Paved, Windows-Vinyl
  • Roof: ArchitecturalShingle
  • Direction Faces: Southeast
  • Foundation Details: Poured Concrete, Slab
  • Patio And Porch Features: Deck, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Attached
  • General Property Description:Garage Capacity: 2
  • InteriorFeatures:Garage Dr Opener(s): Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee: 200.0
  • Association Fee Frequency: Annual
  • Association: Yes

Schools

  • Elementary School: Mill Creek
  • Junior High Dist: Columbia
  • High School: Rock Bridge
  • Middle Or Junior School: John Warner

Lot Info

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

Tax Info

  • Tax Annual Amount: 1837.97
  • Tax Year: 2018

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 7, 2020
Sold by
Berlemann James D and Berlemann Megan M
Bought by
Frew Laurie
Total Days on Market
102
Current Estimated Value
$299,284

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$170,500
Outstanding Balance
$153,195
Interest Rate
3.1%
Mortgage Type
New Conventional
Estimated Equity
$146,089

Purchase Details

Listed on
Oct 8, 2019
Closed on
Feb 14, 2020
Sold by
Yanis Lori A
Bought by
Berlemann James D and Berlemann Megan M
Seller's Agent
Denise Payne
Weichert, Realtors - First Tier
Buyer's Agent
Joel Gast
House of Brokers Realty, Inc.
List Price
$190,000
Sold Price
$173,450
Premium/Discount to List
-$16,550
-8.71%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.80%
Original Mortgage
$73,450
Interest Rate
3.72%
Mortgage Type
Future Advance Clause Open End Mortgage

Purchase Details

Closed on
May 13, 2011
Sold by
Knepper Kathleen N
Bought by
Yanis Lori A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$75,000
Interest Rate
4.87%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Similar Homes in Columbia, MO

  • 1411 Kinloch Ct, Columbia, MO 65203

    $365,000

    • 4 Beds
    • 2 Baths
    • 2,063 Sq Ft
    • 1411 Kinloch Ct
    • Columbia, MO

    Affordable 4 bed 2 bath Cape Cod home in the desirable Highlands neighborhood- Coming Soon! Tucked neatly on a corner lot with fully fenced private back yard and in an amazing school district, this home will not last long. All 4 bedrooms are quite large and this home boasts a spacious primary suite on the main level with dual sink vanity and walk in closet. Roof and garage door are only

    Morgan Hulen Iron Gate Real Estate

    Section Image
  • 3605 Scottson Way, Columbia, MO 65203

    $355,000

    • 3 Beds
    • 2.5 Baths
    • 2,347 Sq Ft
    • 3605 Scottson Way
    • Columbia, MO

    This lovely two-story home features 3 bedrooms, 2.5 bathrooms, and two distinct living spaces plus a formal dining room, ideal for both everyday living and entertaining. The formal spaces shine with engineered wood flooring, decorative shutters, and crown molding, while the inviting family room boasts a wood-burning fireplace with a brick hearth. The spacious kitchen is well-appointed with solid

    Bev Curtis Bev & Co. Realty, LLC

    Section Image
  • 3207 Ballard Mill Dr, Columbia, MO 65203

    $345,000

    • 3 Beds
    • 2 Baths
    • 1,634 Sq Ft
    • 3207 Ballard Mill Dr
    • Columbia, MO

    Beautifully Maintained 3-Bedroom, 2-Bath Home with Open Concept Living. This well-kept home features a desirable split-bedroom and open concept design that's perfect for modern living. Enjoy a spacious kitchen, dining area, and living room with 10 ft. ceilings, LVP flooring, a cozy gas fireplace, and abundant natural light. The kitchen offers generous cabinet & counter space, a separate island,

    JD Estes RE/MAX Boone Realty

    Section Image
  • 1050 W Azoros Dr, Columbia, MO 65203

    $315,000

    • 3 Beds
    • 2 Baths
    • 1,618 Sq Ft
    • 1050 W Azoros Dr
    • Columbia, MO

    Welcome to your next home! From the front you will be impressed by the manicured lawn and great landscaping. From the front door you will be captivated by the light and bright presentation, tall ceilings and lvp flooring throughout the home. The open kitchen offers tons of cabinets, a pantry closet and is open into the breakfast room. The living room boasts tall ceilings a gas fireplace and

    Mike Hill Weichert, Realtors - First Tier

    Section Image
  • 205 E El Cortez Dr, Columbia, MO 65203

    $350,000

    • 5 Beds
    • 3 Baths
    • 2,081 Sq Ft
    • 205 E El Cortez Dr
    • Columbia, MO

    Recently renovated 5 bedroom, 3 bathroom home in the center of Columbia. This home has all the space you need. Located Just south of Green Meadows. Very close to the Missouri stadiums as well as multiple bars and restaurants. The upstairs features 3 bedrooms, 2 bathrooms as well as a living area and kitchen. The lower level features an additional 2 bedroom and 1 bathroom.

    Trey Landes Century 21 Community

    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
  • 2601 Martinshire Ct, Columbia, MO 65203

    $375,000

    • 4 Beds
    • 2.5 Baths
    • 2,179 Sq Ft
    • 2601 Martinshire Ct
    • Columbia, MO

    This beautiful 4-bed, 2.5-bath home with over 2,100 sq ft is located in a highly sought-after neighborhood. Features include genuine hardwood floors, an updated kitchen, and a walk-out basement with a non-conforming bedroom (included in total room count.) Located on a quiet cul-de-sac with mature trees, direct MKT Trail access, and within walking distance to Twin Lakes Park. Close to shopping,

    Cale Childers Century 21 Access

    Section Image
  • 7104 Stanwood Dr, Columbia, MO 65203

    $375,000

    • 3 Beds
    • 2 Baths
    • 2,104 Sq Ft
    • 7104 Stanwood Dr
    • Columbia, MO

    This darling 3 bedroom, 2 bathroom home is located in the desirable Cascades neighborhood. When you walk through the front door, you are greeted with new luxury vinyl plank flooring and vaulted ceilings in the spacious living room. The living room flows into a large kitchen that has a cozy hearth area with a fireplace. On the main level, you will also find a roomy primary suite that offers a

    Suzanne Beckett Berkshire Hathaway HomeServices | Vision Real Estate

    Section Image
  • 5611 Abercorn Dr, Columbia, MO 65203

    $359,900

    • 3 Beds
    • 2 Baths
    • 1,621 Sq Ft
    • 5611 Abercorn Dr
    • Columbia, MO

    Stunning 3-Bedroom, 2-Bath Home in Wyndham Ridge-Move in ready!Step in to this bright and inviting home, open floor plan.Outside, large private fenced backyard, while being just steps away from the community pool and clubhouse.

    Chiao Curd-Ling Berkshire Hathaway HomeServices | Vision Real Estate

    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
Frew Laurie -- Boone Central Title Company
Berlemann James D -- Boone Central Title Company
Yanis Lori A -- Boone Central Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Frew Laurie $170,500
Previous Owner Berlemann James D $73,450
Previous Owner Yanis Lori A $79,000
Previous Owner Yanis Lori A $75,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/14/2020 02/14/20 Sold -- -- --
01/19/2020 01/19/20 Pending -- -- --
10/08/2019 10/08/19 For Sale $190,000 -- $128 / 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,176 $32,262 $4,142 $28,120
2023 $2,158 $32,262 $4,142 $28,120
2022 $1,996 $29,868 $4,142 $25,726
2021 $2,000 $29,868 $4,142 $25,726
2020 $1,971 $27,660 $4,142 $23,518
2019 $1,971 $27,660 $4,142 $23,518
2018 $1,838 $0 $0 $0
2017 $1,816 $25,612 $4,142 $21,470
2016 $1,812 $25,612 $4,142 $21,470
2015 $1,665 $25,612 $4,142 $21,470
2014 $1,670 $25,612 $4,142 $21,470
Source: Public Records

Agents Affiliated with this Home

  • Denise Payne

    Seller's Agent in 2020

    Denise Payne

    Weichert, Realtors - First Tier

    (573) 999-1583

    2 in this area

    299 Total Sales

    Denise Payne
    Section Image
  • Joel Gast

    Buyer's Agent in 2020

    Joel Gast

    House of Brokers Realty, Inc.

    (573) 424-8787

    94 Total Sales

    Joel Gast
    Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 388629

Columbia Board of REALTORS®

APN: 16-903-00-03-057-00-01

Missouri Boone County Columbia 65203 The Highlands

1504 Glencairn Ct, Columbia, MO

This home is located at 1504 Glencairn Ct, Columbia, MO 65203 since 08 October 2019 and is currently estimated at $299,284, approximately $201 per square foot. This property was built in 1987. 1504 Glencairn Ct is a home located in Boone County with nearby schools including Mill Creek Elementary School, Ann Hawkins Gentry Middle School, and Rock Bridge 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