$539,000
SOLD NOV 6, 2024
Last list price

5314 Hallet St Shawnee, KS 66216

5 Beds
5 Baths
3,728 Sq Ft
10,559 Sq Ft Lot

Recently Sold

$145 Per Sq Ft

15 Days on Market

Highlights

  • Hearth Room
  • Vaulted Ceiling
  • Wood Flooring
  • Ray Marsh Elementary School Rated A
  • Traditional Architecture
  • Whirlpool Bathtub

About This Home

As of November 2024

This immaculate 5-bedroom, two-story gem is perfectly situated on a serene cul-de-sac lot, offering everything you’ve been searching for. Step into a grand foyer and be captivated by the expansive open floor plan that seamlessly connects the kitchen and family room, bathed in natural light. Don’t miss the spacious master bedroom, featuring an enormous walk-in closet for all your storage needs.

Meticulously maintained and cared for and ready for its new owner. In 2021, the property received a major upgrades with all-new Triple Pane Windows, a new Roof and Gutters, resurfaced Hardwood Floors, and fresh Exterior Paint. The thoughtful updates continued with new Flooring throughout, ensuring a fresh, contemporary look. The latest updates in 2024 include a fresh coat of interior paint, plush new carpeting in the master bedroom, and elegant new tile in the master bathroom. Enjoy the added benefits of a brand new high efficiency HVAC system and a new water heater, ensuring year-round comfort and efficiency. With its thoughtful renovations and move-in readiness, this home is perfect for anyone looking to start a new chapter in style. Don’t miss your chance to make it yours!

Last Agent to Sell the Property

Spradling Group

EXP Realty LLC Brokerage Phone: 913-320-0906 Listed on: 07/24/2024

EXP Realty LLC

Co-Listed By

Kathy Shen

EXP Realty LLC Brokerage Phone: 913-320-0906 License #00247505

Last Buyer's Agent

Dawn Unger

Platinum Realty LLC License #2001005857

Platinum Realty LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,532

Year Built

  • Built in 1997

Lot Details

  • 10,559 Sq Ft Lot
  • Cul-De-Sac
  • Wood Fence

HOA Fees

  • $38 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Front Facing Garage
  • Garage Door Opener

Home Design

  • Traditional Architecture
  • Shake Roof

Interior Spaces

  • 2-Story Property
  • Vaulted Ceiling
  • Ceiling Fan
  • Wood Burning Fireplace
  • Gas Fireplace
  • Thermal Windows
  • Window Treatments
  • Family Room with Fireplace
  • Great Room
  • Separate Formal Living Room
  • Formal Dining Room
  • Den
  • Fire and Smoke Detector
  • Laundry on main level

Kitchen

  • Country Kitchen
  • Hearth Room
  • Walk-In Pantry
  • Built-In Electric Oven
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Whirlpool Bathtub

Finished Basement

  • Walk-Out Basement
  • Sump Pump
  • Bedroom in Basement

Schools

  • Broken Arrow Elementary School
  • Sm Northwest High School

Additional Features

  • City Lot
  • Forced Air Heating and Cooling System

Community Details

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

Listing and Financial Details

  • Assessor Parcel Number QP77230000 0044
  • $0 special tax assessment

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,532

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: 2958
  • Architectural Style: Traditional
  • Co List Office Mls Id: HMSEXP2
  • Co List Office Name: EXP Realty LLC
  • Co List Office Phone: 913-451-6767
  • Fireplaces: 1
  • Internet Address Display: Yes
  • Internet Consumer Comment: No
  • List Agent Full Name: Spradling Group
  • Listing Service: Full Service
  • List Office Mls Id: HMSEXP2
  • List Office Name: EXP Realty LLC
  • List Office Phone: 913-451-6767
  • Living Area: 3728
  • Mls Status: Sold
  • Ownership: Private
  • Age Description: 21-30 Years
  • Floor Plan Features: 2 Stories
  • Tax Special Amount: 0
  • Tax Total Amount: 5532
  • Value Range Pricing YN: 0
  • Dining Area Features: Country Kitchen,Formal,Hearth Room
  • Other Room Features: Den/Study,Family Room,Formal Living Room,Great Room
  • Major Repair Costs: 0.00
  • Attribution Contact: 913-320-0906
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: All Window Cover, Ceiling Fan(s), Pantry, Walk-In Closet(s), Whirlpool Tub
  • Fireplace Features: Family Room, Gas, Wood Burning
  • Basement: Basement BR, Finished, Sump Pump, Walk Out
  • Appliances: Dishwasher, Disposal, Refrigerator, Built-In Electric Oven
  • Basement: Yes
  • Below Grade Sq Ft: 770
  • Fireplace: Yes
  • Flooring: Carpet, Wood
  • Laundry Features: Main Level, Off The Kitchen
  • Window Features: Thermal Windows

