MODEL HOME - 2023 Street of Dreams winner. Built by Art of a Craftsman, this stunning Hills Farm lake house blends modern living with hints of rustic character. The 1.5-story design showcases clean lines, soaring 20-foot ceilings, and an abundance of natural light. Inside, you'll find 4 spacious bedrooms, 5 stylish bathrooms, and 2 offices. Primary suite offers a luxurious wet-room spa escape connected to a custom closet with a secondary laundry. Modern glass railing accents the loft living area, while the oversized 3-car garage provides generous space. Entertain in style at the speakeasy-inspired bar, where moody lighting and upscale finishes create an unforgettable atmosphere. Double doors open to a resort-like outdoor setting featuring an outdoor kitchen and covered living & dining areas. A perfect blend of luxury, comfort, and character, this home is a true showcase of timeless design and modern living. Photos are of similar home.
New construction
$1,550,000
1086 Sandcherry Rd, Fremont, NE 68025
4beds
3,905sqft
Est.:
Single Family Residence
Built in 2025
0.65 Acres Lot
$1,513,700 Zestimate®
$397/sqft
$42/mo HOA
What's special
Luxurious wet-room spa escapeModern glass railingSpeakeasy-inspired barOutdoor kitchenCustom closetAbundance of natural light
- 95 days |
- 540 |
- 18 |
Zillow last checked: 8 hours ago
Listing updated: October 11, 2025 at 11:04pm
Listed by:
Rusty Johnson 402-738-0131,
BHHS Ambassador Real Estate,
Drew Halvorson 402-639-0775,
BHHS Ambassador Real Estate
Source: GPRMLS,MLS#: 22528874
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 3
- 1/2 bathrooms: 2
- Main level bathrooms: 3
Primary bedroom
- Level: Main
- Area: 270
- Dimensions: 18 x 15
Bedroom 2
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 3
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 4
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Primary bathroom
- Features: Full, Shower, Double Sinks
Kitchen
- Level: Main
- Area: 240
- Dimensions: 20 x 12
Office
- Level: Main
- Area: 99
- Dimensions: 11 x 9
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Range, Oven, Refrigerator, Dishwasher, Dryer, Disposal, Microwave
Features
- Wet Bar, High Ceilings, Two Story Entry, 2nd Kitchen, Ceiling Fan(s), Jack and Jill Bath, Pantry, Zero Step Entry
- Has basement: No
- Number of fireplaces: 1
Interior area
- Total structure area: 3,905
- Total interior livable area: 3,905 sqft
- Finished area above ground: 3,905
- Finished area below ground: 0
Property
Parking
- Total spaces: 3
- Parking features: Tandem, Attached, Garage Door Opener
- Attached garage spaces: 3
Features
- Levels: One and One Half
- Patio & porch: Porch, Patio, Covered Patio
- Exterior features: Sprinkler System, Lighting, Lake Use, Separate Entrance
- Fencing: None
- On waterfront: Yes
- Waterfront features: Lake Front
Lot
- Size: 0.65 Acres
- Dimensions: 146.32 x 210.0 96.64 x 210.0
- Features: Over 1/2 up to 1 Acre, City Lot, Subdivided, Wooded, Paved, Common Area
Details
- Parcel number: 270141792
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Stone, Masonite, Other
- Foundation: Concrete Perimeter
- Roof: Composition
Condition
- Under Construction
- New construction: Yes
- Year built: 2025
Details
- Builder name: Art of a Craftsman
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available
Community & HOA
Community
- Subdivision: Hill Farm Lake
HOA
- Has HOA: Yes
- HOA fee: $500 annually
- HOA name: Hill Farm HOA
Location
- Region: Fremont
Financial & listing details
- Price per square foot: $397/sqft
- Date on market: 10/7/2025
- Listing terms: Conventional,Cash
- Ownership: Fee Simple
- Road surface type: Paved
Estimated market value
$1,513,700
$1.44M - $1.59M
$3,916/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 10/7/2025 | Listed for sale | $1,550,000$397/sqft |
Source:  GPRMLS #22528874 Report a problem | ||
Public tax history
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Est. payment
$8,378/mo
Principal & interest
$6010
Property taxes
$1783
Other costs
$585
Climate risks
Neighborhood: 68025
Nearby schools
GreatSchools rating
- 2/10Washington Elementary SchoolGrades: PK-4Distance: 1.4 mi
- 4/10Fremont Middle SchoolGrades: 7-8Distance: 2.5 mi
- 1/10Fremont Senior High SchoolGrades: 9-12Distance: 2.6 mi
Schools provided by the listing agent
- Elementary: Washington
- Middle: Fremont
- High: Fremont
- District: Fremont
Source: GPRMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
- Loading
