174 Sullivan Dr, Merced, CA 95348
OFF MARKET

174 Sullivan Dr
Merced, CA 95348

  • 4 Beds
  • 3 Baths
  • 1,919 sqft

$424,200

Trulia Estimate
as of May 11, 2026
Est. Refi. Payment $2,492/mo*
Refinance Your Home

$424,200

Trulia Estimate
as of May 11, 2026
Est. Refi. Payment $2,492/mo*
Refinance Your Home
4 Beds
3 Baths
1,919 sqft

Homes for sale near 174 Sullivan Dr

Skip to last item
Skip to first item

Apartments for Rent

Skip to last item
Skip to first item

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

Description

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!
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from December 01, 2023

Home Highlights

Parking
Attached Garage
Outdoor
Yes
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago

Home Details for 174 Sullivan Dr

Interior Features

Interior Details
Number of Rooms: 11Types of Rooms: Master Bedroom, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bathroom, Dining Room, Family Room, Kitchen, Living Room, Basement
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 3
Dimensions and Layout
Living Area: 1919 Square Feet
Appliances & Utilities
Utilities: Public Utilities, PropaneAppliances: Gas Appliances, Disposal, Dishwasher, Microwave, Refrigerator, Water Softener, Water FilterDishwasherDisposalLaundry: Inside,Upper LevelMicrowaveRefrigerator
Heating & Cooling
Heating: Has Heating Unspecified TypeHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Has Heating Unspecified Type
Fireplace & Spa
No Fireplace
Windows, Doors, Floors & Walls
Flooring: Carpet, Laminate, Tile
Levels, Entrance, & Accessibility
Stories: 2Levels: TwoFloors: Carpet, Laminate, Tile

Exterior Features

Exterior Home Features
Roof: CompositionPatio / Porch: Uncovered, ConcreteFencing: FencedFoundation: ConcreteNo Private Pool
Parking & Garage
No CarportHas a GarageHas an Attached GarageHas Open ParkingParking: Garage Attached, Open
Frontage
Not on Waterfront
Water & Sewer
Sewer: Public Sewer

Days on Market

Cumulative Days on Market: 97

Property Information

Year Built
Year Built: 2021
Property Type / Style
Property Type: ResidentialProperty Subtype: Residential, Single Family Residence
Building
Construction Materials: Stucco, Wood Siding, Brick, Stone
Property Information
Parcel Number: 230081006000

Price & Status

Price
List Price: $435,000

Active Status

MLS Status: Sold

Location

Direction & Address
City: Merced
School Information
Elementary School: MercedJr High / Middle School: MercedHigh School: MercedHigh School District: Merced

Building

Building Details
Builder Name: Bellevue Ranch West Village 2 Lot 97
Building Area
Building Area: 1919 Square Feet

Community

Not Senior Community

HOA

Association for this Listing: Fresno MLS

Lot Information

Lot Area: 2443.716 sqft

Documents

Disclaimer: Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.

Offer

Listing Agreement Type: Exclusive Right To Sell

Miscellaneous

Mls Number: 597511
Last check for updates: about 12 hours ago
Listed by Georgina S Loera Enriquez
Rod Aluisi Real Estate
Bought with: Nonmember Nonmember, Nonmember
Originating MLS: Fresno MLS
Source: Fresno MLS, MLS#597511

Price History for 174 Sullivan Dr

DatePriceEventSource
03/03/2024ListingRemovedZillow Rentals
02/15/2024$2,050PriceChange
Zillow Rentals
12/13/2023$2,200PriceChange
Zillow Rentals
12/08/2023$2,600Listed For RentZillow Rentals
11/30/2023$425,000Sold
Fresno MLS #597511
11/11/2023$435,000PendingFresno MLS #597511
10/29/2023$435,000PriceChange
MetroList Services of CA #223068139
10/04/2023$440,000PriceChange
Fresno MLS #597511
08/02/2023$445,000PriceChange
MetroList Services of CA #223068139
07/20/2023$450,000Listed For SaleMetroList Services of CA #223068139
07/01/2022ListingRemovedMetroList Services of CA #222072935
06/03/2022$469,900Listed For SaleMetroList Services of CA #222072935
02/26/2021$319,500Sold
N/A
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$6,618
Assessment$433,500
Home facts updated by county records

