Where Dreams Come True. .. !! Entertainer home. Artist murals on walls and fence. Feels like a resort home. Situated in the highly desirable 28 Palms neighborhood. Separate Living/Family Rm. 3 bedrooms/2 Bathrooms single level home with a pool and murals that take you to paradise. Conveniently located to shopping, parks and schools!! Easy access to freeway 880. Low maintenance yards with artificial lawn. Great outdoor entertaining space!! Hardwood floors throughout! Don't miss this gem of a house!!
*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
3
Baths
2
Stories
1
Lot width
—
Lot depth
—
Lot size
5,700 Sq. Ft.
Year renovated
1962
Sq. Ft.
1,200
Year built
1961
Style
Single Family Residential
County
Alameda County
APN
531 002204100
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 16, 2026.
R-1-6
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
Install a new air conditioning unit and add a new electrical circuit.
HVAC
Jun 30, 2017 • Final
Building
Tear off existing roofing and install new composition shingles 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.
Property details
Parking
Garage Information
Has Garage
# of Garage Spaces: 2
Parking Information
# of Covered Spaces: 2
Interior
Virtual Tour Information
Bedrooms Information
# of Bedrooms: 3
Bathroom Information
Count of Bathrooms: 2
# of Full Bathrooms: 2
Interior Features
Laundry Features: In Garage
Has Heating
Heating: Zoned
Has Cooling
Cooling: Central Air
Flooring: Wood
Has Fireplace(s)
# of Fireplaces Total: 2
Fireplace Features: Family Room, Free Standing, Insert, Living Room
Appliances: Gas Cooktop, Microwave, Dryer, Washer
Exterior
Exterior Features
Entry Level: 0
Building Information
Living Area: 1200
Living Area Units: Square Feet
Living Area Source: Assessor Auto-Fill
Building Area Total: 1200
Building Area Units: Square Feet
Building Area Source: Assessor Auto-Fill
Construction Materials: Stucco
Architectural Style: Contemporary
Year Built: 1961
Mobile Home Information
Mobile Dim Units: Feet
Pool Information
Pool Features: In Ground, Heat None
Property Type
Property Type: Residential
Property SubType: Single Family Residence
Property Information
Property Condition: Original
Lot Information
Lot Features: Shape Regular, Other
Lot Size Sq. Ft.: 5702.004
Lot Size Acres: 0.1309
Lot Size Area: 5702.004
Lot Size Units: SqFt
Lot Size Units: Square Feet
Elevation: 0
Elevation Units: Feet
Utilities
Utility Information
Sewer: Public Sewer
Water Source: Public
Location
HOA Information
Association Fee: 0
Community Information
Subdivision Name: 28 Palms
Public facts
Beds: 3
Baths: 2.0
Sq. Ft.: 1,200
Stories: 1.0
Lot Size: 5,700 square feet
Style: Single Family Residential
Year Built: 1961
Year Renovated: 1962
County: Alameda County
APN: 531 002204100
Home facts updated by county records on Sep 16, 2026
Around this home
Schools
Joseph Azevada Elementary School
Public Tk-5 • Assigned • 0.3mi
7/10
G. M. Walters Middle School
Public 6-8 • Assigned • 0.5mi
8/10
John F. Kennedy High School
Public 9-12 • Assigned • 0.2mi
7/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...