fixed div


Oahu Real Estate Logo

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

Add this Search to your Daily Watch List

107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
1 LH|CPR1 * 2 * 3View 19Active 202407806 $89,888$89,888LeewardMailiKahe Kai 87-122 Helelua Street C201 21/0666$13520No10%2197504-07-202427Average$46$602$46,400$111,300$157,70057%05 - R-5 Residential District  None, OtherOpen - 2, Tandem
2 FS|CPR1 * 2 * 3View 20Active 202400046 $185,000$185,000LeewardMailiKahe Kai 87-119 Helelua Street F201 21/0666$27820No20%21975200603-27-202438Fair$46$601$46,400$111,300$157,700117%NanaikaponoNanakuliNanakuli05 - R-5 Residential District  OtherOtherAssigned, Open - 2, Street
3 LH1 * 2 * 3View 6Active 202407132 $198,000$198,000LeewardMailiPuu Heleakala 87-215 Helelua Street 1 41/11,302$15220No42%2197404-08-202426Average$64$642$163,300$92,100$255,40078%05 - R-5 Residential District  NoneOtherAssigned, Open - 2
4 FS|SS1 * 2 * 3View 13Active 202309935 $292,000$200,000LeewardMailiPuu Heleakala 87-201 Helelua Street #2 31/11,176$24820No42%1197405-01-2023369Needs Major Repair$64$559$163,900$66,700$230,600127%NanakuliNanakuliNanakuli05 - R-5 Residential District  NoneAssigned, Street
5 FS1 * 2 * 3View 15Active 202407129 $315,000$315,000LeewardMailiPuu Heleakala 87-217 Helelua Street 6 31/11,216$2592120No42%3197404-08-202426Fair$86$559$158,500$133,400$291,900108%05 - R-5 Residential District  SunsetOtherAssigned, Carport
6 FS|OH|OV1 * 2 * 3View 17Active 202406572 $335,000$335,000LeewardMailiPuu Heleakala 87-216 Helelua Street 2 31/11,291$25920No41%3197403-18-202447Above Average$25$602$156,600$115,400$272,000123%05 - R-5 Residential District  OceanConservationCovered - 2, Garage
7 FS|OH|MV1 * 2 * 3View 23Active 202410472 $355,000$355,000LeewardMailiPuu Heleakala 87-1457 Helelua Street 7 41/11,302$27320No42%1197405-03-20241Excellent$69$641$162,700$92,100$254,800139%05 - R-5 Residential District  MountainAssigned, Open - 2
8 FS|FC|MV|CPR1 * 2 * 3View 18Active 202409240 $420,000$450,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road MN30 43/01,500$280389No78%1201204-26-20248Average$177$602$159,100$447,000$606,10069%MailiWaianaeWaianae05 - R-5 Residential District  Garden, Mountain, OtherStream/CanalAssigned, Guest, Open - 3+
9 FS|OV|MV|CPR|OF|BF1 * 2 * 3View 25Active 202408725 $458,000$458,000LeewardMailiMaili Cove 87-561 Farrington Highway 307 11/0632$72510No31%3197504-23-202411Above Average$128$814$138,900$298,300$437,200105%05 - R-5 Residential District  Coastline, Mountain, Ocean, SunsetOcean, Sandy BeachAssigned, Guest, Open
10 FS|OV|CPR|OF1 * 2 * 3View 23Active 202408245 $459,000$459,000LeewardMailiMaili Cove 87-561 Farrington Highway 109 11/0632$7261112No31%11975202304-15-202419Above Average$67$813$138,900$310,200$449,100102%05 - R-5 Residential District  Ocean, SunsetOceanAssigned, Guest, Open - 1
107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
11 FS|OH|OV|MV|CPR|OF|BF1 * 2 * 3View 25Active 202406140 $465,000$465,000LeewardMailiMaili Cove 87-561 Farrington Highway 317 11/0632$7361112No31%31975201603-11-202454Excellent$125$831$138,900$305,400$444,300105%MailiWaianaeWaianae05 - R-5 Residential District  Coastline, Garden, Mountain, Ocean, SunsetOcean, Sandy Beach, WaterfrontAssigned, Guest
12 FS|OV|CPR|OF1 * 2 * 3View 25Active 202302450 $467,700$477,000LeewardMailiMaili Cove 87-561 Farrington Highway 311 11/0632$7401112No38%3197502-11-2023448Above Average$95$813$138,000$192,000$131,000357%WaianaeWaianaeWaianae05 - R-5 Residential District  Ocean, SunsetOceanOpen - 1
13 FS|OV|MV|CPR1 * 2 * 3View 25Active 202407390 $475,000$475,000LeewardMailiMaili Cove 87-561 Farrington Highway 319 11/0632$75210No31%31975202204-01-202433Above Average$70$813$138,900$298,300$437,200109%05 - R-5 Residential District  Coastline, Mountain, Ocean, SunsetAssigned, Open - 1
14 FS1 * 2 * 3View 25Active Under Contract 202407863 $325,000$325,000LeewardMailiPuu Heleakala 87-1444 Helelua Street 4 31/01,131$28720No42%0197404-08-202426Excellent$34$614$160,800$58,800$219,600148%05 - R-5 Residential District  NoneAssigned, Open - 2
15 FS|CPR1 * 2 * 3View 15Active Under Contract 202403569 $435,000$450,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road U49 32/11,270$34320No78%1201202-14-202480Average$136$510$134,000$330,500$465,20094%05 - R-5 Residential District  NoneOtherOpen - 2
16 FS|SS|MV|CPR1 * 2 * 3View 25Active Under Contract 202214185 $560,000$595,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road P37 43/01,500$373389No80%1201208-15-2022628Above Average$123$602$132,900$388,100$521,000107%05 - R-5 Residential District  MountainAssigned, Guest, Open - 3+
17 FS|MV|CPR1 * 2 * 3View 25Active Under Contract 202408038 $579,000$579,000LeewardMailiPalm Grove 87-163 Mamoalii Place 87/163 43/01,512$38330Yes75%1197404-17-202417Above Average, Average$161$123$423,100$81,200$504,300115%05 - R-5 Residential District  Mountain, SunsetCarport, Tandem
18 FS|MV|CPR1 * 2 * 3View 24Cancelled 202320580 $599,000$599,000LeewardMailiN-A 87-1958 Pakeke Street J 32/01,158$51720No73%12006202310-12-202314Excellent, Above Average$157$548$359,000$180,700$539,700111%05 - R-5 Residential District  City, Coastline, Garden, Mountain, Other, Sunrise, SunsetOtherAssigned, Covered - 2, Guest, Street
19 FS|MV|CPR1 * 2 * 3View 24Cancelled 202210965 $515,000$515,000LeewardMailiPalm Grove 87-150 Mamoalii Place 87/150 32/0972$53020Yes75%11974202206-10-20228Above Average$82$100$353,300$63,600$416,900124%05 - R-5 Residential District  Marina/Canal, Mountain, SunsetOther, Stream/CanalCarport, Covered - 2, Open - 1
20 LH|CPR1 * 2 * 3View 3Cancelled 202301636 $59,000$65,000LeewardMailiKahe Kai 87-122 Helelua Street C201 21/0666$8920No10%2197501-30-202385Average$42$511$43,900$106,600$150,50039%NanaikaponoNanakuliNanakuli05 - R-5 Residential District  NoneAssigned
107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
21 LH|OV|CPR1 * 2 * 3View 13Cancelled 202224645 $69,999$79,999LeewardMailiKahe Kai 87-123 Helelua Street G205 21/0665$10520No10%21975202211-21-202224Excellent$44$505$43,900$106,600$150,50047%05 - R-5 Residential District  OceanAssigned
22 LH|CPR1 * 2 * 3View 1Cancelled 202211746 $80,000$80,000LeewardMailiKahe Kai 87-118 Helelua Street B202 21/0666$12010No10%2197506-20-202266Above Average, Average, Excellent, Fair, Needs Major Repair, Tear$36$498$43,900$101,600$145,50055%NanaikaponoNanakuliNanakuli05 - R-5 Residential District  NoneAssigned
23 FS|MV|CPR1 * 2 * 3View 16Cancelled 202214202 $175,000$175,000LeewardMailiKahe Kai 87-134 Helelua Street A201 21/0666$26310No10%21975202207-24-20229Above Average$36$498$43,900$101,600$145,500120%NanaikaponoNanakuliNanakuli05 - R-5 Residential District  MountainOtherOpen - 1, Street
24 FS|FC|SS1 * 2 * 3View 1Cancelled 202309887 $188,035$188,035LeewardMailiPuu Heleakala 87-213 Helelua Street 1 31/11,176$16010No40%1197404-28-20237Needs Major Repair$1$602$141,200$78,200$219,40086%05 - R-5 Residential District  NoneOpen - 1
25 FS|MV1 * 2 * 3View 19Cancelled 202325743 $309,000$319,000LeewardMailiPuu Heleakala 87-182 Helelua Street 2 31/01,131$27320No40%0197411-17-202324Average$64$580$161,400$58,800$220,200140%05 - R-5 Residential District  MountainAssigned
26 FS1 * 2 * 3View 13Cancelled 202226262 $345,000$345,000LeewardMailiPuu Heleakala 87-149 Helelua Street 2 41/11,302$26520No40%11974202012-27-202223Excellent, Above Average$68$571$140,500$92,700$233,200148%05 - R-5 Residential District  NoneAssigned, Open - 2, Street
27 FS|OV|CPR|OF|BF1 * 2 * 3View 10Cancelled 202224682 $409,000$438,000LeewardMailiMaili Cove 87-561 Farrington Highway 106 11/0632$6471112No38%1197511-20-2022163Average$104$751$131,200$197,700$328,900124%WaianaeWaianaeWaianae05 - R-5 Residential District  Coastline, Ocean, SunsetOcean, Sandy BeachAssigned, Guest, Open - 1
28 FS|FC|CPR1 * 2 * 3View 25Cancelled 202307125 $458,400$593,600LeewardMailiHolomoana At Sea Country 87-1972 Pakeke Street K 32/01,196$38320No76%1200603-30-202374Fair$147$548$323,100$181,300$504,40091%05 - R-5 Residential District  NoneAssigned
29 FS|OV|MV|CPR|OF|BF1 * 2 * 3View 1Cancelled 202406588 $468,000$468,000LeewardMailiMaili Cove 87-561 Farrington Highway 307 11/0632$74110No31%3197503-27-202425Above Average$128$814$138,900$298,300$437,200107%05 - R-5 Residential District  Coastline, Mountain, Ocean, SunsetOcean, Sandy BeachAssigned, Guest, Open
30 FS|OV|CPR|OF|BF1 * 2 * 3View 25Cancelled 202400539 $470,000$475,000LeewardMailiMaili Cove 87-561 Farrington Highway 109 11/0632$7441112No31%11975202301-11-202482Above Average$67$813$138,900$310,200$449,100105%MailiWaianaeWaianae05 - R-5 Residential District  Ocean, SunsetOcean, Sandy BeachAssigned, Guest
107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
31 FS|SS|MV|CPR1 * 2 * 3View 17Cancelled 202308804 $499,000$499,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Street C6 32/11,222$408289No81%2201204-11-2023100Fair$112$490$129,600$343,200$471,800106%MailiWaianaeWaianae05 - R-5 Residential District  MountainOther, Stream/CanalAssigned, Guest, Street
32 FS|OV|MV|CPR|OF|BF1 * 2 * 3View 25Cancelled 202317195 $499,000$499,000LeewardMailiMaili Cove 87-561 Farrington Highway 307 11/0632$79010No31%3197507-25-2023218Above Average$54$751$138,900$298,300$437,200114%05 - R-5 Residential District  Mountain, Ocean, SunsetOcean, Sandy Beach, WaterfrontAssigned, Guest, Open
33 FS|CPR1 * 2 * 3View 25Cancelled 202216699 $510,000$535,000LeewardMailiPalm Grove 87-154 Mamoalii Place 87/154 32/0967$52720Yes71%11974202208-16-202286Above Average$123$100$353,300$68,500$421,800121%05 - R-5 Residential District  NoneOtherCovered - 1, Open - 2
34 FS|MV|CPR1 * 2 * 3View 14Cancelled 202216632 $540,000$565,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road D12 43/01,500$360289No80%1201208-15-202292Above Average$134$602$132,900$328,100$461,000117%05 - R-5 Residential District  MountainAssigned, Guest, Open - 2
35 FS|FC|MV|CPR1 * 2 * 3View 0Cancelled 202313149 $601,100$0LeewardMaili 87-2141 Pakeke Street NA 42/11,402$42920No70%2200706-05-2023197Average$180$387$446,100$262,000$708,10085%MailiWaianaeWaianae05 - R-5 Residential District  MountainCovered - 2
36 FS|CPR1 * 2 * 3View 13Cancelled 202212551 $605,000$638,000LeewardMailiHolomoana at Sea Country 87-1980 Pakeke Street N 32/01,234$49020No76%2200607-07-2022192Above Average, Average$107$724$380,600$210,200$590,800102%05 - R-5 Residential District  NoneOtherGarage
37 FS|SU|CPR1 * 2 * 3View 4Expired 202211950 $279,000$279,000LeewardMailiGarden Groves 87-1550 Farrington Highway H3 32/01,100$25420No40%1197506-21-2022365Fair$60$475$130,400$107,600$238,000117%05 - R-5 Residential District  NoneOtherAssigned, Open - 2
38 FS|FC|CPR1 * 2 * 3View 3Expired 202224570 $298,900$312,900LeewardMailiGarden Groves 87-1550 Farrington Highway J8 32/01,100$27220No40%1197511-20-202239Average$69$475$130,400$107,600$238,000126%NanaikaponoNanakuliNanakuli05 - R-5 Residential District  NoneAssigned, Open - 2
39 FS|FC|MV|CPR1 * 2 * 3View 18Expired 202323786 $450,000$525,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road MN30 43/01,500$30040No78%1201210-12-202389Average$177$602$159,100$447,000$606,10074%MailiWaianaeWaianae05 - R-5 Residential District  Garden, Mountain, OtherStream/CanalAssigned, Guest, Open - 3+
40 FS|SU|CPR1 * 2 * 3View 25Expired 202223869 $639,000$639,000LeewardMailiHolomoana at Sea Country 87-1980 Pakeke Street P 32/01,263$50600No63%1200611-07-2022122Excellent$143$665$380,600$210,200$590,800108%05 - R-5 Residential District  NoneOtherGarage, Other
107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
41 FS|CPR1 * 2 * 3View 10Pending 202407808 $195,000$195,000LeewardMailiKahe Kai 87-127 Helelua Street H303 21/0666$29310No20%31975202404-06-202423Above Average$46$601$46,400$105,600$152,000128%NanaikaponoNanakuliNanakuli05 - R-5 Residential District  NoneOtherAssigned, Open - 1
42 FS|CPR1 * 2 * 3View 1Sold 202404425 $190,000$190,000LeewardMailiKahe Kai 87-131 Helelua Street J205 $190,00005-01-2024100%100%21/0666$28520No10%2197502-28-202419Above Average$46$580$46,400$135,100$181,500105%05 - R-5 Residential DistrictBernadette A HannaKina KnisleyGardenAssigned, Open - 2
43 FS|MV|CPR1 * 2 * 3View 1Sold 202326249 $459,000$485,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road J23 $420,00004-10-202492%87%32/11,270$361389No82%1201212-18-202357Average$144$535$134,700$359,600$494,30093%MailiWaianaeWaianae05 - R-5 Residential DistrictChance K KnellMichelle M IchikawaMountainOtherAssigned, Open - 3+
44 FS|CPR1 * 2 * 3View 5Sold 202326118 $185,000$185,000LeewardMailiKahe Kai 87-127 Helelua Street H202 $165,00003-19-202489%89%21/0666$27810No10%2197511-27-202340Above Average$37$511$46,400$79,800$126,200147%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictJason H AlthouseMonika LR KauhiGardenAssigned, Open - 1
45 FS1 * 2 * 3View 22Sold 202327860 $345,000$345,000LeewardMailiPuu Heleakala 87-215 Helelua Street 2 $345,00002-14-2024100%100%41/11,302$26520No42%1197412-13-202316Above Average$70$605$163,300$75,300$238,600145%05 - R-5 Residential DistrictDean Hiromi UedaCherise FMA Antoque-TiltonNoneOpen - 2
46 FS|MV|CPR1 * 2 * 3View 25Sold 202325691 $299,500$299,500LeewardMailiGarden Groves 87-1550 Farrington Highway C1 $300,00001-26-2024100%100%32/01,100$27220No39%2197511-28-20236Fair$89$475$130,400$174,800$305,20098%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictAmelita Bing Provido PurpuraErnie PesebreMountainOtherAssigned, Open - 2
47 FS|MV|CPR1 * 2 * 3View 12Sold 202322419 $510,000$520,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road D12 $520,00012-14-2023102%100%43/01,500$340289No78%1201210-06-202338Above Average$172$602$159,100$431,800$590,90086%05 - R-5 Residential DistrictMyra YamadaLexi BrownMountainAssigned, Guest, Open - 2
48 FS|OV|MV|CPR1 * 2 * 3View 16Sold 202324225 $199,800$199,800LeewardMailiKahe Kai 87-126 Helelua Street D302 $204,00011-20-2023102%102%21/0666$30020No19%31975202310-22-20238Excellent, Above Average$45$511$46,400$110,600$157,000127%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictCarleigh IntelliCathy BridgesMountain, Ocean, Sunrise, SunsetOtherAssigned, Open - 2, Tandem
49 FS|MV1 * 2 * 3View 16Sold 202320954 $309,000$309,000LeewardMailiPuu Heleakala 87-186 Helelua Street 2 $321,00011-20-2023104%104%31/01,131$27320No40%1197410-09-202314Excellent$65$580$162,300$58,700$221,000140%05 - R-5 Residential DistrictJerry AdamanyCharlene TonggMountain, SunsetAssigned, Open - 2
50 FS|CPR1 * 2 * 3View 20Sold 202320799 $189,000$189,000LeewardMailiKahe Kai 87-134 Helelua Street A204 $184,00011-14-202397%97%21/0667$28310No10%2197509-08-202318Average$35$520$46,400$106,300$152,700124%05 - R-5 Residential DistrictDaniel R KaslowPunahele CarnateNoneAssigned
107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
51 FS|OV|MV|CPR1 * 2 * 3View 7Sold 202320852 $185,000$180,000LeewardMailiKahe Kai 87-123 Helelua Street G307 $180,00011-06-202397%100%21/0666$27810No10%3197509-12-202326Above Average, Average$44$511$46,400$105,600$152,000122%05 - R-5 Residential DistrictJoshua M MunTiare LandoMountain, OceanOpen - 1
52 FS|CPR1 * 2 * 3View 19Sold 202319177 $195,000$195,000LeewardMailiKahe Kai 87-123 Helelua Street J202 $197,00011-02-2023101%101%21/0666$29310No10%2197508-07-202332Above Average$44$511$46,400$79,800$126,200155%05 - R-5 Residential DistrictChristopher S LennonDebra L AddessiNoneAssigned, Open - 1
53 FS|MV|CPR1 * 2 * 3View 24Sold 202317617 $195,000$195,000LeewardMailiKahe Kai 87-122 Helelua Street C301 $195,00010-18-2023100%100%21/0666$29320No10%3197508-28-20238Above Average$38$511$46,400$84,100$130,500149%05 - R-5 Residential DistrictJoshua M MunCarol P ChristieMountainOpen - 2, Tandem
54 LH1 * 2 * 3View 25Sold 202311728 $169,000$169,000LeewardMailiPuu Heleakala 87-196 Helelua Street 6 $165,00009-18-202398%98%31/11,176$14420No40%1197406-05-202332Excellent, Above Average, Average$2$537$140,900$78,200$219,10077%05 - R-5 Residential DistrictAshley MurrayDavid JacobsGardenOtherAssigned
55 FS|OV|MV|CPR1 * 2 * 3View 25Sold 202313992 $550,000$550,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road Z63 $550,00009-15-2023100%100%43/01,500$367289No80%1201206-18-202331Above Average, Average$150$602$159,100$499,300$658,40084%05 - R-5 Residential DistrictErica YoonJanine K ChangMountain, OceanOtherOpen - 2
56 FS1 * 2 * 3View 10Sold 202316772 $295,000$295,000LeewardMailiPuu Heleakala 87-137 Helelua Street 4 $300,00009-13-2023102%102%31/01,131$26120No30%1197407-19-20237Above Average$61$580$162,700$58,700$221,400133%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictPeter P MoixJustin K TaparraNoneAssigned, Open - 2, Street
57 FS|CPR1 * 2 * 3View 1Sold 202320917 $200,000$200,000LeewardMailiKahe Kai 87-118 Helelua Street D106 $200,00009-08-2023100%100%21/0666$30010No24%1197509-08-20230Average$45$511$46,400$107,000$153,400130%05 - R-5 Residential DistrictNON MLSDaniel Loli BatallaniNoneAssigned
58 FS|CPR1 * 2 * 3View 25Sold 202316356 $360,000$360,000LeewardMailiGarden Groves 87-1550 Farrington Highway J8 $370,00009-06-2023103%103%32/01,100$32720No53%1197507-11-202337Excellent$70$578$130,400$174,800$305,200118%NanakuliNanakuliNanakuli05 - R-5 Residential DistrictGeraldine C SupapoCharlene TonggNoneAssigned, Open - 2
59 FS1 * 2 * 3View 14Sold 202316141 $339,000$339,000LeewardMailiPuu Heleakala 87-2131 Helelua Place 8 $345,00008-23-2023102%102%41/11,131$30020No40%01974202307-08-20239Above Average$67$627$161,400$76,300$237,700143%05 - R-5 Residential DistrictKatherine KeliiJarrod DennisonNoneOtherAssigned, Street
60 LH|CPR1 * 2 * 3View 9Sold 202313636 $60,000$60,000LeewardMailiKahe Kai 87-122 Helelua Street C201 $50,00008-21-202383%83%21/0666$9020No10%2197506-12-202317Average$42$511$43,900$106,600$150,50040%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictFerdinand LucasBen EgerNoneAssigned
107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
61 FS|CPR1 * 2 * 3View 5Sold 202314311 $195,000$195,000LeewardMailiKahe Kai 87-122 Helelua Street C206 $200,00008-07-2023103%103%21/0666$29320No10%21975202306-22-20233Excellent$44$511$46,400$111,300$157,700124%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictPeter P MoixAnthony James CoxNoneAssigned, Open - 2
62 FS1 * 2 * 3View 14Sold 202314545 $299,000$299,000LeewardMailiPuu Heleakala 87-182 Helelua Street 1 $315,00008-07-2023105%105%31/01,131$26420No40%11974202307-03-20232Excellent, Above Average$61$580$162,900$58,700$221,600135%05 - R-5 Residential DistrictJerry AdamanyKimberly A FutrellNoneAssigned, Open - 2, Street
63 FS|CPR1 * 2 * 3View 3Sold 202311683 $170,000$170,000LeewardMailiKahe Kai 87-131 Helelua Street J203 $170,00007-31-2023100%100%21/0666$25520No16%2197505-27-202313Average$50$511$43,900$101,600$145,500117%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictMarcelina M Silvester-ThomasKina KnisleyOtherOtherOpen - 2
64 FS|CPR1 * 2 * 3View 10Sold 202309324 $189,000$189,000LeewardMailiKahe Kai 87-118 Helelua Street B101 $184,50007-25-202398%98%21/0666$28410No19%11975198004-19-202318Average$45$511$43,900$102,200$146,100129%05 - R-5 Residential DistrictElaine L PetersonElaine L PetersonNoneOtherAssigned, Open - 1
65 FS|MV1 * 2 * 3View 25Sold 202309364 $315,000$303,000LeewardMailiPuu Heleakala 87-186 Helelua Street 3 $315,00007-20-2023100%104%41/11,302$24220No41%11974201604-21-202339Above Average, Average$69$626$160,400$75,300$235,700134%05 - R-5 Residential DistrictDaniel K IharaEmely U RubioMountain, SunsetAssigned, Open - 2, Street
66 FS|CPR1 * 2 * 3View 1Sold 202314466 $185,000$185,000LeewardMailiKahe Kai 87-119 Helelua Street F203 $185,00007-17-2023100%100%21/0666$27810No10%2197506-26-20230Above Average$44$511$46,400$106,300$152,700121%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictPeter P MoixRyan S OdaNoneAssigned, Open - 1
67 FS1 * 2 * 3View 1Sold 202314295 $310,000$310,000LeewardMailiPuu Heleakala 87-208 Helelua Street 1 $310,00006-20-2023100%100%31/11,291$24020No40%1197406-20-20230Average$74$0$158,500$115,400$273,900113%05 - R-5 Residential DistrictNON MLSDaniel Loli BatallaniNoneOtherCovered - 2
68 FS1 * 2 * 3View 1Sold 202225209 $335,000$329,000LeewardMailiPuu Heleakala 87-149 Helelua Street 4 $335,00006-15-2023100%102%41/11,301$25720No0%2197412-06-2022150Above Average, Average$65$622$141,200$92,400$233,600143%05 - R-5 Residential DistrictKatherine KeliiSara A MeloNoneOtherAssigned
69 FS|OV|MV|CPR1 * 2 * 3View 19Sold 202309139 $189,000$189,000LeewardMailiKahe Kai 87-126 Helelua Street D308 $195,00006-06-2023103%103%21/0666$28410No10%3197504-18-20238Above Average$44$511$46,400$110,600$157,000120%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictPaz R CateilKilinahe Ka'awaloaMountain, OceanOtherAssigned
70 FS1 * 2 * 3View 14Sold 202309345 $325,000$325,000LeewardMailiNA 87-209 Helelua Street 1 $320,00005-31-202398%98%31/11,218$2672100No40%2197404-19-202319Above Average, Average$75$602$138,700$114,700$253,400128%05 - R-5 Residential DistrictElaine L PetersonLindsey ItamotoCoastlineOtherAssigned, Covered - 2, Garage, Street
107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
71 FS1 * 2 * 3View 14Sold 202309605 $345,000$345,000LeewardMailiPuu Heleakala 87-149 Helelua Street 2 $355,00005-30-2023103%103%41/11,302$26520No40%11974202004-24-20238Excellent, Above Average$68$627$140,500$92,700$233,200148%05 - R-5 Residential DistrictThompson H PhamCathy PossediNoneAssigned, Open - 2, Street
72 FS|MV1 * 2 * 3View 10Sold 202225926 $339,000$335,000LeewardMailiPuu Heleakala 87-133 Helelua Street 2 $330,00005-19-202397%99%41/11,302$26020No25%11974201812-17-202226Excellent$80$591$144,000$53,500$197,500172%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictPeter P MoixLoribelle F Mendoza VillalpandMountainOtherAssigned
73 FS|MV1 * 2 * 3View 24Sold 202220636 $349,000$349,000LeewardMailiPuu Heleakala 87-204 Helelua Street 3 $328,00005-17-202394%94%41/11,302$2682282No41%11974202209-30-2022132Above Average, Average$68$578$139,000$92,600$231,600151%05 - R-5 Residential DistrictLindsey ItamotoJason SubtMountain, SunsetAssigned, Open - 2
74 FS|FC|CPR1 * 2 * 3View 12Sold 202306895 $234,900$234,900LeewardMailiGarden Groves 87-1550 Farrington Highway J8 $220,93105-02-202394%94%32/01,100$21420No40%1197503-27-20234Fair$69$475$130,400$107,600$238,00099%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictJustin T MorikawaGeraldine C SupapoNoneAssigned, Open - 2
75 FS|CPR1 * 2 * 3View 10Sold 202303294 $200,000$200,000LeewardMailiKahe Kai 87-122 Helelua Street C301 $195,00004-17-202398%98%21/0666$30020No10%31975202102-27-20235Excellent, Above Average$44$511$43,900$105,900$149,800134%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictMonika LR KauhiJoshua M MunNoneAssigned, Open - 2
76 FS1 * 2 * 3View 10Sold 202301219 $320,000$320,000LeewardMailiPuu Heleakala 87-150 Helelua Street 3 $320,00004-04-2023100%100%41/11,332$2402100No20%11974202102-13-20237Excellent, Above Average$69$538$142,300$92,700$235,000136%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictMonika LR KauhiKatherine KeliiNoneAssigned, Open - 2
77 FS|MV1 * 2 * 3View 1Sold 202301935 $320,000$320,000LeewardMailiPuu Heleakala 87-217 Helelua Street 4 $326,00003-31-2023102%102%31/11,218$2632100No40%2197402-06-202315Average, Fair$75$602$139,200$118,500$257,700124%05 - R-5 Residential DistrictKatherine KeliiLee WangMountainOtherAssigned, Garage
78 FS|OV|MV|CPR1 * 2 * 3View 13Sold 202300981 $195,000$195,000LeewardMailiKahe Kai 87-123 Helelua Street G202 $195,00003-14-2023100%100%21/0665$29310No19%21975202202-06-20238Excellent$45$511$46,400$106,300$152,700128%NanakuliNanakuliNanakuli05 - R-5 Residential DistrictEbonee BarbadilloBryn W KaufmanMountain, Ocean, Sunrise, SunsetOtherAssigned
79 FS|FC|MV|CPR1 * 2 * 3View 24Sold 202222041 $459,000$530,000LeewardMailiHolomoana At Sea Country 87-1972 Pakeke Street N $429,45002-23-202394%81%32/01,158$39600No100%2200610-24-202267Above Average$883$842$323,100$181,300$504,40091%05 - R-5 Residential DistrictNeven L SpraljaJason A RiveraMountainCovered - 2
80 FS|MV|CPR1 * 2 * 3View 19Sold 202221602 $530,000$545,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road 29 $530,00002-01-2023100%97%43/01,500$3532365No83%12012202210-20-202276Above Average$106$602$132,900$328,100$461,000115%MailiWaianaeWaianae05 - R-5 Residential DistrictShannon L KingCourtney DennisonMarina/Canal, Mountain, SunsetOtherAssigned, Guest
107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
81 LH|MV1 * 2 * 3View 10Sold 202213451 $149,000$170,000LeewardMailiN-A 87-204 Helelua Street 2 $139,00001-10-202393%82%41/11,302$11420No41%1197407-13-2022147Average$70$571$138,200$92,600$230,80065%NanakuliNanakuliNanakuli05 - R-5 Residential DistrictTravis C PalmerGeraldine C SupapoMountainOtherAssigned, Open - 2
82 LH1 * 2 * 3View 16Sold 202220639 $150,000$150,000LeewardMailiPuu Heleakala 87-2143 Helelua Place 4 $141,00001-10-202394%94%31/01,131$13320No41%21974202009-30-202268Above Average$40$549$150,100$68,100$218,20069%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictTravis C PalmerGeraldine C SupapoGardenOtherAssigned, Open - 2, Street
83 FS|MV|CPR1 * 2 * 3View 25Sold 202224873 $179,000$179,000LeewardMailiKahe Kai 87-131 Helelua Street J305 $190,00001-06-2023106%106%21/0666$26920No14%31975202212-09-20222Excellent, Above Average$37$486$43,900$105,900$149,800119%05 - R-5 Residential DistrictJustin K TaparraNON MLSMountainOtherAssigned, Open - 2
84 FS|OV|CPR1 * 2 * 3View 19Sold 202221859 $185,000$185,000LeewardMailiKahe Kai 87-123 Helelua Street G204 $185,00001-06-2023100%100%21/0666$27820No10%21975202010-22-202210Above Average$38$503$43,900$83,400$127,300145%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictSugie S OgasawaraWalter P Bell IIIOceanAssigned, Open - 2
85 FS1 * 2 * 3View 21Sold 202224048 $265,000$265,000LeewardMailiPuu Heleakala 87-141 Helelua Street 8 $276,00001-05-2023104%104%31/01,131$23420No41%11974202211-11-20224Excellent$61$528$141,200$68,000$209,200127%05 - R-5 Residential DistrictEbonee BarbadilloKimberly A FutrellNone, Sunrise, SunsetOtherAssigned, Open - 2, Street
86 FS|OV|CPR|OF|BF1 * 2 * 3View 19Sold 202214145 $468,500$495,000LeewardMailiMaili Cove 87-561 Farrington Highway 109 $460,00012-19-202298%93%11/0632$7411112No39%1197508-08-202287Above Average$96$682$131,200$197,700$328,900142%WaianaeWaianaeWaianae05 - R-5 Residential DistrictLex AllenPaz R CateilOceanOcean, Sandy BeachAssigned, Guest
87 FS1 * 2 * 3View 18Sold 202224019 $269,000$269,000LeewardMailiPuu Heleakala 87-200 Helelua Street 6 $250,00012-15-202293%93%31/11,176$22920No22%1197411-10-20229Fair$63$528$138,400$78,200$216,600124%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictRolanda S RacomaAshley ZhuNoneAssigned, Open - 2
88 FS1 * 2 * 3View 18Sold 202220400 $329,000$329,000LeewardMailiPuu Heleakala 87-2146 Helelua Place 4 $318,00012-14-202297%97%41/11,302$25320No41%11974202210-23-202229Above Average$72$579$140,600$92,700$233,300141%05 - R-5 Residential DistrictKatherine KeliiDaniel R KaslowNoneOtherAssigned
89 FS1 * 2 * 3View 1Sold 202212185 $180,000$180,000LeewardMailiPuu Heleakala 87-182 Helelua Street 1 $160,00012-12-202289%89%31/01,131$15920No41%1197406-24-202285Needs Major Repair$60$547$141,400$68,000$209,40086%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictPeter P MoixPeter P MoixNoneOtherAssigned, Open - 2
90 FS1 * 2 * 3View 1Sold 202220634 $205,000$205,000LeewardMailiPuu Heleakala 87-186 Helelua Street 2 $170,00012-12-202283%83%31/01,131$18120No40%1197410-01-202229Needs Major Repair$61$559$140,900$68,000$208,90098%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictPeter P MoixPeter P MoixNoneOtherOpen - 2
107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
91 FS|CPR1 * 2 * 3View 1Sold 202220215 $305,000$305,000LeewardMailiGarden Groves 87-1550 Farrington Highway D6 $310,00012-06-2022102%102%32/01,100$27720No40%1197509-25-202210Average$60$475$130,400$107,600$238,000128%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictPeter P MoixSteven TiralongoNoneAssigned, Guest, Open - 2
92 FS|OV|MV|CPR1 * 2 * 3View 10Sold 202220519 $185,000$160,000LeewardMailiKahe Kai 87-119 Helelua Street F204 $180,00011-22-202297%113%21/0666$27820No10%21975201909-30-20224Above Average$40$503$43,900$106,600$150,500123%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictTravis C PalmerJoe Extra OrdinarioMountain, Ocean, SunsetOtherAssigned, Open - 2
93 FS|CPR1 * 2 * 3View 20Sold 202219905 $339,000$339,000LeewardMailiGarden Groves 87-1550 Farrington Highway F3 $345,00011-10-2022102%102%32/01,100$30820No28%21975202209-21-20229Excellent, Above Average$60$475$130,400$107,600$238,000142%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictLily K H OchocoTony KawaguchiNoneAssigned, Guest, Open - 2
94 FS|MV1 * 2 * 3View 21Sold 202210871 $305,000$305,000LeewardMailiPuu Heleakala 87-150 Helelua Street 8 $295,00011-07-202297%97%41/11,302$23420No27%1197406-06-202287Above Average$65$591$139,000$92,600$231,600132%NanakuliNanakuliNanakuli05 - R-5 Residential DistrictGeraldine C SupapoErwin V PaulinoMountainAssigned, Street
95 LH|CPR1 * 2 * 3View 8Sold 202218872 $63,000$63,000LeewardMailiKahe Kai 87-118 Helelua Street B201 $63,00010-31-2022100%100%21/0666$9510No10%21975202209-03-20224Average$42$500$43,900$101,600$145,50043%MailiNanakuli05 - R-5 Residential DistrictFerdinand LucasKawena GrahamNoneAssigned
96 FS1 * 2 * 3View 14Sold 202212907 $309,000$309,000LeewardMailiPuu Heleakala 87-141 Helelua Street 1 $300,00010-31-202297%97%41/11,302$23720No41%21974201807-07-202275Average$71$578$139,500$92,400$231,900133%05 - R-5 Residential DistrictKatherine KeliiKayla A ChangNoneOtherAssigned, Open - 2, Street
97 FS|OV|MV1 * 2 * 3View 20Sold 202219228 $250,000$250,000LeewardMailiPuu Heleakala 87-216 Helelua Street 4 $260,00010-19-2022104%104%31/11,291$19420No25%1197409-09-20224Fair, Needs Major Repair$69$648$137,600$118,500$256,10098%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictLinda Dusty WoodstockLindsey ItamotoMountain, OceanAssigned, Carport, Covered - 2, Street
98 FS|MV1 * 2 * 3View 1Sold 202213303 $280,000$260,000LeewardMailiPuu Heleakala 87-204 Helelua Street 4 $295,00009-12-2022105%113%42/01,302$21520No50%2197407-10-202211Fair$30$545$139,000$92,600$231,600121%05 - R-5 Residential DistrictJamie FualaauCortney NadigMountainAssigned
99 FS|MV1 * 2 * 3View 9Sold 202213648 $299,000$299,000LeewardMailiPuu Heleakala 87-133 Helelua Street 3 $299,00009-12-2022100%100%31/01,131$26420No40%21974202207-16-202212Above Average, Excellent$60$548$145,400$68,000$213,400140%05 - R-5 Residential DistrictKatherine KeliiJessica L HaynesMountainOtherAssigned, Street
100 FS|MV|CPR1 * 2 * 3View 22Sold 202211521 $599,000$599,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road Q38 $599,00009-09-2022100%100%43/01,500$399289No80%12012202206-16-202220Excellent$123$602$132,900$328,100$461,000130%MailiWaianaeWaianae05 - R-5 Residential DistrictJeanie C ChinJohanna LeeGarden, MountainOtherAssigned, Guest, Open - 2
107LegendComparePhotosStatusMLS#PriceOriginal
Price
RegionNeighborhoodBuildingAddressSold
Price
Sold
Date
Sold
Ratio
Orig
Ratio
BedsBathsLiving
Sq Ft
Avg.
Living
Park Lanai Pets Owner
Occup.
FLYearYear
Rem
List DateDaysConditionTaxFeesAssessed
Land
Assessed
Improve
Assessed
Total
Assessed
Ratio
ElementaryJuniorHighZoningSeller`s
Agent
Buyer`s
Agent
ViewFrontageParking
101 FS1 * 2 * 3View 17Sold 202213952 $189,900$189,900LeewardMailiPuu Heleakala 87-153 Helelua Street 2 $235,00009-02-2022124%124%41/11,302$1462235No41%1197407-19-202223Needs Major Repair$25$591$139,300$102,100$241,40079%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictRonald M OkuboLauren K AkanaNoneOtherOpen - 2
102 FS|CPR1 * 2 * 3View 16Sold 202213845 $499,000$499,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road D11 $499,00008-31-2022100%100%32/11,222$408389No83%1201207-19-202217Above Average$75$490$108,200$281,700$289,900172%WaianaeWaianaeWaianae05 - R-5 Residential DistrictThomas F RiveraSamantha BerganNoneOtherAssigned, Guest, Open - 3+
103 FS|CPR1 * 2 * 3View 1Sold 202211133 $320,000$320,000LeewardMailiGarden Groves 87-1550 Farrington Highway H1 $305,00008-08-202295%95%32/01,100$29120No40%11975202206-10-202211Above Average$60$475$130,400$107,600$238,000134%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictPeter P MoixKepo'o NoaNoneOtherAssigned, Open - 2
104 FS|CPR1 * 2 * 3View 24Sold 202210878 $590,000$590,000LeewardMailiMaili Beach Place 87-176 Maipalaoa Road P36 $600,00007-21-2022102%102%43/01,500$393389No80%1201206-08-202210Above Average$107$602$132,900$333,100$466,000127%MailiWaianaeWaianae05 - R-5 Residential DistrictMichael D DeMelloMichelle M IchikawaGardenOtherGuest, Open - 3+, Street
105 FS|OV|CPR1 * 2 * 3View 7Sold 202210401 $290,000$290,000LeewardMailiGarden Groves 87-1550 Farrington Highway A3 $310,00007-15-2022107%107%32/01,100$26420No39%11975201006-01-20227Above Average$60$475$130,400$107,600$238,000122%NanakuliNanakuliNanakuli05 - R-5 Residential DistrictShelly M FreitasTony KawaguchiOceanOtherAssigned, Open - 2
106 FS1 * 2 * 3View 1Sold 202209192 $295,000$295,000LeewardMailiPuu Heleakala 87-149 Helelua Street 4 $278,00007-08-202294%94%41/11,302$22720No0%2197405-12-202212Above Average$64$591$129,000$91,900$220,900134%NanaikaponoNanakuliNanakuli05 - R-5 Residential DistrictSylvia E FosterJohn FortunoNoneAssigned, Open - 2
107 FS|OV|MV|CPR1 * 2 * 3View 25Sold 202204730 $580,000$580,000LeewardMailiHolomoana At Sea Country 87-1000 Kahiwelola Street 90 $620,00006-30-2022107%107%32/01,312$442224No75%1200605-04-20226Excellent$130$543$384,500$211,200$575,700101%MailiWaianaeWaianae52 - AG-2 General AgriculturalDeborah L ArguelloJoe Extra OrdinarioMountain, OceanOtherAssigned, Guest, Open - 2

Remember to add this search to your browser's bookmarks or favorites for easy access later or get a short link to send to via Email.

Google Maps

View these results on Google Maps

View these results in Photo View

View guide to what the different colors mean.

This page is printer-friendly.

PropertyType='Condo/Townhouse' AND (Neighbourhood LIKE "MAILI%") AND ListingContractDate >= '2022-05-04'