NOT LISTED FOR SALE

24382 S 199th St Queen Creek, AZ 85142

Estimated Value: $1,735,000 - $2,193,811

5 Beds
5.5 Baths
4,645 Sq Ft
$420/Sq Ft Est. Value

Last Sold May 10, 2024

Last sale price $2,275,000 $490 Per Sq Ft

Est. 11% decrease in value since last sale

Current estimated payment $11,712/month

12 Days on Market

Highlights

  • Heated Spa
  • RV Gated
  • Vaulted Ceiling
  • Queen Creek Elementary School Rated A-
  • 0.7 Acre Lot
  • Outdoor Fireplace

About This Home

As of May 2024

Embrace a lifestyle of luxury and sophistication in this meticulously designed residence, where every detail has been carefully considered to exceed even the highest expectations. Epitome of luxury living this exquisite 5-bedroom, 5.5-bathroom estate, spanning nearly 4700 square feet on an expansive 30,492 square foot lot is all custom built. Step into culinary excellence with high-end Wolf and Sub-Zero Pro kitchen appliances, while a hidden chef's butler pantry adds a touch of convenience and sophistication. Retreat to the primary suite where you'll find dual closets incorporating a built in safe room, workout room, and luxury spa like bathroom. Each additional bedroom boasts its own ensuite and walkin closets, ensuring privacy and comfort for all residents and guests. Outside, discover an entertainer's paradise featuring a luxurious pool with inviting swim-up seating and a soothing built-in spa. The outdoor living space is enhanced by a sunken BBQ kitchen equipped with top of the line bbq and tepanyaki grills, multiple refrigerators, television and a mesmerizing waterfall, creating an idyllic setting for al fresco gatherings and relaxation.

For the sports enthusiast, a private basketball court awaits, providing endless opportunities for recreation and enjoyment. Meanwhile, the expansive oversized 4-car garage is equipped with spray foam insulation, high-lift doors, two tankless water heaters, and a state-of-the-art water filtration system, offering unparalleled convenience and efficiency. This is your opportunity to experience the pinnacle of modern living in a truly exceptional setting.

Last Agent to Sell the Property

Susan Bermudez

LPT Realty, LLC License #BR686418000 Listed on: 03/25/2024

LPT Realty, LLC

Last Buyer's Agent

Dane DeBellis

Real Broker License #SA697270000

Real Broker

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,814

Year Built

  • Built in 2021

Lot Details

  • 0.7 Acre Lot
  • Cul-De-Sac
  • Block Wall Fence
  • Corner Lot
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Grass Covered Lot

HOA Fees

  • $84 Monthly HOA Fees

Parking

  • 4 Car Direct Access Garage
  • 6 Open Parking Spaces
  • Electric Vehicle Home Charger
  • Garage Door Opener
  • RV Gated

Home Design

  • Wood Frame Construction
  • Tile Roof

Interior Spaces

  • 4,645 Sq Ft Home
  • 1-Story Property
  • Wet Bar
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Low Emissivity Windows
  • Tinted Windows
  • Family Room with Fireplace
  • Tile Flooring
  • Smart Home

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Gas Cooktop
  • Built-In Microwave
  • Kitchen Island

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bathroom is a Full Bathroom
  • 5.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub With Separate Shower Stall

Pool

  • Heated Spa
  • Heated Pool
  • Pool Pump

Outdoor Features

  • Covered Patio or Porch
  • Outdoor Fireplace
  • Built-In Barbecue
  • Playground

Schools

  • Queen Creek Elementary School
  • Newell Barney Middle School
  • Crismon High School

Utilities

  • Central Air
  • Heating unit installed on the ceiling
  • Propane
  • Tankless Water Heater
  • Water Purifier
  • Water Softener
  • Septic Tank
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 21
  • Assessor Parcel Number 304-90-717

Community Details

Overview

  • Association fees include ground maintenance
  • Heywood Management Association, Phone Number (480) 422-0888
  • Built by Custom
  • Sonoqui Creek Ranch Phase 3, Pecan Meadows Subdivision

Recreation

  • Sport Court

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,814

Year Built

Built in 2021

Lot Details

0

HOA Fees

$84 per month

Parking

4

Listing Details

  • Cross Street: Hawes in between Chandler Heights & Riggs
  • Legal Info Range: 7E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 83.67
  • Basement: N
  • Parking Spaces Slab Parking Spaces: 6.0
  • Parking Spaces Total Covered Spaces: 4.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2021
  • Spa Private: Yes
  • Tax Year: 2023
  • Directions: Take Chandler Heights east to Hawes Rd, turn right (south) to Sunset Dr, turn right, take first left on 199th Pl home is last one on the right.
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.7
  • Subdivision Name: SONOQUI CREEK RANCH PHASE 3, Pecan Meadows
  • Architectural Style: Ranch
  • Property Attached Yn: No
  • Association Fees:HOA Fee2: 251.0
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Windows:Low-E: Yes
  • Utilities Butane Propane: Yes
  • Cooling:Central Air: Yes
  • Features:Water Purifier: Yes
  • Water Source City Water: Yes
  • Fireplace Features Fireplace Family Rm: Yes
  • Fireplace Features Gas Fireplace: Yes
  • Kitchen Features:Gas Cooktop: Yes
  • Technology:High Speed Internet: Yes
  • Technology:Smart Home: Yes
  • Special Features: None

