Please stand by.
USDAProperties.com is sifting through the details...

 

 

 

$2,050,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
4015 S 175th Ave
Omaha, NE 68130
4 bed 4 bath 4,912 SqFt ($417/SqFt)
0.43 acre lot. Built 2001
Listed 2024-04-02, HOA $75, Taxes $17,764
Ⓧ USDA Ineligible
due to price & location

near Omaha

Experience opulent living in this West Coast Style Estate

A masterpiece of tranquil elegance and modern sophistication. The exterior boasts a pretty courtyard, setting the tone for the grandeur inside. The kitchen is a culinary marvel, featuring two expansive 9-foot quartz islands. High-end appliances and custom cabinetry make cooking a pleasure, while the adjacent dining room and open living room create an ideal space for entertaining.

A curated sitting room cn serve as a tranquil home office. The primary suite is a sanctuary with a double-sided fireplace, his & her walk-in closets, & a spa-like ensuite bathroom. Venture downstairs to find 3 additional bedrooms & an extra kitchen, perfect for guests or extended family. Outside, mature trees surround your private oasis. Meticulously landscaped grounds offer a backdrop for outdoor gatherings, by the patio or pool. The property is professionally decorated & furnished, with al l items included in the sale. Schedule your private showing!


Presented by Jamie N. Hunsberger at
BHHS Ambassador Real Estate.
Listing Agent Photo

Property MLS #22407555 from GreatPlainsRegional

Bedrooms: 4
Primary Bedroom Dimensions: 18.0 x 14.1
Bedroom 2 Dimensions: 14.6 x 10.1
Bedroom 3 Dimensions: 12.1 x 12.0
Bedroom 4 Dimensions: 23.0 x 14.0
Primary Bedroom Level: Main Floor
Bedroom 2 Level: Below Grade
Bedroom 3 Level: Below Grade
Bedroom 4 Level: Below Grade
Primary Bedroom Description: 9'+ Ceiling, Fireplace, Walk-In Closet
Bedroom 2 Description: 9'+ Ceiling, Egress Window, Walk-In Closet, Window Covering
Bedroom 3 Description: Egress Window, Window Covering
Bedroom 4 Description: Egress Window, Walk-In Closet, Window Covering

Total Bathrooms: 4
Full Bathrooms: 1
1/2 Bathrooms: 1
3/4 Bathrooms: 2
Bathrooms On Main Level: 2
Full Bathrooms On Main Level: 1
Half Bathrooms On Main Level: 1
Bathrooms On Basement Level: 2
Three Quarter Bathrooms On Basement Level: 2
Primary Bathroom Description: Double Sinks, Full, Shower

9'+ Ceiling
Central Vacuum
Garage Door Opener
Garage Floor Drain
LL Daylight Windows
Power Humidifier
Security System
Sump Pump
Wetbar
Interior Amenities: Media Room/Theater, Sitting Room
Flooring: Carpet, Luxury Vinyl Plank

Convection Oven
Cooktop
Dishwasher
Disposal
Double Oven
Icemaker
Microwave
Refrigerator
Water Softener
Wine Fridge
Laundry Features: 9'+ Ceiling, Luxury Vinyl Plank

Cooling Features: Central Air, Zoned
Fireplace Features: Direct-Vent Gas Fire
Heating Features: Forced Air, Zoned
Heating Fuel: Gas
Number of Fireplaces: 3

Formal Dining Room Description: 9'+ Ceiling, Luxury Vinyl Plank, Window Covering
Formal Dining Room Dimensions: 15.1 x 12.0
Formal Dining Room Level: Main Floor
Kitchen Description: 9'+ Ceiling, Dining Area, Exterior Door, Fireplace, Luxury Vinyl Plank
Kitchen Dimensions: 24.1 x 20.0
Kitchen Level: Main Floor

