NOT LISTED FOR SALE

Estimated Value: $661,000 - $683,000

4 Beds
3.5 Baths
3,356 Sq Ft
$200/Sq Ft Est. Value

Last Sold March 07, 2025

Last sale price $665,000 $198 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $3,965/month

64 Days on Market

Highlights

  • Contemporary Architecture
  • Granite Countertops
  • Covered Patio or Porch
  • Mesquite Elementary School Rated A-
  • Private Yard
  • 3 Car Direct Access Garage

About This Home

As of March 2025

Welcome to this stunning 3356 sq. ft. home, where curb appeal meets sophistication. As you approach, the stately porte cochere sets the tone, letting you know you've arrived at something truly special. This meticulously designed 4-bedroom, 3.5-bath home also includes a spacious loft, offering an exceptional layout perfect for both family living and entertaining.
Inside, the main level boasts an elegant formal living room, complemented by a separate family room that opens to a beautiful dining area and the kitchen. The upgraded kitchen features 42'' oak cabinetry, luxurious granite countertops, and stainless steel appliances—ideal for preparing meals and hosting guests. Sliding doors open to a covered patio and a newly landscaped backyard. Upstairs, the oversized master suite is a true retreat, with a private bath featuring a separate shower, soaking tub, and a large walk-in closet. Three additional generously sized bedrooms offer plenty of space for family or guests, while the loft provides a versatile area for relaxation or play. Convenience is key with a dedicated laundry room on the second floor.
Outside, you'll love the proximity to a children's playground, basketball court, and ramada just across the street, making it easy to enjoy family-friendly outdoor activities. Additionally, this home is nestled in a small, quiet neighborhood with just 29 homes, located on a private street. Plus, it's within walking distance of downtown Gilbert, where you can enjoy shops, restaurants, and entertainment.
This home combines luxurious living with thoughtful design in an unbeatable locationdon't miss your chance to make it yours!

Last Agent to Sell the Property

Heather Openshaw

Keller Williams Integrity First License #SA565143000 Listed on: 12/07/2024

Keller Williams Integrity First

Co-Listed By

Jared Gruett

Keller Williams Integrity First License #SA708252000

Last Buyer's Agent

Jacob Matanky

HomeSmart License #SA680056000

HomeSmart

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,301

Year Built

  • Built in 2016

Lot Details

  • 4,952 Sq Ft Lot
  • Desert faces the front of the property
  • Cul-De-Sac
  • Private Streets
  • Block Wall Fence
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Private Yard
  • Grass Covered Lot

HOA Fees

  • $141 Monthly HOA Fees

Parking

  • 3 Car Direct Access Garage
  • 2 Open Parking Spaces
  • Garage ceiling height seven feet or more
  • Tandem Garage

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 3,356 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
  • Tinted Windows
  • Solar Screens
  • Security System Owned

Kitchen

  • Breakfast Bar
  • Electric Cooktop
  • Built-In Microwave
  • Kitchen Island
  • Granite Countertops

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bathroom is a Full Bathroom
  • 3.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Low Flow Plumbing Fixtures
  • Bathtub With Separate Shower Stall

Accessible Home Design

  • Insulated Bathroom Pipes
  • Low Kitchen Cabinetry
  • Insulated Kitchen Pipes
  • Accessible Hallway
  • Doors are 32 inches wide or more
  • Multiple Entries or Exits
  • Hard or Low Nap Flooring

Outdoor Features

  • Covered Patio or Porch
  • Outdoor Storage

Utilities

  • Zoned Heating and Cooling System
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 7
  • Assessor Parcel Number 304-22-866

Community Details

Overview

  • Association fees include ground maintenance, street maintenance
  • Trestle Mgmt Group 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,301

Year Built

Built in 2016

Lot Details

0

HOA Fees

$141 per month

Parking

3

Listing Details

  • Cross Street: Warner Rd & Lindsay Rd
  • Legal Info Range: 6E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 141.0
  • Basement: N
  • Parking Spaces Slab Parking Spaces: 2.0
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2016
  • Tax Year: 2024
  • Directions: Head north on S Lindsay Rd, Turn right onto E Rawhide Ct, Turn right to stay on E Rawhide Ct, Home will be on the right.
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.11
  • Co List Office Mls Id: kwif01
  • Co List Office Phone: 480-854-2400
  • Subdivision Name: YELLOW ROSE RANCH AMD
  • Architectural Style: Contemporary
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • Association Fees:HOA Fee2: 141.0
  • 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
  • Windows:Solar Screens: 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
  • Possible Use: None
  • Spa Features: None
  • Appliances: Electric Cooktop
  • Accessibility Features: Accessible Door 32in+ Wide, Mltpl Entries/Exits, Ktch Insulated Pipes, Ktch Low Cabinetry, Hard/Low Nap Floors, Bath Insulated Pipes, Accessible Hallway(s)
  • Possible Bedrooms: 6
  • Total Bedrooms: 4
  • Fireplace Features: None
  • Fireplace: No
  • Interior Amenities: High Speed Internet, Granite Counters, Double Vanity, Upstairs, Breakfast Bar, 9+ Flat Ceilings, Kitchen Island, Pantry, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 3356.0
  • Stories: 2
  • Window Features: Low-Emissivity Windows, Solar Screens, Dual Pane, ENERGY STAR Qualified Windows, Tinted Windows, Vinyl Frame
  • Kitchen Features:RangeOven Elec: Yes
  • 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
  • Other Rooms:Family Room: Yes
  • Community Features:Children_squote_s Playgrnd: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:Loft: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Private Street(s), Private Yard, Storage
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Cul-De-Sac, Grass Back, Auto Timer H2O Front, Natural Desert Front, Auto Timer H2O Back
  • Pool Features: None
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Common Walls: No Common Walls
  • Construction Type: Stucco, Wood Frame, Painted
  • Patio And Porch Features: Covered Patio(s), Patio
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): 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: 3.0
  • Parking Features: Tandem Garage, Direct Access, Attch'd Gar Cabinets, Over Height Garage, Detached
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Open Parking Spaces: 2.0
  • Parking Features:Attch_squote_d Gar Cabinets: Yes
  • Parking Features:Detached: Yes
  • Parking Features:Tandem Garage: Yes
  • Parking Features:Over Height Garage: Yes
  • Parking Features:Direct Access: Yes

