Skip main navigation
Off market
  • $1,486,700

    1086 Sandcherry Rd, Fremont, NE 68025

    4beds
    3,905sqft
    Single Family Residence
    Built in 2025
    -- sqft lot
    $1,486,700 Zestimate®
    $381/sqft
    $4,054 Estimated rent

    Home value

    $1,486,700

    $1.41M - $1.56M

    $4,054/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,054/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,054/mo

    Rent Zestimate®

    Refinance and save

    $7,958/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $7,958/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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.

    This property is not currently displayed as for sale or rent on Zillow. This may be different from what's on other websites or public sources.

    Zillow last checked:

    Source: BHHS broker feed,MLS#: 22528874

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 5
    • Full bathrooms: 3
    • 1/2 bathrooms: 2
    Heating
    • Forced Air, Natural Gas
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Dryer, Microwave, Refrigerator
    Features
    • Cable Ready
    • Has basement: No
    Interior area
    • Total structure area: 3,905
    • Total interior livable area: 3,905 sqft

    Property

    Parking
    • Parking features: GarageAttached
    • Has attached garage: Yes
    Features
    • Patio & porch: Patio
    • On waterfront: Yes
    • Waterfront features: Waterfront
    • Frontage type: Waterfront
    Details
    • Parcel number: 270141792

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Stone
    Condition
    • Year built: 2025

    Community & HOA

    Location
    • Region: Fremont

    Financial & listing details

    • Price per square foot: $381/sqft
    • Date on market: 10/8/2025
    • Lease term: Contact For Details

    Price history

    DateEventPrice
    7/6/2026Listing removed$1,550,000$397/sqft
    Source: GPRMLS #22612928 Report a problem
    5/9/2026Listed for sale$1,550,000$397/sqft
    Source: GPRMLS #22612928 Report a problem
    4/9/2026Listing removed$1,550,000$397/sqft
    Source: GPRMLS #22528874 Report a problem
    10/7/2025Listed for sale$1,550,000$397/sqft
    Source: GPRMLS #22528874 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: 68025

    Nearby schools

    GreatSchools rating
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $1,486,700
    2% more
    +$29,734
    With Zillow Showcase(estimated)
    $1,516,434
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $1,486,700
    2% more
    +$29,734
    With Zillow Showcase(estimated)
    $1,516,434