NOT LISTED FOR SALE

870 NW Frescott Cir Waukee, IA 50263

Estimated Value: $526,568 - $534,000

4 Beds
3 Baths
1,747 Sq Ft
$304/Sq Ft Est. Value

Last Sold March 04, 2025

Last sale price $522,450 $299 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $2,796/month

77 Days on Market

Highlights

  • Deck
  • Ranch Style House
  • Patio
  • Grant Ragan Elementary Rated A
  • Mud Room
  • Forced Air Heating and Cooling System

About This Home

As of March 2025

Perfectly located in the Waukee Northwest schools, this 4-bedroom, 3-bath home has over 2,900 finished square feet with a walkout basement. If you’re looking for more space to entertain, this home has it! The open floorplan on the main level features a large kitchen and dining room perfect for hosting all your friends and family. The kitchen features a large center island, soft-close cabinets, a gas stove, and plenty of countertop space for cooking. The primary bedroom includes an ensuite bathroom with a custom tile shower, double vanity sink, and a large walk-in closet that flows through to the laundry room and mudroom. Also on the main, you’ll find a second bedroom and a full bathroom. The finished walk-out basement includes a large family room, wetbar, two additional bedrooms, and a full bathroom. Enjoy the outdoor space with a covered deck and concrete patio, and an irrigated yard. Located on a cul-de-sac, this home is within walking distance to the Waukee Northwest high school, Grant Ragan Elementary, Waukee YMCA, and Triumph Park.

Last Agent to Sell the Property

Abby Conley

LPT Realty, LLC Listed on: 11/21/2024

LPT Realty, LLC

Co-Listed By

Colin Panzi

LPT Realty, LLC

Last Buyer's Agent

Chris Moore

RE/MAX Concepts

RE/MAX Concepts

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10

Year Built

  • Built in 2024

Lot Details

  • 0.25

HOA Fees

  • $17 Monthly HOA Fees

Home Design

  • Ranch Style House
  • Asphalt Shingled Roof
  • Stone Siding
  • Cement Board or Planked

Interior Spaces

  • 1,747 Sq Ft Home
  • Electric Fireplace
  • Mud Room
  • Family Room Downstairs
  • Dining Area
  • Finished Basement
  • Walk-Out Basement

Bedrooms and Bathrooms

  • 4 Bedrooms | 2 Main Level Bedrooms

Parking

  • 3 Car Attached Garage
  • Driveway

Outdoor Features

  • Deck
  • Patio

Additional Features

  • 0.25 Acre Lot
  • Forced Air Heating and Cooling System

Community Details

  • Landmark Development Association
  • Built by Sage

Listing and Financial Details

  • Assessor Parcel Number 1228202004

Home Details

Home Type

Single Family

Est. Annual Taxes

$10

Year Built

Built in 2024

Lot Details

0

HOA Fees

$17 per month

Listing Details

  • Property Type: Residential
  • Property Subtype: Residential
  • Style: Ranch
  • Homebuilder: Sage
  • Lp Amt Sq Ft: 309.04
  • Natl Assocof Home Builders: No
  • Sp Amt Sq Ft: 299.06
  • Termite: Follow Showing Instructions
  • Year Built: 2024
  • Special Features: NewHome
  • Property Sub Type: Detached

Interior Features

  • Fireplace: Electric
  • Fireplaces: 1
  • Total Bathrooms: 3.00
  • Full Bathrooms: 3
  • First Floor Full Bathrooms: 2
  • Lower Level Full Bathrooms: 1
  • Basement Description: Finished, Walkout
  • Dining Room: Dining Areas
  • Family Room: 1st Floor, Lower Level
  • Other Rooms: Mud Room
  • Living Area Sq Ft: 1747
  • Total Sq Ft: 1747

Exterior Features

  • Exterior: Cement Board, Stone
  • Exterior Features: Deck, Open Patio
  • Foundation: Poured
  • Roof: Asphalt Shingle
  • Street Feature: Concrete

Garage/Parking

  • Driveway: Concrete
  • Garage: 3 Attached

Utilities

  • Sewer: City
  • Water: City
  • Air Conditioner: Central
  • Heat: Gas Forced Air

Condo/Co-op/Association

  • Association Fee: 200.0000
  • Association Fee Term: Year
  • Association Fee: Yes

Association/Amenities

  • HOA Name: Prairie Rose
  • Management Firm: Landmark Development

Lot Info

  • Acres: 0.2500
  • Lot S F: 10890
  • Assessor Parcel Number: 1228202004
  • Zoning: RES

Green Features

  • Additional Green Features: No
  • ENERGYSTAR qualified New Home: No
  • HERS Rating: No
  • Leed For Homes: No
  • Solar: No

Multi Family

  • Geo Solar Thermal: No

Tax Info

  • Gross Taxes: 10.00
  • Net Taxes: 10.00

MLS Schools

  • School District: Waukee

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 21, 2024
Closed on
Feb 28, 2025
Sold by
Csb Assets Llc
Bought by
Loren Tasha M and Louvan Tyler
Seller's Agent
Abby Conley
LPT Realty, LLC
Buyer's Agent
Chris Moore
RE/MAX Concepts
List Price
$539,900
Sold Price
$522,450
Premium/Discount to List
-$17,450
-3.23%
Views
33
Current Estimated Value
$530,642

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$8,192
Avg. Annual Appreciation
2.42%
Original Mortgage
$452,450
Outstanding Balance
$450,170
Interest Rate
6.95%
Mortgage Type
New Conventional
Estimated Equity
$80,472

Purchase Details

Closed on
Oct 4, 2023
Sold by
Crescent Homes Llc
Bought by
Csb Assets Llc
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
Loren Tasha M $522,500 None Listed On Document
Csb Assets Llc -- None Listed On Document
Csb Assets Llc -- None Listed On Document
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Loren Tasha M $452,450
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/04/2025 03/04/25 Sold $522,450 -3.2% $299 / Sq Ft
02/06/2025 02/06/25 Pending -- -- --
11/21/2024 11/21/24 For Sale $539,900 -- $309 / Sq Ft
Source: Des Moines Area Association of REALTORS®

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 $10 $256,920 $115,000 $141,920
2023 $10 $140,000 $115,000 $25,000
2022 $10 $490 $490 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Des Moines Area Association of REALTORS®

MLS Number: 708211

Des Moines Area Association of REALTORS®

APN: 12-28-202-004