$1,950,000

6255 Hood Mesa Trail Farmington, NM 87401

Estimated payment $11,859/month

Total Views 6,943
3 Beds
3 Baths
5,690 Sq Ft
$343 Price per Sq Ft

Highlights

  • Very Popular Property
  • Accessory Dwelling Unit (ADU)
  • Mountain View
  • Country Club Elementary School Rated A-
  • RV or Boat Parking
  • Viking Appliances

About This Home

''Hacienda de las Vistas'' is a completely custom, one-of-a-kind, luxury experience. This unique mansion overlooks Northern Farmington, NM & includes views of the City, the Valley & Rivers, & the mountains to the North. The main home has 8 attached heated garages, one being an RV garage. This property is massive! Over 5,690sf of living space in 2 residences (not including the garage loft area), & over 5,385sf of attached heated garage space! This home even includes a full-size elevator to get from the garage to the main house! No expense was spared in the construction of this Hacienda. Kitchen boasts extreme vaulted ceilings, custom duo-tone cabinets, professional stainless appliances, double dishwasher, leather textured granite, Viking Professional 6 burner stove w/ griddle & dual oven, & separate fridge & freezer, in counter blender & ice maker, professional vent hood, over stove faucet, & pantry. The remainder of the home has the same level of excellence. Main house has 2 bedrooms w/ en-suite restrooms & oversized closets. Dining room, den, office, laundry, 4 pantries, & game room. Covered front patio w/ lighting, fans, & views for 100's of miles. Access from patio to garage loft (game room) w/ 1⁄2 bath. Attached garage 1 is 3-car w/ workbench, sink, mop sink, storage room, & understairs storage. Attached garage 2 has loft, vaulted tongue-&-groove ceilings, room for 4 cars & 1 RV, a 4-post lift, sink w/ mop sink, 1⁄2 bath downstairs, & upstairs, storage room, & a full-sized elevator. Garage 3 is a detached earthen garage for the guest house. Guest house has a full kitchen, living room w/ stove, balcony, loft bedroom, & bathroom w/ a 6-jet shower. Too many features to list, but here are a few: courtyard w/ firepit, waterfall, & outdoor fireplace. Playground for 20-30 kids. Hiking trail w/ rest stops & a deck on top w/ labeled 360 views. Driveway large enough for 10 tour busses. Built-in speakers. Custom landscaping. Garden area.

Listing Agent

Allen Elmore

eXp Realty, LLC Listed on: 08/15/2025

eXp Realty, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $17,629

Year Built

  • Built in 2000

Lot Details

  • 5 Acre Lot
  • Landscaped

Property Views

  • Mountain
  • Valley

Home Design

  • Southwestern Architecture
  • Concrete Foundation
  • Tile Roof
  • Stick Built Home
  • Stucco

Interior Spaces

  • 5,690 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Cathedral Ceiling
  • Wood Burning Stove
  • Double Pane Windows
  • Living Room with Fireplace
  • 1 Home Office
  • Radiant Floor
  • Walk-Out Basement
  • Home Security System

Kitchen

  • Double Oven
  • Microwave
  • Dishwasher
  • Viking Appliances
  • Granite Countertops
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet
  • 3 Full Bathrooms

Laundry

  • Laundry Room
  • Dryer
  • Washer

Parking

  • 8 Car Attached Garage
  • Garage Door Opener
  • RV or Boat Parking

Outdoor Features

  • Balcony
  • Covered Patio or Porch

Additional Homes

  • Accessory Dwelling Unit (ADU)

Utilities

  • Forced Air Cooling System
  • Evaporated cooling system
  • Vented Exhaust Fan
  • Heating System Uses Natural Gas
  • Gas Water Heater
  • Internet Available

Community Details

  • Foothills

Listing and Financial Details

  • Assessor Parcel Number 2074175148379

Home Details

Home Type

Single Family

Est. Annual Taxes

$17,629

Year Built

Built in 2000

Lot Details

0

