Listing Agent: Maria Belmonte, Century 21 Select Real Estate
Great Opportunity for First-Time Buyers or Investors! This 3-bedroom, 2-bath home offers 1,140 sq ft of living space and is full of potential. Whether you're looking for your first home or a solid investment, this property is a great fit. With a little TLC, you can truly make it your own. Features a functional layout, spacious bedrooms, and a generous lot-perfect canvas to add your personal touch. Don't miss out on this chance to create the home you've been dreaming of or to expand your portfolio with a property that has great bones and endless possibilities!
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1991
Year Built Source
Assessor
Special Listing Conditions
Probate Listing
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
front
Price Per Square Foot
$316
Days On London
164
Cumulative Days On London
164
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
99 north Exit Hammatte Ave, Left Aspendglen, Left Wycliffe, Right Glenmoor
Room Type
All Bedrooms Down
Heating
Central
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
Wood Burning
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
0-1 Unit/Acre
Lot Size Area
5766.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Common Interest
None
Parcel Number
023032025000
Additional Parcels Y/N
No
Zoning
R-1
Community Features
Street Lights, Sidewalks
Senior Community Y/N
No
Association Y/N
No
High School District
Livingston Union
Lease Considered Y/N
No
Probate Authority
Court Confirmation Not Required
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
48
Tax Census Tract
3.01
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 342000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 378000 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) >= 890 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1390 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` = 1721590 OR `props-main`.`id` = 1721233 OR `props-main`.`id` = 1721219 OR `props-main`.`id` = 1714738 OR `props-main`.`id` = 1707991 OR `props-main`.`id` = 1702779 OR `props-main`.`id` = 1727532 OR `props-main`.`id` = 1727733 OR `props-main`.`id` = 1683262 OR `props-main`.`id` = 1710224 OR `props-main`.`id` = 1710241 OR `props-main`.`id` = 1622858 OR `props-main`.`id` = 1723447 OR `props-main`.`id` = 1714093 OR `props-main`.`id` = 1727506 OR `props-main`.`id` = 1727355 OR `props-main`.`id` = 1726330 OR `props-main`.`id` = 1707898 OR `props-main`.`id` = 1707910 OR `props-main`.`id` = 1717407 OR `props-main`.`id` = 1704708 OR `props-main`.`id` = 1638025 OR `props-main`.`id` = 1714159 OR `props-main`.`id` = 1727277 OR `props-main`.`id` = 1726780 OR `props-main`.`id` = 1723792 OR `props-main`.`id` = 1720332 OR `props-main`.`id` = 1718094 OR `props-main`.`id` = 1720335 OR `props-main`.`id` = 1724683 OR `props-main`.`id` = 1693519 OR `props-main`.`id` = 1727778 OR `props-main`.`id` = 1725956 OR `props-main`.`id` = 1714814 OR `props-main`.`id` = 1716602 OR `props-main`.`id` = 1726912 OR `props-main`.`id` = 1725213 OR `props-main`.`id` = 1714804 OR `props-main`.`id` = 1677807 OR `props-main`.`id` = 1714307 OR `props-main`.`id` = 1717716 OR `props-main`.`id` = 1717669 OR `props-main`.`id` = 1724090 OR `props-main`.`id` = 1724423)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25155986' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-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();
0
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.
