Listing Agent: Jeffrey Sklar, Beycome Brokerage Realty Inc.
Welcome to this charming home located in Newman, CA. This lovely residence features a spacious layout with multiple bedrooms and bathrooms, appropriate for comfortable living. Enjoy the open kitchen with modern appliances and ample counter space, appropriate for culinary enthusiasts. The backyard boasts a serene space for relaxation and outdoor activities. Situated in a peaceful neighborhood, this home provides easy access to local amenities and schools. Don't miss the opportunity to make this house your new home.
Property Sub Type
Single Family Residence
Year Built
2015
Year Built Source
Assessor
Special Listing Conditions
Standard
Price Per Square Foot
$224
Days On London
0
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Drive south on N St/CA 33. Left to Merced St. Left to Edinburgh Way. Left to Cinnamon Teal Way. Right to Walshford Court. Property is on the right. Cross Street: Cinnamon Teal
Heating
Central
Cooling
Central Air
Roof
Tile
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Eating Area
Breakfast Nook
Appliances Y/N
No
Flooring
Carpet
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Water Source
Public
Sewer
Other
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Electric Vehicle Charging Station(s)
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Size Area
4960.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
049059024000
Zoning
N/A
Association Y/N
No
High School District
Newman-Crows Landing Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 517750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 572250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2185 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2685 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` = 1714460 OR `props-main`.`id` = 1719492 OR `props-main`.`id` = 1711236 OR `props-main`.`id` = 1701659 OR `props-main`.`id` = 1685945 OR `props-main`.`id` = 1715030 OR `props-main`.`id` = 1698726 OR `props-main`.`id` = 1695960 OR `props-main`.`id` = 1714288 OR `props-main`.`id` = 1722258 OR `props-main`.`id` = 1704837 OR `props-main`.`id` = 1723266 OR `props-main`.`id` = 1714109 OR `props-main`.`id` = 1716482 OR `props-main`.`id` = 1719398 OR `props-main`.`id` = 1717653 OR `props-main`.`id` = 1720513 OR `props-main`.`id` = 1713253 OR `props-main`.`id` = 1723959 OR `props-main`.`id` = 1719236 OR `props-main`.`id` = 1677324 OR `props-main`.`id` = 1677331 OR `props-main`.`id` = 1702635 OR `props-main`.`id` = 1722285 OR `props-main`.`id` = 1717614 OR `props-main`.`id` = 1716380 OR `props-main`.`id` = 1700149 OR `props-main`.`id` = 1714160)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82044739' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-27' 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.
