Lerwick St, Fremont, CA 94539
Property image
Property image
OFF MARKET

Lerwick St
Fremont, CA 94539

Mission San Jose
  • 4 Beds
  • 2 Baths
  • 1,924 sqft

$2,362,900

Trulia Estimate
as of Jul 8, 2026
Est. Refi. Payment $14,351/mo*

$2,362,900

Trulia Estimate
as of Jul 8, 2026
Est. Refi. Payment $14,351/mo*
4 Beds
2 Baths
1,924 sqft

Local Information

  • Map ViewExplore the area around Lerwick St.
  • Schools1 Preschool School1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

Description

HERE'S THE ONE U HAVE BEEN WAITING FOR!! DON'T DELAY!! METICULOUSLY CARED FOR MISSION HOME. RECENTLY PAINTED IN & OUT!!NEWER DRIVEWAY & NEWER GARAGE DOOR, DUAL PANE WINDOWS!! PLUS MORE - A MUST SEE !! COME AND ENJOY THE WARMTH OF THIS LOVELY HOME WITH LOTS OF UPGRADES!!
Lerwick St, Fremont, CA 94539 is a 4 bedroom, 2 bathroom, 1,924 sqft single-family home in Mission San Jose, built in 1964. It last sold for the $797,888 asking price on May 29, 2004. It is currently off market. The Trulia Estimate is $2,362,900, with a rent estimate of $5,427/month.

Home Highlights

Parking
2 Car Garage
Outdoor
No Info
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago

Home Details for Lerwick St

Interior Features

Interior Details
Basement: Crawl SpaceNumber of Rooms: 8Types of Rooms: Bathroom, Kitchen
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 2Number of Bathrooms (full): 2
Dimensions and Layout
Living Area: 1924 Square Feet
Appliances & Utilities
Appliances: Dishwasher, Double Oven, Electric Range, Microwave, Refrigerator, Dryer, WasherDishwasherDryerLaundry: In GarageMicrowaveRefrigeratorWasher
Heating & Cooling
Heating: Forced AirHas CoolingAir Conditioning: Ceiling Fan(s)Has HeatingHeating Fuel: Forced Air
Fireplace & Spa
Number of Fireplaces: 1Fireplace: Brick, Family Room, Raised Hearth, Wood BurningHas a Fireplace
Gas & Electric
Electric: 220 Volts in Kitchen, 220 Volts in LaundryHas Electric on Property
Windows, Doors, Floors & Walls
Window: Skylight(s), Window CoveringsFlooring: Linoleum, Other
Levels, Entrance, & Accessibility
Stories: 1Levels: OneFloors: Linoleum, Other
View
Has a ViewView: Hills

Exterior Features

Exterior Home Features
Roof: OtherFencing: FencedFoundation: RaisedNo Private Pool
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas an Attached GarageParking Spaces: 2Parking: Direct Access,Side Yard Access,Garage Door Opener
Pool
Pool: None
Frontage
Not on Waterfront

Property Information

Year Built
Year Built: 1964
Property Type / Style
Property Type: ResidentialProperty Subtype: Residential, Single Family ResidenceArchitecture: Ranch
Building
Construction Materials: Wood SidingNot a New ConstructionNot Attached PropertyIncludes Home Warranty
Property Information
Condition: ExistingParcel Number: 5135074

Price & Status

Price
List Price: $797,888Price Range: $795,000 - $797,888
Status Change & Dates
Off Market Date: Thu Apr 29 2004Possession Timing: Negotiable

Active Status

MLS Status: Sold

Location

Direction & Address
City: FremontCommunity: Mission
School Information
High School District: Fremont (510) 657-2350

Building

Building Details
Builder Name: KROLL
Building Area
Building Area: 1924 Square Feet

HOA

No HOA

Lot Information

Lot Area: 7992 sqft

Offer

Listing Agreement Type: Excl RightListing Terms: Cash, Conventional

Mobile R/V

Mobile Home Park
Mobile Home Units: Feet

Miscellaneous

Mls Number: 40006989Attribution Contact: 510-501-1916Above Grade Unfinished Area Units: Square FeetBelow Grade Unfinished Area Units: Square Feet
Last check for updates: about 4 hours ago
Listed by Ann Gupta DRE #01237171, (510) 501-1916
Realty Experts
Bought with: (R) JOSEPH TIEDJE, (925) 922-0239, (R) KELLER WILLIAMS
Source: Bay East AOR, MLS#40006989

