This move in ready single story home in Village One features ceramic tile entry, separate living room and family room or possible 4th bedroom, open floor plan, plank flooring, large dining bar in kitchen and huge primary suite with double entry doors and walk-in closet. Call Now!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2000
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Unknown
Stories
1
Levels
One
Pets Allowed
Yes
Home Warranty
No
Directions to Property
East on Sylvan Avenue, right on Wood Sorrel, left on Maestro, right on Cardinal Flower. The house is on right side.
Cross Street
Maestro
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Primary Bedroom, Full Bath(s), Garage, Kitchen, Street Entrance
Architectural Style
Ranch
Construction Materials
Stucco
Foundation
Slab
Roof
Tile
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Inside Room
Window Features
Dual Pane Full
Property Faces
East
Interior Features
Formal Entry
Full Bathrooms
2
Bath Features
Bidet, Tub w/Shower Over
Possible Bedrooms
4
Flooring
Wood, See Remarks
Appliances
Dishwasher, Disposal, Microwave
Room Type
Primary Bathroom, Primary Bedroom, Great Room, Kitchen, Laundry
Kitchen Features
Island, Tile Counter
Dining Room Features
Formal Room, Space in Kitchen, Dining/Living Combo
Living Room Features
Great Room
Primary Bedroom Features
Walk-In Closet
Primary Bathroom Features
Bidet, Double Sinks, Tub w/Shower Over
Patio And Porch Features
Front Porch, Covered Patio
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Sewer Connected, Electric, Natural Gas Connected
Electric
220 Volts
Irrigation
See Remarks
Water Source
Water District, Public
Sewer
Public Sewer
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Curb(s)/Gutter(s)
APN
077 045 050 000
Fencing
Back Yard, Wood
Horse Property
No
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Sylvan Union
Middle or Junior School District
Sylvan Union
Senior High School District
Modesto City
Census Tract
9.14
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 489250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 540750 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) >= 1521 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2021 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` = 1697527 OR `props-main`.`id` = 1701000 OR `props-main`.`id` = 1671549 OR `props-main`.`id` = 1701498 OR `props-main`.`id` = 1701361 OR `props-main`.`id` = 1695807 OR `props-main`.`id` = 1701261 OR `props-main`.`id` = 1685955 OR `props-main`.`id` = 1701071 OR `props-main`.`id` = 1695660 OR `props-main`.`id` = 1698830 OR `props-main`.`id` = 1691275 OR `props-main`.`id` = 1698492 OR `props-main`.`id` = 1697583 OR `props-main`.`id` = 1694081 OR `props-main`.`id` = 1702472 OR `props-main`.`id` = 1697854 OR `props-main`.`id` = 1691865 OR `props-main`.`id` = 1702040 OR `props-main`.`id` = 1694651 OR `props-main`.`id` = 1690897 OR `props-main`.`id` = 1697714 OR `props-main`.`id` = 1702319 OR `props-main`.`id` = 1693421 OR `props-main`.`id` = 1702026 OR `props-main`.`id` = 1701866 OR `props-main`.`id` = 1698871 OR `props-main`.`id` = 1700803 OR `props-main`.`id` = 1697447 OR `props-main`.`id` = 1694983 OR `props-main`.`id` = 1697473 OR `props-main`.`id` = 1701637 OR `props-main`.`id` = 1686997 OR `props-main`.`id` = 1661890 OR `props-main`.`id` = 1702457 OR `props-main`.`id` = 1697633 OR `props-main`.`id` = 1701775 OR `props-main`.`id` = 1690717 OR `props-main`.`id` = 1691048 OR `props-main`.`id` = 1691594 OR `props-main`.`id` = 1698734 OR `props-main`.`id` = 1699989 OR `props-main`.`id` = 1681456 OR `props-main`.`id` = 1701771 OR `props-main`.`id` = 1698735 OR `props-main`.`id` = 1701444 OR `props-main`.`id` = 1701082 OR `props-main`.`id` = 1692060 OR `props-main`.`id` = 1698998 OR `props-main`.`id` = 1697497 OR `props-main`.`id` = 1702560 OR `props-main`.`id` = 1695421 OR `props-main`.`id` = 1681349 OR `props-main`.`id` = 1693498 OR `props-main`.`id` = 1675168 OR `props-main`.`id` = 1693884 OR `props-main`.`id` = 1646600 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1692488 OR `props-main`.`id` = 1689866 OR `props-main`.`id` = 1702458 OR `props-main`.`id` = 1697901 OR `props-main`.`id` = 1688192 OR `props-main`.`id` = 1695116 OR `props-main`.`id` = 1699149 OR `props-main`.`id` = 1669972 OR `props-main`.`id` = 1697741 OR `props-main`.`id` = 1677502)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226003859' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-13' 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();
11
Similar Properties
$539,900
4
3
1,944
0.11
3812 Lookout Dr
Modesto, CA 95355
$509,999
4
3
1,800
0.09
2500 Cottage Pointe Dr
Riverbank, CA 95367
$499,999
3
2
1,532
0.17
1608 Kruger Dr
Modesto, CA 95355
$489,900
4
2
1,663
0.17
1309 Nelda Way
Modesto, CA 95355
Courtesy of Joie Altstatt, Joie Altstatt 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.
