NOT LISTED FOR SALE

Estimated Value: $580,000 - $711,000

4 Beds
2.5 Baths
3,036 Sq Ft
$219/Sq Ft Est. Value

Last Sold May 30, 2024

Last sale price $681,750 $225 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $3,852/month

72 Days on Market

Highlights

  • Corner Lot
  • Granite Countertops
  • Covered Patio or Porch
  • Mesquite Elementary School Rated A-
  • Private Yard
  • 2 Car Direct Access Garage

About This Home

As of May 2024

Rare find in this 3000+ sqft home in the heart of Gilbert, built in 2015. This cul-de-sac lot home boasts of 4 large bedrooms + a bonus/rec room AND + an office/den! This home is great for entertaining w/ 10 ft ceilings, covered patio, updated flooring, tall baseboards, 8 ft doors, beautiful island, & functional kitchen space. Relax in the sizable master retreat upstairs with a large walk-in closet & ensuite w/dual vanities, soaking tub, & enclosed shower. Convenient upstairs laundry room with bonus room and den downstairs. Close proximity to downtown Gilbert, mature trees, energy efficient windows, 2x6 construction, 2 car garage.. and many more. Come see!

Last Agent to Sell the Property

Daniel Tansill

Realty ONE Group License #SA637873000 Listed on: 02/16/2024

Last Buyer's Agent

Susan Bermudez

Simply Real Estate License #BR686418000

Simply Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,464

Year Built

  • Built in 2015

Lot Details

  • 8,893 Sq Ft Lot
  • Cul-De-Sac
  • Private Streets
  • Block Wall Fence
  • Corner Lot
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Private Yard
  • Grass Covered Lot

HOA Fees

  • $138 Monthly HOA Fees

Parking

  • 2 Car Direct Access Garage
  • 4 Open Parking Spaces
  • Electric Vehicle Home Charger
  • Garage ceiling height seven feet or more
  • Garage Door Opener

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stone Exterior Construction
  • Stucco

Interior Spaces

  • 3,036 Sq Ft Home
  • 2-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Double Pane Windows
  • ENERGY STAR Qualified Windows with Low Emissivity
  • Vinyl Clad Windows
  • Security System Owned

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Electric Cooktop
  • Kitchen Island
  • Granite Countertops

Flooring

  • Floors Updated in 2024
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Remodeled Bathroom
  • 2.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub With Separate Shower Stall

Outdoor Features

  • Covered Patio or Porch
  • Outdoor Storage
  • Playground

Schools

  • Mesquite Elementary School
  • Greenfield Junior High School
  • Gilbert High School

Utilities

  • Central Air
  • Heating unit installed on the ceiling
  • High Speed Internet
  • Cable TV Available

Additional Features

  • Multiple Entries or Exits
  • Property is near a bus stop

Listing and Financial Details

  • Tax Lot 28
  • Assessor Parcel Number 304-22-887

Community Details

Overview

  • Association fees include ground maintenance, street maintenance
  • Trestle Management Association, Phone Number (480) 422-0888
  • Built by VIP Homes
  • Yellow Rose Ranch Amd Subdivision

Recreation

  • Community Playground

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,464

Year Built

Built in 2015

Lot Details

0

HOA Fees

$138 per month

Parking

2

Listing Details

  • Cross Street: Lindsey and Warner
  • Legal Info Range: 6E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 137.5
  • Basement: N
  • Updated Partial or Full Bathrooms: Partial
  • Updated Floors: Partial
  • Items Updated Floor Yr Updated: 2024
  • Updated Heating or Cooling Units: Full
  • Updated Kitchen: Full
  • Updated Plumbing: Full
  • Updated Roof: Full
  • Updated Wiring: Full
  • Parking Spaces Slab Parking Spaces: 4.0
  • Parking Spaces Total Covered Spaces: 2.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2015
  • Tax Year: 2023
  • Directions: Turn East onto Rawhide Ct off of Lindsey. Home is the second on the left in the culdesac.
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.2
  • Subdivision Name: YELLOW ROSE RANCH AMD
  • Property Attached Yn: No
  • Association Fees:HOA Fee2: 137.5
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Windows:Low-E: Yes
  • Cooling:Central Air: Yes
  • Water Source City Water: Yes
  • Kitchen Features:Electric Cooktop: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Tile
  • Basement YN: No
  • Spa Features: None
  • Appliances: Electric Cooktop
  • Accessibility Features: Mltpl Entries/Exits
  • Possible Bedrooms: 6
  • Total Bedrooms: 4
  • Fireplace Features: None
  • Fireplace: No
  • Interior Amenities: High Speed Internet, Granite Counters, Double Vanity, Upstairs, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Kitchen Island, Pantry, Separate Shwr & Tub
  • Living Area: 3036.0
  • Stories: 2
  • Window Features: Low-Emissivity Windows, Dual Pane, ENERGY STAR Qualified Windows, Vinyl Frame
  • Kitchen Features:RangeOven Elec: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Great Room: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • Community Features:Children_squote_s Playgrnd: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • Community Features:Near Bus Stop: Yes
  • Other Rooms:ExerciseSauna Room: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Playground, Private Street(s), Private Yard, Storage
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Corner Lot, Cul-De-Sac, Grass Front, Auto Timer H2O Front, Auto Timer H2O Back, Irrigation Front, Irrigation Back
  • Pool Features: None
  • Pool Private: No
  • Disclosures: Seller Discl Avail
  • Construction Type: Stucco, Wood Frame, Painted, Stone
  • Patio And Porch Features: Covered Patio(s), Patio
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Childrens Play Area: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Exterior Features:Storage: Yes
  • Exterior Features:Private Street(s): Yes

