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
Entertainers delight can't even describe the vibe of this home. 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
Location
City
Stories
1
Price Per Square Foot
$238
Price Per Acre
$3,377,111
Cumulative Days On London
1
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
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) >= 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` = 1722119 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` = 1710025 OR `props-main`.`id` = 1709911 OR `props-main`.`id` = 1718070 OR `props-main`.`id` = 1721949 OR `props-main`.`id` = 1713472 OR `props-main`.`id` = 1716841 OR `props-main`.`id` = 1716839 OR `props-main`.`id` = 1708431 OR `props-main`.`id` = 1708433 OR `props-main`.`id` = 1639133 OR `props-main`.`id` = 1717617 OR `props-main`.`id` = 1717980 OR `props-main`.`id` = 1718508 OR `props-main`.`id` = 1713386 OR `props-main`.`id` = 1696935 OR `props-main`.`id` = 1696934 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` = 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` = 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` = 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` = 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`) != 'kings234027' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-18' 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.
