NogDog Sorry for the long delay but since webdeveloper.com couldn't notify me, I didn't see this reply until now that I visit the site in a long time. I would have answered a lot sooner. The project have been changing since the last post so I have more questions, but first I'm going to answer these:
Question1: "For instance, can a single property have both a "Rentals" thing and a "Sales" thing associated with it, or is it always just one or the other?".
I realized down the line that a single property is either for rent or for sale, never both it is always just one or the other (Imagine somebody buying the apartment while somebody else is already renting it 😅, what happens then). However once a property has been sold, it can be later uploaded as a property to rent buy the buyer.
Question2: Are you actually tracking "transactions", i.e., something that happens related to the property, presumably with a date or datetime associated with it? (Names are important. 😉)
Indeed names are important here. If you could illustrate more what you meant by transaction that'll be helpful 😅.
Question3: "could there be multiple sales and/or rental "transactions" associated with a property or are you really just storing the current "asking price" to buy or rent that property?"
I think I am just storing the current "asking price" to buy or rent that property. However this question also makes me curious: "could there be multiple sales and/or rental "transactions" associated with a property". This question actually makes me wonder whether real estate platforms keep tracks of the properties sold or rented.
thanks for your attention and Sorry for the long post 🙏.