- 4
- beds
- 2
- baths
- 1,509
- sqft
- 2026
- year built
- Status:
- ACTIVE
- MLS #:
- MC26243367
- County:
- Merced
- Listed By:
- Berendina Hogue - D.R. Horton CA3, Inc
- Agent Phone:
- (209) 704-8649
- Agent Email:
- bwhogue@drhorton.com
Sponsoring Broker: Sam Guillen, Berkshire Hathaway HomeServices California Properties
The Adams is a single-story, four-bedroom, two-bath home with approximately 1,509 square feet of versatile living space. An open-concept great room connects effortlessly to the kitchen and dining area, creating a perfect space for gathering. The kitchen is equipped with quartz countertops, shaker-style cabinets, a large island with snack bar, walk-in pantry, and Whirlpool stainless-steel appliances. The primary suite is tucked off the great room and features dual vanity sinks and a spacious walk-in closet. Three additional bedrooms, a full bathroom, and an indoor laundry area offer flexibility for families, guests, or a home office.
Highlights
- Residential
- Manufactured Home
- Built in 2026
- 2 Car Garage
- 2 days on Market
-
- Bedrooms
- 4
-
- Bathrooms
- 2
-
- Year Built
- 2026
-
- Stories
- 1.0
-
- Garage Spaces
- 2.0
-
- Living Area
- 1509.0
-
- Cooling
- Central Air
-
- Heating
- Forced Air
-
- View
- Neighborhood
-
- Water
- Public
-
- County
- Merced
-
- City
- Merced
-
- Zip Code
- 95341
-
Ask a Question
ez Mortgage Calculator
Enter your details below to estimate your monthly mortgage payment with taxes, fees and insurance.
$
Please enter a valid number
Cost of the current home: $440490
$
%
Please enter a valid number
Cash you pay when you close
Affects interest rates. 30- or 15- year loans are standard.
%
Default rate is illustrative, set internally by ez Home Search and updated periodically; actual rates vary by lender, credit score, and market conditions.
$
%
Please enter a valid number
$
Please enter a valid number
Typically 0.25% of home value per year.
$
Please enter a valid number
Homeowners association dues.
$ 0
Monthly
Principal and interest:
Property Taxes:
Homeowners Insurance:
HOA Dues:
$0 (0%)
$0 (0%)
$0 (0%)
$0 (0%)
The ez Mortgage Calculator is for educational purposes only. Real-world interest rates and payments can differ due to factors like market trends, location, and loan specifics. Calculations are based on your inputs and might not consider extra costs a lender may add, such as insurance, taxes, and fees; thus, actual repayments could surpass estimates. Please note, ez Home Search does not provide loans, and this tool does not promise lending.
What's your home worth?
Calculate your current home value within seconds.
Similar Listings
Look Throughout Merced
There are currently 379 properties available in Merced, with 7 under contract to close soon. Properties in the city have an average sale price of $416,806 and typically spend 75 days on the market before being sold.
Want to compare this property to others available for sale in the area? Use our search to find exactly what you want among our 2,000,000+ listings and to see incredible photos to show you what is possible.
With 17 zip codes in Merced County, you have many options in the area. Be sure to claim your free ez Home Search account to make sure you get alerts when a property that meets your needs becomes available.
Source: ez Home Search, MLS Data
Frequently Asked Questions
How do I schedule a tour of 3154 Blue Water Dr #194?
We can make that happen quickly. Click Tour This Home and we'll connect you directly with our vetted local partner to schedule your visit to 3154 Blue Water Dr #194.
They know residentials in the area well and can give you the guidance you need to buy with confidence.
How do I get more information about 3154 Blue Water Dr #194?
Click Ask a Question to talk with our team. You already know it is a 4 bed, 2 bath, listed for $440,490. We can talk through recent upgrades, potential seller motivation, how this manufactured home compares to others in Merced, and can even get you in to see the property quickly.
How much is the monthly mortgage payment for 3154 Blue Water Dr #194?
With a 20% down payment and a 30-year fixed loan at an illustrative 7.25% rate, the ez Mortgage Calculator estimates the monthly payment for 3154 Blue Water Dr #194 at around $2,507. This includes estimated property taxes and insurance.
Want to see how this changes with different down payments or interest rates? Jump to the calculator to run the numbers and fine-tune your plan.
How do I get pre-approved to buy 3154 Blue Water Dr #194?
Stand out in a competitive market by getting pre-approved today. Our quick and private pre-approval process helps you understand your true buying power—no credit pull required to explore all of your options.
Or, let us connect you with our preferred local lender in Merced County. They will give you all of your available financing options, based on your specific situation and what is available to you.
Can I negotiate the asking price for 3154 Blue Water Dr #194?
In most cases, yes. Whether 3154 Blue Water Dr #194 is priced competitively or not, your best offer depends on your personal situation, the seller's timeline, and recent activity in Merced's market. Our preferred local partner will help you craft a strategy—factoring in comparable properties that have sold, timing, and deal structure—to make a smart, strong offer. Click here to ask about negotiation opportunities.
How do I make an offer on 3154 Blue Water Dr #194?
We can handle that for you. Our preferred local agent specializes in residentials in Merced and can guide you through every step of the offer process.
You need an expert who is looking out for your best interests. From market valuation to contingencies and timing, they'll help you present a compelling offer that fits your goals. Click Ask a Question to get started today.
What is the price per square foot for this home?
This home is listed at $440,490 with 1,509 sqft of space—that comes out to approximately $292 per square foot.
How long has this property been on the market?
3154 Blue Water Dr #194 was listed on November 12, 2026, which means it's been on the market for 2 days.
Want to keep tabs on it? Click the ♥ to favorite this home and get notified of price drops or changes.
When was this house built?
This home was built in 2026, making it approximately 0 years old.
Is 3154 Blue Water Dr #194 still available for sale?
Yes, this home is still available! Click the ♥ to favorite it so you don't miss any changes—or ask our local expert to schedule a time to see it in person.
Source: ez Home Search, MLS Data
Popular Home Searches in Merced, CA
Open Houses Near Merced, CA
Land for Sale Near Merced, CA
Townhomes for Sale Near Merced, CA
Waterfront Homes for Sale Near Merced, CA
Waterfront Condos for Sale Near Merced, CA
Homes with Pools for Sale Near Merced, CA
Gated Community Homes for Sale Near Merced, CA
Homes with No Hoa for Sale Near Merced, CA
Homes in Adult Communities for Sale Near Merced, CA
Search Nearby Cities
Search Nearby Postal Codes
This information is deemed reliable but not guaranteed. You should rely on this information only to decide whether or not to further investigate a particular property. BEFORE MAKING ANY OTHER DECISION, YOU SHOULD PERSONALLY INVESTIGATE THE FACTS (e.g. square footage and lot size) with the assistance of an appropriate professional. You may use this information only to identify properties you may be interested in investigating further. All uses except for personal, noncommercial use in accordance with the foregoing purpose are prohibited. Redistribution or copying of this information, any photographs or video tours is strictly prohibited. This information is derived from the Internet Data Exchange (IDX) service provided by San Diego MLS. Displayed property listings may be held by a brokerage firm other than the broker and/or agent responsible for this display. The information and any photographs and video tours and the compilation from which they are derived is protected by copyright. Copyright © 2026 San Diego MLS.
Last Updated: November 14, 2026 at 04:17AM | Source: San Diego MLS | MLS#: MC26243367
