NOT LISTED FOR SALE

29547 N 154th St Scottsdale, AZ 85262

Estimated Value: $743,000 - $979,000

3 Beds
3 Baths
2,245 Sq Ft
$375/Sq Ft Est. Value

Last Sold June 07, 2018

Last sale price $385,000 $171 Per Sq Ft

Est. 118% increase in value since last sale

Current estimated payment $4,577/month

212 Days on Market

Highlights

  • Mountain View
  • Vaulted Ceiling
  • Granite Countertops
  • Sonoran Trails Middle School Rated A-
  • Hydromassage or Jetted Bathtub
  • No HOA

About This Home

As of June 2018

Home has an open floor plan with bedrooms split. Each bedroom with private bath and of good size. Front views to Four Peaks and morning sun rises.... kitchen with computer center and access to rear patio. Room for pool and spa on the west side of home. Large two car garage extra deep with above storage plus large detached garage with 14 ft ceiling.
Home is on lockbox. Please knock first!

Last Agent to Sell the Property

K Anderson

Hohokam Real Estate and Land Company, Inc. License #BR009233000 Listed on: 08/22/2017

Last Buyer's Agent

Terry Allen

Arizona Realty Central License #BR625113000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,274

Year Built

  • Built in 2009

Lot Details

  • 1 Acre Lot
  • Wrought Iron Fence
  • Front Yard Sprinklers

Parking

  • 4 Car Detached Garage
  • 10 Open Parking Spaces
  • Garage ceiling height seven feet or more
  • Garage Door Opener

Home Design

  • Wood Frame Construction
  • Composition Roof
  • Stucco

Interior Spaces

  • 2,245 Sq Ft Home
  • 1-Story Property
  • Vaulted Ceiling
  • Ceiling Fan
  • Double Pane Windows
  • Low Emissivity Windows
  • Mountain Views
  • Washer and Dryer Hookup

Kitchen

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

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

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

Schools

  • Desert Sun Academy Elementary School
  • Sonoran Sky Elementary School - Scottsdale Middle School
  • Cactus Shadows High School

Utilities

  • Refrigerated Cooling System
  • Zoned Heating
  • Well
  • Septic Tank

Additional Features

  • No Interior Steps
  • Gray Water System
  • Covered patio or porch

Community Details

  • No Home Owners Association
  • Built by Custom
  • Rio Verdi Foothills Subdivision

Listing and Financial Details

  • Tax Lot 001
  • Assessor Parcel Number 219-37-032-N

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,274

Year Built

Built in 2009

Lot Details

0

Parking

4

Listing Details

  • Cross Street: Rio Verde and 152nd Street
  • Legal Info Range: 6E
  • Property Type: Residential
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Basement: N
  • Parking Spaces Slab Parking Spaces: 10.0
  • Parking Spaces Total Covered Spaces: 4.0
  • Separate Den Office Sep Den Office: N
  • Year Built: 2009
  • Tax Year: 2016
  • Directions: Take Rio Verde to 152nd St North to Dixileta Dr then go East to 154th St South to Dr on the left (look for sign at drive on east side of 154th. or just past third house on the left side). Gate w/sign.
  • Property Sub Type: Single Family - Detached
  • Lot Size Acres: 1.0
  • Subdivision Name: Rio Verdi Foothills
  • Architectural Style: Ranch
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • Tax Parcel Letter: N
  • ResoBuildingAreaSource: Assessor
  • Special Features: VirtualTour

Interior Features

  • Flooring: Carpet, Tile
  • Spa Features: None
  • Possible Bedrooms: 3
  • Total Bedrooms: 3
  • Fireplace Features: None
  • Fireplace: No
  • Interior Amenities: Master Downstairs, Walk-In Closet(s), No Interior Steps, Vaulted Ceiling(s), Kitchen Island, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets, Granite Counters
  • Living Area: 2245.0
  • Stories: 1
  • Window Features: Double Pane Windows, Low Emissivity Windows
  • Fireplace:No Fireplace: Yes
  • Kitchen Features:RangeOven Elec: Yes
  • Kitchen Features:Dishwasher2: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Kitchen Features:Disposal2: Yes
  • Kitchen Features:Refrigerator2: Yes
  • Other Rooms:Great Room: Yes
  • Kitchen Features:Cook Top Elec: Yes

