Santa Clara County property record for 404 Shamrock Dr, Campbell, CA 95008
| Property Type | Single Family Home |
|---|---|
| Details | 3 bd · 1 ba · 1,659 sqft · built 1947 |
| Lot Size | 0.241 acres (10,500 sqft) |
| Owner | Individual Name on File |
| Last Sale | $2,256,000 (Jun 2026) |
| Tax Bill | $16,321 (2025) |
| Deeds & Mortgages | Jun 2026 Sale & Mortgage Dec 2020 Transfer |
| Flood Zone | Zone D (undetermined) |
| APN | 414-04-034 |
| Primary APN | 414-04-034 |
|---|
| Bedrooms | 3 Beds |
|---|---|
| Full Baths | 1 Bath |
| Total Rooms | 5 Rooms |
| Stories | 1 Story |
| Building Area | 1,659 sqft Living Area |
| 1st Floor Area | 1,659 sqft |
| Fireplaces | 1 Fireplace |
| Fireplace | Fireplace |
| Year Built | Built 1947 |
|---|---|
| Effective Year Built | Effective 1947 |
| Architectural Style | Custom Design |
| Exterior Material | Stucco |
| Construction Type | Wood |
| Roof Material | Composition Shingle |
| Lot Area | 10,500 sqft (0.241 acres) |
| Lot Dimensions | 175 ft deep x 60 ft wide |
| Garage Area | 520 sqft |
| Parking Spaces | 2 Parking Spaces |
| Pool Type | Pool with Hot Tub/Spa |
| Porch | Porch |
| Cooling System | None |
|---|---|
| Sewer | Municipal |
| Water Source | Commercial |
| Street Address | 404 SHAMROCK DR |
|---|---|
| City | CAMPBELL |
| State | CA |
| Zip | 95008-6116 |
| Property Category | Residential |
| Property Type | Residential > Single Family > Home |
| Local Zoning Code | R1-8 |
| Legal Description | TRACT 287 ELLEN ACRES BOOK 10 PAGE 54 LOT 68 |
| Legal Subdivision | ELLEN ACRES |
| Legal Tract | 287 |
| Legal Lot Number | 68 |
| Jurisdiction | SANTA CLARA CA |
| Township / Civil Division | SAN JOSE |
| Census Block Group | 3 |
| Census Block | 3009 |
| Census Tract | 502701 |
Source: Santa Clara County records · APN 414-04-034
Assessment roll updated August 11, 2025 · Last verified June 2026
Owner names and exact recorded amounts shown locked on this page are available instantly with a free trial.
| Owner of Record | Individual Name on File |
|---|---|
| Mailing Address | 404 SHAMROCK DR, CAMPBELL, CA 95008-6116 |
| Occupancy | Owner Occupied |
| Owner Type | Individual |
| Vesting | Community Property |
| Date | Document |
|---|---|
| Jun 12, 2026 | Grant Deed, Transfer · Conventional Mortgage FREMONT BANK |
| Dec 17, 2020 | Quit Claim Deed, Transfer NOT AVAILABLE |
| Deed Names | Verified Name on Deed |
|---|---|
| Last Sale | Jun 12, 2026 · Amount on Record |
| Deed Sale | Jun 12, 2026 · Amount on Record |
| Prior Sale | Oct 24, 2013 · Amount on Record |
| Deed Document Number | 202626003639 |
| Prior Transfer Date | Dec 10, 2020 |
| Prior Transfer Doc | 0024753974 |
| Record Updated | Sep 20, 2026 |
| Document Type | Grant Deed |
|---|---|
| Jurisdiction | SANTA CLARA CA |
| Recording Date | Jun 12, 2026 |
| Property Address | 404 SHAMROCK DR, CAMPBELL, CA 95008-6116 |
| Document Number | 0026003639 |
| Instrument Date | May 27, 2026 |
| Instrument | 202626003639 |
| Transaction Type | Transfer |
| Record Updated | Jun 18, 2026 |
| Title Company | CORNERSTONE TITLE COMPANY |
| Amount | Amount Recorded |
|---|---|
| Downpayment | Downpayment on File |
| Loan-to-Value (LTV) | LTV on Record |
| Tax | $250,641.60 |
| Amount Accuracy | Full Amount Stated |
| Additional |
|
| Name | Verified Name |
|---|
| Name | Verified Name |
|---|---|
| Relationship | Community Property |
| Address | 404 SHAMROCK DR, CAMPBELL, CA 95008-6116 |
| Investor | Possibly a Property Investor |
| Document Number | 0000003640, |
|---|---|
| Date | Jun 12, 2026 |
| Instrument | 20263640 |
| Name | FREMONT BANK |
|---|
| Type | Conventional Mortgage |
|---|---|
| Amount | Amount Recorded |
| Term | 360 Months |
| Due | Jul 01, 2056 |
| Rate Type | Adjustable Rate |
|---|---|
| Rate | 5.38% |
| Initial Type | Adjustable Rate |
| Adjustable | Adjustable Rate Rider |
| Max Rate | -1% |
| Document Type | Quit Claim Deed |
|---|---|
| Jurisdiction | SANTA CLARA CA |
| Recording Date | Dec 17, 2020 |
| Property Address | 404 SHAMROCK DR, CAMPBELL, CA 95008-6116 |
| Document Number | 0024753974 |
| Instrument Date | Nov 27, 2020 |
| Instrument | 24753974 |
| Transaction Type | Transfer |
| Record Updated | Dec 30, 2020 |
| Title Company | NOT AVAILABLE |
| Tax | $0.00 |
|---|---|
| Additional |
|
| Name | Verified Name |
|---|
| Name | Verified Name |
|---|---|
| Relationship | Revocable Trust |
| Address | 404 SHAMROCK DR CAMPBELL CA 950086116, CAMPBELL, CA 95008-6116 |
Source: Santa Clara County records · Assessment roll updated August 11, 2025 · Last verified June 2026
| Type | Name |
|---|---|
| State | California |
| County | Santa Clara County |
| Municipality | Campbell City |
| Elementary School District | Cambrian Elementary School District (KG - 08) |
| Secondary School District | Campbell Union High School District (09 - 12) |
Assessed value is set for property tax purposes and is not a market price estimate.
| Year | Tax Bill | Assessed Value |
|---|---|---|
| 2025 | $16,321.00 (+1.56%) Homeowner's exemption | $1,205,400 (+4.04%) Land $817,033 Building $388,367 |
| 2023 | $16,070.00 (+1.63%) Homeowner's exemption | $1,158,594 Land $785,307 Building $373,287 |
| 2022 | $15,812.00 |
Source: FEMA National Flood Hazard Layer as of January 18, 2026 · USDA Forest Service Wildfire Risk to Communities as of 2024 · Last verified October 2026
| FEMA Flood Zone | Zone D undetermined · not studied |
|---|---|
| Flood Insurance Requirement | Not required lenders may require it |
| Wildfire Risk | Not rated no burnable land within ember reach |
|---|
Values are read at the parcel center point; lenders make the official flood determination.
Source: FCC Broadband Data Collection as of December 31, 2025 · Last verified October 2026
| Provider | Max Down / Up (Mbps) |
|---|---|
| Xfinity Cable | 2,000 / 250 |
| Verizon Fixed Wireless | 300 / 20 |
| Etheric Communications, LLC. Fixed Wireless | 250 / 100 |
| AT&T DSL · Fiber in parts of the area | 100 / 20 |
May also be available: California Internet, Ridge Wireless, Sail Internet Holdings, T-Mobile USA.
Based on FCC filings for 658 locations within half a mile of this property.
Source: EPA Safe Drinking Water Information System as of 2026 Q3 · EPA water system boundaries as of March 2026 · Last verified October 2026
| Water System | SAN JOSE WATER private · serves 1,039,920 people |
|---|---|
| Water Source | Surface water |
| Last State Inspection | Mar 2026 |
| Lead | Under 1 ppb (2023–2025) action level 15 ppb |
| Water Quality | Treatment failure resolved · Jun 2023 |
|---|---|
| Treatment and Procedure | None last 10 years |
| Monitoring and Reporting | None last 3 years |
Results are for the whole water system as reported to EPA, not water tested at this address; lead at the tap also depends on the building's own pipes. The full violation and enforcement history is in the system's EPA record.
Search by:
By searching, you agree to: Terms • Privacy • Disclosures