Listing Agent: Odrina Bebleh, Intero Real Estate Services
This Morrison-built home features 3 bedrooms, 2.5 bathrooms, and 2,442 sq. ft. of living space. It offers one of the most desirable two-story floor plans, featuring a very open living area. The open kitchen includes a large center island that flows beautifully into the family room, making it a perfect space for entertaining. The family room boasts large windows that provide a picture-frame view of the backyard. Additionally, the property includes a large primary suite, as well as vinyl flooring downstairs, new paint, new Carpet.
Property Sub Type
Single Family Residence
Year Built
2004
Year Built Source
Other
Special Listing Conditions
Standard
Price Per Square Foot
$233
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
Cross Street: W Springer
Heating
Central
Cooling
Central Air
Roof
Composition, Tile
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Appliances Y/N
No
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Water Source
Public
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Off Site
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Size Area
5645.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
071070018000
Zoning
Res
Association Y/N
No
High School District
Turlock Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 539600 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 596400 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) >= 2192 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2692 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` = 1786363 OR `props-main`.`id` = 1786322 OR `props-main`.`id` = 1786398 OR `props-main`.`id` = 1758819 OR `props-main`.`id` = 901883 OR `props-main`.`id` = 1771549 OR `props-main`.`id` = 1780617 OR `props-main`.`id` = 1783452 OR `props-main`.`id` = 1787802 OR `props-main`.`id` = 1780286 OR `props-main`.`id` = 1787245 OR `props-main`.`id` = 1725828 OR `props-main`.`id` = 1771978 OR `props-main`.`id` = 1776689 OR `props-main`.`id` = 1782331 OR `props-main`.`id` = 1765464 OR `props-main`.`id` = 1726062 OR `props-main`.`id` = 1723720 OR `props-main`.`id` = 1770500 OR `props-main`.`id` = 1738994 OR `props-main`.`id` = 1790497 OR `props-main`.`id` = 1765369 OR `props-main`.`id` = 280750 OR `props-main`.`id` = 1786694 OR `props-main`.`id` = 1761937 OR `props-main`.`id` = 1789642 OR `props-main`.`id` = 1777074 OR `props-main`.`id` = 1764627 OR `props-main`.`id` = 1760608 OR `props-main`.`id` = 1759323 OR `props-main`.`id` = 1771268 OR `props-main`.`id` = 1774524 OR `props-main`.`id` = 1767635 OR `props-main`.`id` = 1774194 OR `props-main`.`id` = 1738254 OR `props-main`.`id` = 1777964 OR `props-main`.`id` = 1738407 OR `props-main`.`id` = 1738400 OR `props-main`.`id` = 1793186 OR `props-main`.`id` = 1791729 OR `props-main`.`id` = 1765336 OR `props-main`.`id` = 1784093 OR `props-main`.`id` = 1790966 OR `props-main`.`id` = 1748744 OR `props-main`.`id` = 1786319 OR `props-main`.`id` = 1786641 OR `props-main`.`id` = 1788049 OR `props-main`.`id` = 1786348 OR `props-main`.`id` = 1785167)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82065041' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-19' 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();
3
Similar Properties
$595,000
4
3
2,232
0.14
532 W Springer Dr
Turlock, CA 95382
$570,000
5
3
2,414
0.19
2365 Triumph Ct
Turlock, CA 95380
$565,000
4
4
2,330
0.19
785 Fullerton Dr
Turlock, CA 95382
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.
