If you know the Neighborhoods enter them below. To select Neighborhoods by Region click on a Region below.
A wildcard is inserted at the end. For example entering Ewa Gen finds all neighborhoods starting with Ewa Gen.
Central,
Diamond Head,
Ewa Plain,
Hawaii Kai,
Kailua,
Kaneohe,
Leeward,
Makakilo,
Metro,
North Shore,
Pearl City,
Waipahu
Type the first 1 to 3 letters of the Neighborhood and a drop down list will appear showing you the Neighborhoods.
Help video on searching by Neighborhood
No results found. Please see the top of the page and adjust your search criteria.
Schools
Type the first 1 to 3 letters of the School Name and a drop down list will appear showing you the School Names.
No results found. Please see the top of the page and adjust your search criteria.
MLS Number and Parcel Number
The Sold Filter Restricts Results to Sold Properties
No results found. Please see the top of the page and adjust your search criteria.
35 | | Legend | Compare | Photos | Status | MLS# | Price | Original
Price | Region | Neighborhood | Address | Sold
Price | Sold
Date | Sold
Ratio | Orig
Ratio | Beds | Baths | Land
Sq Ft | Avg.
Land | Living
Sq Ft | Avg.
Living | Year | Year
Rem | List Date | Days | Condition | Tax | Fees | Assessed
Land | Assessed
Improve | Assessed
Total | Assessed
Ratio | Elementary | Junior | High | Zoning | Seller`s Agent | Buyer`s Agent | View | Frontage | Pool | Parking |
1 |
|
FS | 1 * 2 * 3 | View 25 | Active | 202401264 |
$965,000 | $965,000 | Ewa Plain | Ocean Pointe | 91-1020 Kaileonui Street |
| 3 | 2/1 | 4,200 | $230 | 1,551 | $622 | 2001 | 2021 | 01-30-2024 | 80 | Excellent | $266 | $116 | $641,700 | $269,100 | $965,000 | 100% | Keoneula | Ewa Makai | Campbell | 05 - R-5 Residential District | | | None | Other | None | 2 Car, Garage | | | |
2 |
|
FS|FC | 1 * 2 * 3 | View 7 | Expired | 202303195 |
$909,900 | $914,900 | Ewa Plain | Ocean Pointe | 91-1015 Kaikauhaa Street |
| 3 | 2/1 | 4,200 | $217 | 1,442 | $631 | 2000 | | 02-24-2023 | 103 | Average | $200 | $104 | $577,500 | $305,800 | $883,300 | 103% | Keoneula | Ewa Makai | Campbell | 05 - R-5 Residential District | | | None | Other | None | 2 Car, Garage | | | |
3 |
|
FS | 1 * 2 * 3 | View 25 | Expired | 202310091 |
$910,000 | $920,000 | Ewa Plain | Ocean Pointe | 91-6417 Kapolei Parkway |
| 3 | 2/1 | 3,852 | $236 | 1,380 | $659 | 2004 | | 05-03-2023 | 38 | Excellent | $212 | $118 | $678,600 | $261,900 | $940,500 | 97% | | | | 11 - A-1 Low Density Apartment | | | None | | None | 3 Car+, Garage, Street | | | |
4 |
|
FS | 1 * 2 * 3 | View 1 | Sold | 202309739 |
$918,000 | $920,000 | Ewa Plain | Ocean Pointe | 91-6421 Kapolei Parkway |
$882,000 | 04-16-2024 | 96% | 96% | 3 | 2/1 | 3,853 | $238 | 1,380 | $665 | 2004 | | 04-28-2023 | 151 | Above Average | $225 | $117 | $678,700 | $256,800 | $935,500 | 98% | | | | 11 - A-1 Low Density Apartment | Stephanie Rae Band | Stacy L Paris | None | Other | None | 2 Car, Garage |
5 |
|
FS | 1 * 2 * 3 | View 1 | Sold | 202403053 |
$935,000 | $935,000 | Ewa Plain | Ocean Pointe | 91-6431 Kapolei Parkway |
$937,000 | 04-15-2024 | 100% | 100% | 3 | 2/1 | 3,855 | $243 | 1,449 | $645 | 2004 | 2018 | 02-06-2024 | 36 | Above Average, Average | $248 | $133 | $678,800 | $270,900 | $949,700 | 98% | Keoneula | Ewa Makai | Campbell | 11 - A-1 Low Density Apartment | Bonnie Walker | Desmond G Cura | None | | None | 3 Car+, Garage |
6 |
|
FS|FC | 1 * 2 * 3 | View 1 | Sold | 202400638 |
$819,900 | $909,900 | Ewa Plain | Ocean Pointe | 91-1015 Kaikauhaa Street |
$761,250 | 04-12-2024 | 93% | 84% | 3 | 2/1 | 4,200 | $195 | 1,442 | $569 | 2000 | | 01-10-2024 | 25 | Average | $200 | $104 | $688,000 | $267,800 | $955,800 | 86% | Keoneula | Ewa Makai | Campbell | 05 - R-5 Residential District | Justin T Morikawa | Jeffrey N Samuels | None | Other | None | 2 Car, Garage |
7 |
|
FS|SU | 1 * 2 * 3 | View 1 | Sold | 202321892 |
$960,000 | $999,000 | Ewa Plain | Ocean Pointe | 91-1134 Kaiee Street |
$960,000 | 04-12-2024 | 100% | 96% | 3 | 2/1 | 4,320 | $222 | 1,543 | $622 | 2008 | | 10-06-2023 | 117 | Above Average | $272 | $118 | $693,600 | $340,200 | $1,033,800 | 93% | | | | 11 - A-1 Low Density Apartment | Veronica Munez | Adrienne W Lally | None | Other | None | 2 Car, Garage, Street |
8 |
|
FS | 1 * 2 * 3 | View 1 | Sold | 202401487 |
$1,050,000 | $1,050,000 | Ewa Plain | Ocean Pointe | 91-1073 Kaiko Street |
$985,000 | 04-11-2024 | 94% | 94% | 3 | 3/0 | 4,350 | $241 | 1,719 | $611 | 2003 | | 01-13-2024 | 20 | Above Average | $377 | $0 | $695,000 | $351,100 | $1,046,100 | 100% | Keoneula | Ewa Makai | Campbell | 05 - R-5 Residential District | Lucien Breault Jr. | Dillon E Chang | None | | None | 2 Car, Garage, Street |
9 |
|
FS | 1 * 2 * 3 | View 1 | Sold | 202400853 |
$912,000 | $912,000 | Ewa Plain | Ocean Pointe | 91-1023 Kaihi Street |
$900,000 | 04-03-2024 | 99% | 99% | 3 | 2/1 | 3,859 | $236 | 1,288 | $708 | 2004 | | 01-15-2024 | 30 | Excellent, Above Average | $209 | $133 | $672,000 | $243,100 | $915,100 | 100% | | | | 11 - A-1 Low Density Apartment | Bonnie Walker | Lisa Harding | Sunrise, Sunset | | None | 2 Car, Garage |
10 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202327924 |
$875,650 | $875,650 | Ewa Plain | Ocean Pointe | 91-1098 Kaileolea Drive |
$875,650 | 03-27-2024 | 100% | 100% | 3 | 2/1 | 3,876 | $226 | 1,380 | $635 | 2003 | | 12-14-2023 | 57 | Excellent | $270 | $133 | $679,800 | $245,800 | $925,600 | 95% | | | | 05 - R-5 Residential District | Ashley Zhu | Adrienne W Lally | None | | None | 2 Car, Garage, Street |
35 | | Legend | Compare | Photos | Status | MLS# | Price | Original
Price | Region | Neighborhood | Address | Sold
Price | Sold
Date | Sold
Ratio | Orig
Ratio | Beds | Baths | Land
Sq Ft | Avg.
Land | Living
Sq Ft | Avg.
Living | Year | Year
Rem | List Date | Days | Condition | Tax | Fees | Assessed
Land | Assessed
Improve | Assessed
Total | Assessed
Ratio | Elementary | Junior | High | Zoning | Seller`s Agent | Buyer`s Agent | View | Frontage | Pool | Parking |
11 |
|
FS|FC | 1 * 2 * 3 | View 25 | Sold | 202325096 |
$799,000 | $820,000 | Ewa Plain | Ocean Pointe | 91-1054 Kaipu Street |
$780,000 | 03-18-2024 | 98% | 95% | 3 | 2/1 | 4,579 | $174 | 1,442 | $554 | 1999 | | 12-05-2023 | 73 | Average | $277 | $118 | $705,700 | $242,300 | $948,000 | 84% | | | | 05 - R-5 Residential District | Adrienne W Lally | Isaiah Cureton | None | | None | 2 Car |
12 |
|
FS | 1 * 2 * 3 | View 1 | Sold | 202328304 |
$930,000 | $930,000 | Ewa Plain | Ocean Pointe | 91-1027 Kaiko Street |
$950,000 | 02-05-2024 | 102% | 102% | 3 | 2/1 | 3,842 | $242 | 1,449 | $642 | 2004 | 2021 | 12-21-2023 | 2 | Excellent | $262 | $117 | $678,200 | $266,100 | $944,300 | 98% | Keoneula | Ewa Makai | Campbell | 05 - R-5 Residential District | Courtney L Williams | Tina Marie Garcia | None | | None | Garage |
13 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202322378 |
$900,000 | $900,000 | Ewa Plain | Ocean Pointe | 91-1167 Kaimalie Street |
$901,500 | 12-13-2023 | 100% | 100% | 3 | 2/1 | 3,850 | $234 | 1,449 | $621 | 2006 | | 10-06-2023 | 17 | Above Average | $250 | $118 | $678,500 | $279,300 | $957,800 | 94% | | | | 05 - R-5 Residential District | Erica Yoon | Daria Andreev | None | | None | 2 Car |
14 |
|
FS|FC | 1 * 2 * 3 | View 22 | Sold | 202314174 |
$864,900 | $950,000 | Ewa Plain | Ocean Pointe | 91-1043 Kekaiholo Street |
$850,000 | 12-04-2023 | 98% | 89% | 3 | 2/1 | 4,137 | $209 | 1,543 | $561 | 2004 | | 06-21-2023 | 131 | Average | $264 | $117 | $685,100 | $296,000 | $981,100 | 88% | Keoneula | Ewa Makai | Campbell | 05 - R-5 Residential District | Jack M Legal | Shannon TKS Feliciano Jr. | None | | None | 2 Car, Garage |
15 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202310530 |
$875,000 | $915,000 | Ewa Plain | Ocean Pointe | 91-1146 Kai Kukuma Street |
$890,000 | 11-09-2023 | 102% | 97% | 3 | 2/1 | 3,906 | $224 | 1,442 | $607 | 2008 | | 05-31-2023 | 104 | Above Average | $120 | $118 | $565,900 | $267,400 | $833,300 | 105% | | | | 11 - A-1 Low Density Apartment | Adrienne W Lally | Leian Harosky | None | | None | Garage |
16 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202319044 |
$859,000 | $859,000 | Ewa Plain | Ocean Pointe | 91-1176 Kaiopua Street |
$840,000 | 10-13-2023 | 98% | 98% | 3 | 2/1 | 3,528 | $243 | 1,364 | $630 | 2001 | | 08-10-2023 | 13 | Above Average | $193 | $106 | $663,300 | $258,600 | $921,900 | 93% | | | | 05 - R-5 Residential District | Dennis L Noah-Casison | Michelle Moore | None | Other | None | 2 Car, Garage, Street |
17 |
|
FS | 1 * 2 * 3 | View 14 | Sold | 202317277 |
$898,000 | $898,000 | Ewa Plain | Ocean Pointe | 91-1044 Kaikane Street |
$880,000 | 09-28-2023 | 98% | 98% | 3 | 2/0 | 4,361 | $206 | 1,287 | $698 | 2003 | | 07-27-2023 | 41 | Excellent | $270 | $118 | $695,500 | $231,200 | $926,700 | 97% | | | | 11 - A-1 Low Density Apartment | James Son | Anthony James Cox | None | | None | 2 Car, Garage |
18 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202319083 |
$849,000 | $849,000 | Ewa Plain | Ocean Pointe | 91-1179 Kaiopua Street |
$828,888 | 09-25-2023 | 98% | 98% | 3 | 2/1 | 3,533 | $240 | 1,400 | $606 | 2001 | | 08-09-2023 | 12 | Average | $251 | $104 | $557,000 | $302,800 | $859,800 | 99% | | | | 05 - R-5 Residential District | Ronald N Lee | Kelly Lee | Other | | None | 2 Car, Garage |
19 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202313526 |
$884,000 | $899,000 | Ewa Plain | Ocean Pointe | 91-6417 Kapolei Parkway |
$900,000 | 08-21-2023 | 102% | 100% | 3 | 2/1 | 3,852 | $229 | 1,380 | $641 | 2004 | | 06-11-2023 | 29 | Excellent | $212 | $118 | $678,600 | $261,900 | $940,500 | 94% | | | | 11 - A-1 Low Density Apartment | Koa Cassady | Grant M Jeffries | None | | None | 3 Car+, Garage, Street |
20 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202310426 |
$935,000 | $960,000 | Ewa Plain | Ocean Pointe | 91-1036 Kai Kukuma Street |
$937,000 | 08-17-2023 | 100% | 98% | 3 | 2/1 | 4,283 | $218 | 1,449 | $645 | 2005 | 2022 | 05-09-2023 | 73 | Excellent | $262 | $118 | $580,800 | $318,200 | $899,000 | 104% | | | | 11 - A-1 Low Density Apartment | Tiare K Kabazawa | Kina Knisley | None | Other | None | 2 Car, Garage, Street |
35 | | Legend | Compare | Photos | Status | MLS# | Price | Original
Price | Region | Neighborhood | Address | Sold
Price | Sold
Date | Sold
Ratio | Orig
Ratio | Beds | Baths | Land
Sq Ft | Avg.
Land | Living
Sq Ft | Avg.
Living | Year | Year
Rem | List Date | Days | Condition | Tax | Fees | Assessed
Land | Assessed
Improve | Assessed
Total | Assessed
Ratio | Elementary | Junior | High | Zoning | Seller`s Agent | Buyer`s Agent | View | Frontage | Pool | Parking |
21 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202310101 |
$1,149,000 | $1,149,000 | Ewa Plain | Ocean Pointe | 91-1008 Kaiohee Street |
$1,139,000 | 08-09-2023 | 99% | 99% | 3 | 2/1 | 5,978 | $192 | 1,759 | $653 | 2002 | | 05-10-2023 | 8 | Excellent, Above Average | $240 | $106 | $715,600 | $374,300 | $989,900 | 116% | Keoneula | Ewa Makai | Campbell | 05 - R-5 Residential District | Veronica Munez | Melanie Meinken | None | | In Ground, Spa/HotTub, Pool on Property | 2 Car, Garage, Street |
22 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202311668 |
$930,000 | $930,000 | Ewa Plain | Ocean Pointe | 91-1038 Kaiikuwa Street |
$960,000 | 08-07-2023 | 103% | 103% | 3 | 2/1 | 4,392 | $212 | 1,442 | $645 | 2001 | | 05-31-2023 | 4 | Above Average | $232 | $106 | $585,000 | $308,700 | $893,700 | 104% | Keoneula | Ewa Makai | Campbell | 05 - R-5 Residential District | Carri L Pothier | Kevin K Pedersen | None | | None | 2 Car |
23 |
|
FS|FC | 1 * 2 * 3 | View 24 | Sold | 202310503 |
$879,900 | $879,900 | Ewa Plain | Ocean Pointe | 91-1080 Kaileolea Drive |
$815,000 | 07-21-2023 | 93% | 93% | 3 | 2/1 | 3,876 | $227 | 1,380 | $638 | 2003 | 2023 | 05-09-2023 | 36 | Above Average | $252 | $57 | $564,800 | $300,700 | $865,500 | 102% | Keoneula | Ewa Makai | Campbell | 05 - R-5 Residential District | Justin T Morikawa | Noble L Tacras | None | | None | 2 Car, Garage |
24 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202311040 |
$910,500 | $910,500 | Ewa Plain | Ocean Pointe | 91-1049 Kaihi Street |
$925,000 | 07-14-2023 | 102% | 102% | 3 | 2/1 | 3,942 | $231 | 1,449 | $628 | 2004 | 2022 | 05-19-2023 | 6 | Above Average | $228 | $118 | $675,900 | $273,300 | $949,200 | 96% | | | | 11 - A-1 Low Density Apartment | Rhibecca Martin | Dustin L Cronhardt | None | | None | 1 Car, Garage, Street |
25 |
|
FS | 1 * 2 * 3 | View 20 | Sold | 202308940 |
$895,000 | $880,000 | Ewa Plain | Ocean Pointe | 91-1214 Kaiopua Street |
$890,000 | 07-10-2023 | 99% | 101% | 3 | 2/1 | 3,812 | $235 | 1,468 | $610 | 2001 | | 04-12-2023 | 18 | Excellent | $226 | $109 | $562,300 | $310,900 | $873,200 | 102% | Keoneula | Ewa Makai | Campbell | 05 - R-5 Residential District | Marlon J Martell | Ashley K Payne | Other | Other | None | 2 Car, Garage, Street |
26 |
|
FS | 1 * 2 * 3 | View 12 | Sold | 202225296 |
$799,000 | $900,000 | Ewa Plain | Ocean Pointe | 91-1182 Kaiopua Street |
$805,000 | 07-06-2023 | 101% | 89% | 3 | 2/1 | 3,802 | $210 | 1,364 | $586 | 2001 | | 12-06-2022 | 92 | Above Average | $250 | $0 | $561,900 | $293,700 | $855,600 | 93% | | | | 05 - R-5 Residential District | Cameron J Higgins | Shari M Hooks | None | | None | 3 Car+, Garage, Street |
27 |
|
FS | 1 * 2 * 3 | View 24 | Sold | 202309040 |
$897,000 | $910,000 | Ewa Plain | Ocean Pointe | 91-1073 Kaiopua Street |
$912,000 | 07-03-2023 | 102% | 100% | 3 | 2/1 | 4,865 | $184 | 1,442 | $622 | 1999 | | 04-14-2023 | 49 | Above Average | $284 | $107 | $609,800 | $292,800 | $902,600 | 99% | | | | 05 - R-5 Residential District | Matthew FG Wong | Tracey Anne Stott Kelley | None | | None | 2 Car, Garage, Street |
28 |
|
FS | 1 * 2 * 3 | View 18 | Sold | 202310011 |
$865,000 | $895,000 | Ewa Plain | Ocean Pointe | 91-1315 Kaileolea Drive |
$870,000 | 06-23-2023 | 101% | 97% | 3 | 2/1 | 3,754 | $230 | 1,492 | $580 | 2008 | | 05-01-2023 | 32 | Excellent, Above Average, Average | $240 | $118 | $629,100 | $351,600 | $980,700 | 88% | | | | 11 - A-1 Low Density Apartment | Jennifer Melchor Sison | Jarrod Dennison | None | | None | 2 Car, Garage |
29 |
|
FS | 1 * 2 * 3 | View 24 | Sold | 202309330 |
$888,888 | $888,888 | Ewa Plain | Ocean Pointe | 91-1029 Kaiikuwa Street |
$870,000 | 06-08-2023 | 98% | 98% | 3 | 2/0 | 4,200 | $212 | 1,275 | $697 | 2001 | | 04-19-2023 | 13 | Excellent | $235 | $106 | $688,000 | $217,500 | $905,500 | 98% | Keoneula | Ilima | Campbell | 05 - R-5 Residential District | Bryn W Kaufman | Carolina Cristancho | Other | | None | 2 Car, Garage, Street |
30 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202303312 |
$890,000 | $900,000 | Ewa Plain | Ocean Pointe | 91-6505 Kapolei Parkway |
$865,000 | 06-08-2023 | 97% | 96% | 3 | 2/1 | 3,870 | $230 | 1,449 | $614 | 2004 | | 03-01-2023 | 46 | Excellent, Above Average | $256 | $117 | $564,500 | $313,800 | $878,300 | 101% | Ho'okele | Kapolei | Kapolei | 05 - R-5 Residential District | Michael D DeMello | Angela Rezentes | None | Other | None | 3 Car+, Garage |
35 | | Legend | Compare | Photos | Status | MLS# | Price | Original
Price | Region | Neighborhood | Address | Sold
Price | Sold
Date | Sold
Ratio | Orig
Ratio | Beds | Baths | Land
Sq Ft | Avg.
Land | Living
Sq Ft | Avg.
Living | Year | Year
Rem | List Date | Days | Condition | Tax | Fees | Assessed
Land | Assessed
Improve | Assessed
Total | Assessed
Ratio | Elementary | Junior | High | Zoning | Seller`s Agent | Buyer`s Agent | View | Frontage | Pool | Parking |
31 |
|
FS | 1 * 2 * 3 | View 23 | Sold | 202307156 |
$910,000 | $915,000 | Ewa Plain | Ocean Pointe | 91-6425 Kapolei Parkway |
$895,000 | 05-31-2023 | 98% | 98% | 3 | 2/1 | 3,854 | $236 | 1,449 | $628 | 2004 | 2020 | 03-30-2023 | 25 | Excellent | $172 | $117 | $569,700 | $313,800 | $883,500 | 103% | | | | 11 - A-1 Low Density Apartment | Stephanie Rae Band | Margarita Margo Munden | None | | None | 2 Car, Garage |
32 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202224561 |
$875,000 | $875,000 | Ewa Plain | Ocean Pointe | 91-1168 Kaimalie Street |
$885,000 | 05-24-2023 | 101% | 101% | 3 | 2/0 | 4,405 | $199 | 1,275 | $686 | 2001 | 2022 | 12-07-2022 | 147 | Excellent, Above Average | $275 | $109 | $585,500 | $208,700 | $794,200 | 110% | Ewa Beach | Ewa Makai | Campbell | 05 - R-5 Residential District | David M Lundstrom | Ernie Pesebre | None | Other | None | 2 Car, Street |
33 |
|
FS | 1 * 2 * 3 | View 16 | Sold | 202306832 |
$879,000 | $879,000 | Ewa Plain | Ocean Pointe | 91-1136 Kaiopua Street |
$850,000 | 05-10-2023 | 97% | 97% | 3 | 2/0 | 4,200 | $209 | 1,275 | $689 | 2002 | | 03-25-2023 | 15 | Excellent | $209 | $106 | $688,000 | $227,400 | $915,400 | 96% | | | | 05 - R-5 Residential District | Nathalie C Mullinix | Kina Knisley | Other | | None | 2 Car, Garage |
34 |
|
FS | 1 * 2 * 3 | View 20 | Sold | 202300631 |
$915,000 | $915,000 | Ewa Plain | Ocean Pointe | 91-6611 Kapolei Parkway |
$900,000 | 05-10-2023 | 98% | 98% | 3 | 2/1 | 3,712 | $246 | 1,510 | $606 | 2006 | 2019 | 01-17-2023 | 42 | Excellent, Above Average | $278 | $109 | $633,700 | $316,200 | $949,900 | 96% | | | | 05 - R-5 Residential District | Deep Shrestha | Courtney L Williams | None | | None | 2 Car, Garage |
35 |
|
FS | 1 * 2 * 3 | View 25 | Sold | 202300052 |
$870,000 | $915,000 | Ewa Plain | Ocean Pointe | 91-6494 Kapolei Parkway |
$870,000 | 04-21-2023 | 100% | 95% | 3 | 2/1 | 3,843 | $226 | 1,288 | $675 | 2003 | 2022 | 01-04-2023 | 78 | Excellent, Above Average | $241 | $109 | $671,300 | $249,300 | $920,600 | 95% | | | | 05 - R-5 Residential District | Tina Marie Garcia | Brittany E Hampton | None | | None | 2 Car, Garage |
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.
This page is printer-friendly.
PropertyType='Single Family' AND Status IN ('Active','Pending','Sold','Expired') AND (Neighbourhood LIKE "OCEAN POINTE%") AND BedsTotal>=3 AND BedsTotal<=3 AND ListingContractDate >= '2022-04-19' AND (CloseDate >="2023-04-19" OR CloseDate <="2000-01-01")