Exterior Features

  • Fencing: Wrought Iron
  • Exterior Features: Covered Patio(s), Patio
  • Lot Features: Sprinklers In Front, Dirt Front, Dirt Back
  • Pool Features: None
  • View: Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Painted, Stucco, Frame - Wood
  • Roof: Composition
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Patio: Yes

Garage/Parking

  • Total Covered Spaces: 4.0
  • Parking Features: Electric Door Opener, Extnded Lngth Garage, Over Height Garage, Detached, RV Access/Parking
  • Attached Garage: No
  • Garage Spaces: 4.0
  • Open Parking Spaces: 10.0
  • Parking Features:Electric Door Opener: Yes
  • Parking Features:Extnded Lngth Garage: Yes
  • Parking Features:RV Parking: Yes
  • Parking Features:Detached: Yes
  • Parking Features:Over Height Garage: Yes

Utilities

  • Cooling: Refrigeration, Ceiling Fan(s)
  • Heating: Electric
  • Laundry Features: Wshr/Dry HookUp Only
  • Water Source: Well
  • Heating:Electric: Yes
  • Sewer Septic Tank: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Fees:HOA YN2: N
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: %
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: %
  • Association Fee Incl:No Fees: Yes

Schools

  • Elementary School: Desert Sun Academy
  • High School: Cactus Shadows High School
  • Middle Or Junior School: Sonoran Sky Elementary School - Scottsdale

Lot Info

  • Horse Amenities: Other, See Remarks
  • Land Lease: No
  • Lot Size Sq Ft: 43558.0
  • Parcel #: 219-37-032-N
  • ResoLotSizeUnits: SquareFeet

Green Features

  • Green Water Conservation: Gray Water System

Building Info

  • Builder Name: Custom

Tax Info

  • Tax Annual Amount: 1274.0
  • Tax Book Number: 219.00
  • Tax Lot: 001
  • Tax Map Number: 37.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 22, 2017
Closed on
May 29, 2018
Sold by
Hildrebrandt Robert R and Robert R Hildrebrandt Living T
Bought by
Scott Brent J
Seller's Agent
K Anderson
Hohokam Real Estate and Land Company, Inc.
Buyer's Agent
Terry Allen
Arizona Realty Central
List Price
$385,000
Sold Price
$385,000
Total Days on Market
212
Current Estimated Value
$841,020

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$456,020
Avg. Annual Appreciation
11.76%
Original Mortgage
$308,000
Interest Rate
4.5%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 10, 2009
Sold by
Hildrebrandt Robert R
Bought by
Hildrebrandt Robert R and Robert R Hildrebrandt Living T

Purchase Details

Closed on
Apr 21, 2009
Sold by
Hildebrandt Sharon A Saba and Hildebrandt Robert R
Bought by
Hildebrandt Robert R

Purchase Details

Closed on
Jul 19, 2005
Sold by
Hildebrandt Robert R and Hildebrandt Sharon S
Bought by
Hildebrandt Robert R and Hildebrandt Sharon A

Purchase Details

Closed on
Jan 13, 2004
Sold by
Russell Kenneth R
Bought by
Hildebrandt Robert R and Hildebrandt Sharon S

Purchase Details

Closed on
Jun 22, 2001
Sold by
Lagin Steven M
Bought by
Russell Kenneth R
Source: Public Records

