Please provide the following information and Melissa Schroder will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.mimischroder.com/agent/17001/melissa-schroder/property/link/fresno/646454/1155-W-Julia-Way/Hanford/https://www.mimischroder.com/images/props/fresno/full/646454.jpgLondon Properties Hanford Real Estate | 1155 W Julia Way
Incredibly well-maintained 3 bedroom, 2 bathroom home located in a desirable NW Hanford neighborhood. Thoughtfully designed floor plan features a spacious living room with vaulted ceilings, a gas fireplace, and a versatile flex space ideal for a playroom, formal dining area, or additional living space. The kitchen offers modern appliances, granite countertops, rich wood cabinetry, and a large pantry. The backyard is fully landscaped and designed for entertaining, complete with a generous patio area and a fire pit space. The oversized owner's suite provides a true retreat, featuring dual vanities, a soaking tub, a separate shower, and a large walk-in closet. Additional features include a 3-car garage with ample space for parking and storage. Located within the Pioneer School District with a convenient commute to NAS Lemoore. Bed count differs from tax records. Buyer to verify
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2004
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$235
Price Per Acre
$2,681,735
Days On London
9
Cumulative Days On London
9
County
Kings
REO / Bank Owned
No
Cross Street Address
N Glacier Way
Directions
Starting on W Grangeville Blvd, turn right on N 11th Ave, left on W Fargo Ave, right N Glacier Way, left on W Julia Way. House will be on the left.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 417050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 460950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1618 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2118 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` = 1702833 OR `props-main`.`id` = 1702845 OR `props-main`.`id` = 1709188 OR `props-main`.`id` = 1709193 OR `props-main`.`id` = 1713472 OR `props-main`.`id` = 1716841 OR `props-main`.`id` = 1716839 OR `props-main`.`id` = 1721393 OR `props-main`.`id` = 1681688 OR `props-main`.`id` = 1681689 OR `props-main`.`id` = 1694424 OR `props-main`.`id` = 1692202 OR `props-main`.`id` = 1717617 OR `props-main`.`id` = 1717980 OR `props-main`.`id` = 1718508 OR `props-main`.`id` = 1713386 OR `props-main`.`id` = 1716323 OR `props-main`.`id` = 1721623 OR `props-main`.`id` = 1696935 OR `props-main`.`id` = 1696934 OR `props-main`.`id` = 1705468 OR `props-main`.`id` = 1722519 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1719330 OR `props-main`.`id` = 1719327 OR `props-main`.`id` = 1719328 OR `props-main`.`id` = 1721515 OR `props-main`.`id` = 1704935 OR `props-main`.`id` = 1704975 OR `props-main`.`id` = 1695753 OR `props-main`.`id` = 1715663 OR `props-main`.`id` = 1719073 OR `props-main`.`id` = 1718727 OR `props-main`.`id` = 1721655 OR `props-main`.`id` = 1720918 OR `props-main`.`id` = 1720927 OR `props-main`.`id` = 1719564 OR `props-main`.`id` = 1719641 OR `props-main`.`id` = 1718106 OR `props-main`.`id` = 1721351 OR `props-main`.`id` = 1721531 OR `props-main`.`id` = 1721359 OR `props-main`.`id` = 1720620 OR `props-main`.`id` = 1720675 OR `props-main`.`id` = 1715600 OR `props-main`.`id` = 1718120 OR `props-main`.`id` = 1722148 OR `props-main`.`id` = 1722151 OR `props-main`.`id` = 1696680 OR `props-main`.`id` = 1696498 OR `props-main`.`id` = 1696560 OR `props-main`.`id` = 1697839 OR `props-main`.`id` = 1722513 OR `props-main`.`id` = 1722512 OR `props-main`.`id` = 1698937 OR `props-main`.`id` = 1698938 OR `props-main`.`id` = 1720574 OR `props-main`.`id` = 1721750 OR `props-main`.`id` = 1708238 OR `props-main`.`id` = 1722391 OR `props-main`.`id` = 1722389 OR `props-main`.`id` = 1722405 OR `props-main`.`id` = 1722426 OR `props-main`.`id` = 1721165 OR `props-main`.`id` = 1721456 OR `props-main`.`id` = 1720718 OR `props-main`.`id` = 1718746 OR `props-main`.`id` = 1704240 OR `props-main`.`id` = 1709561 OR `props-main`.`id` = 1711293 OR `props-main`.`id` = 1711150 OR `props-main`.`id` = 1711290 OR `props-main`.`id` = 1721843 OR `props-main`.`id` = 1717632 OR `props-main`.`id` = 1712572 OR `props-main`.`id` = 1712568 OR `props-main`.`id` = 1712626 OR `props-main`.`id` = 1716333 OR `props-main`.`id` = 1712621 OR `props-main`.`id` = 1711095 OR `props-main`.`id` = 1711081 OR `props-main`.`id` = 1711093 OR `props-main`.`id` = 1718235 OR `props-main`.`id` = 1718994 OR `props-main`.`id` = 1707015 OR `props-main`.`id` = 1707022 OR `props-main`.`id` = 1707016 OR `props-main`.`id` = 1704221 OR `props-main`.`id` = 1706823 OR `props-main`.`id` = 1706833 OR `props-main`.`id` = 1713158 OR `props-main`.`id` = 1719146 OR `props-main`.`id` = 1721034 OR `props-main`.`id` = 1718914 OR `props-main`.`id` = 1720318 OR `props-main`.`id` = 1720315 OR `props-main`.`id` = 1719529 OR `props-main`.`id` = 1719489 OR `props-main`.`id` = 1721002 OR `props-main`.`id` = 1719240 OR `props-main`.`id` = 1719483 OR `props-main`.`id` = 1702770 OR `props-main`.`id` = 1720378 OR `props-main`.`id` = 1720380 OR `props-main`.`id` = 1720391 OR `props-main`.`id` = 1720398 OR `props-main`.`id` = 1720490 OR `props-main`.`id` = 1705125 OR `props-main`.`id` = 1718175)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646454' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-20' 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();
3
Similar Properties
$459,000
4
2
1,872
0.18
1588 Muscat Pl
Hanford, CA 93230
$430,000
4
2
1,809
0.15
1356 Castoro Way
Hanford, CA 93230
$425,000
4
2
1,800
0.17
795 Northstar Dr
Hanford, CA 93230
Courtesy of Ashley Lovrencevic, London Properties - ashleylrealtor@yahoo.com Last modified 1 week ago Fresno MLS last checked for updates 2 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.
