Residents
- Queen Emma Apts
- Lot: 7,706 sqft
Facts
Lot size: 7,706 sqft
 
                            
                    
                    
                    
                Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|  | Industry: Single-Family House Construction | See Details | |
| 
        808-926-****     
        808-924-****     | Categories: Real EstateVacation RentalsReal Estate Rental ServiceProperty Management Industry: Real Estate Agent/ManagerReal Estate Agents SIC: 6531 - Real Estate Agents and Managers Site: gailpetagnorealtor.com | See Details | |
| 
                                        P R Gail                                     | 
        808-926-****     |  | |
| 
                                        Realtor Petagno                                     | 
        808-926-****     |  | |
| 
                                        Gail M Petagno Age: 85                                     | 
        808-922-****     
        808-924-****     | Email: Organization: Gail Petagno Realtor Site: gailpetagnorealtor.com Owner Ms. Gail M. H. Petagno | 
- 1 bed
- 1 bath
- 625 sqft
- Built in 1959
Facts
Lot size: 5,680 sqft
Parking: None
 
                            
                    
                    
                    
                Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|  | Industry: Distribute Holiday Packs To Hotels And Rental UnitsPacks Include Kitchen Utensils & Other Utensils Used In Rental Apartments Type of Business: Domestic Limited Partnership | See Details | |
|  | Industry: Business Services | See Details | |
|  | Industry: Nonclassifiable Establishments | See Details | |
|  | Industry: Jewelry And/or Gem Wholesaling Inactive: 19941017 | See Details | |
|  | Industry: Dance Studio/School/Hall Type of Business: Domestic Limited Liability Company (LLC) | See Details | 
 
                            
                    
                    
                    
                Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|  | Industry: Charter Boat Sailing Inactive: 20180429 | See Details | |
|  | Industry: Beverage Catering Inactive: 20190106 | See Details | |
| 
                                        Daniel T Baker                                     |  |  | |
| 
                                        Tina M Bell                                     | 
        808-552-****     |  | |
| 
                                        Brandon Bodell Age: 44                                     |  |  | 
- Lot: 7,692 sqft
Facts
Lot size: 7,692 sqft
 
                            
                    
                    
                    
                Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|  | Industry: Musical Show Band Recording Band Inactive: 20010412 | See Details | |
|  | Industry: ENTERTAINMENT AGENCYPRODUCTIONS AND ENTERTAINMENT COMPANYMotion Picture/Tape Distribution Inactive: 20010111 | See Details | |
|  | Type of Business: Domestic Limited Liability Company (LLC) Inactive: 20181008 | See Details | |
|  | Industry: Candies And Food Wholesale/retail Inactive: 20150902 | See Details | |
|  | Industry: ConsultingBusiness Consulting ServicesNonclassifiable Establishments Type of Business: Domestic Limited Liability Company (LLC) | See Details | 
- Aqua Aloha Surf Hotel
- 1 bed
- 1 bath
- 495 sqft
- Built in 1968
Facts
Lot size: 0.52 acres
Rooms: 2
Stories: 1 story
Exterior walls: Other
 
                            
                                            
                            For Sale
                                                            $179,000
                                                                                
                    
                    
                    
                Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
|  | Type of Business: General Domestic Partnership | See Details | |
| 
        808-923-****     | Categories: General Merchandise Wholesale | See Details | |
| 
        808-926-****     | Categories: Chinese RestaurantsRestaurants Site: alohasurfhotelwaikiki.com | See Details | |
| 
        808-926-****     | Categories: Tours - Operators & Promoters | See Details | |
| 
                                        Aloha Bistro                                     | 
        808-926-****     |  | 
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| 
                                        Jennifer E Ahn                                     | 
        808-923-****     |  | 
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| 
                                        Emaley Mcculloch                                     | 
        808-923-****     |  | 
Market Activities
To date, we have no information about market activities in 2025
    
        Jun 2024
        
            Sold            
            
        
    
    
        Jun 2024
        
            Sold            
            
        
    
    
        Jun 2024
        
            Listed for sale            
            
        
    
    
        May 2024
        
            Listed for sale            
            
        
    
    
        May 2024
        
            Sold            
            
        
    
    
        May 2024
        
            Listed for sale            
            
        
    
    
        May 2024
        
            Listed for sale            
            
        
    
    
        Apr 2024
        
            Sold            
            
        
    
    
        Apr 2024
        
            Sold            
            
        
    
    
        Apr 2024
        
            Sold            
            
        
    
    
        Mar 2024
        
            Sold            
            
        
    
    
        Mar 2024
        
            Sold            
            
        
    
    
        Mar 2024
        
            Sold            
            
        
    
    
        Feb 2024
        
            Sold            
            
        
    
    
        Feb 2024
        
            Listed for sale            
            
        
    
    
        Jan 2024
        
            Sold            
            
        
    
    
        Dec 2023
        
            Sold            
            
        
    
    
        Oct 2023
        
            Sold            
            
        
    
    
        Oct 2023
        
            Sold            
            
        
    
    
        Sep 2023
        
            Sold            
            
        
    
    
Fire Incident History
To date, we have no information about fire incidents in 2025
            
        
                    28 Sep 2012
                    Building fires
                
                Property Use — 
                 Multifamily dwellings
               Area of Origin — 
                 Common room, den, family room, living room, lounge
               First Ignition — 
                 Upholstered sofa, chair, vehicle seats
               Heat Source — 
                 Candle
               
                    19 Mar 2006
                    Outside equipment fire
                
                Property Use — 
                 Multifamily dwellings
               Area of Origin — 
                 Entrance way, lobby
               First Ignition — 
                 Electrical wire, cable insulation
               Heat Source — 
                 Arcing
               
                    02 Mar 2004
                    Building fires
                
                Property Use — 
                 Hotel/motel, commercial
               Area of Origin — 
                 Ceiling & floor assembly, crawl space b/t stories
               First Ignition — 
                 Electrical wire, cable insulation
               Heat Source — 
                 Spark, ember or flame from operating equipment
               
                    14 Nov 1999
                    Natural vegetation fire, other
                
                Property Use — 
                 Hotel/motel, commercial
               Area of Origin — 
                 Open area - outside; included are farmland, field
               First Ignition — 
                 Animal living or dead
               Heat Source — 
                 Cigarette
               Incidents registered in Federal Emergency Management Agency
To date, we have no information about incidents registered in FEMA in 2025
            
        
                    11 Jan 2014
                    Vehicle accident, general cleanup
                
                Property Use — 
                 Street or road in commercial area
               
                    25 May 2011
                    Cultivated trees or nursery stock fire
                
                Property Use — 
                 Hotel/motel, commercial
               
                    26 Jul 2010
                    Cultivated trees or nursery stock fire
                
                Property Use — 
                 Hotel/motel, commercial
               
                    11 Jan 2007
                    Arcing, shorted electrical equipment
                
                Property Use — 
                 Multifamily dwellings