Please provide the following information and Margarita Garcia will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.margaritagarciarealtor.com/agent/16700/margarita-garcia/property/link/tulare/236990/1857-S-Red-Rock-Dr/Hanford/https://www.margaritagarciarealtor.com/images/props/tulare/full/236990.jpgLondon Properties Hanford Real Estate | 1857 S Red Rock Dr
This beautiful 3-bedroom, 2-bath home in the sought-after Sterling Oaks neighborhood offers the perfect blend of modern comfort and serene living. The open-concept floor plan is filled with natural light, highlighting the spacious kitchen complete with stainless steel appliances, abundant cabinetry, and a large island ideal for entertaining. The split-bedroom design provides privacy, with the primary suite set apart from the additional bedrooms for added comfort.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2023
Year Built Source
Assessor
Days On Market
17
Cumulative Days On Market
17
County
Kings
New Construction
No
Stories
1
Directions to Property
Heading S on 12th Ave, make a left on Hume Avenue, south on Alpine Avenue west on Sunset Avenue south on Poppy Springs Avenue, north on S Red Rock Dr home is on the right
Construction Materials
Stone Veneer, Stucco
Foundation Details
Slab
Roof
Composition
Heating
Central
Cooling
Central Air
Laundry Features
Inside, Laundry Room
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Appliances
Dishwasher, Disposal, Gas Oven, Gas Range, Microwave
Fireplace Y/N
No
Flooring
Other, Carpet
Spa
No
Patio and Porch Features
Patio, Porch
Utilities
Natural Gas Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
2.0
APN
011 600 021 000
Lot Features
Sprinklers In Front
Lot Dimensions
108X60
Additional Parcels Y/N
No
HOA
No
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 408500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 451500 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) >= 1410 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1910 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` = 1669702 OR `props-main`.`id` = 1626116 OR `props-main`.`id` = 1626120 OR `props-main`.`id` = 1626111 OR `props-main`.`id` = 1648248 OR `props-main`.`id` = 1643093 OR `props-main`.`id` = 1682335 OR `props-main`.`id` = 1665900 OR `props-main`.`id` = 1679817 OR `props-main`.`id` = 1674594 OR `props-main`.`id` = 1636285 OR `props-main`.`id` = 1614339 OR `props-main`.`id` = 1613599 OR `props-main`.`id` = 1615157 OR `props-main`.`id` = 1681309 OR `props-main`.`id` = 1681282 OR `props-main`.`id` = 1681541 OR `props-main`.`id` = 1679384 OR `props-main`.`id` = 1676378 OR `props-main`.`id` = 1653176 OR `props-main`.`id` = 1648085 OR `props-main`.`id` = 1659576 OR `props-main`.`id` = 1660339 OR `props-main`.`id` = 1680932 OR `props-main`.`id` = 1667648 OR `props-main`.`id` = 1681149 OR `props-main`.`id` = 1682178 OR `props-main`.`id` = 1668875 OR `props-main`.`id` = 1676228 OR `props-main`.`id` = 1676227 OR `props-main`.`id` = 1676226 OR `props-main`.`id` = 1676217 OR `props-main`.`id` = 1682179 OR `props-main`.`id` = 1678155 OR `props-main`.`id` = 1681402 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1683401 OR `props-main`.`id` = 1668724 OR `props-main`.`id` = 1681542 OR `props-main`.`id` = 1673823 OR `props-main`.`id` = 1652718 OR `props-main`.`id` = 1684096 OR `props-main`.`id` = 1684127 OR `props-main`.`id` = 1684151 OR `props-main`.`id` = 1684099 OR `props-main`.`id` = 1684134 OR `props-main`.`id` = 1667593 OR `props-main`.`id` = 1681390 OR `props-main`.`id` = 1627862 OR `props-main`.`id` = 1632242 OR `props-main`.`id` = 1681546 OR `props-main`.`id` = 1571373 OR `props-main`.`id` = 1571371 OR `props-main`.`id` = 1681814 OR `props-main`.`id` = 1681495 OR `props-main`.`id` = 1666685 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1666686 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1683328)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare236990' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-07' 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 Carolyn Collins, London Properties, Ltd.
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.
