The office will be closed on Friday, July 4th, in observance of Independence Day and will re-open on Monday.
Listing Overview
Price: $799,000
Area: EWA GEN LAULANI-TIDES
Status: Active
Discover this beautifully upgraded 4-bedroom, 2.5-bath single-family corner-end home listed at $799,000! Enjoy privacy and open views. The kitchen and bathrooms were tastefully remodeled in 2023. Eco-friendly features include 2 new Tesla Powerwall-2 battery storage, 20 leased PV panels, and a solar water heater. A spacious 2-car garage adds convenience. Located in a desirable neighborhood with a swimming pool and BBQ area. The maintenance fee covers water, sewer, and common area upkeep. Move-in ready and in great condition—this home is a must-see! A few photos have been virtually staged(enhanced). Listing by: BHGRE Advantage Realty (808) 738-3600
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202515080"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "91-1001"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Keaunui"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(2) "97"
}
["City"]=>
array(1) {
[0]=>
string(9) "Ewa Beach"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96706"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://listings.hetproductions.com/sites/zevbbng/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "799000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(21) "EWA GEN LAULANI-TIDES"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(607) "Discover this beautifully upgraded 4-bedroom, 2.5-bath single-family corner-end home listed at $799,000! Enjoy privacy and open views. The kitchen and bathrooms were tastefully remodeled in 2023. Eco-friendly features include 2 new Tesla Powerwall-2 battery storage, 20 leased PV panels, and a solar water heater. A spacious 2-car garage adds convenience. Located in a desirable neighborhood with a swimming pool and BBQ area. The maintenance fee covers water, sewer, and common area upkeep. Move-in ready and in great condition—this home is a must-see! A few photos have been virtually staged(enhanced)."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "2958.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1372"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2010"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "407.79"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "KrisztinaK@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Krisztina Kollo"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18837636"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-06-30T18:26:08.327"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-06-30"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(8) "Ewaplain"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "18:26:08.327"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27051270"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27051270"
[1]=>
string(8) "27051271"
[2]=>
string(8) "27051272"
[3]=>
string(8) "27051273"
[4]=>
string(8) "27051274"
[5]=>
string(8) "27051275"
[6]=>
string(8) "27051276"
[7]=>
string(8) "27051277"
[8]=>
string(8) "27051278"
[9]=>
string(8) "27051279"
[10]=>
string(8) "27051280"
[11]=>
string(8) "27051281"
[12]=>
string(8) "27051282"
[13]=>
string(8) "27051283"
[14]=>
string(8) "27051284"
[15]=>
string(8) "27051285"
[16]=>
string(8) "27051286"
[17]=>
string(8) "27051287"
[18]=>
string(8) "27051288"
[19]=>
string(8) "27051289"
[20]=>
string(8) "27051290"
[21]=>
string(8) "27051291"
[22]=>
string(8) "27051292"
[23]=>
string(8) "27051293"
[24]=>
string(8) "27051294"
[25]=>
string(8) "27051295"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202515080
)
[StreetNumber] => Array
(
[0] => 91-1001
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Keaunui
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] => 97
)
[City] => Array
(
[0] => Ewa Beach
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96706
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/zevbbng/unbranded
)
[ListPrice] => Array
(
[0] => 799000.00
)
[Neighbourhood] => Array
(
[0] => EWA GEN LAULANI-TIDES
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover this beautifully upgraded 4-bedroom, 2.5-bath single-family corner-end home listed at $799,000! Enjoy privacy and open views. The kitchen and bathrooms were tastefully remodeled in 2023. Eco-friendly features include 2 new Tesla Powerwall-2 battery storage, 20 leased PV panels, and a solar water heater. A spacious 2-car garage adds convenience. Located in a desirable neighborhood with a swimming pool and BBQ area. The maintenance fee covers water, sewer, and common area upkeep. Move-in ready and in great condition—this home is a must-see! A few photos have been virtually staged(enhanced).
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 2958.00
)
[SqftTotal] => Array
(
[0] => 1372
)
[YearBuilt] => Array
(
[0] => 2010
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 407.79
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => KrisztinaK@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3600
)
[ListAgentFullName] => Array
(
[0] => Krisztina Kollo
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18837636
)
[MatrixModifiedDT] => Array
(
[0] => 2025-06-30T18:26:08.327
)
[ListingContractDate] => Array
(
[0] => 2025-06-30
)
[MLSAreaMajor] => Array
(
[0] => Ewaplain
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 18:26:08.327
)
[_thumbnail_id] => Array
(
[0] => 27051270
)
[listing_image] => Array
(
[0] => 27051270
[1] => 27051271
[2] => 27051272
[3] => 27051273
[4] => 27051274
[5] => 27051275
[6] => 27051276
[7] => 27051277
[8] => 27051278
[9] => 27051279
[10] => 27051280
[11] => 27051281
[12] => 27051282
[13] => 27051283
[14] => 27051284
[15] => 27051285
[16] => 27051286
[17] => 27051287
[18] => 27051288
[19] => 27051289
[20] => 27051290
[21] => 27051291
[22] => 27051292
[23] => 27051293
[24] => 27051294
[25] => 27051295
)
)
BedsTotal: 4
Full Baths: 2
Half Baths: 1
Land Area (sf): 2,958 sf
Living (sf): 1,372
Year Built: 2010
Property Condition: Excellent
Number of Parking Spaces: 2
View: Mountain
Listing Office: BHGRE Advantage Realty
Maintenance Fees: $408
Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on June 30, 2025 - 6:26 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
© Marcus Realty. All Rights Reserved.