New construction

$1,385,000

2463 E Juneberry Rd, Fremont, NE 68025

5beds

3,961sqft

$8,922/mo

Get pre-qualified

Single Family Residence

Built in 2026

0.58 Acres Lot

$1,364,200 Zestimate^®

$350/sqft

$83/mo HOA

What's special

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.

28 days

519

10

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,364,200

$1.30M - $1.43M

$3,788/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.

Principal & interest
$1,547
Mortgage insurance
$0
Property taxes
$170
Home insurance
$105
HOA fees
$0
Utilities
Not included

All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.

HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.

Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.

See how much you could borrow to make a competitive offer.

Get pre-qualified