Title Page Background
DEBUG FN args: Array ( [0] => 1736 [1] => [2] => [3] => agent ) BEFORE: Site: 1736 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1736 Igate: njhud LocID: 1736 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 = 1736 AND i.igate IN ('orhud','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 = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1736 [1] => [2] => [3] => lender ) BEFORE: Site: 1736 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1736 Igate: njhud LocID: 1736 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 = 1736 AND i.igate IN ('orhud','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 = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1736 [1] => [2] => [3] => other ) BEFORE: Site: 1736 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1736 Igate: njhud LocID: 1736 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 = 1736 AND i.igate IN ('orhud','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 = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

240336 Highland Road
Scottsbluff, NE 69361
Alecia Kraupie with Kraupie's Real Estate & Auctioneers, original listing - (308) 262-1150

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $625,000
Beds: 4
Baths: Full: 1, ½: 2
Status: Active
SqFt: 1323 Square Feet
Agency: Kraupie's Real Estate & Auctioneers
Agency Phone: (308) 262-1150

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1918
Notes: This beautiful, recently remodeled home sits on two acres roughly a quarter of a mile North of Highland Road and half a mile East of Lacy Park in Scottsbluff, NE. This stunning property offers a private escape from the city while also offering the convenience of being less than 10 minutes away from the heart of downtown Scottsbluff. The property features two finished detached garages, and a small storage shed as well as room for an additional building. The home comes with a large 469 square foot wood deck overlooking a beautiful yard with over 30 mature trees and a new underground sprinkler system. All the structures on the property have new stucco and new asphalt roofs. The North garage is 24' x 32' with two new insulated overhead doors and features a small lighted storage area above. The garage closer to the home is new and slightly larger at 30' x30' and also features two new insulated overhead doors. Between the two garages is new colored concrete. The property is also on a well system and has two septic tanks. The 2,433 square foot home comes with four bedrooms, two living rooms, one full bathroom, two 3/4 bathrooms, a laundry/utility room, and a pantry. The water heater, plumbing, wiring, flooring, carpet, doors, cabinets, toilets, mirrors, vanities, switches, fixtures, and trim are all new. All the windows in the kitchen are new Pella windows. It features a modern kitchen with new quartz counters and brand-new Frigidaire Gallery appliances. The home also incorporates a new water softening system as well as central air. Overall, this property is a perfect single-family home. This nearly new home has the newest trends in design and state-of-the-art lighting. The hard work is done and all you have to do is move in and enjoy! Call Today for an appointment.
MlsNumber: --
ListingId: 11392840


Listing Provided By: Kraupie's Real Estate & Auctioneers, original listing
Phone: (308) 262-1150
Office Phone: (308) 262-1150
Agent Name: Alecia Kraupie
Disclaimer: Copyright © 2024 My State 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