$1,650,000
$100K PRICE DROP

1500 N Crismon Rd Mesa, AZ 85207

Estimated payment $9,122/month

Total Views 8,505
4 Beds
3.5 Baths
3,627 Sq Ft
$455 Price per Sq Ft

Highlights

  • Guest House
  • Equestrian Center
  • RV Access or Parking
  • Franklin at Brimhall Elementary School Rated A
  • Private Pool
  • Mountain View

About This Home

Stunning Custom Home with Casita & Breathtaking Views! This exceptional custom home w/ casita is a dream for horse owners, outdoor enthusiasts, and nature lovers alike! Nestled on just under 2 acres w/ horse stalls and an arena, this property backs to a pristine preserve, offering unmatched privacy and breathtaking views—best enjoyed from your rooftop deck. The main home is thoughtfully designed with 3 bedrooms, 2.5 baths, a private office, a separate family room, and an entertainment room. Step outside to a spacious covered patio, perfect for watching stunning Arizona sunsets after a refreshing swim. The separate casita features an open floor plan, 1 bedroom, 1 bath, a full kitchen, and incredible preserve views. Located just minutes from Usery Mountain trailhead and freeway access, this home offers the perfect blend of privacy, convenience, and outdoor adventure!

Listing Agent

Ceejay Cesiel

SERHANT. License #SA653766000 Listed on: 04/10/2025

SERHANT.

Co-Listing Agent

Mary Jo Santistevan

SERHANT. License #SA581367000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,956

Year Built

  • Built in 2000

Lot Details

  • 1.8 Acre Lot
  • Private Streets
  • Desert faces the front and back of the property
  • Wrought Iron Fence
  • Block Wall Fence
  • Artificial Turf

Parking

  • 2 Car Garage
  • 2 Carport Spaces
  • Oversized Parking
  • Garage Door Opener
  • RV Access or Parking

Home Design

  • Spanish Architecture
  • Roof Updated in 2024
  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 3,627 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • 1 Fireplace
  • Double Pane Windows
  • Vinyl Clad Windows
  • Wood Frame Window
  • Mountain Views

Kitchen

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

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

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

Pool

  • Pool Updated in 2024
  • Private Pool

Outdoor Features

  • Balcony
  • Covered Patio or Porch

Schools

  • Zaharis Elementary School
  • Smith Junior High School
  • Skyline High School

Horse Facilities and Amenities

  • Equestrian Center
  • Horses Allowed On Property
  • Horse Stalls
  • Corral
  • Tack Room
  • Arena

Utilities

  • Central Air
  • Heating Available
  • Shared Well
  • Septic Tank
  • High Speed Internet
  • Cable TV Available

Additional Features

  • No Interior Steps
  • Guest House

Community Details

  • Property has a Home Owners Association
  • Association fees include no fees
  • Built by Guzman Bros
  • Cholla Estates Subdivision

Listing and Financial Details

  • Assessor Parcel Number 220-01-018-T

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,956

Year Built

Built in 2000

Lot Details

0

Parking

2

Listing Details

  • Cross Street: Brown and Crismon
  • Legal Info Range: 7E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee: N
  • Basement: N
  • Updated Floors: Full
  • Items Updated Floor Yr Updated: 2020
  • Updated Kitchen: Full
  • Items Updated Kitchen Yr Updated: 2019
  • Updated Pool: Full
  • Items Updated Pool Yr Updated: 2024
  • Updated Roof: Full
  • Items Updated Roof Yr Updated: 2024
  • Parking Spaces Slab Parking Spaces: 4.0
  • Parking Spaces Total Covered Spaces: 4.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2000
  • Tax Year: 2024
  • Directions: North on Crismon to entrance of Cholla Estates on the left. Drive around and loop to the right. Your new home is up the road behind the arena.
  • Property Sub Type: Single Family Residence
  • Horses: Yes
  • Lot Size Acres: 1.8
  • Co List Office Mls Id: serh004
  • Co List Office Phone: 480-703-4085
  • Subdivision Name: Cholla Estates
  • Architectural Style: Ranch, Spanish
  • Property Attached Yn: No
  • Tax Parcel Letter: T
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Cooling:Central Air: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: None

Interior Features

  • Flooring: Tile, Wood
  • Basement YN: No
  • Possible Use: Ranch, Farm
  • Spa Features: None
  • Possible Bedrooms: 5
  • Total Bedrooms: 4
  • Fireplace Features: 1 Fireplace
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Double Vanity, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, No Interior Steps, Kitchen Island, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 3627.0
  • Stories: 1
  • Window Features: Dual Pane, Vinyl Frame, Wood Frames
  • Kitchen Features:RangeOven Elec: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Other Rooms:Great Room: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Other Rooms:Media Room: Yes
  • Community Features:Horse Facility: Yes
  • KitchenFeatures:Refrigerator: Yes

