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

383 W 800 St
Pima, AZ 85543

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $490,415
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2281 Square Feet
Agency: KeyHole Properties

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Range, Refrigerator, Garbage Disposer
Architectural Style: Other
Flooring: Laminate
Heating: Forced Air
Interior Features: Ceiling Fans, Garden Tub, Flooring- Laminate, Window Coverings, Walk-in Closets, Smoke Detectors
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Exterior Features: Corner Lot, Horse Property, View of Mountains, Fenced- Partial, Patio- Covered, Road Type- Dirt
Fencing: Fenced
Patio and Porch Features: Patio
Roof: Shingle

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Pima

Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Welcome to your dream farmhouse nestled on a spacious 1.3-acre lot in the serene landscapes of Pima, AZ. This charming single-family home, exuding quintessential farmhouse elegance, offers the perfect blend of modern amenities and rustic charm. Step into the heart of the home, where a stunning apron sink and gleaming stainless-steel appliances await in the spacious kitchen with the center island, inviting you to indulge in culinary adventures and gatherings with loved ones. With 2281 square feet of thoughtfully designed living space, this home provides ample room for both relaxation and entertainment. Boasting four bedrooms and two bathrooms, including a luxurious principal suite, this residence offers comfortable accommodation for the whole family. The principal suite is a serene retreat, featuring ample closet space and a spa-like ensuite bathroom, providing the perfect oasis to unwind after a long day. Nestled on a desirable corner lot, this property offers plenty of space for outdoor recreation and entertaining. Don't miss the opportunity to make this enchanting farmhouse your own, where modern luxury meets rustic charm.
MlsNumber: --


Listing Provided By: KeyHole Properties, original listing
Phone: (928) 965-8091
Office Phone: (928) 965-8091
Agent Name: Kym Gifford
Disclaimer: Copyright © 2024 Gila Valley 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