NOT LISTED FOR SALE

Estimated Value: $658,826 - $716,000

4 Beds
3.5 Baths
3,191 Sq Ft
$213/Sq Ft Est. Value

Last Sold May 01, 2025

Last sale price $675,000 $212 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $3,742/month

65 Days on Market

Highlights

  • New Construction
  • Covered Deck
  • Ranch Style House
  • Reagan Elementary School Rated A-
  • Family Room with Fireplace
  • Wood Flooring

About This Home

As of May 2025

Craftsmanship in every corner w/ Ramm Construction 4th generation homebuilders! Our Dotty ranch plan greets you w/ an extended covered porch flanked by columns complementing natural stone & black Marvin windows. Inside, durable engineered wood floors span from the LR to dining & kitchen featuring GE profile appliances. Custom, locally-crafted cabinets add to the storage provided by the large walk-in pantry, extended kitchen island, & built-in hutch. Natural stone appears on the fireplace from floor to ceiling, drawing the eye up to custom ceiling details. Upgrades carry through to the baths w/ quartz countertops, chrome fixtures, & ceramic tile (and so. much. storage!). We love this floor plan featuring 2 en suite bedrooms on the main floor in addition to a powder bath. Finished lower level offers flex room, family room w/ electric fireplace, & a well-equipped wet bar. Extended 3-car garage. This home provides a composite deck to enjoy a view of the walkout lot. Quality matters at Ramm

Last Agent to Sell the Property

Aubrey Hess

Better Homes and Gardens R.E. License #20060160 Listed on: 01/09/2025

Better Homes and Gardens R.E.

Last Buyer's Agent

Gregory Kraemer

NP Dodge RE Sales Inc 148Dodge License #20160093

NP Dodge RE Sales Inc 148Dodge

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,242

Year Built

  • Built in 2024 | New Construction

Lot Details

  • 10,019 Sq Ft Lot
  • Lot Dimensions are 71.61 x 130.19 x 81.58 x 130
  • Sprinkler System

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

  • Ranch Style House
  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • Wet Bar
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Electric Fireplace
  • Gas Fireplace
  • Sliding Doors
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace

Kitchen

  • Oven
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Wall to Wall Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

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

Finished Basement

  • Walk-Out Basement
  • Sump Pump
  • Basement with some natural light

Outdoor Features

  • Balcony
  • Covered Deck
  • Covered Patio or Porch

Schools

  • Ronald Reagan Elementary School
  • Beadle Middle School
  • Millard West High School

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Gas

Community Details

  • Property has a Home Owners Association
  • Built by Ramm Construction
  • Ruscello / North Streams Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1842022226

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,242

Year Built

Built in 2024 | New Construction

Lot Details

10,019 Sq Ft Lot

Parking

3

Listing Details

  • Parcel Number: 1842022226
  • Property Sub Type: Single Family Residence
  • Year Built: 2024
  • Prop. Type: Residential
  • Lot Size Acres: 0.23
  • Lot Size: 71.61 x 130.19 x 81.58 x 130
  • Ownership: Fee Simple
  • Subdivision Name: Ruscello / North Streams
  • Directions: From 204th, head East on J Street, turn South on 202 Ave, property is on the East side of the street.
  • Above Grade Finished Sq Ft: 1864
  • Architectural Style: Ranch
  • Carport Y N: No
  • Garage Yn: Yes
  • New Construction: Yes
  • ResoBuildingAreaSource: Plans
  • Remarks22: Exterior to be painted when weather permits. Douglas County tax assessment for calendar year 2024 just received at lot value only. GREAT NEWS FOR YOUR BUYERS! SHOWINGS: Please call Showing Time to schedule an appointment. CONTRACTS: can be emailed to hello@aubreyhess.com. Please contact me beforehand, and I'll be glad to help you properly complete builder addenda. Please allow 24 hours response time for offers. Pre approval letter or proof of funds to be submitted with all offers. Association dues (if any) are thought to be accurate. Buyer responsible to ensure accuracy. AMA PHOTOGRAPHY OR VIDEOGRAPHY: for any sort of promotional or social media use without the express written consent of the owner or agent is strictly prohibited.
  • Kitchen Level: Main Floor
  • Special Features: 4098

