Skip main navigation
Off market
  • $2,004,000

    38123 Holland Ave, Fremont, CA 94536

    4beds
    2,226sqft
    SingleFamily
    Built in 1960
    6,433 Square Feet Lot
    $2,004,000 Zestimate®
    $900/sqft
    $4,798 Estimated rent

    Owner options

    List your home for rent

    $4,798/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,798/mo

    Rent Zestimate®

    Refinance and save

    $12,705/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $12,705/mo

    Est. payment

    What's special

    Charming, spacious upgraded home in Parkmont. Cleanliness sparkles throughout! Located in a quiet court across street from Park entrance. 2 master bedrooms, one upstairs and the other downstairs. New hardwood floor in large living room. Extra large additional Family room. Elegant stone fireplace, floor to ceiling. 8 foot sit down hearth. In separate area of room, there is plumbing set up for bar area. Skylight in updated kitchen, dining area. Immaculate yard with sprinklers, copper piping throughout, 2 large patios, walkways, concrete pavers with Hot Tub. New colored concrete driveway, new large front porch. Community pool, Centrally located close to Bart, Medical facilities, shopping centers, Whole foods & Downtown area. Easy access to Freeway 880/680 and CA-84.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 3
    Heating
    • Forced air, Gas
    Appliances
    • Included: Dryer, Garbage disposal, Microwave, Range / Oven, Refrigerator, Washer
    • Laundry: Gas Dryer Hookup, In Garage, Dryer, Washer
    Features
    • Flooring: Tile, Carpet, Hardwood, Laminate
    • Number of fireplaces: 2
    Interior area
    • Total interior livable area: 2,226 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stucco, Wood
    • Has spa: Yes
    • Has view: Yes
    • View description: Territorial
    Lot
    • Size: 6,433 sqft
    Details
    • Parcel number: 501153531

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • wood frame
    • Roof: Other
    Condition
    • Year built: 1960

    Community & neighborhood

    Location
    • Region: Fremont

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $45 monthly

    Other

    Other facts
    • Class: RESIDENTIAL
    • BATH-MASTER INCLUDES: Stall Shower, Updated Baths
    • BATH NON-MSTR INCLUDE: Shower Over Tub, Updated Baths, Stall Shower
    • CONSTRUCTION STATUS: Existing
    • EXTERIOR: Stucco, Wood Siding, Dual Pane Windows
    • HEATING: Forced Air 1 Zone, Gas
    • KITCHEN FEATURES: 220 Volt Outlet, Electric Range/Cooktop, Garbage Disposal, Range/Oven Free Standing, Microwave, Counter - Solid Surface, Refrigerator, Updated Kitchen, Self-Cleaning Oven, Skylight(s)
    • LOT DESCRIPTION: Level
    • ROOM - ADDITIONAL: Family Room
    • WATER/SEWER: Sewer System - Public, Water - Public
    • YARD DESCRIPTION: Patio, Sprinklers Back, Sprinklers Front, Back Yard, Sprinklers Automatic, Fenced, Front Yard, Side Yard, Tool Shed
    • Garage (Y/N): Yes
    • Source: Public Records
    • Stories: Two Story
    • EQUIPMENT ADDITIONAL: DSL/Modem Line, Garage Door Opener, Water Heater Gas, Window Coverings, Mirrored Closet Door(s), Washer, Dryer
    • GARAGE/PARKING: Off Street Parking, Guest Parking, Enclosed Garage
    • LAUNDRY: Gas Dryer Hookup, In Garage, Dryer, Washer
    • STYLE: Traditional
    • FLOORING: Hardwood Floors, Laminate, Tile, Carpet
    • LEVEL - UPPER: 2 Bedrooms, 1 Bath
    • PETS: Allowed - Yes
    • ROOF: Other
    • HOA Fees Freq: Monthly
    • HOA: Yes
    • LEVEL - STREET: Main Entry, 2 Baths, Master Bedrm Suite - 1, 2 Bedrooms
    • VIEWS: Hills
    • COOLING: Ceiling Fan(s)
    • Pool (Y/N): Yes
    • HOA AMENITIES: Greenbelt, Pool, Security Gate
    • City: FREMONT
    • POOL: Community Fclty, Electric Heat, Hot Tub
    • DISABLED FEATURES: Disabled Bath Feat
    • FIREPLACES: 2
    • List Date: 2020-02-27
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,004,000