Search Open Houses Buyer's Rebate Sell for 2% Sell for $3,500 Statistics Help Tools Saved Searches Testimonials Blog Contact

Oahu Real Estate Logo

20% Rebate for Buyers
$3,500 Flat Fee for Sellers
2% Full Service for Sellers


Found 26 Homes on Lahaina Street

Spreadsheet Comparable View

Click Here to Save This Search to Receive Automatic Email Updates

Bookmark This Page to See Updates Without Having to Search Each Time

Region is Leeward. Street is Lahaina. Status is All. Sorted by Newest First.

Status: Sold - no longer available for sale.

MLS Number: 202406027
List Price: $410,000
Beds/Baths: 3/1
Region: Leeward
Neighborhood: Makaha
List Date: 03-05-2024
Address: 84-927 Lahaina Street
Sold Price: $410,000
Sold Date: 03-08-2024
Living: 704
Land: 10,240
Year Built: 1997
Days on Market: 3

Single family detached home. Tenant occupied and home needs lots of work. Three bedroom, one bath home. Located in Makaha.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202401440
List Price: $785,000
Beds/Baths: 4/2
Region: Leeward
Neighborhood: Makaha
List Date: 01-25-2024
Address: 84-617 Lahaina Street
Sold Price: $805,000
Sold Date: 02-29-2024
Living: 1,966
Land: 5,001
Year Built: 2024
Days on Market: 9

NEW CONSTRUCTION AND BEAUTIFUL! Introducing a brand new pocket of four homes. This brand new, contemporary, open concept floor plan featuring vaulted ceilings, wide hallways and generously sized rooms. This beautiful Waianae home the latest in construction and design to enhance your West Side living. Enjoy the island breeze on your private lanai while taking in majestic mountain views.

The open chef's kitchen boasts shaker cabinets, quartz countertops, and stainless steel appliances. With four bedrooms and three bathrooms, this home is ready to accommodate all of your needs. One bedroom and full bathroom are located on the main level for multi-generational living.

The two-car carport and long driveway offers plentiful parking for cars and toys. Don't miss this opportunity to call this your NEW HOME! Compare pricing to other homes on market and you will discover this home has tremendous value. Home comes with a one-year home warranty.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202400823
List Price: $815,000
Beds/Baths: 4/3
Region: Leeward
Neighborhood: Makaha
List Date: 01-15-2024
Address: 84-623 Lahaina Street
Sold Price: $815,000
Sold Date: 02-28-2024
Living: 1,966
Land: 5,490
Year Built: 2023
Days on Market: 13

NEW CONSTRUCTION AND BEAUTIFUL! Introducing a brand new pocket of four homes. This brand new, contemporary, open concept floor plan featuring vaulted ceilings, wide hallways and generously sized rooms. This beautiful Waianae home offers the latest in construction and design to enhance your West Side living. Enjoy the island breeze on your private lanai while taking in majestic mountain views.

The open chef's kitchen boasts shaker cabinets, quartz countertops and stainless steel appliances. With four bedrooms and three bathrooms, this home is ready to accommodate all of your needs. One bedroom and full bathroom is located on the main level for multi-generational living.

The two-car carport and long private driveway offers plentiful parking for cars and toys. Don't miss this opportunity to call this your NEW HOME! Compare pricing to other homes on market and you will discover this home is a tremendous value. Home comes with a one year home warranty.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202400703
List Price: $545,000
Beds/Baths: 3/1
Region: Leeward
Neighborhood: Makaha
List Date: 01-12-2024
Address: 84-1064 Lahaina Street 1
Sold Price: $520,000
Sold Date: 03-15-2024
Living: 864
Land: 4,400
Year Built: 1959
Days on Market: 10

Cute remodeled 3 bedroom 1 bath home in a 4 unit CPR with no association fees! Laminate and tile floors throughout the house. Two parking spaces in front with a grassy yard. Easy walk or drive to Lahilahi Beach, Long's and other shops. Move in ready!

Top of Page

Status: Active - availble to show. Not In Escrow.