Comparable Sales for 174 Sullivan Dr

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
339 Bale Mill Rd, Merced, CA
0.17
Single-Family Home
$400,000
07/09/25
4
3
1,760
4222 Pecota Ct, Merced, CA
0.10
Single-Family Home
$370,000
11/07/25
3
2.5
1,440
4214 Berryesa Ave, Merced, CA
0.08
Single-Family Home
$404,000
06/25/25
3
2.5
1,555
377 Shafer Ave, Merced, CA
0.17
Single-Family Home
$369,000
04/28/26
3
3
1,440
4315 Strathmore Pl, Merced, CA
0.16
Single-Family Home
$425,000
05/01/26
4
2
1,836
4346 Bixby Way, Merced, CA
0.18
Single-Family Home
$439,000
07/29/25
3
2
1,455
453 Glendon Pl, Merced, CA
0.24
Single-Family Home
$458,000
08/28/25
4
2
1,727
4373 Strathmore Pl, Merced, CA
0.20
Single-Family Home
$435,000
08/21/25
3
3
1,580
4371 Briggs Ln, Merced, CA
0.40
Single-Family Home
$365,000
10/27/25
3
2.5
1,469
4349 Wickson Pl, Merced, CA
0.29
Single-Family Home
$430,000
12/23/25
4
2
1,640

Assigned Schools

These are the assigned schools for 174 Sullivan Dr.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Merced

At least 524 Trulia users voted on each feature.

  • 86 % Say there are sidewalks

  • 82 % Say yards are well-kept

  • 82 % Say it's dog friendly

  • 80 % Say parking is easy

  • 78 % Say car is needed

  • 72 % Say there's holiday spirit

  • 63 % Say kids play outside

  • 56 % Say it's quiet

  • 55 % Say it's walkable to grocery stores

  • 54 % Say streets are well-lit

  • 51 % Say they plan to stay for at least 5 years

  • 49 % Say neighbors are friendly

  • 47 % Say it's walkable to restaurants

  • 44 % Say people would walk alone at night

  • 26 % Say there's wildlife

  • 22 % Say there are community events