Listing Details

  • Additional Living Quarters: Yes
  • Appliance Inclusions: Refrigerator, Washer, Dishwasher, Disposal, Double Oven, Dryer, Exhaust Fan, Microwave, Range/Oven
  • Estimated Total Acres: 5
  • Class: RESIDENTIAL
  • Em Deposit: 7500
  • Em Holder: Title company
  • Exterior Inclusions: Balcony, Covered Porch, Landscaping, Patio
  • Interior Inclusions: Wood Stove, Cathedral Ceiling, W/D Hookup, Wet Bar, Vaulted Ceiling, Granite Counters, Pantry, Security System, Walk In Closet, Garage Door Opener
  • Legal Lot Block: NE NE SW NE 26 30 13 BK.1501 PG.485 BK.1589 PG.622 & SE SE NW NE 26 30 13 BK.1524 PG.102
  • Lot Size Acreage: 5-9.99
  • Parcel Id Number: 2074175148379
  • Price Per Sq Ft: 342.71
  • Property Description: Foothills
  • Real Estate Included: Yes
  • Realist Id: 2074175148379.000000
  • Residence Stories: Two Story
  • Residence Style: Southwest
  • Rv Parking: Yes
  • Sale/Rent: For Sale
  • Siding: Stucco
  • Street Descriptionaccess: City/Town
  • Street Designation: Trail
  • Zoning: Residential Single Family
  • Type: Stick Built
  • Additional Living Type: Guest Home
  • Internet Service: Yes
  • Total Taxes Dollar: 17629.32
  • Year Built: 2000
  • Foreign Owned Y N: No
  • Prop Description Remarks: ''Hacienda de las Vistas'' is a completely custom, one-of-a-kind, luxury experience. This unique mansion overlooks Northern Farmington, NM & includes views of the City, the Valley & Rivers, & the mountains to the North. The main home has 8 attached heated garages, one being an RV garage. This property is massive! Over 5,690sf of living space in 2 residences (not including the garage loft area), & over 5,385sf of attached heated garage space! This home even includes a full-size elevator to get from the garage to the main house! No expense was spared in the construction of this Hacienda. Kitchen boasts extreme vaulted ceilings, custom duo-tone cabinets, professional stainless appliances, double dishwasher, leather textured granite, Viking Professional 6 burner stove w/ griddle & dual oven, & separate fridge & freezer, in counter blender & ice maker, professional vent hood, over stove faucet, & pantry. The remainder of the home has the same level of excellence. Main house has 2 bedrooms w/ en-suite restrooms & oversized closets. Dining room, den, office, laundry, 4 pantries, & game room. Covered front patio w/ lighting, fans, & views for 100's of miles. Access from patio to garage loft (game room) w/ ½ bath. Attached garage 1 is 3-car w/ workbench, sink, mop sink, storage room, & understairs storage. Attached garage 2 has loft, vaulted tongue-&-groove ceilings, room for 4 cars & 1 RV, a 4-post lift, sink w/ mop sink, ½ bath downstairs, & upstairs, storage room, & a full-sized elevator. Garage 3 is a detached earthen garage for the guest house. Guest house has a full kitchen, living room w/ stove, balcony, loft bedroom, & bathroom w/ a 6-jet shower. Too many features to list, but here are a few: courtyard w/ firepit, waterfall, & outdoor fireplace. Playground for 20-30 kids. Hiking trail w/ rest stops & a deck on top w/ labeled 360° views. Driveway large enough for 10 tour busses. Built-in speakers. Custom landscaping. Garden area.
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 19

Interior Features

  • Dining Room: Island
  • Bedrooms: 3
  • Estimated Total Sq Ft: 5690
  • Full Bathrooms: 3
  • Half Bathrooms: 0
  • Bathrooms Quarter: 0
  • Bathrooms Three Quarters: 0
  • Total Bathrooms: 3
  • Fireplace Location Type: Living Room, Woodstove
  • Foundation: Basement-walk out, Concrete
  • Main Level Sq Ft: 4065
  • Master Bedrm Dimensions: 17.5 x 19
  • Master Bedroom Level: Main Level
  • Office Den Dimensions: 27.1 x 18
  • Total Office Den: 1

Exterior Features

  • Windows: Double Pane
  • Exterior Structures: RV/Boat Shelter, Guest House
  • Roof: Tile
  • Views: Mountains, Valley

Garage/Parking

  • Garage Type: Attached Garage
  • Garage: Yes
  • Garage Capacity: 8

