Data | Merge Code | Example Output |
---|
Sales or lettings | <LoggedNegotiator.Config.CurrentAppMode == "L"> | True / False | Brief Description (with ellipsis) | <Formatter.WordEllipsis(Property.Brief, 300)> |
| Price (for advertising) | <LoggedNegotiator.Config.CurrentAppMode == "L" ? (Property.Lettings.RentQual == "PA" ? "Rent on application" : Property.Lettings.RentUIFormattedWithPeriod) : (Property.Sales.PriceQual == "PA" ? Property.Sales.PriceQualName : Property.Sales.PriceQualName + ": " + Property.Sales.PriceRangeFormatted)> | £500 per month / Guide price: £250,000 | Price (for advertising - short) | <LoggedNegotiator.Config.CurrentAppMode == "L" ? (Property.Lettings.RentQual == "PA" ? "Rent on application" : Property.Lettings.RentUIFormattedWithPeriod.Replace ("per month", "PCM").Replace("per week", "PW").Replace ("per annum", "PA")) : (Property.Sales.PriceQual == "PA" ? Property.Sales.PriceQualName : (Property.Sales.PriceQual == "OR" ? "OIRO " : Property.Sales.PriceQual == "OE" ? "OIEO " : Property.Sales.PriceQualName) + ": " + Property.Sales.PriceRangeFormatted)> | £500 PCM / OIRO: £250,000 | Price (for advertising - no sales qualifer) | <LoggedNegotiator.Config.CurrentAppMode == "L" ? (Property.Lettings.RentQual == "PA" ? "Rent on application" : Property.Lettings.RentUIFormattedWithPeriod) : (Property.Sales.PriceQual == "PA" ? Property.Sales.PriceQualName : Property.Sales.PriceRangeFormatted)> | £500 per month / £250,000 | Price Qualifier (with Price Reduction Qualifier) | <LoggedNegotiator.Config.CurrentAppMode == "S" ? ((Property.Sales.Reduced != DateTime.MinValue) && (7 <= (DateTime.Now - Property.Sales.Reduced).Days) ? "NEW PRICE" : Property.Sales.StatusName.Replace (" - Available", "").Replace(" STC", "").Replace (" - Unavailable", "").ToUpper()) : (Property.Lettings.StatusName.Replace (" - Available", "").Replace(" STC", "").Replace (" - Unavailable", "").ToUpper())> | NEW PRICE / FOR SALE | Rent (in words) | <Formatter.PriceWord(Convert.ToInt32 (Math.Floor(Property.Lettings.RentUI)) + " pounds" + (Property.Lettings.RentUI % 1 != 0 ? " and " + Formatter.PriceWord (Convert.ToInt32((Property.Lettings.RentUI - Math.Floor(Property.Lettings.RentUI))*100)) + " pence" : "")> | five hundred and thirty-five pounds | Annual Rent | <Formatter.FormatPrice(Property.Lettings.ARent, 2)> | £57,204.05 | Annual Rent (in words) | <Formatter.PriceWord(Convert.ToInt32(Math.Floor (Property.Lettings.ARent))) + " pounds" + (Property.Lettings.ARent % 1 != 0 ? " and " + Formatter.PriceWord(Convert.ToInt32 ((Property.Lettings.ARent - Math.Floor (Property.Lettings.ARent))*100)) + " pence" : "")> | fifty-seven thousand, two hundred and four pounds and five pence | Sales Price (in words) | <Formatter.PriceWord(Convert.ToInt32(Property. Sales.Price))> pounds | twenty-two thousand, one hundred and one pounds | Offer Price (in words) | <Formatter.PriceWord(Convert.ToInt32(Offer.OfferPrice)) > pounds | twenty-two thousand, one hundred and one pounds | Available From | <Property.AvFrom < DateTime.Now ? "Available Now" : "Available from " + Property.AvFrom.ToShortDateString()> | Available Now / Available from 05/01/2016 | Negotiator Image |
|
| Company Vendor Staff Contact | <Property.PrimaryContact.AsCompany().GetStaffPhone (Property.PrimaryContact.AsCompany().CurrentAttn, "e")> | jbloggs@reapit.com | Vendor Solicitor Bank - Account name | <Property.Sales.Vendor.Solicitor. MainAccount.AccountName> | Lloyds | Vendor Solicitor Bank - Account number | <Property.Sales.Vendor.Solicitor.MainAccount.Account Num> | 01234567 | Vendor Solicitor Bank - Sort Code | <Property.Sales.Vendor.Solicitor.MainAccount. SortCode> | 01-23-45 |
DevelopmentData | Merge Code | Example Output |
---|
Site phone | <Property.GetSiteMasterPrp().SiteOffice.SitePhone> |
| Open hours | <Property.GetSiteMasterPrp().SiteOffice.OpenHours> |
| Staff name 1 | <Property.GetSiteMasterPrp().SiteOffice.AllStaff[0].ToString()> |
| Staff name 2 | <Property.GetSiteMasterPrp().SiteOffice.AllStaff[1].ToString()> |
|
MarketingData | Merge Code | Example Output |
---|
Sales Board Type | <Property.Sales.SBType == "F" ? "Flag Board" : Property.Sales.SBType == "V" ? "V Board" : "None"> | Flag Board | Sales Board Status | <Formatter.CodesToNames(Property.Sales.SBStat, UserEnvironment.SBStatusList)> | Sold | Sales Board Previous Status | <Formatter.CodesToNames(origPrpExtra.GetExtra("pSBStat", ""), UserEnvironment.Instance.SBStatusList)> | For Sale | Sales Board Date | <Property.Sales.SBDate.ToShortDateString()> | 14/12/2015 | Sales Board Notes | <Property.BoardNotes> |
| Internet URL | <String.IsNullOrEmpty(Property.URL) ? MergeHelper.MergeString(LoggedNegotiator.Config.PrpUrl, Property) : Property.URL> | http://www. example.com /sales/ LDS150001 | URL Text | <Property.UrlText> | Property Link | No Internet Advertising | <Property.NoIntAdv> | True/False | Council Tax Band | <Property.ExtrasField.GetExtra("pCouncilTaxBand", "")> | D | Old Property Reference | <Property.OldCode> | CHLCH_814 | Extra descriptions | <Property.ExtrasField.GetExtra("pLongDesc", "")> |
| Legal Matter Number | <Property.ExtrasField.GetExtra("pMatterNo", "")> | 366853 |
EPC screenData | Merge Code | Example Output |
---|
BER Rating | <Property.ExtrasField.GetExtra("pBERExempt", false) ? "Exempt" : Property.ExtrasField.GetExtra("pBERRating", "To be confirmed")> | C3 | EPC Band | <Property.HipEerBand> | C |
Attributes screenData | Merge Code | Example Output |
---|
Department Code | <Property.Attributes.DepCode> | G | All Attributes | <Property.Attributes.ToString()> | 2 Plots, Leasehold 2 years 10 months, 4 Total Bedrooms [...] | All Attributes (bullet point list) | <Convert.ToChar(8226).ToString()+ " " + Property.Attributes.ToString().Replace(", ", Convert.ToChar(13).ToString() + Convert.ToChar(8226).ToString() + " ")> | |
Attribute columnsData | Merge Code | Example Output |
---|
Attribute column 1 value (Type) | <Property.Attributes.MakeAtts("1")> | House | Attribute column 2 value (Style) | <Property.Attributes.MakeAtts("2")> | End of terrace | Attribute column 3 value (Situation) | <Property.Attributes.MakeAtts("3")> | Garden, Patio | Attribute column 4 value (Special) | <Property.Attributes.MakeAtts("4")> | Outbuilding | Attribute column 5 value (Parking) | <Property.Attributes.MakeAtts("5")> | Garage, Residential Parking | Attribute column 6 value (Age) | <Property.Attributes.MakeAtts("6")> | Period | Attribute column 7 value (Locality) | <Property.Attributes.MakeAtts("7")> | Rural |
Rooms/areaData | Merge Code | Example Output |
---|
Square Metres | <Property.Attributes.Metres> | 300 | Square Metres To | <Property.Attributes.MetresTo> | 400 | Price Per Square Foot (Sales) | <Formatter.FormatPrice(Property.Sales.Price / Property.Attributes.Feet)> | £2,500.00 | Price per square foot (lettings) | <String.Format("{0}/Sq.Ft. {1}", Formatter.FormatPrice(Property.Lettings.RentUI / Property.Attributes.Feet, 2), Property.Lettings.RentPeriodNameShort)> | £25.00/Sq.Ft. p/a | Hectares | <Math.Round(Property.Attributes.Acres * 0.4047, 1)> | 2.6 | Number of units | <Property.Attributes.Plots> | 4 |
Appliances, insurance & safetyData | Merge Code | Example Output |
---|
Start Date | <Property.Lettings.GetLastCert("GS"). StartDate.ToShortDateString()> | 05/04/2016 | Expiry Date | <Property.Lettings.GetLastCert("GS"). EndDate.ToShortDateString()> | 05/04/2017 | Policy Number | <Property.Lettings.GetLastCert("GS"). PolicyNo> | AA65413 | Supplier | <Property.Lettings.GetLastCert("GS"). Supplier.Name> | British Gas, Leeds | Notes | <Property.Lettings.GetLastCert("GS").Notes> |
|
Financial screen (sales only)Data | Merge Code | Example Output |
---|
Date Instructed - New Instruction | <(DateTime.Now - Property.Sales.ForSDate).Days <= 14 ? "New Instruction" : ""> | New Instruction | Agency Agreement Expiry Weeks | <(Property.Sales.AgExpiry - Property.Sales.ForSDate).Days / 7> | 6 | Joint Agent 1 Name | <Property.Sales.JointAgents[0].Name> | Savills | Joint Agent 1 Address | <Property.Sales.JointAgents[0].Address.AddressWithReturns> | PO Box 227 Rotherham S98 1PD | Joint Agent 2 Name | <Property.Sales.JointAgents[1].Name> | Savills | Joint Agent 2 Address | <Property.Sales.JointAgents[2].Address.AddressWithReturns> | PO Box 227 Rotherham S98 1PD | Estimated Commission VAT | <Formatter.FormatPrice((Convert.ToDecimal(Property.Sales. CommAmount) * LoggedNegotiator.Config.Vat) /100, 2)> | £6,000.00 | Estimated Commission Amount (without VAT) | <Property.Sales.CommAmountFormatted> | £30,000 | Estimated Commission plus VAT | <Formatter.FormatPrice(Convert.ToDecimal(Property.Sales. CommAmount) + (Convert.ToDecimal(Property.Sales. CommAmount) * LoggedNegotiator.Config.Vat) /100, 2)> | £36,000.00 | Estimated Commission plus VAT formatted as % | <(Convert.ToDecimal(Property.Sales.Comm) + Decimal.Multiply((LoggedNegotiator.Config.Vat / 100.00), Convert.ToDecimal(Property.Sales.Comm))).ToString("#.#") + "%"> | 1.6% | Estimated Commission plus VAT formatted as % | <(Convert.ToDecimal(Property.Sales.Comm) + Decimal.Multiply((LoggedNegotiator.Config.Vat / 100.00), Convert.ToDecimal(Property.Sales.Comm))).ToString("#.#") + "%"> | 1.6% | Estimated Commission with decimals from Asking Price (if record is Exchanged it will pull through Exchange Commission) | <Property.Sales.ExchComm != 0 ? Property.Sales.ExchCommFormatted : Property.Sales.Comm != 0.0 ? Formatter.FormatPrice(Math.Round(Convert.ToDecimal(Property.Sales. Comm) / 100.0 * Convert.ToDecimal(Property.Sales.Price), 2),2) : Property.Sales.FixedCommFormatted> | £3249.38 | Vendor Estimated Price | <Formatter.FormatPrice(Convert.ToDouble(Property.ExtrasField.GetExtra ("pVendEst", "")),2)> | £21,000 | Minimum match price | <Property.Sales.MinPriceFormatted> | £400,000 | Maximum match price | <Property.Sales.MaxPriceFormatted> | £500,000 | Matching price range | <String.Format("{0} to {1}", Property.Sales.PriceFormatted, Property.Sales.MaxPriceFormatted)> | £400,000 to £500,000 |
Rent/fee details (lettings)Data | Merge Code | Example Output |
---|
Letting Fee Reducing to % (1) | <Formatter.GetPercentString(Property.Lettings.FeeRedPer1)> | 5% | Letting Fee Reducing to months (1) | <Property.Lettings.FeeRedMonth1> | 6 | Letting Fee Reducing to % (2) | <Formatter.GetPercentString(Property.Lettings.FeeRedPer2)> | 2.5% | Letting Fee Reducing to months (2) | <Property.Lettings.FeeRedMonth2> | 12 | Joint Agent 1 Name | <Property.Lettings.JointAgents[0].Name> | Savills | Joint Agent 1 Address | <Property.Lettings.JointAgents[0].Address.AddressWithReturns> | PO Box 227 Rotherham S98 1PD | Joint Agent 2 Name | <Property.Lettings.JointAgents[1].Name> | Savills | Joint Agent 2 Address | <Property.Lettings.JointAgents[2].Address.AddressWithReturns> | PO Box 227 Rotherham S98 1PD | Deposit required | <LoggedNegotiator.Config.CurrentAppMode == "L" ? Property.Lettings.DepositSumFormatted : ""> | £500.00 |
RoomsData | Merge Codes | Example Output |
---|
Accommodation Summary - comma separated | <Property.AccSum.Trim().Replace(Convert.ToChar(13).ToString(), ", ")> | 21 houses, 716 acres, Two main boat houses, A harbour, Bantham Ham, Bantham Beach, | Accommodation Summary - bullet point separated inline | <Property.AccSum.Trim().Replace(Convert.ToChar(13).ToString(), " • ")> | 21 houses • 716 acres • Two main boat houses • A harbour • Bantham Ham • Bantham Beach | Accommodation Summary - with bullet point on each line | <"• " + Property.AccSum.Trim().Replace(Convert.ToChar(13).ToString(), Convert.ToChar(13).ToString() + "• ")> | • 21 houses • 716 acres • Two main boat houses • A harbour • Bantham Ham • Bantham Beach |
KeysData | Merge Code | Example Output |
---|
Keys held office name | <UserEnvironment.Offices[Property.KeyOffCode].Name> | Leeds | Keys held office address | <UserEnvironment.Offices[Property.KeyOffCode]. Address.AddressWithReturns> | 1 The Headrow Leeds LS1 1AA | Key Number | <Property.KeyNo> | 123 | Viewing arrangements | <Property.Viewing> | Lorem ipsum dolor sit amet, consectetur adipiscing elit. | Keys out with | <Property.KeyWith> | John Doe |
|