Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
Listing
Price: $1,800,000Area: HAWAII LOA RIDGEStatus: Active
AMAZING OPPORTUNITY to build your DREAM HOME on the prestigious Hawaii Loa Ridge. This rare rim lot features panoramic views of the Ko’olau Mountain Range, Koko Head, and the ocean. In addition, this lot has ideal topography for a builder to develop on. Hawaii Loa Ridge is a premier gated community, with 24/7 security, private park, tennis courts, club house, BBQ areas and open air pavilions!!! Listing by: BHGRE Advantage Realty (808) 738-3600
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202319075"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "804"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Moaniala"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96821"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://listings.hetproductions.com/sites/yzlpkgz/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1800000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1800000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "HAWAII LOA RIDGE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(402) "AMAZING OPPORTUNITY to build your DREAM HOME on the prestigious Hawaii Loa Ridge. This rare rim lot features panoramic views of the Ko’olau Mountain Range, Koko Head, and the ocean. In addition, this lot has ideal topography for a builder to develop on. Hawaii Loa Ridge is a premier gated community, with 24/7 security, private park, tennis courts, club house, BBQ areas and open air pavilions!!!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "9906.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["YearBuilt"]=>
array(1) {
[0]=>
string(0) ""
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(0) ""
}
["ParkingTotal"]=>
array(1) {
[0]=>
NULL
}
["StoriesType"]=>
array(1) {
[0]=>
NULL
}
["View"]=>
array(1) {
[0]=>
string(22) "Mountain,Ocean,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(10) "Aina Haina"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "BrettA@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Brett K Aka"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-06T22:15:06.793"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17496533"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-08-09T17:08:01.473"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Preservation"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25911442"
}
["listing_image"]=>
array(16) {
[0]=>
string(8) "25911442"
[1]=>
string(8) "25911443"
[2]=>
string(8) "25911444"
[3]=>
string(8) "25911445"
[4]=>
string(8) "25911446"
[5]=>
string(8) "25911447"
[6]=>
string(8) "25911448"
[7]=>
string(8) "25911449"
[8]=>
string(8) "25911450"
[9]=>
string(8) "25911451"
[10]=>
string(8) "25911452"
[11]=>
string(8) "25911453"
[12]=>
string(8) "25911454"
[13]=>
string(8) "25911455"
[14]=>
string(8) "25911456"
[15]=>
string(8) "25911457"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "22:15:06.793"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202319075
)
[StreetNumber] => Array
(
[0] => 804
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Moaniala
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96821
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/yzlpkgz/unbranded
)
[ListPrice] => Array
(
[0] => 1800000.00
)
[CurrentPrice] => Array
(
[0] => 1800000.00
)
[Neighbourhood] => Array
(
[0] => HAWAII LOA RIDGE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => AMAZING OPPORTUNITY to build your DREAM HOME on the prestigious Hawaii Loa Ridge. This rare rim lot features panoramic views of the Ko’olau Mountain Range, Koko Head, and the ocean. In addition, this lot has ideal topography for a builder to develop on. Hawaii Loa Ridge is a premier gated community, with 24/7 security, private park, tennis courts, club house, BBQ areas and open air pavilions!!!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 9906.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Aina Haina
)
[MiddleOrJuniorSchool] => Array
(
[0] => Niu Valley
)
[HighSchool] => Array
(
[0] => Kalani
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => BrettA@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3600
)
[ListAgentFullName] => Array
(
[0] => Brett K Aka
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-06T22:15:06.793
)
[Matrix_Unique_ID] => Array
(
[0] => 17496533
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-08-09T17:08:01.473
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Preservation
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25911442
)
[listing_image] => Array
(
[0] => 25911442
[1] => 25911443
[2] => 25911444
[3] => 25911445
[4] => 25911446
[5] => 25911447
[6] => 25911448
[7] => 25911449
[8] => 25911450
[9] => 25911451
[10] => 25911452
[11] => 25911453
[12] => 25911454
[13] => 25911455
[14] => 25911456
[15] => 25911457
)
[MatrixModifiedTime] => Array
(
[0] => 22:15:06.793
)
)
View: Mountain,Ocean,SunriseListing Office: BHGRE Advantage Realty
Land Tenure: FS - Fee Simple
Elementary School: Aina HainaMiddle School: Niu ValleyHigh School: Kalani
