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 = 2797 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 = 2797 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 = 2797 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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;

7050 N River Valley
Peoa, UT 84061
Gregory Miner with KW Park City Keller Williams Real Estate, original listing - (435) 649-9882

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,750,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: --
Agency: KW Park City Keller Williams Real Estate
Agency Phone: (435) 649-9882

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: This stunning property is nestled on the banks of the Weber River, with over 500' of private shoreline, and features 12.44 fenced acres, with a beautiful custom, 5-bed/4-bath home. With a seven-acre productive hay pasture, frequent visits from palustrine wildlife, and majestic river views, the property feels a world apart from nearby Park City, UT. As you enter the home, beautiful Italian wood-look porcelain tile and warm decor greet you. The floor plan is perfect for entertaining guests or relaxing after a day fishing or skiing. The main living area features large windows, vaulted ceilings, built-ins, and a warm stone hearth and fireplace. The gourmet kitchen is a chef's dream, complete with Italian marble counters, high-end appliances, and storage galore. Enjoy meals in the built-in dining room or outside on the large riverside patio-taking in the sights and sounds of the surrounding landscape. The primary suite is an oasis, boasting a large, ensuite bathroom with soaking tub, double vanity, and walk-in shower. A second bedroom downstairs offers the potential for main-level living for those desiring an office. The additional three bedrooms upstairs are comfortable, providing plenty of room for guests or family members. Two separate upstairs landings ensure privacy between the main living areas and the bunk and entertainment room over the garage. Outside, you will find a beautifully landscaped yard with mature trees, fire pit, and boulders. And, the spacious garage provides ample room for vehicles and toys. Want something no one else can have? This home is located closer to the water's edge than could be replicated under current development regulations. River serenity like nowhere else. The property can also be further customized with a guest house and agricultural out buildings such as equestrian barns or run-ins, as can be found on other properties in the exclusive 6-lot subdivision. Need more space? The adjoining lot is also available.
MlsNumber: --
ListingId: 2002025


Listing Provided By: KW Park City Keller Williams Real Estate, original listing
Phone: (435) 649-9882
Office Phone: (435) 649-9882
Agent Name: Gregory Miner
Disclaimer: Copyright © 2024 UtahRealEstate.com. 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 = 2797 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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;
Real Estate Expert Photo for Alex Hoeker
Alex Hoeker
ASCIIKeller Williams Realty
Call Today!: (603) 545-4343

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App