$1,999,888
$300K PRICE DROP

Estimated payment $10,948/month

Total Views 8,194
6 Beds
5 Baths
2,440 Sq Ft
$820 Price per Sq Ft

Highlights

  • Updated Kitchen
  • Engineered Wood Flooring
  • Double Oven
  • Niles Elementary School Rated A
  • No HOA
  • 3 Car Detached Garage

About This Home

Motivated seller! Price reduced $300k! Nestled in the heart of Fremont’s historical Niles District where the golden era of silent films began! Don't miss your opportunity to own a one-of-a-kind triplex property! THREE complete gut remodeled HOMES on one lot. Each home has its own address, PG&E meter, garage & laundry and shows like brand new! Whether you're looking for investment, multi-generational living, or rental income to offset your mortgage, this property offers flexibility, location & historical charm in equal measure! Each home has been beautifully renovated with the main home gorgeously showcasing Niles antique design! YOU MUST SEE to appreciate: photos do not capture the quality craftsmanship and stunning design! Located just steps away from Niles Elementary School and the bustling "Main Street" with weekly Farmer's Market, restaurants, antique shops & ongoing festivities. Enjoy breathtaking views as you stroll the Niles Community Park with tennis courts, playground, paved pathways, and breathtaking Fall colors - just a few minutes walk away! Act fast! THREE stunning homes priced for the cost of two with perfect location in downtown Niles District. Bring your extended family! This won’t last!

Listing Agent

nadine camara

Realty Experts Brokerage Phone: 510-673-4299 License #00924223 Listed on: 09/13/2025

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1915

Lot Details

  • 7,409 Sq Ft Lot

Parking

  • 3 Car Detached Garage

Home Design

  • Bungalow
  • Composition Shingle Roof
  • Wood Siding
  • Stucco

Interior Spaces

  • 1-Story Property
  • Skylights
  • Washer and Dryer Hookup

Kitchen

  • Updated Kitchen
  • Double Oven
  • Gas Range
  • Free-Standing Range
  • Microwave
  • Plumbed For Ice Maker
  • Dishwasher

Flooring

  • Engineered Wood
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms

Utilities

  • Central Heating and Cooling System
  • Gas Water Heater

Community Details

  • No Home Owners Association
  • Niles Subdivision

Listing and Financial Details

  • Assessor Parcel Number 50725016

Home Details

Home Type

Single Family

Year Built

Built in 1915

Lot Details

0

Parking

3

Listing Details

  • Stories: 1
  • Year Built: 1915
  • Property Sub Type: Detached
  • Prop. Type: Residential
  • Subdivision Name: Niles
  • Directions: Near intersection of: F Street & 2nd Street
  • Architectural Style: Bungalow
  • Garage Yn: Yes
  • Unit Levels: One Story
  • New Construction: No
  • Skirt: Brick Veneer Skirt
  • remarks11: * Triplex property: 3 homes one lot - all homes are vacant - go direct to show. * Please LEAVE ALL LIGHTS ON after showing. Thank you! * Seller is Listing Agent: Real Estate Broker, DRE Lic # 00924223 * All units are complete gut remodel and ready to move in, prestine condition- see brochure (located at 37230 2nd St property) for remodel & upgrade details including full interior gut remodels with luxury materials, roofing, electrical, insulation, sewer, water main, dual pane windows, sky lights, landscaping, etc. * Seller requests 2 week rent back after close of escrow. * BUYER TO OBTAIN THEIR OWN SQUARE FOOT MEASUREMENTS, Seller does not guarantee square footage. * Photos of 37238 2nd St (side unit) are not current: from previous staging * Disclosures IO link to be added soon with disclosures & reports * This is DUPLICATE LISTING with MLS #41111550 on Residential Income MLS
  • remarks22: Nadine Camara - 510-673-4299 - Motivated seller! Price reduced $300k! Nestled in the heart of Fremont’s historical Niles District where the golden era of silent films began! Don't miss your opportunity to own a one-of-a-kind triplex property! THREE complete gut remodeled HOMES on one lot. Each home has its own address, PG&E meter, garage & laundry and shows like brand new! Whether you're looking for investment, multi-generational living, or rental income to offset your mortgage, this property offers flexibility, location & historical charm in equal measure! Each home has been beautifully renovated with the main home gorgeously showcasing Niles antique design! YOU MUST SEE to appreciate: photos do not capture the quality craftsmanship and stunning design! Located just steps away from Niles Elementary School and the bustling "Main Street" with weekly Farmer's Market, restaurants, antique shops & ongoing festivities. Enjoy breathtaking views as you stroll the Niles Community Park with tennis courts, playground, paved pathways, and breathtaking Fall colors - just a few minutes walk away! Act fast! THREE stunning homes priced for the cost of two with perfect location in downtown Niles District. Bring your extended family! This won’t last!
  • Attribution Contact: 510-673-4299
  • Special Features: None

Interior Features

  • Flooring: Tile, Other, Engineered Wood
  • Appliances: Dishwasher, Double Oven, Gas Range, Plumbed For Ice Maker, Microwave, Free-Standing Range, Refrigerator, Gas Water Heater
  • Full Bathrooms: 3
  • Total Bedrooms: 6
  • Fireplace Features: None
  • Fireplace: No
  • Window Features: Skylight(s), Window Coverings
  • Room Kitchen Features: Stone Counters, Dishwasher, Double Oven, Eat-in Kitchen, Disposal, Gas Range/Cooktop, Ice Maker Hookup, Microwave, Range/Oven Free Standing, Refrigerator, Skylight(s), Updated Kitchen

Exterior Features

  • Roof: Composition Shingles, Other
  • Lot Features: Level, Landscaped
  • Pool Features: None
  • Pool Private: No
  • Construction Type: Stucco, Wood Siding
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Detached

Utilities

  • Heating: Other, Central
  • Cooling: Central Air, Other
  • Laundry Features: Hookups Only, Other
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: No Solar
  • Water Source: Public

Condo/Co-op/Association

  • Association: No

Schools

  • Senior High School District: Fremont (510) 657-2350

Lot Info

  • Lot Size Sq Ft: 7409
  • Parcel Number: 50725016

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $5,510 $319,547 $243,063 $83,484
2024 $5,510 $313,144 $238,297 $81,847
2023 $5,306 $313,867 $233,625 $80,242
2022 $5,161 $300,714 $229,045 $78,669
2021 $5,067 $294,680 $224,554 $77,126
2020 $4,806 $298,588 $222,252 $76,336
2019 $4,761 $292,733 $217,894 $74,839
2018 $4,656 $286,995 $213,623 $73,372
2017 $4,537 $281,368 $209,435 $71,933
2016 $4,429 $275,852 $205,329 $70,523
2015 $4,355 $271,709 $202,245 $69,464
2014 $4,271 $266,386 $198,283 $68,103
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/04/2025 11/04/25 Price Changed $1,999,888 -9.1% $820 / Sq Ft
10/11/2025 10/11/25 Price Changed $2,199,888 -4.3% $902 / Sq Ft
09/13/2025 09/13/25 For Sale $2,299,888 -- $943 / Sq Ft
Source: Bay East Association of REALTORS®

Purchase History

Date Type Sale Price Title Company
Interfamily Deed Transfer -- --
Source: Public Records

Source: Bay East Association of REALTORS®

MLS Number: 41111513

Bay East Association of REALTORS®

APN: 507-0250-016-00