Price History for Lerwick St

DatePriceEventSource
05/29/2004$795,000Sold
Bay East AOR #40006989

Market trends in Fremont

Last updated May 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$1.44M
$111K
MoM
Sale-to-List Price
102.2%
1.2%
MoM
Price per sq ft
$899
$18
MoM
Available listings
406
8
MoM
Skip to last item
  • Results are loading
Skip to first item

Comparable Sales for Lerwick St

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
0.07
Single-Family Home
$2,330,000
08/19/25
4
2
1,924
0.20
Single-Family Home
$2,250,000
03/13/26
4
2
1,848
0.09
Single-Family Home
$2,400,000
09/05/25
3
2
1,690
0.08
Single-Family Home
$2,740,000
04/16/26
4
3
2,028
0.16
Single-Family Home
$2,300,000
04/17/26
3
2
1,682
0.11
Single-Family Home
$2,640,051
05/14/26
3
2
1,699
0.24
Single-Family Home
$1,820,000
03/30/26
3
2
1,447
0.39
Single-Family Home
$1,875,000
04/28/26
4
2
1,860
0.14
Single-Family Home
$2,230,000
08/08/25
5
3
1,983
0.50
Single-Family Home
$1,998,000
06/22/26
4
2
1,601

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for Lerwick St.
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

Neighborhood Overview

Neighborhood stats provided by third party data sources.

What Locals Say about Mission San Jose

At least 27 Trulia users voted on each feature.
  • 93 % Say car is needed

  • 90 % Say it's dog friendly

  • 88 % Say there are sidewalks

  • 87 % Say parking is easy

  • 67 % Say it's walkable to restaurants

  • 67 % Say people would walk alone at night

  • 63 % Say it's quiet

  • 61 % Say there's holiday spirit

  • 58 % Say streets are well-lit

  • 54 % Say they plan to stay for at least 5 years

  • 50 % Say yards are well-kept

  • 45 % Say kids play outside

  • 45 % Say neighbors are friendly

  • 42 % Say there's wildlife

  • 27 % Say it's walkable to grocery stores

  • 23 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • Trulia User
    "Lots of dogs and friendly owners in the area. Plenty of space to walk and get activity in for you and your pup! "
  • Trulia User
    "Marriage ceremonies, olive festival college festivals , cooperative environment , canteen, cafeteria, beauty parlors "
  • Hui
    "I live here. All my kids love this area!! Safe and well maintained street! You don’t need to worry about anything. Neighbors are very friendly"
  • Sharlene X. R.
    "Admire the history and attracted to clean atmosphere. The feel of the openness and lovely scenic drive thru town is very nice to see."
  • M V.
    "palm 🌴 good food options farmers market coffee shops running and hiking trails bike trails freeway access"
  • Vinsahni55
    "Neighbor hood app and a cul de sac pot luck and mission schools lake Elizabeth and various festivals in Fremont"
  • AP
    "Mission is best known for views and schools. Good place to live with family."
  • AP
    "Best schools, very clean, peaceful, central and connected to all of Bay Area.."
  • Srivatsand
    "This is a part of a huge community of newly built homes. Excellent school district. Ideal for family with kids"
  • HomeVideoTour
    "Living in Fremont for over 40 years means knowing the good and the bad of Fremont. Mission San Jose Area is one of those places where everyone feels the best that Fremont has to offer. Convenient shopping, Top Schools in California, Clean Communities, Convenient Transportation if needed, Close enough to major highway access, and just close enough drive to Silicon Valley or SF without paying the high Real Estate prices. Mission San Jose area of Fremont is a gem."

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Explore by feature - Pet Friendly

Explore by feature - Garage

Explore by feature - Air Conditioning

Explore by feature - Pool

Explore by feature - Washer/dryer

Explore by feature - Outdoor Space

Homes for sale near Lerwick St

Skip to last item
Skip to first item

Off Market Homes Near Lerwick St

Skip to last item
Skip to first item
Bay East© 2026, CCAR© 2026, bridgeMLS© 2026. Information Deemed Reliable but not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used or any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated at 2026-07-07 23:38:18 PDT.