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 Market
87
Cumulative Days On Market
87
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
Sidewalks, Street Lights
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
72876
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` = 1680264 OR `props-main`.`id` = 1681462 OR `props-main`.`id` = 1664583 OR `props-main`.`id` = 1682733 OR `props-main`.`id` = 1637015 OR `props-main`.`id` = 1683262 OR `props-main`.`id` = 1671177 OR `props-main`.`id` = 1622858 OR `props-main`.`id` = 1682262 OR `props-main`.`id` = 1678657 OR `props-main`.`id` = 1681837 OR `props-main`.`id` = 1638025 OR `props-main`.`id` = 1638152 OR `props-main`.`id` = 1638139 OR `props-main`.`id` = 1682442 OR `props-main`.`id` = 1683358 OR `props-main`.`id` = 1668742 OR `props-main`.`id` = 1627746 OR `props-main`.`id` = 1682376 OR `props-main`.`id` = 1670937 OR `props-main`.`id` = 1670947 OR `props-main`.`id` = 1682557 OR `props-main`.`id` = 1682551 OR `props-main`.`id` = 1682553 OR `props-main`.`id` = 1650580 OR `props-main`.`id` = 1682692 OR `props-main`.`id` = 1686796 OR `props-main`.`id` = 1686805 OR `props-main`.`id` = 1688102 OR `props-main`.`id` = 1668284 OR `props-main`.`id` = 1674117 OR `props-main`.`id` = 1685961 OR `props-main`.`id` = 1682887 OR `props-main`.`id` = 1677807)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25155986' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-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();
1
Similar Properties
$369,901
4
2
1,344
0.09
1504 Willow Ct
Livingston, CA 95334
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.