Luxury lakefront living awaits in this exceptional custom-built story-and-a-half by 402 Customs on Hills Farm Lake in Fremont. Designed to capture stunning water views, the open-concept floor plan features a spacious great room, dining area, and chef's kitchen with Wolf and Sub-Zero appliances, oversized island, and an expansive butler's pantry. A private main-floor office offers the perfect work-from-home space, while the luxurious primary suite showcases panoramic lake views, a spa-inspired bath with a stunning wet room, and an oversized walk-in closet. Upstairs you'll find four additional bedrooms and a versatile loft complete with a fireplace and wet bar, creating the perfect space for entertaining or relaxing. The oversized five-car split tandem garage includes a rear overhead door for convenient access to the lake and all your water toys. An extraordinary blend of luxury, thoughtful design, and premier waterfront living.
New construction
$1,385,000
2463 E Juneberry Rd, Fremont, NE 68025
5beds
3,961sqft
Single Family Residence
Built in 2026
0.58 Acres Lot
$1,354,900 Zestimate®
$350/sqft
$83/mo HOA
What's special
- 77 days
- 250
- 5
Zillow last checked:
Listing updated:
Listed by:
Brandon Fowler 402-440-6696,
Nebraska Realty,
Barry Fowler 402-430-8915,
Nebraska Realty
Source: GPRMLS,MLS#: 22618337
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 2
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
- Main level bathrooms: 2
Primary bedroom
- Level: Main
- Area: 238
- Dimensions: 14 x 17
Bedroom 2
- Level: Second
- Area: 168
- Dimensions: 12 x 14
Bedroom 3
- Level: Second
- Area: 168
- Dimensions: 12 x 14
Bedroom 4
- Level: Second
- Area: 168
- Dimensions: 14 x 12
Bedroom 5
- Level: Second
- Area: 210
- Dimensions: 14 x 15
Primary bathroom
- Features: Full, 3/4, Double Sinks
Family room
- Level: Second
- Area: 323
- Dimensions: 17 x 19
Kitchen
- Level: Main
- Area: 256
- Dimensions: 16 x 16
Living room
- Level: Main
- Area: 456
- Dimensions: 24 x 19
Office
- Level: Main
- Area: 154
- Dimensions: 11 x 14
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Humidifier, Refrigerator, Freezer, Dishwasher, Disposal, Microwave, Double Oven, Cooktop
Features
- Wet Bar, High Ceilings, Two Story Entry, Ceiling Fan(s), Drain Tile
- Flooring: Carpet, Luxury Vinyl, Plank
- Basement: Other
- Number of fireplaces: 2
- Fireplace features: Direct-Vent Gas Fire, Electric
Interior area
- Total structure area: 3,961
- Total interior livable area: 3,961 sqft
- Finished area above ground: 3,961
- Finished area below ground: 0
Property
Parking
- Total spaces: 5
- Parking features: Attached, Garage Door Opener
- Attached garage spaces: 5
Features
- Levels: One and One Half
- Patio & porch: Porch, Patio, Covered Patio
- Exterior features: Sprinkler System, Lake Use, Recreational, Separate Entrance
- Fencing: None
- On waterfront: Yes
- Waterfront features: Lake Front
Lot
- Size: 0.58 Acres
- Dimensions: 120 x 212
- Features: Over 1/2 up to 1 Acre, City Lot, Subdivided, Level, Paved, Common Area, Secluded, Private Roadway
Details
- Parcel number: 270141854
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Stone, Cement Siding
- Foundation: Slab
- Roof: Composition
Condition
- Under Construction
- New construction: Yes
- Year built: 2026
Details
- Builder name: 402 Customs
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Electricity Available, Natural Gas Available, Water Available, Sewer Available, Storm Sewer, Phone Available, Fiber Optic
Community & HOA
Community
- Subdivision: Hills Farm Lake
HOA
- Has HOA: Yes
- Amenities included: Hiking
- Services included: Lake, Common Area Maintenance
- HOA fee: $1,000 annually
- HOA name: Hills Farm Lake
Location
- Region: Fremont
Financial & listing details
- Price per square foot: $350/sqft
- Annual tax amount: $3,455
- Date on market: 6/29/2026
- Listing terms: VA Loan,Conventional,Cash
- Ownership: Fee Simple
- Electric utility on property: Yes
- Road surface type: Paved
Estimated market value
$1,354,900
$1.29M - $1.42M
$3,964/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/29/2026 | Listed for sale | $1,385,000+515.6%$350/sqft |
Source:  GPRMLS #22618337 Report a problem | ||
| 6/29/2026 | Listing removed | $225,000$57/sqft |
Source: GPRMLS #22610311 Report a problem | ||
| 4/17/2026 | Listed for sale | $225,000$57/sqft |
Source: GPRMLS #22610311 Report a problem | ||
| 1/1/2026 | Listing removed | $225,000$57/sqft |
Source: GPRMLS #22516477 Report a problem | ||
| 6/16/2025 | Listed for sale | $225,000$57/sqft |
Source: GPRMLS #22516477 Report a problem | ||
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: 68025
Nearby schools
Schools provided by the listing agent
- Elementary: Howard
- 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.
Similar homes
- $1,550,0004 bd5 ba3.9k sqft1086 E Sandcherry Rd, Fremont, NE 68025New Construction
MLS ID #22621012, Bryce Penke, BHHS Ambassador Real Estate. GPRMLS - $1,400,0003 bd4 ba4k sqftS 1198 N Lake Shore Dr, Fremont, NE 68025For Sale
MLS ID #22620459, Kori Krause, NP Dodge RE Sales Inc 148Dodge. GPRMLS - $1,832,0004 bd4 ba3.3k sqft2389 Juneberry Rd, Fremont, NE 68025New Construction
MLS ID #22605633, Karen Jennings, BHHS Ambassador Real Estate. GPRMLS - $995,0004 bd3 ba2.1k sqftS 1095 Maple Ln, Fremont, NE 68025For Sale
MLS ID #22614886, Karen Jennings, BHHS Ambassador Real Estate. GPRMLS - $1,100,0004 bd4 ba4.4k sqft17227 Cattle Gate Ln, Kennard, NE 68034For SaleMLS ID #22626484, Nancy Heim-Berg, BHHS Ambassador Real Estate. GPRMLS
- $1,339,9005 bd4 ba4.4k sqft3538 S 210th Ave, Elkhorn, NE 68022New ConstructionMLS ID #22626517, Johnathan O'Gorman, Better Homes and Gardens R.E.. GPRMLS
- $779,0007 bd4 ba2.9k sqftS1063 Timber Ln, Fremont, NE 68025For SaleMLS ID #22614189, Kori Krause, NP Dodge RE Sales Inc 148Dodge. GPRMLS
- $795,0003 bd3 ba3.9k sqft4201 N Somers Ave #B, Fremont, NE 68025For SaleMLS ID #22620531, Darin Whitmer, Dodge County Realty Group. GPRMLS
- $1,199,5004 bd4 ba3.4k sqft5512 N 284th Cir, Valley, NE 68064For SaleMLS ID #22625125, Ken Bartholomew, BHHS Ambassador Real Estate. GPRMLS
- $1,400,0005 bd4 ba4.7k sqft3644 S 217th St, Elkhorn, NE 68022New ConstructionMLS ID #22626210, Eric Carraher, Meraki Realty Group. GPRMLS
- $1,400,0006 bd4 ba5k sqft3513 S 221st St, Elkhorn, NE 68022New ConstructionMLS ID #22626212, Eric Carraher, Meraki Realty Group. GPRMLS
- $1,400,0004 bd5 ba4k sqft3637 S 219th St, Elkhorn, NE 68022New ConstructionMLS ID #22625513, Byron Thompson, Meraki Realty Group. GPRMLS
- $1,075,0004 bd5 ba3.2k sqft28488 Laurel Cir, Valley, NE 68064For SaleMLS ID #22626354, Billy Arthur, BHHS Ambassador Real Estate. GPRMLS
- $1,300,0004 bd5 ba5.1k sqft22106 Quail Cir, Elkhorn, NE 68022For SaleMLS ID #22617018, Tony Terp, Milford Real Estate. GPRMLS
- $1,290,0004 bd4 ba4.3k sqft21068 Valley Cir, Elkhorn, NE 68022For SaleMLS ID #22624225, Jenn Haeg, Better Homes and Gardens R.E.. GPRMLS
- $1,599,0005 bd5 ba4.7k sqft22220 Sanctuary Ridge Dr, Elkhorn, NE 68022New ConstructionMLS ID #22626324, Shelli Klemke, BHHS Ambassador Real Estate. GPRMLS
- $1,250,0006 bd5 ba5.8k sqft910 S 220th St, Elkhorn, NE 68022For SaleMLS ID #22624228, Sarah Lynch, Better Homes and Gardens R.E.. GPRMLS
- $1,245,0004 bd4 ba4.3k sqft23423 Nancy Cir, Elkhorn, NE 68022For SaleMLS ID #22620983, Jason Kroll, Better Homes and Gardens R.E.. GPRMLS
- $850,0005 bd4 ba3.6k sqft3965 George B Lake Pkwy, Elkhorn, NE 68022For SaleMLS ID #22626357, Katie Major, BHHS Ambassador Real Estate. GPRMLS
- $1,299,0005 bd5 ba5.7k sqft17808 S Reflection Ave, Bennington, NE 68007For SaleMLS ID #22611212, Jennifer Vacek, Better Homes and Gardens R.E.. GPRMLS
