It's OK, freelance contracts can be really hard, I've had one go south very quickly. While it (maybe?) doesn't matter now, you might have been better served by setting them up with wordpress + a real-estate specific plugin (there are lots, some even free). Basically what they were asking you for seems like a real estate specific CRM system, and the CRM world is very very deep and flush with pre-built/other options. Those kind of ideas are often best farmed out, a lot of places will think they need custom software but really don't (or at least you shouldn't write it though it would seem fun).
If it wasn't too long ago, maybe you can make it up to them by hosting a Wordpress instance (or some other low-cost-to-you CRM tech you didn't have to write) and offering a solution to them for free for a year or something as an apology? An apology would probably feel better for you if you had something to offer them in addition to just the words.
Either way, definitely hang out in the Slack! I don't know where in Japan you are, but there's a lot happening in the Fukuoka area, and I think there's a HN Kansai that just started as well. Not sure of anything to the north but maybe there is!
Also, being able to even find freelance contracts locally is pretty difficult, so that's a great accomplishment, keep your chin up! It seems likely that you have the skills necessary to make it work just need to find the right way to apply them.