NOT LISTED FOR SALE

1854 N Red Cliff Mesa, AZ 85207

Estimated Value: $490,000 - $546,000

2 Beds
2 Baths
1,364 Sq Ft
$383/Sq Ft Est. Value

Last Sold July 01, 2014

Last sale price $249,922 $183 Per Sq Ft

Est. 109% increase in value since last sale

Current estimated payment $3,215/month

2 Days on Market

Highlights

  • Fitness Center
  • Gated Community
  • Spanish Architecture
  • Franklin at Brimhall Elementary School Rated A
  • Mountain View
  • Granite Countertops

About This Home

As of July 2014

A Luxury Villa, in gorgeous elevated desert setting! Completed New Build Home!! Resort style lock and leave living in award winning Mountain Bridge! The Villa’s are the most attractive price point within the Mountainbridge Master Plan. Private gated community entrance, heated pools & spas, fitness centers, billiard room, front yard landscape maintenance, and much more! Mountainbridge boasts an unprecedented 45% open space dedicated to natural desert. Gorgeous scenery and incredible freeway access. An easy 2 miles east of the 202 freeway! Cobblestone driveways, welcoming courtyard entry, staggered maple cabinets, 2x6 Exterior Construction, oil rubbed bronze hardware, much more! Taxes Estimated. Purchase Price reflects all incentives offered!!

Last Agent to Sell the Property

Ross Johnson

AZ Brokerage Holdings, LLC License #SA538384000 Listed on: 05/31/2014

Co-Listed By

Jay Scott

AZ Brokerage Holdings, LLC License #SA514181000

Last Buyer's Agent

Non-MLS Agent

Non-MLS Office

Property Details

Home Type

  • Multi-Family

Est. Annual Taxes

  • $2,000

Year Built

  • Built in 2014

Lot Details

  • 6,482 Sq Ft Lot
  • 1 Common Wall
  • Private Streets
  • Desert faces the front and back of the property
  • Wrought Iron Fence
  • Block Wall Fence
  • Front and Back Yard Sprinklers
  • Private Yard

HOA Fees

Parking

  • 2 Car Garage
  • Garage Door Opener

Home Design

  • Spanish Architecture
  • Patio Home
  • Property Attached
  • Wood Frame Construction
  • Tile Roof
  • Block Exterior
  • Stucco

Interior Spaces

  • 1,364 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Double Pane Windows
  • Low Emissivity Windows
  • Mountain Views
  • Washer and Dryer Hookup

Kitchen

  • Breakfast Bar
  • Built-In Microwave
  • Granite Countertops

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 2 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom

Schools

  • Zaharis Elementary School
  • Fremont Junior High School
  • Red Mountain High School

Utilities

  • Central Air
  • Heating Available
  • Water Softener
  • High Speed Internet
  • Cable TV Available

Additional Features

  • No Interior Steps
  • Patio

Listing and Financial Details

  • Tax Lot 95
  • Assessor Parcel Number 219-32-638

Community Details

Overview

  • Association fees include roof repair, insurance, ground maintenance, street maintenance, front yard maint, maintenance exterior
  • Mountain Bridge Association, Phone Number (480) 284-9510
  • Villas Association, Phone Number (480) 284-4510
  • Association Phone (480) 284-4510
  • Built by Blandford Homes
  • Mountain Bridge Subdivision, Villa 1 Floorplan

Recreation

  • Tennis Courts
  • Community Playground
  • Fitness Center
  • Heated Community Pool
  • Community Spa
  • Bike Trail

Additional Features

  • Recreation Room
  • Gated Community

Property Details

Home Type

Multi-Family

Est. Annual Taxes

$2,000

Year Built

Built in 2014

Lot Details

0

HOA Fees

$303 per month

Parking

2

