Meet your next address! This Village-One Stunner is located in the Legends subdivision and features 3147 square feet of living space on a .22 acre lot with 5 bedrooms, 3 baths, including a full bedroom and bath on the main level. Also, on the main level are two versatile bonus rooms...ideal for a home office, gym, media room, or playroom...allowing you to tailor the space to your lifestyle. Additional features include engineered hardwood flooring, Plantation shutters, fireplaces in both the formal living and family rooms, and a large gourmet eat-in kitchen with Quartz countertops, smoked stainless steel appliances, double oven, custom soft-close cabinets and a large island. The resort-style backyard includes a custom heated pebble-tec pool and spa, surrounded by elevated patio spaces, a custom koi pond with waterfall and a large covered patio area. There is tons of storage in the huge 3-car garage with epoxy floors and walls of cabinets. Located in the highly sought-after Sylvan School District.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached, Luxury
Property Condition
Updated/Remodeled
Year Built
2001
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 6-10YR, Kitchen 6-10YR
Stories
2
Levels
Two
Pets Allowed
Yes, Cats OK, Dogs OK
Home Warranty
No
Other Equipment
Water Filter System
Directions to Property
East on Floyd Ave. from Floyd and Roselle. Floyd to Fine. South on Fine to Lookout. West on Lookout to Leonatus.
Cross Street
Lookout
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Retreat, Kitchen, Street Entrance
Living Room, Family Room, Gas Log, Gas Piped, Gas Starter
Flooring
Carpet, Tile, Wood
Appliances
Gas Plumbed, Gas Water Heater, Ice Maker, Dishwasher, Disposal, Microwave, Double Oven, Plumbed For Ice Maker, Self/Cont Clean Oven, ENERGY STAR Qualified Appliances, Free Standing Gas Oven
Room Type
Primary Bathroom, Primary Bedroom, Bonus Room, Media Room, Office, Dining Room, Family Room, Kitchen, Laundry, Living Room
Kitchen Features
Breakfast Area, Pantry Closet, Quartz Counter, Island, Kitchen/Family Combo
Dining Room Features
Breakfast Nook, Formal Room, Dining Bar, Dining/Family Combo, Dining/Living Combo
Built-In, On Lot, Pool Sweep, Pool/Spa Combo, Fenced, Gas Heat
Spa
Yes
Spa Features
Spa/Hot Tub Built-In, Spa/Hot Tub Personal
ADU/2nd Unit
No
Utilities
Cable Available, Public, Electric, Sewer In & Connected, Natural Gas Connected
Electric
220 Volts,220 Volts in Laundry
Irrigation
None
Water Source
Public, Meter on Site, Water District
Sewer
Public Sewer
Energy Efficient
Appliances
Parking Features
Attached, Garage Facing Front
Garage Spaces
3.00
Lot Features
Auto Sprinkler F&R, Curb(s)/Gutter(s), Shape Regular, Street Lights, Landscape Back, Landscape Front
APN
085 031 012 000
Driveway/Sidewalks
Sidewalk/Curb/Gutter
Fencing
Back Yard, Wood, Fenced, Masonry
Horse Property
No
Road Surface Type
Paved
Zoning Description
SFR
Subdivision
LEGENDS VILLAGE
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.12
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 831250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 918750 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) >= 2897 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3397 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` = 1680147 OR `props-main`.`id` = 1711309 OR `props-main`.`id` = 1697604 OR `props-main`.`id` = 1689722 OR `props-main`.`id` = 1713425 OR `props-main`.`id` = 1704457 OR `props-main`.`id` = 1698444 OR `props-main`.`id` = 1713241 OR `props-main`.`id` = 1714510 OR `props-main`.`id` = 1715730 OR `props-main`.`id` = 1712762 OR `props-main`.`id` = 1689340 OR `props-main`.`id` = 1708424 OR `props-main`.`id` = 1709273 OR `props-main`.`id` = 1716834 OR `props-main`.`id` = 1714780 OR `props-main`.`id` = 1712373 OR `props-main`.`id` = 1716152 OR `props-main`.`id` = 1708497 OR `props-main`.`id` = 1717224 OR `props-main`.`id` = 1717143 OR `props-main`.`id` = 1717482 OR `props-main`.`id` = 1713476 OR `props-main`.`id` = 1697854 OR `props-main`.`id` = 1691865 OR `props-main`.`id` = 1717336 OR `props-main`.`id` = 1703104 OR `props-main`.`id` = 1716075 OR `props-main`.`id` = 1716104 OR `props-main`.`id` = 1711168 OR `props-main`.`id` = 1697714 OR `props-main`.`id` = 1714711 OR `props-main`.`id` = 1708218 OR `props-main`.`id` = 1714546 OR `props-main`.`id` = 1704885 OR `props-main`.`id` = 1715732 OR `props-main`.`id` = 1686997 OR `props-main`.`id` = 1717268 OR `props-main`.`id` = 1717512 OR `props-main`.`id` = 1715680 OR `props-main`.`id` = 1716056 OR `props-main`.`id` = 1706068 OR `props-main`.`id` = 1703452 OR `props-main`.`id` = 1708276 OR `props-main`.`id` = 1703802 OR `props-main`.`id` = 1716505 OR `props-main`.`id` = 1713700 OR `props-main`.`id` = 1708028 OR `props-main`.`id` = 1715659 OR `props-main`.`id` = 1716781 OR `props-main`.`id` = 1716990 OR `props-main`.`id` = 1710184 OR `props-main`.`id` = 1702925 OR `props-main`.`id` = 1716284 OR `props-main`.`id` = 1715487 OR `props-main`.`id` = 1707869 OR `props-main`.`id` = 1707870 OR `props-main`.`id` = 1716441 OR `props-main`.`id` = 1717001 OR `props-main`.`id` = 1713962 OR `props-main`.`id` = 1710082 OR `props-main`.`id` = 1714415)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226031107' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-21' 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 Ninon Lapan-Dalman, Weeks Real Estate 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.
