Great location~All top rated schools~ 5 bedrooms +3.5 baths(2suite, 1 downstairs & 1 upstairs)~ 9100 sq ft huge lot~lots of upgrades: new roof, new carpet, gourmet kitchen, double pane windows, hardwood flrs in living, dining, kitchen. .too many to list, must see, O/H Sat, Sun 1-5 pm
Single-familyProperty Type
1977Year Built
9,100 sq ftLot Size
$1,124Est. Price/Sq.Ft.
2 car garageParking
Listed by Linda Young•DRE #01076248• USA Realty & Loans
Contact: (510) 673-8811
Bought with Leon Hu•DRE #01883510• USA Realty & Loans
Nice layout with granite kitchen counters with wood panel on dishwasher and refrigerator. One master bedroom downstairs and One upstairs. Huge back yard with a park next to the house. Move in ready.
13 years ago• May not reflect the current state of the home
bridgeMLS, Bay East AOR, or Contra Costa AOR #40628581
Sep 27, 2013
Listing Removed
—
Sep 27, 2013
Sold
$1,020,000
$466/sq ft
Aug 30, 2013
Pending
—
Aug 21, 2013
Listed
$949,999
$434/sq ft
+15
Great location~All top rated schools~ 5 bedrooms +3.5 baths( 2suite, 1 downstairs & 1 upstairs)~ 9100 sq ft huge lot~lots of upgrades: new roof, new carpet, gourmet kitchen, double pane windows, hardwood flrs in living,dining, kitchen..too many to list, must see
Public Records
Feb 28, 1986
Sold
$179,500
$82/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$16,550 (+5.1%)
$382,597 + $987,430
$1,370,027
2024
$15,743 (+2.7%)
$375,097 + $968,073
$1,343,170
2023
$15,336 (+1.2%)
$367,744 + $949,095
$1,316,839
2022
$15,158 (+2.5%)
$353,466 + $912,246
$1,265,712
2021
$14,782 (−0.7%)
$353,466 + $912,246
$1,265,712
2020
$14,887 (+1.2%)
$346,538 + $894,365
$1,240,903
2019
$14,715 (+2.0%)
$342,986 + $885,197
$1,228,183
2018
$14,432 (+2.6%)
$336,263 + $867,846
$1,204,109
2017
$14,072 (+8.9%)
$323,209 + $834,155
$1,157,364
2016
$12,926 (+1.3%)
$323,209 + $834,155
$1,157,364
2015
$12,763 (+1.7%)
$316,872 + $739,368
$1,056,240
2014
$12,551 (+216.8%)
$306,000 + $714,000
$1,020,000
2013
$3,962 (+2.5%)
$306,000 + $714,000
$1,020,000
2012
$3,866 (+1.6%)
$126,208 + $188,094
$314,302
2011
$3,804 (+5.1%)
$123,734 + $184,407
$308,141
2010
$3,620
$121,309 + $180,792
$302,101
2009
$3,618 (+1.7%)
$120,403 + $179,442
$299,845
2008
$3,556
$120,689 + $179,869
$300,558
Tax history for 48254 TURQUOISE St
Year
Property tax
Land + Additions
Assessment*
2025
$16,550 (+5.1%)
$382,597 + $987,430
$1,370,027
2024
$15,743 (+2.7%)
$375,097 + $968,073
$1,343,170
2023
$15,336 (+1.2%)
$367,744 + $949,095
$1,316,839
2022
$15,158 (+2.5%)
$353,466 + $912,246
$1,265,712
2021
$14,782 (−0.7%)
$353,466 + $912,246
$1,265,712
2020
$14,887 (+1.2%)
$346,538 + $894,365
$1,240,903
2019
$14,715 (+2.0%)
$342,986 + $885,197
$1,228,183
2018
$14,432 (+2.6%)
$336,263 + $867,846
$1,204,109
2017
$14,072 (+8.9%)
$323,209 + $834,155
$1,157,364
2016
$12,926 (+1.3%)
$323,209 + $834,155
$1,157,364
2015
$12,763 (+1.7%)
$316,872 + $739,368
$1,056,240
2014
$12,551 (+216.8%)
$306,000 + $714,000
$1,020,000
2013
$3,962 (+2.5%)
$306,000 + $714,000
$1,020,000
2012
$3,866 (+1.6%)
$126,208 + $188,094
$314,302
2011
$3,804 (+5.1%)
$123,734 + $184,407
$308,141
2010
$3,620
$121,309 + $180,792
$302,101
2009
$3,618 (+1.7%)
$120,403 + $179,442
$299,845
2008
$3,556
$120,689 + $179,869
$300,558
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
5
Baths
4
Stories
1.5
Lot width
—
Lot depth
—
Lot size
9,100 Sq. Ft.
Year renovated
1986
Sq. Ft.
2,750
Year built
1977
Style
Single Family Residential
County
Alameda County
APN
519 120104400
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 16, 2026.
R-1-8
Single-Family Residential District
To promote and maintain predominantly single-family home neighborhoods together with compatible accessory and supporting uses.
Permitted uses
Include but are not limited to:
Agriculture-Other
Housing-Single unit
Housing-Senior
Housing-Other
Jun 30, 2017 • Final
Building/historical/na/na
Electrical
Jun 30, 2017 • Final
Building
Tear off the existing roof and install new composition roofing on a residential building.
Roofing
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Fireplace Description: In Family Room, Wood-Burning, Fireplace Available
Heating & Cooling Information
Cooling: Central Forced Air
Heating: Forced Air
Exterior
Exterior Features
Roof: Composition
Yard/Grounds: Patio(s), Deck, Fenced
Building Information
Style: Contemporary
Subclass: Single Family Home
Building Type: Detached
Exterior: Stucco
Foundation Pillars
Building Height (Minimum): 2
Building Height (Maximum): 2
Property Features
Amenities: Double Pane Windows(s), Wet Bar
Living Sq. Ft.: 2,190
Property Information
Level (Street/Main): 2 or more Master Suites
Property Primary ID: 371356
Lot Information
Lot Size Area Minimum Units: Sq. Ft.
Lot Size Area Maximum Units: Sq. Ft.
Lot Size Source: Assessor
Zoning: r
Financial
Tax/Assessment Information
City Transfer Tax: No
Utilities
Utility Information
Energy Features: Double Pane Windows, Ceiling Fan(s)
Sewer Septic: Sewer in Street, Sewer Connected
Water Information
Water: Public
Location
Multi-Unit Information
# of Stories: 2
School Information
Elementary School District: Fremont Unified
High School District: Fremont Unified
Public facts
Beds: 5
Baths: 4.0
Sq. Ft.: 2,750
Stories: 1.5
Lot Size: 9,100 square feet
Style: Single Family Residential
Year Built: 1977
Year Renovated: 1986
County: Alameda County
APN: 519 120104400
Home facts updated by county records on Sep 16, 2026
Other
Miscellaneous Information
Incorporated: Yes
Around this home
Schools
Warm Springs Elementary School
Public 3-5 • Assigned • 0.8mi
10/10
John M. Horner Middle School
Public 6-8 • Assigned • 4.7mi
9/10
Irvington High School
Public 9-12 • Assigned • 4.5mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Local insights from Redfin agents
Fremont’s housing market is cooling, with median sale prices down 6.5% year over year to $1.37 million in Sep 2026, desirable homes attract competition. Buyers find more negotiating opportunities as inventory rises, sellers should price competitively...
Fremont’s median sale price is approximately $1.37M, down 6.5% year over year. Homes sell in a median of 21 days, with a 101% sale-to-list ratio. Softer prices create opportunities for buyers, while sellers should focus on strategic pricing and...
Buyer demand in Fremont is keeping the market aggressive. Homes frequently receive multiple offers and go pending in about 20 days. With many properties closing above asking price, well-priced, move-in-ready homes offer sellers a distinct advantage...
Fremont's fall market offers clear buyer opportunities. Median prices hold steady around $1.4M with homes averaging three weeks on market. While move-in-ready homes draw quick competitive offers, properties needing cosmetic updates give you room to...