MLS Number: 202400724
List Price: $675,000
Price changed from $699,000
Beds/Baths: 5/2
Region: Leeward
Neighborhood: Makaha
List Date: 01-11-2024
Address: 84-730 Lahaina Street
Living: 1,632
Land: 5,000
Year Built: 1968
Days on Market: 99


Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202328498
List Price: $570,000
Beds/Baths: 4/1
Region: Leeward
Neighborhood: Makaha
List Date: 01-03-2024
Address: 84-705 Lahaina Street
Sold Price: $560,000
Sold Date: 03-22-2024
Living: 1,056
Land: 5,963
Year Built: 1983
Days on Market: 36

As you step inside, you'll be greeted by a warm, well-maintained and welcoming home. This 4 bedroom, 1 and half bathroom home has room for everyone and is ready for new owners to create lasting memories. The updated bathrooms add a modern touch. A covered carport provides convenient parking. For those who love outdoor living, this home has a covered patio, perfect for hosting gatherings with friends and family.

Or relaxing under the shade of your large mango tree. Proximity to schools, essential amenities and the beach makes it easy to enjoy the laid-back lifestyle of Makaha. This well-maintained home is ready for new owners to create lasting memories. Don't miss the opportunity to make this your own. Schedule your viewing today and step into the doorway of your new home! One or more photos have been enhanced.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202326692
List Price: $599,000
Beds/Baths: 3/1
Region: Leeward
Neighborhood: Makaha
List Date: 12-14-2023
Address: 84-755 Lahaina Street
Sold Price: $579,000
Sold Date: 02-23-2024
Living: 880
Land: 7,540
Year Built: 1958
Days on Market: 35

Looking for a renovated property available for immediate occupancy at closing? Dwelling renovated in 2023. New plumbing, electrical, flooring, bathroom, kitchen and bedrooms. Recessed lighting, mirror closet doors and ceiling fans. Roof was replaced approximately 12 years ago. Looking for a place to park your boat? This is the property. Fully fenced large property zoned R-5. Seller's have topography map, survey and approval for second sewer connection to construct a new attached dwelling or an ADU.

No plans available. Perfect for an investor. Rental income while you wait for your building permit. Seller's have active Hawaii real estate licenses. Property scheduled for tent fumigation but easy to show. Priced to sell. Buyer to do their own due diligence. Large mango tree on property.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202325088
List Price: $675,000
Beds/Baths: 3/2
Region: Leeward
Neighborhood: Makaha
List Date: 11-06-2023
Address: 84-790 Lahaina Street
Sold Price: $635,000
Sold Date: 01-05-2024
Living: 1,134
Land: 5,082
Year Built: 2016
Days on Market: 21

Discover island living at its best in this Move-In Ready home on the Leeward side. Built in 2016, newly renovation - new interior paint, new exteriors paint, new kitchen, new bathroom, cabinets in 2023 with new appliances. This spectacular single-level residence offers easy living with 3 bedrooms and 2 full baths. The home features leased PV panels, central AC, and a solar water heater, Lease Pv system making it energy-efficient. Enjoy the open floor plan , and fully fenced outdoor area. With no Association or HOA fees, this is your chance to own a great home in Makaha. Don't miss out!

Top of Page

Status: Active - availble to show. Not In Escrow.

MLS Number: 202324828
List Price: $589,000
Price changed from $625,000
Beds/Baths: 4/2
Region: Leeward
Neighborhood: Makaha
List Date: 11-01-2023
Address: 84-833A Lahaina Street
Living: 1,248
Land: 5,820
Year Built: 1989
Days on Market: 170

PRICE ENHANCEMENT! NEW VINYL FENCE!!! From the moment you step inside, you'll be treated to the details and finishing touches of your new home. The new luxury vinyl plank floors welcome your every step. Fresh paint inside and out brightens everyone's day. The updated kitchen provides plenty of space to cook for the family with its modern cabinets, countertops, and new appliances.