Similar Homes in the area

  • 18151 E Juniper Oaks Dr, Scottsdale, AZ 85263

    $834,566

    • 2 Beds
    • 2 Baths
    • 1,945 Sq Ft
    • 18151 E Juniper Oaks Dr
    • Scottsdale, AZ

    Welcome to this brand new home in Trilogy at Verde River featuring the Nice layout with 2 bedrooms, a den, and a stunning gourmet kitchen! The great room has a pocket slider to seamlessly connect the indoor and outdoors. Enjoy mountain views from your backyard! Do not miss out! The amenities at Verde River are World Class with Tom Lehman inspired eighteen-hole Golf course, tennis courts,

    Beth Rider Keller Williams Arizona Realty

    Section Image
  • 18203 E Paria Canyon Dr, Scottsdale, AZ 85263

    $959,300

    • 2 Beds
    • 2.5 Baths
    • 2,413 Sq Ft
    • 18203 E Paria Canyon Dr
    • Scottsdale, AZ

    Welcome to the Cordoba in the Guard Gated community of Trilogy at Verde River! This home has 2 bedrooms, 2.5 bathrooms, a den, and beautiful upgrades throughout. You will love the bar in the entryway equipped with 2 beverage refrigerators and wine storage. The kitchen is beautiful with rich cabinetry, quartz countertops, and an island with a breakfast bar. The primary suite is lavish with a

    Beth Rider Keller Williams Arizona Realty

    Section Image
  • 14129 E Barbie Ln, Scottsdale, AZ 85262

    $675,000

    • 3 Beds
    • 2 Baths
    • 2,435 Sq Ft
    • 14129 E Barbie Ln
    • Scottsdale, AZ

    North Scottsdale living! No water issues..Epcor membership confirmed!! Horses, toys, privacy,and SPACE! Nestled on an oversized 1 acre lot and featuring a natural desert landscape, 2 car garage, and paver walkway! Inside you will find spacious dining & living areas w/concrete floors, high ceilings, an entertainment niche, a warm fireplace, and neutral palette throughout. Amazing gourmet kitchen,

    Alexander Prewitt Real Broker

    Section Image
  • 18221 E Paria Canyon Dr, Scottsdale, AZ 85263

    $751,498

    • 2 Beds
    • 2 Baths
    • 1,761 Sq Ft
    • 18221 E Paria Canyon Dr
    • Scottsdale, AZ

    Come take a look at this brand-new stunning home in Trilogy at Verde River. The Acacia layout boasts 2 bedrooms, a den, and a spacious great room. The kitchen features beautiful Alder Shaker Cabinets, Calacatta Jubilee Quartz Countertops, and high-end stainless steel appliances. The great room offers a 15' Multi-slide door and upgraded tile flooring. The primary suite has a luxurious ensuite

    Beth Rider Keller Williams Arizona Realty

    Section Image
  • 9562 E Cavalry Dr, Scottsdale, AZ 85262

    $1,025,000

    • 3 Beds
    • 2.5 Baths
    • 2,099 Sq Ft
    • 9562 E Cavalry Dr
    • Scottsdale, AZ

    Desert Luxury Meets Modern Upgrades in Legend TrailWelcome to the heart of North Scottsdale's premier golf community—Legend Trail. This beautifully updated 3-bedroom, 2.5-bath home offers 2,099 sq. ft. of stylish comfort and sits just moments away from one of Arizona's most acclaimed courses— the 18-hole Rees Jones-designed championship layout (plus the bonus 19th hole!).Step inside and be wowed

    Allen Studebaker Compass

    Section Image
  • 1725 E Staghorn Ln, Carefree, AZ 85377

    $795,000

    • 2 Beds
    • 2 Baths
    • 1,690 Sq Ft
    • 1725 E Staghorn Ln
    • Carefree, AZ

    This charming two-bedroom, two-bath home is located near the end of a winding cul-de-sac across from the recently remodeled community pool and spa. Backing to the 15th green of the Boulders North Course, the deep back yard reflects natural desert beauty. The spacious living room has a gas fireplace and sliding glass doors that open to the patio. The large primary suite has sliding doors that lead

    Steven Klemow Realty Executives

    Section Image
  • 7278 E Camino Salida Del Sol, Scottsdale, AZ 85266

    $1,049,999

    • 2 Beds
    • 2.5 Baths
    • 2,195 Sq Ft
    • 7278 E Camino Salida Del Sol
    • Scottsdale, AZ

    Welcome to this GATED 55+ upscale community of Scottsdale Heights. This pristine home is ideal for a full-or-part time residence and offers 2 bedrooms (each with en-suite baths) plus a den/flex room with double doors and 2.5 baths in 2195 SqFt. Designed for entertaining and hosting family and friends, this floor plan features a large great room and split bedrooms. The kitchen is beautifully

    Beth Rider Keller Williams Arizona Realty

    Section Image
  • 7291 E Eagle Feather Rd, Scottsdale, AZ 85266

    $985,000

    • 3 Beds
    • 3 Baths
    • 2,503 Sq Ft
    • 7291 E Eagle Feather Rd
    • Scottsdale, AZ

    Best patio home plan featuring an expansive owners suite split across the home from another secondary ensuite bedroom along with a third bedroom w/ hallway bath. The home features a separate office or den w/ doors to close for privacy. Plantation shutters t/o, turnkey sale. The kitchen features a large kitchen island, pull out drawers, many many cabinets, breakfast nook & opens to the family room

    Steven Klemow Realty Executives

    Section Image
  • 13789 E Geronimo Rd, Scottsdale, AZ 85259

    $874,000

    • 3 Beds
    • 2 Baths
    • 1,996 Sq Ft
    • 13789 E Geronimo Rd
    • Scottsdale, AZ

    Wow! 200k price reduction since listed! Best Buy in luxury Guard gated Scottsdale Mountain. Freshly updated in 2024 and ready for quick move in. Open and airy great room floor plan with oversized island kitchen. Seller just updated bathrooms, kitchen, floors, paint and more. Very private And low maintenance South facing yard with freshly installed turf. The exclusive guard gated community has its

    David Rucker Compass

    Section Image
