NOT LISTED FOR SALE

Estimated Value: $1,684,000 - $2,036,061

4 Beds
2 Baths
2,070 Sq Ft
$907/Sq Ft Est. Value

Last Sold December 20, 2023

Last sale price $1,800,000 $870 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $12,042/month

7 Days on Market

Highlights

  • Updated Kitchen
  • Stone Countertops
  • Double Oven
  • Niles Elementary School Rated A
  • No HOA
  • 2 Car Detached Garage

About This Home

As of December 2023

Nestled at 860 Cashew Way, Fremont, this Semi-Custom Niles home offers approximately 2070 square feet of sophisticated living space on a large lot. Recent renovations have infused the home with a contemporary feel, including new carpets, craftsman MDF baseboards, and a variety of updated lighting fixtures like chandeliers, ceiling fans, wall sconces, and outdoor lights. The transformation extends to both primary and guest bathrooms, now featuring new vanities, sinks, faucets, vanity lights, framed mirrors, and accessories, complemented by luxury vinyl plank flooring in the guest bathroom. The interior is further enhanced with a designer kitchen boasting quartz counters, stainless steel appliances, separate formal living and dining areas, and an expansive family room ideal for entertainment. Fresh interior and exterior paint alongside newly landscaped grounds contribute to the home's unique appeal. An inviting covered patio and deck offer a perfect setting for year-round enjoyment. This property represents a harmonious blend of modern comforts and serene living, reflecting meticulous attention to detail in every aspect.

Last Agent to Sell the Property

Joseph Sabeh

Golden Gate Sotheby's Int'l License #01295925 Listed on: 11/17/2023

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $21,210

Year Built

  • Built in 1961

Lot Details

  • 8,439 Sq Ft Lot
  • Landscaped
  • Back and Front Yard

Parking

  • 2 Car Detached Garage
  • Garage Door Opener

Home Design

  • Shingle Roof
  • Wood Siding

Interior Spaces

  • 1-Story Property
  • Family Room
  • Living Room with Fireplace
  • Laundry closet

Kitchen

  • Updated Kitchen
  • Breakfast Bar
  • Double Oven
  • Indoor Grill
  • Microwave
  • Plumbed For Ice Maker
  • Dishwasher
  • Stone Countertops
  • Disposal

Flooring

  • Carpet
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 2 Full Bathrooms

Outdoor Features

  • Outdoor Storage

Utilities

  • Forced Air Heating and Cooling System
  • 220 Volts in Kitchen
  • Gas Water Heater

Community Details

  • No Home Owners Association
  • Bay East Association
  • Niles Gardens Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$21,210

Year Built

Built in 1961

Lot Details

0

Parking

2

Listing Details

  • Stories: 1
  • Year Built: 1961
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.19
  • Subdivision Name: NILES GARDENS
  • Directions: GOOGLE MAPS
  • Architectural Style: Ranch
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: One Story
  • New Construction: No
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: VirtualTour

Interior Features

  • Flooring: Vinyl, Carpet
  • Appliances: Dishwasher, Double Oven, Disposal, Grill Built-in, Plumbed For Ice Maker, Microwave, Refrigerator, Gas Water Heater
  • Full Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace Features: Living Room
  • Fireplaces: 1
  • Fireplace: Yes
  • Interior Amenities: Family Room, Breakfast Bar, Stone Counters, Updated Kitchen
  • Room Kitchen Features: 220 Volt Outlet, Breakfast Bar, Counter - Stone, Dishwasher, Double Oven, Garbage Disposal, Grill Built-in, Ice Maker Hookup, Microwave, Refrigerator, Updated Kitchen

Exterior Features

  • Roof: Shingle
  • Lot Features: Premium Lot
  • Pool Features: None
  • Pool Private: No
  • Construction Type: Wood Siding
  • Exterior Features: Back Yard, Front Yard, Side Yard, Sprinklers Automatic, Storage, Landscape Back, Landscape Front
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 2
  • Attached Garage: No
  • Covered Parking Spaces: 2
  • Parking Features: Detached, Garage Door Opener

Utilities

  • Heating: Forced Air
  • Cooling: Central Air
  • Laundry Features: Laundry Closet
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: No Solar, 220 Volts in Kitchen
  • Electricity On Property: Yes
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Association Name: BAY EAST
  • Association: No

Lot Info

  • Lot Size Sq Ft: 8439
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 3, 2025
Sold by
Squires Nicholas and Squires Stephanie
Bought by
Squires Revocable Trust and Squires
Current Estimated Value
$1,876,515

Purchase Details

Listed on
Nov 17, 2023
Closed on
Dec 7, 2023
Sold by
Palmer Family Trust
Bought by
Squires Stephanie Syu and Squires Nicholas Gerald
Seller's Agent
Joseph Sabeh
Golden Gate Sotheby's Int'l
List Price
$1,698,000
Sold Price
$1,800,000
Premium/Discount to List
$102,000
6.01%
Views
417

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
2.56%
Original Mortgage
$790,000
Interest Rate
7.5%
Source: Public Records

Range of Values:

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

Purchase History

Date Buyer Sale Price Title Company
Squires Revocable Trust -- None Listed On Document
Squires Stephanie Syu $1,800,000 Chicago Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Squires Stephanie Syu $790,000
Previous Owner Squires Stephanie Syu $790,000
Previous Owner Squires Stephanie Syu $180,000
Previous Owner Palmer James D $99,475
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/04/2025 02/04/25 Off Market $1,800,000 -- --
12/20/2023 12/20/23 Sold $1,800,000 +6.0% $870 / Sq Ft
11/21/2023 11/21/23 Pending -- -- --
11/14/2023 11/14/23 For Sale $1,698,000 -- $820 / Sq Ft
Source: Bay East Association of REALTORS®

Tax History Compared to Growth

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 $21,210 $1,836,000 $714,000 $1,122,000
2024 $21,210 $1,800,000 $700,000 $1,100,000
2023 $6,803 $541,537 $162,461 $379,076
2022 $6,703 $523,920 $159,276 $371,644
2021 $6,541 $513,510 $156,153 $364,357
2020 $6,523 $515,173 $154,552 $360,621
2019 $6,450 $505,071 $151,521 $353,550
2018 $6,322 $495,170 $148,551 $346,619
2017 $6,163 $485,461 $145,638 $339,823
2016 $6,052 $475,945 $142,783 $333,162
2015 $5,966 $468,798 $140,639 $328,159
2014 $5,858 $459,617 $137,885 $321,732
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Bay East Association of REALTORS®

MLS Number: 41044400

Bay East Association of REALTORS®

APN: 507-0028-040-00