Featuring four bedrooms and two fully remodeled bathrooms, there's plenty of space for everyone to feel at home and at peace. New fans, lights, a two-car carport and a long driveway....everything you need is here. Schedule your showing today!

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202324211
List Price: $799,500
Beds/Baths: 4/3
Region: Leeward
Neighborhood: Makaha
List Date: 10-20-2023
Address: 84-615 Lahaina Street
Sold Price: $800,000
Sold Date: 03-07-2024
Living: 2,242
Land: 5,490
Year Built: 2023
Days on Market: 86

WELCOME TO YOUR NEW HOME! Be the first to live in this contemporary two-story flag lot home with wonderful mountain and territorial views and just blocks from the ocean. Step foot into the grand living room featuring vaulted ceilings and lots of light shining through the many windows. The main floor open concept offers a chef's kitchen with white shaker cabinets, island with quartz counters and stainless steel appliances.

The main floor full bath features double vanity and luxuriously tiled bath surround. The main level bedroom could be a home office or playroom with access to the relaxing back lanai. The second floor offers a cozy alcove and two sizable bedrooms adjoining the second full bathroom.

The owner's suite features high ceilings and a beautiful main bath as well as walk-in closet. The two-car carport and long private driveway offers room for many vehicles. At under $800,000 and over 2000 square feet of new construction, this is the best value on the West Side!. Home comes with a one year home warranty.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202324198
List Price: $775,000
Beds/Baths: 4/2
Region: Leeward
Neighborhood: Makaha
List Date: 10-20-2023
Address: 84-621 Lahaina Street
Sold Price: $775,000
Sold Date: 02-07-2024
Living: 2,000
Land: 5,000
Year Built: 2023
Days on Market: 33

NEW CONSTRUCTION! Introducing a brand new, contemporary, open concept floor plan featuring vaulted ceilings, wide hallways and generously sized rooms. This beautiful Waianae home offers the latest in construction and design to enhance your West Side living. Enjoy the island breeze on your private lanai while taking in majestic mountain views. The open chef's kitchen boasts shaker cabinets, quartz countertops and stainless steel appliances.

With four bedrooms and two full bathrooms, this home is ready to accommodate all of your needs. The two-car carport and driveways offers plentiful parking for cars and toys. Don't miss this opportunity to call this beautiful property your new HOME! Compare pricing to other homes on market and you will discover this home is a tremendous value at over 2000 square feet of new construction. Homes come with a one year home warranty.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202321092
List Price: $600,000
Beds/Baths: 4/2
Region: Leeward
Neighborhood: Makaha
List Date: 09-14-2023
Address: 84-815 Lahaina Street
Sold Price: $553,000
Sold Date: 11-01-2023
Living: 1,059
Land: 5,300
Year Built: 1949
Days on Market: 14

POSSIBLY THE BEST PRICED HOUSE IN MAKAHA, OAHU, HAWAII. IDEAL FOR A FIRST-TIME HOMEOWNER OR INVESTOR. AN EXCELLENT OPPORTUNITY FOR RENTERS WHO'VE BEEN WANTING TO OWN! BUY THIS HOME & BUILD UP EQUITY. HOME FULLY REMODELED IN 2023, INSIDE AND OUT. NEW ROOF/GUTTERS. NEW FLOORING IN ALL ROOMS. THIS ONE WILL BE GONE QUICKLY! SOLD "AS IS".

Top of Page

Status: Active - availble to show. Not In Escrow.

MLS Number: 202316871
List Price: $699,000
Price changed from $725,000
Beds/Baths: 3/2
Region: Leeward
Neighborhood: Makaha
List Date: 08-01-2023
Address: 84-790 Lahaina Street
Living: 1,134
Land: 5,082
Year Built: 2016
Days on Market: 262

Discover island living at its best in this Move-In Ready home on the Leeward side. Built in 2016, newly renovation - new interior paint, new exteriors paint, new kitchen, new bathroom, cabinets in 2023 with new appliances. This spectacular single-level residence offers easy living with 3 bedrooms and 2 full baths. The home features leased PV panels, central AC, and a solar water heater, making it energy-efficient. Enjoy the open floor plan , and fully fenced outdoor area. With no Association or HOA fees, this is your chance to own a great home in Makaha. Don't miss out!

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202314778
List Price: $520,000
Beds/Baths: 3/1
Region: Leeward
Neighborhood: Makaha
List Date: 07-05-2023
Address: 84-755 Lahaina Street
Sold Price: $455,000
Sold Date: 09-15-2023
Living: 880
Land: 7,540
Year Built: 1958
Days on Market: 22

