NOT LISTED FOR SALE

Estimated Value: $2,361,000 - $2,477,887

3 Beds
3.5 Baths
2,503 Sq Ft
2,178 Sq Ft Lot

Last Sold December 03, 2013

Last sale price $1,375,000 $549 Per Sq Ft

Est. 75% increase in value since last sale

Current estimated payment $13,916/month

92 Days on Market

Highlights

  • Concierge
  • Fitness Center
  • Unit is on the top floor
  • Hopi Elementary School Rated A
  • Gated with Attendant
  • Heated Spa

About This Home

As of December 2013

The Scottsdale Waterfront Residences is a place you can conveniently walk to nearly 500 shops, including Scottsdale Fashion Square, more than 95 restaurants, nearly 70 art galleries and almost 50 salons and spas, making it the most pedestrian friendly development in the Valley. These full service buildings offer 24 hour security, concierge, valet parking, fitness center, roof top pool and a gorgeous clubroom for entertaining. This 3 bedroom, 3 .5 bath unit is great for entertaining in the large great room, with North facing views of Camelback mountain. This home has many upgrades, including custom lighting, marble, granite and upgraded carpets in bedrooms and the great room. Must see, call listing agent for an appointment.

Last Agent to Sell the Property

Babbi Gabel

RETSY License #SA028866000 Listed on: 08/05/2013

RETSY

Co-Listed By

Angela Phillips

RETSY License #SA573327000

Last Buyer's Agent

Lauren Ellington

Realty Executives License #SA542605000

Realty Executives

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $7,224

Year Built

  • Built in 2007

Lot Details

  • Waterfront
  • End Unit
  • Two or More Common Walls

Parking

  • 2 Car Garage
  • Gated Parking
  • Assigned Parking
  • Community Parking Structure

Property Views

  • City Lights

Home Design

  • Tile Roof
  • Foam Roof
  • Stone Exterior Construction
  • Metal Construction or Metal Frame
  • Stucco

Interior Spaces

  • 2,503 Sq Ft Home
  • Ceiling height of 9 feet or more
  • Gas Fireplace
  • Double Pane Windows
  • Living Room with Fireplace
  • Security System Owned

Kitchen

  • Gas Cooktop
  • Built-In Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops

Flooring

  • Carpet
  • Stone

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • 3.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Pool

  • Heated Spa
  • Heated Pool

Location

  • Unit is on the top floor
  • Property is near a bus stop

Schools

  • Hopi Elementary School
  • Ingleside Middle School
  • Acacia Elementary High School

Utilities

  • Refrigerated Cooling System
  • Zoned Heating
  • Water Softener
  • Cable TV Available

Additional Features

  • Stepless Entry

Listing and Financial Details

  • Tax Lot 801-2
  • Assessor Parcel Number 173-42-290

Community Details

Overview

  • Property has a Home Owners Association
  • Aam Association, Phone Number (602) 957-9191
  • High-Rise Condominium
  • Built by Opus/Edmunds
  • Scottsdale Waterfront Residences Subdivision, Residence 'A' Floorplan
  • 13-Story Property

Amenities

  • Concierge
  • Valet Parking
  • Recreation Room

Recreation

  • Community Spa
  • Bike Trail

Security

  • Gated with Attendant
  • Fire Sprinkler System

Property Details

Home Type

Condominium

Est. Annual Taxes

$7,224

Year Built

Built in 2007

Lot Details

0

Parking

2

Listing Details

  • Cross Street: Camelback and Marshall Way
  • Legal Info Range: 4E
  • Property Type: Residential
  • HOA #2: N
  • HOA #3 Fee: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 1583.0
  • Basement: N
  • Parking Spaces Total Covered Spaces: 2.0
  • Year Built: 2007
  • Tax Year: 2012
  • Directions: From Scottsdale, head West on Camelback to Marshall Way, south to buildings.
  • Master Model: Residence 'A'
  • Property Sub Type: Apartment Style/Flat
  • Lot Size Acres: 0.05
  • Co List Office Mls Id: swlp01
  • Co List Office Phone: 480-596-0001
  • Subdivision Name: Scottsdale Waterfront Residences
  • Architectural Style: Other (See Remarks)
  • Efficiency: Multi-Zones
  • ResoBuildingAreaSource: Builder
  • Association Fees:HOA Fee2: 1583.0
  • Special Features: None

