Please provide the following information and Rene Carson will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.renesrealestate.com/agent/10516/rene-carson/property/link/kings/232929/150-N-Falcon-Ave/Hanford/https://www.renesrealestate.com/images/props/kings/full/232929.jpgLondon Properties Hanford Real Estate | 150 N Falcon Ave
Highly Upgraded Home with Large Covered Porch. Seller will carry with $30,000 down at 5.5% interest. Only $3,250 per month (I.T.I.). Easy qualifying! 5 Bedrooms & 4 Bathrooms. Don't miss this opportunity - call today for details!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built Exception
Under Construction
Location
City
Stories
2
Price Per Square Foot
$272
Price Per Acre
$6,441,558
Cumulative Days On Market
20
County
Kings
New Construction
Yes
HUD
No
Foreclosure
No
Short Sale
No
Directions
HWY 198 Exit 12th Ave. North on 12th Ave. West on Centennial Dr. West on Millennium Way. North on Union St.
Full Bathrooms
4
Pool Private Y/N
No
Spa Y/N
No
Porch / Patio
Covered Patio, Covered Porch
Solar Y/N
Yes
Solar Options
Solar Battery in Garage, Solar Panels
Solar Ownership
PPA: Pwr Purch Agmnt
Garage Type
Garage Attached
Garage Capacity
2
Horse Property Y/N
No
APN Number
011 610 007 000
HOA Dues
120.00
HOA Frequency
Monthly
Association
Kings County Multiple Listing Service
Currently Rented
No
Lease Type
Net
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 706800 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 781200 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2484 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2984 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` = 1687039 OR `props-main`.`id` = 1687037 OR `props-main`.`id` = 1687321 OR `props-main`.`id` = 1667648 OR `props-main`.`id` = 1687046 OR `props-main`.`id` = 1690728 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` = 1689293 OR `props-main`.`id` = 1689106 OR `props-main`.`id` = 1689110 OR `props-main`.`id` = 1673823 OR `props-main`.`id` = 1667593 OR `props-main`.`id` = 1689272 OR `props-main`.`id` = 1627862 OR `props-main`.`id` = 1681546 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` = 1686730 OR `props-main`.`id` = 1688656 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1666685 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1666686 OR `props-main`.`id` = 1677314 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` = 1689565 OR `props-main`.`id` = 1691177 OR `props-main`.`id` = 1664322 OR `props-main`.`id` = 1687212 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` = 1683661 OR `props-main`.`id` = 1688664 OR `props-main`.`id` = 1664766 OR `props-main`.`id` = 1688012 OR `props-main`.`id` = 1657276 OR `props-main`.`id` = 1683085 OR `props-main`.`id` = 1690994 OR `props-main`.`id` = 1690993 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` = 1676838 OR `props-main`.`id` = 1642940 OR `props-main`.`id` = 1644759 OR `props-main`.`id` = 1657138 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` = 1686593 OR `props-main`.`id` = 1679624 OR `props-main`.`id` = 1679881 OR `props-main`.`id` = 1686714 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` = 1675154 OR `props-main`.`id` = 1688584 OR `props-main`.`id` = 1688519 OR `props-main`.`id` = 1689240 OR `props-main`.`id` = 1690686 OR `props-main`.`id` = 1690454 OR `props-main`.`id` = 1690442 OR `props-main`.`id` = 1690460 OR `props-main`.`id` = 1690462 OR `props-main`.`id` = 1690473 OR `props-main`.`id` = 1690307 OR `props-main`.`id` = 1683522 OR `props-main`.`id` = 1683663 OR `props-main`.`id` = 1688055 OR `props-main`.`id` = 1684013 OR `props-main`.`id` = 1684461 OR `props-main`.`id` = 1686360 OR `props-main`.`id` = 1627122 OR `props-main`.`id` = 1677676 OR `props-main`.`id` = 1657588 OR `props-main`.`id` = 1681076 OR `props-main`.`id` = 1657568 OR `props-main`.`id` = 1687097 OR `props-main`.`id` = 1677493 OR `props-main`.`id` = 1686231 OR `props-main`.`id` = 1686230 OR `props-main`.`id` = 1686236 OR `props-main`.`id` = 1684519 OR `props-main`.`id` = 1683722 OR `props-main`.`id` = 1637597 OR `props-main`.`id` = 1681250 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1676856 OR `props-main`.`id` = 1676897 OR `props-main`.`id` = 1688562 OR `props-main`.`id` = 1615610 OR `props-main`.`id` = 1614319 OR `props-main`.`id` = 1613643 OR `props-main`.`id` = 1685528 OR `props-main`.`id` = 1688188 OR `props-main`.`id` = 1657694 OR `props-main`.`id` = 1679737 OR `props-main`.`id` = 1689872 OR `props-main`.`id` = 1689894 OR `props-main`.`id` = 1689903 OR `props-main`.`id` = 1690996 OR `props-main`.`id` = 1690884 OR `props-main`.`id` = 1690885 OR `props-main`.`id` = 1636871 OR `props-main`.`id` = 1689008 OR `props-main`.`id` = 1676324 OR `props-main`.`id` = 1691064 OR `props-main`.`id` = 1691072 OR `props-main`.`id` = 1690461 OR `props-main`.`id` = 1690327 OR `props-main`.`id` = 1690394 OR `props-main`.`id` = 1690313 OR `props-main`.`id` = 1690838 OR `props-main`.`id` = 1686882 OR `props-main`.`id` = 1684453 OR `props-main`.`id` = 1680768 OR `props-main`.`id` = 1691002 OR `props-main`.`id` = 1690789 OR `props-main`.`id` = 1691019 OR `props-main`.`id` = 1688765 OR `props-main`.`id` = 1688755 OR `props-main`.`id` = 1688795 OR `props-main`.`id` = 1689010 OR `props-main`.`id` = 1673193 OR `props-main`.`id` = 1690308 OR `props-main`.`id` = 1658281 OR `props-main`.`id` = 1649972 OR `props-main`.`id` = 1680031 OR `props-main`.`id` = 1680275 OR `props-main`.`id` = 1685942 OR `props-main`.`id` = 1684996 OR `props-main`.`id` = 1684097 OR `props-main`.`id` = 1684104 OR `props-main`.`id` = 1684098 OR `props-main`.`id` = 1684111 OR `props-main`.`id` = 1684598)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings232929' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-24' 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 J. Nicole Kennedy, Jo-Ann Nicole Yvette Kennedy
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.
