Active

14018 Arcadia Road NE

Albuquerque, NM 87123

N/A/5
(0 reviews)
Starting Pricei
$50.94
Projected Annual Returni
8.85%
Projected Rental Yieldi
6.92%
Rental Yieldi
14.03%

Price per token

6 Bed
6 Bath
4300 sqft
Vacation rental

About the Property

Airbnb Rental Home "Casa Cascada" located in Albuquerque, New Mexico.

Offering Details

  • Tristan Huerta transferred his property's deed to a new LLC and is selling a portion of the LLC on the Lofty Marketplace. This property is the only asset owned by the LLC.
  • Tokens represent direct ownership in the LLC that owns the property. Tristan will maintain at least 10% ownership in the LLC indefinitely.
  • View proof of Tristan's ownership before the title transfer here. View proof of title transfer to the LLC here. View the LLC documents here.
  • Tristan is a Superhost on Airbnb and manages the property. View Tristans Airbnb Superhost profile.
  • Tristan was previously the Head of Short Term Rentals at Investment.com.

Airbnb

Property Details

  • Welcome to Casa Cascada! This beautiful 6 bedroom, 6 bath, 4,200 sq. ft. home with 14 beds sleeps 21 comfortably and leaves nothing to be desired.
  • Guests can enjoy the pool with cascading waterfalls, the game room for some ping-pong, or cornhole on the back patio.
  • The spacious home is nestled in the foothills of Albuquerque, just minutes from downtown with easy access to I-40.
  • Casa Cascada is the perfect stay for those looking to enjoy a tastefully designed, New Mexican style home with friends and family.
  • The adobe home has red brick floors, high wood beam ceilings, and Mexican style countertops throughout. Unique New Mexican details are found throughout each room of the house.
  • View costs of furnishings, interior design, and repairs.
  • Tristan will provide a full credit for a new roof and pool resurfacing once these repairs are required.
  • View the repairs made from the inspection report here.
  • Tristan advised that he recently hired a new cleaning crew and the cleanliness issue mentioned in a recent review has now been resolved.
  • The utilities cost in the "Financials" tab includes cleaning, electricity, water, gas, internet, supplies, pool cleaning, Youtube TV, Pricelabs, and Hospitable.
  • The closing costs include an additional $65,959.41 for the purchased furniture, which can be viewed here. The property is fully furnished.
  • View YTD Bookings and Profit & Loss Statement here
  • View Operating Reserve balance chart
  • View property transaction data
  • The annual projected appreciation rate is taken from Zillow

Property Management and Insurance

  • Managed by the seller, Tristan Huerta, and Madison Cason. Both Tristan and Madison are Superhosts on Airbnb.
  • Tristan primarily manages the Airbnb. Madison is a co-host who is the primary point of contact for guests, handles all communication with the cleaning and maintenance team, orders all supplies, and handles any issues that come up.
  • Property Management Agreement
  • Insurance Policy from Proper Insurance Services, LLC.

Airbnb

Property Leverage

  • This property has a loan of $533,900 View the loan documents here.
  • As the seller, Tristan Huerta pays down 100% of the loan payments, his equity percentage in the property will increase and the levered rental yield of investors will decrease over time. Investors have the ability to change this structure via a governance vote.

Occupancy Status

Location Data

  • "A-" Rating for Zip Code on Niche
  • Sandia Peak Ski Area, Albuquerque's only skiable mountain, is a 15 minute drive from Casa Cascada but was temporarily closed 2022. In October 2023, Mountain Capital Partners announced a JV agreement for the operation of Sandia Peak Ski Area. In early February, company officials announced that MCP would assume both ownership and management of Sandia Peak Ski Area. Later that month, the mountain opened to the public for the first time in 2 years. This is the company’s third New Mexico ski area (Pajarito, Sipapu), bringing the company's total portfolio to fourteen ski, bike and golf resorts across the Southwest, Oregon, and Chile. Sandia Peak is included in the company's Power Pass which includes several other resorts like Purgatory and Nordic Valley. The mountain and city itself is significantly more affordable than the alternative (Santa Fe) so Tristan anticipates a significant boost in booking revenue from vacationers.

