---
listing_id: BE41142577
status: Active
price: 2188000
beds: 4
baths_full: 2
baths_half: 1
sqft_living: 2163
sqft_lot: 7663
lot_acres: 
year_built: 1979
property_type: Residential
property_subtype: Single Family Residence
address: "866 Hidatsa Ct"
city: Fremont
state: CA
zip: 94539
county: "Alameda County"
lat: 37.5035359
lng: -121.9264653
days_on_market: 5
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Scott Piper"
list_office: "EXP Realty of California, Inc"
list_agent_phone: "(925) 989-1300"
list_agent_license: 01151725
mls_source: MAXEBRDI
modified: 2026-07-27
transaction_type: buy
---

Home | Alameda County | Fremont | 94539 | 866 Hidatsa Ct

866 Hidatsa Ct, Fremont, CA 94539

MLS: BE41142577 | Status: Active | Price: $2,188,000
Beds/Baths: 4 / 2 /1
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
4 2 /1 2,163 7,663 1979

Remarks

OPEN HOUSE: SAT & SUN 2-4 **Tucked at the end of a quiet court in the Weibel school district, this north-facing 4-bedroom, 2.5-bath home offers 2,163 square feet in crisp white canvas on a 7,600 sq ft lot. Vaulted ceilings anchor the formal living and dining rooms, and new luxury vinyl plank flooring, recessed lighting, and fresh paint carry through the home ready for its next chapter. The kitchen, finished in quartz with a stainless sink and new appliances, opens directly to the family room and rear yard. A standout sunroom, tiled floor, ceiling fans, and brick patio, extends the living space outdoors and offers a rare bonus room that is not included in the square footage. Every bathroom has been updated with quartz vanities and clean, current finishes. The lot is unlandscaped front and back, a true opportunity for a buyer to design outdoor space on their own terms. Minutes to Warm Springs BART, Mission Peak trails, 680/880, and Fremont's major employers, with Weibel Elementary an easy walk away. Live Well!

MLS Listing Information

Field Value
MLS # BE41142577
MLS Source Bay East
Days on Site 5

Features

Interior Features

Feature Details
Bathrooms Primary - Shower(s) over Tub(s), Primary - Solid Surface, Tile, Updated Bath(s)
Kitchen Breakfast Bar, Countertop - Stone, Hookups - Ice Maker
Appliances Cooktop - Electric, Dishwasher, Garbage Disposal, Microwave, Oven Range
Dining Room Formal Dining Room
Fireplace Brick, Family Room
Flooring Carpet - Wall to Wall, Laminate, Stone
Laundry 220 Volt Outlet, Hookups Only, In Laundry Room
Cooling Ceiling Fan, Central -1 Zone
Heating Forced Air

Exterior Features

Feature Details
Roof Metal
Pool None, Pool - No
Style Traditional

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Garage, Garage: 2 Car(s)

Contact Information

Scott Piper
EXP Realty of California, Inc
License #: 01151725
Phone: (925) 989-1300

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Fred E. Weibel Elementary School public K-5 0.18 mi 10
Lila Bringhurst Elementary public TK,KG,1,2,3,4,5,6 1.07 mi 10
James Leitch Elementary School public TK,KG,1,2 1.12 mi N/A
Warm Springs Elementary School public 3,4,5 1.46 mi 10
Mission San Jose Elementary School public TK,KG,1,2,3,4,5 1.71 mi 10
E. M. Grimmer Elementary School public TK,KG,1,2,3,4,5 1.77 mi 6
Harvey Green Elementary School public TK,KG,1,2,3,4,5 2.12 mi 9
Robertson High (Continuation) School public 9-12 2.39 mi 3
Vista Alternative School public 7-12 2.39 mi 10
Mission Valley Elementary School public K-5 2.51 mi 9
Irvington High School public 9-12 2.63 mi 10
O. N. Hirsch Elementary School public K-5 2.73 mi 9
John M. Horner Middle School public 6-8 2.80 mi 9
Mission San Jose High School public 9-12 2.84 mi 10
Steven Millard Elementary School public TK,KG,1,2,3,4,5 2.87 mi 8
Joshua Chadbourne Elementary School public TK,KG,1,2,3,4,5 2.87 mi 10
William Hopkins Middle School public 6-8 3.11 mi 9
John Blacow Elementary School public TK,KG,1,2,3,4,5 3.15 mi 7
Joseph Weller Elementary School public K-6 3.31 mi 8
John Gomes Elementary School public TK,KG,1,2,3,4,5 3.47 mi 9

Nearby Homes

Address Price Beds Baths Sq Ft Status
47108 Yucatan Dr $2,188,000 4 2/1 1,784 Active
801 Lippert Ave $1,799,000 4 2 1,544 Active
571 Bernal Cmn $2,180,000 3 2/1 1,685 Active
43163 Starr St $1,836,000 3 1 951 Active

Disclosures

©2026 Bay East. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from Bay East.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of July 27, 2026. For the most current information, please contact Scott Piper, (925) 989-1300.