NOT LISTED FOR SALE

1854 N Red Cliff Mesa, AZ 85207

Estimated Value: $519,546 - $556,000

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

Last Sold July 01, 2014

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

Est. 114% increase in value since last sale

Current estimated payment $3,423/month

2 Days on Market

Highlights

  • Fitness Center
  • Heated Spa
  • Mountain View
  • Franklin at Brimhall Elementary School Rated A
  • Gated Community
  • Clubhouse

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

Ross Johnson

Realty Executives License #SA538384000 Listed on: 06/01/2014

Realty Executives

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

  • $303 Monthly 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

Kitchen

  • Breakfast Bar
  • Built-In Microwave
  • Dishwasher
  • Granite Countertops

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • Walk-In Closet
  • 2 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom

Laundry

  • Laundry in unit
  • Washer and Dryer Hookup

Pool

  • Heated Spa
  • Heated Pool

Schools

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

Utilities

  • Refrigerated Cooling System
  • 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

  • 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
  • FHA/VA Approved Complex

Amenities

  • Clubhouse
  • Recreation Room

Recreation

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

Security

  • 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
  • HOA #2 Fee: 138.0
  • 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
  • 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
  • ResoBuildingAreaSource: Builder
  • Association Fees:HOA Fee2: 165.0
  • Special Features: None

Interior Features

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

Exterior Features

  • Fencing: Block, Wrought Iron
  • Exterior Features: Patio, Private Street(s), Private Yard
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Desert Back, Desert Front
  • Pool Features: Community, Heated, None
  • View: Mountain(s)
  • Disclosures: None
  • Common Walls: 1 Common Wall
  • Construction Type: Stucco, Block, Frame - Wood
  • 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: Electric Door Opener
  • Attached Garage: No
  • Garage Spaces: 2.0
  • Parking Features:Electric Door Opener: Yes

Utilities

  • Cooling: Refrigeration
  • Heating: Electric
  • Laundry Features: Inside, Wshr/Dry HookUp Only
  • Security: Gated Community
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Community Features: Tennis Court(s), Playground, Biking/Walking Path, Clubhouse, Fitness Center
  • Amenities: FHA Approved Prjct, Management, Rental OK (See Rmks), VA Approved Prjct
  • Association #2 Fee: 138.0
  • Association #2 Fee Frequency: Monthly
  • 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

Schools

  • Elementary School: Zaharis Elementary
  • High School: Red Mountain High School
  • Middle Or Junior School: Fremont Junior High School

Lot Info

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

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
Total Days on Market
2
Current Estimated Value
$534,637

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
Jun 1, 2014
Closed on
Jun 26, 2014
Sold by
Blandford Homes Llc
Bought by
Frye Raymond
Seller's Agent
Ross Johnson
Realty Executives
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
7.34%
Original Mortgage
$249,922
Interest Rate
4.17%
Mortgage Type
VA

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