Due Diligence Documents

  • Property Update (05/17/2025):

    • Owners are currently receiving daily rent calculated from April's cash flow, continuing through June 12th.
    • For April, the net cash flow totaled $4,572.57, compared to March's cash flow of $3,176.25.
    • Year-to-Date Profit & Loss Statement

  • Property Update (04/19/2025):

    • Owners are currently receiving daily rent calculated from March's cash flow, continuing through May 14th.
    • For March, the net cash flow totaled $3,176.25, compared to February's cash flow of $945.33.
    • Year-to-Date Profit & Loss Statement
    • The co-owner and property manager, Tristan, is available in this property's Discord channel to answer questions from owners.

  • Property Update (03/23/2025):

    • Owners are currently receiving daily rent calculated from February's cash flow, continuing through April 13th.
    • For February, the net cash flow totaled $945.33, compared to January's cash flow of $81.81.
    • Year-to-Date Profit & Loss Statement
    • The co-owner and property manager, Tristan, is available in this property's Discord channel to answer questions.

  • Property Update (02/24/2025):

    • Owners are currently receiving daily rent calculated from January's cash flow, continuing through March 16th.
    • For January, the net cash flow totaled $81.81, reflecting a 97.44% decrease compared to December's cash flow of $3,197.06.
    • The Co-owner and property manager, Tristan, reported the below:
    • ""Hi all,
    • Revenue for the offseason, including January, was higher than previous years as expected due to Sandia Peak reopening just 30 minutes away. We did roughly $6,500 in revenue compared to $0 in January last year. February is looking strong with ~$5,500 on the books. As you may remember, we had to switch pool servicing companies over the summer, and we were finally billed by the new company for our outstanding balance ($1,493) in January. This is the primary reason for the breakeven month. Unfortunately, the ups and downs are just the nature of short term rentals, but we have a clean slate expense wise moving into the high season (March - September) and I'm looking forward to another strong summer.
    • Thanks!"
    • Year-to-Date Profit & Loss Statement
    • The co-owner and property manager, Tristan, is available in this property's Discord channel to answer questions from investors.

  • Property Update (01/18/2025):

    • Owners are currently receiving daily rent calculated from December's cash flow, continuing through February 13th.
    • For December, the net cash flow totaled $3,197.06, reflecting a 177.66% increase compared to November's cash flow of $1,151.43.
    • Year-to-Date Profit & Loss Statement

  • Property Update (12/22/2024):

    • Owners are currently receiving daily rent based on November's cash flow through January 13th.
    • For November, the net cash flow totaled $1,105.60, reflecting a 84.42% decrease compared to October's cash flow of $7,095.44.
    • Year-to-Date Profit & Loss Statement

  • Property Update (11/19/2024):

    • Owners are currently receiving daily rent based on October's cash flow through December 14th.
    • For October, the net cash flow totaled $7,095.44, reflecting a 217% increase compared to September’s cash flow of $2,234.88.
    • The Property Manager has also provided the following report for review:
    • Year-to-Date Profit & Loss Statement

  • Property Update (10/19/2024):

    • Owners are now receiving the net cash flow for the month of September on a daily basis until November 13th.
    • The net cash flow in September was $9,588.48, a 52% decrease over August's net cash flow of $10,915.78.
    • Tristan Huerta, the co-owner and property manager, provided the update below.
    • We had 1 cancellation for Sept 25th - 27th - which resulted in a loss of $979.70 in booking revenue
    • We had to refund 1 night of the September 27th - September 30th reservation which resulted in a loss of $665. The refund was due to a party someone had a few blocks over that ultimately led to gunfire. The guests didn't feel safe so we refunded the last night.
    • Our pool company has been fired. We discovered that the closet for the pool equipment has been unlocked which has likely been contributing to the high electricity and water bills. We had to refund $370.47 in pool heating fees due to the pool not heating in time for guest arrival which again was due to our pool servicing company. We've since found a new company and haven't had any issues since.
    • I charged a 15% PM fee on September reservations - a decrease from the normal 25%.
    • October has been extremely uneventful in terms of R&M, refunds, etc. We currently have $15.7k in revenue on the books as of this update - a 21.5% increase over the month of September. The weather has cooled down, and with the replacement of our pool team, I anticipate a significant decrease in utility costs moving forward. We've also gotten several reservations for the offseason which should help to offset this slower month!
    • YTD Profit & Loss Statement & Reservations

  • Property Update (09/16/2024):

    • Owners are now receiving the net cash flow for the month of August on a daily basis until October 15th.
    • The net cash flow in August was $6,355.43, a 41.21% decrease over July's net cash flow of $10,810.35.
    • Tristan, the Co-owner and Property Manager, provided the following update:
    • "Our NOI for August came in lower than anticipated due to several unexpected issues. However, we still outperformed the market with 61.29% occupancy compared to the market average of 56.6% and generated $16.7k in gross revenue.
    • The biggest setback occurred with a 5-night reservation from August 4th to 9th totaling ~$4,300. The guests reported a hot water issue on the morning of August 5th, and I immediately sent a plumber to resolve it. Unfortunately, the issue resurfaced on August 6th, and the guests also found mouse droppings and a chewed container of nuts, which led them to request an early departure and a full refund. Although we’ve never had a mouse problem before and pest control is conducted monthly, I refunded the rest of their stay along with the cleaning fee to avoid a bad review. Unfortunately, they still left a 3-star review, though thankfully, they didn’t detail the specific issues. Pest control later found and captured two mice, sealed all entry points, and placed traps, which showed no further evidence of mice after a few days. The plumber also replaced the burner assembly for $690, resolving the hot water problem for good.
    • Additionally, our electric bill came in high at $1,462, compared to $1,166 for the same period last year, likely due to increased summer usage. I’ve locked the thermostats to prevent them from being set below 68°F and instructed the cleaning team to set the temperature to 76°F between stays, which should help reduce energy costs. We also had to cover some one-off expenses, such as $575 to replace the pool filters and $600 for handyman work that included replacing blinds, fixing tiles, repairing a cabinet door, and completing three dump runs.
    • During August’s heavy thunderstorms, we experienced a leak in the courtyard bedroom, which was built below grade in the late 1980s. This bedroom is prone to water intrusion due to poor drainage and the downward slope of the lot. I had a similar issue after purchasing the house and spent $6,000 to waterproof the room. Unfortunately, it seems the problem has returned, and the original contractor has recommended the same fix for $5,700. Needless to say we won't use him this time around. I’m currently obtaining bids from other contractors to find a more permanent solution. Fortunately, September has been dry, so there haven't been any further issues with that room during guest stays.
    • Looking forward, we’re entering a busy period with the Albuquerque International Balloon Festival in October. We’ve already secured a 5-night booking for $8,000 for the first weekend of the festival, and Casa Cascada is one of the last remaining homes available for the second weekend. I’ve raised the price to $2,000 per night as a result, and expect those dates to be booked soon. We'll gradually start to decrease those rates as we approach the festival in the off chance that it's not. While August was a bit rough, the property has already achieved close to a 5% CoC return in just two months of rent distributions. I remain confident we’re on track for a strong year!"
    • The total hot water tank repair cost is $688.38. The repair costs owed by investors via the Operating Reserve, will be determined based on the ownership stake of investors on the dates the repairs occurred.
    • YTD Profit & Loss Statement

  • Property Update (08/21/2024):

    • Owners are currently receiving the net cash flow from the month of July on a daily basis until September 14th.
    • The net cash flow in July was $10,810.35, a 24.53% increase over June's net cash flow of $8,681.03.
    • View Year-to Date P&L Statement

  • Property Update (07/22/2024):

    • Owners are currently receiving the net cash flow from the month of June on a daily basis until August 14th.
    • The net cash flow in June was $8,681.03, a 4.77% decrease over May's net cash flow of $9,115.99.
    • View Year-to Date P&L Statement

