Please provide the following information and Melissa Schroder will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/agent/17001/melissa-schroder/property/link/fresno/639350/766-Lincoln-St/Hanford/https://www.londonproperties.com/images/props/fresno/full/639350.jpgLondon Properties Hanford Real Estate | 766 Lincoln St
Move-in ready! This beautifully updated Hanford home offers comfortable single level living with charming details throughout. Featuring 3 bedrooms and 1 bathroom, this home provides ample storage space both inside and in the attached garage. Enjoy a spacious lot perfect for outdoor activities or future possibilities. Conveniently located near schools, parks, local favorites, and just minutes from all that Downtown Hanford has to offer!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1960
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$295
Price Per Acre
$1,384,450
Days On Market
4
Cumulative Days On Market
4
County
Kings
REO / Bank Owned
No
Cross Street Address
S 11th Ave
Directions
Head south on N Douty St toward China Aly, turn right onto W 4th St, use the middle lane to turn left onto S 11th Ave, turn right onto Lincoln St
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Main
Flooring
Carpet, Laminate, Tile
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Garage Type
Attached
Garage Spaces
1
APN
012 322 016 000
Zoning
R16
School District
Hanford Schools
School Type 1
High School
School Name 1
Hanford West
School Type 2
Junior High School
School Name 2
Woodrow Wilson
School Type 3
Grade School
School Name 3
Roosevelt
Seller Will Consider
Government, Conventional, Cash
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 245290 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 271110 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 625 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1125 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` = 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` = 1692046 OR `props-main`.`id` = 1692195 OR `props-main`.`id` = 1685402 OR `props-main`.`id` = 1688781 OR `props-main`.`id` = 1653176 OR `props-main`.`id` = 1648085 OR `props-main`.`id` = 1659576 OR `props-main`.`id` = 1660339 OR `props-main`.`id` = 1687039 OR `props-main`.`id` = 1687037 OR `props-main`.`id` = 1691467 OR `props-main`.`id` = 1691468 OR `props-main`.`id` = 1687321 OR `props-main`.`id` = 1667648 OR `props-main`.`id` = 1687046 OR `props-main`.`id` = 1668875 OR `props-main`.`id` = 1676228 OR `props-main`.`id` = 1689477 OR `props-main`.`id` = 1689476 OR `props-main`.`id` = 1690924 OR `props-main`.`id` = 1690955 OR `props-main`.`id` = 1691285 OR `props-main`.`id` = 1689618 OR `props-main`.`id` = 1688708 OR `props-main`.`id` = 1686941 OR `props-main`.`id` = 1692213 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1692212 OR `props-main`.`id` = 1689293 OR `props-main`.`id` = 1689106 OR `props-main`.`id` = 1689110 OR `props-main`.`id` = 1673823 OR `props-main`.`id` = 1692366 OR `props-main`.`id` = 1692368 OR `props-main`.`id` = 1692412 OR `props-main`.`id` = 1667593 OR `props-main`.`id` = 1692367 OR `props-main`.`id` = 1692359 OR `props-main`.`id` = 1692363 OR `props-main`.`id` = 1692364 OR `props-main`.`id` = 1692360 OR `props-main`.`id` = 1689272 OR `props-main`.`id` = 1627862 OR `props-main`.`id` = 1691963 OR `props-main`.`id` = 1691946 OR `props-main`.`id` = 1691959 OR `props-main`.`id` = 1571373 OR `props-main`.`id` = 1571371 OR `props-main`.`id` = 1662106 OR `props-main`.`id` = 1686895 OR `props-main`.`id` = 1681814 OR `props-main`.`id` = 1687669 OR `props-main`.`id` = 1686730 OR `props-main`.`id` = 1688656 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1674820 OR `props-main`.`id` = 1666685 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1666686 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1691606 OR `props-main`.`id` = 1669910 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1688313 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1686587 OR `props-main`.`id` = 1685459 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1689974 OR `props-main`.`id` = 1685056 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1691788 OR `props-main`.`id` = 1692153 OR `props-main`.`id` = 1692170 OR `props-main`.`id` = 1691177 OR `props-main`.`id` = 1664322 OR `props-main`.`id` = 1687213 OR `props-main`.`id` = 1687245 OR `props-main`.`id` = 1687246 OR `props-main`.`id` = 1687255 OR `props-main`.`id` = 1687273 OR `props-main`.`id` = 1691937 OR `props-main`.`id` = 1683661 OR `props-main`.`id` = 1688664 OR `props-main`.`id` = 1691492 OR `props-main`.`id` = 1664766 OR `props-main`.`id` = 1688012 OR `props-main`.`id` = 1657276 OR `props-main`.`id` = 1668439 OR `props-main`.`id` = 1668454 OR `props-main`.`id` = 1668433 OR `props-main`.`id` = 1668444 OR `props-main`.`id` = 1690384 OR `props-main`.`id` = 1668943 OR `props-main`.`id` = 1688638 OR `props-main`.`id` = 1683329 OR `props-main`.`id` = 1692530 OR `props-main`.`id` = 1692542 OR `props-main`.`id` = 1692521 OR `props-main`.`id` = 1692527 OR `props-main`.`id` = 1642940 OR `props-main`.`id` = 1644759 OR `props-main`.`id` = 1657138 OR `props-main`.`id` = 1691327 OR `props-main`.`id` = 1691315 OR `props-main`.`id` = 1691323 OR `props-main`.`id` = 1677794 OR `props-main`.`id` = 1677800 OR `props-main`.`id` = 1677797 OR `props-main`.`id` = 1683205 OR `props-main`.`id` = 1685298 OR `props-main`.`id` = 1679881 OR `props-main`.`id` = 1686714 OR `props-main`.`id` = 1691623 OR `props-main`.`id` = 1686713 OR `props-main`.`id` = 1690097 OR `props-main`.`id` = 1690242 OR `props-main`.`id` = 1690172 OR `props-main`.`id` = 1690088 OR `props-main`.`id` = 1675152 OR `props-main`.`id` = 1675155 OR `props-main`.`id` = 1681688 OR `props-main`.`id` = 1681689 OR `props-main`.`id` = 1692194 OR `props-main`.`id` = 1675154 OR `props-main`.`id` = 1690686 OR `props-main`.`id` = 1692202 OR `props-main`.`id` = 1692193 OR `props-main`.`id` = 1692198)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639350' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-04' 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 Erika Robles, Keller Williams Realty Tulare County - [email protected] Last modified 2 days ago Fresno MLS last checked for updates 56 minutes ago
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.