Interior Features

  • Interior Amenities: Wet Bar, 9'+ Ceiling, Ceiling Fan(s), Pantry
  • Basement: Walk-Out Access, Full, Finished
  • Appliances: Humidifier, Range - Cooktop + Oven, Oven - No Cooktop, Dishwasher, Microwave
  • Other Equipment: Sump Pump
  • Basement YN: Yes
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1327
  • Door Features: Sliding Doors
  • Fireplace Features: Family Room, Living Room, Direct-Vent Gas Fire, Electric
  • Fireplaces: 2
  • Fireplace: Yes
  • Living Area: 3191
  • ResoLivingAreaSource: Plans
  • Room Office Area: 143.6042
  • Bedroom 1 Level: Main Floor
  • Room Bedroom2 Level: Basement
  • Room Bedroom3 Level: Basement
  • Room Office Features: Wall/Wall Carpeting
  • Dining Room Dining Room Level: Main Floor
  • Room Family Room Level: Basement
  • Room Kitchen Features: Wood Floor, Pantry
  • Living Room Living Room Level: Main Floor
  • Bedroom 1 Features: Wall/Wall Carpeting
  • Room Bedroom2 Features: Wall/Wall Carpeting, Walk-In Closet(s)
  • Room Bedroom3 Features: Wall/Wall Carpeting, Walk-In Closet(s)
  • Dining Room Features: Wood Floor, Balcony/Deck, Sliding Glass Door
  • Family Room Features: Wall/Wall Carpeting, Wood Floor, Fireplace, Wet Bar
  • Living Room Features: Wood Floor, Fireplace, Ceiling Fan(s)
  • Master Bedroom Master Bedroom Level: Main Floor
  • Master Bedroom Features: Wall/Wall Carpeting, 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, Drain Tile
  • Fencing: None
  • Builder Name: Ramm Construction
  • Patio And Porch Features: Covered Deck, Deck, Covered Patio
  • Property Condition: New Construction
  • Roof: Composition

Garage/Parking

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

Utilities

  • Cooling: Central Air
  • Laundry Features: Ceramic Tile Floor
  • Cooling Y N: Yes
  • Heating: Gas, Forced Air
  • Heating Yn: Yes
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

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

Schools

  • High School: Millard West
  • Elementary School: Ronald Reagan
  • Junior High Dist: Millard
  • Middle Or Junior School: Beadle

Lot Info

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

Green Features

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 1241.62

Multi Family

  • Above Grade Finished Area Units: Square Feet

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 9, 2025
Closed on
Apr 21, 2025
Sold by
Ramm Construction Inc
Bought by
Geis Adam and Geis Mary
Seller's Agent
Aubrey Hess
Better Homes and Gardens R.E.
Buyer's Agent
Gregory Kraemer
NP Dodge RE Sales Inc 148Dodge
List Price
$675,000
Sold Price
$675,000
Views
43
Current Estimated Value
$680,957

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$5,957
Avg. Annual Appreciation
0.97%
Original Mortgage
$540,000
Outstanding Balance
$537,285
Interest Rate
6%
Mortgage Type
New Conventional
Estimated Equity
$143,672

Purchase Details

Closed on
Feb 2, 2024
Sold by
Millard 35 Llc
Bought by
Jbt Holdings Llc
Source: Public Records

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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Geis Adam $675,000 Ambassador Title
Ramm Construction Inc $57,000 Ambassador Title
Jbt Holdings Llc $298,000 Midwest Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Geis Adam $540,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
05/01/2025 05/01/25 Sold $675,000 0.0% $212 / Sq Ft
03/15/2025 03/15/25 Pending -- -- --
01/09/2025 01/09/25 For Sale $675,000 -- $212 / Sq Ft
Source: Great Plains Regional MLS

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 $1,242 $558,500 $85,000 $473,500
2024 $991 $56,100 $56,100 --
2023 $991 $40,000 $40,000 --
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Great Plains Regional MLS

MLS Number: 22500928

Great Plains Regional MLS

APN: 4202-2226-18

Your Personal Tour Guide

Ask me questions while you tour the home.