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
20
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` = 1713447 OR `props-main`.`id` = 1706873 OR `props-main`.`id` = 1716637 OR `props-main`.`id` = 1707054 OR `props-main`.`id` = 1704004 OR `props-main`.`id` = 1714406 OR `props-main`.`id` = 1712448 OR `props-main`.`id` = 1676645 OR `props-main`.`id` = 1716293 OR `props-main`.`id` = 1705694 OR `props-main`.`id` = 1708451 OR `props-main`.`id` = 1708510 OR `props-main`.`id` = 1714183 OR `props-main`.`id` = 1714698 OR `props-main`.`id` = 1691726 OR `props-main`.`id` = 1699229 OR `props-main`.`id` = 1714576 OR `props-main`.`id` = 1705845 OR `props-main`.`id` = 1705815 OR `props-main`.`id` = 1703425 OR `props-main`.`id` = 1701116 OR `props-main`.`id` = 1714325 OR `props-main`.`id` = 1705932 OR `props-main`.`id` = 1714710 OR `props-main`.`id` = 1716130 OR `props-main`.`id` = 1714824 OR `props-main`.`id` = 1697608 OR `props-main`.`id` = 1690894 OR `props-main`.`id` = 1698127 OR `props-main`.`id` = 280750 OR `props-main`.`id` = 1690291 OR `props-main`.`id` = 1714723 OR `props-main`.`id` = 1701428 OR `props-main`.`id` = 1706148 OR `props-main`.`id` = 1703421 OR `props-main`.`id` = 1711472 OR `props-main`.`id` = 1701345 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-03-17' 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.