See All Homes in Scottsdale

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
Scott Brent J $385,000 Driggs Title Agency Inc
Hildrebrandt Robert R -- None Available
Hildebrandt Robert R -- None Available
Hildebrandt Robert R -- --
Hildebrandt Robert R $62,500 First American Title Ins Co
Russell Kenneth R $50,000 First American Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Scott Brent J $348,600
Closed Scott Brent J $308,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/07/2018 06/07/18 Sold $385,000 0.0% $171 / Sq Ft
04/09/2018 04/09/18 For Sale $385,000 0.0% $171 / Sq Ft
03/21/2018 03/21/18 Pending -- -- --
02/26/2018 02/26/18 Price Changed $385,000 -3.5% $171 / Sq Ft
08/21/2017 08/21/17 For Sale $399,000 -- $178 / 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 $1,373 $36,311 -- --
2024 $1,314 $34,581 -- --
2023 $1,314 $58,400 $11,680 $46,720
2022 $1,287 $43,300 $8,660 $34,640
2021 $1,445 $42,120 $8,420 $33,700
2020 $1,424 $37,360 $7,470 $29,890
2019 $1,381 $37,010 $7,400 $29,610
2018 $1,329 $37,520 $7,500 $30,020
2017 $1,282 $35,370 $7,070 $28,300
2016 $1,274 $35,650 $7,130 $28,520
2015 $1,206 $33,780 $6,750 $27,030
Source: Public Records

Agents Affiliated with this Home

  • K

    Seller's Agent in 2018

    K Anderson

    Hohokam Real Estate and Land Company, Inc.

    (480) 585-6689

    Section Image

  • T

    Buyer's Agent in 2018

    Terry Allen

    Arizona Realty Central

    4 Total Sales

    Terry Allen
    Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 5649850

Arizona Regional Multiple Listing Service (ARMLS)

APN: 219-37-032N

Arizona Maricopa County Scottsdale 85262

29547 N 154th St, Scottsdale, AZ

This home is located at 29547 N 154th St, Scottsdale, AZ 85262 since 22 August 2017 and is currently estimated at $841,020, approximately $374 per square foot. This property was built in 2009. 29547 N 154th St is a home located in Maricopa County with nearby schools including Desert Sun Academy, Sonoran Trails Middle School, and Cactus Shadows High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Arizona Regional Multiple Listing Service (ARMLS) All information should be verified by the recipient and none is guaranteed as accurate by ARMLS

Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393

Nearby Homes