Skip main navigation
Sold for $425,000
  • $425,000

    174 Sullivan Dr, Merced, CA 95348

    4beds
    3baths
    1,919sqft
    Residential, Single Family Residence
    Built in 2021
    2,443 Square Feet Lot
    $408,600 Zestimate®
    $221/sqft
    $2,196 Estimated rent

    Home value

    $408,600

    $388,000 - $429,000

    $2,196/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $2,196/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

    $2,196/mo

    Rent Zestimate®

    Refinance and save

    $2,744/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

    $2,744/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Your new home is awaiting! Built in 2021, this spacious 4/bed 2.5/bath home is located in the coveted Bellevue Ranch area. The front of the house is adorned with shutters, attractive stone , a unique tandem 2 car garage for space saving. Solar and water softener system with reverse osmosis included. It is in close proximity to UC Merced, Merced College, Mercy Hospital, shopping centers and restaurants to name a few. The home has been recently upgraded with new laminate flooring and a fresh coat of paint. The kitchen opens to the family room, and it features granite countertops, pantry, stainless steel appliances with gas range stove, shaker door cabinets, and eating area. Upstairs you will find all bedrooms are privately located as well as a bonus loft with a potential to turn into a workspace. The main bedroom has ample room with a spacious bathroom, walk in closet ,dual vanities and a large walk-in shower. The hall bathroom has dual sink vanities and a shower over tub. Need a low Maintenace yard? No problem, this house has it. Don't pass up this opportunity to own this charming home, schedule your showing before it's gone!

    Zillow last checked:

    Listing updated:

    Listed by:

    Georgina S Loera Enriquez,

    Rod Aluisi Real Estate

    Bought with:

    Nonmember Nonmember

    Nonmember

    Source: Fresno MLS,MLS#: 597511Originating MLS: Fresno MLS

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    Primary bedroom
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 1
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 2
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 3
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 4
    • Area: 0
    • Dimensions: 0 x 0
    Bathroom
    • Features: Tub/Shower, Shower
    Dining room
    • Features: Formal
    • Area: 0
    • Dimensions: 0 x 0
    Family room
    • Area: 0
    • Dimensions: 0 x 0
    Kitchen
    • Features: Pantry
    • Area: 0
    • Dimensions: 0 x 0
    Living room
    • Area: 0
    • Dimensions: 0 x 0
    Basement
    • Area: 0
    Heating
    • Has Heating (Unspecified Type)
    Cooling
    • Central Air
    Appliances
    • Included: Gas Appliances, Disposal, Dishwasher, Microwave, Refrigerator, Water Softener, Water Filter
    • Laundry: Inside, Upper Level
    Features
    • Loft
    • Flooring: Carpet, Laminate, Tile
    • Has fireplace: No
    Interior area
    • Total structure area: 1,919
    • Total interior livable area: 1,919 sqft

    Property

    Parking
    • Parking features: Garage - Attached, Open
    • Has attached garage: Yes
    • Has uncovered spaces: Yes
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Uncovered, Concrete
    • Fencing: Fenced
    Lot
    • Size: 2,443 Square Feet
    • Dimensions: 2,444
    • Features: Urban, Sprinklers In Front, Sprinklers Auto
    Details
    • Parcel number: 230081006000
    • Zoning: P-D

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Residential, Single Family Residence
    Materials
    • Stucco, Wood Siding, Brick, Stone
    • Foundation: Concrete
    • Roof: Composition
    Condition
    • Year built: 2021
    Details
    • Builder name: Bellevue Ranch West Village 2 Lot 97

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Public Utilities, Propane

    Community & HOA

    Location
    • Region: Merced

    Financial & listing details

    • Price per square foot: $221/sqft
    • Tax assessed value: $442,170
    • Date on market: 7/20/2023
    • Cumulative days on market: 97 days
    • Listing agreement: Exclusive Right To Sell

    Price history

    DateEventPrice
    9/24/2026Listing removed$2,000$1/sqft
    Source: Zillow Rentals Report a problem
    8/17/2026Price change$2,000-4.5%$1/sqft
    Source: Zillow Rentals Report a problem
    8/7/2026Price change$2,095-4.6%$1/sqft
    Source: Zillow Rentals Report a problem
    6/29/2026Price change$2,195-4.6%$1/sqft
    Source: Zillow Rentals Report a problem
    6/11/2026Listed for rent$2,300+12.2%$1/sqft
    Source: Zillow Rentals Report a problem
    3/3/2024Listing removed--
    Source: Zillow Rentals Report a problem
    2/15/2024Price change$2,050-6.8%$1/sqft
    Source: Zillow Rentals Report a problem
    12/13/2023Price change$2,200-15.4%$1/sqft
    Source: Zillow Rentals Report a problem
    12/8/2023Listed for rent$2,600$1/sqft
    Source: Zillow Rentals Report a problem
    11/30/2023Sold$425,000-2.3%$221/sqft
    Source: Fresno MLS #597511 Report a problem
    11/11/2023Pending sale$435,000$227/sqft
    Source: Fresno MLS #597511 Report a problem
    10/29/2023Price change$435,000-1.1%$227/sqft
    Source: MetroList Services of CA #223068139 Report a problem
    10/4/2023Price change$440,000-1.1%$229/sqft
    Source: Fresno MLS #597511 Report a problem
    8/2/2023Price change$445,000-1.1%$232/sqft
    Source: MetroList Services of CA #223068139 Report a problem
    7/20/2023Listed for sale$450,000-4.2%$234/sqft
    Source: MetroList Services of CA #223068139 Report a problem
    7/1/2022Listing removed--
    Source: MetroList Services of CA #222072935 Report a problem
    6/3/2022Listed for sale$469,900+47.1%$245/sqft
    Source: MetroList Services of CA #222072935 Report a problem
    2/26/2021Sold$319,500$166/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2026-- $442,170 +2%
    2025$6,618 +4.7%$433,500 +2%
    2024$6,320 +19%$425,000 +28.1%
    2023$5,312 +2.2%$331,892 +2%
    2022$5,199 +47.8%$325,385 +96.8%
    2021$3,518 +1111.3%$165,362 +2901.7%
    2020$290 -20.8%$5,509 +2%
    2019$367 -0.1%$5,401 +2%
    2018$367 -13.9%$5,296 +2%
    2017$426 -0.4%$5,193 +2%
    2016$428 +0.7%$5,092 +1.5%
    2015$425 $5,016 +2%
    2014$425 +0.2%$4,918 +0.4%
    2013$424 $4,896 -2.1%
    2012-- $5,000
    2011-- $5,000
    2010-- $5,000 -80%
    2009-- $25,000
    Find assessor info on the county website

    Neighborhood: 95348

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Merced
    • Middle: Merced
    • High: Merced

    Source: Fresno MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $408,600
    2% more
    +$8,172
    With Zillow Showcase(estimated)

    $416,772

    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $408,600
    2% more
    +$8,172
    With Zillow Showcase(estimated)

    $416,772