44745 Aguila Ter, Fremont, CA 94539

5 beds, 5.5 baths, 5,135 sqft
Sold: $3,350,000
Sold on 05/06/14
Zestimate®: $3,369,014
Est. Mortgage:

Estimated Monthly Payment

Please enter a dollar amount between $0 and $200,000,000

()

Please enter a percent between 0% and 100%

30 Year Fixed
/mo
15 Year Fixed
/mo
5/1 ARM
/mo
Estimated taxes & insurance of are not included.
/mo 

A Zestimate® home valuation is Zillow's estimated market value. It is not an appraisal. Use it as a starting point to determine a home's value. Learn more

My Notes
Edit
~ A Remarkable Mission San Jose Custom Home ~ 44745 Aguila Terrace Listed for: $ 3,330,000Virtual Tour: http44745aguilaterrace.dom.usAbsolutely spectacular! This sensational pride of ownership luxurious custom home is located in the heart of the prestigious highly sought after upscale Mission San Jose community yet elegantly tucked away in a private seclude setting surrounded with multi-million dollar custom homes.View! View! View! Seeing is believing! This magnificent home offers phenomenal breathtaking panoramic views of bay, mountains, and city lights throughout the entire house. It was custom built in 1993 and has approx. 5,135 square feet of living space and approx. 18,580 square feet of premium lot with 5 bedrooms, 5.5 bathrooms, office and 4 car garages. This luxurious home boasts marvelous architecture and luxurious custom features which make this beautiful home as spectacular as Mission San Jose area s colorful history. Award Winning Schools: Mission San Jose Elementary (API 996), William Hopkins Jr. High School (API 987), and Mission San Jose High School (API 951)Monthly HOA: $140 (Managing and maintaining the common areas) Hurry up! Do not miss the wonderful opportunity to own this grandiose Mission San Jose custom built dream home. Outstanding Features of the Home- 5 bedrooms & 5.5 bathrooms - Approx. 5,135 Sq Ft of living space- Approx. 18,580 Sq Ft of premium lot- Attached 4 car garage- Gorgeous curb appeal with circular driveway- Grand formal foyer & marvelous formal living room- Elegant formal dining room-Amazingly family friendly open floor plan- Sophisticated two bedroom suites downstairs- One full bath downstairs with access to back yard +one powder room- Newly remodeled fabulous family room - Splendid master bedroom suite, two bedrooms, one full bath & office upstairs - Gorgeous hardwood floors in family, dinning, kitchen & breakfast nook area - Beautifully remodeled 4 full bathrooms features marble/granite counter tops, marble/ tiled flooring, designer light fixtures and high-end quality material - Upgraded gourmet kitchen with granite counter tops, all high-end stainless steel appliances- Executive office with private balcony, lots of built-in book shelves and cabinets, picture windows for spectacular view of the hills and greenbelt- Professional landscaping in front yard and backyard- Fantastic back yard features sparkling swimming pool with new automatic pool cover, spa, arbor, patio, lush lawn area is absolutely perfect for entertainment Formal Entry and Formal Living Room- Custom cherry double doors entrance- Grand foyer sparkling with elegant marble flooring- Dramatic high ceiling with graceful crystal chandelier - Gorgeous custom stone finished fireplace with custom stone mantel- Exquisite custom crown molding and recessed lighting - Lovely Powder room adjacent to living room-Picture windows with sensational view of mountain, greenbelt & lots of sunlight- Hunter Douglas Silhouette shadings -Dramatic high ceilingFormal Dining Room- Fabulous formal dining room with hardwood flooring- Coffered ceiling, crown molding and recessed lights- Butler s Pantry- Picture window overlooking the astonishing mountain and greenbeltSeparate Family Room- Magnificent panoramic views of city lights, bay & mountains from all windows - Remodeled spacious and open family room with hardwood floors- Built-in surrounded sound system and speakers- Beautiful custom stone finished fireplace with custom stone mantel- Coffered ceiling with gorgeous crown molding and recessed lighting- Convenient second staircase - Access to the wonderful back yardGourmet Kitchen -High quality maple wood cabinets with granite counter tops and granite backsplash, custom crown molding-Center island features Gaggeneau 5-burner gas cook top, Thermador island hood, island prep sink, and breakfast bar- All high-end stainless steel appliances includes Sub-Zero refrigerator, double self cleaning Thermador ovens, built-in warmer & microwave- Beautiful coffe  MoreLess
Views
If this home is listed on Zillow, it will reach the largest real estate network on the web.*
3,683 all-time views
of this home (chart)
224 forecasted views of this home
in the first 7 days after listing for sale
Interested in selling this home?
 
