NOT LISTED FOR SALE

221 N 245th Cir Waterloo, NE 68069

Estimated Value: $1,623,117 - $1,823,000

5 Beds
3.5 Baths
5,360 Sq Ft
$326/Sq Ft Est. Value

Sale Details

Date Sold: November 7, 2017

Last sale price $1,200,000 $224 Per Sq Ft

Est. 39% increase in value since last sale

Current estimated payment $10,681 / mo

56 Days on Market

Highlights

  • Lake Front
  • Spa
  • Living Room with Fireplace
  • Douglas County West High School Rated 9+
  • Covered Deck
  • Ranch Style House

About This Home

As of November 2017

This luxurious 5 BD 5 BA, spanning over 5000 SF Ranch has magnificent waterfront views & is graced by soaring 10"-16"ceilings w/ custom designer touches. The immaculate entryway draws you into a voluminous layout made for entertaining. Accompanied by an elegant eat-in Kitchen w/ large center island. Master suite presents windows overlooking the water, & master bath that will leave you breathless. Rain or snow enjoy the ALL SEASON family room and LL rec rm, theatre rm & wet bar, Ted Grace built.

Last Agent to Sell the Property

Lori Paul

BHHS Ambassador Real Estate License #20020891 Listed on: 07/27/2017

BHHS Ambassador Real Estate

Last Buyer's Agent

Staci Mueller

BHHS Ambassador Real Estate License #20080312

BHHS Ambassador Real Estate

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $21,106

Year Built

  • Built in 2015

Lot Details

  • Lot Dimensions are 65 x 225 x 211.25 x 225
  • Lake Front
  • Cul-De-Sac
  • Sprinkler System

HOA Fees

  • $42 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Heated Garage

Home Design

  • Ranch Style House
  • Composition Roof
  • Cement Board or Planked
  • Stone

Interior Spaces

  • Wet Bar
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Window Treatments
  • Living Room with Fireplace
  • 2 Fireplaces
  • Dining Area
  • Recreation Room with Fireplace
  • Home Security System

Kitchen

  • Double Oven
  • Warming Drawer
  • Microwave
  • Dishwasher
  • Wine Refrigerator
  • Disposal

Flooring

  • Wood
  • Wall to Wall Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Dual Sinks
  • Whirlpool Bathtub
  • Shower

Laundry

  • Dryer
  • Washer

Basement

  • Walk-Out Basement
  • Basement Windows

Outdoor Features

  • Spa
  • Balcony
  • Covered Deck
  • Patio
  • Exterior Lighting
  • Porch

Schools

  • Waterloo Elementary And Middle School
  • Waterloo High School

Utilities

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

Community Details

  • Association fees include lake, common area maintenance
  • Built by Ted Grace
  • West Shores Subdivision

Listing and Financial Details

  • Assessor Parcel Number 2524500578
  • Tax Block 2

Home Details

Home Type

Single Family

Est. Annual Taxes

$21,106

Year Built

Built in 2015

Lot Details

0.71 Acres

HOA Fees

$42 per month

Parking

3

Listing Details

  • Parcel Number: 2524500578
  • Property Sub Type: Single Family Residence
  • Year Built: 2015
  • Prop. Type: Residential
  • Lot Size: 65 x 225 x 211.25 x 225
  • Ownership: Fee Simple
  • Subdivision Name: West Shores
  • Directions: HWY 275 (240th Street) and W Dodge Road, West to 243rd ST. Left to Chicago St. Right to 245th Circle Left to home
  • Above Grade Finished Sq Ft: 3448
  • Architectural Style: Ranch
  • Carport Y N: No
  • Garage Yn: Yes
  • New Construction: No
  • Remarks22: AMA, AATLA Lori Paul (402)681-9371; As much notice as possible. Agent to accompany all showings. OPPD - $236 / Black Hills - $136 Custom built in 2015 by Ted Grace, 10'-16' soaring ceilings throughout. Amazing designer touches from the entry custom doors to the all season deck to enjoy year round! Heated master bathroom floors, Theatre room in LL, remote window treatments, Bosch and Thermador appliances, McKay exterior lightning.Infinity effect view from the kitchen great room windows.
  • Kitchen Level: Main Floor
  • Special Features: None

Interior Features

  • Interior Amenities: Wet Bar, 9'+ Ceiling
  • Basement: Walk-Out Access
  • Private Spa: Yes
  • Appliances: Humidifier, Range - Cooktop + Oven, Oven - No Cooktop, Refrigerator, Water Softener, Washer, Dishwasher, Dryer, Disposal, Microwave, Double Oven, Warming Drawer, Wine Refrigerator
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1912
  • Fireplace Features: Recreation Room, Living Room
  • Fireplaces: 2
  • Fireplace: Yes
  • Flooring: Carpet, Ceramic Tile, Wood
  • Living Area: 5360
  • Window Features: Window Covering, LL Daylight Windows
  • Room Bedroom4 Area: 208.16
  • Bedroom 1 Level: Main Floor
  • Room Bedroom2 Level: Main Floor
  • Room Bedroom3 Level: Below Grade
  • Room Bedroom4 Level: Below Grade
  • Room Family Room Level: Main Floor
  • Room Kitchen Features: Wood Floor, Window Covering, 9'+ Ceiling, Dining Area, Pantry
  • Bedroom 1 Features: Wall/Wall Carpeting, Window Covering, 9'+ Ceiling, Balcony/Deck, Walk-In Closet(s)
  • Room Bedroom2 Features: Wall/Wall Carpeting, Window Covering, 9'+ Ceiling
  • Room Bedroom3 Features: Wall/Wall Carpeting, Window Covering, 9'+ Ceiling, Walk-In Closet(s)
  • Room Bedroom4 Features: Wall/Wall Carpeting, Window Covering, 9'+ Ceiling, Walk-In Closet(s)
  • Living Room Features: Wood Floor, Window Covering, Fireplace, 9'+ Ceiling, Interior Balcony
  • Master Bedroom Master Bedroom Level: Main Floor
  • Master Bedroom Features: Wall/Wall Carpeting, Window Covering, 9'+ Ceiling, Ceiling Fan(s), Walk-In Closet(s)
  • Master Bathroom Features: Full, Shower, Whirlpool, Double Sinks

