186 Santa Rosa Dr, San Jose, CA 95111, USA

Property CA
, , , , , , , , , , ,
1

Property Overview:

2017 N Winery Ave is a condominium in Fresno, CA 93703. The property features a 24,439 sq. ft. building with 52 bedrooms and 28 bathrooms. The estimated home value is $1,189,730. The home was originally built in 1959 and underwent a complete rebuild in 1999 after a fire, retaining only a few original walls. The featured unit is a 3-bedroom, 2-bathroom home with 1,123 sq. ft. of living space.

Neighborhood Highlights:

  • Nearby Schools:

    • Sierra Charter School
    • Fresno County Community School
    • Ericson Elementary School

  • Shopping & Dining:

    • Grocery stores: SUPERVALU, Kroger-Wesco Foods, G Mart
    • Coffee shops: Starbucks, Valley Coffee
    • Restaurants: Subway, Great Moon Buffet, Taco Bell

  • Parks & Recreation:

    • Reedy Park
    • Carozza Park
    • Oso de Oro II Park

  • Convenient Location:

    • Close to Solari Plaza and supermarkets
    • Easy access to highways 101, 280, and 680

Property Features:

  • 3 bedrooms, 2 bathrooms
  • 1,123 sq. ft. of living space
  • Laminate (Pergo) flooring throughout
  • Tiled kitchen floor
  • Central heating and air conditioning
  • Kitchen:
    • Cherry cabinets
    • Granite countertops
    • Custom backsplash
    • Gas stove
  • Updated bathrooms with modern finishes
  • Garage with polished epoxy floors
  • Low-maintenance landscaping
  • Move-in ready condition
  • Offered as-is (approved short sale)
  • Brokered by: Prudential California Realty, Listing Agent: Elizabeth N. Nguyen

Location Benefits:

  • Ideal for first-time home buyers or investors
  • Commuter-friendly with quick access to major highways
  • Close to schools, shopping, dining, and parks
  • Classic charm with modern construction due to 1999 rebuild
  • Comparable nearby homes:
    • 4747 N Woodrow Ave #124
    • 4718 E Alamos Ave #106
    • 4811 N Winery Cir #113
2

Price and Status History

date type price
1998-10-06 For Sale 249950
1998-11-17 Sold 247000
1998-12-31 Sold 247000
2006-08-14 Sold 550000
2010-10-17 Sold 299000
2011-05-16 Sold 320000
2022-02-20 Off Market NaN
2022-05-12 Sold 990000
2022-07-11 Off Market 2866500
2024-08-21 For Sale 1099000
2024-11-13 For Sale NaN
2024-11-14 Pending NaN
2024-11-28 Pending NaN
2024-12-13 For Sale NaN
2024-12-28 Pending 299000
2025-01-23 Sold 1100500
2025-01-27 Sold 1100255
3

Superfund Enterprise Management System

No data found within 1.0 miles for this property.

Toxic Release Inventory

FACILITY NAME ADDRESS TOTAL FORMS LAST FORM YEAR RISK SCREENING FACILITY ID DISTANCE (MILES)
GRANITE ROCK CAPITOL PLANT 100 Granite Rock Way, San Jose, CA 95136-1304, USA 2 2017 N/A 9513WGRNTR1GRAN 0.8

Integrated Compliance Information System - Air

No data found within 1.0 miles for this property.

4

Flood Risk Info

fld_zone very high impact: up to 0.0001 miles high impact: up to 0.2 miles moderate impact: up to 0.5 miles low-moderate impact: up to 1.5 miles
A 0 0 0 0
AE 0 0 0 13
AH 0 0 0 0
AO 0 0 0 0

Flood Zone Type

code meaning
A 1% annual chance flood zone determined using approximate methods. No BFEs shown. Flood insurance and management standards apply.
AE 1% annual chance flood zone determined by detailed methods. BFEs shown. Insurance and floodplain management required.
AH Shallow flooding (ponding) zones with depths between 1-3 feet. BFEs shown. Insurance and management required.
AO Shallow flooding (sheet flow) zones with depths 1-3 feet. BFEs or average depths shown. High-velocity areas may exist.

Earthquake Risk Info

zone_name quad_name very high impact: up to 0.0001 miles high impact: up to 2.0 miles moderate impact: up to 10.0 miles
Central Calaveras Calaveras Reservoir 0 0 0
Central Calaveras Lick Observatory 0 0 1
Central Calaveras San Jose East 0 0 0
South Hayward Calaveras Reservoir 0 0 3
South Hayward Lick Observatory 0 0 1
South Hayward San Jose East 0 0 3

Landslide Risk Info

lscat very high impact: up to 0.0001 miles high impact: up to 0.04 miles moderate impact: up to 0.1 miles low-moderate impact: up to 0.2 miles
8 0 0 0 0

Liquefaction Risk Info

Suscept very high impact: up to 0.0001 miles high impact: up to 0.05 miles moderate impact: up to 0.5 miles low-moderate impact: up to 1.0 miles
High 0 0 0 0
Very high 0 0 0 0

Wild fire Risk Info

haz_class very high impact: up to 0.0001 miles high impact: up to 0.5 miles moderate impact: up to 1.5 miles low-moderate impact: up to 3.0 miles
High 0 0 0 0
Very High 0 0 0 0
5

Traffic Noise by Hour x Weekday

Not enough data points

6

Airplane Noise by Hour x Weekday

hour_of_day Monday Tuesday Wednesday Thursday Friday Saturday Sunday
0 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1
2 0 1 1 1 1 1 1
3 1 1 1 1 1 1 1
4 0 1 0 1 1 5 0
5 1 1 1 1 1 4 1
6 1 1 2 2 2 2 1
7 3 3 3 4 2 2 3
8 5 4 5 5 6 5 4
9 5 5 6 8 8 6 7
10 9 8 9 7 9 6 8
11 9 7 8 8 8 9 10
12 7 8 9 9 10 7 7
13 8 8 11 10 8 8 7
14 6 8 9 9 9 7 5
15 7 6 9 6 8 5 7
16 8 7 8 8 7 6 7
17 6 5 6 7 7 4 6
18 5 5 5 7 5 3 4
19 4 5 4 6 4 3 2
20 3 3 3 3 3 1 2
21 3 2 3 3 3 1 3
22 2 2 1 2 2 1 1
23 1 1 1 1 1 1 1