Facts
  • Lot: 0.43 acres
  • Single Family
  • Built in 1993
  • HOA Fee: $140
  • Cooling: Central
  • Heating: Forced air
  • Last sold: May 2014 for $3,350,000
  • Price/sqft: $652
Features
  • Ceiling Fan
  • Deck
  • Double Pane/Storm Windows
  • Fenced Yard
  • Fireplace
  • Flooring: Hardwood, Tile
  • Jetted Tub
  • Lawn
  • Parking: Garage - Attached
  • Patio
  • Pool
  • Porch
  • Sprinkler System
  • Vaulted Ceiling
Additional Features
  • Granite countertop, Living room, Stainless steel appliances
Appliances Included
  • Dishwasher
  • Garbage disposal
  • Microwave
  • Range / Oven
  • Refrigerator
  • Washer
Room Types
  • Breakfast nook
  • Dining room
  • Family room
  • Master bath
  • Office
  • Pantry
  • Walk-in closet
Construction
  • Construction quality: 8.0
  • Room count: 14
  • # Stories: 2.0
  • Structure type: Other
  • Unit count: 1
Other
  • Floor size: 5,135 sqft
  • Last remodel year: 1994
  • Laundry: In Unit
  • Parcel #: 513 026501500
  • Zillow Home ID: 25021214
Home Values
Add owner estimate
Zestimate What's this?
Close
A Zestimate home valuation is Zillow's estimated market value. It is not an appraisal. Use it as a starting point to determine a home's value. Learn more

The Value Range is the high and low estimate market value for which Zillow values a home. The more information, the smaller the range, and the more accurate the Zestimate. See data coverage and accuracy table

Don't agree with your home's Zestimate? Owners can edit their home facts to make the Zestimate more accurate. Plus, you can leave an opinion on your Zestimate value below. Just click "Owner Estimate".
$3,369,014
-$96,152 Last 30 daysd
$2.83M
$3.67M
Zestimate range
Rent Zestimate What's this?
Close
A Rent Zestimate is Zillow's estimated monthly rental price, computed using a proprietary formula. It is a starting point in determining the monthly rental price for a specific property. Learn more

The Rent Range is the high and low estimate for which an apartment or home could rent. The more information we have, the smaller the range, and the more accurate the Rent Zestimate. See data coverage and accuracy table
$5,159/mo
-$365 Last 30 daysd
$2.7K
$10K
Zestimate range

Loading chart...

Internet, phone and TV
Details
Home security
Details
Furniture
Details

Neighborhood for 44745 Aguila Ter

View larger map
Zillow predicts 94539 home values will rise 1.4% next year, compared to a 2.3% increase for Fremont as a whole. Among 94539 homes, this home is valued 189.2% more than the midpoint (median) home, and is valued 11.6% more per square foot.

Foreclosures will be a factor impacting home values in the next several years. In 94539, the number of foreclosures waiting to be sold is 8.6% less than in Fremont, and 28.3% lower than the national average. This lower local number could help 94539 home values rise more quickly than other regions in Fremont.

Learn more about forecast calculations or 94539 home values.
  MoreLess
 
