NOT LISTED FOR SALE

5074 S 174th St Omaha, NE 68135

Estimated Value: $571,000 - $672,000

5 Beds
3.5 Baths
4,307 Sq Ft
$149/Sq Ft Est. Value

Last Sold August 26, 2024

Last sale price $660,000 $153 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $3,999/month

6 Days on Market

Highlights

  • Greenhouse
  • Spa
  • Cathedral Ceiling
  • Willowdale Elementary School Rated A
  • Engineered Wood Flooring
  • Whirlpool Bathtub

About This Home

As of August 2024

Welcome to this stunning 5-bedroom, 4-bath two-story home, where every detail has been meticulously upgraded. Over the past three years, this property has received extensive improvements including new windows, roof, siding, garage doors and openers and paint, ensuring long-lasting beauty and durability. The charming gazebo and deck are perfect for outdoor enjoyment. Inside, the kitchen has been remodeled with new appliances, and the laundry room/drop zone is both functional and stylish. Custom window coverings add a touch of elegance, while the powder bath, stairs, and flooring have been updated for a fresh look. The lower level boasts a 5th bedroom and a spacious entertainment area, perfect for guests or family gatherings. This home is a true gem, offering modern amenities and timeless appeal. Don't miss your chance to make it yours!

Last Agent to Sell the Property

Jo Boyles

BHHS Ambassador Real Estate License #20050398 Listed on: 07/19/2024

BHHS Ambassador Real Estate

Last Buyer's Agent

Sarah Maier Pavel

Better Homes and Gardens R.E. License #20130042

Better Homes and Gardens R.E.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,058

Year Built

  • Built in 1991

Lot Details

  • 0.33 Acre Lot
  • Lot Dimensions are 158 x 91
  • Property is Fully Fenced
  • Aluminum or Metal Fence
  • Corner Lot
  • Sprinkler System

HOA Fees

  • $13 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

  • Brick Exterior Construction
  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Log Fireplace
  • Window Treatments
  • Sliding Doors
  • Two Story Entrance Foyer
  • Family Room with Fireplace
  • Dining Area

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Engineered Wood
  • Wall to Wall Carpet
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Dual Sinks
  • Whirlpool Bathtub

Partially Finished Basement

  • Walk-Out Basement
  • Basement Windows

Outdoor Features

  • Spa
  • Patio
  • Greenhouse
  • Porch

Schools

  • Willowdale Elementary School
  • Russell Middle School
  • Millard West High School

Utilities

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

Community Details

  • Autumn Ridge Subdivision

Listing and Financial Details

  • Assessor Parcel Number 0530667304

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,058

Year Built

Built in 1991

Lot Details

0

HOA Fees

$13 per month

Parking

3

Listing Details

  • Parcel Number: 0530667304
  • Property Sub Type: Single Family Residence
  • Year Built: 1991
  • Prop. Type: Residential
  • Lot Size Acres: 0.33
  • Lot Size: 158 x 91
  • Ownership: Fee Simple
  • Subdivision Name: AUTUMN RIDGE
  • Directions: Q St to S 172nd St, North to P St, West on P St to S 174th St
  • Above Grade Finished Sq Ft: 3050
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • ResoBuildingAreaSource: Other
  • Kitchen Level: Main Floor
  • Special Features: None

Interior Features

  • Interior Amenities: Two Story Entry, Ceiling Fan(s), Pantry
  • Basement: Daylight, Egress, Walk-Out Access, Partially Finished
  • Private Spa: Yes
  • Appliances: Humidifier, Range - Cooktop + Oven, Refrigerator, Water Softener, Dishwasher, Disposal, Microwave
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1257
  • Door Features: Sliding Doors
  • Fireplace Features: Family Room, Gas Log Lighter
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Carpet, Vinyl, Engineered Wood
  • Living Area: 4307
  • Main Level Bathrooms: 1
  • Window Features: Window Covering, LL Daylight Windows
  • ResoLivingAreaSource: Other
  • Room Office Area: 144.96
  • Room Kitchen Area: 270.3
  • Room Office Level: Main
  • Room Bedroom2 Area: 157.6036
  • Room Bedroom3 Area: 133.6048
  • Room Bedroom4 Area: 196.9812
  • Bedroom 1 Level: 2nd Floor
  • Room Bedroom2 Level: 2nd Floor
  • Room Bedroom3 Level: 2nd Floor
  • Room Bedroom4 Level: Below Grade
  • Room Dining Room Area: 145.148
  • Room Family Room Area: 300.6
  • Room Living Room Area: 196.1216
  • Room Office Features: Ceiling Fan(s), Engineered Wood
  • Dining Room Dining Room Level: Main Floor
  • Room Family Room Level: Main Floor
  • Room Kitchen Features: Window Covering, Dining Area, Pantry, Engineered Wood, Sliding Glass Door
  • Living Room Living Room Level: Main Floor
  • Bedroom 1 Features: Wall/Wall Carpeting, Ceiling Fan(s)
  • Room Bedroom2 Features: Wall/Wall Carpeting
  • Room Bedroom3 Features: Wall/Wall Carpeting, Cath./Vaulted Ceiling
  • Room Bedroom4 Features: Wall/Wall Carpeting, Egress Window
  • Room Master Bedroom Area: 253.62
  • Dining Room Features: Engineered Wood
  • Family Room Features: Window Covering, Fireplace, Ceiling Fan(s), Engineered Wood
  • Living Room Features: Cath./Vaulted Ceiling, Engineered Wood
  • Master Bedroom Master Bedroom Level: 2nd Floor
  • Master Bedroom Master Bedroom Width: 14.09
  • Master Bedroom Features: Wall/Wall Carpeting, Cath./Vaulted Ceiling, Ceiling Fan(s), Walk-In Closet(s)
  • Master Bathroom Features: Full, 3/4, Whirlpool, Double Sinks

