Exceptional 2005 Custom-Built Fremont Residence, Were Timeless Elegance, Luxury & Thoughtful Craftsmanship Come Together in One of the City's Most Desirable Neighborhoods. Designed with a Highly Sought-After Multi-Generational Floor Plan, This Remarkable Home Seamlessly Blends Sophisticated Living with Everyday Comfort. The Impressive Open-Concept Design Showcases Soaring Vaulted Ceilings, Striking Architectural Columns, Elegant Crown Molding, Gas Fireplace, Recessed Lighting & Expansive Windows That Fill the Home with Natural Light. At The Heart of the Home, Is the Beautifully Updated Chef's Kitchen Features Premium Appliances, Granite Countertops, Custom Cabinetry with Under-Cabinet Lighting, Thermador Gas Range, Breakfast Bar Seating & Spacious Pantry. Formal Living/Dining Rooms Provide the Perfect Setting for Grand Entertaining. The Luxurious Primary Suite Offers an Oversized Walk-In Closet with Chandelier & Skylight, Spa-Inspired Ensuite with Dual Vanities, Soaking Jacuzzi Tub, Separate Glass-Enclosed Shower & Sliding Door to the Backyard. Spacious Additional Bedrooms Feature Ceiling Fans, Recessed Lighting & Custom Closet Organizers. Upstairs Bath Includes Shower-Over-Tub with Glass Enclosure, Dual Vanity Sinks, Private Toilet Area & Generous Linen Storage. Escape To Your Own Resort-Style Backyard Featuring a Custom Pool & Spa with Cascading Waterfall, Lush Landscaping, Stamped Concrete Patio & Additional Side-Yard Access Ideal for RV Or Extra Vehicle Parking. Additional Highlights Include: Upstairs Den/Library Nook, Downstairs Sitting Room with Bar Area, Laundry Room with Built-In Cabinetry & Sink, Original Hardwood Floors, Energy-Efficient Dual-Pane Windows, Plantation Shutters, A/C, Custom Pigmented Exterior Stucco, Fresh Interior Paint, Upgraded Insulation Throughout, Raised Grade-Beam Foundation, Oversized Garage with 9-Foot Ceilings, Pulldown Attic Storage & Expanded Driveway. Ideally Located Near Top-Rated Fremont Schools, Kaiser & Washington Medical Facilities, Downtown Fremont, Shinn Historical Park, Lake Elizabeth, Scenic Walking Trails, Historical Niles Area & Sunol. Commuters Dream: BART, ACE Train, I-880, I-680 & 84/Dumbarton Bridge. This Extraordinary Residence Offers an Exceptional Blend of Quality & Functionality! Don't Miss Out on Making It YOURS!
Pending
$2,400,000
1315 Skelton Ave, Fremont, CA 94536
4beds
3,141sqft
Residential, Single Family Residence
Built in 2005
9,740 Square Feet Lot
$2,426,200 Zestimate®
$764/sqft
$-- HOA
What's special
Gas fireplaceBreakfast bar seatingLuxurious primary suiteImpressive open-concept designStriking architectural columnsFresh interior paintSeparate glass-enclosed shower
- 35 days
- 1,323
- 38
Zillow last checked:
Listing updated:
Listed by:
Jacqualeene Campbell DRE #00992813 510-714-3209,
Bhg Reliance Partners,
Jowelle Campbell DRE #02105634 510-714-0550,
Bhg Reliance Partners
Source: Bay East AOR,MLS#: 41142956
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- Partial bathrooms: 1
Rooms
- Room types: 2 Bedrooms, 2.5 Baths, Primary Bedrm Suite - 1, Main Entry, Den, Office, Study
Kitchen
- Features: Breakfast Bar, Stone Counters, Dishwasher, Disposal, Gas Range/Cooktop, Pantry, Range/Oven Free Standing
Heating
- Zoned
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Gas Range, Free-Standing Range, Gas Water Heater, Water Softener
- Laundry: Hookups Only, Laundry Room, Cabinets, Sink, Common Area
Features
- Study, Breakfast Bar, Pantry
- Flooring: Hardwood, Tile
- Windows: Double Pane Windows
- Basement: Crawl Space
- Number of fireplaces: 1
- Fireplace features: Living Room
Interior area
- Total structure area: 3,141
- Total interior livable area: 3,141 sqft
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Attached, Garage Door Opener
- Garage spaces: 3
Features
- Levels: Two
- Stories: 2
- Exterior features: Low Maintenance
- Has private pool: Yes
- Pool features: In Ground, Pool Sweep, Pool/Spa Combo, Outdoor Pool
- Has spa: Yes
Lot
- Size: 9,740 Square Feet
- Features: Court, Premium Lot, Back Yard, Side Yard
Details
- Parcel number: 501156068
- Special conditions: Successor Trustee Sale
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Mediterranean
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Roof: Composition
Condition
- Existing
- New construction: No
- Year built: 2005
Utilities & green energy
- Electric: No Solar
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Fire Sprinkler System, Security System Owned, Carbon Monoxide Detector(s), Double Strapped Water Heater, Smoke Detector(s)
- Subdivision: Shin Park
HOA
- Has HOA: No
Location
- Region: Fremont
Financial & listing details
- Price per square foot: $764/sqft
- Tax assessed value: $1,273,985
- Price range: $2.4M - $2.4M
- Date on market: 7/27/2026
- Listing agreement: Excl Right
- Listing terms: Cash,Conventional
Estimated market value
$2,426,200
$2.30M - $2.55M
$6,257/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/12/2026 | Pending sale | $2,400,000$764/sqft |
Source: | ||
| 7/27/2026 | Listed for sale | $2,400,000$764/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $1,273,985 +2% |
| 2025 | $15,357 +5.1% | $1,249,009 +2% |
| 2024 | $14,613 +2.7% | $1,224,526 +2% |
| 2023 | $14,231 +1.2% | $1,200,518 +2% |
| 2022 | $14,062 +2.5% | $1,176,984 +2% |
| 2021 | $13,712 -0.6% | $1,153,911 +1% |
| 2020 | $13,801 +1.2% | $1,142,083 +2% |
| 2019 | $13,640 +4.6% | $1,119,695 +2% |
| 2018 | $13,040 | $1,097,747 +2% |
| 2017 | $13,040 +1.7% | $1,076,228 +2% |
| 2016 | $12,826 +3% | $1,055,131 +1.5% |
| 2015 | $12,451 | $1,039,286 +2% |
| 2014 | $12,451 | $1,018,933 +7.3% |
| 2013 | -- | $950,000 +1.6% |
| 2012 | -- | $935,000 |
| 2011 | -- | $935,000 |
| 2010 | -- | $935,000 -3.6% |
| 2009 | -- | $969,976 +2% |
| 2008 | -- | $950,962 +6.5% |
| 2007 | -- | $893,322 +2% |
| 2006 | -- | $875,807 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: Parkmont
Local buyer's agents are ready to help



