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 ('azhud','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 = 'azhud', 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 ('azhud','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 = 'azhud', 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 ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

680 E 1050 S
Pima, AZ 85546

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $445,000
Beds: 4
Baths:
Status: Active Under Contract
SqFt: 2313 Square Feet
Agency: Seek Legacy

Map Details Show Map | Show StreetView




House Features

Appliances: Microwave, Range, Garbage Disposer
Architectural Style: Ranch
Construction Materials: Stucco, Frame
Flooring: Carpet, Tile
Heating: Heat Pump
Interior Features: Ceiling Fans, Flooring- Carpet, Flooring- Tile, Window Coverings, Walk-in Closets, Smoke Detectors
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Exterior Features: Pool, Fenced- Full, Sidewalks, Swimming Pool, View of Mountains, Landscape- Partial, Rv/Boat Parking, Patio- Covered, Road Type- Paved, Fema Flood Ins (not Required)
Fencing: Fenced, Full
Other Features: RV/Boat Storage
Patio and Porch Features: Patio
Roof: Shingle

Neighborhood/Schools

Elementary School/District: Pima
Middle/Junior High School/District:
High School/District: Pima
Subvidision Name: Alder Heights

Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Welcome to your dream home nestled in the desirable Alder Heights! This stunning home offers many desirable features and luxurious amenities. Including 10 foot ceilings, spacious 1 acre fenced in backyard with covered patio, built in bbq grill connected with gas, and your own pool! As you step inside, you'll be greeted by beautiful tile flooring that flows seamlessly throughout the great room, creating a cohesive and trendy atmosphere. The open-concept layout floor plan allows for easy navigation and a sense of spaciousness.The upgraded kitchen is a chef's delight. Adorned with plenty of dark cabinets, and granite countertops it radiates elegance and sophistication. Prepare meals and entertain guests effortlessly in this well-appointed kitchen inluding a walk in pantry and breakfast nook. The principle bedroom is a tranquil retreat. The en-suite features tall ceilings and the bathroom boasts a walk-in snail shower with floor-to-ceiling tile offering a luxurious and modern aesthetic. Take a step outside to your large covered patio and enjoy the scenic views of the Mountains. Every detail in this home has been meticulously designed with your needs in mind. Make an appointment today!
MlsNumber: --


Listing Provided By: Seek Legacy, original listing
Phone: (928) 424-5555
Office Phone: (928) 424-5555
Agent Name: Randy Pozo
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