Single Family House with large flat lot and it’s priced below assessed value for land. Bring your imagination for this large parcel of flat lot. Bring your imagination for this large parcel of flat lot. House is in fair condition. An ideal 'fixer-upper' for starter or investment or rebuild with your desired plans. Conveniently located a couple of blocks away from Farrington Hwy and close to beaches, parks, shops and schools.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202302766
List Price: $698,000
Beds/Baths: 3/2
Region: Leeward
Neighborhood: Makaha
List Date: 02-20-2023
Address: 84-736 Lahaina Street
Sold Price: $680,000
Sold Date: 04-11-2023
Living: 912
Land: 5,000
Year Built: 1972
Days on Market: 13

A beautifully refreshed 3-bdrm, 2-bath home in Makaha! Completely renovated from the floor to the roof, this single-level home offers a comfortable, efficient and open floor plan. Enjoy the improvements of vinyl plank flooring throughout, double walls, new windows, stainless steel appliances, LED lighting, rain gutters, patio decking, and so many more to appreciate.

Plenty of tandem parking spaces, 2 cars on each side. Fenced in spacious back yard as well as a large shaded front patio makes it perfect for outdoor gatherings. Enjoy the small town residential community with short distances to Makaha Beach Park, Makaha Valley Country Club, and many great coastal and valley settings to appreciate in Makaha's famous destination.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202300539
List Price: $499,000
Price changed from $700,000
Beds/Baths: 4/2
Region: Leeward
Neighborhood: Makaha
List Date: 01-31-2023
Address: 84-833 Lahaina Street A
Sold Price: $400,000
Sold Date: 08-24-2023
Living: 1,248
Land: 5,820
Year Built: 1989
Days on Market: 106

Motivated seller gives another HUGE PRICE REDUCTION for this partially renovated 4 bedroom/2 bath detached single family home! Lowest priced detached single family home in Makaha at this time! Recent renovations include a brand new hallway bathroom, new living room picture window and hand rails on back porch have been secured. A few years ago, the kitchen and living room area were remodeled as well.

House is located down a private driveway, away from the noise of the main street. Some parts of the house need work but with a little TLC, this house could be your dream home! Just a few minutes' drive from world famous Makaha beach. Click on the reel icon for virtual tour. Schedule your private showing today!

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202300457
List Price: $745,000
Price changed from $899,000
Beds/Baths: 4/2
Region: Leeward
Neighborhood: Makaha
List Date: 01-10-2023
Address: 84-1162 Lahaina Street 3
Sold Price: $761,800
Sold Date: 04-19-2023
Living: 1,595
Land: 5,281
Year Built: 2022
Days on Market: 37

Brand new single family home, CPR, has 4 bedrooms, 2 baths with 9 ft. ceiling, 2-car carport with 12 ft. ceiling and additional parking space. A beautiful plantation style home with open floor layout of living/dining room and modern kitchen with large center island. Split AC in all rooms, luxury vinyl plank flooring, front/back covered lanai, and fence around the house with security sliding gate. Enjoy the mountain views or walk to the beautiful beaches of Waianae Coast. Price below tax assess value of $856,300

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202300525
List Price: $742,000
Price changed from $778,000
Beds/Baths: 4/2
Region: Leeward
Neighborhood: Makaha
List Date: 01-10-2023
Address: 84-1162 Lahaina Street 2
Sold Price: $740,000
Sold Date: 05-18-2023
Living: 1,503
Land: 4,264
Year Built: 2022
Days on Market: 83

