NOT LISTED FOR SALE

5310 Hallet St Shawnee, KS 66216

Estimated Value: $527,000 - $608,050

4 Beds
5 Baths
3,241 Sq Ft
$173/Sq Ft Est. Value

Last Sold December 11, 2023

Current estimated payment $3,642/month

4 Days on Market

Highlights

  • In Ground Pool
  • Deck
  • Traditional Architecture
  • Ray Marsh Elementary School Rated A
  • Vaulted Ceiling
  • Wood Flooring

About This Home

As of December 2023

BEAUTIFULLY UPDATED 2 STORY TUCKED AWAY ON A CUL-DE-SAC WITH IN-GROUND POOL! Open Main Level with Front Flex Room, currently staged as sitting room could also be formal dining or office! Great room with fireplace for those cozy nights and wall of windows letting all the natural light in! Gorgeous Kitchen boasts quartz countertops, stainless steel appliances including a double oven, eat-in bar area and pantry! Custom stainless steel shelving in Laundry Room Stays! Spacious Primary Suite has Tray Vaulted Ceiling, walk-in closet, separate soaking tub and dual vanity! ALL bedrooms with walk-in closets! Guests Visiting? 4th bedroom has private bath! Looking for the PERFECT house to entertain in? This one has GREAT Options! Privacy fenced backyard with pool, sun deck and outdoor bar that seats 8! Full Finished basement including Family Room, Walk-In Bourbon/Wine Room, 2nd Mini Kitchen with Granite Countertops, Island and Dishwasher, Game Room, Office or 5th Non-Conforming Bedroom and WALKS-OUT!!! 3 Car Garage! Bonus Shed Stays for ALL your Storage Needs! Great location, just minutes to 435 to get anywhere quick and easy! Professional Photos coming Friday !!!!

Last Agent to Sell the Property

Bryan Huff

Keller Williams Realty Partners Inc. Brokerage Phone: 913-907-0760 License #SP00228927 Listed on: 10/27/2023

Keller Williams Realty Partners Inc.

Co-Listed By

Kenn Williamson

Keller Williams Realty Partners Inc. Brokerage Phone: 913-907-0760

Last Buyer's Agent

Whitney Boyd

RE/MAX Heritage License #2020042247

RE/MAX Heritage

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,005

Year Built

  • Built in 1997

Lot Details

  • 0.27 Acre Lot
  • Cul-De-Sac
  • Privacy Fence
  • Wood Fence
  • Paved or Partially Paved Lot
  • Level Lot
  • Sprinkler System

HOA Fees

  • $38 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Inside Entrance
  • Front Facing Garage

Home Design

  • Traditional Architecture
  • Composition Roof

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Vaulted Ceiling
  • Ceiling Fan
  • Fireplace With Gas Starter
  • Great Room with Fireplace
  • Family Room
  • Home Office
  • Laundry Room

Kitchen

  • Breakfast Room
  • Eat-In Kitchen
  • Double Oven
  • Built-In Electric Oven
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Finished Basement

  • Walk-Out Basement
  • Sump Pump

Outdoor Features

  • In Ground Pool
  • Deck
  • Covered Patio or Porch
  • Playground

Schools

  • Ray Marsh Elementary School
  • Sm Northwest High School

Utilities

  • Central Air
  • Heat Pump System

Community Details

  • Association fees include trash
  • The Woods Of Hidden Valley Subdivision

Listing and Financial Details

  • Exclusions: see disclosure
  • Assessor Parcel Number QP77230000-0043
  • $72 special tax assessment

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,005

Year Built

Built in 1997

Lot Details

0

HOA Fees

$38 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Year Built: 1997
  • Above Grade Finished Sq Ft: 2476
  • Architectural Style: Traditional
  • Co List Office Mls Id: HMSKW01
  • Co List Office Name: Keller Williams Realty Partner
  • Co List Office Phone: 913-906-5400
  • Fireplaces: 1
  • Internet Address Display: Yes
  • Internet Consumer Comment: No
  • List Agent Full Name: Bryan Huff
  • Listing Service: Full Service
  • List Office Mls Id: HMSKW01
  • List Office Name: Keller Williams Realty Partner
  • List Office Phone: 913-906-5400
  • Living Area: 3241
  • Mls Status: Sold
  • Ownership: Private
  • Age Description: 21-30 Years
  • Floor Plan Features: 2 Stories
  • Tax Special Amount: 72
  • Tax Total Amount: 5077
  • Value Range Pricing YN: 0
  • Dining Area Features: Breakfast Area,Eat-In Kitchen
  • Maintenance Provided YN: 0
  • Other Room Features: Breakfast Room,Family Room,Great Room,Office
  • Special Documents Required YN: 0
  • Building Conversion YN: 0
  • Major Repair Costs: 0.00
  • Attribution Contact: 913-907-0760
  • Special Features: None

Interior Features

  • Exclusions: see disclosure
  • Interior Amenities: Ceiling Fan(s), Kitchen Island, Pantry, Vaulted Ceiling, Walk-In Closet(s), Wet Bar
  • Fireplace Features: Gas Starter, Great Room
  • Basement: Finished, Inside Entrance, Sump Pump, Walk Out
  • Appliances: Dishwasher, Disposal, Double Oven, Microwave, Built-In Electric Oven, Stainless Steel Appliance(s)
  • Basement: Yes
  • Below Grade Sq Ft: 765
  • Fireplace: Yes
  • Flooring: Carpet, Tile, Wood
  • Laundry Features: Laundry Room, Off The Kitchen

Beds/Baths

  • Full Bathrooms: 3
  • Half Bathrooms: 2
  • Bedrooms: 4

