The Lancaster is a breathtaking modern farmhouse with elegant stone accents that seamlessly blend rustic charm and contemporary style. Its open floor plan is filled with natural light from expansive windows, leading to a spacious covered rear patio. The gourmet kitchen flows effortlessly into the inviting living area, perfect for entertaining, while a dedicated office space makes working from home easy and efficient. Standard features include 8' doors, a gas fireplace in the great room, quartz kitchen countertops, Bosch stainless steel appliances, LVP flooring, and premium carpet. Smart home upgrades like a Ring Doorbell and Nest Thermostat add convenience, while a gas line stub on the back patio makes outdoor cooking easy. A 50' RV garage provides ample storage. Located in Middleton’s Waterbrook Farms, this exclusive community features 26 homesites in a peaceful country setting, just moments from Purple Sage Golf Course.
Sold
Price Unknown
24837 Lavier Ave, Caldwell, ID 83607
4beds
3baths
2,392sqft
Single Family Residence
Built in 2025
0.84 Acres Lot
$905,500 Zestimate®
$--/sqft
$2,691 Estimated rent
Home value
$905,500
$833,000 - $987,000
$2,691/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: December 15, 2025 at 02:29pm
Listed by:
Andy Elliot 208-573-0473,
Silvercreek Realty Group,
Mike Brown 208-250-3444,
Silvercreek Realty Group
Bought with:
Mary Vis
Team Realty
Source: IMLS,MLS#: 98934526
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Main level bathrooms: 3
- Main level bedrooms: 4
Primary bedroom
- Level: Main
- Area: 225
- Dimensions: 15 x 15
Bedroom 2
- Level: Main
- Area: 132
- Dimensions: 12 x 11
Bedroom 3
- Level: Main
- Area: 143
- Dimensions: 13 x 11
Bedroom 4
- Level: Main
- Area: 144
- Dimensions: 12 x 12
Kitchen
- Level: Main
- Area: 240
- Dimensions: 16 x 15
Office
- Level: Main
- Area: 156
- Dimensions: 13 x 12
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Gas Water Heater, Tank Water Heater, Dishwasher, Disposal, Microwave, Oven/Range Built-In
Features
- Bath-Master, Bed-Master Main Level, Den/Office, Great Room, Double Vanity, Walk-In Closet(s), Pantry, Kitchen Island, Quartz Counters, Number of Baths Main Level: 3
- Flooring: Carpet
- Has basement: No
- Number of fireplaces: 1
- Fireplace features: One, Gas
Interior area
- Total structure area: 2,392
- Total interior livable area: 2,392 sqft
- Finished area above ground: 2,392
- Finished area below ground: 0
Property
Parking
- Total spaces: 4
- Parking features: Attached, Driveway
- Attached garage spaces: 4
- Has uncovered spaces: Yes
- Details: Garage: 28X24
Features
- Levels: One
- Patio & porch: Covered Patio/Deck
- Fencing: Full,Vinyl
Lot
- Size: 0.84 Acres
- Features: 1/2 - .99 AC, Horses, Chickens, Auto Sprinkler System, Full Sprinkler System, Pressurized Irrigation Sprinkler System
Details
- Parcel number: R3812711600
- Horses can be raised: Yes
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Stone, HardiPlank Type
- Foundation: Crawl Space
- Roof: Architectural Style
Condition
- New Construction
- New construction: Yes
- Year built: 2025
Details
- Builder name: Pontifex Homes LLC
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & neighborhood
Location
- Region: Caldwell
- Subdivision: Waterbrook Farms
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $1,000 annually
Other
Other facts
- Listing terms: Cash,Conventional,VA Loan
- Ownership: Fee Simple,Fractional Ownership: No
- Road surface type: Paved
Price history
Price history is unavailable.
Public tax history
Tax history is unavailable.
Neighborhood: 83607
Nearby schools
GreatSchools rating
- 6/10Purple Sage Elementary SchoolGrades: PK-5Distance: 0.9 mi
- NAMiddleton Middle SchoolGrades: 6-8Distance: 4 mi
- 8/10Middleton High SchoolGrades: 9-12Distance: 2.7 mi
Schools provided by the listing agent
- Elementary: Purple Sage
- 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.