See Home Value
$2,898,246*
House - Off Market

40200 Hacienda Ct

FREMONT, CA 94539
bedrooms
4 Beds
bathrooms
6 Baths, 1 Half Bath
square feet
3506 Sqft
$2,430,000 - $2,968,000
Reference Base Price*
7.38%
Since Apr 1, 2021
CA-San Francisco
Primary Model
Sold Apr 27, 2021
$2,681,000
$1,755,000 by Jpmorgan Chase Bank Na
Mortgage Due Sep 01, 2051
Sold Jun 19, 2006
$905,000
$510,000 by Wells Fargo Bank Na
Mortgage Due Jul 01, 2036

About This Property

Helen Du - - Exquisite luxury home in The Mission District, custom rebuilt in 2015, designed through-out with the finest materials, raised foundation on corner lot. Dual master suites, total of 4 bedrooms and 5.5 bathrooms. Each bedroom is uniquely designed with its own bathroom. Wake up with a panoramic view of the Mission Peak sunrise from your bed in the upstairs master bedroom. Extraordinary double-door entry, designer crystal chandeliers, Brazilian Cherry Wood grand staircase. Impressive den with custom built-in desks make it a pleasure to work from home.  Gourmet kitchen featuring top-end appliances from Wolf, including a deluxe cooktop with griddle, drawer microwave, double oven with steam convection, and warming drawer for a true professional chef experience. Indoor spa that features a blissfully soothing waterfall, built-in jacuzzi, steam room with shower. Dual laundry, upstairs & downstairs. Home-grown fruits year-round. Convenient access to Mission Blvd, shopping center and highway 680.

The manager has listed the unit size as 3506 square feet.
Unit Size
3,506Ft²
Days on Market
-
Land Size
0.15 acres
Price per sqft
$770
Property Type
House
Property Taxes
-
HOA Dues
-
Year Built
2015

Price History

Date / Event Date Event Price
Apr 27, 2021 Sold to Alice Xun Xu, Bo Hung Wu $2,681,000
Sold to Alice Xun Xu, Bo Hung Wu
Mar 23, 2021 No longer available -
No longer available
Feb 2, 2021 Listed $2,699,000
Listed

Property Highlights

Air Conditioning
Garage

Building Info

Overview

    General

  • Year Built: 2015
  • Effective Year Built: 2015
  • Building Count: 1
  • Total Rooms: 10
  • Bedroom Count: 4
  • Bathroom Count: 5
  • Full Bathrooms: 4
  • Partial Bathrooms: 5
  • Building Condition: Good
  • Building Quality: B
  • Construction Type: Wood
  • Building Style: Other
  • Exterior Walls Type: Stucco
  • Roof Cover Type: Wood shake/ shingles
  • Floor Count: 2
  • Living Units: 1
  • Basement Area: 0
  • Garage Type: Garage
  • Parking Space Count: 2

    Dimensions

  • Lot Size Square Feet: 6,720
  • Total Building Area: 3,506
  • Building Area: 3,506
  • Building Area Measurement: Living Area

    Heating and Cooling

  • Air Conditioning: unknown
  • Heating: Forced air unit
  • Heated Square Feet: 3,506
  • Heating Fuel Type: unknown

    Utilities

  • Sewer System: Municipal
  • Water Service: Municipal

Building

  • Property Class: Residential
  • Subdivision: FREMONT
  • Land Acres: 0.154
  • Standard Land Use Code: Single family residential
  • County Land Use Code: Residential income (general) (multi-family)
  • Legal Description 1: LOT: 00001 BLK: 0001 TR: 2859

Ownership

  • Current Owner : WU BO HUNG
  • Current Owner 2: XU ALICE XUN
  • Previous Owner : KUO JOSEPH CHUO JU
  • Previous Owner 2: KUO JU LU
  • Owner Before Previous Owner: UTIC PHILLIP J
  • Owner Before Previous Owner 2: UTIC LIVING TRUST
  • Is Owner Occupied: Owner-occupied property

