95-2048 Waikalani Place Unit D205
Mililani, HI 96789

Listing
Overview

Price: $261,300
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Sold

Bring your handyman and your imagination to the rarely available Ridgecrest – Melamanu Woodlands. This 2 bed/1 bath, 2nd floor unit features wood cabinets in the kitchen and a large covered lanai that looks out to the trees and other foliage that provide privacy, behind the building. Most of the demo work is already done and just waiting for you to put your own stamp on it. This Pet Friendly condo even has its own dog park and resident manager on site! Perfect for investors or first time homebuyers, you don’t want to let this deal slip away. Property was built prior to 1978 and lead based paint potentially exists. This property may qualify for Seller Financing (Vendee).

Listing by: Island, REALTORS (808) 687-8000

array(172) {
  ["agency"]=>
  array(1) {
    [0]=>
    string(16) "Island, REALTORS"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "132000.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "148700.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "280700.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(19) "Ridgecrest-Melemanu"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(26) "Low-Rise 6 or Less Stories"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(30) "Non Resident Owner,See Remarks"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(6) "Kipapa"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "249076.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(10) "Land Court"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(34) "jennifer.cook-fujioka@irhawaii.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(23) "Jennifer K Cook-Fujioka"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 687-8000"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-08"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(16) "Island, REALTORS"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "261300.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "799"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(53) "95-2048 Waikalani Place Unit D205, Mililani, HI 96789"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "479.00"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202125568"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "STFP"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(26) "Assigned,Covered - 1,Guest"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96789"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(4) "Fair"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(15) "condo_townhouse"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(15) "Condo Townhouse"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(7) "Central"
  }
  ["rets_association_community_name"]=>
  array(1) {
    [0]=>
    string(37) "AOAO of Ridgecrest-Melemanu Woodlands"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "479"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "1.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_building_name"]=>
  array(1) {
    [0]=>
    string(19) "Ridgecrest-Melemanu"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["rets_co_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 687-8000"
  }
  ["rets_co_list_agent_email"]=>
  array(1) {
    [0]=>
    string(27) "scott.fujiwara@irhawaii.com"
  }
  ["rets_co_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Scott T Fujiwara"
  }
  ["rets_co_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "21741"
  }
  ["rets_co_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3474102"
  }
  ["rets_co_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "STFP"
  }
  ["rets_co_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487863"
  }
  ["rets_co_list_office_name"]=>
  array(1) {
    [0]=>
    string(16) "Island, REALTORS"
  }
  ["rets_co_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 687-8000"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(2) "61"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "275000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(6) "Kipapa"
  }
  ["rets_elevators_number_of"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_floor_number"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_fractional_ownership_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_high_school"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16217972"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_internet_automated_valuation_dis"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_internet_consumer_comment_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 687-8000"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(34) "jennifer.cook-fujioka@irhawaii.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(23) "Jennifer K Cook-Fujioka"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "44780"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9286389"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "STFP"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487863"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(16) "Island, REALTORS"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 687-8000"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "261300.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-08"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "249076.00"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "479.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(6) "Huakai"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-524-9310"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2022-02-09T06:50:56.720"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16217972"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202125568"
  }
  ["rets_model_site_contact_phone"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-08T09:00:07.670"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "261300.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "70"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-9-5-012-028-0071"
  }
  ["rets_parking_additional"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_permit_address_internet_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_permit_internet_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_photo_count"]=>
  array(1) {
    [0]=>
    string(2) "14"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-08T09:00:07.670"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96789"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16217972"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(286) "1) All offers must be submitted at www.vrmproperties.com. Agents must register as a User, enter the property address, and click on “Start Offer”. 2) This property may qualify for Seller Financing (Vendee). 3) If Property was built prior to 1978, Lead Based Paint Potentially Exists."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(679) "Bring your handyman and your imagination to the rarely available Ridgecrest - Melamanu Woodlands. This 2 bed/1 bath, 2nd floor unit features wood cabinets in the kitchen and a large covered lanai that looks out to the trees and other foliage that provide privacy, behind the building. Most of the demo work is already done and just waiting for you to put your own stamp on it. This Pet Friendly condo even has its own dog park and resident manager on site! Perfect for investors or first time  homebuyers, you don't want to let this deal slip away. Property was built prior to 1978 and lead based paint potentially exists. This property may qualify for Seller Financing (Vendee)."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "799"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "799"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2022-02-09T06:50:56.720"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-02-07"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(9) "Waikalani"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(7) "95-2048"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(5) "77.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "280700.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "132000.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "148700.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16217972/da6fb2e95f494e565b27cb9feb539379"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "195"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(2) "71"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "28"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "12"
  }
  ["rets_unit_number"]=>
  array(1) {
    [0]=>
    string(4) "D205"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(19) "Key,Security Patrol"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(9) "Waikalani"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(7) "95-2048"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-9-5-012-028-0071"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(65) "Bedroom on 1st Level,Full Bath on 1st Floor,Odd# Unit,Split Level"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(4) "D205"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16217972"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202125568"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1644425502"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(30) "11 - A-1 Low Density Apartment"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1117) "a:70:{i:0;i:20927045;i:1;i:20927046;i:2;i:20927047;i:3;i:20927048;i:4;i:20927049;i:5;i:20927050;i:6;i:20927051;i:7;i:20927052;i:8;i:20927053;i:9;i:20927054;i:10;i:20927055;i:11;i:20927056;i:12;i:20927057;i:13;i:20927058;i:14;i:20927095;i:15;i:20927096;i:16;i:20927097;i:17;i:20927098;i:18;i:20927099;i:19;i:20927100;i:20;i:20927101;i:21;i:20927102;i:22;i:20927103;i:23;i:20927104;i:24;i:20927105;i:25;i:20927106;i:26;i:20927107;i:27;i:20927108;i:28;i:20927124;i:29;i:20927125;i:30;i:20927126;i:31;i:20927127;i:32;i:20927128;i:33;i:20927129;i:34;i:20927130;i:35;i:20927131;i:36;i:20927132;i:37;i:20927133;i:38;i:20927134;i:39;i:20927135;i:40;i:20927136;i:41;i:20927137;i:42;i:21411838;i:43;i:21411839;i:44;i:21411840;i:45;i:21411841;i:46;i:21411842;i:47;i:21411843;i:48;i:21411844;i:49;i:21411845;i:50;i:21411846;i:51;i:21411847;i:52;i:21411848;i:53;i:21411849;i:54;i:21411850;i:55;i:21411851;i:56;i:21612081;i:57;i:21612082;i:58;i:21612083;i:59;i:21612084;i:60;i:21612085;i:61;i:21612086;i:62;i:21612087;i:63;i:21612088;i:64;i:21612089;i:65;i:21612090;i:66;i:21612091;i:67;i:21612092;i:68;i:21612093;i:69;i:21612094;}"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-08"
  }
  ["rets_association_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-445-5311"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(78) "1$21.46519697129822$-158.0238595474035$83.41$13.33$1.00$2I4kaO9S0Oblo9ETqhp2bw"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(6) "924.00"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-02-07"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "275000.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-04-05"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-02-07"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 263-6000"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(24) "hawaiirestacey@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(18) "Stacey A Shigekane"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "46043"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9953957"
  }
  ["rets_selling_agent_remarks"]=>
  array(1) {
    [0]=>
    string(49) "Thank you Stacey, for your hard work on this one!"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "KAIL"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485137"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(25) "Kailua Beach Realty, Ltd."
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 263-6000"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21612081"
  }
}
Array
(
    [agency] => Array
        (
            [0] => Island, REALTORS
        )

    [assd_val_imprv] => Array
        (
            [0] => 132000.00
        )

    [assd_val_land] => Array
        (
            [0] => 148700.00
        )

    [assd_val_total] => Array
        (
            [0] => 280700.00
        )

    [bedrooms] => Array
        (
            [0] => 2
        )

    [building_name] => Array
        (
            [0] => Ridgecrest-Melemanu
        )

    [building_style] => Array
        (
            [0] => Low-Rise 6 or Less Stories
        )

    [city] => Array
        (
            [0] => Mililani
        )

    [county] => Array
        (
            [0] => Oahu
        )

    [disclosures] => Array
        (
            [0] => Non Resident Owner,See Remarks
        )

    [elementary_school] => Array
        (
            [0] => Kipapa
        )

    [floor_covering] => Array
        (
            [0] => Other
        )

    [frontage] => Array
        (
            [0] => Other
        )

    [full_baths] => Array
        (
            [0] => 1
        )

    [furnished] => Array
        (
            [0] => None
        )

    [half_baths] => Array
        (
            [0] => 0
        )

    [high_school] => Array
        (
            [0] => Mililani
        )

    [home_exampt] => Array
        (
            [0] => 0
        )

    [land_area_sf] => Array
        (
            [0] => 249076.00
        )

    [land_recorded] => Array
        (
            [0] => Land Court
        )

    [land_tenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [list_agent_email] => Array
        (
            [0] => jennifer.cook-fujioka@irhawaii.com
        )

    [list_agent_name] => Array
        (
            [0] => Jennifer K Cook-Fujioka
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 687-8000
        )

    [list_date] => Array
        (
            [0] => 2021-10-08
        )

    [list_office_name] => Array
        (
            [0] => Island, REALTORS
        )

    [list_price] => Array
        (
            [0] => 261300.00
        )

    [living_sf] => Array
        (
            [0] => 799
        )

    [location] => Array
        (
            [0] => 95-2048 Waikalani Place Unit D205, Mililani, HI 96789
        )

    [maintenance_fees] => Array
        (
            [0] => 479.00
        )

    [middle_school] => Array
        (
            [0] => Mililani
        )

    [mls_] => Array
        (
            [0] => 202125568
        )

    [neighborhood] => Array
        (
            [0] => WAIPIO ACRES/WAIKALANI WOODLANDS
        )

    [number_of_parking_spaces] => Array
        (
            [0] => 1
        )

    [number_of_stories] => Array
        (
            [0] => One
        )

    [office_mls_id] => Array
        (
            [0] => STFP
        )

    [parking_features] => Array
        (
            [0] => Assigned,Covered - 1,Guest
        )

    [possession] => Array
        (
            [0] => At Closing
        )

    [postal_code] => Array
        (
            [0] => 96789
        )

    [property_condition] => Array
        (
            [0] => Fair
        )

    [property_type] => Array
        (
            [0] => condo_townhouse
        )

    [property_type_label] => Array
        (
            [0] => Condo Townhouse
        )

    [region] => Array
        (
            [0] => Central
        )

    [rets_association_community_name] => Array
        (
            [0] => AOAO of Ridgecrest-Melemanu Woodlands
        )

    [rets_association_fee_total] => Array
        (
            [0] => 479
        )

    [rets_baths_full] => Array
        (
            [0] => 1
        )

    [rets_baths_half] => Array
        (
            [0] => 0
        )

    [rets_baths_total] => Array
        (
            [0] => 1.00
        )

    [rets_beds_total] => Array
        (
            [0] => 2
        )

    [rets_building_name] => Array
        (
            [0] => Ridgecrest-Melemanu
        )

    [rets_city] => Array
        (
            [0] => Mililani
        )

    [rets_co_list_agent_direct_work_phone] => Array
        (
            [0] => (808) 687-8000
        )

    [rets_co_list_agent_email] => Array
        (
            [0] => scott.fujiwara@irhawaii.com
        )

    [rets_co_list_agent_full_name] => Array
        (
            [0] => Scott T Fujiwara
        )

    [rets_co_list_agent_mlsid] => Array
        (
            [0] => 21741
        )

    [rets_co_list_agent_mui] => Array
        (
            [0] => 3474102
        )

    [rets_co_list_office_mlsid] => Array
        (
            [0] => STFP
        )

    [rets_co_list_office_mui] => Array
        (
            [0] => 3487863
        )

    [rets_co_list_office_name] => Array
        (
            [0] => Island, REALTORS
        )

    [rets_co_list_office_phone] => Array
        (
            [0] => (808) 687-8000
        )

    [rets_condo_parking_unit] => Array
        (
            [0] => 61
        )

    [rets_current_price] => Array
        (
            [0] => 275000.00
        )

    [rets_dom] => Array
        (
            [0] => 0
        )

    [rets_dual_variable_compensation_yn] => Array
        (
            [0] => 0
        )

    [rets_elementary_school] => Array
        (
            [0] => Kipapa
        )

    [rets_elevators_number_of] => Array
        (
            [0] => 1
        )

    [rets_floor_number] => Array
        (
            [0] => 2
        )

    [rets_foreclosure_yn] => Array
        (
            [0] => 0
        )

    [rets_fractional_ownership_yn] => Array
        (
            [0] => 0
        )

    [rets_high_school] => Array
        (
            [0] => Mililani
        )

    [rets_id] => Array
        (
            [0] => 16217972
        )

    [rets_immoviewer_yn] => Array
        (
            [0] => 0
        )

    [rets_internet_automated_valuation_dis] => Array
        (
            [0] => 1
        )

    [rets_internet_consumer_comment_yn] => Array
        (
            [0] => 1
        )

    [rets_list_agent_direct_work_phone] => Array
        (
            [0] => (808) 687-8000
        )

    [rets_list_agent_email] => Array
        (
            [0] => jennifer.cook-fujioka@irhawaii.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Jennifer K Cook-Fujioka
        )

    [rets_list_agent_mlsid] => Array
        (
            [0] => 44780
        )

    [rets_list_agent_mui] => Array
        (
            [0] => 9286389
        )

    [rets_list_office_mlsid] => Array
        (
            [0] => STFP
        )

    [rets_list_office_mui] => Array
        (
            [0] => 3487863
        )

    [rets_list_office_name] => Array
        (
            [0] => Island, REALTORS
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 687-8000
        )

    [rets_list_price] => Array
        (
            [0] => 261300.00
        )

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-10-08
        )

    [rets_lot_size_area] => Array
        (
            [0] => 249076.00
        )

    [rets_maintenance_expense] => Array
        (
            [0] => 479.00
        )

    [rets_management_company_name] => Array
        (
            [0] => Huakai
        )

    [rets_management_company_phone] => Array
        (
            [0] => 808-524-9310
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2022-02-09T06:50:56.720
        )

    [rets_matrix_unique_id] => Array
        (
            [0] => 16217972
        )

    [rets_middle_or_junior_school] => Array
        (
            [0] => Mililani
        )

    [rets_mls_number] => Array
        (
            [0] => 202125568
        )

    [rets_model_site_contact_phone] => Array
        (
            [0] => 
        )

    [rets_neighbourhood] => Array
        (
            [0] => WAIPIO ACRES/WAIKALANI WOODLANDS
        )

    [rets_new_development_construction_yn] => Array
        (
            [0] => 0
        )

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-10-08T09:00:07.670
        )

    [rets_original_list_price] => Array
        (
            [0] => 261300.00
        )

    [rets_owner_occupancy_percentage] => Array
        (
            [0] => 70
        )

    [rets_parcel_number] => Array
        (
            [0] => 1-9-5-012-028-0071
        )

    [rets_parking_additional] => Array
        (
            [0] => 0
        )

    [rets_parking_total] => Array
        (
            [0] => 1
        )

    [rets_permit_address_internet_yn] => Array
        (
            [0] => 1
        )

    [rets_permit_internet_yn] => Array
        (
            [0] => 1
        )

    [rets_photo_count] => Array
        (
            [0] => 14
        )

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-10-08T09:00:07.670
        )

    [rets_postal_code] => Array
        (
            [0] => 96789
        )

    [rets_primary_key] => Array
        (
            [0] => 16217972
        )

    [rets_private_remarks] => Array
        (
            [0] => 1) All offers must be submitted at www.vrmproperties.com. Agents must register as a User, enter the property address, and click on “Start Offer”. 2) This property may qualify for Seller Financing (Vendee). 3) If Property was built prior to 1978, Lead Based Paint Potentially Exists.
        )

    [rets_public_remarks] => Array
        (
            [0] => Bring your handyman and your imagination to the rarely available Ridgecrest - Melamanu Woodlands. This 2 bed/1 bath, 2nd floor unit features wood cabinets in the kitchen and a large covered lanai that looks out to the trees and other foliage that provide privacy, behind the building. Most of the demo work is already done and just waiting for you to put your own stamp on it. This Pet Friendly condo even has its own dog park and resident manager on site! Perfect for investors or first time  homebuyers, you don't want to let this deal slip away. Property was built prior to 1978 and lead based paint potentially exists. This property may qualify for Seller Financing (Vendee).
        )

    [rets_sqft_roofed_living] => Array
        (
            [0] => 799
        )

    [rets_sqft_total] => Array
        (
            [0] => 799
        )

    [rets_state_or_province] => Array
        (
            [0] => HI
        )

    [rets_status_change_timestamp] => Array
        (
            [0] => 2022-02-09T06:50:56.720
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2022-02-07
        )

    [rets_street_name] => Array
        (
            [0] => Waikalani
        )

    [rets_street_number] => Array
        (
            [0] => 95-2048
        )

    [rets_sub_agency_compensation] => Array
        (
            [0] => 3
        )

    [rets_tax_amount] => Array
        (
            [0] => 77.00
        )

    [rets_tax_assessed_value] => Array
        (
            [0] => 280700.00
        )

    [rets_tax_assessed_value_improvements] => Array
        (
            [0] => 132000.00
        )

    [rets_tax_assessed_value_land] => Array
        (
            [0] => 148700.00
        )

    [rets_tax_excemption_owner_occupancy] => Array
        (
            [0] => 0
        )

    [rets_tax_paid_by_seller_yn] => Array
        (
            [0] => 0
        )

    [rets_tax_year] => Array
        (
            [0] => 2020
        )

    [rets_thumbnail_url] => Array
        (
            [0] => https://cdn.rets.ci/marcusrealty-images/16217972/da6fb2e95f494e565b27cb9feb539379
        )

    [rets_tmk_area] => Array
        (
            [0] => 195
        )

    [rets_tmk_condo_property_regime_number] => Array
        (
            [0] => 71
        )

    [rets_tmk_division] => Array
        (
            [0] => 1
        )

    [rets_tmk_parcel] => Array
        (
            [0] => 28
        )

    [rets_tmk_section] => Array
        (
            [0] => 5
        )

    [rets_tmk_zone] => Array
        (
            [0] => 9
        )

    [rets_tmkplat] => Array
        (
            [0] => 12
        )

    [rets_unit_number] => Array
        (
            [0] => D205
        )

    [rets_year_built] => Array
        (
            [0] => 1973
        )

    [security] => Array
        (
            [0] => Key,Security Patrol
        )

    [state_or_province] => Array
        (
            [0] => HI
        )

    [status] => Array
        (
            [0] => Sold
        )

    [street_name] => Array
        (
            [0] => Waikalani
        )

    [street_number] => Array
        (
            [0] => 95-2048
        )

    [street_suffix] => Array
        (
            [0] => Place
        )

    [terms_accept] => Array
        (
            [0] => Cash,Conventional
        )

    [tmk] => Array
        (
            [0] => 1-9-5-012-028-0071
        )

    [unit] => Array
        (
            [0] => Bedroom on 1st Level,Full Bath on 1st Floor,Odd# Unit,Split Level
        )

    [unit_number] => Array
        (
            [0] => D205
        )

    [view] => Array
        (
            [0] => Garden
        )

    [wpp::rets_pk] => Array
        (
            [0] => 16217972
        )

    [wpp_gpid] => Array
        (
            [0] => 202125568
        )

    [wpp_import_schedule_id] => Array
        (
            [0] => 1463343682
        )

    [wpp_import_time] => Array
        (
            [0] => 1644425502
        )

    [year_built] => Array
        (
            [0] => 1973
        )

    [zoning] => Array
        (
            [0] => 11 - A-1 Low Density Apartment
        )

    [new_attached_media] => Array
        (
            [0] => a:70:{i:0;i:20927045;i:1;i:20927046;i:2;i:20927047;i:3;i:20927048;i:4;i:20927049;i:5;i:20927050;i:6;i:20927051;i:7;i:20927052;i:8;i:20927053;i:9;i:20927054;i:10;i:20927055;i:11;i:20927056;i:12;i:20927057;i:13;i:20927058;i:14;i:20927095;i:15;i:20927096;i:16;i:20927097;i:17;i:20927098;i:18;i:20927099;i:19;i:20927100;i:20;i:20927101;i:21;i:20927102;i:22;i:20927103;i:23;i:20927104;i:24;i:20927105;i:25;i:20927106;i:26;i:20927107;i:27;i:20927108;i:28;i:20927124;i:29;i:20927125;i:30;i:20927126;i:31;i:20927127;i:32;i:20927128;i:33;i:20927129;i:34;i:20927130;i:35;i:20927131;i:36;i:20927132;i:37;i:20927133;i:38;i:20927134;i:39;i:20927135;i:40;i:20927136;i:41;i:20927137;i:42;i:21411838;i:43;i:21411839;i:44;i:21411840;i:45;i:21411841;i:46;i:21411842;i:47;i:21411843;i:48;i:21411844;i:49;i:21411845;i:50;i:21411846;i:51;i:21411847;i:52;i:21411848;i:53;i:21411849;i:54;i:21411850;i:55;i:21411851;i:56;i:21612081;i:57;i:21612082;i:58;i:21612083;i:59;i:21612084;i:60;i:21612085;i:61;i:21612086;i:62;i:21612087;i:63;i:21612088;i:64;i:21612089;i:65;i:21612090;i:66;i:21612091;i:67;i:21612092;i:68;i:21612093;i:69;i:21612094;}
        )

    [rets_pending_date] => Array
        (
            [0] => 2021-10-08
        )

    [rets_association_phone] => Array
        (
            [0] => 808-445-5311
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.46519697129822$-158.0238595474035$83.41$13.33$1.00$2I4kaO9S0Oblo9ETqhp2bw
        )

    [rets_tax_annual_amount] => Array
        (
            [0] => 924.00
        )

    [rets_close_date] => Array
        (
            [0] => 2022-02-07
        )

    [rets_close_price] => Array
        (
            [0] => 275000.00
        )

    [rets_expiration_date] => Array
        (
            [0] => 2022-04-05
        )

    [rets_off_market_date] => Array
        (
            [0] => 2022-02-07
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 263-6000
        )

    [rets_selling_agent_email] => Array
        (
            [0] => hawaiirestacey@gmail.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Stacey A Shigekane
        )

    [rets_selling_agent_mlsid] => Array
        (
            [0] => 46043
        )

    [rets_selling_agent_mui] => Array
        (
            [0] => 9953957
        )

    [rets_selling_agent_remarks] => Array
        (
            [0] => Thank you Stacey, for your hard work on this one!
        )

    [rets_selling_office_mlsid] => Array
        (
            [0] => KAIL
        )

    [rets_selling_office_mui] => Array
        (
            [0] => 3485137
        )

    [rets_selling_office_name] => Array
        (
            [0] => Kailua Beach Realty, Ltd.
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 263-6000
        )

    [_thumbnail_id] => Array
        (
            [0] => 21612081
        )

)

  • Bedrooms: 2
  • Full Baths: 1
  • Land Area (sf): 249,076
  • Living (sf): 799
  • Year Built: 1973
  • Building Name: Ridgecrest-Melemanu

  • Property Condition: Fair
  • Number of Parking Spaces: 1
  • Number of Stories: One
  • View: Garden
  • Listing Office: Island, REALTORS

  • Maintenance Fees: $479
  • Land Tenure: FS - Fee Simple

  • Elementary School: Kipapa
  • Middle School: Mililani
  • High School: Mililani

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446