Listing Agent: Rita Zaya, Synoptic Real Estate Group
Charming northeast Turlock home featuring contemporary enhancements. As you enter, you're greeted by a grand ceiling entrance that sets the tone for the entire residence. The main living area boasts a generous living room, perfect for relaxation and entertaining. The kitchen is a chef's dream with an expansive granite countertop and elegant marble backsplash, making cooking a delight. Throughout the living area, you'll find stylish LVT flooring complemented by new upgraded lighting . This home is also fitted with modern amenities, including upgraded ceiling fans, a smart thermostat for energy efficiency, and a finished garage. The spacious 2-car garage provides ample storage, along with additional driveway parking for convenience. Located in a prime spot, enjoy quick access to all the amenities Turlock has to offer!
Property Sub Type
Single Family Residence
Year Built
2006
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Price Per Square Foot
$357
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
Turn right onto Ivory Lane. Cross Street: E Springer
Room Type
Walk-In Closet
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage, Washer Included, Dryer Included
Roof
Shingle
Foundation Details
Slab
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Room Kitchen Features
Granite Counters
Appliances Y/N
Yes
Appliances
Gas Cooktop, Disposal, Microwave, Refrigerator, Vented Exhaust Fan, Dishwasher
Room Bathroom Features
Double sinks in bath(s)
Flooring
Tile
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Gas Starter, Living Room
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Size Area
3868.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
073045077000
Zoning
R1
Association Y/N
No
High School District
Turlock Unified
Elementary School
Other
Middle Or Junior School
Other
High School
Other
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 498750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 551250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1219 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1719 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` = 1697666 OR `props-main`.`id` = 1711294 OR `props-main`.`id` = 1706873 OR `props-main`.`id` = 1707054 OR `props-main`.`id` = 1704004 OR `props-main`.`id` = 1710657 OR `props-main`.`id` = 1676645 OR `props-main`.`id` = 1705694 OR `props-main`.`id` = 1708451 OR `props-main`.`id` = 1708510 OR `props-main`.`id` = 1710412 OR `props-main`.`id` = 1707980 OR `props-main`.`id` = 1710973 OR `props-main`.`id` = 1691726 OR `props-main`.`id` = 1699229 OR `props-main`.`id` = 1710846 OR `props-main`.`id` = 1705845 OR `props-main`.`id` = 1703135 OR `props-main`.`id` = 1711385 OR `props-main`.`id` = 1678680 OR `props-main`.`id` = 1705815 OR `props-main`.`id` = 1703425 OR `props-main`.`id` = 1710559 OR `props-main`.`id` = 1707187 OR `props-main`.`id` = 1701116 OR `props-main`.`id` = 1705932 OR `props-main`.`id` = 1710986 OR `props-main`.`id` = 1703705 OR `props-main`.`id` = 1697608 OR `props-main`.`id` = 1690894 OR `props-main`.`id` = 1698127 OR `props-main`.`id` = 1703055 OR `props-main`.`id` = 280750 OR `props-main`.`id` = 1697927 OR `props-main`.`id` = 1690291 OR `props-main`.`id` = 1711002 OR `props-main`.`id` = 1701428 OR `props-main`.`id` = 1702988 OR `props-main`.`id` = 1706148 OR `props-main`.`id` = 1703421 OR `props-main`.`id` = 1711472 OR `props-main`.`id` = 1711388 OR `props-main`.`id` = 1701345 OR `props-main`.`id` = 1701214 OR `props-main`.`id` = 1690323 OR `props-main`.`id` = 1711490)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82036239' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-25' 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.