List of nearby homes
    For Sale
    See all nearby listings
    Rentals
    See all nearby rentals

    Nearby Schools

    Data by GreatSchools.org  ?

    Close

    GreatSchools ratings give an overview of a school's test results. The ratings are based on a comparison of test results for all schools in the state.

    Disclaimer: School attendance zone boundaries are supplied by Maponics and are subject to change. Check with the applicable school district prior to making a decision based on these boundaries.

    Contact a local agent

    What's this?
    Close
    About these agents
    These listing agents specialize in this area and can get you a market value for this home and answer your questions.

    Are you an agent looking for more exposure for yourself or your listings? Call Zillow at (855) 840-3292
    Close
    Premier Agents specialize in this area and can assist you in seeing a home or answer your questions.

    Are you an agent looking for more exposure for yourself or your listings? Call Zillow at 866-324-4005

    Contact Consent

    Close
    By submitting your contact request for a loan product, you are providing an electronic signature and consenting to be contacted by Wells Fargo Bank N.A. or Wells Fargo Home Mortgage by telephone (on a recorded line and potentially using automated dialing systems and artificial or prerecorded voice messaging), email or mail based on the information you have provided, even if your telephone number or e-mail is on a corporate, state, or the National Do Not Call Registry. In addition, you are consenting, acknowledging and agreeing to Wells Fargo Bank N.A.'s Terms of Use and Privacy Policy. You are not required to consent to receiving autodialed calls as a condition of purchasing any Wells Fargo Bank N.A. or Wells Fargo Home Mortgage products or services.

    Learn how to appear as the agent above

    Close
    Want to learn how to appear as the agent above? Contact us here or call us at (855) 840-3292

    Ask these lenders about financing

    (408) 399-2751
    NMLS #455288

    Email successfully sent!Submission failed!

    Are you pre-approved already?

    Find out how much house you can afford and get pre-approved for a mortgage in minutes.

    • Fast & easy
    • Top-notch lenders
    • Safe & secure

    Get Pre-Approved

    Next: Get Pre-Approved

    A Zillow Confirmed Lender will call you.

    Contact me

    A Zillow Confirmed Lender will also be calling you back to assist with pre-approval. Thanks for using Zillow!

     
     
     
     
     
     
     

    Contact a local agent

    What's this?
    Close
    About these agents
    These listing agents specialize in this area and can get you a market value for this home and answer your questions.

    Are you an agent looking for more exposure for yourself or your listings? Call Zillow at (855) 840-3292
    Close
    Premier Agents specialize in this area and can assist you in seeing a home or answer your questions.

    Are you an agent looking for more exposure for yourself or your listings? Call Zillow at 866-324-4005

    Contact Consent

    Close
    By submitting your contact request for a loan product, you are providing an electronic signature and consenting to be contacted by Wells Fargo Bank N.A. or Wells Fargo Home Mortgage by telephone (on a recorded line and potentially using automated dialing systems and artificial or prerecorded voice messaging), email or mail based on the information you have provided, even if your telephone number or e-mail is on a corporate, state, or the National Do Not Call Registry. In addition, you are consenting, acknowledging and agreeing to Wells Fargo Bank N.A.'s Terms of Use and Privacy Policy. You are not required to consent to receiving autodialed calls as a condition of purchasing any Wells Fargo Bank N.A. or Wells Fargo Home Mortgage products or services.

    Learn how to appear as the agent above

    Close
    Want to learn how to appear as the agent above? Contact us here or call us at (855) 840-3292

    Email successfully sent!Submission failed!

    Are you pre-approved already?

    Find out how much house you can afford and get pre-approved for a mortgage in minutes.

    • Fast & easy
    • Top-notch lenders
    • Safe & secure

    Get Pre-Approved

    Next: Get Pre-Approved

    A Zillow Confirmed Lender will call you.

    Contact me

    A Zillow Confirmed Lender will also be calling you back to assist with pre-approval. Thanks for using Zillow!

    Similar Homes for Sale

    1. 850 Vista Hill Ter, Fremont, CA 94539
      850 Vista Hill Ter, Fremont, CA 94539

      For Sale: $3,700,000

      • Beds: 5
      • Sqft: 5100
      • Baths: 5.0
      • Lot: 0.68 ac
    2. 45437 Rutherford Ter, Fremont, CA 94539
      45437 Rutherford Ter, Fremont, CA 94539

      For Sale: $2,875,000

      • Beds: 5
      • Sqft: 5027
      • Baths: 6.0
      • Lot: 0.5 ac
    Home Design Ideas and Photos

    Nearby Similar Sales

    1. 800 Vista Hill Ter, Fremont, CA 94539

      Sold on 3/21/2014: $3,688,000

      • Beds: 5
      • Sqft: 5713
      • Baths: 6.0
      • Lot: 0.49 ac
    2. 45437 Rutherford Ter, Fremont, CA 94539

      Sold on 8/20/2014: $2,875,000

      • Beds: 5
      • Sqft: 5027
      • Baths: 6.0
      • Lot: 0.5 ac
    3. 651 Vista Hill Ter, Fremont, CA 94539

      Sold on 11/21/2013: $2,770,000

      • Beds: 6
      • Sqft: 6049
      • Baths: 5.0
      • Lot: 0.5 ac
    Featured Partners for 44745 Aguila Ter