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/fresno/647825/1735-N-Hunter-Ave/Stockton/https://www.londonproperties.com/images/props/fresno/full/647825.jpgLondon Properties Stockton Real Estate | 1735 N Hunter Ave
This charming turn-of-the-century Craftsman home at in Stockton offers timeless character combined with modern updates. The expansive front porch welcomes you into a warm and inviting space, perfect for relaxing or entertaining. Inside, beautiful hardwood floors flow throughout the home, complemented by high ceilings and a striking wood beam ceiling in the dining room that adds architectural interest. The kitchen features a cozy breakfast room, ideal for casual meals and morning coffee. The large primary suite boasts a dream closet, providing ample storage and comfort. Convenience is enhanced with a second-floor laundry room, making household chores easier. Step outside to enjoy the newly added deck and new pool plaster, creating a perfect backyard oasis for gatherings and outdoor fun. This home blends classic charm with thoughtful updates, offering a confident and comfortable lifestyle in a desirable Stockton neighborhood.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1935
Region
Urban
# of Stories
Two
Price Per Square Foot
$247
Price Per Acre
$4,643,388
Days On London
12
Cumulative Days On London
12
County
San Joaquin
REO / Bank Owned
No
Cross Street Address
Walnut
Directions
Walnut and left on Hunter.
Style
Victorian
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Upper
Flooring
Carpet, Hardwood
# of Fireplaces
1
Exterior
Other
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
Yes
Spa Type
In Ground
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Are there garage spaces?
No
APN
127 131 170 000
School District
Stockton
School Type 1
High School
School Name 1
Edison High
School Type 2
Junior High School
School Name 2
Marshall
School Type 3
Grade School
School Name 3
Taylor Elementaty
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 593750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 656250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2276 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2776 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` = 1720581 OR `props-main`.`id` = 1724043)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647825' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-27' 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 Ryan Davis, Real Broker - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 3 minutes ago
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.