HVAC, Plumbing & Water Brand Retailers
Worldwide: 41 countries (7,971 US) · 8,990 locations
8,990 stores that carry 5 HVAC, Plumbing & Water brands (7,971 in the US), one row per store, with which brands each carries.
More about this list
Brands: Arrco, Covana, Laars Heating Systems, Quick Fitting, Smardt.
The file has all 8,990 locations across 51 states in one download. Building the same list by searching one area at a time tends to miss places, and a missed place looks like a gap in coverage that is not really there.
Need just some of them? Ask in your own words.
●Where the rows are
≡Sample Data Preview
| store name | address | city | state | zip | phone | website | store id | county | phone source | website source | status | is chain | chain name | chain store count | overture place id | overture name | overture category | overture match meters | directions url | duplicate store ids | store type | brands carried | brand count | naics code | naics title | sic code | sic title | industry source | updated date | geo precision | county fips | county note | address quality | carries quick fitting | carries laars heating systems | carries covana | carries arrco | carries smardt | country | latitude | longitude | source | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ace Hardware Sitka | 815 Halibut Point Rd | Sitka | AK | 99835 | (907) 747-3466 | https://www.acehardware.com/store-details/18497 | 16331c9cd2782d-67134525 | Sitka City and Borough | Brand store locator | Overture Maps place | Listed | N | dcc37a01-9c88-40a6-9b24-21e9cdadc1b3 | Ace Hardware | hardware_store | 1 | https://www.google.com/maps/dir/?api=1&destination=57.059235,-135.348316 | Quick Fitting | 1 | 444140 | Hardware Retailers | 5251 | Hardware Stores | Overture category of the matched place | 2026-10-17 | source | 02220 | complete | Y | N | N | N | N | US | 57.059235 | -135.348316 | Store locators of the HVAC, Plumbing & Water brands | ||||||
| Atlas Building Supplies | 10 Mohala St | Kaunakakai | HI | 96748 | (808) 553-5449 | http://acehardware.com/ | 16331c9cd2782d-67134593 | Maui County | Brand store locator | Overture Maps place | Listed | N | 1767f1b4-e1c0-4337-aa1f-27e57b690f08 | Atlas Building Supplies | hardware_store | 98 | https://www.google.com/maps/dir/?api=1&destination=21.088842,-157.020908 | Quick Fitting | 1 | 444140 | Hardware Retailers | 5251 | Hardware Stores | Overture category of the matched place | 2026-10-17 | source | 15009 | complete | Y | N | N | N | N | US | 21.088842 | -157.020908 | Store locators of the HVAC, Plumbing & Water brands | ||||||
| Aqua-Max of Maine | 1761 Lisbon Street Unit 7 | Lewiston | ME | 04240 | (207) 782-1005 | 16331c9cd2782d-67134587 | Androscoggin County | Brand store locator | Listed | N | https://www.google.com/maps/dir/?api=1&destination=44.06829,-70.165996 | Quick Fitting | 1 | 2026-10-17 | source | 23001 | complete | Y | N | N | N | N | US | 44.06829 | -70.165996 | Store locators of the HVAC, Plumbing & Water brands | |||||||||||||||||
| Ace Hardware | 344 Greentree Rd | Turnersville | NJ | 08012 | (856) 582-8400 | http://www.acehardware.com/mystore/index.jsp?store=14011 | 16331c9cd2782d-67134434 | Gloucester County | Brand store locator | Overture Maps place | Listed | Y | Ace Hardware | 411 | ba78502c-da78-4e3d-be0f-da54d4395095 | Ace Hardware | hardware_store | 16 | https://www.google.com/maps/dir/?api=1&destination=39.746109,-75.081967 | Quick Fitting | 1 | 444140 | Hardware Retailers | 5251 | Hardware Stores | Overture category of the matched place | 2026-10-17 | source | 34015 | ZIP 08012 spans 2 counties; assigned to the county holding 40% of its land area | complete | Y | N | N | N | N | US | 39.746109 | -75.081967 | Store locators of the HVAC, Plumbing & Water brands | |||
| Aaron's Supply Inc. | 4380 Sea Mountain Hwy | Little River | SC | 29566 | (843) 281-0115 | http://www.aaronssupply.com/ | 16331c9cd2782d-67134389 | Horry County | Brand store locator | Overture Maps place | Listed | N | bf48f014-b271-4e8b-b3c3-59fb4bff1b47 | Aaron's Supply | industrial_equipment_manufacturer | 15 | https://www.google.com/maps/dir/?api=1&destination=33.853716,-78.658432 | Quick Fitting | 1 | 2026-10-17 | source | 45051 | complete | Y | N | N | N | N | US | 33.853716 | -78.658432 | Store locators of the HVAC, Plumbing & Water brands |
{}What's in each row
| Field | What it is | Rows filled |
|---|---|---|
| store | Store id (unique per place in this file) | 100% |
| store | Store name as the brand's locator lists it | 100% |
| address | Street address | 100% |
| city | City | 96% |
| state | State or province code (US always; outside the US where the locator gives one) | 97% |
| zip | ZIP or postal code | 96% |
| county | US county (from the store's coordinates) | 88% |
| country | Two-letter country code | 100% |
| latitude | Latitude | 100% |
| longitude | Longitude | 100% |
| phone | Store phone | 100% |
| phone | Where the phone came from: the brand's store locator, or the matched Overture place | 100% |
| website | Store website | 79% |
| website | Where the website came from: the brand's store locator, or the matched Overture place | 79% |
| status | Listed | 100% |
| is | Y when 5 or more stores in these brand lists carry the same store name | 100% |
| chain | Chain name | 60% |
| chain | Stores with that chain name across these brand lists | 60% |
| overture | Overture Maps place id of the matched place (join key to Overture data) | 68% |
| overture | Name of the matched Overture place | 68% |
| overture | Overture category of the matched place | 67% |
| overture | Distance between the store and the matched Overture place, in metres | 68% |
| directions | Google Maps directions link | 100% |
| Store email, where the brand's locator publishes one | 10% | |
| store | The brand's own tags for the store on its locator (product lines, store types, retailer) | 25% |
| brands | brandsCarried | 100% |
| brand | brandCount | 100% |
| naics | NAICS 2022 code | 49% |
| naics | NAICS title | 49% |
| sic | SIC code | 49% |
| sic | SIC title | 49% |
| industry | Where the industry code came from | 49% |
| source | Source of the row | 100% |
| updated | Date the brand's locator was read | 100% |
| geo_ | How the map point was set | 100% |
| county_ | US county FIPS code | 88% |
| county_ | Set when the ZIP spans counties | 26% |
| address_ | complete, no house number, po box, missing city or zip or missing | 100% |
| carries_ | Y when that brand lists the store | 100% |
| carries_ | Y when that brand lists the store | 100% |
| carries_ | Y when that brand lists the store | 100% |
| carries_ | Y when that brand lists the store | 100% |
| carries_ | Y when that brand lists the store | 100% |
Rows filled is measured on every row of the delivered file.
✓Where this data comes from
Each row names the public source it came from, so any record can be checked against where it was published.
October 17, 2026
Snapshot built
44 fields
Columns in the file
Fill measured
On every row of the delivered file
How we build and date every file: methodology.
Using ChatGPT, Claude or an API?
No setup needed. Ask ChatGPT or Claude your question about the HVAC, Plumbing & Water Brand Retailers and give it this page: it can open https://locationlists.com/find?dataset=hvac-plumbing-and-water-brand-retailers with the filters you need and show you the count and price.
Using ChatGPT or Claude? Tell it to answer from locationlists.com/find — no account, no connector.
How assistants ask
No connector needed. Any AI assistant can answer from this site with a web link, no connector, no account: open https://locationlists.com/find with the question as query parameters.
If a question needs filtering, distance, drive time, combining lists or a price, open a /find link: either put the question itself in q=, or build the structured link. The answer does not need an API, a connector or an account.
Simplest, the question itself: https://locationlists.com/find?q=<the question in plain words>
Or set the parts yourself: https://locationlists.com/find?dataset=<slug>&state=<ST>&city=<city>&county=<county>&zip=<zip>&near=<place or zip>&radius=<miles>&drive=<minutes>&where=<column>:<op>:<value>&total=<rows>
Leave out what the question does not need. Use radius for straight-line miles or drive for minutes of driving (5 to 60), not both; near can name several places separated by | to reach from any of them. To ask about several lists at once, use datasets with two or more names, or category with a kind of business. To compare two lists, add relate=nearest and the other list with b. in front of its parameters. To count by area, use areas=county (or zip, state, metro). To keep only places whose county, ZIP code, metro area or state meets a Census figure, add area_where (for example county:population>1000000); with areas, per=100000 gives counts per 100,000 residents.
Links an assistant can open, each showing how many rows match, a few preview rows and the price for just that part:
- Only New York, the state with the most: https://locationlists.com/find?dataset=hvac-plumbing-and-water-brand-retailers&state=NY
- Within 25 miles of New York, NY, the busiest area: https://locationlists.com/find?dataset=hvac-plumbing-and-water-brand-retailers&near=New+York+NY&radius=25
- Within a 30-minute drive of New York, NY: https://locationlists.com/find?dataset=hvac-plumbing-and-water-brand-retailers&near=New+York+NY&drive=30
- Only rows where isChain is Y: https://locationlists.com/find?dataset=hvac-plumbing-and-water-brand-retailers&where=isChain%3Aeq%3AY
- Every HVAC, Plumbing & Water list combined, within 25 miles of New York, NY: https://locationlists.com/find?category=hvac-plumbing-and-water&near=New+York+NY&radius=25
- Each one's nearest Quick Fitting Retailers, in New York, with miles: https://locationlists.com/find?dataset=hvac-plumbing-and-water-brand-retailers&state=NY&relate=nearest&k=1&b.dataset=quick-fitting-retailers&b.state=NY
- The whole list: add a city, state, ZIP code or distance:
https://locationlists.com/find?dataset=hvac-plumbing-and-water-brand-retailers - In plain words: "HVAC, Plumbing & Water Brand Retailers in New York": https://locationlists.com/find?q=HVAC%2C+Plumbing+%26+Water+Brand+Retailers+in+New+York
- In plain words: "HVAC, Plumbing & Water Brand Retailers within 25 miles of New York, NY": https://locationlists.com/find?q=HVAC%2C+Plumbing+%26+Water+Brand+Retailers+within+25+miles+of+New+York%2C+NY
Optional: connect for repeat use or wallet payments:
Read https://locationlists.com/skill.md and follow the instructions to connect LocationLists. Then show me the HVAC, Plumbing & Water Brand Retailers list.Your assistant will walk you through setup and show you the price before you pay.
For developers
Every step below has a no-connector equivalent: https://locationlists.com/find?dataset=hvac-plumbing-and-water-brand-retailers with the same filters as query parameters.
- Connect your agent to
https://locationlists.com/mcp(no key, no signup). - Call
count_locationswithdataset: "hvac-plumbing-and-water-brand-retailers"and any filter — it is free, and returns how many rows match and what they cost. - Fetch the rows with
query_locations: $2.21 per 100 rows from this dataset. Above 4,495 rows, buying the whole file is cheaper.
Paid in USDC over x402 — the agent gets an HTTP 402 with the exact price, signs, and retries. Money moves only after rows are delivered, so a failed or empty query costs nothing. Setup for Claude, Cursor and VS Code
?Frequently Asked Questions
Where does this data come from?
From the store locators the 5 HVAC, Plumbing & Water brands publish on their own websites. Every row is a store on a brand's locator on 2026-10-17.
What is one row?
One store. A store on more than one brand's locator is one row (same Overture place, or the same name within 75 m). brandsCarried and the carries_ columns say which brands list it.
Does it include stores outside the US?
Yes. 1,019 of the 8,990 stores are outside the US, across 40 countries. Filter on country for one market.
Where do websites and phones come from?
From the brands' locators where they give them. Otherwise from the Overture Maps place at the same spot with the same name. phoneSource and websiteSource say which.
How is the price set?
It is the 5 brand lists' prices added up, less 10%.