Welcome to 1204 Dezzani Lane in Modesto This 4 bedroom, 2 bathroom home offering 1,469 sq ft of living space on a 4,900 sq ft lot, ready for your vision and personal touch. Step inside to a light-filled layout featuring vaulted ceilings, a cozy brick fireplace, and an open-concept living and dining area perfect for everyday living or entertaining. The kitchen offers ample counter space, a breakfast bar, and a functional layout with great potential for updates. Upstairs you'll find generously sized bedrooms with flexibility for family, guests, or a home office. Outside, the backyard provides a covered patio and plenty of room to create your ideal outdoor space. Conveniently located near schools, parks, and shopping, this property is being sold AS-IS an excellent opportunity for investors or buyers looking to build equity and make it their own.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 361000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 399000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' 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` = 1717619 OR `props-main`.`id` = 1704359 OR `props-main`.`id` = 1717613 OR `props-main`.`id` = 1714110 OR `props-main`.`id` = 1717238 OR `props-main`.`id` = 1698158 OR `props-main`.`id` = 1687989 OR `props-main`.`id` = 1719193 OR `props-main`.`id` = 1722108 OR `props-main`.`id` = 1722344 OR `props-main`.`id` = 1713218 OR `props-main`.`id` = 1723663 OR `props-main`.`id` = 1722988 OR `props-main`.`id` = 1721382 OR `props-main`.`id` = 1722872 OR `props-main`.`id` = 1717548 OR `props-main`.`id` = 1722900 OR `props-main`.`id` = 1695208 OR `props-main`.`id` = 1715950 OR `props-main`.`id` = 1715944 OR `props-main`.`id` = 1715949 OR `props-main`.`id` = 1723418 OR `props-main`.`id` = 1705396 OR `props-main`.`id` = 1714357 OR `props-main`.`id` = 1722094 OR `props-main`.`id` = 1715604 OR `props-main`.`id` = 1716590 OR `props-main`.`id` = 1722048 OR `props-main`.`id` = 1720400 OR `props-main`.`id` = 1714350 OR `props-main`.`id` = 1714690 OR `props-main`.`id` = 1721683 OR `props-main`.`id` = 1722854 OR `props-main`.`id` = 1719285 OR `props-main`.`id` = 1718874 OR `props-main`.`id` = 1709553 OR `props-main`.`id` = 1715937)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226051567' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-24' 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();
1
Similar Properties
$399,000
4
2
1,567
0.15
921 Atlantic Dr
Modesto, CA 95358
Courtesy of Deborah Hall, Realty ONE Group Zoom IDX provided by Reliance Marketing
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.
