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
$346
Days On London
60
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) >= 483550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 534450 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` = 1723579 OR `props-main`.`id` = 1722037 OR `props-main`.`id` = 1723506 OR `props-main`.`id` = 1713447 OR `props-main`.`id` = 1706873 OR `props-main`.`id` = 1720851 OR `props-main`.`id` = 1707054 OR `props-main`.`id` = 1704004 OR `props-main`.`id` = 1720269 OR `props-main`.`id` = 1723094 OR `props-main`.`id` = 1714406 OR `props-main`.`id` = 1716293 OR `props-main`.`id` = 1722083 OR `props-main`.`id` = 1716907 OR `props-main`.`id` = 1708451 OR `props-main`.`id` = 1708510 OR `props-main`.`id` = 1714183 OR `props-main`.`id` = 1714576 OR `props-main`.`id` = 1721263 OR `props-main`.`id` = 1722954 OR `props-main`.`id` = 1717384 OR `props-main`.`id` = 1721184 OR `props-main`.`id` = 1721083 OR `props-main`.`id` = 1721556 OR `props-main`.`id` = 1723195 OR `props-main`.`id` = 1723675 OR `props-main`.`id` = 1719457 OR `props-main`.`id` = 1714325 OR `props-main`.`id` = 1705932 OR `props-main`.`id` = 1714710 OR `props-main`.`id` = 1714824 OR `props-main`.`id` = 1697608 OR `props-main`.`id` = 1723704 OR `props-main`.`id` = 1723720 OR `props-main`.`id` = 280750 OR `props-main`.`id` = 1721172 OR `props-main`.`id` = 1690291 OR `props-main`.`id` = 1718698 OR `props-main`.`id` = 1722699 OR `props-main`.`id` = 1714723 OR `props-main`.`id` = 1723902 OR `props-main`.`id` = 1723627 OR `props-main`.`id` = 1721059 OR `props-main`.`id` = 1723211 OR `props-main`.`id` = 1723593 OR `props-main`.`id` = 1706148 OR `props-main`.`id` = 1711472 OR `props-main`.`id` = 1721889 OR `props-main`.`id` = 1701345 OR `props-main`.`id` = 1723032 OR `props-main`.`id` = 1722991 OR `props-main`.`id` = 1721510 OR `props-main`.`id` = 1721606)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82036239' 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.