Brand new single family home, CPR, has 4 bedrooms, 2 baths with 9 ft. ceiling, 2-car carport with 12 ft. ceiling and additional parking space. A beautiful plantation style home with open floor layout of living/dining room and modern kitchen with large center island. Split AC in all rooms, luxury vinyl plank flooring, front/back covered lanai, and fence around the house with security sliding gate. Enjoy the mountain views or walk to the beautiful beaches of Waianae Coast. Price below tax assess value of $836,900

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202220753
List Price: $591,700
Beds/Baths: 3/2
Region: Leeward
Neighborhood: Makaha
List Date: 10-07-2022
Address: 84-827A Lahaina Street
Sold Price: $593,000
Sold Date: 12-07-2022
Living: 1,196
Land: 4,905
Year Built: 2018
Days on Market: 28

Wow - lots of value to be found in this 3 BR/2 BA single family home that is in excellent condition. Setback from the road on a flag lot, it was built in 2018 and has energy efficient insulated double wall construction, vaulted ceilings, luxury vinyl flooring, quartz counters, split AC, Solar water heater, 2 car garage and much more. Spacious master bedroom has lots of storage and a beautiful bathroom with walk-in shower. Enjoy the beaches and water year around being conveniently located in close proximity to world class beaches. Private backyard awaiting your custom touches. No AOAO fees.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202219425
List Price: $450,000
Beds/Baths: 3/2
Region: Leeward
Neighborhood: Makaha
List Date: 09-13-2022
Address: 84-790 Lahaina Street
Sold Price: $440,000
Sold Date: 06-09-2023
Living: 1,134
Land: 5,082
Year Built: 2016
Days on Market: 2

SHORT SALE OFFER WITH BANK PENDING Lienholder APPROVAL - WARNING PREVIOUS LEAK WITH MOLD PRESENT PLEASE CONTACT LISTING AGENT FOR SHOWINGS - Waianae Coast Single-Story Residence constructed in 2016 with mountain views located within a short distance to the beach. 3 bedrooms, 2 full baths, leased PV panels, central AC, solar water heater, stainless steel appliances in kitchen and washer/dryer on premise but not guaranteed to function.

Fenced yard for privacy and contains a mango tree. Plenty of parking space. NO ASSOCIATION OR MAINTENANCE FEES. Short sale is negotiated by law firm for a fee of $6500 and is paid by buyer at closing. Terms acceptable are cash or conventional loan.
Short Sale

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202218857
List Price: $1,000,000
Price changed from $1,100,000
Beds/Baths: 5/2
Region: Leeward
Neighborhood: Makaha
List Date: 09-02-2022
Address: 84-694A Lahaina Street
Sold Price: $900,000
Sold Date: 10-31-2023
Living: 1,624
Land: 15,040
Year Built: 1963
Days on Market: 392

Must see to appreciate! Beautiful 15k sq ft property located a few minutes from beautiful beaches, golf course, hiking spots, and schools. This charming 5bedrooms 2 bathroom 1624 sq ft living area home has had many improvements. Enjoy stunning sunsets, mountain views, and cascading waterfalls during the rainy season. Fully fenced with automatic steel gate and landscaped yard with irrigation system.

Big front and backyard for your pets and children to play. Lots of storage and space for gatherings. 2-car carport attached with outside bathrooms and shower. Big driveway for 6+ cars and your boat. Split AC, solar water heater, and prepaid solar system. One or more photos enhanced to give the buyer a modern design feel. Broker and open house on 06/07/2023 from 10AM to Noon.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202214664
List Price: $709,000
Beds/Baths: 4/2
Region: Leeward
Neighborhood: Makaha
List Date: 08-01-2022
Address: 84-911 Lahaina Street
Sold Price: $715,000
Sold Date: 09-30-2022
Living: 1,200
Land: 5,000
Year Built: 2012
Days on Market: 7