Utilities

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

Condo/Co-op/Association

  • Community Features: Playground
  • Association Fee: 141.0
  • 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: Yes
  • Association Fees:HOA Transfer Fee2: 75.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: 250.0
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fees:Disclosure Fees HOA: 250.0
  • Association Fees:Other Fees HOA: 275.0
  • Association Fees:Other Fees Description: 0
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:HOA Management Company: Trestle Mgmt Group
  • Association Fees:Cap ImprovementImpact Fee 2: 242.0
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: $
  • Association Fee Incl:Street Maint: Yes

Fee Information

  • Association Fee Includes: Maintenance Grounds, Street Maint

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 4952.0
  • Parcel #: 304-22-866

Green Features

  • Green Water Conservation: Low-Flow Fixtures

Building Info

  • Builder Name: VIP Homes

Tax Info

  • Tax Annual Amount: 2301.0
  • Tax Book Number: 304.00
  • Tax Lot: 7
  • Tax Map Number: 22.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 7, 2024
Closed on
Feb 27, 2025
Sold by
Burkhouse Mike
Bought by
Quinio Santiago Ray Diaz and Armstrong Julia Robin
Seller's Agent
Heather Openshaw
Keller Williams Integrity First
Buyer's Agent
Jacob Matanky
HomeSmart
List Price
$685,000
Sold Price
$665,000
Premium/Discount to List
-$20,000
-2.92%
Views
116
Current Estimated Value
$671,840

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$6,840
Avg. Annual Appreciation
2.15%
Original Mortgage
$465,500
Outstanding Balance
$463,555
Interest Rate
6.96%
Mortgage Type
New Conventional
Estimated Equity
$208,285

Purchase Details

Listed on
Jan 2, 2020
Closed on
May 19, 2020
Sold by
Gallagher Jacob and Gallagher Laura A
Bought by
Burkhouse Mike
Seller's Agent
Beth Rider
Keller Williams Arizona Realty
Buyer's Agent
Holly Poty
Real Broker
List Price
$485,000
Sold Price
$439,000
Premium/Discount to List
-$46,000
-9.48%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.08%
Original Mortgage
$454,804
Interest Rate
3.3%
Mortgage Type
VA

Purchase Details

Closed on
Jun 15, 2017
Sold by
Vip Custon Homes Llc
Bought by
Gallaher Jacob and Gallaher Laura A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$302,450
Interest Rate
4.05%
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
Quinio Santiago Ray Diaz $665,000 Pioneer Title Agency
Burkhouse Mike $439,000 Ez Title Agency Llc
Gallaher Jacob $378,063 First American Title Insuran
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Quinio Santiago Ray Diaz $465,500
Previous Owner Burkhouse Mike $454,804
Previous Owner Gallaher Jacob $302,450
Previous Owner Vip Custom Homes Llc $291,700
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/07/2025 03/07/25 Sold $665,000 -1.5% $198 / Sq Ft
02/04/2025 02/04/25 Price Changed $675,000 -1.5% $201 / Sq Ft
12/07/2024 12/07/24 For Sale $685,000 +56.0% $204 / Sq Ft
05/27/2020 05/27/20 Sold $439,000 -2.4% $131 / Sq Ft
04/26/2020 04/26/20 Pending -- -- --
04/15/2020 04/15/20 Price Changed $450,000 -0.4% $134 / Sq Ft
04/03/2020 04/03/20 Price Changed $452,000 -2.2% $135 / Sq Ft
03/31/2020 03/31/20 Price Changed $462,000 -0.2% $138 / Sq Ft
03/24/2020 03/24/20 Price Changed $463,000 -0.2% $138 / Sq Ft
03/17/2020 03/17/20 Price Changed $464,000 -0.2% $138 / Sq Ft
02/26/2020 02/26/20 Price Changed $465,000 -1.1% $139 / Sq Ft
02/12/2020 02/12/20 Price Changed $470,000 -1.1% $140 / Sq Ft
02/05/2020 02/05/20 Price Changed $475,000 -1.0% $142 / Sq Ft
01/29/2020 01/29/20 Price Changed $480,000 -1.0% $143 / Sq Ft
01/02/2020 01/02/20 For Sale $485,000 -- $145 / 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,301 $31,831 -- --
2024 $2,320 $30,315 -- --
2023 $2,320 $48,430 $9,680 $38,750
2022 $2,250 $37,520 $7,500 $30,020
2021 $2,377 $36,160 $7,230 $28,930
2020 $2,340 $34,060 $6,810 $27,250
2019 $2,151 $32,420 $6,480 $25,940
2018 $2,085 $27,280 $5,450 $21,830
2017 $1,811 $25,860 $5,170 $20,690
2016 $264 $3,255 $3,255 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6792178

Arizona Regional Multiple Listing Service (ARMLS)

APN: 304-22-866