Similar Homes in the area

  • 1043 N 90th Cir Unit 34, Mesa, AZ 85207

    $485,000

    • 3 Beds
    • 2 Baths
    • 1,775 Sq Ft
    • 1043 N 90th Cir
    • Unit 34
    • Mesa, AZ

    Welcome to this beautifully maintained single-level home tucked away on a quiet cul-de-sac lot in a prime Mesa location! With 3 bedrooms and 2 bathrooms, this home also includes a bonus room created by converting the 4th bedroom into an extra-large space with dual full-size closets — perfect for a home office, playroom, or media room. The home features a brand new carpet, an open and functional

    Gina Dwyer Citiea

    Section Image
  • 10856 E Arcadia Ave, Mesa, AZ 85208

    $420,000

    • 3 Beds
    • 2.5 Baths
    • 1,540 Sq Ft
    • 10856 E Arcadia Ave
    • Mesa, AZ

    HUGE LOT with OWNED SOLAR! Plus, a BRAND NEW ROOF! Pristine 3 bdrm. with addtl DEN/LOFT, 2.5 bath. Oversized Great Room. Kitchen comes with Stainless Steel appliances, freshly painted cabinets, new lighting and a Pantry, along with eat Kitchen! Upstairs Laundry! Spacious primary bedroom includes en suite and walk in closet. A large slider from the Dining Room leads to beautiful extended

    Gwendolyn Miriani eXp Realty

    Section Image
  • 6202 E Mckellips Rd Unit 189, Mesa, AZ 85215

    $489,900

    • 2 Beds
    • 2 Baths
    • 1,633 Sq Ft
    • 6202 E Mckellips Rd
    • Unit 189
    • Mesa, AZ

    Welcome to this impeccably maintained, upgraded villa located in the highly desirable, gated golf community of Tuscany Villas at Painted Mountain Golf Resort. This turnkey end unit features an oversized, south-facing backyard & a private, gated courtyard entry. Inside, an open floor plan awaits, showcasing a gourmet kitchen with granite countertops, a generous island, modern chalk appliances &

    Diane Bearse Realty Executives

    Section Image
  • 5830 E Mckellips Rd Unit 100, Mesa, AZ 85215

    $395,000

    • 2 Beds
    • 2 Baths
    • 1,547 Sq Ft
    • 5830 E Mckellips Rd
    • Unit 100
    • Mesa, AZ

    Discover the charm of this highly desirable home in the vibrant, gated community of Apache Wells II. This immaculate turnkey residence offers privacy and serenity with views of a lush greenbelt. The bright and open floor plan features vaulted ceilings and abundant natural light, creating a welcoming atmosphere. Two spacious bedrooms, each with walk-in closets, provide comfort and convenience. The

    Lorraine Ryall KOR Properties

    Section Image
  • 4786 E Laurel Ct, Gilbert, AZ 85234

    $420,000

    • 3 Beds
    • 2.5 Baths
    • 1,375 Sq Ft
    • 4786 E Laurel Ct
    • Gilbert, AZ

    Charming two story home in La Aldea Community. This home has 3 bedrooms and 2.5 baths. New stainless appliances, including brand new washer and dryer. Fresh exterior paint. New Hvac system. Small low maintenance yard, plus fenced side yard. Shared driveway to private 2-car garage. Community offers grassed parks, with playgrounds, walking paths and a beautiful community pool and spa. Highly

    April Kuhlmann OMNI Homes International

    Section Image
  • 945 N Pasadena Unit 61, Mesa, AZ 85201

    $399,950

    • 3 Beds
    • 2 Baths
    • 1,552 Sq Ft
    • 945 N Pasadena
    • Unit 61
    • Mesa, AZ

    Immaculate and move-in ready patio home in Park Centre exuding quiet privacy. Great end lot location sitting on the community greenbelt! Walking paths T/O the area. Home offers an open layout great room with vaulted ceilings, fireplace, wood floors, and two sliding glass doors that merge the indoor/outdoor living areas. Peace of mind with newer roof underlayment in 2012, HVAC 2013, windows 2015,

    Mark Toon My Home Group Real Estate

    Section Image
  • 945 N Pasadena Unit 62, Mesa, AZ 85201

    $420,000

    • 3 Beds
    • 2 Baths
    • 1,380 Sq Ft
    • 945 N Pasadena
    • Unit 62
    • Mesa, AZ

    Look NO further! This adorable 3-bedroom patio home, FULLY FURNISHED in Park Centre is the one for you. Situated on a cul-de-sac, it offers a 2-car garage and a gated courtyard as well as a backyard! Check out the perfectly flowing living & dining room featuring travertine flooring, custom cabinets T/O, remodeled bathrooms. The kitchen has recessed lighting, plenty of cabinets, built-in S/S

    Mark Toon My Home Group Real Estate

    Section Image
  • 45 E 9th Place Unit 36, Mesa, AZ 85201

    $399,900

    • 3 Beds
    • 3 Baths
    • 1,831 Sq Ft
    • 45 E 9th Place
    • Unit 36
    • Mesa, AZ

    Discover this stunning single-story home featuring 3 bedrooms and 2 bathrooms, complete with modern flooring, fresh paint, updated fixtures, and stylish lighting with bright, high ceilings throughout. The spacious open kitchen boasts elegant quartz countertops and beautifully refinished white cabinets. One of the secondary bedrooms includes an en suite bath, providing the perfect setup for guests

    John Biddle Redfin Corporation

    Section Image
  • 633 W 1st St, Mesa, AZ 85201

    $405,000

    • 3 Beds
    • 2 Baths
    • 1,479 Sq Ft
    • 633 W 1st St
    • Mesa, AZ

    What an opportunity to own 2 homes in 1 in the heart of Mesa. This property is located among single family homes & has a main house w/2 BR's 1 BA + an attached guest house w/1 BR 1 BA. Long time owner has taken great care of this property. Main house has tile thruout main living area w/carpet in BR's & an updated KIT w/white cabinets. Long time tenant would like to stay if purchased by investor.

    Linda Patterson West USA Realty

    Section Image

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

  • Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 5123815

Arizona Regional Multiple Listing Service (ARMLS)

APN: 219-32-638