Utilities

  • Utilities: Electric, Natural Gas
  • Cooling: Evaporative Cooler, Forced Air
  • Electric Supplier: Farmington Electric Utility System
  • Heating System: Floor Radiant
  • Water Heater: Gas Water Heater

Schools

  • Elementary School: Open Enrollment
  • Middle School: Open Enrollment
  • High School: Open Enrollment
  • High School: Open Enrollment

Lot Info

  • Geo Subdivision: NM

Rental Info

  • Furnished: Unfurnished

Tax Info

  • Tax Year: 2023

MLS Schools

  • Elementary School: Open Enrollment
  • Middle School: Open Enrollment

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
2024 $8,007 $338,816 $0 $0
2023 $8,007 $328,948 $0 $0
2022 $7,630 $319,367 $0 $0
2021 $7,305 $308,303 $0 $0
2020 $7,282 $308,152 $0 $0
2019 $7,213 $306,801 $0 $0
2018 $7,372 $355,750 $0 $0
2017 $8,114 $355,750 $0 $0
2016 $8,078 $355,750 $0 $0
2015 $7,942 $355,750 $0 $0
2014 $7,969 $352,684 $0 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/15/2025 08/15/25 For Sale $1,950,000 0.0% $343 / Sq Ft
08/07/2025 08/07/25 For Sale $1,950,000 0.0% $343 / Sq Ft
10/09/2024 10/09/24 Pending -- -- --
06/14/2024 06/14/24 Price Changed $1,950,000 -2.5% $343 / Sq Ft
05/17/2024 05/17/24 Price Changed $2,000,000 -7.0% $351 / Sq Ft
11/17/2023 11/17/23 Price Changed $2,150,000 -2.3% $378 / Sq Ft
06/29/2023 06/29/23 For Sale $2,200,000 -- $387 / Sq Ft
Source: Colorado Real Estate Network (CREN)

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- None Available
Source: Public Records

About the Listing Agent

Allen Elmore

eXp Realty, LLC

(505) 391-4984

Section Image

NOW SERVING NW NEW MEXICO AND SW COLORADO!

After 25 years in the advertising and marketing industry, Allen Elmore founded AE Properties Team, and has focused his efforts on helping people buy and sell property with one guiding principle: The Platinum Rule (Treat Others How THEY Want To Be Treated).

Allen has managed 3 weekly advertising publications, a women’s health magazine, a car magazine, and a marketing company that focused on political campaigns, branding campaigns, and