Exterior Features

  • Exterior Features: Sprinkler System, Lighting, Other
  • Fencing: None
  • Waterfront Features: Lake Front
  • Waterfront: Yes
  • Home Warranty: No
  • Builder Name: Ted Grace
  • Construction Type: Stone, Cement Board
  • Patio And Porch Features: Porch, Patio, Covered Deck, Deck
  • Property Condition: Not New and NOT a Model
  • Roof: Composition

Garage/Parking

  • Garage Spaces: 3
  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Parking Features: Attached, Heated Garage
  • Total Parking Spaces: 3

Utilities

  • Cooling: Central Air, Zoned
  • Laundry Features: Ceramic Tile Floor, Window Covering, 9'+ Ceiling
  • Security: Security System
  • Cooling Y N: Yes
  • Heating: Gas, Forced Air, Zoned
  • Heating Yn: Yes
  • Sewer: Public Sewer
  • Utilities: Cable Available
  • Water Source: Public

Condo/Co-op/Association

  • Senior Community: No
  • Association Fee: 500
  • Association Fee Frequency: Annually
  • Association: Yes

Fee Information

  • Association Fee Includes: Lake, Common Area Maintenance

Schools

  • High School: Waterloo
  • Elementary School: Waterloo
  • Junior High Dist: Douglas County West
  • Middle Or Junior School: Waterloo

Lot Info

  • Property Attached Yn: No
  • Lot Features: Over 1/2 up to 1 Acre, Lakefront, Cul-De-Sac, Subdivided
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2016
  • Tax Annual Amount: 21105.76
  • Tax Block: 2

Multi Family

  • Above Grade Finished Area Units: Square Feet

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 27, 2017
Closed on
Oct 12, 2017
Sold by
Yarlagadda Rajkumar and Chigurupati Vasanta
Bought by
Seller's Agent
Lori Paul
BHHS Ambassador Real Estate
Buyer's Agent
Staci Mueller
BHHS Ambassador Real Estate
List Price
$1,395,000
Sold Price
$1,200,000
Premium/Discount to List
-$195,000
-13.98%
Current Estimated Value
$1,666,340

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$466,340
Avg. Annual Appreciation
4.36%

Purchase Details

Closed on
Aug 15, 2013
Sold by
Tg Holdings Llc
Bought by
Yarlagadda Rajkumar

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$210,800
Interest Rate
4.42%
Mortgage Type
Future Advance Clause Open End Mortgage

Purchase Details

Closed on
Feb 28, 2013
Sold by
Century Development Company Llc
Bought by
T G Holdings Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$191,000
Interest Rate
3.59%
Mortgage Type
Unknown
Source: Public Records

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$1,200,000 Ambassador Title Services
Yarlagadda Rajkumar $248,000 Nebraska Title Company
T G Holdings Llc $225,000 Rels Title
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Closed $210,800
Previous Owner Tg Holdings Llc $191,000
Previous Owner Tg Holdings Llc $191,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
11/07/2017 11/07/17 Sold $1,200,000 -10.8% $224 / Sq Ft
09/21/2017 09/21/17 Pending -- -- --
09/11/2017 09/11/17 Price Changed $1,345,000 -3.6% $251 / Sq Ft
07/27/2017 07/27/17 For Sale $1,395,000 -- $260 / Sq Ft
Source: Great Plains Regional MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $17,337 $1,407,000 $349,900 $1,057,100
2024 $18,910 $1,407,000 $349,900 $1,057,100
2023 $18,910 $1,172,200 $349,900 $822,300
2022 $21,033 $1,172,200 $349,900 $822,300
2021 $20,109 $1,086,600 $349,900 $736,700
2020 $20,628 $1,086,600 $349,900 $736,700
2019 $23,416 $1,124,500 $292,600 $831,900
2018 $23,585 $1,124,500 $292,600 $831,900
2017 $21,278 $1,011,400 $292,600 $718,800
2016 $21,106 $970,500 $211,000 $759,500
2015 $3,084 $336,400 $211,000 $125,400
2014 $3,084 $137,200 $137,200 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Great Plains Regional MLS

MLS Number: 21713800

Great Plains Regional MLS

APN: 2450-0578-25

Your Personal Tour Guide

Ask me questions while you tour the home.