Exterior Features

  • Foundation Details: Concrete Perimeter
  • Exterior Features: Sprinkler System
  • Fencing: Full, Iron
  • Home Warranty: No
  • Construction Type: Wood, Brick/Other
  • Other Structures: Greenhouse
  • Patio And Porch Features: Porch, Patio
  • Property Condition: Not New and NOT a Model
  • Roof: Composition

Garage/Parking

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

Utilities

  • Cooling: Central Air
  • Laundry Features: Engineered Wood
  • 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: 150
  • Association Fee Frequency: Annually
  • Association: Yes

Schools

  • High School: Millard West
  • Elementary School: Willowdale
  • Junior High Dist: Millard
  • Middle Or Junior School: Russell

Lot Info

  • Property Attached Yn: No
  • Lot Features: Over 1/4 up to 1/2 Acre, City Lot, Corner Lot, Subdivided, Public Sidewalk
  • ResoLotSizeUnits: SquareFeet

Green Features

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 7057.64

Multi Family

  • Above Grade Finished Area Units: Square Feet

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 19, 2024
Closed on
Aug 15, 2024
Sold by
Simmons T Andrew R T and Simmons Jamie L
Bought by
Mcconnell Nathan
Seller's Agent
Jo Boyles
BHHS Ambassador Real Estate
Buyer's Agent
Sarah Maier Pavel
Better Homes and Gardens R.E.
List Price
$650,000
Sold Price
$660,000
Premium/Discount to List
$10,000
1.54%
Views
186
Current Estimated Value
$641,033

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$18,967
Avg. Annual Appreciation
-2.62%
Original Mortgage
$660,000
Interest Rate
6.77%
Mortgage Type
New Conventional

Purchase Details

Listed on
Dec 12, 2015
Closed on
Feb 23, 2016
Sold by
Ambrose Benjamin T
Bought by
Simmons Andrew R and Simmons Jamie L
Seller's Agent
Jillian Currie
Berkshire Real Estate
Buyer's Agent
Jo Boyles
BHHS Ambassador Real Estate
List Price
$305,000
Sold Price
$299,000
Premium/Discount to List
-$6,000
-1.97%

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.76%
Original Mortgage
$239,200
Interest Rate
3.92%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 19, 2012
Sold by
Ambrose Jenny L
Bought by
Ambrose Benjamin T

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$260,000
Interest Rate
3.42%
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
Mcconnell Nathan $660,000 Green Title
Simmons Andrew R $299,000 Ne Land Title & Abstract
Ambrose Benjamin T -- Midwest Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mcconnell Nathan $660,000
Previous Owner Simmons Andrew R $239,200
Previous Owner Ambrose Benjamin T $260,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/26/2024 08/26/24 Sold $660,000 +1.5% $153 / Sq Ft
07/26/2024 07/26/24 Pending -- -- --
07/19/2024 07/19/24 For Sale $650,000 +117.4% $151 / Sq Ft
02/26/2016 02/26/16 Sold $299,000 -2.0% $76 / Sq Ft
01/17/2016 01/17/16 Pending -- -- --
12/11/2015 12/11/15 For Sale $305,000 -- $77 / 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
2024 $7,058 $437,800 $35,600 $402,200
2023 $7,058 $354,500 $35,600 $318,900
2022 $7,492 $354,500 $35,600 $318,900
2021 $6,409 $304,800 $35,600 $269,200
2020 $6,462 $304,800 $35,600 $269,200
2019 $6,482 $304,800 $35,600 $269,200
2018 $5,863 $271,900 $35,600 $236,300
2017 $5,771 $271,900 $35,600 $236,300
2016 $5,626 $264,800 $25,400 $239,400
2015 $5,365 $247,400 $23,700 $223,700
2014 $5,365 $247,400 $23,700 $223,700
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: 22418431

Great Plains Regional MLS

APN: 3066-7304-05