Interior Features

  • Basement: None
  • Flooring: Carpet, Stone
  • Spa Features: Community, Heated, None
  • Accessibility Features: Zero-Grade Entry
  • Possible Bedrooms: 3
  • Total Bedrooms: 3
  • Fireplace Features: 1 Fireplace, Living Room, Gas
  • Fireplace: Yes
  • Interior Amenities: Walk-In Closet(s), 9+ Flat Ceilings, Elevator, Fire Sprinklers, Soft Water Loop, Kitchen Island, Pantry, Double Vanity, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets, Granite Counters
  • Living Area: 2503.0
  • Stories: 13
  • Window Features: Double Pane Windows
  • ResoLivingAreaSource: Builder
  • Community Features:ClubhouseRec Room: Yes
  • Kitchen Features:Dishwasher2: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Fireplace:_one_ Fireplace: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Community Features:BikingWalking Path: Yes
  • Community Features:Community Pool Htd: Yes
  • Community Features:Community Spa Htd: Yes
  • Community Features:Guarded Entry: Yes
  • Community Features:Workout Facility: Yes
  • Kitchen Features:Disposal2: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Great Room: Yes
  • Fireplace:Gas Fireplace: Yes
  • Community Features:On-Site Guard: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Community Features:Near Bus Stop: Yes
  • Kitchen Features:Cook Top Gas: Yes
  • Fireplace:Fireplace Living Rm: Yes
  • Community Features:Concierge: Yes

Exterior Features

  • Fencing: None
  • Exterior Features: Balcony
  • Pool Features: Community, Heated, None
  • View: City Lights, Mountain(s)
  • Waterfront: Yes
  • Disclosures: Seller Discl Avail
  • Common Walls: Two Common Walls, Neighbor Below, Neighbor Above, End Unit
  • Construction Type: Painted, Stucco, Stone, Frame - Metal
  • Roof: Tile, Foam
  • Construction:Frame - Metal: Yes
  • Exterior Features:Balcony: Yes

Garage/Parking

  • Total Covered Spaces: 2.0
  • Parking Features: Separate Strge Area, Assigned, Community Structure, Gated, Valet
  • Attached Garage: No
  • Garage Spaces: 2.0
  • Parking Features:Assigned Parking: Yes
  • Parking Features:Gated Parking: Yes
  • Parking Features:Separate Strge Area: Yes
  • Parking Features:Community Structure: Yes
  • Parking Features:Valet: Yes

Utilities

  • Utilities: Other, See Remarks
  • Cooling: Refrigeration
  • Heating: Electric
  • Laundry Features: Dryer Included, Inside, Washer Included
  • Security: Security System Owned, Security Guard
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Community Features: Near Bus Stop, Guarded Entry, Concierge, Biking/Walking Path, Clubhouse, Fitness Center
  • Amenities: Management
  • Association Fee Frequency: Monthly
  • Association Name: AAM
  • Phone: 602-957-9191
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Transfer Fee2: 375.0
  • Association Fees:HOA Paid Frequency: Monthly
  • Association Fees:HOA Name4: AAM
  • Association Fees:HOA Telephone4: 602-957-9191
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: %
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: %
  • Association Fee Incl:Front Yard Maint: Yes
  • Association Fee Incl:Exterior Mnt of Unit: Yes
  • Association Fee Incl:Roof Repair: Yes
  • Association Fee Incl:Roof Replacement: Yes
  • Association Fee Incl:Blanket Ins Policy: Yes
  • Association Fee Incl:Water6: Yes
  • Association Fee Incl:Sewer6: Yes
  • Association Fee Incl:Garbage Collection2: Yes
  • Association Fee Incl:Pest Control: Yes
  • Association Fee Incl:Cable or Satellite: Yes

Schools

  • Elementary School: Hopi Elementary School
  • High School: Acacia Elementary School
  • Middle Or Junior School: Ingleside Middle School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 2336.0
  • Parcel #: 173-42-290
  • ResoLotSizeUnits: SquareFeet

Green Features

  • Green Water Conservation: Recirculation Pump

Building Info

  • Builder Name: Opus/Edmunds

Tax Info

  • Tax Annual Amount: 7224.0
  • Tax Book Number: 173.00
  • Tax Lot: 801-2
  • Tax Map Number: 42.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Oct 24, 2024
Sold by
William Max Mcgee Qtip Marital Trust and Mcgee Denise Rae
Bought by
Denise Rae Mcgee Trust and Mcgee
Current Estimated Value
$2,406,472

Purchase Details

Closed on
Sep 14, 2017
Sold by
One Investments Llc
Bought by
Mcgee Denise Rae and Denise Rae Mcgee Trust

Purchase Details