Interior Features

  • Flooring: Tile
  • Basement YN: No
  • Possible Use: None
  • Spa Features: Heated, Private
  • Appliances: Gas Cooktop, Water Purifier
  • Possible Bedrooms: 7
  • Total Bedrooms: 5
  • Fireplace Features: 1 Fireplace, Exterior Fireplace, Family Room, Gas
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Smart Home, Double Vanity, Eat-in Kitchen, Breakfast Bar, Soft Water Loop, Vaulted Ceiling(s), Wet Bar, Kitchen Island, Pantry, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 4645.0
  • Stories: 1
  • Window Features: Low-Emissivity Windows, Dual Pane, Tinted Windows
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Great Room: Yes
  • Kitchen Features:Non-laminate Counter: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Other Rooms:ExerciseSauna Room: Yes
  • KitchenFeatures:Refrigerator: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Playground, Sport Court(s), Built-in Barbecue
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Corner Lot, Cul-De-Sac, Grass Front, Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: Variable Speed Pump, Heated, Private
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Wood Frame, Painted
  • Other Structures: Gazebo
  • Patio And Porch Features: Covered Patio(s), Patio
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes
  • Exterior Features:Childrens Play Area: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:GazeboRamada: Yes
  • Exterior Features:Sport Court(s): Yes
  • Fireplace Features Exterior Fireplace: Yes

Garage/Parking

  • Total Covered Spaces: 4.0
  • Parking Features: RV Gate, Garage Door Opener, Extended Length Garage, Direct Access, Electric Vehicle Charging Station(s)
  • Attached Garage: No
  • Garage Spaces: 4.0
  • Open Parking Spaces: 6.0
  • Parking Features:RV Gate: Yes
  • Parking Features:Electric Vehicle Charging Station(s): Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Direct Access: Yes
  • Parking Features:Extended Length Garage: Yes

Utilities

  • Utilities: Propane
  • Cooling: Central Air, Ceiling Fan(s), Programmable Thmstat
  • Heating: Electric, Ceiling
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Electric: Yes
  • Sewer Septic Tank: Yes
  • Heating:Ceiling: Yes

Condo/Co-op/Association

  • Association Fee: 251.0
  • Association Fee Frequency: Quarterly
  • Association Name: Sonoqui Creek Ranch
  • Phone: 480-892-5222
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA DisclosureAddendum Affirmation: Yes
  • Association Fees:HOA Transfer Fee2: 275.0
  • Association Fees:HOA Paid Frequency: Quarterly
  • Association Fees:HOA Name4: Sonoqui Creek Ranch
  • Association Fees:HOA Telephone4: (480)892-5222
  • Association Fees:Special Assessment HOA: No
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fees:Prepaid Association Fees HOA: 251.0
  • Association Fees:Disclosure Fees HOA: 400.0
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:HOA Management Company: Heywood Management
  • Association Fees:HOA Management Phone: 480-422-0888

Fee Information

  • Association Fee Includes: Maintenance Grounds

Schools

  • Elementary School: Queen Creek Elementary School
  • High School: Crismon High School
  • Junior High Dist: Queen Creek Unified District
  • Middle Or Junior School: Newell Barney Middle School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 30492.0
  • Parcel #: 304-90-717

Green Features

  • Green Water Conservation: Tankless Ht Wtr Heat

Building Info

  • Builder Name: Custom

Tax Info

  • Tax Annual Amount: 6814.0
  • Tax Book Number: 304.00
  • Tax Lot: 21
  • Tax Map Number: 90.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 25, 2024
Closed on
May 9, 2024
Sold by
Farnsworth Rory D
Bought by
Alberts Alyssa and Fluelien Gerard
Seller's Agent
Susan Bermudez
LPT Realty, LLC
Buyer's Agent
Dane DeBellis
Real Broker
List Price
$2,375,000
Sold Price
$2,275,000
Premium/Discount to List
-$100,000
-4.21%
Views
767
Current Estimated Value
$2,035,891

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$239,109
Avg. Annual Appreciation
-2.47%
Original Mortgage
$1,933,750
Interest Rate
6.79%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 14, 2021
Sold by
Glauser Burk R and Glauser Kelly A
Bought by
Farnsworth Rory D

Purchase Details

Closed on
Jun 10, 2020
Sold by
Capaldi William and Capaldi Angela
Bought by
Glauser Burk R and Glauser Kelly A

Purchase Details

Closed on
Apr 19, 2004
Sold by
Pecan Meadows Llc
Bought by
Capaldi William and Capaldi Angela

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$79,040
Interest Rate
5.39%
Mortgage Type
New Conventional
Source: Public Records

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
Alberts Alyssa $2,275,000 Security Title Agency
Farnsworth Rory D $286,500 Security Title Agency Inc
Glauser Burk R $165,000 Security Title Agency Inc
Capaldi William $98,800 Capital Title Agency Inc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Alberts Alyssa $1,956,000
Closed Alberts Alyssa $1,933,750
Previous Owner Farnsworth Rory D $1,215,826
Previous Owner Capaldi William $79,040
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/10/2024 05/10/24 Sold $2,275,000 -4.2% $490 / Sq Ft
03/25/2024 03/25/24 For Sale $2,375,000 -- $511 / 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,425 $66,231 -- --
2024 $6,814 $63,077 -- --
2023 $6,814 $100,250 $20,050 $80,200
2022 $1,003 $22,275 $22,275 $0
2021 $1,010 $22,080 $22,080 $0
2020 $982 $19,020 $19,020 $0
2019 $957 $16,650 $16,650 $0
2018 $920 $11,580 $11,580 $0
2017 $876 $10,320 $10,320 $0
2016 $860 $10,260 $10,260 $0
2015 $765 $8,672 $8,672 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6680872

Arizona Regional Multiple Listing Service (ARMLS)

APN: 304-90-717