Exterior Features

  • Fencing: Block, Wrought Iron
  • Exterior Features: Balcony, Private Street(s)
  • Lot Features: Desert Front, Natural Desert Back, Gravel/Stone Front, Synthetic Grass Frnt, Synthetic Grass Back
  • Pool Private: Yes
  • View: City Light View(s), Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail, Well Disclosure
  • Construction Type: Stucco, Wood Frame, Painted
  • Other Structures: Separate Guest House
  • Patio And Porch Features: Covered Patio(s)
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Balcony: Yes
  • Exterior Features:Separate Guest House: Yes
  • Exterior Features:Private Street(s): Yes

Garage/Parking

  • Total Covered Spaces: 4.0
  • Parking Features: RV Access/Parking, Garage Door Opener, Extended Length Garage, Attch'd Gar Cabinets
  • Attached Garage: No
  • Carport Spaces: 2.0
  • Garage Spaces: 2.0
  • Open Parking Spaces: 4.0
  • Parking Features:Attch_squote_d Gar Cabinets: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Extended Length Garage: Yes
  • Parking Features:RV AccessParking: Yes

Utilities

  • Cooling: Central Air, Ceiling Fan(s), Programmable Thmstat
  • Heating: Electric
  • Security: Fire Sprinkler System
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: Shared Well
  • Heating:Electric: Yes
  • Sewer Septic Tank: Yes

Condo/Co-op/Association

  • Community Features: Horse Facility
  • Association Fee Frequency: Annually
  • Association Name: Cholla Estates
  • Phone: 00000000
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA DisclosureAddendum Affirmation: Yes
  • Association Fees:HOA Paid Frequency: Annually
  • Association Fees:HOA Name4: Cholla Estates
  • Association Fees:HOA Telephone4: 00000000
  • Association Fees:Special Assessment HOA: No
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fees:HOA Management Company: Self Managed
  • Association Fee Incl:No Fees: Yes

Fee Information

  • Association Fee Includes: No Fees

Schools

  • Elementary School: Zaharis Elementary
  • High School: Skyline High School
  • Junior High Dist: Mesa Unified District
  • Middle Or Junior School: Smith Junior High School

Lot Info

  • Horse Amenities: Arena, Corral(s), Stall, Tack Room
  • Land Lease: No
  • Lot Size Sq Ft: 78364.0
  • Parcel #: 220-01-018-T

Building Info

  • Builder Name: Guzman Bros

Tax Info

  • Tax Annual Amount: 3956.0
  • Tax Book Number: 220.00
  • Tax Lot: -
  • Tax Map Number: 1.00

Map

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

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 $3,956 $46,413 -- --
2024 $3,993 $44,203 -- --
2023 $3,993 $85,710 $17,140 $68,570
2022 $3,898 $67,360 $13,470 $53,890
2021 $3,953 $59,460 $11,890 $47,570
2020 $3,894 $49,820 $9,960 $39,860
2019 $3,599 $45,310 $9,060 $36,250
2018 $3,430 $42,230 $8,440 $33,790
2017 $3,310 $40,500 $8,100 $32,400
2016 $3,250 $41,860 $8,370 $33,490
2015 $3,068 $40,270 $8,050 $32,220
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/16/2025 09/16/25 Price Changed $1,650,000 -1.2% $455 / Sq Ft
08/25/2025 08/25/25 Price Changed $1,670,000 -1.5% $460 / Sq Ft
08/09/2025 08/09/25 Price Changed $1,695,000 -1.2% $467 / Sq Ft
06/19/2025 06/19/25 Price Changed $1,715,000 -0.6% $473 / Sq Ft
05/15/2025 05/15/25 Price Changed $1,725,000 -1.4% $476 / Sq Ft
04/10/2025 04/10/25 For Sale $1,750,000 -- $482 / Sq Ft
Source: Arizona Regional Multiple Listing Service (ARMLS)

Purchase History

Date Type Sale Price Title Company
Special Warranty Deed -- None Listed On Document
Warranty Deed $298,000 Capital Title Agency
Cash Sale Deed $109,000 Chicago Title Insurance Co
Warranty Deed $85,000 Capital Title Agency
Warranty Deed -- Capital Title Agency
Quit Claim Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $297,000 New Conventional
Previous Owner $289,000 New Conventional
Previous Owner $310,000 Unknown
Previous Owner $239,800 Unknown
Previous Owner $238,000 New Conventional
Previous Owner $42,500 Seller Take Back
Source: Public Records

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6846645

Arizona Regional Multiple Listing Service (ARMLS)

APN: 220-01-018T