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/kings/234027/2404-W-Bristol-Ln/Hanford/https://www.londonproperties.com/images/props/kings/full/234027.jpgLondon 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.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2020
Location
City
Stories
1
Price Per Square Foot
$231
Price Per Acre
$3,283,302
Cumulative Days On London
21
County
Kings
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 Systems
Central
Cooling
Ceiling Fan(s), Central
Laundry
Room
Roof
Composition
Window Treatments
Blinds, Shades, Shutters
Windows
Dual Pane
Permanent Foundation
Slab
Full Bathrooms
2
Floors
Carpet, Tile Floors
Dining Room
12x10 Level: Main
Dining Room Dimensions
12.00 x 10.00
Dining Room Length
12.00
Dining Room Width
10.00
Dining Room Area
120.0000
Pool Private Y/N
No
Spa Y/N
No
Porch / Patio
Covered Patio
Utilities
All Public
Water Supply
Public
Sewer
Public Sewer
Solar Y/N
Yes
Solar Options
Solar Panels
Solar Ownership
PPA: Pwr Purch Agmnt
Garage Type
Garage Attached
Garage Capacity
2
Sprinklers
Automatic
Horse Property Y/N
No
APN Number
009 450 010 000
Association
Kings County Multiple Listing Service
Currently Rented
Yes
Monthly Rent Amount
2500.00
Lease Type
Net
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 498750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 551250 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` = 1724617 OR `props-main`.`id` = 1724618 OR `props-main`.`id` = 1724829 OR `props-main`.`id` = 1724843 OR `props-main`.`id` = 1724844 OR `props-main`.`id` = 1724845 OR `props-main`.`id` = 1713710 OR `props-main`.`id` = 1710007 OR `props-main`.`id` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1724968 OR `props-main`.`id` = 1704066 OR `props-main`.`id` = 1717395 OR `props-main`.`id` = 1717401 OR `props-main`.`id` = 1718070 OR `props-main`.`id` = 1725508 OR `props-main`.`id` = 1725385 OR `props-main`.`id` = 1725502 OR `props-main`.`id` = 1723724 OR `props-main`.`id` = 1723725 OR `props-main`.`id` = 1723718 OR `props-main`.`id` = 1639133 OR `props-main`.`id` = 1717617 OR `props-main`.`id` = 1717980 OR `props-main`.`id` = 1718508 OR `props-main`.`id` = 1725811 OR `props-main`.`id` = 1725799 OR `props-main`.`id` = 1713386 OR `props-main`.`id` = 1724791 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` = 1720918 OR `props-main`.`id` = 1720927 OR `props-main`.`id` = 1725371 OR `props-main`.`id` = 1725370 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` = 1724982 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` = 1724079 OR `props-main`.`id` = 1724162 OR `props-main`.`id` = 1724167 OR `props-main`.`id` = 1706823 OR `props-main`.`id` = 1706833 OR `props-main`.`id` = 1719529 OR `props-main`.`id` = 1719489 OR `props-main`.`id` = 1719240 OR `props-main`.`id` = 1719483)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings234027' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-08' 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, Real Brokerage Technologies
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.
