$525,000
SOLD SEP 19, 2025

475 Front St Unit 237 Lahaina, HI 96761

-- Bed
1 Bath
416 Sq Ft
3.31 Acres

Recently Sold

$1,262 Per Sq Ft

110% Above List Price

37 Days on Market

Highlights

  • Beach Front
  • In Ground Pool
  • No Heating
  • Ocean View
  • 3.31 Acre Lot
  • 2-minute walk to Lahaina Historic Trail

About This Home

As of September 2025

PENDING - STILL SHOW. ACCEPTING BACKUP OFFERS. Worldbid Auction. PRE AUCTION OFFERS: A Buyer may elect to submit a Pre Auction rather than participate in Auction bidding. Pre auction offers may be submitted on a standard HAR (Hawaii Association of Realtors) purchase contract. Pre Auction offers may have any contingency a buyer requests. A Pre Auction offer must be submitted no later than 8/25/25. The offer will state the buyer will remove all contingencies no later than 9/1/25 or close escrow by that date. If the Buyer removes contingencies or closes escrow no later than 9/1/25, the auction will be cancelled. The Pre Auction offer must include the Buyer’s Premium of 4%. No exceptions to the date deadlines will be accepted. The buyer must provide a 10% deposit with their offer, proof of funds to close the purchase and a lender approval letter (if applicable). AUCTION DAY BIDDING: Your Sealed bid must be submitted on the Premiere Estates Sealed Bid auction purchase contract. 1. Qualifying round bids are due on 9/10/25 noon HT and must be emailed to agent. 2. The top 50% bids (by price) of the qualifying round bids received, those bidders will be notified by 9/10/25 3pm HT, they are approved to submit their final bid. The bidders, which have qualified to bid in the Final Bid round are due on 9/11/25 noon HT. Both the qualifying and final round bids must be provided on the Premiere Estates Sealed Bid auction purchase contract. Escrow Shall close no later than 10/11/25. The Sealed Bid auction purchase is available in attached docs. Auction day bids are completely non contingent. Buyer’s may obtain financing, though financing is not a contingency to close. Proof of funds to close and/or a lender’s approval letter are required with your bid. You may conduct your inspections anytime. TRUST SALE - specific terms apply. Welcome to Lahaina Shores, the only beachfront, hotel-zoned resort condominium in Lahaina. Perfectly situated on the sand and a short stroll from historic Front Street, Lahaina Shores is a boutique resort offering a peaceful, tropical atmosphere and the convenience of walkable dining, shopping, and harbor activities. Unit 237 is a fully furnished, second-floor studio offering 416 sqft. of bright, open living space with direct ocean views. The unit features a private lanai perfect for enjoying morning coffee with the sound of waves, a well-equipped kitchenette, and air conditioning for year-round comfort. The resort recently completed a major renovation and reopened to guests and owners on 7/1/25. Certified fire and smoke remediation was conducted throughout the building, followed by environmental testing to confirm safe occupancy. Upgrades include new air conditioning units in all residences, refreshed hallway carpeting and paint, updated landscaping, and a beautifully restored main lobby. Elevator systems were fully rebuilt, damaged electrical and lighting components were replaced, and various plumbing repairs were made to the copper domestic water system. The asphalt parking area was resealed, and the pool and spa facilities were restored and are now fully operational. Ceiling tiles and carpets in the main lobby were also replaced, among many other upgrades. Lahaina Shores blends classic plantation-style architecture with the comfort of modern amenities. Owners and guests enjoy direct beach access, a beachfront pool, concierge and housekeeping services, laundry facilities, and beautifully maintained tropical grounds. HOA fees cover air conditioning, Wi-Fi, cable, water, sewer, trash, grounds maintenance, and exterior building upkeep. Unit 237 shares an interior connection with Unit 235, also for sale. Together, the two units offer a unique opportunity for expanded living, owner-occupancy with guest flexibility, or dual-unit rental income. Don’t miss this chance to own a part of one of Maui’s most iconic beachfront properties with the security of knowing that major capital improvements have just been completed.

Last Agent to Sell the Property

Zoe Berg-Pitt

Compass-W License #S.189296 Listed on: 07/16/2025

Compass-W

Last Buyer's Agent

Zoe Berg-Pitt

Compass-W License #S.189296 Listed on: 07/16/2025

Compass-W

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $7,935

Year Built

  • Built in 1974

Interior Spaces

  • 1 Bathroom
  • 416 Sq Ft Home
  • Ocean Views

Schools

  • King Kamehameha Iii Elementary School
  • Lahaina Intermediate
  • Lahainaluna High School

Additional Features

  • In Ground Pool
  • Beach Front
  • No Heating

Community Details

  • Lahaina Shores Community
  • Lahaina Shores Subdivision

Listing and Financial Details

  • Assessor Parcel Number 2460020070049

Property Details

Home Type

Condominium

Est. Annual Taxes

$7,935

Year Built

Built in 1974

Lot Details

0

Listing Details

  • View: Ocean
  • Year Built: 1974
  • Property Sub Type: Condominium
  • Prop. Type: Residential
  • PoolFeatures: In Ground
  • Subdivision Name: Lahaina Shores
  • Carport Y N: No
  • Garage Yn: No
  • LivingArea: 416
  • Special Features: None

Exterior Features

  • Acres: 3.31
  • View: Yes
  • Waterfront Features: Beach Front
  • Waterfront: Yes

Utilities

  • HeatingYN: No

Schools

  • Elementary School: King Kamehameha III Elementary
  • High School: Lahainaluna High
  • Middle Or Junior School: Lahaina Intermediate

Lot Info

  • Lot Size Sq Ft: 144184
  • ResoLotSizeUnits: Acres
  • Parcel #: 2460020070049

Green Features

Multi Family

  • Building Area Units: Square Feet

Tax Info

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 28, 2025
Sold by
Hayden John Terrell
Bought by
John T Hayden Revocable Trust and Gillach
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 Type Sale Price Title Company
Personal Reps Deed -- None Listed On Document
Personal Reps Deed -- None Listed On Document
Personal Reps Deed -- None Listed On Document
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $476,250 Unknown
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/19/2025 09/19/25 Sold $525,000 +110.0% $1,262 / Sq Ft
08/22/2025 08/22/25 Pending -- -- --
08/22/2025 08/22/25 For Sale $250,000 0.0% $601 / Sq Ft
07/16/2025 07/16/25 For Sale $250,000 -- $601 / Sq Ft
Source: Maui MLS (REALTORS® Association of Maui)

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 $7,935 -- -- --
2024 $7,935 -- -- --
2023 $7,935 $669,600 $82,100 $587,500
2022 $7,035 $593,700 $41,300 $552,400
2021 $7,155 $644,000 $37,600 $606,400
2020 $5,455 $492,300 $37,600 $454,700
2019 $5,612 $522,000 $34,100 $487,900
2018 $3,913 $421,700 $31,000 $390,700
2017 $4,270 $0 $0 $0
2016 $3,514 $403,500 $29,500 $374,000
2015 $3,281 $411,500 $29,500 $382,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Maui MLS (REALTORS® Association of Maui)

MLS Number: 406554

Maui MLS (REALTORS® Association of Maui)

APN: 2-4-6-002-007-0049