Learn more about our methodology.
  • Dessuarez2003
    "Merced station specifically is so amazing! So excited to be renewing here! This community has been a great place to live, and the by-bedspace leasing makes it easy for me to save money while focusing on my studies. The environment is comfortable, the amenities are convenient, and everyone here is genuinely friendly. I’m really happy to call this place home for another year! "
    0
    Flag
  • Jamangel1
    "Lots of new builds coming soon to the area. There are parks and new stores and a new school being built in the next few years."
    1
    Flag
  • Jamangel1
    "Great place to live. Lots of walking trails , close to shops and restaurants, easy freeway access, and expressway to UCM. "
    0
    Flag
  • Farrah
    "Be aware of stray dogs and cats. Also people like to dump their trash in the streets, and allow their dogs to bark incessantly."
    0
    Flag
  • Salvador Reyes
    "Always look after your kids if or when playing outside because there are many cars that drive reckless here and pass by speeding"
    3
    Flag
  • Trulia User
    "The parks and big open spaces like fileds and the mellowness around the area, can’t wait for more parks to become available "
    0
    Flag
  • Jenifernigh38
    "ny home is a old beautiful Victorian built in 1900 quiet neighborhood lots of parking made for older people to just relax and enjoy life"
    9
    Flag
  • Sylvia P.
    "I stay here part time. Close to get on N99. But to get here off freeway exit, then you have to take some back roads to get to Franklin. No freeway exit to Franklin Rd."
    0
    Flag
  • Ramirez 5.
    "I love where I live it’s next to schools the grocery store has stating and the hospital. I’m hoping it stays safe. "
    1
    Flag
  • Lexus S.
    "It’s best to look for homes that are in city limits because there are islands in the city that don’t count as in city limits so they don’t have side walks or parks. "
    7
    Flag
  • Rent L.
    "Lots of open space. Lower cost of living. Slow pace and easy access to freeway 99. Many parks, lake and proximity to UC Merced. "
    0
    Flag
  • Rebecca F.
    "it's up and coming and you get the county fair flea market every Saturday and the farmers market in town for freshest meat and produce too "
    6
    Flag
  • L.donohue
    "This neighborhood has a center park, and outdoor movies night, farmers market, Christmas parade that go through the downtown areas and hiking trials that go through out the city including the city park, green spaces and water features. "
    1
    Flag
  • Jamangel1
    "There’s a park in our neighborhood within walking distance from every home. Families are always walking on the paths next to the new Campus Parkway. Soon there will be shopping and easy commute to UCMerced."
    0
    Flag
  • Elisa H.
    "Not safe area. Lived here nearly my entire life. No growth opportunity here, not a good place for family. Best thing that happens around here are the Christmas parades."
    0
    Flag
  • Angela
    "small community. chooses the right neighborhood and you will have great neighbors. introduction yourself and get to know who you love near."
    0
    Flag
  • Angela
    "I've lived in this neighborhood for three years and I like it. Picking the right neighborhood is important though so make sure to research. "
    0
    Flag
  • Pahn
    "We have movie at the park presented by the City Of Merced during the summer time. Halloween is very popular holiday. "
    0
    Flag
  • Reginald N.
    "That it is a busy area with cars . The dog park is too far from resident and that walk would be a tired some walk"
    8
    Flag
  • Annette G.
    "This is an established neighborhood where neighbors know each other and look out for each other. There are lots of trees and people like to take walks on the nearby creek path."
    0
    Flag
  • Emily G.
    "Horrible neighborhood. I’ve been broken into. I do not recommend moving here. It’s a dangerous area. "
    33
    Flag
  • Bdenatly
    "There are few small parks, but no dedicated dog parks and all dogs must stay on leash in the parks. The yards are on the small size and really only suitable for small breed dogs. "
    0
    Flag
  • Mariah M. D.
    "that everyone around are dog friendly and enjoy having there pets around the area. everyone around here walks there dogs on a daily. "
    2
    Flag
  • Luis F. M. M.
    "Love Merced is a great opportunity for community service,the Merced theatre is coming along with events that are food to be a part off "
    4
    Flag
  • Vanygonz54
    "All the neighbors watch out for each other and make sure the area is safe. I like how when one neighbor is gone they feel safe leaving due to all the neighbors having each other’s back "
    8
    Flag
  • Starlitegoddess14
    "I've lived here for 3 years . people are nice and friendly and look out for each other. safe and well maintained neighborhood"
    0
    Flag
  • Deborahlgiannone
    "There is a 5 minutes to shopping areas easily driveable. Bus pick up near. Uber and Taxi available. Senior mobile transit available."
    4
    Flag
  • Estrzartz
    "This area has lots of dog owners, and I see lots of people walking here. Everyone is very friendly, and the people who walk their dogs are really responsible for what their dogs leave behind by carrying little plastic bags!"
    8
    Flag
  • Stephanie H.
    "Merced i actually a pretty alright city to live in. There isn't a lot of social sites or things to do but the city is definitely growing and expanding into a nice place. The crime and violence has significantly decreased through out the passing years and the school all seem to do a great job with our education. It's definitely a much cleaner and nicer city than nearby areas like Fresno or Modesto. "
    5
    Flag
  • Sue J.
    "I only live 10 minutes from work. Traffic moves well,not a lot of road work or obstacles. Streets are maintained well as are sidewalks. My neighborhood is well kept and quiet. The neighborhoods surrounding me are clean and the homeowners have pride in . "
    0
    Flag
  • Cl.hairstyles
    "In my neighborhood there is a lot of access to public transportation. Is close to downtown areas and highways. Is only 15 mins to community college or UC."
    2
    Flag
  • Lynn D.
    "My neighbor has a short distant to the public transportation that go to the UC Merced. We feel safe in this neighborhood, it’s also nice and clean."
    0
    Flag
  • Lisa
    "My community has easy access to public transportation, & uber cars. Also, traffic isn’t too crazy out here! "
    1
    Flag
  • Jamangel1
    "Newer neighborhood near the Campus Parkway. Nice park in the neighborhood with schools nearby. Bike and walking areas."
    0
    Flag
  • Katherine W.
    "Dog owners should beware other of other dogs roaming freely because you don't know if that other dog will be friendly or aggressive. "
    1
    Flag
  • Lisa J.
    "You see people walking their dogs all the time. I haven't had a problem with people and their animals."
    1
    Flag

LGBTQ Local Legal Protections

Homes for rent near 174 Sullivan Dr

Skip to last item
  • Results are loading
Skip to first item

Off Market Homes Near 174 Sullivan Dr

Skip to last item
Skip to first item

Explore by feature

174 Sullivan Dr, Merced, CA 95348 is a 4 bedroom, 3 bathroom, 1,919 sqft single-family home built in 2021. This property is not currently available for sale. 174 Sullivan Dr was last sold on Nov 30, 2023 for $425,000 (2% lower than the asking price of $435,000). The current Trulia Estimate for 174 Sullivan Dr is $424,200.