That's great information, thank you very much indeed. That book on Waterford Streets you linked is a treasure trove, and I see that Lt Col Hardy seemed to have owned all the lands to do with St Catherine's Priory, which seem to include the current Courthouse grounds, part of the People's Park and extended right across from John's Hill, where he was selling property in 1812, and down Catherine Street to the Mall - quite a bit of land. The lands do seem to have passed to the 'Misses Hardy', who were his daughters Elizabeth and Harriet, and also to Caroline another daughter (who was married to a Rev Daniel Wall). Is it reasonable to assume these lands and various rents/tithes that passed to his daughters were simply purchased as an investment by him at some point, as the daughters are variously referred to as 'lay impropriators' in the tithe books?
I can't find any reference anywhere to Mr Hardy's marriage or his wife, or how he came into having so much land in Waterford, but the militia connection does seem to be the main one. I did find a reference in the Waterford Mail in 1826 referring to his death in Wicklow and noting he was 'for many years a resident of Waterford'.