Listing Agent: Jose Torres, BHHS Drysdale Properties, Merced
Welcome to this beautifully maintained 3-bedroom, 2-bathroom home that offers the perfect blend of comfort, sustainability, and convenience. Nestled in a quiet neighborhood, this move-in-ready property boasts a functional floor plan with plenty of natural light throughout. Enjoy lower utility bills with a fully paid solar system. Home also comes with a water filtration system and a spacious backyard featuring mature fruit trees, perfect for relaxing evenings or entertaining guests.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1999
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
Front door
Price Per Square Foot
$312
Days On Market
101
Cumulative Days On Market
101
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
coming from Ashby south make right onto Fern St
Room Type
All Bedrooms Down
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage
Roof
Composition
Main Level Bedrooms
1
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
1
Appliances Y/N
Yes
Appliances
Dishwasher, Refrigerator, Water Purifier
Flooring
Laminate, Tile
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Patio
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
0-1 Unit/Acre
Lot Size Area
6732.0000
Lot Size Units
Square Feet
View Y/N
No
View
None
Common Interest
None
Parcel Number
057474018000
Additional Parcels Y/N
No
Community Features
Urban
Senior Community Y/N
No
Association Y/N
No
High School District
Merced Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
None
Tax Lot
43
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 361855 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 399945 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 971 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1471 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1693807 OR `props-main`.`id` = 1696651 OR `props-main`.`id` = 1700752 OR `props-main`.`id` = 1688050 OR `props-main`.`id` = 1688040 OR `props-main`.`id` = 1681087 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1694975 OR `props-main`.`id` = 1694974 OR `props-main`.`id` = 1679706 OR `props-main`.`id` = 1686825 OR `props-main`.`id` = 1690564 OR `props-main`.`id` = 1695318 OR `props-main`.`id` = 1696857 OR `props-main`.`id` = 1694846 OR `props-main`.`id` = 1701066 OR `props-main`.`id` = 1684012 OR `props-main`.`id` = 1683991 OR `props-main`.`id` = 1695615 OR `props-main`.`id` = 1642555 OR `props-main`.`id` = 1696223 OR `props-main`.`id` = 1688095 OR `props-main`.`id` = 1701652 OR `props-main`.`id` = 1697660 OR `props-main`.`id` = 1697205 OR `props-main`.`id` = 1684758 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 1693749 OR `props-main`.`id` = 1693818 OR `props-main`.`id` = 1646767 OR `props-main`.`id` = 1700256 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1697488 OR `props-main`.`id` = 1698910 OR `props-main`.`id` = 1697930 OR `props-main`.`id` = 1690931 OR `props-main`.`id` = 1701339 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1693840 OR `props-main`.`id` = 1701483 OR `props-main`.`id` = 1696012 OR `props-main`.`id` = 1686975 OR `props-main`.`id` = 1698176 OR `props-main`.`id` = 1687101 OR `props-main`.`id` = 1695048 OR `props-main`.`id` = 1701185 OR `props-main`.`id` = 1700779 OR `props-main`.`id` = 1698404 OR `props-main`.`id` = 1689954 OR `props-main`.`id` = 1698222 OR `props-main`.`id` = 1701619 OR `props-main`.`id` = 1696704 OR `props-main`.`id` = 1698181 OR `props-main`.`id` = 1701911 OR `props-main`.`id` = 1690469 OR `props-main`.`id` = 1700654 OR `props-main`.`id` = 1690474)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25227701' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-10' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
3
Similar Properties
$374,999
3
2
1,263
0.14
3280 cheyenne Dr
Merced, CA 95348
$369,000
4
2
1,450
0.14
2440 Crystal Springs Ave
Merced, CA 95348
$364,500
3
2
1,380
0.11
2139 W Chesler
Merced, CA 95348
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
