NOT LISTED FOR SALE

554 Guerra Dr San Jose, CA 95111

Hillsdale Neighborhood

Estimated Value: $950,000 - $1,114,000

3 Beds
2 Baths
1,053 Sq Ft
$988/Sq Ft Est. Value

Sale Details

Date Sold: August 14, 2018

Last sale price $770,000 $731 Per Sq Ft

Est. 35% increase in value since last sale

Current estimated payment $6,647 / mo

31 Days on Market

Highlights

  • Formal Dining Room
  • Forced Air Heating and Cooling System
  • 1-Story Property
  • 2 Car Attached Garage

About This Home

As of August 2018

Affordable... Great opportunity to own your dream home. This move-in ready single story property located in the heart of San Jose featuring open floor plan, huge living room with pitched ceiling, separate dining room, recessed lighting and gleaming laminate flooring. Chef's kitchen with granite countertops and designer inspired cabinetry with glass panels. Gated and private large lot for relaxing and quality time with family fun activities. Exterior large storage shed can be a possible relaxing bonus room. 2-car garage, tile roof, AC unit and low maintenance landscape. Minutes away from North Valley and upcoming Berryessa Bart Station. Easy access to freeway 87, 280, 101, 680 and within 19 miles from Apple and Google Headquarters.

Last Agent to Sell the Property

Alan Huynh

Redfin License #01334577 Listed on: 06/11/2018

Last Buyer's Agent

Tong Lim

Giant Realty Inc. License #00997068

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1979

Lot Details

  • 4,914 Sq Ft Lot
  • Zoning described as R1PD

Parking

  • 2 Car Attached Garage

Home Design

  • Tile Roof

Interior Spaces

  • 1,053 Sq Ft Home
  • 1-Story Property
  • Formal Dining Room

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms

Utilities

  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number 497-40-019

Home Details

Home Type

Single Family

Year Built

Built in 1979

Lot Details

4,914 Sq Ft Lot

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Listing Class: Residential
  • Structure Sq Ft: 1053
  • Year Built: 1979
  • Zoning Description: R1PD
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: No Family Room
  • Dining Room: Formal Dining Room
  • Living Sq Ft: 1053
  • Stories: 1
  • Full Bathrooms: 2
  • Total Bedrooms: 3

Exterior Features

  • Roof: Tile

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Attached Garage

Utilities

  • Cooling System: Central AC
  • Heating System: Central Forced Air
  • Sewer/Septic System: Sewer - Public

Lot Info

  • Parcel Number: 497-40-019
  • Lot Acres: 0.1128
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 4913.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 4913.00

Multi Family

  • Utilities: Public Utilities

MLS Schools

  • High School District Text: East Side Union High

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Closed on
May 5, 2024
Sold by
Bought by
Current Estimated Value
$1,040,054

Purchase Details

Closed on
Aug 6, 2019
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$671,000
Interest Rate
0.0373%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jun 11, 2018
Closed on
Aug 7, 2018
Sold by
Bought by
Seller's Agent
Alan Huynh
Redfin
Buyer's Agent
Tong Lim
Giant Realty Inc.
List Price
$768,000
Sold Price
$770,000
Premium/Discount to List
$2,000
0.26%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.87%
Original Mortgage
$679,650
Interest Rate
0.045%
Mortgage Type
New Conventional

Purchase Details

Listed on
May 7, 2012
Closed on
Jul 6, 2012
Sold by
Bought by
Seller's Agent
Colleen Rose
Coldwell Banker Realty
List Price
$369,900
Sold Price
$380,000
Premium/Discount to List
$10,100
2.73%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
12.30%
Original Mortgage
$373,117
Interest Rate
0.037%
Mortgage Type
FHA

Purchase Details

Closed on
Dec 18, 2009
Sold by
Bought by

Purchase Details

Closed on
Oct 6, 2009
Sold by
Bought by

Purchase Details

Closed on
Oct 1, 2009
Sold by
Bought by

Purchase Details

Closed on
Aug 26, 2005
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$468,000
Interest Rate
0.0662%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Feb 7, 2000
Sold by
Bought by
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
-- None Listed On Document
-- Chicago Title Company
$770,000 Ornage Coast Title Co Of Nor
$380,000 North American Title Company
$350,000 Fidelity National Title Co
-- Fidelity National Title Co
-- Fidelity National Title Co
$250,000 Fidelity National Title Co
$585,000 Financial Title Company
-- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Previous Owner $640,000
Previous Owner $671,000
Previous Owner $679,650
Previous Owner $373,117
Previous Owner $468,000
Previous Owner $190,000
Previous Owner $162,400
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/14/2018 08/14/18 Sold $770,000 +0.3% $731 / Sq Ft
07/13/2018 07/13/18 Pending -- -- --
06/11/2018 06/11/18 For Sale $768,000 +102.1% $729 / Sq Ft
07/13/2012 07/13/12 Sold $380,000 +2.7% $361 / Sq Ft View Prior Sale
05/21/2012 05/21/12 Pending -- -- --
05/18/2012 05/18/12 For Sale $369,900 0.0% $351 / Sq Ft
05/17/2012 05/17/12 Pending -- -- --
05/07/2012 05/07/12 For Sale $369,900 -- $351 / Sq Ft
Source: MLSListings

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $12,343 $858,944 $669,309 $189,635
2024 $12,343 $842,103 $656,186 $185,917
2023 $12,203 $825,592 $643,320 $182,272
2022 $11,919 $809,405 $630,706 $178,699
2021 $11,894 $793,536 $618,340 $175,196
2020 $10,730 $723,000 $563,300 $159,700
2019 $11,074 $770,000 $600,000 $170,000
2018 $6,667 $411,256 $329,006 $82,250
2017 $6,580 $403,193 $322,555 $80,638
2016 $6,260 $395,288 $316,231 $79,057
2015 $6,134 $389,351 $311,481 $77,870
2014 $5,609 $381,725 $305,380 $76,345
Source: Public Records

Agents Affiliated with this Home

  • A

    Seller's Agent in 2018

    Alan Huynh

    Redfin

    Section Image

  • T

    Buyer's Agent in 2018

    Tong Lim

    Giant Realty Inc.

    Section Image

  • C

    Seller's Agent in 2012

    Colleen Rose

    Coldwell Banker Realty

    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81709655

MLSListings

APN: 497-40-019

California Santa Clara County San Jose 95111 Hillsdale

554 Guerra Dr, San Jose, CA

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

MLSListings Property Information © 2026 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.