Beds/Baths

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

Exterior Features

  • Roof: Shake
  • Construction Materials: Stucco & Frame
  • Fencing: Wood

Garage/Parking

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

Utilities

  • Cooling: Electric
  • Heating: Forced Air
  • Sewer: City/Public
  • Cooling: Yes
  • Security Features: Smoke Detector(s)
  • Water Source: Public
  • Telecom: Cable - Available,Metro Free

Condo/Co-op/Association

  • Association Fee: 450
  • Association Fee Frequency: Annually
  • Association Fee Includes: Trash

Association/Amenities

  • Association: Yes

Fee Information

  • Deposit: Platinum Title

Schools

  • Middle/Junior School: Hocker Grove
  • Junior High Dist: Shawnee Mission

Lot Info

  • Lot Features: City Lot, Cul-De-Sac
  • Lot Size Area: 10559
  • Lot Size Sq Ft: 10559
  • Parcel Number: QP77230000 0044
  • Property Attached: No
  • Subdivision Name: The Woods Of Hidden Valley
  • ResoLotSizeUnits: SquareFeet
  • In Flood Plain: No

Tax Info

  • Tax Annual Amount: 5532

MLS Schools

  • Elementary School: Broken Arrow
  • High School: SM Northwest

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 24, 2024
Closed on
Nov 5, 2024
Sold by
Somerhalder Samuel S and Somerhalder Samuel S
Bought by
Neugebauer Tyler and Neugebauer Rachel J
Seller's Agent
Spradling Group
EXP Realty LLC
Buyer's Agent
Dawn Unger
Platinum Realty LLC
List Price
$539,000
Views
75
Current Estimated Value
$531,540

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.30%
Original Mortgage
$431,200
Outstanding Balance
$429,081
Interest Rate
6.12%
Mortgage Type
New Conventional
Estimated Equity
$111,368

Purchase Details

Closed on
Jul 25, 2007
Sold by
Somerhalder Samuel S and Somerhalder Andrea M
Bought by
Somerhalder Samuel S and Samuel S Somerhalder Revocab

Home Financials for this Owner

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

Purchase Details

Closed on
Jan 9, 2007
Sold by
Somerhalder Samuel S
Bought by
Somerhalder Samuel S

Purchase Details

Closed on
Oct 12, 2006
Sold by
Somerhalder Samuel S and Somerhalder Andrea M
Bought by
Somerhalder Samuel S

Purchase Details

Closed on
Sep 25, 2001
Sold by
Barnard Larry L and Barnard Barbara J
Bought by
Palazzo Frank and Palazzo Pamela A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$177,450
Interest Rate
9.99%
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 Type Sale Price Title Company
Warranty Deed -- Platinum Title
Warranty Deed -- Platinum Title
Interfamily Deed Transfer -- First American Title Ins
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Warranty Deed -- Security Land Title Company
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $431,200 New Conventional
Closed $431,200 New Conventional
Previous Owner $50,000 Stand Alone Second
Previous Owner $177,450 No Value Available
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/06/2024 11/06/24 Sold -- -- --
09/22/2024 09/22/24 Pending -- -- --
09/20/2024 09/20/24 For Sale $539,000 -2.0% $145 / Sq Ft
09/19/2024 09/19/24 Off Market -- -- --
09/06/2024 09/06/24 For Sale $550,000 -- $148 / 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 $5,942 $55,775 $12,114 $43,661
2023 $5,532 $51,520 $10,094 $41,426
2022 $5,090 $47,242 $10,094 $37,148
2021 $5,099 $44,563 $8,778 $35,785
2020 $4,975 $42,907 $8,778 $34,129
2019 $4,801 $41,378 $7,625 $33,753
2018 $4,696 $40,320 $7,625 $32,695
2017 $4,322 $36,524 $6,621 $29,903
2016 $4,358 $36,363 $6,340 $30,023
2015 $4,083 $35,236 $6,340 $28,896
2013 -- $30,096 $6,340 $23,756
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Heartland MLS

MLS Number: 2501249

Heartland MLS

APN: QP77230000-0044