NOT LISTED FOR SALE

Estimated Value: $688,000 - $710,000

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

Last Sold May 30, 2024

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

Est. 2% increase in value since last sale

Current estimated payment $4,240/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/03/2024

Last Buyer's Agent

Susan Bermudez

LPT Realty, LLC License #BR686418000

LPT Realty, LLC

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
  • 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 - Gilbert
  • Greenfield Junior High School
  • Gilbert High School

Utilities

  • Refrigerated Cooling System
  • 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 - Detached
  • Horses: No
  • Lot Size Acres: 0.2
  • Subdivision Name: YELLOW ROSE RANCH AMD
  • Property Attached Yn: No
  • ResoBuildingAreaSource: Assessor
  • Association Fees:HOA Fee2: 137.5
  • Special Features: None

Interior Features

  • Flooring: Carpet, Tile
  • Basement YN: No
  • Spa Features: None
  • Accessibility Features: Mltpl Entries/Exits
  • Possible Bedrooms: 6
  • Total Bedrooms: 4
  • Fireplace Features: None
  • Fireplace: No
  • Interior Amenities: Upstairs, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Kitchen Island, Pantry, Double Vanity, Separate Shwr & Tub, High Speed Internet, Granite Counters
  • Living Area: 3036.0
  • Stories: 2
  • Window Features: Dual Pane, ENERGY STAR Qualified Windows, Low-E, Vinyl Frame
  • Fireplace:No Fireplace: Yes
  • Kitchen Features:RangeOven Elec: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: 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
  • Kitchen Features:_two_20 Volts in Kitchen: Yes
  • Kitchen Features:Cook Top Elec: Yes
  • Other Rooms:ExerciseSauna Room: Yes
  • KitchenFeatures:Refrigerator: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Covered Patio(s), Playground, Patio, 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: Painted, Stucco, Stone, Frame - Wood
  • 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: Dir Entry frm Garage, Electric Door Opener, 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:Dir Entry frm Garage: Yes
  • Parking Features:Electric Door Opener: Yes
  • Parking Features:Separate Strge Area: Yes
  • Parking Features:Electric Vehicle Charging Station(s): Yes
  • Parking Features:Over Height Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Community Features: Near Bus Stop, Playground
  • Amenities: None
  • 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 School - Gilbert
  • 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
  • ResoLotSizeUnits: SquareFeet

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 3, 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
LPT Realty, LLC
List Price
$743,000
Sold Price
$681,750
Premium/Discount to List
-$61,250
-8.24%
Total Days on Market
72
Views
159
Current Estimated Value
$694,430

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$12,680
Avg. Annual Appreciation
1.82%
Original Mortgage
$681,750
Outstanding Balance
$676,123
Interest Rate
7.1%
Mortgage Type
VA
Estimated Equity
$18,307

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

