99-460A Fernridge Place Unit 15-C Aiea, HI 96701
Listing
Overview
Price: $735,000
Area: HALAWA HEIGHTS
Status: Active
Fantastic savings with a $60,000 price drop on one of the last opportunities in the tranquil Halawa Heights neighborhood to build your own dream home! With a variety of fruit trees to harvest and a view of Pearl Harbor with urban attractions below, this lush piece of nature is ideal for both enjoying serenity and having the conveniences of the city nearby. Sellers are highly motivated and excited for new ownership! Listing by: Neue Realty Group (808) 729-0963
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202408215"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "99-460A"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Fernridge"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "15-C"
}
["City"]=>
array(1) {
[0]=>
string(4) "Aiea"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96701"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "735000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "735000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(14) "HALAWA HEIGHTS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(418) "Fantastic savings with a $60,000 price drop on one of the last opportunities in the tranquil Halawa Heights neighborhood to build your own dream home! With a variety of fruit trees to harvest and a view of Pearl Harbor with urban attractions below, this lush piece of nature is ideal for both enjoying serenity and having the conveniences of the city nearby. Sellers are highly motivated and excited for new ownership!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(17) "Neue Realty Group"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7099.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(30) "City,Coastline,Mountain,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["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) "HERO"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "TimMiller.ENRG@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 729-0963"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Timothy Miller"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-06-09T17:12:10.690"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17938080"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-14T07:08:52.407"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "PearlCity"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26165082"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26165082"
[1]=>
string(8) "26165083"
[2]=>
string(8) "26165084"
[3]=>
string(8) "26165085"
[4]=>
string(8) "26165086"
[5]=>
string(8) "26165087"
[6]=>
string(8) "26165088"
[7]=>
string(8) "26165089"
[8]=>
string(8) "26165090"
[9]=>
string(8) "26165091"
[10]=>
string(8) "26165092"
[11]=>
string(8) "26165093"
[12]=>
string(8) "26165094"
[13]=>
string(8) "26165095"
[14]=>
string(8) "26165096"
[15]=>
string(8) "26165097"
[16]=>
string(8) "26184414"
[17]=>
string(8) "26184415"
[18]=>
string(8) "26184416"
[19]=>
string(8) "26184417"
[20]=>
string(8) "26184418"
[21]=>
string(8) "26574435"
[22]=>
string(8) "26574436"
[23]=>
string(8) "26574437"
[24]=>
string(8) "26574438"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202408215
)
[StreetNumber] => Array
(
[0] => 99-460A
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Fernridge
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => 15-C
)
[City] => Array
(
[0] => Aiea
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96701
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 735000.00
)
[CurrentPrice] => Array
(
[0] => 735000.00
)
[Neighbourhood] => Array
(
[0] => HALAWA HEIGHTS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Fantastic savings with a $60,000 price drop on one of the last opportunities in the tranquil Halawa Heights neighborhood to build your own dream home! With a variety of fruit trees to harvest and a view of Pearl Harbor with urban attractions below, this lush piece of nature is ideal for both enjoying serenity and having the conveniences of the city nearby. Sellers are highly motivated and excited for new ownership!
)
[ListOfficeName] => Array
(
[0] => Neue Realty Group
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 7099.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => City,Coastline,Mountain,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HERO
)
[ListAgentEmail] => Array
(
[0] => TimMiller.ENRG@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 729-0963
)
[ListAgentFullName] => Array
(
[0] => Timothy Miller
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-06-09T17:12:10.690
)
[Matrix_Unique_ID] => Array
(
[0] => 17938080
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-14T07:08:52.407
)
[MLSAreaMajor] => Array
(
[0] => PearlCity
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26165082
)
[listing_image] => Array
(
[0] => 26165082
[1] => 26165083
[2] => 26165084
[3] => 26165085
[4] => 26165086
[5] => 26165087
[6] => 26165088
[7] => 26165089
[8] => 26165090
[9] => 26165091
[10] => 26165092
[11] => 26165093
[12] => 26165094
[13] => 26165095
[14] => 26165096
[15] => 26165097
[16] => 26184414
[17] => 26184415
[18] => 26184416
[19] => 26184417
[20] => 26184418
[21] => 26574435
[22] => 26574436
[23] => 26574437
[24] => 26574438
)
)
- View: City,Coastline,Mountain,Sunset
- Listing Office: Neue Realty Group
- Land Tenure: FS - Fee Simple
