NOT LISTED FOR SALE

5207 Sheridan Rd Papillion, NE 68133

Estimated Value: $383,000 - $445,000

4 Beds
3 Baths
2,297 Sq Ft
$177/Sq Ft Est. Value

Last Sold June 05, 2024

Last sale price $423,807 $185 Per Sq Ft

Est. 4% decrease in value since last sale

Current estimated payment $2,455/month

198 Days on Market

Highlights

  • Under Construction
  • Ranch Style House
  • Covered Deck
  • Platteview Senior High School Rated 9+
  • 3 Car Attached Garage
  • Walk-In Closet

About This Home

As of June 2024

Welcome to The Concord by Celebrity Homes. Split bedroom Ranch Design that offers 3 bedrooms on the main floor (2 on one side, 1 on the other)…privacy for the Owner’s Suite. The Concord Design offers a surprisingly roomy main floor Gathering Room leading into an Eat-In Island Kitchen and Dining Area. Plenty of room in the lower level for a Rec Room, another Bedroom, and even another Bath! Owner’s Suite is appointed with a walk-in closet, Privacy Bath Design with a Dual Vanity. Features of this 3 Bedroom, 2 Bath Home Include: 2 Car Garage with a Garage Door Opener, Refrigerator, Washer/Dryer Package, Quartz Countertops, Luxury Vinyl Panel Flooring (LVP) Package, Sprinkler System, Extended 2-10 Warranty Program, 3/4 Bath Rough-In, Professionally Installed Blinds, and that’s just the start! (Pictures of Model Home) Price may reflect promotional discounts, if applicable.

Last Agent to Sell the Property

Monica Lang

Celebrity Homes Inc License #0950049 Listed on: 08/21/2023

Co-Listed By

Tiffany Stanton

Celebrity Homes Inc License #20140638

Last Buyer's Agent

Tanya Foral

CENTURY 21 Century Real Estate License #930192

CENTURY 21 Century Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $644

Year Built

  • Built in 2024 | Under Construction

Lot Details

  • 0.25 Acre Lot
  • Sprinkler System

HOA Fees

  • $21 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Ranch Style House
  • Composition Roof
  • Concrete Perimeter Foundation
  • Hardboard

Interior Spaces

  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Electric Fireplace
  • Window Treatments
  • Living Room with Fireplace
  • Natural lighting in basement

Kitchen

  • Oven or Range
  • Microwave
  • Freezer
  • Ice Maker
  • Dishwasher
  • Disposal

Flooring

  • Wall to Wall Carpet
  • Luxury Vinyl Plank Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Dual Sinks
  • Shower Only

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Covered Deck

Schools

  • Two Springs Elementary School
  • Lewis And Clark Middle School
  • Bellevue West High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Cable TV Available

Community Details

  • Lions Gate HOA
  • Built by CELEBRITY HOMES
  • Lions Gate Subdivision, Concord Floorplan

Listing and Financial Details

  • Assessor Parcel Number 011600863

Home Details

Home Type

Single Family

Est. Annual Taxes

$644

Year Built

Built in 2024 | Under Construction

Lot Details

0

HOA Fees

$21 per month

Parking

3

Listing Details

  • Parcel Number: 011600863
  • Property Sub Type: Single Family Residence
  • Year Built: 2024
  • Prop. Type: Residential
  • Lot Size Acres: 0.25
  • Lot Size: irreg
  • Co List Office Mls Id: 5000
  • Co List Office Phone: 402-896-3100
  • Ownership: Fee Simple
  • Subdivision Name: LIONS GATE
  • Directions: From Capehart Rd & South 48th Street, head south on South 48th Street. Travel to Helwig Ave. Head west into Lions Gate. Visit model homes at Schram 108 (108th & Schram Rd) for access to homes and Community Map
  • Above Grade Finished Sq Ft: 1533
  • Architectural Style: Ranch
  • Carport Y N: No
  • Garage Yn: Yes
  • Master Model: CONCORD
  • New Construction: Yes
  • ResoBuildingAreaSource: Plans
  • Kitchen Level: Main Floor
  • Special Features: 4098