Exterior Features

  • Roof: Composition
  • Construction Materials: Stucco & Frame
  • Fencing: Privacy, Wood
  • Patio And Porch Features: Deck, Covered Patio, Porch
  • Pool Features: Inground
  • Road Surface Type: Paved
  • Exclusions YN: 1

Garage/Parking

  • Garage Spaces: 3
  • Garage: Yes
  • Parking Features: Attached, Garage Faces Front

Utilities

  • Cooling: Electric
  • Heating: Heat Pump
  • Sewer: City/Public
  • Cooling: Yes
  • Water Source: Public

Condo/Co-op/Association

  • Association Amenities: Play Area
  • Association Fee: 450
  • Association Fee Frequency: Annually
  • Association Fee Includes: Trash

Association/Amenities

  • Association: Yes

Fee Information

  • Deposit: Platinum Title

Schools

  • Middle/Junior School: Trailridge
  • Junior High Dist: Shawnee Mission

Lot Info

  • Lot Features: Cul-De-Sac, Level, Sprinkler-In Ground
  • Lot Size Area: 11728
  • Lot Size Sq Ft: 11728
  • Parcel Number: QP77230000-0043
  • Property Attached: No
  • Subdivision Name: The Woods Of Hidden Valley
  • ResoLotSizeUnits: SquareFeet
  • In Flood Plain: No

Tax Info

  • Tax Annual Amount: 5005
  • Tax Abatement YN: 0

MLS Schools

  • Elementary School: Ray Marsh
  • High School: SM Northwest

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 27, 2023
Closed on
Dec 11, 2023
Sold by
Bertholdi Bryan and Bertholdi Beth
Bought by
Collette Jeffrey and Collette Heather
Seller's Agent
Bryan Huff
Keller Williams Realty Partners Inc.
Buyer's Agent
Whitney Boyd
RE/MAX Heritage
List Price
$525,000
Views
49
Current Estimated Value
$559,763

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.82%
Original Mortgage
$429,242
Interest Rate
7.76%
Mortgage Type
FHA

Purchase Details

Listed on
Feb 8, 2019
Closed on
Mar 15, 2019
Sold by
Whittaker Katrina
Bought by
Bertholdi Bryan
Seller's Agent
Tim Seibold
Coldwell Banker Regan Realtors
Buyer's Agent
Amy Crossman
Platinum Realty LLC
List Price
$359,950

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.35%
Original Mortgage
$284,000
Interest Rate
4.4%
Mortgage Type
New Conventional

Purchase Details

Listed on
May 13, 2016
Closed on
Jun 22, 2016
Sold by
Flannigan Brady and Flannigan Kim I
Bought by
Whittaker Katrina
Seller's Agent
Blake Nelson
KW KANSAS CITY METRO
Buyer's Agent
Francene Sutton
Gemini I I, Inc Realtors
List Price
$315,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.70%

Purchase Details

Closed on
Oct 24, 2006
Sold by
Martin Kim Hene and Martin Kim I
Bought by
Martin Kim I

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$46,750
Interest Rate
6.03%
Mortgage Type
Stand Alone Second

Purchase Details

Closed on
Apr 25, 2006
Sold by
Berger Timothy B and Martin Kim Ilene
Bought by
Martin Kim Ilene and Martin Kim I

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 29, 2002
Sold by
Elliott Paul S and Elliott Kristen S
Bought by
Berger Timothy B and Berger Kim M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$260,700
Interest Rate
6.78%
Mortgage Type
VA
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
Collette Jeffrey -- Platinum Title
Bertholdi Bryan -- Stewart Title Company
Whittaker Katrina -- Platinum Title Llc
Martin Kim I -- Chicago Title Ins Co
Martin Kim Ilene -- Chicago Title Insurnce Co
Berger Timothy B -- Security Land Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Collette Heather $451,658
Closed Collette Jeffrey $429,242
Previous Owner Bertholdi Bryan $315,000
Previous Owner Bertholdi Bryan $288,000
Previous Owner Bertholdl Bryan $51,000
Previous Owner Bertholdi Bryan $284,000
Previous Owner Martin Kim T $272,000
Previous Owner Martin Kim I $267,069
Previous Owner Martin Kim I $46,750
Previous Owner Martin Kim Ilene $227,200
Previous Owner Berger Timothy B $260,700
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/11/2023 12/11/23 Sold -- -- --
11/07/2023 11/07/23 Pending -- -- --
11/02/2023 11/02/23 For Sale $525,000 +45.9% $162 / Sq Ft
03/20/2019 03/20/19 Sold -- -- --
02/08/2019 02/08/19 For Sale $359,950 +14.3% $148 / Sq Ft
06/23/2016 06/23/16 Sold -- -- --
05/13/2016 05/13/16 Pending -- -- --
05/13/2016 05/13/16 For Sale $315,000 -- $123 / Sq Ft
Source: Heartland 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 $6,651 $62,318 $12,284 $50,034
2023 $5,360 $49,922 $10,234 $39,688
2022 $5,077 $47,127 $10,234 $36,893
2021 $4,896 $42,780 $8,900 $33,880
2020 $4,757 $41,021 $8,900 $32,121
2019 $4,696 $40,469 $7,720 $32,749
2018 $4,677 $40,158 $7,720 $32,438
2017 $4,291 $36,260 $6,713 $29,547
2016 $4,158 $34,684 $6,420 $28,264
2015 $3,829 $33,051 $6,420 $26,631
2013 -- $29,658 $6,420 $23,238
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Heartland MLS

MLS Number: 2461070

Heartland MLS

APN: QP77230000-0043