Come home to this lovely 4-bedroom, 2-bath Single Family Home in Makaha! Enjoy the many upgrades this home has to offer; vinyl plank flooring for a modern look, 5 split ac units throughout to stay comfortable and cool, and 38 OWNED PV PANELS to help keep the electric expense down. The home sits on a fully fenced 5,000 square ft lot providing ample yard space for gatherings with family and friends, parking for multiple vehicles and views of the Makaha mountain range from the front yard. Don't miss out on the opportunity to own this great home in Makaha!

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202213563
List Price: $625,000
Beds/Baths: 6/3
Region: Leeward
Neighborhood: Makaha
List Date: 07-14-2022
Address: 84-1111A Lahaina Street
Sold Price: $563,750
Sold Date: 11-10-2022
Living: 1,719
Land: 5,437
Year Built: 1980
Days on Market: 30

Open House this Sunday 8/28 from 2-5pm! Amazing opportunity with this duplex, plenty of possibilities! Perfect for a large family, investor or live in one side and rent out the other side. Newly refreshed interior painting, door frames, doors, toilets, 2 new bathroom vanities, new front security doors, etc. The layout is a 3 bed 2 bath and a 3 bed 1 bath with separate front & back entrances. 23 panel OWNED Photovoltaic system is a huge bonus to help keep the electricity bill low.

Extremely durable granite floor tile throughout the entire home. This home has great bones with its concrete foundation and clay tile roof. Fully fenced yard (brand new wood fencing installed in between back neighbor) and a large outdoor patio area out front. A short walk to Mauna Lahilahi beach park, longs drugs, 7/11 gas station, shave ice, etc... Schedule a private showing today!

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202212448
List Price: $709,999
Price changed from $775,000
Beds/Baths: 4/3
Region: Leeward
Neighborhood: Makaha
List Date: 06-29-2022
Address: 84-865 Lahaina Street
Sold Price: $700,000
Sold Date: 07-26-2023
Living: 1,404
Land: 5,192
Year Built: 1942
Days on Market: 348

Welcome Home to your island country getaway! Located at the majestic Waianae Makaha. Single level home with open floor plan. Two primary suits, with a total of four bedrooms. Great closet space. Brand new appliances. Beautiful open kitchen and living room, a great space for large gatherings and/ or to create cozy multiple seating areas. Take advantage of the low maintenance outdoor area which gives you more time to relax and enjoy mountain views or walk to the beautiful beaches of Waianae coast. Must see this house!

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202210367
List Price: $796,000
Price changed from $896,000
Beds/Baths: 4/2
Region: Leeward
Neighborhood: Makaha
List Date: 06-01-2022
Address: 84-1162 Lahaina Street 1
Sold Price: $770,000
Sold Date: 12-21-2022
Living: 1,503
Land: 5,232
Year Built: 2022
Days on Market: 68

Brand new single family home, CPR, has 4 bedrooms, 2 baths with 9 ft. ceiling, 2-car carport with 12 ft. ceiling and additional parking space. A beautiful plantation style home with open floor layout of living/dining room and modern kitchen with large center island. Split AC in all rooms, luxury vinyl plank flooring, front/back covered lanai, and fence around the house with security sliding gate. Enjoy the mountain views or walk to the beautiful beaches of Waianae Coast.

Top of Page

Status: Sold - no longer available for sale.

MLS Number: 202210382
List Price: $785,000
Price changed from $899,000
Beds/Baths: 4/2
Region: Leeward
Neighborhood: Makaha
List Date: 06-01-2022
Address: 84-1162 Lahaina Street 4
Sold Price: $805,000
Sold Date: 12-30-2022
Living: 1,595
Land: 5,223
Year Built: 2022
Days on Market: 82

Brand new single family home, CPR, has 4 bedrooms, 2 baths with 9 ft. ceiling, 2-car carport with 12 ft. ceiling and additional parking space. A beautiful plantation style home with open floor layout of living/dining room and modern kitchen with large center island. Split AC in all rooms, luxury vinyl plank flooring, front/back covered lanai, and fence around the house with security sliding gate. Enjoy the mountain views or walk to the beautiful beaches of Waianae Coast.

Top of Page

http://www.oahure.com/ClickToSearchResults.php?PropertyType=RES&MLSAreaMajor=Leeward&Neighborhood=&StreetName=Lahaina

(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Lahaina' AND MLSAreaMajor = 'Leeward' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)