Neighborhood

  • School District Name: Fremont Unified School District
  • Census Tract: 442100

Geography

  • Assessors Map Reference: 91-B2
  • Subdivision Tract Number: 2859
  • Parcel: Jan 01, 1970
  • Block: 1
  • Lot: 1
  • Municipality: CITY OF FREMONT
  • Latitude: 37.5539
  • Longitude: -121.952

    Address

  • Full Address: 40200 Hacienda Ct
  • Address - House Number: 40200
  • Address - Street Name: Hacienda
  • Address - Suffix Type: Ct
  • State: CA
  • City Name: Fremont
  • Carrier Code: C036
  • 4-Digit Zip Code: 3607
  • Zip Code: 94539

Valuation

    Tax

  • Tax Year: 2022
  • Tax Amount: $31,807
  • Tax Rate Code Area: 12-051

    Appraisal Valuation

  • Standard Deviation: 0.209
  • Valuation Date: Jul 12, 2023
  • Confidence Score: 71
  • Final Value: 2,444,464
  • High Value: 2,955,453
  • Low Value: 1,933,474

    Open Liens

  • Total Open Liens: 1
  • Total Open Liens Amount: $1,755,000
  • First Open Lien Mortgage Lender: JPMORGAN CHASE BANK NA
  • First Open Lien Mortgage Recording Date: Aug 12, 2021
  • First Open Lien Mortgage Financing Type: Adjustable Rate
  • First Open Lien Mortgage Loan Amount: $1,755,000
  • First Open Lien Mortgage Term: 360
  • First Open Lien Mortgage Position: 1
  • First Open Lien Mortgage Loan Type: New Conventional
  • First Open Lien Mortgage Loan Due Date: Sep 01, 2051

    Assessments Valuation

  • Assessed Year: 2022
  • Assessed Total Value: $2,727,416
  • Assessed Land Value: $867,000
  • Assessed Improvements Value: $1,867,416

    Exemptions

  • Homeowner Exemption: Yes

    Sales

  • Current Sale Contract Date: Apr 21, 2021
  • Current Sale Recording Date: Apr 27, 2021
  • Current Sale Transaction ID: 11834439300
  • Current Sale Price: $2,681,000
  • Current Sale Document Type: Grant Deed
  • Current Sale Input Document Number: 2021163551
  • Previous Sale Recording Date: Jun 19, 2006
  • Previous Sale Contract Date: Jun 12, 2006
  • Previous Sale Amount: $905,000
  • Previous Sale Document Type: Grant Deed

    Last Sale Mortgage

  • First Mortgage Lender: CITIBANK NA
  • First Mortgage Transaction Date: Apr 27, 2021
  • First Mortgage Loan Amount: $2,144,640
  • First Mortgage Terms: 360
  • First Mortgage Loan Type: New Conventional
  • First Mortgage Loan Due Date: May 01, 2051

    Financing

  • First Mortgage Financing Type: Adjustable Rate

    Previous Mortgages

  • Previous Mortgage Lender: WELLS FARGO BANK NA
  • Previous Mortgage Transaction Date: Jun 19, 2006
  • Previous Mortgage Financing Type: Adjustable Rate
  • Previous Mortgage Loan Amount: $510,000
  • Previous Mortgage Term: 360
  • Previous Mortgage Loan Type: Fannie Mae/Freddie Mac (Phased out because Fannie Mae does not originate loans directly to borrowers or investors. Most "new conventional" loans meet their general underwriting guidelines.)
  • Previous Mortgage Loan Due Date: Jul 01, 2036



Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Mission San Jose


Similar Homes for Sale

Currently no similar homes around

Nearby Rentals



Frequently Asked Questions

When was property at 40200 Hacienda Court built and last sold?
The property at 40200 Hacienda Court was built in 2015 and last sold on Apr 21, 2021 for $2,681,000.
How much is this home worth?
The estimated value of the home located at 40200 Hacienda Court is $2,725,990.
What are some comparable homes to 40200 Hacienda Court?
There are currently no comparable homes to 40200 Hacienda Court.

Quantcast