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

4747 N Scottsdale Road
Scottsdale, AZ 85251

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $820,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1945 Square Feet
Agency: HomeSmart

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Other
Year Built: 2008
Notes: Exceptional opportunity available for this exquisitely designed 3rd floor contemporary townhome that is sure to surpass expectations with its luxurious finishes, top-of-the-line appliances, expansive floor-to-ceiling windows, and two balconies. Situated in one of the most sought-after areas in the valley, this property offer distinctively sophisticated living experience. Upon entering, you will be welcomed into a chef's kitchen that overlooks the serene community Zen pool. The kitchen exudes elegance with its Scavolini cabinetry, Cambria Quartz countertops, and state-of-the-art Sub Zero and Bosch appliances. The generously appointed primary suite boasts its own private balcony and floor-to-ceiling glass windows, providing breathtaking views. The primary bathroom showcases dual vanities adorned with Waterworks fixtures, as well as a stunning "Shower Room" featuring a spacious soaking tub and shower surrounded by elegant neutral limestone tile detailing. Additionally, a large primary closet ensures ample storage space. This exceptional unit offers numerous upgrades, including a brand new Sub-Zero refrigerator, fully automated blinds in every room, and a washer-dryer. Furthermore, it provides the convenience of two covered underground parking spaces with electronic car charging capability. <br /> The award-winning community, designed by Miller/Hull, presents two community pools, a multitude of water and fire features, and direct access to the canal, which leads to the highly desirable Old Town Scottsdale for shopping and dining. The desirability of this location extends even further, as the back gate of the property grants access to scenic walking and biking paths along the Arizona Canal. Just west of Scottsdale Road, you will find the upscale Scottsdale Fashion Square and the new Caesars Republic, featuring renowned chef Giada and her three exceptional restaurants. Take this opportunity to unwind and embrace the vibrant lifestyle that Old Town Scottsdale offers, all just steps away from the Safari!
MlsNumber: --


Listing Provided By: HomeSmart, original listing
Phone: (602) 526-0424
Office Phone: (602) 230-7600
Agent Name: Fred Dougherty
Disclaimer: Copyright © 2024 Arizona Regional Multiple Listing Service, Inc. 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => maricopa-county-northeast [3] => AZ [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: maricopa-county-northeast State: AZ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: maricopa-county-northeast State: AZ 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 = 3425 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;
Real Estate Expert Photo for Melody Holehan-Kopas and Jay Kopas
Melody Holehan-Kopas and Jay Kopas
ASCIIHome Smart Elite Group - Kopas Home Team
Melody: (623) 910-5788
Jay: (623) 680-5183

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App