A must see, Once in a lifetime opportunity Model Home. Selling with everything included! YESS!!! All furniture and decoration included. Turn Key Home!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2026
Year Built Source
Builder
Days On London
21
Cumulative Days On London
21
County
Tulare
Property Condition
New Construction
New Construction
Yes
Stories
2
Current Use
Residential
Directions to Property
From Highway 99, go West on Betty Drive (Exit 98), and South on Road 63, the Granite Hills community will be on the right at the NW corner of Road 64 and Ave. 304. From Highway 198, go North on Road 64, the Granite Hills community will be on the left at the NW corner of Road 64 and Ave. 304.
Construction Materials
Stucco
Foundation Details
Slab
Roof
Composition
Heating
Central, Electric, High Effciency
Cooling
Central Air, Electric, High Effciency
Laundry Features
Laundry Room
Security Features
Carbon Monoxide Detector(s), Fire Alarm, Fire Sprinkler System, Smoke Detector(s)
Interior Features
Granite Counters, Kitchen Island, Kitchen Open to Family Room, Pantry
# of Main Level Bathrooms
1
Bathrooms Total (Integer)
3
Full Baths
2.5
Full Baths
2
Half Baths
1
Appliances
Dishwasher, Electric Range, Electric Water Heater, Microwave, Range Hood
Fireplace Y/N
No
Flooring
Carpet, Ceramic Tile
Common Walls
No Common Walls
Private Pool
No
Spa
No
Patio and Porch Features
Covered, Patio
Utilities
Electricity Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Features
Garage Faces Front, Guest
Garage
Yes
Attached Garage
No
# of Garage Spaces
2.0
APN
123 456 789 000
Lot Features
Back Yard, Fencing, Front Yard, Landscaped, Level, Sprinklers In Front
Lot Dimensions
irreg
Horse Property
No
Additional Parcels Y/N
No
View
Neighborhood
Waterfront Y/N
No
Road Surface Type
Paved
HOA
Yes
Association Fees
90.89
Payment Schedule
Monthly
Association Fee Includes
Maintenance Grounds
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 417905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 461895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1540 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2040 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` = 1758038 OR `props-main`.`id` = 1758044 OR `props-main`.`id` = 1728132 OR `props-main`.`id` = 1760246 OR `props-main`.`id` = 1754610 OR `props-main`.`id` = 1726924 OR `props-main`.`id` = 1727253 OR `props-main`.`id` = 1741375 OR `props-main`.`id` = 1745964 OR `props-main`.`id` = 1727008 OR `props-main`.`id` = 1756900 OR `props-main`.`id` = 1732112 OR `props-main`.`id` = 1720190 OR `props-main`.`id` = 1720225 OR `props-main`.`id` = 1742315 OR `props-main`.`id` = 1728670 OR `props-main`.`id` = 1750420 OR `props-main`.`id` = 1719976)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare243247' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-23' 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 Lana Fahoum, San Joaquin Valley Homes
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.
