Located in the Wisteria community in Modesto, this two-story home offers 2,411 square feet of living space with 5 bedrooms, 3 bathrooms, and a 2-car garage. Features include upgraded cabinetry and flooring, along with coach lights at the garage. The home is offered at $673,760. Buyers may be eligible for up to $10,000 in builder incentives when using a preferred lender, subject to applicable terms, conditions, and seller concessions. Contact the listing agent for additional information.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Tract
Property Condition
New Construction
Year Built Details
New
Year Built Source
Builder
Remodeled/Updated
No
Stories
2
Home Warranty
Yes
Directions to Property
FROM CA-99 TAKE EXIT 242 FOR CA-120 E/YOSEMITE AVE TOWARD SONORA. TURN LEFT ONTO CA-12 E/E T=YOSEMITE AVE. TURN RIGHT ONTO MURPHY RD. TURN LEFT ONTO E RIVER RD. TURN RIGHT ONTO MCHENRY AVE. TURN LEFT ONTO PATTERSON RD. TURN RIGHT ONTO COFFEE RD. AT THE TRAFFIC CIRCLE, TAKE THE 3RD EXIT ONTO CLARATINA AVE. TURN RIGHT ONTO OAKDALE RD. TURN LEFT ONTO LA FORCE DR. AT THE TRAFFIC CIRCLE, TURN RIGHT ONTO KODIAK DR. TURN RIGHT ONTO ORCHARD PARK WAY. COMMUNITY ENTRANCE WILL BE ON THE RI
Cross Street
Amelia Way
County
Stanislaus
Special Listing Conditions
None
Builder Name
MHP Builders Inc.
Builder Model
Residence 2411
Main Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco, Frame
Foundation
Concrete, Slab
Roof
Shake
Heating
Central
Cooling
Central
Laundry Features
Electric, Hookups Only, Inside Room
Window Features
Caulked/Sealed, Window Screens
Full Bathrooms
3
Bath Features
Double Sinks, Tub w/Shower Over, Window
Flooring
Carpet, Laminate
Appliances
Dishwasher, Disposal, Microwave, Free Standing Electric Range
Room Type
Laundry
Kitchen Features
Pantry Closet, Quartz Counter, Island, Kitchen/Family Combo
Dining Room Features
Dining/Family Combo
Living Room Features
Great Room
Primary Bathroom Features
Double Sinks, Tub, Walk-In Closet, Window
Upper Level
Bedroom(s), Primary Bedroom, Full Bath(s)
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Solar
Electric
220 Volts in Laundry
Irrigation
None
Water Source
Meter on Site
Sewer
Public Sewer
Parking Features
Attached, Garage Door Opener, Garage Facing Front
Garage Spaces
2.00
Lot Features
Auto Sprinkler Front, Landscape Front
APN
077 071 006 000
Land Use
Residential
Fencing
Back Yard, Wood
Horse Property
No
Zoning Description
R1
Subdivision
Wisteria
Subdivision Developer
Legacy Homes
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) >= 640072 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 707448 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2139 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2639 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` = 1759551 OR `props-main`.`id` = 1680147 OR `props-main`.`id` = 1776746 OR `props-main`.`id` = 1759282 OR `props-main`.`id` = 1787430 OR `props-main`.`id` = 1779074 OR `props-main`.`id` = 1787474 OR `props-main`.`id` = 1774238 OR `props-main`.`id` = 1771588 OR `props-main`.`id` = 1786031 OR `props-main`.`id` = 1789451 OR `props-main`.`id` = 1789726 OR `props-main`.`id` = 1774704 OR `props-main`.`id` = 1755639 OR `props-main`.`id` = 1763815 OR `props-main`.`id` = 1763813 OR `props-main`.`id` = 1744005 OR `props-main`.`id` = 1790425 OR `props-main`.`id` = 1786055 OR `props-main`.`id` = 1727300 OR `props-main`.`id` = 1755762 OR `props-main`.`id` = 1786741 OR `props-main`.`id` = 1789106 OR `props-main`.`id` = 1786742 OR `props-main`.`id` = 1774525 OR `props-main`.`id` = 1774633 OR `props-main`.`id` = 1768901 OR `props-main`.`id` = 1773029 OR `props-main`.`id` = 1775669 OR `props-main`.`id` = 1776041 OR `props-main`.`id` = 1788684 OR `props-main`.`id` = 1769323 OR `props-main`.`id` = 1751158 OR `props-main`.`id` = 1772220 OR `props-main`.`id` = 1772863 OR `props-main`.`id` = 1776180 OR `props-main`.`id` = 1775357 OR `props-main`.`id` = 1750106 OR `props-main`.`id` = 1774744 OR `props-main`.`id` = 1787698 OR `props-main`.`id` = 1764630 OR `props-main`.`id` = 1759041 OR `props-main`.`id` = 1778172 OR `props-main`.`id` = 1787803 OR `props-main`.`id` = 1752476 OR `props-main`.`id` = 1777885 OR `props-main`.`id` = 1785274 OR `props-main`.`id` = 1776806 OR `props-main`.`id` = 1725328 OR `props-main`.`id` = 1725327 OR `props-main`.`id` = 1725326 OR `props-main`.`id` = 1722553 OR `props-main`.`id` = 1725329 OR `props-main`.`id` = 1763972 OR `props-main`.`id` = 1763618 OR `props-main`.`id` = 1787458 OR `props-main`.`id` = 1785676 OR `props-main`.`id` = 1758286 OR `props-main`.`id` = 1740841 OR `props-main`.`id` = 1787220 OR `props-main`.`id` = 1788775 OR `props-main`.`id` = 1771627 OR `props-main`.`id` = 1752883 OR `props-main`.`id` = 1779206 OR `props-main`.`id` = 1763008 OR `props-main`.`id` = 1780644 OR `props-main`.`id` = 1723462 OR `props-main`.`id` = 1752212 OR `props-main`.`id` = 1787223 OR `props-main`.`id` = 1755085 OR `props-main`.`id` = 1769032 OR `props-main`.`id` = 1782458 OR `props-main`.`id` = 1728945 OR `props-main`.`id` = 1790424 OR `props-main`.`id` = 1743992 OR `props-main`.`id` = 1733603 OR `props-main`.`id` = 1781086 OR `props-main`.`id` = 1772872 OR `props-main`.`id` = 1778493 OR `props-main`.`id` = 1776675 OR `props-main`.`id` = 1774391 OR `props-main`.`id` = 1762980 OR `props-main`.`id` = 1780000 OR `props-main`.`id` = 1721984 OR `props-main`.`id` = 1785511 OR `props-main`.`id` = 1785713 OR `props-main`.`id` = 1748119 OR `props-main`.`id` = 1788704 OR `props-main`.`id` = 1771000 OR `props-main`.`id` = 1751493 OR `props-main`.`id` = 1755086 OR `props-main`.`id` = 1789359 OR `props-main`.`id` = 1787640 OR `props-main`.`id` = 1789360 OR `props-main`.`id` = 1770408 OR `props-main`.`id` = 1766319 OR `props-main`.`id` = 1775951 OR `props-main`.`id` = 1757597 OR `props-main`.`id` = 1738197 OR `props-main`.`id` = 1774315 OR `props-main`.`id` = 1787633 OR `props-main`.`id` = 1757588 OR `props-main`.`id` = 1755822 OR `props-main`.`id` = 1741825 OR `props-main`.`id` = 1752068 OR `props-main`.`id` = 1789425 OR `props-main`.`id` = 1747859 OR `props-main`.`id` = 1766845 OR `props-main`.`id` = 1770156 OR `props-main`.`id` = 1754682 OR `props-main`.`id` = 1751457 OR `props-main`.`id` = 1755009 OR `props-main`.`id` = 1789200 OR `props-main`.`id` = 1735305 OR `props-main`.`id` = 1789161 OR `props-main`.`id` = 1789224 OR `props-main`.`id` = 1712982 OR `props-main`.`id` = 1787351 OR `props-main`.`id` = 1786726 OR `props-main`.`id` = 1766716 OR `props-main`.`id` = 1710082 OR `props-main`.`id` = 1762364 OR `props-main`.`id` = 1774227 OR `props-main`.`id` = 1783486)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226126520' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-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();
1
Similar Properties
$649,000
5
3
2,316
0.32
3508 Sagewood Ct
Modesto, CA 95356
Courtesy of Carly Drebert, Carly Drebert 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.
