99-460A Fernridge Place Unit 15-C Aiea, HI 96701
Listing
Overview
Price: $950,000
Area: HALAWA HEIGHTS
Status: Active
Welcome to your dream property! This exceptional lot offers a picturesque blend of breathtaking city and sunset views with Pearl Harbor front and center, creating an idyllic setting for your future home. Nestled at the edge of a tranquil stream and lush forest area, this is an opportunity to embrace the beauty of nature while enjoying the convenience of urban living. There are two avocado trees, one Haas and one Nishikawa avocado, two mature mulberry trees, ice cream banana and apple banana. The home above this vacant lot will be on the market soon, and potential buyers can consider buying that house as well. Listing by: eXp Realty
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202313763"
}
["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) "950000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "950000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(14) "HALAWA HEIGHTS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(621) "Welcome to your dream property! This exceptional lot offers a picturesque blend of breathtaking city and sunset views with Pearl Harbor front and center, creating an idyllic setting for your future home. Nestled at the edge of a tranquil stream and lush forest area, this is an opportunity to embrace the beauty of nature while enjoying the convenience of urban living. There are two avocado trees, one Haas and one Nishikawa avocado, two mature mulberry trees, ice cream banana and apple banana. The home above this vacant lot will be on the market soon, and potential buyers can consider buying that house as well."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp 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) "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(21) "City,Coastline,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) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "chase.meresz@exprealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Chase Meresz"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-10-23T10:53:03.467"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17384376"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-06-15T09:25:31.683"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25870534"
}
["listing_image"]=>
array(7) {
[0]=>
string(8) "25870534"
[1]=>
string(8) "25870535"
[2]=>
string(8) "25870536"
[3]=>
string(8) "25870537"
[4]=>
string(8) "25870538"
[5]=>
string(8) "25870539"
[6]=>
string(8) "25870540"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "PearlCity"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202313763
)
[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] => 950000.00
)
[CurrentPrice] => Array
(
[0] => 950000.00
)
[Neighbourhood] => Array
(
[0] => HALAWA HEIGHTS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your dream property! This exceptional lot offers a picturesque blend of breathtaking city and sunset views with Pearl Harbor front and center, creating an idyllic setting for your future home. Nestled at the edge of a tranquil stream and lush forest area, this is an opportunity to embrace the beauty of nature while enjoying the convenience of urban living. There are two avocado trees, one Haas and one Nishikawa avocado, two mature mulberry trees, ice cream banana and apple banana. The home above this vacant lot will be on the market soon, and potential buyers can consider buying that house as well.
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[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,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => chase.meresz@exprealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => Chase Meresz
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-10-23T10:53:03.467
)
[Matrix_Unique_ID] => Array
(
[0] => 17384376
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-06-15T09:25:31.683
)
[_thumbnail_id] => Array
(
[0] => 25870534
)
[listing_image] => Array
(
[0] => 25870534
[1] => 25870535
[2] => 25870536
[3] => 25870537
[4] => 25870538
[5] => 25870539
[6] => 25870540
)
[MLSAreaMajor] => Array
(
[0] => PearlCity
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- View: City,Coastline,Sunset
- Listing Office: eXp Realty
- Land Tenure: FS - Fee Simple
