Title Page Background
DEBUG FN args: Array ( [0] => 197 [1] => [2] => [3] => agent ) BEFORE: Site: 197 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 197 Igate: njhud LocID: 197 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 197 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 197 [1] => [2] => [3] => lender ) BEFORE: Site: 197 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 197 Igate: njhud LocID: 197 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 197 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 197 [1] => [2] => [3] => other ) BEFORE: Site: 197 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 197 Igate: njhud LocID: 197 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 197 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2937 Higham Ave
Lake Isabella, CA 93240

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $99,500
Beds: 2
Baths:
Status: Active
SqFt: 1000 Square Feet
Agency: Freeman's Lakeside Realty

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator, Dryer, Washer/Dryer Combo
Architectural Style: Other
Cooling: Wall Unit(s) A/C
Flooring: Carpet, Wood, Hardwood
Interior Features: Flooring- Carpet, Flooring- Hardwood
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2

Window Features

Exterior Features: Corner Lot, Fenced- Full, Patio- Covered, Sprinklers- Drip System
Fencing: Fenced, Full
Patio and Porch Features: Patio
Roof: Shingle, Composition

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Lakeland Estates

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Mobile Home
Year Built: 1969
Notes: Location is key!!! single-wide mobile home sits right in town giving you access to not only the stores and amenities, but also being walking distance to the local library. The layout and size of 1,000 sqft gives you the opportunity to design and make this home your own! With the property being fully fenced, it allows the you to let your children or animals play through out the whole yard! Looking to have a nice area to relax and enjoy the weather? Luckily for you there are two covered patio's and a covered laundry space which makes it convenient and enjoyable on days such as the beautiful summer evenings. The seller is leaving all items including major furnishes, with the exception of few selected personal items that are in both the home and garage. Another feature this home has to offer is the double garage that was converted into a workshop supplying 220 Volt wiring. If you're looking for a comfortable place to live, that also offers you being close to all shopping and amenities, this is the place for you! The seller did a lot of work on the home, but is still being sold AS IS.
MlsNumber: --


Listing Provided By: Freeman's Lakeside Realty, original listing
Phone: (760) 379-5915
Office Phone: (760) 379-5915
Agent Name: Matthew Freeman
Disclaimer: Copyright © 2024 Southern Sierra MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App