Extra Room-1 Dimensions: 9.0 x 8.0
Extra Room-2 Dimensions: 14.0 x 11.0
Extra Room-3 Dimensions: 12.1 x 11.0
Game/Recreation Room Dimensions: 18.1 x 18.0
Living Room Dimensions: 23.0 x 19.1
Extra Room-1 Level: Main Floor
Extra Room-2 Level: Main Floor
Extra Room-3 Level: Below Grade
Game/Recreation Room Level: Below Grade
Living Room Level: Main Floor
Extra Room-1 Features: 9'+ Ceiling, Luxury Vinyl Plank
Extra Room-2 Features: 9'+ Ceiling, Luxury Vinyl Plank, Window Covering
Extra Room-3 Features: 9'+ Ceiling, Wall/Wall Carpeting
Basement Description: Daylight, Egress, Partially Finished, Walkout
Extra Room-1 Description: Foyer/Entry
Extra Room-2 Description: Sitting Room
Extra Room-3 Description: Media Room/Theater
Game/Recreation Room Description: 9'+ Ceiling, Egress Window, Fireplace, Luxury Vinyl Plank
Living Room Description: 9'+ Ceiling, Fireplace, Luxury Vinyl Plank, Wetbar

Covered Deck
Decorative Lighting
Patio
Pool Inground
Porch
Sprinkler System
Fencing: Full, IRON

Lot Description: In City, Public Sidewalk
Lot Size Acres: 0.431
Lot Size Dimensions: 24.56 x 86.05 x 104.34 x 54.62 x 103.09
Lot Size Square Feet: 18774

Garage Spaces: 3
Garage Description: Attached

Association: Yes
Association Fee: 900
Association Fee Frequency: Annually
Calculated Total Monthly Association Fees: 75

Elementary School: Rohwer
High School: Millard West
Middle School: Russell
School District: Millard

Rohwer Elementary School is a public elementary school located approximately 0.2 miles away.
directions icon Map directions

Russell Middle School is a public middle school located approximately 1.1 miles away.
directions icon Map directions

Millard West High School is a public high school located approximately 1.4 miles away.
directions icon Map directions

St Stephen The Martyr School is a private elementary and middle school located approximately 1.4 miles away.
directions icon Map directions

Annual Tax Amount: 16733.26
Source Listing Status: Active
County: Douglas
Directions: 175th Ave and F Street. North to home.
Tax Year: 2023
Source Property Type: RESIDENTIAL
Source Neighborhood: Bay Wood
Ownership Type: Fee Simple
Parcel Number: 0537780176
Subdivision: Bay Wood
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$758,900 + $81,600
$840,500
$17,764
2021$489,300 + $81,600
$570,900
$12,003
2020$489,300 + $81,600
$570,900
$12,104
2019$662,400 + $81,600
$744,000
$15,822
2018$662,400 + $81,600
$744,000
$16,041
2017$662,400 + $81,600
$744,000
$15,790
2016$552,300 + $80,300
$632,600
$13,439
2015$516,200 + $75,000
$591,200
$12,690
2014$516,200 + $75,000
$591,200
$12,821
2013$516,200 + $75,000
$591,200
$13,698
2012$516,200 + $75,000
$591,200
$13,251
2010$630,100 + $75,000
$705,100
$15,688

Listing removed 2024-04-02
$2,200,000
GreatPlainsRegional
Listed 2024-04-02
$2,050,000
GreatPlainsRegional
Listed 2024-01-12
$2,200,000
GreatPlainsRegional
Sold 2021-11-22
$844,500
GreatPlainsRegional
Sold 2001-01-04
$369,000
Public Record

Total Square Feet Living: 4912
Year Built: 2001
BelowGradeFinishedArea: 2385
Construction Materials: Cement Board, Stucco
Foundation Details: Poured Concrete
Property Age: 23
Roof: Composition
House Style: 1.0 Story/Ranch
Total Above Grade Sqft Area: 2527
Total Area Main: 2527
Total Below Grade Area: 2457
Year Built Details: Not New and NOT a Model

Electric
Natural Gas
Sewer
Water
Water Source: Public Sewer, Public Water
Click Thumbnail Images To View Full Size
unknownunknownunknownkitchenkitchen
kitchenkitchenkitchenkitchenkitchen
dining_roomdining_roomliving_roomliving_roomliving_room
living_roomliving_roombedroombedroomunknown
bathroombathroombathroomunknownunknown
unknownunknownunknowndining_roomkitchen
living_roomliving_roomliving_roombedroombedroom
bathroombathroomliving_roomlaundry_roombedroom
bedroomporchporchporchunknown
poolporchunknownunknownunknown
unknownunknownunknownunknownhouse_view
house_viewhouse_viewhouse_view

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.