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/crmls/25600971/655-Lim-St/Merced/https://www.yanghomeownership.com/images/props/crmls/full/25600971.jpgLondon Properties Merced Real Estate | 655 Lim St
SELLER MUST SELL!! MAKE US AN OFFER.. just minutes from the fast growing UC Merced downtown, shopping district easy access for commuters to highway 99 This Home is perfect for first time buyers, families, retirees or investors looking for strong rental demand.
Property Sub Type
Single Family Residence
Year Built
2019
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Price Per Square Foot
$223
Days On Market
73
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Gerard ave and la Habra st to E San Pedro st
Architectural Style
Craftsman
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Individual Room
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Appliances Y/N
Yes
Interior Features
Ceiling Fan(s)
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Attached Garage Y/N
Yes
Lot Size Area
5062.0000
Lot Size Units
Square Feet
View Y/N
Yes
Parcel Number
259296006000
Zoning
R-1-5
Senior Community Y/N
No
Association Y/N
No
72876
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 389500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 430500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1592 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2092 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` = 1689144 OR `props-main`.`id` = 1655628 OR `props-main`.`id` = 1692992 OR `props-main`.`id` = 1692994 OR `props-main`.`id` = 1667395 OR `props-main`.`id` = 1667390 OR `props-main`.`id` = 1692995 OR `props-main`.`id` = 1667389 OR `props-main`.`id` = 1667396 OR `props-main`.`id` = 1692991 OR `props-main`.`id` = 1692739 OR `props-main`.`id` = 1693010 OR `props-main`.`id` = 1667912 OR `props-main`.`id` = 1667929 OR `props-main`.`id` = 1693013 OR `props-main`.`id` = 1693012 OR `props-main`.`id` = 1667931 OR `props-main`.`id` = 1667930 OR `props-main`.`id` = 1693011 OR `props-main`.`id` = 1692809 OR `props-main`.`id` = 1688171 OR `props-main`.`id` = 1695047 OR `props-main`.`id` = 1695049 OR `props-main`.`id` = 1691355 OR `props-main`.`id` = 1691163 OR `props-main`.`id` = 1696706 OR `props-main`.`id` = 1688975 OR `props-main`.`id` = 1691296 OR `props-main`.`id` = 1691295 OR `props-main`.`id` = 1691292 OR `props-main`.`id` = 1662588 OR `props-main`.`id` = 1697049 OR `props-main`.`id` = 1695611 OR `props-main`.`id` = 1690063 OR `props-main`.`id` = 1679532 OR `props-main`.`id` = 1688452 OR `props-main`.`id` = 1694370 OR `props-main`.`id` = 279647 OR `props-main`.`id` = 1683856 OR `props-main`.`id` = 1692725 OR `props-main`.`id` = 1696321 OR `props-main`.`id` = 1696325 OR `props-main`.`id` = 1697503 OR `props-main`.`id` = 1692622 OR `props-main`.`id` = 1622831 OR `props-main`.`id` = 1693217 OR `props-main`.`id` = 1697573 OR `props-main`.`id` = 1695824 OR `props-main`.`id` = 1696149 OR `props-main`.`id` = 1694809 OR `props-main`.`id` = 1622835 OR `props-main`.`id` = 1683646 OR `props-main`.`id` = 1685963 OR `props-main`.`id` = 1690946 OR `props-main`.`id` = 1674436 OR `props-main`.`id` = 1688814 OR `props-main`.`id` = 1678158 OR `props-main`.`id` = 1697021 OR `props-main`.`id` = 1697642 OR `props-main`.`id` = 1693444 OR `props-main`.`id` = 1693092 OR `props-main`.`id` = 1678324 OR `props-main`.`id` = 1637234 OR `props-main`.`id` = 1694511 OR `props-main`.`id` = 1693516 OR `props-main`.`id` = 1692792 OR `props-main`.`id` = 1694865 OR `props-main`.`id` = 1694487 OR `props-main`.`id` = 1694967 OR `props-main`.`id` = 1696306 OR `props-main`.`id` = 1692024 OR `props-main`.`id` = 1694864 OR `props-main`.`id` = 1637576 OR `props-main`.`id` = 1695790 OR `props-main`.`id` = 1686586 OR `props-main`.`id` = 1665493 OR `props-main`.`id` = 1689129 OR `props-main`.`id` = 1693274 OR `props-main`.`id` = 1658895 OR `props-main`.`id` = 1692931 OR `props-main`.`id` = 1692729 OR `props-main`.`id` = 1622860 OR `props-main`.`id` = 1688973 OR `props-main`.`id` = 1680418 OR `props-main`.`id` = 1680833 OR `props-main`.`id` = 1694973 OR `props-main`.`id` = 1672896 OR `props-main`.`id` = 1693031 OR `props-main`.`id` = 1693713 OR `props-main`.`id` = 1696898 OR `props-main`.`id` = 1041230 OR `props-main`.`id` = 1694970 OR `props-main`.`id` = 1693694 OR `props-main`.`id` = 1693706 OR `props-main`.`id` = 1694962 OR `props-main`.`id` = 1674548 OR `props-main`.`id` = 1692454 OR `props-main`.`id` = 1692435 OR `props-main`.`id` = 1694376 OR `props-main`.`id` = 1693679 OR `props-main`.`id` = 1697381 OR `props-main`.`id` = 1694731 OR `props-main`.`id` = 1696432 OR `props-main`.`id` = 1696427 OR `props-main`.`id` = 1697530 OR `props-main`.`id` = 1686690 OR `props-main`.`id` = 1689907 OR `props-main`.`id` = 1695219 OR `props-main`.`id` = 1693160 OR `props-main`.`id` = 1696920 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1677522 OR `props-main`.`id` = 1696408 OR `props-main`.`id` = 1691603 OR `props-main`.`id` = 1691684 OR `props-main`.`id` = 1627326 OR `props-main`.`id` = 1694977 OR `props-main`.`id` = 1693545 OR `props-main`.`id` = 1690072 OR `props-main`.`id` = 1690062 OR `props-main`.`id` = 1693296 OR `props-main`.`id` = 1622733 OR `props-main`.`id` = 1622891 OR `props-main`.`id` = 1674192 OR `props-main`.`id` = 1693065 OR `props-main`.`id` = 1676643 OR `props-main`.`id` = 1655369 OR `props-main`.`id` = 1683057 OR `props-main`.`id` = 1696642 OR `props-main`.`id` = 1695165 OR `props-main`.`id` = 1695038 OR `props-main`.`id` = 1695334 OR `props-main`.`id` = 1692161)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls25600971' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-13' 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();
4
Similar Properties
$400,000
4
2
1,617
0.12
296 Dena Ct
Merced, CA 95341
$399,990
4
2
1,846
0.16
1098 E 21st St
Merced, CA 95340
$399,000
4
3
1,688
0.11
130 Mcgregor St
Merced, CA 95341
$398,000
4
2
1,706
0.16
596 ST Teresa St
Merced, CA 95341
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.
