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/647692/2404-W-Bristol-Ln/Hanford/https://www.londonproperties.com/images/camerashy.pngLondon Properties Hanford Real Estate | 2404 W Bristol Ln
Open space with high ceilings and upgrades that feel like you're in a model home. The grand entrance into the home feels welcoming and modern as it pours you into the open living space. The Kitchen has a massive island with room for several stools for entertaining till you're hearts content. Open to the dining area so that everyone can connect and be a part of all that is going on from the living space to the kitchen and inside the dining area. You're going to want to check out the pictures. The large slider doors in the living space opens up to allow the outside to feel like an extension of the inside. The extra spacious primary bedroom has space for a sitting area, large furniture, or other unique living options as your private retreat. Check out the barn door style door to the restroom area where you will feel the luxury of a spa like space of your own. On the other side of the home are 3 spacious bedrooms with towering ceilings and their own restroom. An indoor laundry is a nice feature that is off of the garage entrance. The backyard has a nice patio and a great backyard that's already landscaped. It's nice to find a home where you don't have two story homes behind or surrounding you. Come drive by the home and enjoy the tree lined streets and picture how beautiful it will look in a few more years as they continue to grow. This home and neighborhood have been deeply loved and are ready for it's next adventure. Will it be with you?
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2020
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$238
Price Per Acre
$3,377,111
Days On London
7
Cumulative Days On London
7
County
Kings
REO / Bank Owned
No
Cross Street Address
Centennial Dr.
Directions
From Grangeville & 12th Ave, go West on Grangeville to Centennial Dr. At Centennial Dr, head North and then turn West on Bristol Lane. It will be down on the North side of the road.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Main
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Covered
Gas & Electric
Public Utilities
Sewer / Water
Public Water
Solar
Yes
Solar Type
Power Purchase AGMT
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
009 450 010 000
School District
Hanford Schools
School Type 1
High School
School Name 1
Hanford
School Type 2
Junior High School
School Name 2
Woodrow Wilson
School Type 3
Grade School
School Name 3
Pioneer
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 513000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 567000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2019 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2519 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` = 1622949 OR `props-main`.`id` = 1720969 OR `props-main`.`id` = 1722289 OR `props-main`.`id` = 1722827 OR `props-main`.`id` = 1713710 OR `props-main`.`id` = 1710007 OR `props-main`.`id` = 1720395 OR `props-main`.`id` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1721486 OR `props-main`.`id` = 1721487 OR `props-main`.`id` = 1721414 OR `props-main`.`id` = 1721482 OR `props-main`.`id` = 1704066 OR `props-main`.`id` = 1717395 OR `props-main`.`id` = 1717401 OR `props-main`.`id` = 1718070 OR `props-main`.`id` = 1713472 OR `props-main`.`id` = 1723724 OR `props-main`.`id` = 1723725 OR `props-main`.`id` = 1723718 OR `props-main`.`id` = 1708431 OR `props-main`.`id` = 1708433 OR `props-main`.`id` = 1639133 OR `props-main`.`id` = 1722672 OR `props-main`.`id` = 1717617 OR `props-main`.`id` = 1717980 OR `props-main`.`id` = 1718508 OR `props-main`.`id` = 1713386 OR `props-main`.`id` = 1722519 OR `props-main`.`id` = 1723731 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1719328 OR `props-main`.`id` = 1721515 OR `props-main`.`id` = 1695753 OR `props-main`.`id` = 1715663 OR `props-main`.`id` = 1719073 OR `props-main`.`id` = 1718727 OR `props-main`.`id` = 1722904 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` = 1720620 OR `props-main`.`id` = 1720675 OR `props-main`.`id` = 1718120 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` = 1721165 OR `props-main`.`id` = 1721456 OR `props-main`.`id` = 1720718 OR `props-main`.`id` = 1721843 OR `props-main`.`id` = 1722700 OR `props-main`.`id` = 1712572 OR `props-main`.`id` = 1712568 OR `props-main`.`id` = 1712626 OR `props-main`.`id` = 1716333 OR `props-main`.`id` = 1722953 OR `props-main`.`id` = 1712621 OR `props-main`.`id` = 1722919 OR `props-main`.`id` = 1722946 OR `props-main`.`id` = 1711095 OR `props-main`.`id` = 1711081 OR `props-main`.`id` = 1711093 OR `props-main`.`id` = 1718235 OR `props-main`.`id` = 1721447 OR `props-main`.`id` = 1706823 OR `props-main`.`id` = 1706833 OR `props-main`.`id` = 1719146 OR `props-main`.`id` = 1719529 OR `props-main`.`id` = 1719489 OR `props-main`.`id` = 1719240 OR `props-main`.`id` = 1719483)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647692' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-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 Natalie Leon, Modern Broker - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 1 hour 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.
