THIS A THREE BEDROOM HOME OPEN CONCEPT WITH GREAT ROOM DINING AND KITCHEN OPEN TO EACH OTHER. WALK-IN PANTRY AND LAUNDRY ROOM. LARGE LOT WITH ENOUGH ROOM FOR A POOL.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1992
Year Built Source
Assessor
Days On London
8
Cumulative Days On London
8
County
Kings
New Construction
No
Stories
1
Current Use
Single Family
Directions to Property
NORTH ON GRANGEVILLE TO GREENWOOD TURN RIGHT GOING WEST THEN TO KNOWLWWOOD TURN LEFT GOING EAST TO BURLWOOD TURN LEFT GOING WEST THEN LEFT ON OAKWOOD GOING EAST DESTINAION ON THE RIGHT
Construction Materials
Brick, Stucco
Foundation Details
Concrete Perimeter
Roof
Shake, Tile
Cooling
Central Air
Laundry Features
Laundry Room
Security Features
Smoke Detector(s)
Direction Faces
West
Interior Features
Ceiling Fan(s), Ceramic Counters, Kitchen Open to Family Room
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Appliances
Gas Range, Solar Hot Water, Water Heater
Fireplace Y/N
Yes
Fireplace Features
Great Room, Masonry
Flooring
Combination
Common Walls
No Common Walls
Exterior Features
Lighting
Private Pool
No
Spa
No
Patio and Porch Features
Covered
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
3.0
APN
014 670 048 000
Lot Features
Sprinklers In Front
Lot Dimensions
cul-de-sac
Horse Property
No
Zoning Description
SINGLE FAMILY RESIDENCE
Additional Parcels Y/N
No
Waterfront Y/N
No
Road Frontage Type
City Street
Road Surface Type
Asphalt
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 394250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 435750 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) >= 2679 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3179 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` = 1719343 OR `props-main`.`id` = 1727194 OR `props-main`.`id` = 1728173 OR `props-main`.`id` = 1705552 OR `props-main`.`id` = 1718585 OR `props-main`.`id` = 1725543 OR `props-main`.`id` = 1727785 OR `props-main`.`id` = 1727797 OR `props-main`.`id` = 1731725 OR `props-main`.`id` = 1724094 OR `props-main`.`id` = 1724097 OR `props-main`.`id` = 1731121 OR `props-main`.`id` = 1720483 OR `props-main`.`id` = 1720485 OR `props-main`.`id` = 1728495 OR `props-main`.`id` = 1723041 OR `props-main`.`id` = 1727951 OR `props-main`.`id` = 1728368 OR `props-main`.`id` = 1728376 OR `props-main`.`id` = 1728390 OR `props-main`.`id` = 1728391 OR `props-main`.`id` = 1724022 OR `props-main`.`id` = 1724025 OR `props-main`.`id` = 1723694 OR `props-main`.`id` = 1723733 OR `props-main`.`id` = 1704066 OR `props-main`.`id` = 1723742 OR `props-main`.`id` = 1724098 OR `props-main`.`id` = 1728673 OR `props-main`.`id` = 1720448 OR `props-main`.`id` = 1720460 OR `props-main`.`id` = 1720445 OR `props-main`.`id` = 1720447 OR `props-main`.`id` = 1724840 OR `props-main`.`id` = 1731234 OR `props-main`.`id` = 1724387 OR `props-main`.`id` = 1707238 OR `props-main`.`id` = 1710124 OR `props-main`.`id` = 1711130 OR `props-main`.`id` = 1711142 OR `props-main`.`id` = 1725682 OR `props-main`.`id` = 1728614 OR `props-main`.`id` = 1709188 OR `props-main`.`id` = 1709193 OR `props-main`.`id` = 1727792 OR `props-main`.`id` = 1728046 OR `props-main`.`id` = 1712817 OR `props-main`.`id` = 1694424 OR `props-main`.`id` = 1728296 OR `props-main`.`id` = 1692202 OR `props-main`.`id` = 1694426 OR `props-main`.`id` = 1728299 OR `props-main`.`id` = 1727746 OR `props-main`.`id` = 1727744 OR `props-main`.`id` = 1725572 OR `props-main`.`id` = 1704293 OR `props-main`.`id` = 1729113 OR `props-main`.`id` = 1724056 OR `props-main`.`id` = 1725811 OR `props-main`.`id` = 1731115 OR `props-main`.`id` = 1725799 OR `props-main`.`id` = 1729077 OR `props-main`.`id` = 1726917 OR `props-main`.`id` = 1716323 OR `props-main`.`id` = 1724791 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1726477 OR `props-main`.`id` = 1726476 OR `props-main`.`id` = 1721515 OR `props-main`.`id` = 1704935 OR `props-main`.`id` = 1704975 OR `props-main`.`id` = 1731173 OR `props-main`.`id` = 1728491 OR `props-main`.`id` = 1725023 OR `props-main`.`id` = 1718727 OR `props-main`.`id` = 1725019 OR `props-main`.`id` = 1725021 OR `props-main`.`id` = 1718106 OR `props-main`.`id` = 1729867 OR `props-main`.`id` = 1729946 OR `props-main`.`id` = 1726197 OR `props-main`.`id` = 1729022 OR `props-main`.`id` = 1725371 OR `props-main`.`id` = 1725370 OR `props-main`.`id` = 1722774 OR `props-main`.`id` = 1715600 OR `props-main`.`id` = 1722148 OR `props-main`.`id` = 1722151 OR `props-main`.`id` = 1731374 OR `props-main`.`id` = 1696680 OR `props-main`.`id` = 1696498 OR `props-main`.`id` = 1696560 OR `props-main`.`id` = 1726377 OR `props-main`.`id` = 1726238 OR `props-main`.`id` = 1726373 OR `props-main`.`id` = 1731696 OR `props-main`.`id` = 1708238 OR `props-main`.`id` = 1709561 OR `props-main`.`id` = 1723943 OR `props-main`.`id` = 1731645 OR `props-main`.`id` = 1723954 OR `props-main`.`id` = 1723866 OR `props-main`.`id` = 1723933 OR `props-main`.`id` = 1724982 OR `props-main`.`id` = 1730424 OR `props-main`.`id` = 1731799 OR `props-main`.`id` = 1707015 OR `props-main`.`id` = 1707022 OR `props-main`.`id` = 1707016 OR `props-main`.`id` = 1725952 OR `props-main`.`id` = 1680247 OR `props-main`.`id` = 1726621 OR `props-main`.`id` = 1726683 OR `props-main`.`id` = 1729273 OR `props-main`.`id` = 1729483 OR `props-main`.`id` = 1727119 OR `props-main`.`id` = 1720318 OR `props-main`.`id` = 1720315 OR `props-main`.`id` = 1726188 OR `props-main`.`id` = 1727069 OR `props-main`.`id` = 1729078 OR `props-main`.`id` = 1702770 OR `props-main`.`id` = 1727348 OR `props-main`.`id` = 1727015)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare242060' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-02' 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 Mel Cox, Daley Enterprises, Inc
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.
