Start this year in a newly built smart home from 2022 with paid off solar and tankless water heater and reverse osmosis. This home boasts comfort and modern living. The moment you walk in you will be greeted with water proof pergo flooring throughout the home. As you tour the home you will notice an open living room floor plan that will you walk down the hall into a stainless steel and white coated kitchen that offers a white quartz island/dining bar table. Attention to detail is no missing factor. Each room has window shutters which is perfect for privacy but also adds a sleak look. This home is ready for you and your family. Please note as you continue to tour you will see both primary and secondary bathrooms have a clean white quartz counter tops with beautiful glass bowl sinks. You will truly love this home the more and more you tour this home. This is a smart home which means there is cad 5 electrical wiring within the walls to convert this home into smart home compatiable. Lets continue with being impressed and walk into the primary suite which is the room with the most luxuries. In this primary suite you have the walk in closet and a dual vanity and a jetted tub in the primary restroom, just steps away from your bed, not to mention direct access to your back yard to enjoy a smooth night of relaxation. In the back yard you will inherit the shed as well which can be used to your own preference. With all the great attributes this home has, privacy is definitely one of them and this home provides it well. The front door has is rod iron gated and rod iron fence infront of the home as well for your comfort. BACK ON MARKET, BUYER COULD NOT PERFORM
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2022
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Bed 0-5YR, Kitchen 0-5YR
Stories
1
Home Warranty
No
Other Equipment
Water Filter System
Directions to Property
When coming from the 99, drive down crows landing and turn left on Crater.
Cross Street
crowslanding
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Kitchen
Construction Materials
Other
Foundation
Concrete, Raised
Roof
Shingle
Heating
Central
Cooling
Central
Laundry Features
Space For Frzr/Refr, In Garage
Window Features
Dual Pane Full
Other Structures
Shed(s), Storage
Full Bathrooms
2
Bath Features
Shower Stall(s), Jetted Tub, Quartz
Flooring
Laminate, Wood
Appliances
Microwave
Kitchen Features
Breakfast Area, Pantry Cabinet, Island, Stone Counter, Island w/Sink, Kitchen/Family Combo
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 422750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 467250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1370 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1870 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` = 1706152 OR `props-main`.`id` = 1711228 OR `props-main`.`id` = 1704359 OR `props-main`.`id` = 1711620 OR `props-main`.`id` = 1712382 OR `props-main`.`id` = 1702759 OR `props-main`.`id` = 1698158 OR `props-main`.`id` = 1687989 OR `props-main`.`id` = 1697462 OR `props-main`.`id` = 1706037 OR `props-main`.`id` = 1711197 OR `props-main`.`id` = 1711960 OR `props-main`.`id` = 1702641 OR `props-main`.`id` = 1695208 OR `props-main`.`id` = 1702785 OR `props-main`.`id` = 1712678 OR `props-main`.`id` = 1711968 OR `props-main`.`id` = 1705316 OR `props-main`.`id` = 1712653 OR `props-main`.`id` = 1711911 OR `props-main`.`id` = 1698941 OR `props-main`.`id` = 1712019 OR `props-main`.`id` = 1712247 OR `props-main`.`id` = 1704345 OR `props-main`.`id` = 1705396 OR `props-main`.`id` = 1711885 OR `props-main`.`id` = 1674476 OR `props-main`.`id` = 1711332 OR `props-main`.`id` = 1710238 OR `props-main`.`id` = 1709867 OR `props-main`.`id` = 1711878 OR `props-main`.`id` = 1712220 OR `props-main`.`id` = 1699060 OR `props-main`.`id` = 1697287 OR `props-main`.`id` = 1703092 OR `props-main`.`id` = 1711786 OR `props-main`.`id` = 1700083 OR `props-main`.`id` = 1710165 OR `props-main`.`id` = 1704117 OR `props-main`.`id` = 1697509 OR `props-main`.`id` = 1709553 OR `props-main`.`id` = 1706715 OR `props-main`.`id` = 1697625 OR `props-main`.`id` = 1709770 OR `props-main`.`id` = 1702599 OR `props-main`.`id` = 1711976 OR `props-main`.`id` = 1712679 OR `props-main`.`id` = 1712040 OR `props-main`.`id` = 1711954 OR `props-main`.`id` = 1677808 OR `props-main`.`id` = 1711828 OR `props-main`.`id` = 1711829 OR `props-main`.`id` = 1708496 OR `props-main`.`id` = 1711716 OR `props-main`.`id` = 1711707)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225147510' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-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();
3
Similar Properties
$449,000
5
2
1,661
0.14
1740 1740 DENVER ST
Modesto, CA 95358
$430,000
3
2
1,707
0.91
604 604 Sunset avenue
Modesto, CA 95351-3754
$429,900
3
3
1,850
0.15
1016 Lombardy Dr
Modesto, CA 95351
Courtesy of Andrew Cervantes, HomeSmart PV & Associates 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.
