---
listing_id: ML81976645
status: Closed
price: 1780000
beds: 0
baths_full: 0
baths_half: 0
sqft_living: 1983
sqft_lot: 7095
lot_acres: 
year_built: 1947
property_type: Residential Income
property_subtype: Duplex
address: "474 N Bayview Ave"
city: Sunnyvale
state: CA
zip: 94085
county: "Santa Clara County"
lat: 37.386275
lng: -122.022382
days_on_market: 625
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Stephen Guzzetti"
list_office: "Intero Real Estate Services"
list_agent_phone: "(408) 393-4647"
list_agent_license: 01777838
mls_source: MLSL
modified: 2026-02-02
transaction_type: recentlySold
---

Home | Santa Clara County | Sunnyvale | 94085 | 474 N Bayview Ave

474 N Bayview Ave, Sunnyvale, CA 94085

MLS: ML81976645 | Status: Sold | Price: $1,780,000
Beds/Baths: – / –
Property Type: Residential Income

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
1,983 7,095 1947

Remarks

Fantastic Turnkey Investment Opportunity In One of The Hottest Rental Submarkets in The Bay Area! Perfect for the Cash Flow Investor or an Owner User, as this property boasts a 3 bedroom 2 bath front unit and a 2 bedroom 1 bath rear unit. Large ~7,000 sq.ft Lot in a Rapidly Gentrifying Neighborhood. Expansive-Open Concept floor plan in 474. Both units have newer Higher End Finishes featuring: Granite and Tile Counter Tops, Laminate and Tile Flooring in main areas and Carpeting in the spacious Bedrooms. Glass Tile Backsplash, Stainless Appliances, Upgraded Cabinets and In House Laundry. Dual Pane Windows, Copper Plumbing, Wall Heaters! Front Porches. Completely re-done Electrical system in both units. New exterior and interior paint. New good neighbor fence. Recessed lighting. New front yard landscaping. Two Car Garage with newer Concrete Driveway. Best Of All....Location; Facebook=11mi. Location; Apple 2=1.1mi. Location; CalTrain=1.0mi. Location; LinkedIn=.7mi. Location; SC Square=3.8mi. Location; Moffett Towers=2.2mi.

MLS Listing Information

Field Value
MLS # ML81976645
MLS Source MLSListings, Inc.

Features

Interior Features

Feature Details
Kitchen Countertop - Synthetic, Countertop - Tile, Hookups - Gas
Appliances Dishwasher, Garbage Disposal, Hood Over Range, Microwave, Oven Range - Gas, Refrigerator, Washer/Dryer
Flooring Carpet, Laminate, Tile
Laundry Hookups Only
Cooling None
Heating Wall Furnace

Exterior Features

Feature Details
Roof Composition
Foundation Concrete Perimeter

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Common Parking Area, Garage: 2 Car(s)
Elementary District Sunnyvale
High School District Fremont Union High
Sewer Public Sewer
Water Public
Zoning R2

Contact Information

Listing Agent Co-Listing Agent
Stephen Guzzetti Reid Yoshida
Intero Real Estate Services Intero Real Estate Services
License #: 01777838 License #: 02206190
Phone: (408) 393-4647 Phone: (408) 701-7268

Property Units

# Buildings # Leased Units # Total Units
2 0 2

Unit Details

Unit # Sq Ft Beds Baths Rent
1 1,292 3 2/0 $3,800
2 691 2 1/0 $2,900

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Bishop Elementary School public K-5 0.13 mi 7
Columbia Middle School public 6-8 0.50 mi 6
San Miguel Elementary School public K-5 0.81 mi 5
Ellis Elementary School public K-5 1.18 mi 7
Lakewood Elementary School public K-5 1.28 mi 6
Vargas Elementary School public K-5 1.45 mi 3
Braly Elementary School public K-5 1.51 mi 9
Cumberland Elementary School public K-5 1.80 mi 10
Ponderosa Elementary School public K-5 1.81 mi 9
Fairwood Elementary School public K-5 1.86 mi 9
Jose Antonio Vargas Elementary public K-5 2.21 mi 8
Slater Special Education Preschool public UG 2.25 mi N/A
Mission Early College High public 9-12 2.27 mi 10
Sunnyvale Middle School public 6-8 2.33 mi 9
Cherry Chase Elementary School public K-5 2.34 mi 10
Adult And Community Education public UG 2.39 mi N/A
Fremont High School public 9-12 2.41 mi 9
Adrian Wilcox High School public 9-12 2.46 mi 8
Community Day School public 9-12 2.46 mi N/A
North County Regional Occupational Program School public 9-12 2.46 mi N/A

Disclosures

©2026 MLSListings Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of February 02, 2026. For the most current information, please contact Stephen Guzzetti, (408) 393-4647.