Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/metrolist/226004264/4309-Hazelnut-Dr/Modesto/https://www.londonproperties.com/images/props/metrolist/full/226004264.jpgLondon Properties Modesto Real Estate | 4309 Hazelnut Dr
PRICE REDUCED .GREAT LOCATION! NEAR SCHOOLS, SHOPPING CENTERS& EASY FREEWAY ACCESS. QUIET NEIGHBORHOOD. TESLA SOLAR SYSTEM WITHOUT POWER WALL BATTERIES (INSATLLED UNDER FINANCING STATUS. SELLERS WILL PAY IT OFF IN CLOSE OF ESCROW).PROPERTY ALSO HAS WATER PURIFICATION SYSTEM , WATER SOFTENER ,WINDOW PLANTATION SHUTTERS,JET HOT TUB, NEWER WATER HEATER & 2 STORAGE SHEDS.5 BEDROOOMS INCLUDING GREAT PRIMARY BEDROOM,1 BEDROOM DOWNSTAIRS, & 3 FULL BATHROOMS.IT IS READY TO MOVE IN. MUST SEE! .THANK YOU.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached, Tract
Year Built
2000
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
Unknown
Stories
2
Home Warranty
No
Directions to Property
FROM FREEWAY 99 TAKE BANG AVE, THEN MAKE A RIGHT TURN ON ALMOND VALLEY, THEN RIGHT ON AMARETTO, LEFT ON HAZELNUT DR. Cross Street : ALMOND BLOSSOM
Cross Street
ALMOND BLOSSOM
County
Stanislaus
Special Listing Conditions
Trust
Lower Level
Living Room
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Architectural Style
Contemporary
Construction Materials
Stucco, Frame, Wood, Lap Siding
Foundation
Slab
Roof
Tile
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Electric, Ground Floor, Hookups Only, Inside Area
Window Features
Dual Pane Full
Other Structures
Shed(s), Storage
Full Bathrooms
3
Bath Features
Double Sinks, Tub
# of Fireplaces
1
Fireplace Features
Family Room
Flooring
Carpet, Tile, Wood
Appliances
Free Standing Gas Range, Gas Water Heater, Dishwasher, Disposal, Plumbed For Ice Maker
Kitchen Features
Granite Counter
Dining Room Features
Formal Area
Living Room Features
Other
Family Room Features
Other
Primary Bathroom Features
Closet, Shower Stall(s), Tile, Tub
Upper Level
Bedroom(s), Primary Bedroom, Full Bath(s)
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Cable Available, Public, Electric, Sewer In & Connected, Solar
Electric
220 Volts,220 Volts in Laundry
Irrigation
None
Water Source
Public, Meter on Site
Sewer
Public Sewer
Parking Features
Attached, Garage Door Opener
Garage Spaces
3.00
Lot Features
Low Maintenance
APN
046 013 067
Topography
Level
Fencing
Wood, Fenced
Horse Property
No
Road Responsibility
Public Maintained Road
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
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 622250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 687750 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) >= 2640 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3140 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` = 1709443 OR `props-main`.`id` = 1710930 OR `props-main`.`id` = 1711016 OR `props-main`.`id` = 1709519 OR `props-main`.`id` = 1704957 OR `props-main`.`id` = 1709496 OR `props-main`.`id` = 1625562 OR `props-main`.`id` = 1711317 OR `props-main`.`id` = 1711047 OR `props-main`.`id` = 1703119 OR `props-main`.`id` = 1711017 OR `props-main`.`id` = 1710474 OR `props-main`.`id` = 1711326 OR `props-main`.`id` = 1694191 OR `props-main`.`id` = 1710175 OR `props-main`.`id` = 1693981 OR `props-main`.`id` = 1702731 OR `props-main`.`id` = 1709294 OR `props-main`.`id` = 1701671 OR `props-main`.`id` = 1710064 OR `props-main`.`id` = 1704964 OR `props-main`.`id` = 1710159 OR `props-main`.`id` = 1706033 OR `props-main`.`id` = 1694263 OR `props-main`.`id` = 1710645 OR `props-main`.`id` = 1694971 OR `props-main`.`id` = 1709992 OR `props-main`.`id` = 1703391 OR `props-main`.`id` = 1709545 OR `props-main`.`id` = 1709852 OR `props-main`.`id` = 1702834 OR `props-main`.`id` = 1711297 OR `props-main`.`id` = 1707934 OR `props-main`.`id` = 1707055 OR `props-main`.`id` = 1710707 OR `props-main`.`id` = 1705003 OR `props-main`.`id` = 1705009 OR `props-main`.`id` = 1709885 OR `props-main`.`id` = 1703955 OR `props-main`.`id` = 1695291 OR `props-main`.`id` = 1702956 OR `props-main`.`id` = 1711308 OR `props-main`.`id` = 1709875 OR `props-main`.`id` = 1705393 OR `props-main`.`id` = 1708169 OR `props-main`.`id` = 1709776 OR `props-main`.`id` = 1684831 OR `props-main`.`id` = 1707112 OR `props-main`.`id` = 1705257 OR `props-main`.`id` = 1709454 OR `props-main`.`id` = 1705924 OR `props-main`.`id` = 1694633 OR `props-main`.`id` = 1679295 OR `props-main`.`id` = 1699969 OR `props-main`.`id` = 1709712 OR `props-main`.`id` = 1697504 OR `props-main`.`id` = 1703470 OR `props-main`.`id` = 1698851 OR `props-main`.`id` = 1704624 OR `props-main`.`id` = 1704269 OR `props-main`.`id` = 1694579 OR `props-main`.`id` = 1694304 OR `props-main`.`id` = 1705005)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226004264' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 Thomas Nguyen, Pacificwide Real Estate & Mortgage 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.
