$1,200,000
SOLD FEB 3, 2025
Last list price

497 Century Ave Caldwell, ID 83605

3 Beds
3 Baths
2,856 Sq Ft
0.5 Acres

Recently Sold

$420 Per Sq Ft

37 Days on Market

Highlights

  • New Construction
  • Two Primary Bedrooms
  • Wood Flooring
  • RV Access or Parking
  • Recreation Room
  • Great Room

About This Home

As of February 2025

Welcome to this beautiful modern farmhouse by Mendiola Custom Homes in Middleton's new River Walk Crossing Subdivision. The finest materials and design have been used in this lovely 3 bed, 3.5 bath single level home. Custom lighting and well-placed accent lighting. Beautiful, vaulted ceilings. A single full refrigerator and single full freezer in Kitchen. Large industrial size double oven/range. Designer fireplace surrounded with custom built-ins. Custom cabinetry throughout. Spa like Master bathroom retreat. 3rd Bedroom is a second master/mother-in-law/guest quarters. Bonus/rec room, & office. Garage is the perfect playroom if you do not fill it with Toys! From the covered back porch, you step out to your private beach front.

Last Agent to Sell the Property

Kirk Hessing

Silvercreek Realty Group Listed on: 11/15/2024

Silvercreek Realty Group

Co-Listed By

Barb Malmstrom

Silvercreek Realty Group

Last Buyer's Agent

Kirk Hessing

Silvercreek Realty Group Listed on: 11/15/2024

Silvercreek Realty Group

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2024 | New Construction

Lot Details

  • 0.5 Acre Lot
  • Sprinkler System

HOA Fees

  • $75 Monthly HOA Fees

Parking

  • 4 Car Attached Garage
  • Driveway
  • Open Parking
  • RV Access or Parking

Home Design

  • Architectural Shingle Roof
  • Composition Roof
  • HardiePlank Type
  • Stucco

Interior Spaces

  • 2,856 Sq Ft Home
  • 1-Story Property
  • Plumbed for Central Vacuum
  • Gas Fireplace
  • Great Room
  • Den
  • Recreation Room
  • Crawl Space

Kitchen

  • Double Oven
  • Gas Oven
  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Main Level Bedrooms
  • Double Master Bedroom
  • Split Bedroom Floorplan
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • 3 Bathrooms
  • Double Vanity

Outdoor Features

  • Covered Patio or Porch

Schools

  • Mill Creek Elementary School
  • Middleton Jr
  • Middleton High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Gas Water Heater

Community Details

  • Built by Mendiola Custom Homes

Listing and Financial Details

  • Assessor Parcel Number R3393813400

Home Details

Home Type

Single Family

Year Built

Built in 2024 | New Construction

Lot Details

0

HOA Fees

$75 per month

Parking

4

Listing Details

  • Year Built: 2024
  • Kitchen Level: Main
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.5
  • Road Frontage Type: Public Road
  • Road Surface Type: Paved
  • Co List Office Phone: 208-377-0422
  • Ownership: Fee Simple
  • Subdivision Name: River Walk Crossing
  • Above Grade Finished Sq Ft: 2856
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: Yes
  • ResoPropertyType: Residential
  • Special Features: NewHome

Interior Features

  • Heating: Forced Air, Natural Gas
  • Room Bedroom2 Level: Main
  • Master Bedroom Master Bedroom Level: Main
  • Room Office Level: Main
  • Room Office Area: 110
  • Room Bedroom3 Level: Main
  • Room Kitchen Area: 156
  • Dining Room Dining Room Level: Main
  • Master Bedroom Master Bedroom Width: 15
  • Room Master Bedroom Area: 240
  • Room Dining Room Area: 156
  • Appliances: Gas Water Heater, Tank Water Heater, Dishwasher, Disposal, Double Oven, Microwave, Oven/Range Freestanding, Refrigerator, Gas Oven, Gas Range
  • Total Bedrooms: 3
  • Fireplace Features: Gas, One
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Tile, Carpet, Engineered Wood Floors
  • Interior Amenities: Bath-Master, Bed-Master Main Level, Split Bedroom, Den/Office, Great Room, Rec/Bonus, Two Master Bedrooms, Dual Vanities, Central Vacuum Plumbed, Walk-In Closet(s), Pantry, Kitchen Island, Quartz Counters
  • Living Area: 2856
  • Main Level Bathrooms: 3
  • Main Level Bedrooms: 3
  • ResoLivingAreaSource: Plans

Exterior Features

  • Roof: Architectural Style, Composition
  • Builder Name: Mendiola Custom Homes
  • Construction Type: Stucco, Other, HardiPlank Type
  • Foundation Details: Crawl Space
  • Patio And Porch Features: Covered Patio/Deck

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 4
  • Garage Spaces: 4
  • Open Parking: Yes
  • Parking Features: Attached, RV Access/Parking, Finished Driveway
  • Total Parking Spaces: 4

Utilities

  • Cooling: Central Air
  • Water Source: City Service
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Sewer Connected

Condo/Co-op/Association

  • Association Fee: 900
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Schools

  • Elementary School: Mill Creek
  • Junior High Dist: Middleton School District #134
  • High School: Middleton
  • Middle Or Junior School: Middleton Jr

Lot Info

  • Lot Features: 1/2 - .99 AC, Auto Sprinkler System, Full Sprinkler System, Pressurized Irrigation Sprinkler System
  • Parcel Number: R3393813400
  • Current Use: Single Family
  • Land Lease: No
  • Lot Size Sq Ft: 21780
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Year: 2023

Multi Family

  • Above Grade Finished Area Units: Square Feet

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

Property History

Date Event Price List to Sale Price per Sq Ft
02/03/2025 02/03/25 Sold -- -- --
12/22/2024 12/22/24 Pending -- -- --
11/15/2024 11/15/24 For Sale $1,200,000 -- $420 / Sq Ft
Source: Intermountain MLS

Tax History Compared to Growth

Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Intermountain MLS

MLS Number: 98929358

Intermountain MLS