Allen's Other Listings

  • 6255 Hood Mesa Trail, Farmington, NM 87401

    $1,950,000

    • 3 Beds
    • 6 Baths
    • 5,690 Sq Ft
    • 6255 Hood Mesa Trail
    • Farmington, NM

    ''Hacienda de las Vistas'' is a completely custom, one-of-a-kind, luxury experience. This unique mansion overlooks Northern Farmington, NM & includes views of the City, the Valley & Rivers, & the mountains to the North. The main home has 8 attached heated garages, one being an RV garage. This property is massive! Over 5,690sf of living space in 2 residences (not including the garage loft area), &

    Allen Elmore EXP Realty, LLC

    Section Image
  • 2235 Lions Trail, Farmington, NM 87401

    $1,273,550

    • 4 Beds
    • 3.5 Baths
    • 4,390 Sq Ft
    • 2235 Lions Trail
    • Farmington, NM

    ''Lion's Share'' Exquisite Spanish-style estate on 2.5-acre hillside in N. Farmington w/ 270 panoramic views of the La Plata Mtns, Lukachukai Mtns, Chokecherry Canyon, Barker Dome & more. Less than 1 hr from Durango, this residence blends elegance, serenity & grandeur and features a heated saltwater pool.Grand entry w/ chandelier & soaring ceilings opens to a sunken den boasting 20' ceilings,

    Allen Elmore EXP Realty, LLC

    Section Image
  • 5895 Pharaohs Trail, Farmington, NM 87401

    $253,475

    • Land
    • 2.5 Acres
    • $101,390 per Acre
    • 5895 Pharaohs Trail
    • Farmington, NM

    ''Pharaoh's Throne'' Quite possibly the finest building site in San Juan County, this 2.5-acre gated hillside property offers unmatched privacy, serenity, and views. Perched high above the valley on a level building site with a new driveway, the lot showcases sweeping 270 vistas of the La Plata Mountains, Lukachukai Mountains, Chokecherry Canyon, Barker Dome, and beyond.Utilities are available,

    Allen Elmore EXP Realty, LLC

    Section Image
  • 5510 Rinconada St, Farmington, NM 87402

    $599,000

    • 5 Beds
    • 3.5 Baths
    • 3,972 Sq Ft
    • 5510 Rinconada St
    • Farmington, NM

    ''Round About'' Discover timeless charm and impressive space in this stunning Spanish-style brick home, where craftsmanship and architectural detail abound. Arched windows and doors, exposed beams, and solid wood finishes create an ambiance that is both elegant and inviting. Enjoy peaceful moments in the shaded front porch or private atrium, and take in sweeping views from the upper-level veranda

    Allen Elmore EXP Realty, LLC

    Section Image
  • NYA Glade Rd, Farmington, NM 87401

    $2,990,000

    • Land
    • 332.34 Acres
    • $8,997 per Acre
    • NYA Glade Rd
    • Farmington, NM

    ''La Plata Cliffs'' Unlock the potential of over 330 acres in the heart of Chokecherry Canyon Recreation Area--an outdoor enthusiast's dream and a developer's blank canvas. Imagine building your dream home, establishing an RV park, creating a tiny home community, developing a destination campground, or transforming it into an off-road and mountain biking paradise. This extraordinary property is

    Allen Elmore EXP Realty, LLC

    Section Image
  • NYA Foothills Dr, Farmington, NM 87402

    $169,000

    • Land
    • 3.83 Acres
    • $44,125 per Acre
    • NYA Foothills Dr
    • Farmington, NM

    Build your dream home on this level and cleared 3.83-acre lot along the highly desirable North Foothills Drive in Farmington, NM. Offering both space and convenience, this property provides the ideal setting for a custom home and shop with plenty of room to spread out. Enjoy the perfect balance of privacy and accessibility--close to town yet with a peaceful, secluded feel. Under an hour from

    Allen Elmore EXP Realty, LLC

    Section Image
  • 3606 English Rd, Farmington, NM 87401

    $4,999,000

    • Land
    • 26.17 Acres
    • $191,020 per Acre
    • 3606 English Rd
    • Farmington, NM

    ''English & Largo'' An unmatched opportunity to acquire one of the most strategically located and versatile parcels in Farmington, New Mexico — just under an hour from Durango, Colorado. This ±26.17-acre property sits directly across from the Animas Valley Mall, offering unparalleled visibility and access in one of the area's most active commercial corridors. Zoned General Commercial, but

    Allen Elmore eXp Realty, LLC

    Section Image
  • 4021 Vista Pinon Dr, Farmington, NM 87401

    $1,400,000

    • 4 Beds
    • 6 Baths
    • 7,976 Sq Ft
    • 4021 Vista Pinon Dr
    • Farmington, NM

    ''Chateau Colline'' Elegant, enormous, bright & airy Southwestern-Style estate located on a cul-de-sac atop Farmington NM's ''F Hill'' w/ views of Shiprock, rivers, bluffs & mountains. Less than 5 minutes from Chokecherry Canyon and under 1 hour from Durango, CO. Smart Home possesses 5312sf of above-ground living space w/ a finished 2440sf basement & 4-car garage. Abundant natural light from

    Allen Elmore eXp Realty, LLC

    Section Image
  • 5713 Pinehurst, Farmington, NM 87402

    $465,000

    • 3 Beds
    • 2 Baths
    • 2,189 Sq Ft
    • 5713 Pinehurst
    • Farmington, NM

    ''Summer Solstice'' Charming updated Southwestern-style home located in the prestigious San Juan Country Club Estates, nestled along Fairway #4 in a private Country Club in northeast Farmington, NM, just under an hour from Durango, CO. This 3-bedroom, 2-bathroom residence boasts an inviting open and split floorplan. As you approach, a covered front porch with a private courtyard welcomes you into

    Allen Elmore eXp Realty, LLC

    Section Image

Source: Colorado Real Estate Network (CREN)

MLS Number: 827651

Colorado Real Estate Network (CREN)

APN: 0050370