Move in ready, this home is a rare gem. 3bedroom 2 bath, primary bedroom on one end the home other bedrooms at the other end. large living area with cozy fireplace, area off kitchen for dining. open kitchen to living and dining area. Great starter home or investment opportunity. Won't last.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1988
Year Built Source
Public Records
Special Listing Conditions
Trust, Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
Side
Price Per Square Foot
$321
Days On London
20
Cumulative Days On London
20
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Directions
X Street south to Heritage Right to Home
Room Type
All Bedrooms Down, Great Room
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage
Main Level Bedrooms
3
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
2
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
1.00
Attached Garage Y/N
Yes
Garage Spaces
1.00
Lot Features
Rectangular Lot
Lot Size Area
4565.0000
Lot Size Units
Square Feet
View Y/N
No
View
None
Common Interest
None
Parcel Number
059542006000
Additional Parcels Y/N
No
Community Features
Curbs, Sidewalks
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
Unknown
Tax Lot
6
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 313405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 346395 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) >= 779 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1279 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` = 1715694 OR `props-main`.`id` = 1725700 OR `props-main`.`id` = 1715753 OR `props-main`.`id` = 1715746 OR `props-main`.`id` = 1715759 OR `props-main`.`id` = 279647 OR `props-main`.`id` = 1705416 OR `props-main`.`id` = 1705077 OR `props-main`.`id` = 1709192 OR `props-main`.`id` = 1709198 OR `props-main`.`id` = 1709154 OR `props-main`.`id` = 1723820 OR `props-main`.`id` = 1702687 OR `props-main`.`id` = 1723864 OR `props-main`.`id` = 1723292 OR `props-main`.`id` = 1722045 OR `props-main`.`id` = 1722036 OR `props-main`.`id` = 1714774 OR `props-main`.`id` = 1694967 OR `props-main`.`id` = 1723261 OR `props-main`.`id` = 1665493 OR `props-main`.`id` = 1723281 OR `props-main`.`id` = 1714387 OR `props-main`.`id` = 1693807 OR `props-main`.`id` = 1693713 OR `props-main`.`id` = 1693694 OR `props-main`.`id` = 1714454 OR `props-main`.`id` = 1694962 OR `props-main`.`id` = 1692454 OR `props-main`.`id` = 1692435 OR `props-main`.`id` = 1703178 OR `props-main`.`id` = 1703174 OR `props-main`.`id` = 1703265 OR `props-main`.`id` = 1714340 OR `props-main`.`id` = 1724892 OR `props-main`.`id` = 1724914 OR `props-main`.`id` = 1724946 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1718808 OR `props-main`.`id` = 1723296 OR `props-main`.`id` = 1714743 OR `props-main`.`id` = 1714759 OR `props-main`.`id` = 1723264 OR `props-main`.`id` = 1696651 OR `props-main`.`id` = 1714499 OR `props-main`.`id` = 1717979 OR `props-main`.`id` = 1722385 OR `props-main`.`id` = 1716553 OR `props-main`.`id` = 1720206 OR `props-main`.`id` = 1690062 OR `props-main`.`id` = 1716559 OR `props-main`.`id` = 1724706 OR `props-main`.`id` = 1724819 OR `props-main`.`id` = 1722113 OR `props-main`.`id` = 1722109 OR `props-main`.`id` = 1716763 OR `props-main`.`id` = 1724959 OR `props-main`.`id` = 1717008 OR `props-main`.`id` = 1724054 OR `props-main`.`id` = 1723665 OR `props-main`.`id` = 1710126 OR `props-main`.`id` = 1718502 OR `props-main`.`id` = 1714294 OR `props-main`.`id` = 1704870 OR `props-main`.`id` = 1704891 OR `props-main`.`id` = 1704917 OR `props-main`.`id` = 1723274 OR `props-main`.`id` = 1724314 OR `props-main`.`id` = 1695165 OR `props-main`.`id` = 1725712 OR `props-main`.`id` = 1703320 OR `props-main`.`id` = 1723282 OR `props-main`.`id` = 1690433 OR `props-main`.`id` = 1690429 OR `props-main`.`id` = 1725214 OR `props-main`.`id` = 1725267 OR `props-main`.`id` = 1718325 OR `props-main`.`id` = 262682 OR `props-main`.`id` = 1688050 OR `props-main`.`id` = 1688040 OR `props-main`.`id` = 1703457 OR `props-main`.`id` = 1704693 OR `props-main`.`id` = 1717582 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1725552 OR `props-main`.`id` = 1704003 OR `props-main`.`id` = 1723278 OR `props-main`.`id` = 1723295 OR `props-main`.`id` = 1686965 OR `props-main`.`id` = 1714366 OR `props-main`.`id` = 289931 OR `props-main`.`id` = 1725038 OR `props-main`.`id` = 1720494 OR `props-main`.`id` = 1724891 OR `props-main`.`id` = 1721525 OR `props-main`.`id` = 1708410 OR `props-main`.`id` = 1708334 OR `props-main`.`id` = 1679706 OR `props-main`.`id` = 1686825 OR `props-main`.`id` = 1690564 OR `props-main`.`id` = 1695318 OR `props-main`.`id` = 1704152 OR `props-main`.`id` = 1723059 OR `props-main`.`id` = 1714687 OR `props-main`.`id` = 1720840 OR `props-main`.`id` = 1714599 OR `props-main`.`id` = 1725148 OR `props-main`.`id` = 87746 OR `props-main`.`id` = 1723291 OR `props-main`.`id` = 1725537 OR `props-main`.`id` = 1725710 OR `props-main`.`id` = 270485 OR `props-main`.`id` = 1696131 OR `props-main`.`id` = 1723934 OR `props-main`.`id` = 1696130 OR `props-main`.`id` = 1722876 OR `props-main`.`id` = 1695615 OR `props-main`.`id` = 1720346 OR `props-main`.`id` = 1719076 OR `props-main`.`id` = 1642555 OR `props-main`.`id` = 1722481 OR `props-main`.`id` = 1724893 OR `props-main`.`id` = 1715691 OR `props-main`.`id` = 1716876 OR `props-main`.`id` = 1716882 OR `props-main`.`id` = 1717810 OR `props-main`.`id` = 1716863 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1725317 OR `props-main`.`id` = 1720291 OR `props-main`.`id` = 1720493 OR `props-main`.`id` = 1711179 OR `props-main`.`id` = 1711176 OR `props-main`.`id` = 1721995 OR `props-main`.`id` = 1721563 OR `props-main`.`id` = 1721565 OR `props-main`.`id` = 1721572 OR `props-main`.`id` = 1717010 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1724609)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26082147' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-07' 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
$340,000
3
2
1,000
0.12
767 Taryn Ct
Merced, CA 95341
$335,000
3
2
1,144
0.20
1847 W 8th
Merced, CA 95341
$324,999
3
2
1,200
0.18
2228 N drake N
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.
