Here's a great opportunity for investment. This property is one of 11 being sold together. Offers for one property or another may be considered by the seller. This is a tenant occupied property. Please do not disturb the tenants. This 5 bed 2 bath house with 1919 sq feet has a large lot of 6075 sq ft. Call an agent for more details.
Property Type
Residential
Property Subtype 1
Single Family Residence
Description / Subtype
Contemporary
Year Built
1961
Location
City
Stories
1
Price Per Square Foot
$195
Price Per Acre
$2,688,172
Cumulative Days On Market
22
County
Kings
New Construction
No
HUD
No
Foreclosure
No
Short Sale
No
Directions
From Hwy 198 take the 12th Ave exit. Turn south on to S 12th Ave. Turn right onto W Hanford-Armona Rd. G Turn left onto Woodland Dr. Turn right onto Lincolnwood Cir. Turn right onto Lincolnwood Cir. Arrive at Lincolnwood Cir. Your destination is on the right.
Heating Systems
Natural Gas, Central
Cooling
Ceiling Fan(s), Central
Water Heater Types
Gas
Laundry
220V/Electric,Room,Gas
Roof
Composition
Windows
Dual Pane
Permanent Foundation
Slab
Possible Bedrooms
6
Full Bathrooms
2
Appliances Included
Dishwasher, Gas Range/Oven
Basement Foundation
Slab
Floors
Carpet, Tile Floors
Exterior
Stucco
Pool Private Y/N
No
Spa Y/N
No
Utilities
220 Volts,Natural Gas Connected,All Public
Water Supply
Public
Sewer
Public Sewer
Solar Y/N
No
Garage Type
Converted
Road Surface
Paved
Horse Property Y/N
No
APN Number
011 090 025 000
Zoning
R16
Association
Kings County Multiple Listing Service
Currently Rented
Yes
Monthly Rent Amount
1700.00
Lease Type
Net
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1669 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2169 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` = 1694201 OR `props-main`.`id` = 1693870 OR `props-main`.`id` = 1693668 OR `props-main`.`id` = 1693865 OR `props-main`.`id` = 1695834 OR `props-main`.`id` = 1685402 OR `props-main`.`id` = 1693846 OR `props-main`.`id` = 1696872 OR `props-main`.`id` = 1696871 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` = 1695467 OR `props-main`.`id` = 1696251 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` = 1687940 OR `props-main`.`id` = 1693885 OR `props-main`.`id` = 1695420 OR `props-main`.`id` = 1696113 OR `props-main`.`id` = 1695957 OR `props-main`.`id` = 1695977 OR `props-main`.`id` = 1694359 OR `props-main`.`id` = 1694643 OR `props-main`.`id` = 1692213 OR `props-main`.`id` = 1692212 OR `props-main`.`id` = 1695172 OR `props-main`.`id` = 1673823 OR `props-main`.`id` = 1692366 OR `props-main`.`id` = 1692368 OR `props-main`.`id` = 1692412 OR `props-main`.`id` = 1695879 OR `props-main`.`id` = 1667593 OR `props-main`.`id` = 1693627 OR `props-main`.`id` = 1693626 OR `props-main`.`id` = 1693629 OR `props-main`.`id` = 1693926 OR `props-main`.`id` = 1696589 OR `props-main`.`id` = 1662106 OR `props-main`.`id` = 1685836 OR `props-main`.`id` = 1685837 OR `props-main`.`id` = 1571373 OR `props-main`.`id` = 1571371 OR `props-main`.`id` = 1686895 OR `props-main`.`id` = 1681814 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` = 1622949 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1694609 OR `props-main`.`id` = 1694611 OR `props-main`.`id` = 1692170 OR `props-main`.`id` = 1695719 OR `props-main`.`id` = 1691177 OR `props-main`.`id` = 1687255 OR `props-main`.`id` = 1696696 OR `props-main`.`id` = 1696697 OR `props-main`.`id` = 1696698 OR `props-main`.`id` = 1696700 OR `props-main`.`id` = 1696701 OR `props-main`.`id` = 1693452 OR `props-main`.`id` = 1696314 OR `props-main`.`id` = 1696280 OR `props-main`.`id` = 1683661 OR `props-main`.`id` = 1668439 OR `props-main`.`id` = 1668454 OR `props-main`.`id` = 1668433 OR `props-main`.`id` = 1668444 OR `props-main`.`id` = 1688638 OR `props-main`.`id` = 1642940 OR `props-main`.`id` = 1644759 OR `props-main`.`id` = 1657138)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings233153' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-05' 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 Matthew Thompson, Century 21 Jordan-Link & Company
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.