Listing Details

  • Cross Street: McKellips & Ellsworth
  • Legal Info Range: 7E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2 Name: Villas
  • HOA #2 Phone Number: 4802844510
  • HOA #2 Transfer Fee: 30.0
  • HOA #2: Y
  • HOA #3 Fee: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 303.0
  • Basement: N
  • Parking Spaces Total Covered Spaces: 2.0
  • Separate Den Office Sep Den Office: N
  • Year Built: 2014
  • Tax Year: 2015
  • Directions: 202 Red Mountain Freeway, Exit McKellips (Exit 24) and head East on McKellips approximately 1.5 Miles. Right on Mountain Bridge Drive. Follow signage to Models / The Villas
  • Master Model: Villa 1
  • Property Sub Type: Patio Home
  • Horses: No
  • Lot Size Acres: 0.15
  • Co List Office Mls Id: reax48
  • Co List Office Phone: 480-641-1800
  • Subdivision Name: Mountain Bridge
  • Architectural Style: Spanish
  • New Construction: No
  • Property Attached Yn: Yes
  • Association Fees:HOA Fee2: 165.0
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Technology:Cable TV Avail: Yes
  • Windows:Low-E: Yes
  • Cooling:Central Air: Yes
  • Water Source City Water: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Tile
  • Basement YN: No
  • Spa Features: None
  • Possible Bedrooms: 2
  • Total Bedrooms: 2
  • Fireplace Features: None
  • Fireplace: No
  • Interior Amenities: High Speed Internet, Granite Counters, Double Vanity, Breakfast Bar, 9+ Flat Ceilings, No Interior Steps, Soft Water Loop, Pantry, 3/4 Bath Master Bdrm
  • Living Area: 1364.0
  • Stories: 1
  • Window Features: Low-Emissivity Windows, Dual Pane
  • Community Features:ClubhouseRec Room: Yes
  • Kitchen Features:RangeOven Gas: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Master Bathroom:Double Sinks: Yes
  • Community Features:BikingWalking Path: Yes
  • Community Features:Comm Tennis Court(s): Yes
  • Community Features:Community Spa Htd: Yes
  • Community Features:Workout Facility: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Great Room: Yes
  • Community Features:Children_squote_s Playgrnd: Yes
  • Kitchen Features:Gas Stub for Range: Yes
  • Community Features:Gated: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block, Wrought Iron
  • Exterior Features: Private Street(s), Private Yard
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Desert Back, Desert Front
  • Pool Features: None
  • Pool Private: No
  • View: Mountain(s)
  • Disclosures: None
  • Common Walls: 1 Common Wall
  • Construction Type: Stucco, Wood Frame, Block
  • Patio And Porch Features: Patio
  • Property Condition: Complete Spec Home
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Construction:Block: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Construction Status:Complete Spec Home: Yes
  • Exterior Features:Private Street(s): Yes

Garage/Parking

  • Total Covered Spaces: 2.0
  • Parking Features: Garage Door Opener
  • Attached Garage: No
  • Garage Spaces: 2.0
  • Parking Features:Garage Door Opener: Yes

Utilities

  • Cooling: Central Air
  • Heating: Electric
  • Laundry Features: Wshr/Dry HookUp Only
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Community Features: Gated, Community Spa Htd, Tennis Court(s), Playground, Biking/Walking Path, Fitness Center
  • Association #2 Fee: 138.0
  • Association #2 Fee Frequency: Monthly
  • Association Fee: 165.0
  • Association Fee Frequency: Monthly
  • Association: Villas
  • Association Name: Mountain Bridge
  • Association Phone #2: 4802844510
  • Phone: 480-284-9510
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Paid Frequency: Monthly
  • Association Fees:HOA Name4: Mountain Bridge
  • Association Fees:HOA Telephone4: 480-284-9510
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:HOA Paid Frequency 2: Monthly
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: $
  • Association Fee Incl:Front Yard Maint: Yes
  • Association Fee Incl:Street Maint: Yes
  • Association Fee Incl:Exterior Mnt of Unit: Yes
  • Association Fee Incl:Roof Repair: Yes
  • Association Fee Incl:Blanket Ins Policy: Yes

