Title Page Background
HFQUERY 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 = 69 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 69 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 69 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

5610 Huffman Road
Anchorage, AK 99516

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,150,000
Beds: 5
Baths: 5
Status: Active
SqFt: 6032
Agency: RE/MAX Dynamic Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2022
Notes: THE MOST DREAMY HOME is Here! Over 6000 SF Featuring 5 BRs/4.5 BA's, Plus Office + Exercise Rooms, 2.3 Acres, Radiant In-Floor Heat, 2-Story Great Room w/ Wall of Windows & Electric Blinds. Upgrades Galore~See Feature List in Supplement. Brand New Hot Tub, Game Room Wired for Golf Simulator, Small Den w/Theater Wiring. Main Lvl Bedroom Suite. Serene Setting Surrounded by Mature Trees+Flat Acreage Features:<br /> RV pad installed with Septic dump, 50 amp RV plug wiring, and water hook ups next to garage.<br /> House is wired for an external emergency generator <br /> Wiring for backyard lighting (i.e. ice rink, spot lights) <br /> Plumbing for irrigation system in place<br /> Under Eve outlets for Christmas lights operated by switch located in the guest coat closet<br /> Double oven with Steam oven on top<br /> Microwave drawer<br /> Double dishwashers<br /> Wiring for wine cellar installed, as well as vapor barrier and no heat tubing in that area for heat control <br /> Wiring for golf simulator room installed <br /> Wiring for surround sound in "theater room" installed<br /> Wiring for 2, 20 amp exercise equipment installed in exercise room <br /> Surround sound speakers and sub installed in family room<br /> Office is insulated for sound dampening<br /> Hot/cold hose bib installed inside garage next to utility sink<br /> Dog wash pluming available in garage<br /> Laundry room has sink and steam closet<br /> Epoxy garage floors<br /> Custom entry chandelier <br /> Under-cabinet lighting in kitchen <br /> Reverse osmosis drinking water spout<br /> Water filtration system<br /> Hot tub <br /> Wireless electric blinds<br /> Remote fireplace <br /> 15 heat zones of in floor heat <br /> Ceiling fans in 4 bedrooms <br /> Waterfall counters in island with outlet on both ends<br /> Concrete border along driveway
MlsNumber: 24-2262


Listing Provided By: RE/MAX Dynamic Properties, original listing
Name: RE/MAX Dynamic Properties
Phone: (907) 261-7616
Office Name: RE/MAX Dynamic Properties
Office Phone: (907) 865-4700
Agent Name: Laura Halverson
Disclaimer: Copyright © 2024 Alaska Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY 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 = 69 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Peter Jarratt
ASCIIHerrington & Company, LLC
Call Today!: (907) 240-6059

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App