Please provide the following information and Valiant Reyes will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.valiantrealtor.com/agent/22682/valiant-reyes/property/link/crmls/25600971/655-Lim-St/Merced/https://www.valiantrealtor.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
150
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` = 1711788 OR `props-main`.`id` = 1711789 OR `props-main`.`id` = 1667395 OR `props-main`.`id` = 1667390 OR `props-main`.`id` = 1711790 OR `props-main`.`id` = 1667389 OR `props-main`.`id` = 1667396 OR `props-main`.`id` = 1711787 OR `props-main`.`id` = 1711795 OR `props-main`.`id` = 1667912 OR `props-main`.`id` = 1667929 OR `props-main`.`id` = 1711798 OR `props-main`.`id` = 1711797 OR `props-main`.`id` = 1667931 OR `props-main`.`id` = 1667930 OR `props-main`.`id` = 1711796 OR `props-main`.`id` = 1711680 OR `props-main`.`id` = 1704658 OR `props-main`.`id` = 1709536 OR `props-main`.`id` = 1706970 OR `props-main`.`id` = 1691296 OR `props-main`.`id` = 1712582 OR `props-main`.`id` = 1710225 OR `props-main`.`id` = 1712425 OR `props-main`.`id` = 1706678 OR `props-main`.`id` = 1688452 OR `props-main`.`id` = 1709974 OR `props-main`.`id` = 1709725 OR `props-main`.`id` = 1694370 OR `props-main`.`id` = 279647 OR `props-main`.`id` = 1698238 OR `props-main`.`id` = 1707935 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` = 1709939 OR `props-main`.`id` = 1711639 OR `props-main`.`id` = 1711974 OR `props-main`.`id` = 1622831 OR `props-main`.`id` = 1711892 OR `props-main`.`id` = 1712030 OR `props-main`.`id` = 1696149 OR `props-main`.`id` = 1708142 OR `props-main`.`id` = 1712003 OR `props-main`.`id` = 1622835 OR `props-main`.`id` = 1708287 OR `props-main`.`id` = 1709466 OR `props-main`.`id` = 1709216 OR `props-main`.`id` = 1685963 OR `props-main`.`id` = 1690946 OR `props-main`.`id` = 1702687 OR `props-main`.`id` = 1712670 OR `props-main`.`id` = 1702067 OR `props-main`.`id` = 1702099 OR `props-main`.`id` = 1712139 OR `props-main`.`id` = 1702508 OR `props-main`.`id` = 1710117 OR `props-main`.`id` = 1712300 OR `props-main`.`id` = 1694865 OR `props-main`.`id` = 1712000 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` = 1695790 OR `props-main`.`id` = 1701468 OR `props-main`.`id` = 1686586 OR `props-main`.`id` = 1665493 OR `props-main`.`id` = 1689129 OR `props-main`.`id` = 1711919 OR `props-main`.`id` = 1688973 OR `props-main`.`id` = 1694973 OR `props-main`.`id` = 1672896 OR `props-main`.`id` = 1711805 OR `props-main`.`id` = 1712306 OR `props-main`.`id` = 1701588 OR `props-main`.`id` = 1711417 OR `props-main`.`id` = 1041230 OR `props-main`.`id` = 1693713 OR `props-main`.`id` = 1693694 OR `props-main`.`id` = 1711988 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` = 1706931 OR `props-main`.`id` = 1703178 OR `props-main`.`id` = 1703174 OR `props-main`.`id` = 1703265 OR `props-main`.`id` = 1689907 OR `props-main`.`id` = 1712413 OR `props-main`.`id` = 1711863 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1677522 OR `props-main`.`id` = 1708189 OR `props-main`.`id` = 1712269 OR `props-main`.`id` = 1712283 OR `props-main`.`id` = 1691603 OR `props-main`.`id` = 1691684 OR `props-main`.`id` = 1627326 OR `props-main`.`id` = 1708251 OR `props-main`.`id` = 1694977 OR `props-main`.`id` = 1693545 OR `props-main`.`id` = 1690072 OR `props-main`.`id` = 1690062 OR `props-main`.`id` = 1711928 OR `props-main`.`id` = 1712424 OR `props-main`.`id` = 1708460 OR `props-main`.`id` = 1710126 OR `props-main`.`id` = 1711816 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` = 1712154 OR `props-main`.`id` = 1703320 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-03-01' 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
$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.
