Hotel management and booking system using Mambo

Hello! I'm looking for a professional and slick way to manage hotel listings and bookings for the hotels/bed and breakfasts/motels/hostels/condos/etc. in my area. What I am looking to do is utilize mambo server to do this and I do not want to work with an affiliation service. What I would like is the following: A central, searchable database containing: 1. Hotel/hostel/motel/Bed and Breakfast information such as: a. Type (hotel, bed and breakfast, etc.) b. Name c. Location (address) d. email address e. Preferred payment types f. Room types g. Accomodations h. Nearby attractions i. Capability to upload hotel photos j. Other, customizable fields 2. Room availability a. Dates b. Prices for the specific types of rooms c. Special rates (IE. Book for 3 days and get a 10% discount) I would like to let my clientel be able to login to this central database and create their own listings and be able to easily change their availability, rates, anything applicable. Additionally, once there is a successful payment (perhaps via paypal), I would also like to automatically reflect the room availability for that specific hotel and note that the successful booking was through that service; also shoot into another database that a successful booking has been made for that specific hotel and for what amount (for commission purposes on my end). I want to be able to display all the relevant information on the front end by either utilizing mambo directly or through a frame of somesort displaying the simple information. I want the front end to be able to include the following: 1. A thumbnail preview of the hotel image which would be shown in full once the user clicks for more hotel information 2. A preview of hotel availability for the criteria the user has provided, along with prices and a brief description (which would be provided by the hotel) 3. Capability to pay for the hotel booking via credit card (using Paypal) For the backend, where hotel clients would manipulate their availability and create new listings, I would prefer it to be completely web based -> scripts being easily manipulated for future expansion (if the main server with the database changes from [login to view URL] to [login to view URL] I would like to easily change this). What I am thinking of doing is creating a site that would be used to do the listings and everything (IE. [login to view URL]) and then have other sites reflecting the actual listings (IE. [login to view URL] and [login to view URL]). This is just my idea as to what I would like to do. It is a little intense of a thing to do, It's ok to use other existing components so long as no legal barriers are crossed... Let me know what you think. I think that this is a good project as this can easily be tailored for other clients in the future and even be used for other purposes (real estate listings such as an alternative MLS, other inventory type systems). If you do decide to make this as extensive as possible, I'm looking to do other things with real estate listings in my area, like creating an exclusive lakefront property listing service and more.