Listed on
Aug 5, 2013
Closed on
Nov 6, 2013
Sold by
Sheffield Larry and Sheffield Tara
Bought by
One Investments Llc
Seller's Agent
Babbi Gabel
RETSY
Buyer's Agent
Lauren Ellington
Realty Executives
List Price
$1,550,000
Sold Price
$1,375,000
Premium/Discount to List
-$175,000
-11.29%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.37%

Purchase Details

Closed on
Aug 9, 2013
Sold by
Sm Waterfront Condo Llc
Bought by
Sheffield Larry and Sheffield Tara

Purchase Details

Closed on
Jun 23, 2010
Sold by
Sheffield Larry L and Sheffield Tara G
Bought by
Sm Waterfront Condo Llc

Purchase Details

Closed on
Feb 28, 2007
Sold by
Waterfront Residences Llc
Bought by
Sheffield Larry L and Sheffield Tara G

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$173,575
Interest Rate
6.29%
Mortgage Type
Credit Line Revolving
Source: Public Records

Similar Homes in Scottsdale, AZ

  • 4849 N Camelback Ridge Rd Unit A106, Scottsdale, AZ 85251

    $2,995,000

    • 2 Beds
    • 3 Baths
    • 2,244 Sq Ft
    • 4849 N Camelback Ridge Rd
    • Unit A106
    • Scottsdale, AZ

    Tucked at the base of revered Camelback Mountain, Ascent is a new, private residential enclave adjacent to The Phoenician Resort - one of Arizona's premier luxury resort destination. This community incorporates the Sonoran Desert landscape directly into its design, at the most enviable location in Scottsdale. Ascent offer views overlooking the Valley & Camelback Mountain. Home designs feature

    Leslie Jenkins Russ Lyon Sotheby's International Realty

    Section Image
  • 4849 N Camelback Ridge Rd Unit B202, Scottsdale, AZ 85251

    $2,695,000

    • 2 Beds
    • 3 Baths
    • 2,318 Sq Ft
    • 4849 N Camelback Ridge Rd
    • Unit B202
    • Scottsdale, AZ

    Tucked at the base of revered Camelback Mountain, Ascent is a new, private residential enclave adjacent to The Phoenician Resort - one of Arizona's premier luxury resort destination. This community incorporates the Sonoran Desert landscape directly into its design, at the most enviable location in Scottsdale. Ascent offer views overlooking the Valley & Camelback Mountain. Home designs feature

    Leslie Jenkins Russ Lyon Sotheby's International Realty

    Section Image
  • 4849 N Camelback Ridge Rd Unit B206, Scottsdale, AZ 85251

    $2,550,000

    • 2 Beds
    • 3 Baths
    • 2,510 Sq Ft
    • 4849 N Camelback Ridge Rd
    • Unit B206
    • Scottsdale, AZ

    This unique loft style home features 20' ceilings in the living area with spacious indoor/outdoor living and a lower garden/yard. This home is exceptional with its soaring ceilings and phenomenal views of Camelback Mountain. Featuring 1 bedroom, 2 full baths, a den and 2 reserved parking spaces. Tucked at the base of Camelback Mountain, Ascent is a new, private gated residential enclave adjacent

    Joe Bushong Russ Lyon Sotheby's International Realty

    Section Image
  • 4849 N Camelback Ridge Rd Unit A309, Scottsdale, AZ 85251

    $2,875,000

    • 2 Beds
    • 3 Baths
    • 2,294 Sq Ft
    • 4849 N Camelback Ridge Rd
    • Unit A309
    • Scottsdale, AZ

    This unique loft style home features 20' ceilings in the living area with spacious indoor/outdoor living and a lower garden/yard. This home is exceptional with its soaring ceilings and phenomenal views of Camelback Mountain. Featuring 1 bedroom, 2 full baths, a den and 2 reserved parking spaces. Tucked at the base of Camelback Mountain, Ascent is a new, private gated residential enclave adjacent

    Joe Bushong Russ Lyon Sotheby's International Realty

    Section Image
  • 4849 N Camelback Ridge Rd Unit A206, Scottsdale, AZ 85251

    $2,325,000

    • 2 Beds
    • 3 Baths
    • 2,244 Sq Ft
    • 4849 N Camelback Ridge Rd
    • Unit A206
    • Scottsdale, AZ

    Tucked at the base of revered Camelback Mountain, Ascent is a new, private residential enclave adjacent to The Phoenician Resort - one of Arizona's premier luxury resort destination. This community incorporates the Sonoran Desert landscape directly into its design, at the most enviable location in Scottsdale. Ascent offer views overlooking the Valley & Camelback Mountain. Home designs feature

    Leslie Jenkins Russ Lyon Sotheby's International Realty

    Section Image
  • 4849 N Camelback Ridge Rd Unit A102, Scottsdale, AZ 85251

    $2,995,000

    • 2 Beds
    • 3 Baths
    • 2,599 Sq Ft
    • 4849 N Camelback Ridge Rd
    • Unit A102
    • Scottsdale, AZ

    Tucked at the base of revered Camelback Mountain, Ascent is a new, private residential enclave adjacent to The Phoenician Resort - one of Arizona's premier luxury resort destination. This community incorporates the Sonoran Desert landscape directly into its design, at the most enviable location in Scottsdale. Ascent offer views overlooking the Valley & Camelback Mountain. Home designs feature

    Leslie Jenkins Russ Lyon Sotheby's International Realty

    Section Image
  • 4849 N Camelback Ridge Rd Unit B306, Scottsdale, AZ 85251

    $2,995,000

    • 2 Beds
    • 3 Baths
    • 2,510 Sq Ft
    • 4849 N Camelback Ridge Rd
    • Unit B306
    • Scottsdale, AZ

    Tucked at the base of revered Camelback Mountain, Ascent is a new, private residential enclave adjacent to The Phoenician Resort - one of Arizona's premier luxury resort destination. This community incorporates the Sonoran Desert landscape directly into its design, at the most enviable location in Scottsdale. Ascent offer views overlooking the Valley & Camelback Mountain. Home designs feature

    Leslie Jenkins Russ Lyon Sotheby's International Realty

    Section Image
  • 4849 N Camelback Ridge Rd Unit B203, Scottsdale, AZ 85251

    $2,395,000

    • 2 Beds
    • 3 Baths
    • 2,294 Sq Ft
    • 4849 N Camelback Ridge Rd
    • Unit B203
    • Scottsdale, AZ

    Tucked at the base of revered Camelback Mountain, Ascent is a new, private residential enclave adjacent to The Phoenician Resort - one of Arizona's premier luxury resort destination. This community incorporates the Sonoran Desert landscape directly into its design, at the most enviable location in Scottsdale. Ascent offer views overlooking the Valley & Camelback Mountain. Home designs feature

    Leslie Jenkins Russ Lyon Sotheby's International Realty

    Section Image
  • 4849 N Camelback Ridge Rd Unit A111, Scottsdale, AZ 85251

    $3,050,000

    • 2 Beds
    • 3 Baths
    • 2,497 Sq Ft
    • 4849 N Camelback Ridge Rd
    • Unit A111
    • Scottsdale, AZ

    This unique loft style home features 20' ceilings in the living area with spacious indoor/outdoor living and a lower garden/yard. This home is exceptional with its soaring ceilings and phenomenal views of Camelback Mountain. Featuring 1 bedroom, 2 full baths, a den and 2 reserved parking spaces. Tucked at the base of Camelback Mountain, Ascent is a new, private gated residential enclave adjacent

    Joe Bushong Russ Lyon Sotheby's International Realty

    Section Image

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Denise Rae Mcgee Trust -- None Listed On Document
Denise Rae Mcgee Trust -- None Listed On Document
Mcgee Denise Rae $1,550,000 First American Title Insuran
One Investments Llc $1,375,000 First American Title Insuran
Sheffield Larry -- None Available
Sm Waterfront Condo Llc $1,173,575 None Available
Sheffield Larry L $1,509,858 First American Title Ins Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Sheffield Larry L $173,575
Previous Owner Sheffield Larry L $1,000,000
Closed Sheffield Larry $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/03/2013 12/03/13 Sold $1,375,000 -11.3% $549 / Sq Ft
08/01/2013 08/01/13 For Sale $1,550,000 -- $619 / Sq Ft
Source: Arizona Regional Multiple Listing Service (ARMLS)

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $6,116 $119,766 -- --
2024 $7,410 $114,063 -- --
2023 $7,410 $154,020 $30,800 $123,220
2022 $6,999 $145,310 $29,060 $116,250
2021 $7,474 $132,080 $26,410 $105,670
2020 $7,404 $128,560 $25,710 $102,850
2019 $7,123 $118,520 $23,700 $94,820
2018 $6,878 $95,330 $19,060 $76,270
2017 $7,162 $98,570 $19,710 $78,860
2016 $7,023 $110,880 $22,170 $88,710
2015 $6,685 $104,680 $20,930 $83,750
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 4978073

Arizona Regional Multiple Listing Service (ARMLS)

APN: 173-42-290