Please provide the following information and Xay Yang will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.yanghomeownership.com/agent/16534/xay-yang/property/link/metrolist/225086714/2443-Fern-St/Merced/https://www.yanghomeownership.com/images/props/metrolist/full/225086714.jpgLondon Properties Merced Real Estate | 2443 Fern St
Make this 3/2 single story in an established Merced neighborhood, your next home. Dual pane windows throughout, large Bay window in L-Room. Central Heat & Air. Newer flooring in L-Room & hall, new carpet in bedrooms. Nice sized kitchen with plenty of cupboard space for all your small appliances, including a corner cabinet with lazy Susan! Previous Sellers also added an extra room and Covered RV slab parking! Kitchen is plumbed for ice maker and garage has gas hook up for your dryer. Includes Blink Security system and doorbell camera. This home is ready for a new family with your final touches and some TLC, schedule your showing now! Newer stainless-steel refrigerator stays with Buyer(without warranty) Rain Soft Water Softner stays (without warranty).
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached, Tract
Year Built
1979
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Kitchen 6-10YR, Bed 0-5YR
Stories
1
Levels
One
Home Warranty
No
Other Equipment
Water Cond Equipment Owned
Directions to Property
Beachwood to Lobo to Fern
Cross Street
Lobo
County
Merced
Special Zones
Flood Insurance Required, Flood Zone
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Architectural Style
Ranch
Construction Materials
Stone, Frame, Lap Siding
Foundation
Raised, Slab
Roof
Composition
Heating
Central, Natural Gas
Cooling
Ceiling Fan(s), Central
Laundry Features
Gas Hook-Up, In Garage
Window Features
Dual Pane Full
Other Structures
Shed(s)
Full Bathrooms
2
Bath Features
Tub w/Shower Over
Possible Bedrooms
4
Flooring
Carpet, Concrete, Laminate, Tile
Appliances
Free Standing Refrigerator, Dishwasher, Disposal, Microwave, Plumbed For Ice Maker, Self/Cont Clean Oven, Free Standing Electric Oven, Free Standing Electric Range
Room Type
Primary Bathroom, Primary Bedroom, Bonus Room, Kitchen, Living Room
Kitchen Features
Breakfast Area, Synthetic Counter
Dining Room Features
Space in Kitchen
Living Room Features
Other
Primary Bedroom Features
Closet, Walk-In Closet
Primary Bathroom Features
Shower Stall(s)
Patio And Porch Features
Covered Patio
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Cable Connected, Sewer Connected, Internet Available, Natural Gas Connected
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 323000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 357000 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) >= 1050 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1550 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` = 1650972 OR `props-main`.`id` = 1682572 OR `props-main`.`id` = 1684543 OR `props-main`.`id` = 1671769 OR `props-main`.`id` = 1673919 OR `props-main`.`id` = 1681087 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1646944 OR `props-main`.`id` = 1647074 OR `props-main`.`id` = 1679706 OR `props-main`.`id` = 1678157 OR `props-main`.`id` = 1681183 OR `props-main`.`id` = 1684012 OR `props-main`.`id` = 1683991 OR `props-main`.`id` = 1664312 OR `props-main`.`id` = 1676252 OR `props-main`.`id` = 1680554 OR `props-main`.`id` = 1684735 OR `props-main`.`id` = 1680532 OR `props-main`.`id` = 1642555 OR `props-main`.`id` = 1636675 OR `props-main`.`id` = 1655648 OR `props-main`.`id` = 1683355 OR `props-main`.`id` = 1683573 OR `props-main`.`id` = 1684758 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 1646767 OR `props-main`.`id` = 1682283 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1671727 OR `props-main`.`id` = 1673241 OR `props-main`.`id` = 1673275 OR `props-main`.`id` = 1682563 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 1650700 OR `props-main`.`id` = 1650686 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1654918 OR `props-main`.`id` = 1676251 OR `props-main`.`id` = 1680047 OR `props-main`.`id` = 1683767 OR `props-main`.`id` = 1681588 OR `props-main`.`id` = 1678643 OR `props-main`.`id` = 1679616 OR `props-main`.`id` = 1682874)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225086714' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-20' 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();
1
Similar Properties
$349,900
3
2
1,165
0.17
2915 Balsam Way
Merced, CA 95348
Courtesy of Christina Brown, Valley Home Realty IDX provided by Reliance Marketing
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.