Garage/Parking

  • Total Covered Spaces: 2.0
  • Parking Features: Garage Door Opener, Direct Access, Over Height Garage, Separate Strge Area, Electric Vehicle Charging Station(s)
  • Attached Garage: No
  • Garage Spaces: 2.0
  • Open Parking Spaces: 4.0
  • Parking Features:Separate Strge Area: Yes
  • Parking Features:Electric Vehicle Charging Station(s): Yes
  • Parking Features:Over Height Garage: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Direct Access: Yes

Utilities

  • Electric: 220 Volts in Kitchen
  • Cooling: Central Air, Ceiling Fan(s), Programmable Thmstat
  • Heating: Electric, Ceiling
  • Security: Security System Owned
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Electric: Yes
  • Heating:Ceiling: Yes

Condo/Co-op/Association

  • Community Features: Near Bus Stop, Playground
  • Association Fee: 137.5
  • Association Fee Frequency: Monthly
  • Association Name: Yellow Rose Ranch
  • Phone: 480-422-0888
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA DisclosureAddendum Affirmation: No
  • Association Fees:HOA Transfer Fee2: 150.0
  • Association Fees:HOA Paid Frequency: Monthly
  • Association Fees:HOA Name4: Yellow Rose Ranch
  • Association Fees:HOA Telephone4: (480) 422-0888
  • Association Fees:Special Assessment HOA: No
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee: 275.0
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fees:Prepaid Association Fees HOA: 275.0
  • Association Fees:Disclosure Fees HOA: 250.0
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:HOA Management Company: Trestle Management
  • Association Fee Incl:Street Maint: Yes

Fee Information

  • Association Fee Includes: Maintenance Grounds, Street Maint

Schools

  • Elementary School: Mesquite Elementary
  • High School: Gilbert High School
  • Junior High Dist: Gilbert Unified District
  • Middle Or Junior School: Greenfield Junior High School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 8893.0
  • Parcel #: 304-22-887

Building Info

  • Builder Name: VIP Homes

Tax Info

  • Tax Annual Amount: 2464.0
  • Tax Book Number: 304.00
  • Tax Lot: 28
  • Tax Map Number: 22.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 16, 2024
Closed on
May 30, 2024
Sold by
Feab Living Trust and Tansill Daniel J
Bought by
Derden Timothy R and Derden Jourdan E
Seller's Agent
Daniel Tansill
Realty ONE Group
Buyer's Agent
Susan Bermudez
Simply Real Estate
List Price
$743,000
Sold Price
$681,750
Premium/Discount to List
-$61,250
-8.24%
Views
159
Current Estimated Value
$664,507

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$17,243
Avg. Annual Appreciation
-1.94%
Original Mortgage
$681,750
Outstanding Balance
$673,777
Interest Rate
7.1%
Mortgage Type
VA
Estimated Equity
-$9,270

Purchase Details

Closed on
Sep 27, 2022
Sold by
Tansill Daniel J and Tansill Natalie M
Bought by
Feab Living Trust

Purchase Details

Closed on
Jul 7, 2015
Sold by
Vip Custom Home Llc
Bought by
Tansill Daniel J and Tansill Natalie M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$274,385
Interest Rate
3.83%
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
Derden Timothy R $681,750 Security Title Agency
Feab Living Trust -- Final Title Support
Tansill Daniel J $304,873 First American Title Ins Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Derden Timothy R $681,750
Previous Owner Tansill Daniel J $364,784
Previous Owner Tansill Daniel J $253,900
Previous Owner Tansill Daniel J $274,385
Previous Owner Vip Custom Homes Llc $245,250
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/30/2024 05/30/24 Sold $681,750 +1.0% $225 / Sq Ft
04/22/2024 04/22/24 Price Changed $675,000 -2.0% $222 / Sq Ft
04/12/2024 04/12/24 Price Changed $689,000 -0.9% $227 / Sq Ft
04/05/2024 04/05/24 Price Changed $695,000 -0.6% $229 / Sq Ft
03/20/2024 03/20/24 Price Changed $699,000 -3.6% $230 / Sq Ft
03/08/2024 03/08/24 Price Changed $725,000 -0.7% $239 / Sq Ft
03/04/2024 03/04/24 Price Changed $729,999 -0.7% $240 / Sq Ft
03/02/2024 03/02/24 Price Changed $735,000 -0.4% $242 / Sq Ft
02/24/2024 02/24/24 Price Changed $738,000 -0.7% $243 / Sq Ft
02/16/2024 02/16/24 Price Changed $743,000 0.0% $245 / Sq Ft
02/16/2024 02/16/24 For Sale $743,000 -- $245 / 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 $2,444 $33,811 -- --
2024 $2,464 $32,201 -- --
2023 $2,464 $48,970 $9,790 $39,180
2022 $2,390 $39,050 $7,810 $31,240
2021 $2,525 $37,880 $7,570 $30,310
2020 $2,486 $35,570 $7,110 $28,460
2019 $2,285 $33,760 $6,750 $27,010
2018 $2,215 $31,510 $6,300 $25,210
2017 $2,137 $30,000 $6,000 $24,000
2016 $2,211 $29,060 $5,810 $23,250
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: 6659334

Arizona Regional Multiple Listing Service (ARMLS)

APN: 304-22-887