Are you ready for more community in your neighborhood? Welcome to Rose Lane...where families grow and neighbors care for one another. 1718 Heirloom Ct. in Modesto-a beautifully maintained home tucked away in a quiet court, perfect for family living. Pride of ownership shows throughout the home. Newer tile floors that lead to the heart of the home, the kitchen. Large island with sink and seating, quartz countertops with custom cabinetry made with soft close drawers and pull out shelving. The two-toned colors make it sleek and modern. Great view of the backyard, and opens to the family room. A bedroom and a full bathroom downstairs. French doors to your primary bedroom with an updated bathroom, including a double sided walk in closet for his and hers. One of the rooms can be an office, or a craft room, as extra cabinets have been added. The backyard boasts of a sparkling pool with relaxing sounds of the waterfall. The pool has been recently replastered and the pump has been replaced. The grass area is big enough for a play structure, trampoline or to play grass volleyball. Side shed for extra storage. New HVAC, and 33 PAID solar panels to help lower the utility bills. Highly sought out Sylvan Schools, walking distance to parks, and a block away from the new Crossroads shopping center. Don't miss out on the opportunity to have your dream home. Come by and fall in love with Heirloom Court, and make your dream a reality!!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Property Condition
Updated/Remodeled
Year Built
1998
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Other-Rmks 0-5YR
Stories
2
Levels
Two
Home Warranty
No
Directions to Property
From Mable, turn on Veranda Way, then turn into Heirloom Ct. Look for sign.
Cross Street
Veranda
County
Stanislaus
Special Listing Conditions
None
Builder Model
McHenry
Lower Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Living Room
Main Level
Kitchen, Street Entrance
Construction Materials
Stucco, Frame, Wood
Foundation
Slab
Roof
Shingle
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Inside Area, Inside Room
Other Structures
Shed(s), Storage
Full Bathrooms
3
Bath Features
Tub w/Shower Over, Window
# of Fireplaces
1
Fireplace Features
Gas Piped
Flooring
Carpet, Tile, Wood
Appliances
Gas Cook Top, Ice Maker, Dishwasher, Microwave, Double Oven
Kitchen Features
Breakfast Area, Quartz Counter, Island w/Sink
Dining Room Features
Formal Room
Living Room Features
Great Room
Primary Bathroom Features
Double Sinks, Walk-In Closet
Upper Level
Bedroom(s), Full Bath(s)
Exterior Features
Built-In Barbeque
Patio And Porch Features
Front Porch
Pool
Yes
Pool Features
Above Ground, Built-In, Fenced
Spa
No
ADU/2nd Unit
No
Utilities
Public, Solar
Electric
220 Volts
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Court
APN
082 001 051 000
Fencing
Wood
Horse Property
No
Road Responsibility
Public Maintained Road
Zoning Description
R1
Subdivision
Rose Lane
Subdivision Developer
Florsheim
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
4.03
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 759050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 838950 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) >= 2407 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2907 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` = 1716075 OR `props-main`.`id` = 1718110 OR `props-main`.`id` = 1697714 OR `props-main`.`id` = 1719850 OR `props-main`.`id` = 1719535 OR `props-main`.`id` = 1718976 OR `props-main`.`id` = 1705345 OR `props-main`.`id` = 1704885 OR `props-main`.`id` = 1715732 OR `props-main`.`id` = 1713162 OR `props-main`.`id` = 1718143 OR `props-main`.`id` = 1718884 OR `props-main`.`id` = 1718926 OR `props-main`.`id` = 1714803 OR `props-main`.`id` = 1716283 OR `props-main`.`id` = 1715680 OR `props-main`.`id` = 1702971 OR `props-main`.`id` = 1715773 OR `props-main`.`id` = 1719651 OR `props-main`.`id` = 1715774 OR `props-main`.`id` = 1718857 OR `props-main`.`id` = 1715603 OR `props-main`.`id` = 1718611 OR `props-main`.`id` = 1713700 OR `props-main`.`id` = 1708028 OR `props-main`.`id` = 1715659 OR `props-main`.`id` = 1713189 OR `props-main`.`id` = 1719377 OR `props-main`.`id` = 1719671 OR `props-main`.`id` = 1713777 OR `props-main`.`id` = 1707869 OR `props-main`.`id` = 1704964 OR `props-main`.`id` = 1707870 OR `props-main`.`id` = 1716441 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1717001 OR `props-main`.`id` = 1718598 OR `props-main`.`id` = 1713962 OR `props-main`.`id` = 1712982 OR `props-main`.`id` = 1718536 OR `props-main`.`id` = 1710082 OR `props-main`.`id` = 1718537 OR `props-main`.`id` = 1713442 OR `props-main`.`id` = 1714806 OR `props-main`.`id` = 1718539 OR `props-main`.`id` = 1716072 OR `props-main`.`id` = 1718356 OR `props-main`.`id` = 1719140 OR `props-main`.`id` = 1677502 OR `props-main`.`id` = 1719732 OR `props-main`.`id` = 1709417 OR `props-main`.`id` = 1705737 OR `props-main`.`id` = 1717989 OR `props-main`.`id` = 1712986 OR `props-main`.`id` = 1712987 OR `props-main`.`id` = 1705563 OR `props-main`.`id` = 1717981 OR `props-main`.`id` = 1711461 OR `props-main`.`id` = 1716825 OR `props-main`.`id` = 1701961)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226039743' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' 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 Lili-Marlene Leiva, PMZ 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.