Similar Homes in the area

  • 1522 E Cheyenne St, Gilbert, AZ 85296

    $525,000

    • 3 Beds
    • 2 Baths
    • 1,655 Sq Ft
    • 1522 E Cheyenne St
    • Gilbert, AZ

    Amazing lot in Val Vista with extended backyard and resort-like pool w/ waterfall, lush grassy area and palm trees. Home has covered patio and two entrances from the home to overlook this oasis! Wonderful floor plan with 3 bed/2 baths, kitchen with island, pantry and breakfast nook overlooking family room with fireplace, front rooms for formal living or dining/entertainment. Primary bedroom

    Robyn Bernzott eXp Realty

    Section Image
  • 1663 S Boulder St, Gilbert, AZ 85295

    $775,000

    • 5 Beds
    • 3 Baths
    • 3,284 Sq Ft
    • 1663 S Boulder St
    • Gilbert, AZ

    BRAND NEW Exterior Paint! This Stunning Move In Ready Gem In The Premier & Family Friendly Gilbert Community Of Ashland Ranch Features Oversized Private Lot w/Sparkling Pool & Open Spacious Backyard Paradise! Interior Features Split Level Design, Gorgeous Wood Laminate Flooring, Solid Stone Counters, Plantation Shutters, Vaulted Ceilings, Upgraded Fixtures, Fans & Hardware, Upstairs Loft, Full

    Dawn Carroll Lori Blank & Associates, LLC

    Section Image
  • 901 N Quartz St, Gilbert, AZ 85234

    $539,000

    • 3 Beds
    • 2 Baths
    • 1,750 Sq Ft
    • 901 N Quartz St
    • Gilbert, AZ

    Start packing! Fully furnished and move-in ready—perfect as a turn-key vacation rental or primary residence, this 3 bedroom home is located near shops, cafes, and the heart of Downtown Gilbert. Enjoy modern living with vaulted 14' ceilings, open-concept layout, and sleek contemporary finishes. Entertainer's dream with a PebbleTec pool, easy to manage landscaping, and no rear neighbors. . Spacious

    AYANNA HAWKINS At Home

    Section Image
  • 843 W Palo Verde St, Gilbert, AZ 85233

    $560,000

    • 4 Beds
    • 3 Baths
    • 2,104 Sq Ft
    • 843 W Palo Verde St
    • Gilbert, AZ

    Step into effortless living! This stunningly updated tri-level home boasts over $55,000 in recent upgrades, including a brand-new roof, newer HVAC system, updated bathrooms, and fresh interior and exterior paint. Imagine preparing meals on sleek quartz countertops in the beautifully renovated kitchen, or unwinding in the spa-like master bath with its trendy, modern shower. The popular tri-level

    Carol A. Royse Your Home Sold Guaranteed Realty

    Section Image
  • 2057 E Marquette Dr, Gilbert, AZ 85234

    $610,000

    • 4 Beds
    • 2 Baths
    • 2,142 Sq Ft
    • 2057 E Marquette Dr
    • Gilbert, AZ

    Rare remodeled single-story home with 4 bedrooms and a 3-car garage in desirable Val Vista Lakes! This open-concept home features soaring vaulted ceilings, a cozy fireplace, and a beautifully remodeled kitchen with stone countertops + farmhouse sink. Mix up your favorite beverage at the custom coffee/wet bar with mini fridge. Updated bathrooms add a fresh, modern touch. Outside, enjoy the large

    Chris Lundberg Redeemed Real Estate

    Section Image
  • 384 N Scott Dr, Chandler, AZ 85225

    $570,000

    • 4 Beds
    • 2 Baths
    • 1,757 Sq Ft
    • 384 N Scott Dr
    • Chandler, AZ

    VA Buyers take over this 26 year mortgage at 2.99% saving you over $43,000 in interest that's already been paid and $850 p/month compared to a new conventional loan! This true 4 bedroom w/Like New Swimming Pool that was completely remodeled down to the plumbing in 11/2024 is waiting for you to jump right in!! Great open floor plan w/modern tile flooring, remodeled kitchen with granite counters,

    Edith 'Eydie' Fernandez HomeSmart

    Section Image
  • 345 N Scott Dr, Chandler, AZ 85225

    $615,000

    • 4 Beds
    • 2.5 Baths
    • 2,407 Sq Ft
    • 345 N Scott Dr
    • Chandler, AZ

    This isn't the typical 2 story floorpan with walls separating each room on the dark main floor. From the moment you walk in, you'll love the openness that provides a bright visual of the interiors of this home! You'll also find one of the hottest features of a 2 story home - the main bedroom located on the first floor. Plus an impressive near 9,200 sq. ft. pie-shaped corner lot with an updated

    Edith 'Eydie' Fernandez HomeSmart

    Section Image
  • 2218 E Mallard Ct, Gilbert, AZ 85234

    $625,000

    • 4 Beds
    • 3 Baths
    • 2,538 Sq Ft
    • 2218 E Mallard Ct
    • Gilbert, AZ

    Pristine Listing!Welcome home to this immaculate 4 bedroom, 3 bath beauty, perfectly situated on a large corner lot in the highly sought after Val Vista Lake community! From the moment you arrive, you'll be captivated by the charming curb appeal,& inviting presence of this 2 story gem.Step inside to discover a spacious, light filled, open floor plan where vaulted ceilings create an airy, elegant

    Connie Murphy Keller Williams Integrity First

    Section Image
  • 1449 E Kent Ave, Chandler, AZ 85225

    $580,000

    • 4 Beds
    • 2 Baths
    • 1,720 Sq Ft
    • 1449 E Kent Ave
    • Chandler, AZ

    Become the proud owner of this delightful 4-bedroom residence! Filled with beautiful upgraded repaired back patio roof with new layment, freshly painted exterior, new countertops in kitchen and bathrooms, new plumbing fixtures, new landscaping irrigation system, brand new pebble tec and pool surfacing, brand new pool pump and equipment, paid off solar panels, new garbage disposal, all new sinks,

    Rebecca Kennard My Home Group Real Estate

    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
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