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

331 N Quincy Ave
Hines, OR 97738
Mardy Stewart with Jett Blackburn Real Estate Inc., original listing - (541) 413-5660

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $250,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1924 Square Feet
Agency: Jett Blackburn Real Estate Inc.
Agency Phone: (541) 413-5660

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1963
Notes: This charming, well-kept home is ready for you to move in and enjoy! With many thoughtful upgrades throughout, it offers comfort and convenience. The kitchen features updated oak cabinets and a cozy dining area. There is carpet and laminate flooring running throughout the home, enhancing its appeal. The spacious bedrooms on the main floor provide plenty of room for relaxation. The basement adds valuable living space, including a versatile room that is currently used as a bedroom, a family room, a half bath, a laundry area, and a storage room. The exterior has also seen updates, including a new composition roof, vinyl siding, vinyl windows, and gutters for easy maintenance. You'll appreciate the carport and covered patio, offering sheltered access to the home, plus a convenient storage room attached to the carport. A shed in the backyard provides even more space for storage. There is also an underground sprinkler system for ease of yard care. The paved driveway adds to the home's curb appeal. Homes like this one don't come on the market often-make it yours before it's gone! TAXES: $2,030.95; FINANCING: Cash or conventional; YEAR BUILT: 1963; SQ. FT.: 1924 (962 main & 962 finished basement); LOT SIZE: 0.20; HEAT SOURCE: F/A furnace (4-5 yrs old); BEDROOMS: 2 possibly 3 (2 on main floor); BATHROOMS: 11/2 ; APPLIANCES: Range & dishwasher; GARAGE: Carport
MlsNumber: --
ListingId: 11428653


Listing Provided By: Jett Blackburn Real Estate Inc., original listing
Phone: (541) 413-5770
Office Phone: (541) 413-5660
Agent Name: Mardy Stewart
Disclaimer: Copyright © 2025 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