Home / Companies / IN-HOUSE REALTY LLC

IN-HOUSE REALTY LLC H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
IN-HOUSE REALTY LLC IN HOUSE REALTY LLC	4	3	1	FY2016 to FY2018 Latest decision 2018-02-02	2	BI ENGINEER 2 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	4
Certified LCAs	4
Denied LCAs	0
Role titles	3
Worksites	1
Latest decision	2018-02-02
USCIS approvals	2
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
IN HOUSE REALTY LLC	IN-HOUSE REALTY LLC, IN HOUSE REALTY LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
BI ENGINEER	15-1199	2	$53,500	$0
BUSINESS INTELLIGENCE ENGINEER	15-1199	1	$64,043	$0
SQA ENGINEER	15-1199	1	$65,000	$0

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Detroit	MI	48226	4	3	53,500	0	2,016	2,018

Full company payload

Company ID	company:in house realty
Name	IN-HOUSE REALTY LLC
Normalized Name	in house realty
Source Company Ids	company_dol_oflc_lca_in_house_realty_llc, company_uscis_h1b_datahub_in_house_realty_llc_tax_9140
Source Names	IN-HOUSE REALTY LLC, IN HOUSE REALTY LLC
Aliases	IN HOUSE REALTY LLC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "IN-HOUSE REALTY LLC",
    "IN HOUSE REALTY LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "IN-HOUSE REALTY LLC",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "IN HOUSE REALTY, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "IN HOUSE REALTY LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9140",
    "source": "uscis_h1b_employer_data_hub"
  }
]

LCA Activity

{
  "lca_count": 4,
  "case_count": 4,
  "role_title_count": 3,
  "worksite_count": 1,
  "total_workers": 4,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-01-08",
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2018-02-02",
  "certified_count": 4,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 2,
  "total_denial": 0,
  "fiscal_years": [
    "2009",
    "2016"
  ],
  "year_metrics": [
    {
      "cities": [
        "Livonia"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "53"
      ],
      "postal_codes": [
        "48152"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_in_house_realty_llc_tax_9140_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_019625"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Detroit"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "53"
      ],
      "postal_codes": [
        "48226"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_in_house_realty_llc_tax_9140_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_010533"
      ],
      "continuing_approval": 1
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "DETROIT MI 48226",
      "city": "Detroit",
      "state": "MI",
      "postal_code": "48226",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-02-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "DETROIT MI 48226",
      "city": "Detroit",
      "county": "Wayne",
      "state": "MI",
      "postal_code": "48226",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-02-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 1,
    "has_street_address_evidence": true,
    "caveat": "LCA employer/worksite addresses are capped filing evidence scoped to matched source company names and should not be treated as verified headquarters without external validation."
  }
}

Geography

{
  "states": [
    "MI"
  ],
  "cities": [
    "Detroit",
    "Livonia"
  ],
  "postal_codes": [
    "48226",
    "48152"
  ],
  "top_markets": [
    {
      "city": "Detroit",
      "state": "MI",
      "postal_code": "48226",
      "lca_count": 4,
      "role_title_count": 3,
      "wage_low_min": 53500,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    }
  ]
}

Industry

{
  "naics_codes": [
    "5313",
    "53"
  ],
  "naics_breakdown": [
    {
      "value": "5313",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 53500,
  "annualized_high_max": 0,
  "annualized_low_avg": 59556.25
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 55682,
    "wage_high_max": 0,
    "wage_low_avg": 60341
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 53500,
    "wage_high_max": 0,
    "wage_low_avg": 53500
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 64043,
    "wage_high_max": 0,
    "wage_low_avg": 64043
  }
]

Links

{
  "roles": "/v1/roles?company=IN-HOUSE%20REALTY%20LLC",
  "wages": "/v1/wages?company=IN-HOUSE%20REALTY%20LLC",
  "trends": "/v1/trends?company=IN-HOUSE%20REALTY%20LLC"
}

Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=in+house+realty+llc&limit=5JSON

Docs · Get an API key