Interior Features

  • Interior Amenities: 9'+ Ceiling
  • Basement: Daylight
  • Appliances: Range - Cooktop + Oven, Ice Maker, Refrigerator, Freezer, Washer, Dishwasher, Dryer, Disposal, Microwave
  • Basement YN: Yes
  • Full Bathrooms: 1
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 764
  • Fireplace Features: Living Room, Electric
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Carpet, Vinyl
  • Living Area: 2297
  • Main Level Bathrooms: 2
  • Window Features: Window Covering
  • ResoLivingAreaSource: Plans
  • Bedroom 1 Level: Main Floor
  • Room Bedroom2 Level: Main Floor
  • Room Bedroom3 Level: Below Grade
  • Dining Room Dining Room Level: Main Floor
  • Room Kitchen Features: Window Covering, Pantry, Luxury Vinyl Plank
  • Living Room Living Room Level: Main Floor
  • Bedroom 1 Features: Wall/Wall Carpeting, Window Covering
  • Room Bedroom2 Features: Wall/Wall Carpeting, Window Covering
  • Room Bedroom3 Features: Wall/Wall Carpeting, Window Covering
  • Dining Room Features: Window Covering, Luxury Vinyl Plank
  • Living Room Features: Window Covering, Fireplace, Ceiling Fan(s), Luxury Vinyl Plank
  • Master Bedroom Master Bedroom Level: Main Floor
  • Master Bedroom Features: Wall/Wall Carpeting, Window Covering, Ceiling Fan(s), Walk-In Closet(s)
  • Master Bathroom Features: 3/4, Shower, Double Sinks

Exterior Features

  • Foundation Details: Concrete Perimeter
  • Exterior Features: Sprinkler System
  • Fencing: None
  • Home Warranty: No
  • Builder Name: CELEBRITY HOMES
  • Construction Type: Hardboard
  • Patio And Porch Features: Covered Deck
  • Property Condition: Under Construction
  • Roof: Composition

Garage/Parking

  • Garage Spaces: 3
  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Parking Features: Built-In
  • Total Parking Spaces: 3

Utilities

  • Cooling: Central Air
  • Laundry Features: Luxury Vinyl Plank
  • Cooling Y N: Yes
  • Heating: Gas, Forced Air
  • Heating Yn: Yes
  • Sewer: Public Sewer
  • Utilities: Cable Available
  • Water Source: Public

Condo/Co-op/Association

  • Senior Community: No
  • Association Fee: 250
  • Association Fee Frequency: Annually
  • Association Name: Lions Gate HOA
  • Association: Yes

Schools

  • High School: Bellevue West
  • Elementary School: Two Springs
  • Junior High Dist: Bellevue
  • Middle Or Junior School: Lewis and Clark

Lot Info

  • Property Attached Yn: No
  • Lot Features: Up to 1/4 Acre.
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 643.56

Multi Family

  • Above Grade Finished Area Units: Square Feet

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 21, 2023
Closed on
Apr 17, 2024
Sold by
Celebrity Home Llc
Bought by
Meisinger Justin M and Takeshita Shelby L
Seller's Agent
Monica Lang
Celebrity Homes Inc
Buyer's Agent
Tanya Foral
CENTURY 21 Century Real Estate
List Price
$388,400
Sold Price
$423,807
Premium/Discount to List
$35,407
9.12%
Views
32
Current Estimated Value
$406,344

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$17,463
Avg. Annual Appreciation
-2.96%
Original Mortgage
$432,918
Interest Rate
4%
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
Meisinger Justin M $424,000 Nebraska Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Meisinger Justin M $432,918
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/05/2024 06/05/24 Sold $423,807 +0.7% $185 / Sq Ft
03/08/2024 03/08/24 Price Changed $421,008 +10.8% $183 / Sq Ft
03/07/2024 03/07/24 Pending -- -- --
03/05/2024 03/05/24 Price Changed $380,142 +1.0% $165 / Sq Ft
02/20/2024 02/20/24 Price Changed $376,263 +0.8% $164 / Sq Ft
12/19/2023 12/19/23 Price Changed $373,353 +0.4% $163 / Sq Ft
12/01/2023 12/01/23 Price Changed $371,898 -1.3% $162 / Sq Ft
11/28/2023 11/28/23 Price Changed $376,900 +0.3% $164 / Sq Ft
11/21/2023 11/21/23 Price Changed $375,900 -2.0% $164 / Sq Ft
08/23/2023 08/23/23 Price Changed $383,400 -1.3% $167 / Sq Ft
08/21/2023 08/21/23 For Sale $388,400 -- $169 / Sq Ft
Source: Great Plains Regional 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
2025 $3,635 $380,651 $49,000 $331,651
2024 $629 $159,866 $47,000 $112,866
2023 $644 $26,100 $26,100 --
2022 $644 $26,460 $26,460 $0
2021 $621 $25,200 $25,200 $0
2020 $622 $25,200 $25,200 $0
2019 $277 $11,271 $11,271 $0
2018 $280 $11,271 $11,271 $0
2017 $24 $1,514 $1,514 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Great Plains Regional MLS

MLS Number: 22319079

Great Plains Regional MLS

APN: 011600863