Discover what it feels like to live in a true luxury lakefront retreat with this breathtaking model home by award-winning builder Art of a Craftsman, known for crafting custom homes with unmatched precision and personal detail. Located in the exclusive Hills Farm Lake in Fremont, our signature 1.5-story "Roatan" design showcases an elevated lifestyle you could build for yourself. One-of-a-kind character shines through soaring ceilings, custom beams, designer fireplaces, a dramatic loft overlooking the open living spaces, and a grand entry filled with natural light. High-end finishes include engineered hardwood floors, a hidden butler’s pantry, quartz countertops, and a spa-inspired zero-entry shower. Designed for entertaining, enjoy the huge covered patio, outdoor kitchen, along with ATV Trails, and lake access for boating, jet skis, fishing, and sunset cruises. This is more than a home—it’s a luxury lifestyle built entirely around you. Call now for available lots and building info!
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
$-- Zestimate®
$397/sqft
$42/mo HOA
What's special
Huge covered patioSpa-inspired zero-entry showerOutdoor kitchenCustom beamsSoaring ceilingsDesigner fireplacesQuartz countertops
- 16 hours |
- 100 |
- 7 |
Zillow last checked:
Listing updated:
Listed by:
Byron Thompson 402-890-8995,
Meraki Realty Group,
Eric Carraher 402-312-3301,
Meraki Realty Group
Source: GPRMLS,MLS#: 22612928
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: Main
- Area: 270
- Dimensions: 18 x 15
Bedroom 3
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 4
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 5
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Primary bathroom
- Features: Full, Shower, Double Sinks
Great room
- Level: Main
Kitchen
- Level: Main
- Area: 240
- Dimensions: 20 x 12
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Range, Oven, Refrigerator, Dishwasher, Disposal, Microwave
Features
- 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: Attached
- 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
Lot
- Size: 0.65 Acres
- Dimensions: 146.32 x 210 x 96.64 x 210
- Features: Over 1/2 up to 1 Acre
Details
- Parcel number: 270141792
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Stone, Masonite, Other
- Foundation: Concrete Perimeter
Condition
- Under Construction
- New construction: Yes
- Year built: 2025
Details
- Builder name: Art Of A Craftsman
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: HILL FARM ROAD
HOA
- Has HOA: Yes
- HOA fee: $500 annually
Location
- Region: Fremont
Financial & listing details
- Price per square foot: $397/sqft
- Date on market: 5/9/2026
- Listing terms: VA Loan,FHA,Conventional,Cash
- Ownership: Fee Simple
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/9/2026 | Listed for sale | $1,550,000$397/sqft |
Source:  GPRMLS #22612928 Report a problem | ||
| 4/9/2026 | Listing removed | $1,550,000$397/sqft |
Source: GPRMLS #22528874 Report a problem | ||
| 10/7/2025 | Listed for sale | $1,550,000$397/sqft |
Source: GPRMLS #22528874 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment
$9,818/mo
Principal & interest
$7993
Property taxes
$1783
HOA Fees
$42
More affordability tools
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.
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.
- Nebraska
- Dodge County
- Fremont
- 68025
- 1086 Sandcherry Rd
Nearby cities
Nearby zip codes
Other Fremont Topics
