Brand new and never lived in! This beautifully designed 5-bedroom, 3 full bathroom home is located in a desirable Riverbank neighborhood and offers the perfect blend of comfort, style, and functionality. With 1 full bedroom and 1 full bathroom located downstairs, this layout is ideal for guests, multigenerational living, or a home office setup. Enjoy the spacious and open floor plan featuring a modern kitchen that flows seamlessly into the living and dining areas perfect for everyday living and entertaining. Upstairs you'll find four additional bedrooms, including a large primary suite with a walk-in closet and a spa-inspired ensuite bathroom. This two-story home is move-in ready and offers all the benefits of new construction without the wait. Close to schools, parks, and shopping. Don't miss your chance to own this brand-new home in a growing community! Builder is providing up to 15K toward closing costs.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Property Condition
New Construction
Year Built Details
New
Year Built Source
Builder
Remodeled/Updated
Unknown
Stories
2
Home Warranty
No
Directions to Property
Roselle Avenue north, right off S. Rose Brook Dr, left on Landon Lane
Cross Street
S. Rose Brook
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Full Bath(s)
Construction Materials
Frame
Foundation
Slab
Roof
Tile
Heating
Central
Cooling
Central
Laundry Features
Inside Area
Full Bathrooms
3
Bath Features
Tub w/Shower Over
Flooring
Laminate
Kitchen Features
Granite Counter
Dining Room Features
Dining/Family Combo
Living Room Features
Other
Upper Level
Bedroom(s), Full Bath(s)
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Sewer In & Connected, Solar
Electric
220 Volts
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Curb(s)/Gutter(s)
APN
075 095 056 000
Horse Property
No
Zoning Description
R1
Subdivision
Elmwood Estates
Subdivision Developer
Seton Pacific Co
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Riverbank Unified
Middle or Junior School District
Riverbank Unified
Senior High School District
Riverbank Unified
Census Tract
3.03
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 565202.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 624697.5 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) >= 1989 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2489 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` = 1710082 OR `props-main`.`id` = 1716072 OR `props-main`.`id` = 1714415 OR `props-main`.`id` = 1650045 OR `props-main`.`id` = 1677502 OR `props-main`.`id` = 1705464 OR `props-main`.`id` = 1709417 OR `props-main`.`id` = 1705737 OR `props-main`.`id` = 1712986 OR `props-main`.`id` = 1712987 OR `props-main`.`id` = 1705563 OR `props-main`.`id` = 1713527 OR `props-main`.`id` = 1711461 OR `props-main`.`id` = 1704378 OR `props-main`.`id` = 1655863 OR `props-main`.`id` = 1701961 OR `props-main`.`id` = 1714324 OR `props-main`.`id` = 1715848 OR `props-main`.`id` = 1705423 OR `props-main`.`id` = 1694239 OR `props-main`.`id` = 1704280 OR `props-main`.`id` = 1709518 OR `props-main`.`id` = 1714475 OR `props-main`.`id` = 1714491 OR `props-main`.`id` = 1714736 OR `props-main`.`id` = 1704793 OR `props-main`.`id` = 1711531 OR `props-main`.`id` = 1716367 OR `props-main`.`id` = 1712516 OR `props-main`.`id` = 1716155 OR `props-main`.`id` = 1709873 OR `props-main`.`id` = 1691597 OR `props-main`.`id` = 1711494 OR `props-main`.`id` = 1714174 OR `props-main`.`id` = 1712514 OR `props-main`.`id` = 1714667 OR `props-main`.`id` = 1716578 OR `props-main`.`id` = 1714791 OR `props-main`.`id` = 1709814 OR `props-main`.`id` = 1683669 OR `props-main`.`id` = 1705118)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225054457' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-17' 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();
0
Courtesy of Steven Bordona, 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.
