Discover Luxury Living at Sterling Lakes! If you're looking for a quality-built home with premium upgrades and exceptional craftsmanship, come see what sets us apart. This amazing home offers 2,694 sq. ft. of thoughtfully designed living space with 4 bedrooms, 3 baths. The open-concept layout is perfect for entertaining, while the gourmet kitchen features quartz countertops, a large island, built-in stainless steel appliances, slow-close wood cabinetry, and a walk-in pantry. Relax in the spacious main floor primary suite with a soaking tub, oversized walk-in shower, and a walk-through closet connecting directly to the laundry room. Upstairs has 2 bedrooms, full bath and a bonus room for gathering. Need extra garage space? Enjoy a textured, painted, and insulated 2-car garage plus a 40' deep RV bay offering room for 4 vehicles, toys, or storage its up to you. Front and back landscaping, sprinklers, and fencing are included. Photos are similar; features, elevations, finishes, and colors may vary. Elevation renderings are for illustration purposes only and may not accurately depict the actual condition of the item being represented. All square footage is approximate. See a sales representative for details.
New
$624,900
232 Sturgeon Ave, Middleton, ID 83644
3beds
3baths
2,694sqft
Single Family Residence
Built in 2027
7,840 Square Feet Lot
$-- Zestimate®
$232/sqft
$100/mo HOA
What's special
Bonus room for gatheringLarge islandQuartz countertopsGourmet kitchenBuilt-in stainless steel appliancesSlow-close wood cabinetryWalk-in pantry
- 13 hours |
- 122 |
- 7 |
Zillow last checked:
Listing updated:
Listed by:
Chris Schneider Main:208-999-0156,
Starwood Realty Inc
Source: IMLS,MLS#: 98998381
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Main level bathrooms: 2
- Main level bedrooms: 2
Primary bedroom
- Level: Main
Bedroom 2
- Level: Main
Bedroom 3
- Level: Upper
Bedroom 4
- Level: Upper
Kitchen
- Level: Main
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Gas Water Heater, ENERGY STAR Qualified Water Heater, Tank Water Heater, Dishwasher, Disposal, Double Oven, Microwave, Oven/Range Built-In, Gas Oven, Gas Range
Features
- Bath-Master, Bed-Master Main Level, Great Room, Double Vanity, Central Vacuum Plumbed, Walk-In Closet(s), Breakfast Bar, Pantry, Kitchen Island, Quartz Counters, Number of Baths Main Level: 2, Number of Baths Upper Level: 1, Bonus Room Level: Upper
- Flooring: Carpet, Engineered Vinyl Plank, Laminate
- Has basement: No
- Number of fireplaces: 1
- Fireplace features: One, Gas, Insert
Interior area
- Total structure area: 2,694
- Total interior livable area: 2,694 sqft
- Finished area above ground: 2,694
- Finished area below ground: 0
Property
Parking
- Total spaces: 4
- Parking features: Attached, RV Access/Parking, Driveway
- Attached garage spaces: 4
- Has uncovered spaces: Yes
Features
- Levels: Two
- Patio & porch: Covered Patio/Deck
- Fencing: Full,Vinyl
- Waterfront features: Pond Community
Lot
- Size: 7,840 Square Feet
- Dimensions: 75 x 107
- Features: Standard Lot 6000-9999 SF, Garden, Sidewalks, Auto Sprinkler System, Drip Sprinkler System, Full Sprinkler System, Pressurized Irrigation Sprinkler System
Details
- Parcel number: 33869138 0
- Zoning: R-3-DA
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Stone, Stucco, HardiPlank Type
- Foundation: Crawl Space
- Roof: Composition
Condition
- New Construction
- New construction: Yes
- Year built: 2027
Details
- Builder name: Sterling Homes
Utilities & green energy
- Water: Public
- Utilities for property: Sewer Connected, Broadband Internet
Community & HOA
Community
- Subdivision: Sterling Lakes
HOA
- Has HOA: Yes
- HOA fee: $300 quarterly
Location
- Region: Middleton
Financial & listing details
- Price per square foot: $232/sqft
- Date on market: 8/23/2026
- Listing terms: Cash,Conventional,1031 Exchange,VA Loan
- Ownership: Fee Simple
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history is unavailable.
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 83644
Nearby schools
GreatSchools rating
- 8/10Middleton Mill Creek Elementary SchoolGrades: PK-5Distance: 0.8 mi
- NAMiddleton Middle SchoolGrades: 6-8Distance: 1.7 mi
- 8/10Middleton High SchoolGrades: 9-12Distance: 2.8 mi
Schools provided by the listing agent
- Elementary: Mill Creek
- Middle: Middleton Jr
- High: Middleton
- District: Middleton School District #134
Source: IMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- $674,9003 bd4 ba2.3k sqft218 Sturgeon Ave, Middleton, ID 83644New Construction
- $256,8403 bd1 ba1.7k sqft23249 Duff Ln, Middleton, ID 83644Off Market
- $1,019,6002 bd1 ba1.1k sqft23005 Duff Ln, Middleton, ID 83644Off Market
- $39,7004 bd2 ba1.7k sqft23249 Duff Ln, Middleton, ID 83644Off Market
- $1,467,8003 bd2 ba1.7k sqft23251 Duff Ln, Middleton, ID 83644Off Market
- $39,7004 bd2 ba1.7k sqft23251 Duff Ln, Middleton, ID 83644Off Market
- $653,0002 bd2 ba2.4k sqft23041 Duff Ln, Middleton, ID 83644Off Market
- $960,2003 bd2 ba2.6k sqft10346 Highway 44, Middleton, ID 83644Off Market
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
Similar homes
- from $715,0003 bd2 ba2.8k sqftSpring Creek Plan, River Pointe, Middleton, ID 83644New Construction
Gardner Homes - from $639,9954 bd3 ba2.6k sqftForest Plan, Heirloom Ridge - Willow, Star, ID 83669New Construction
Toll Brothers Inc. - from $567,9954 bd3 ba2.6k sqftForest Plan, Meadows at West Highlands - Willow, Middleton, ID 83644New ConstructionToll Brothers Inc.
- from $649,9003 bd3 ba2.5k sqftThe Rogue Plan, Inspirado, Meridian, ID 83646New Construction
Pacific Lifestyle Homes - $675,0003 bd3 ba2.3k sqft4819 Gap Creek Ave, Caldwell, ID 83607ActiveMLS ID #98995055, Casey Coller, Berkshire Hathaway HomeServices Silverhawk Realty. IMLS
- from $584,9904 bd4 ba2.9k sqftDarius Plan, Sellwood, Star, ID 83669New ConstructionRichmond Homes
- from $550,9954 bd3 ba2.6k sqftForest Plan, Passero Ridge - Willow, Caldwell, ID 83607New ConstructionToll Brothers Inc.
- $749,9003 bd3 ba2.4k sqft10452 W Mizzle Dr, Star, ID 83669ActiveMLS ID #98993644, Chris Schneider, Starwood Realty Inc. IMLS
- from $519,9903 bd2 ba1.7k sqftBronze Plan, Sellwood, Star, ID 83669New ConstructionRichmond Homes
- from $623,9003 bd4 ba2.6k sqftConcord Plan, Valnova, Eagle, ID 83616New ConstructionShea Homes
- from $639,9953 bd2 ba2.3k sqftFonte Plan, Torrente - Solena Collection, Eagle, ID 83616New ConstructionToll Brothers Inc.
- from $627,9903 bd4 ba2.9k sqftRedwood Plan, Prescott Ridge, Saint Meridian, ID 83646New ConstructionHubble Homes
- from $565,0003 bd3 ba2.2k sqftThe Oakley: Build On Your Lot Plan, Build On Your Lot, Emmett, ID 83617New ConstructionRenegade Homes Inc.
- from $622,9952 bd3 ba2.2k sqftEdmund Plan, Regency at Milestone Ranch - Orchard, Star, ID 83669New ConstructionToll Brothers Inc.
- $674,9953 bd2 ba2.1k sqft7066 W Alveo Dr, Eagle, ID 83616ActiveMLS ID #98979041, Joan Urso, Toll Brothers Real Estate, Inc. IMLS
- from $599,9903 bd3 ba2.7k sqftHarley Plan, Franklin Village North, Nampa, ID 83687New ConstructionRichmond Homes
- from $844,9904 bd4 ba3.2k sqftHarley Plan, Iron Mountain Vista, Tcw6t0 Star, ID 83669New ConstructionRichmond Homes
- from $749,9003 bd3 ba2.4k sqftMelody Plan, Cherished Estates, Star, ID 83669New ConstructionSterling Homes
- from $545,0003 bd2 ba1.8k sqftJessie Plan, Whiteley Meadows, Emmett, ID 83617New ConstructionRenegade Homes Inc.
- from $580,9953 bd2 ba2.2k sqftBramley Plan, Heirloom Ridge - Willow, Star, ID 83669New ConstructionToll Brothers Inc.
