This is the dream, especially if that dream means acute style-acumen and normco...
Typing "hardware near me" into Google in Dubai turns up two very different worlds, and which one you need depends on what's actually broken or being built. There's the retail DIY layer — big-box stores in malls and retail parks selling paint, garden tools and flat-pack fittings to homeowners — and there's the trade layer, the small ironmongers and building-material shops clustered in industrial areas that contractors and maintenance companies actually use. Knowing which one you need before you drive anywhere saves a wasted trip.
If you want volume, trade pricing and someone who actually stocks the odd-sized bolt you need, the destinations are Al Quoz Industrial Areas 1 to 4, Ras Al Khor Industrial Area, and Naif Road and the surrounding lanes in Deira. These areas are full of small shops, often run as extensions of a general trading or building materials licence, that sell everything from plumbing fittings and electrical conduit to power tools, locks, paint and timber. Karama and Satwa also have a good spread of hardware and paint shops mixed in with the residential streets, useful if you're doing small home fixes and don't want to drive to an industrial area for a tin of filler.
For retail quantities — a tin of paint, a cordless drill, curtain rails — the DIY chains with stores in places like Al Barsha, Dubai Marina Mall, Dragon Mart and various retail parks are the easier option. They take cards, have fixed shelf prices, and don't expect you to know trade terminology. What they don't do well is small, odd, or bulk trade orders; for that you want the independent shops.
Prices in the independent shops are rarely marked, which surprises people used to fixed retail tags, but that doesn't mean they're arbitrary. A standard box of assorted screws runs AED 15-25. A decent 13mm cordless drill from a mid-range brand sits around AED 150-300 depending on battery capacity; anything advertised at AED 60-80 is almost certainly a low-quality import that will burn out within a few uses. A 4-litre tin of standard emulsion paint from a recognised regional brand costs AED 60-110, while unbranded paint from the cheapest shops can be half that and noticeably thinner, needing three coats where two would do. Mortice locks for internal doors run AED 40-90; a decent euro-cylinder lock suitable for a main entrance door is closer to AED 120-250. If a shop quotes well below these ranges for branded-sounding items, ask to see the box and check the brand is spelled correctly — counterfeit tools and fittings do circulate through some of the cheaper industrial-area shops.

If you're managing a villa renovation, running a small maintenance company, or simply doing enough work that you're back at the same shop every fortnight, ask about a trade account. Most of the established shops in Al Quoz and Ras Al Khor will set one up with a copy of your trade licence or Ejari, and it typically gets you 10-20% off list prices plus the ability to pay monthly against invoices rather than cash on the day. This matters more than it sounds: cash-only shops with no account system are usually the smaller, less established operations, and if something goes wrong with a bulk order you have far less leverage to get it resolved.
Delivery is standard practice, not a favour. Most hardware shops in the trade areas will deliver within Dubai same-day for orders over a modest threshold, often free above AED 200-300 and for a flat AED 20-40 fee below that. If a shop tells you delivery isn't possible for a bulky order like cement bags or timber lengths, that's usually a sign they don't have the relationship with a driver or pickup that a properly run shop should.
A few quick questions on the phone or in person tell you a lot before you commit to an order:

Demand for hardware in Dubai follows the building calendar as much as the weather. October through April is villa-renovation and fit-out season, and the good trade shops get genuinely busy — expect slower delivery times and less room to negotiate. June through September is quieter on the trade side but brutal for anyone doing outdoor work themselves; paint doesn't cure properly above certain temperatures, sealants skin over before you've smoothed them, and most experienced tradespeople will tell you plainly that exterior jobs should wait for autumn. If a shop's staff wave through a request to paint an exposed wall in July without mentioning this, take the advice with a pinch of salt.
One last practical point: a shop's DED licence category matters more than it looks. A "general trading" licence lets a business sell almost anything, including hardware, but a shop specifically licensed for building materials or electrical goods has usually gone through more scrutiny on the products it can legally stock, particularly for anything used in fixed installations. It's not something you need to interrogate on every visit, but for larger orders — a full villa's worth of electrical fittings, say — asking to see the shop's trade licence alongside the invoice is a reasonable and not remotely awkward request in Dubai's trade culture.
This is the dream, especially if that dream means acute style-acumen and normco...