Where to find pie pumpkins

A week ago they were everywhere, and I know I can't find them anywhere. Where on earth do I find a sugar pumpkin aka pie pumpkin? I'm making homemade pie for thanksgiving. Bonus points for suggestions being in West Houston, I live near SH6, so anywhere nearby, would be amazing, but I have no issues driving somewhere farther away. Thanks y'all!