About usMarcetplaceHome

Refer and Earn!


Give $20, Get $50

Sign up below to get started

View Leaderboard
Back

How it works

1

1. Sign up and share your unique link with friends

2

2. They visit Lofty, invest in a property, and hold all tokens purchased continuously for 30 days

3

3. We'll send you both a $25 Lofty Gift Certificate

Refer even more friends for bonus rewards too!

Lofty Referral Program FAQ

  • I know someone who’d love Lofty and would like to refer them. How do I start?
    To start the referral process, please sign up for our referral program here. Once you’ve signed up, you can share your unique referral link via email, SMS, and social networks. Please note, in order to take part in our referral program, terms and conditions apply. You may view the terms of service of our referral program here.
  • What is a successful referral?
    In order for a referral to count, the person you have referred must not already have a Lofty account, they must be investing with Lofty for the first time, they must invest in at least one property token, and they must hold all of the tokens from their first investment with Lofty continuously for 90 days starting on the date of the investment.
  • How do I know how many of my referrals have signed up?
    Once you’ve signed up for our referral program, you will be able to see how many referrals have signed up by logging into our referral program homepage here.
  • If one of my referral signs up, when and how do I get my reward?
    Our team is automatically notified when a referral takes place and will promptly issue rewards for qualified referrals. Once our team approves your reward, you will receive an email from us notifying you with redemption details.
  • My referral forgot to use my unique referral link to sign up. Is there a way I can still receive credit?
    Please contact our team via in dashboard support chat to assist you, and please share with us the email address used by your friend to invest on Lofty.

Lofty Referral Program Terms of Service

  • In order for a referral to count, the person you have referred must not already have a Lofty account, they must be investing with Lofty for the first time, they must invest in at least one property token, and they must hold all of the tokens from their first investment with Lofty continuously for 90 days starting on the date of the investment.
  • Self-referrals are not allowed. Cheating will get you permanently banned from our referral program.
  • We reserve the right to disqualify rewards earned through fraudulent, illegal, or abusive methods.
  • We will only count referrals on links that are automatically tracked and reported by our system. We will not credit a referral if someone says they signed up or someone says they entered a referral code and it was not tracked by our system.
  • We reserve the right to change the terms of service for our referral program at any time.
  • You may not use our referral program for any illegal or unauthorized purpose. You must not violate any laws in your jurisdiction.
  • Referrers may not bid on keywords involving the Lofty brand name, including "Lofty", "Lofty AI", and "Lofty Real Estate". Doing so will get you permanently banned from our referral program.
Powered by GrowSurf
0
GrowSurf
Join our referral program