Fee Information

  • Association Fee Includes: Roof Repair, Insurance, Maintenance Grounds, Street Maint, Front Yard Maint, Maintenance Exterior

Schools

  • Elementary School: Zaharis Elementary
  • High School: Red Mountain High School
  • Junior High Dist: Mesa Unified District
  • Middle Or Junior School: Fremont Junior High School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 6482.0
  • Parcel #: 219-32-638

Building Info

  • Builder Name: Blandford Homes

Tax Info

  • Tax Annual Amount: 2000.0
  • Tax Book Number: 219.00
  • Tax Lot: 95
  • Tax Map Number: 32.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 26, 2024
Sold by
Julien Family Revocable Trust
Bought by
Dennis And Carol Hebert Family Trust and Hebert
Current Estimated Value
$521,881

Purchase Details

Closed on
Jun 1, 2020
Sold by
Julien Paul and Julien Joanne
Bought by
Julien Paul E and Julien Joanne M

Purchase Details

Closed on
Jan 3, 2018
Sold by
Frye Raymond
Bought by
Julien Paul and Julien Joanne

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$109,500
Interest Rate
3.9%
Mortgage Type
New Conventional

Purchase Details

Listed on
May 31, 2014
Closed on
Jun 26, 2014
Sold by
Blandford Homes Llc
Bought by
Frye Raymond
Seller's Agent
Ross Johnson
AZ Brokerage Holdings, LLC
Buyer's Agent
Non-MLS Agent
Non-MLS Office
List Price
$249,922
Sold Price
$249,922

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.82%
Original Mortgage
$249,922
Interest Rate
4.17%
Mortgage Type
VA
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
Dennis And Carol Hebert Family Trust $530,000 First American Title
Julien Paul E -- None Available
Julien Paul $284,500 Lawyers Title Of Arizona Inc
Frye Raymond $249,922 Old Republic Title Agency
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Julien Paul $109,500
Previous Owner Frye Raymond $249,922
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/01/2014 07/01/14 Sold $249,922 0.0% $183 / Sq Ft
06/02/2014 06/02/14 Pending -- -- --
05/31/2014 05/31/14 For Sale $249,922 -- $183 / 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 $1,868 $26,101 -- --
2024 $2,583 $24,858 -- --
2023 $2,583 $36,730 $7,340 $29,390
2022 $2,530 $28,910 $5,780 $23,130
2021 $2,560 $25,700 $5,140 $20,560
2020 $2,527 $24,010 $4,800 $19,210
2019 $2,361 $22,310 $4,460 $17,850
2018 $2,266 $21,920 $4,380 $17,540
2017 $1,861 $22,080 $4,410 $17,670
2016 $1,828 $21,170 $4,230 $16,940
2015 $1,725 $20,810 $4,160 $16,650
Source: Public Records

Agents Affiliated with this Home

  • R

    Seller's Agent in 2014

    Ross Johnson

    Realty Executives

  • J

    Seller Co-Listing Agent in 2014

    Jay Scott

    Realty Executives

  • N

    Buyer's Agent in 2014

    Non-MLS Agent

    Non-MLS Office

See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 5123815

Arizona Regional Multiple Listing Service (ARMLS)

APN: 219-32-638

Arizona Maricopa County Mesa 85207

1854 N Red Cliff, Mesa, AZ

This home is located at 1854 N Red Cliff, Mesa, AZ 85207 since 31 May 2014 and is currently estimated at $521,881, approximately $382 per square foot. This property was built in 2014. 1854 N Red Cliff is a home located in Maricopa County with nearby schools including Franklin at Brimhall Elementary School, Zaharis Elementary School, and Franklin West Elementary School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Arizona Regional Multiple Listing Service (ARMLS) All information should be verified by the recipient and none is guaranteed as accurate by ARMLS

Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393

Nearby Homes