• Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • Blog
Phone714-745-2708
Login or sign up for new accountLogin / Register
Email Our TeamEmail Us
  • Search Listings
    • Residential
    • Lease
    • Commercial
  • Previous Sales
  •   Local
    • Fullerton
    • Tustin
    • Yorba Linda
    • Santa Ana
    • Orange Park Acres
    • North Tustin
    • Orange
    • Anaheim
  •   Buyers
    • Ways To Take Title In California
    • Vesting
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  •     Sellers
    • New Sellers Guide
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  •     Services
    • Onepoint
    • Home Financing
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PRESALE/STAGING
    • Relocation
  •     About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only
  • Our Team
  • Blog
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
  • Home
  • 38555 Overacker Ave #0

38555 Overacker Ave #0, Fremont, CA 94536

$15,000,000 Approx. USD 0 beds, 0 baths
Save My Notes
Share
  • Copy Link
  • Facebook
  • Twitter
  • Pinterest
Source MLS Verified
MORE INFO
BrochureBrochure
The Keaty Team

View Team Members

Photo of Kevin Keaty

The Keaty Team REALTOR® - Sales Associate 714-608-3298 m
714-745-2708 o
Lic#: 01276603
NRDS ID: 187514104
thekeatyteam@bhhscal.com Text Me
Call My Cell
Call My Office
Lic#: 01276603
NRDS ID: 187514104
thekeatyteam@bhhscal.com Tustin Office
18302 Irvine Blvd, Suite 240
Tustin, CA 92780
Phone: 714-832-8800
Fax: 949-565-7700
 Tustin 18302 Irvine Blvd, Suite 240
Tustin, CA 92780
Call Branch Office
Fax: 949-565-7700
Mortgage Calculator
GET PRE-APPROVED
Interested in This Property? Your message will be sent to Kevin.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Listing Agent


Dan Picker
Lic#: 02218565
Broker: Courtesy of Show & Sell
Phone: 619-987-4932

Agent Remarks

2+ acre residential zoned lot in the heart of Fremont contains a 2800 sqft historical home, work and storage sheds, and mature trees. Fremont Unified School District: Vallejo Mills Elementary, Centerville Middle School, Washington High School

Listing Details

Property type: Lots/Land (Lots/Land)
Status: ACTIVE
MLS# 240009570
Price: $15,000,000
Beds: 0
Baths: 0
2.04 acres
Subdivision: OUT OF AREA
County: Alameda
Zoning: R-1-6

Last Updated: 4/23/2026

 Days On Market (DOM): 785

 Find more Fremont homes and real estate

 Find more homes in 94536 zip code

 Find more homes in the OUT OF AREA subdivision

Lat/Long: 37.569583, -121.968179.
Find nearby listings

DISCLAIMER: There is NO WARRANTY, expressed or implied, for the accuracy of this information or its applicability to your financial situation. Please consult your financial and/or tax advisor. GET PRE-APPROVED The loan's interest rate will depend upon the specific characteristics of the loan transaction and credit profile up to the time of closing.

94536 Area Map

Demographics

Schools

CLICK TO VIEW MAP

Similar Listings

Next Listing
859 London Drive VIRTUAL TOUR
859 London Drive ,
$12,800,000 Approx. USD

List Date: 10/5/2022
 Status: Pending
 MLS #: ML81909525

My Notes Save
Listing courtesy of
148 Tuscaloosa Avenue VIRTUAL TOUR
148 Tuscaloosa Avenue ,
$13,500,000 Approx. USD

List Date: 3/24/2022
 Status: Pending
 MLS #: ML81883623

My Notes Save
Listing courtesy of
5660 Alpine Road VIRTUAL TOUR
5660 Alpine Road ,
$15,500,000 Approx. USD

List Date: 8/17/2020
 Status: Active
 MLS #: ML81803731

My Notes Save
Listing courtesy of
0 Twin Oaks Drive VIRTUAL TOUR
0 Twin Oaks Drive ,
$16,000,000 Approx. USD

List Date: 7/31/2023
 Status: Active Under Contract
 MLS #: ML81936703

My Notes Save
Listing courtesy of
18570 Black Road VIRTUAL TOUR
18570 Black Road ,
$14,200,000 Approx. USD

List Date: 9/29/2025
 Status: Active
 MLS #: ML82023193

My Notes Save
Listing courtesy of
1181 Etheldore Street VIRTUAL TOUR
1181 Etheldore Street ,
$15,000,000 Approx. USD

List Date: 1/30/2025
 Status: Active
 MLS #: ML81992261

My Notes Save
Listing courtesy of
1289 Thompson Avenue VIRTUAL TOUR
1289 Thompson Avenue ,
$16,000,000 Approx. USD

List Date: 1/12/2026
 Status: Active
 MLS #: ML82030952

My Notes Save
Listing courtesy of
42100 El Camino Real VIRTUAL TOUR
42100 El Camino Real ,
$14,107,500 Approx. USD

List Date: 1/16/2026
 Status: Active
 MLS #: NS26011411

My Notes Save
Listing courtesy of
2401 S Highway 1 VIRTUAL TOUR
2401 S Highway 1 ,
$17,200,000 Approx. USD

List Date: 7/1/2025
 Status: Active
 MLS #: C1-11066

My Notes Save
Listing courtesy of
1800 Atascadero Road VIRTUAL TOUR
1800 Atascadero Road ,
$15,500,000 Approx. USD

List Date: 3/20/2025
 Status: Active
 MLS #: NS25061446

My Notes Save
Listing courtesy of
Previous Listing
  • Search
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
    • Commercial
    • New Homes
    • Luxury
  • Buyers
    • Ways To Take Title In California
    • Vesting
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  • Sellers
    • New Sellers Guide
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only
  • Blog
  • Our Team
The Keaty Team
Lic#: 01276603

View Team Members


Tustin Office
18302 Irvine Blvd, Suite 240
Tustin, CA 92780
hsoa-logo
  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • Blog

© 2026 BHH Affiliates, LLC. An independently operated subsidiary of HomeServices of America, Inc., a Berkshire Hathaway affiliate, and a franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status