Off Market2749d on market
35417 Terra Cotta Cir
Fremont, CA, 94536 • Niles • Alameda County
$2,194,000
$1080/sqft
3Beds
3Baths
2,032Sqft
Property DNA
Hardwood Floors
Quality flooring throughout
Market activity
Demand and pricing signals for this listing
12 views
People checking out this listing
2749 days on market
Established listing
$1,080/sqft
Price per square foot
About this home
Single Family
Beautifully remodeled Niles area home in park like setting! Gorgeous gourmet kitchen that has been completely remodeled with high end appliances and large island, perfect for entertaining! Wood flooring throughout. Large master bedroom with beautifully remodeled master bathroom. Plantation shutters and custom drapery. So many upgrades in this beautiful home!! Custom landscaped low maintenance back yard. Front yard is maintained by the HOA! Close to parks, shopping and freeway access! No pets of any kind Must make at least 3 times the monthly rent along with having 750+ credit score Please note, small refrigerator in pictures not available. Washer and dryer included but not pictured. Pictures are from when the property was staged. Property comes unfurnished. All information provided is deemed reliable but is not guaranteed and should be independently verified Minimum One (1) year lease- No Smoking of any kind- No Pets of any kind
Standout features identified
Our analysis highlights gorgeous gourmet kitchen, beautifully remodeled master bathroom, and high end appliances as key attractions of this home.
Estimated monthly payment
Based on current rates
$13,853/month
Principal & Interest$10,927
Property Tax$2,194
Insurance$731
Down payment20% ($438,800)
3%50%
Est. 6.36% rate · 30yr fixed · $1,755,200 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence
CoolingCentral Air
ParkingAttached Garage
Property
Home typeSingle Family
Sub-typeSingle Family Residence
Systems
CoolingCentral Air
Parking & Outdoor
ParkingAttached, Off Street
Location & Tax
NeighborhoodNiles
Parcel5075058
Bathrooms & Fees
Full baths2
Features & details
5 categories of property features
Interior Features
Appliances
Dryer
Washer
Flooring
Hardwood
Cooling
Central Air
Laundry
In Unit
Exterior Features
Parking
Attached
Off Street
Listing insights
Market data and value estimates
StatusOff Market
Days on market2749
Est. value$2,194,000
Est. rent$4,542/mo
Tax rate1.22%
Price/sqft$1080
On marketDec 1, 2025
PostedDec 1, 2025
Last sold$1,395,000
MLS updatedJan 1, 2026
Tour days6
Views12
How are the schools in Fremont?
3 schools rated nearby
Location
Fremont, CA, 94536
Price history
23 events
DateEventPrice$/sqftSource
Jan 5, 2026Listing Removed$5,000$2Zillow Rentals
Dec 1, 2025Listed For Rent$5,000$2Zillow Rentals
Dec 19, 2024Listing Removed$5,000$2Zillow Rentals
Dec 16, 2024Listed For Rent$5,000$2Zillow Rentals
Nov 6, 2024Listing Removed$5,000$2Zillow Rentals
Oct 31, 2024Listed For Rent$5,000$2Zillow Rentals
Oct 12, 2024Listing Removed$5,000$2Zillow Rentals
Sep 18, 2024Price Change$5,000$2Zillow Rentals
Jul 24, 2024Listed For Rent$5,200$3Zillow Rentals
Oct 8, 2022Listing Removed——Zillow Rental Manager
Sep 27, 2022Listed For Rent$4,500$2Zillow Rental Manager
Nov 4, 2021Listing Removed——Zillow Rental Manager
Nov 1, 2021Listed For Rent$4,500$2Zillow Rental Manager
Feb 24, 2021Listing Removed——Owner
Oct 20, 2020Listing Removed$4,500$2Owner
Aug 22, 2020Listed For Rent$4,500$2Owner
Sep 19, 2019Listing Removed$4,375$2Kuo Properties
Aug 6, 2019Price Change$4,375$2Kuo Properties
Jul 4, 2019Listed For Rent$4,500$2Kuo Properties
Sep 27, 2018Sold$1,395,000$687Bay East AOR
Sep 7, 2018Pending Sale$1,395,000$687Excel Realty
Aug 31, 2018Price Change$1,395,000$687Excel Realty
Jul 12, 2018Listed For Sale$1,495,000$736Excel Realty
Listing Removed$5,000
Jan 5, 2026•$2/sqft•Zillow Rentals
Listed For Rent$5,000
Dec 1, 2025•$2/sqft•Zillow Rentals
Listing Removed$5,000
Dec 19, 2024•$2/sqft•Zillow Rentals
Listed For Rent$5,000
Dec 16, 2024•$2/sqft•Zillow Rentals
Listing Removed$5,000
Nov 6, 2024•$2/sqft•Zillow Rentals
Listed For Rent$5,000
Oct 31, 2024•$2/sqft•Zillow Rentals
Listing Removed$5,000
Oct 12, 2024•$2/sqft•Zillow Rentals
Price Change$5,000
Sep 18, 2024•$2/sqft•Zillow Rentals
Listed For Rent$5,200
Jul 24, 2024•$3/sqft•Zillow Rentals
Listing Removed—
Oct 8, 2022•Zillow Rental Manager
Listed For Rent$4,500
Sep 27, 2022•$2/sqft•Zillow Rental Manager
Listing Removed—
Nov 4, 2021•Zillow Rental Manager
Listed For Rent$4,500
Nov 1, 2021•$2/sqft•Zillow Rental Manager
Listing Removed—
Feb 24, 2021•Owner
Listing Removed$4,500
Oct 20, 2020•$2/sqft•Owner
Listed For Rent$4,500
Aug 22, 2020•$2/sqft•Owner
Listing Removed$4,375
Sep 19, 2019•$2/sqft•Kuo Properties
Price Change$4,375
Aug 6, 2019•$2/sqft•Kuo Properties
Listed For Rent$4,500
Jul 4, 2019•$2/sqft•Kuo Properties
Sold$1,395,000
Sep 27, 2018•$687/sqft•Bay East AOR
Pending Sale$1,395,000
Sep 7, 2018•$687/sqft•Excel Realty
Price Change$1,395,000
Aug 31, 2018•$687/sqft•Excel Realty
Listed For Sale$1,495,000
Jul 12, 2018•$736/sqft•Excel Realty
Tax history
25 years of records
YearTax paidAssessed value
Apr 8, 2025—$1,556,122
Apr 8, 2024$18,023$1,525,613
Apr 8, 2023$17,559$1,495,704
Apr 8, 2022$17,358$1,466,381
Apr 8, 2021$16,925$1,437,631
Apr 8, 2020$17,061$1,422,900
Apr 8, 2019$16,861$1,395,000
Apr 8, 2018$7,374$601,253
Apr 8, 2017$7,374$589,467
Apr 8, 2016$7,244$577,910
Apr 8, 2015$7,019$569,231
Apr 8, 2014$7,019$558,080
Apr 8, 2013—$555,562
Apr 8, 2012—$544,670
Apr 8, 2011—$533,991
Apr 8, 2010—$530,002
Apr 8, 2009—$531,264
Apr 8, 2008—$520,847
Apr 8, 2007—$510,635
Apr 8, 2006—$500,624
Apr 8, 2005—$490,809
Apr 8, 2004—$481,187
Apr 8, 2003—$472,372
Apr 8, 2002—$463,112
Apr 8, 2001$4,906$454,030
Nearby homes
Neighborhood details
Local context around this listing
Fremont, CA • Alameda County
Nearby neighborhoods
ArdenwoodCabrilloCentervilleDowntownGlenmoorGrimmerIrvingtonNorthgateSundaleWarm Springs
Nearby cities
AlamedaBerkeleyDublinFremontHaywardLivermoreOaklandPleasanton
Nearby zip codes
945369453794538945399455594560
Similar homes
No obligation · Same-day response