Please provide the following information and Araceli Garcia will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.araceligarciarealtor.com/agent/16801/araceli-garcia/property/link/crmls/25600971/655-Lim-St/Merced/https://www.araceligarciarealtor.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 London
130
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
72871
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` = 1706323 OR `props-main`.`id` = 1706324 OR `props-main`.`id` = 1667395 OR `props-main`.`id` = 1667390 OR `props-main`.`id` = 1706325 OR `props-main`.`id` = 1667389 OR `props-main`.`id` = 1667396 OR `props-main`.`id` = 1706322 OR `props-main`.`id` = 1706223 OR `props-main`.`id` = 1706328 OR `props-main`.`id` = 1667912 OR `props-main`.`id` = 1667929 OR `props-main`.`id` = 1706331 OR `props-main`.`id` = 1706330 OR `props-main`.`id` = 1667931 OR `props-main`.`id` = 1667930 OR `props-main`.`id` = 1706329 OR `props-main`.`id` = 1706254 OR `props-main`.`id` = 1688171 OR `props-main`.`id` = 1704658 OR `props-main`.`id` = 1691355 OR `props-main`.`id` = 1691163 OR `props-main`.`id` = 1696706 OR `props-main`.`id` = 1706970 OR `props-main`.`id` = 1691296 OR `props-main`.`id` = 1691295 OR `props-main`.`id` = 1706678 OR `props-main`.`id` = 1697049 OR `props-main`.`id` = 1695611 OR `props-main`.`id` = 1690063 OR `props-main`.`id` = 1688452 OR `props-main`.`id` = 1703145 OR `props-main`.`id` = 1694370 OR `props-main`.`id` = 279647 OR `props-main`.`id` = 1702223 OR `props-main`.`id` = 1698238 OR `props-main`.`id` = 1705416 OR `props-main`.`id` = 1705077 OR `props-main`.`id` = 1706216 OR `props-main`.`id` = 1705460 OR `props-main`.`id` = 1706441 OR `props-main`.`id` = 1622831 OR `props-main`.`id` = 1705349 OR `props-main`.`id` = 1699684 OR `props-main`.`id` = 1699890 OR `props-main`.`id` = 1696149 OR `props-main`.`id` = 1701865 OR `props-main`.`id` = 1706455 OR `props-main`.`id` = 1622835 OR `props-main`.`id` = 1703966 OR `props-main`.`id` = 1685963 OR `props-main`.`id` = 1690946 OR `props-main`.`id` = 1702687 OR `props-main`.`id` = 1702280 OR `props-main`.`id` = 1702067 OR `props-main`.`id` = 1702099 OR `props-main`.`id` = 1706554 OR `props-main`.`id` = 1702508 OR `props-main`.`id` = 1694511 OR `props-main`.`id` = 1693516 OR `props-main`.`id` = 1694865 OR `props-main`.`id` = 1706453 OR `props-main`.`id` = 1694967 OR `props-main`.`id` = 1705935 OR `props-main`.`id` = 1696306 OR `props-main`.`id` = 1698061 OR `props-main`.`id` = 1698962 OR `props-main`.`id` = 1700195 OR `props-main`.`id` = 1701206 OR `props-main`.`id` = 1692024 OR `props-main`.`id` = 1695790 OR `props-main`.`id` = 1701468 OR `props-main`.`id` = 1686586 OR `props-main`.`id` = 1665493 OR `props-main`.`id` = 1701027 OR `props-main`.`id` = 1689129 OR `props-main`.`id` = 1688973 OR `props-main`.`id` = 1694973 OR `props-main`.`id` = 1672896 OR `props-main`.`id` = 1706334 OR `props-main`.`id` = 1703143 OR `props-main`.`id` = 1701588 OR `props-main`.`id` = 1703985 OR `props-main`.`id` = 1041230 OR `props-main`.`id` = 1693713 OR `props-main`.`id` = 1693694 OR `props-main`.`id` = 1706448 OR `props-main`.`id` = 1694962 OR `props-main`.`id` = 1674548 OR `props-main`.`id` = 1706026 OR `props-main`.`id` = 1692454 OR `props-main`.`id` = 1692435 OR `props-main`.`id` = 1699047 OR `props-main`.`id` = 1697381 OR `props-main`.`id` = 1706931 OR `props-main`.`id` = 1702413 OR `props-main`.`id` = 1703178 OR `props-main`.`id` = 1703174 OR `props-main`.`id` = 1703265 OR `props-main`.`id` = 1689907 OR `props-main`.`id` = 1706377 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1677522 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` = 1701030 OR `props-main`.`id` = 1702414 OR `props-main`.`id` = 1702709 OR `props-main`.`id` = 1674192 OR `props-main`.`id` = 1705283 OR `props-main`.`id` = 1700994 OR `props-main`.`id` = 1704870 OR `props-main`.`id` = 1704891 OR `props-main`.`id` = 1704917 OR `props-main`.`id` = 1676643 OR `props-main`.`id` = 1655369 OR `props-main`.`id` = 1695165 OR `props-main`.`id` = 1702872 OR `props-main`.`id` = 1703320 OR `props-main`.`id` = 1705431 OR `props-main`.`id` = 1704769 OR `props-main`.`id` = 1700089 OR `props-main`.`id` = 1700067 OR `props-main`.`id` = 1700069 OR `props-main`.`id` = 1692161)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls25600971' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-09' 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();
2
Similar Properties
$424,000
4
2
1,700
0.23
2021 Normandy Lane
Merced, CA 95340
$400,000
4
3
1,839
0.07
547 Granada Ct
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.
