Microsoft 365 Expert Needed to Build Real Estate Listing Database System (SharePoint + Microsoft Lists + Excel Dashboard)
Budget: $250 – $750 AUD
Project Overview
We are a real estate and business brokerage firm based in Melbourne, Australia. Our agency manages different types of listings including:
• Residential properties
• Vacant land and estate lots
• Farms and development land
• Businesses for sale (including fuel stations)
We are looking for an experienced Microsoft 365 developer or automation specialist to build a centralised listing management system using Microsoft Lists, SharePoint, Power Automate, and Excel or Power BI dashboards.
The goal is to create a central database where multiple agents can add and update listings, while management can see all listings in one master system.
System Overview
The system should work as follows:
Agents enter listings
↓
Microsoft Lists database
↓
SharePoint storage
↓
Automatic Master Listing database
↓
Excel or Power BI dashboard
This system will function as a simple internal CRM for listing management.
System Components Required
The system must include the following components.
Microsoft Lists Databases
Create separate listing databases for:
• Business Sales
• Residential Properties
• Land Listings
• Farm / Development Land
Each list will store structured listing data.
Master Listing Database
All listings from the different lists must automatically feed into a Master Stock List.
The master list should allow filtering by:
• listing type
• agent
• suburb / location
• status
• price range
Agent Access
Agents must be able to:
• add new listings
• edit their own listings
• update listing status
• access the system through SharePoint or Microsoft Lists
Permissions should allow agents to manage their own listings while management can see all listings.
Dashboard
Create a dashboard using Excel or Power BI showing:
• total listings
• listings by agent
• listings by category
• active listings
• under offer listings
• sold listings
Business Sale Listings – Required Fields
• Date
• Business Name
• Address
• Status
• Station
• Conjunctional Agent
• Business Type
• Asking Price
• Description
• Listing Agent
• Selling Agent
• Rent
• Patrons
• Net Profit
• Lease Left
• Authority
• Commercial Online
• Social Video
• Social Photo
• Marketplace
• Gumtree
• Links
Residential Listings – Required Fields
• Date
• Property Type
• Street Number
• Street Name
• Suburb
• Status
• Listed in CRM As
• Bedrooms
• Bathrooms
• Toilets
• Car Spaces
• Land Size
• House Size
• Asking Price
• Listing Agent
• Conjunctional Agent
• Other Details
• Listing Link
Land Listings – Required Fields
• Date
• Exclusive
• Land Size (M²)
• Stage
• Title / Lot Type
• Frontage
• Width / Depth
• Price
• Lot Number
• Street
• Location
• Listed As
• Rebate
• Asking On Top
• Estate
• Listing Agent
• Project Name
• Description
• Settlement Terms
• GRE Agent
• Remarks
Farm / Development Land Listings – Required Fields
• Date
• Exclusivity
• Agent
• Street Number
• Street Name
• Suburb
• CRM Status
• Listed As
• PSP Name
• Zoning
• Area (M²)
• Area (Ha)
• Acres
• Vendor Asking Price
• Price Per Acre
• NDA
• Description
• Settlement Terms
• Notes
• Vendor Name
• Vendor Contact Details
System Requirements
The system must include:
• Microsoft Lists database structure
• SharePoint integration
• Power Automate workflows to consolidate data
• multi-user editing support
• dropdown menus and data validation
• filtering and search functionality
• clean and simple user interface
• mobile-friendly access
Deliverables
The freelancer must provide:
• fully working Microsoft Lists databases
• SharePoint setup and permissions
• Power Automate flows for master database
• Excel or Power BI dashboard
• documentation explaining how agents use the system
Required Expertise
Applicants must have experience with:
• Microsoft Lists
• SharePoint Online
• Power Automate
• Excel advanced automation
• Microsoft 365 solutions
• data architecture or database design
Bonus experience:
• real estate CRM systems
• listing management platforms
• Power BI dashboards
Proposal Requirements
Please include:
• examples of similar systems you built
• explanation of how you would structure the database
• estimated timeline
• fixed project price or hourly rate
Project Goal
We want a simple, scalable listing management system where agents can easily update their listings while management has one central database of all listings.
This system will become our internal listing CRM for our real estate business.
We are a real estate and business brokerage firm based in Melbourne, Australia. Our agency manages different types of listings including:
• Residential properties
• Vacant land and estate lots
• Farms and development land
• Businesses for sale (including fuel stations)
We are looking for an experienced Microsoft 365 developer or automation specialist to build a centralised listing management system using Microsoft Lists, SharePoint, Power Automate, and Excel or Power BI dashboards.
The goal is to create a central database where multiple agents can add and update listings, while management can see all listings in one master system.
System Overview
The system should work as follows:
Agents enter listings
↓
Microsoft Lists database
↓
SharePoint storage
↓
Automatic Master Listing database
↓
Excel or Power BI dashboard
This system will function as a simple internal CRM for listing management.
System Components Required
The system must include the following components.
Microsoft Lists Databases
Create separate listing databases for:
• Business Sales
• Residential Properties
• Land Listings
• Farm / Development Land
Each list will store structured listing data.
Master Listing Database
All listings from the different lists must automatically feed into a Master Stock List.
The master list should allow filtering by:
• listing type
• agent
• suburb / location
• status
• price range
Agent Access
Agents must be able to:
• add new listings
• edit their own listings
• update listing status
• access the system through SharePoint or Microsoft Lists
Permissions should allow agents to manage their own listings while management can see all listings.
Dashboard
Create a dashboard using Excel or Power BI showing:
• total listings
• listings by agent
• listings by category
• active listings
• under offer listings
• sold listings
Business Sale Listings – Required Fields
• Date
• Business Name
• Address
• Status
• Station
• Conjunctional Agent
• Business Type
• Asking Price
• Description
• Listing Agent
• Selling Agent
• Rent
• Patrons
• Net Profit
• Lease Left
• Authority
• Commercial Online
• Social Video
• Social Photo
• Marketplace
• Gumtree
• Links
Residential Listings – Required Fields
• Date
• Property Type
• Street Number
• Street Name
• Suburb
• Status
• Listed in CRM As
• Bedrooms
• Bathrooms
• Toilets
• Car Spaces
• Land Size
• House Size
• Asking Price
• Listing Agent
• Conjunctional Agent
• Other Details
• Listing Link
Land Listings – Required Fields
• Date
• Exclusive
• Land Size (M²)
• Stage
• Title / Lot Type
• Frontage
• Width / Depth
• Price
• Lot Number
• Street
• Location
• Listed As
• Rebate
• Asking On Top
• Estate
• Listing Agent
• Project Name
• Description
• Settlement Terms
• GRE Agent
• Remarks
Farm / Development Land Listings – Required Fields
• Date
• Exclusivity
• Agent
• Street Number
• Street Name
• Suburb
• CRM Status
• Listed As
• PSP Name
• Zoning
• Area (M²)
• Area (Ha)
• Acres
• Vendor Asking Price
• Price Per Acre
• NDA
• Description
• Settlement Terms
• Notes
• Vendor Name
• Vendor Contact Details
System Requirements
The system must include:
• Microsoft Lists database structure
• SharePoint integration
• Power Automate workflows to consolidate data
• multi-user editing support
• dropdown menus and data validation
• filtering and search functionality
• clean and simple user interface
• mobile-friendly access
Deliverables
The freelancer must provide:
• fully working Microsoft Lists databases
• SharePoint setup and permissions
• Power Automate flows for master database
• Excel or Power BI dashboard
• documentation explaining how agents use the system
Required Expertise
Applicants must have experience with:
• Microsoft Lists
• SharePoint Online
• Power Automate
• Excel advanced automation
• Microsoft 365 solutions
• data architecture or database design
Bonus experience:
• real estate CRM systems
• listing management platforms
• Power BI dashboards
Proposal Requirements
Please include:
• examples of similar systems you built
• explanation of how you would structure the database
• estimated timeline
• fixed project price or hourly rate
Project Goal
We want a simple, scalable listing management system where agents can easily update their listings while management has one central database of all listings.
This system will become our internal listing CRM for our real estate business.