REALLY liked this guy when he did my house back in 2019, referred by a very close friend.
Rod Stewardson
Rod Inspects, LLC
210-494-5560
He charged us, if I recall correctly, like $400, but he did a very comprehensive check... the home I was purchasing was about 20 years old and in AMAZING condition (supremely rare kept up), and he even found little stuff to let me know about, and of course 1-2 'bigger' concern items like a little rust on a valve on the water heater and the dryer-duct in attic leading to roof was a little crooked (someone bumped into it, it needed straightening). Small stuff, but kinda told me that he does notice everything and isn't just mailing in an easy job for good pay.
http://www.rodinspects.com Gonna have to flush the toilet, but that's one expensive poo.