INSERT INTO `atom_api_logs` (`id`, `user_id`, `property_id`, `called_from`, `called_by`, `api_endpoint`, `api_request`, `api_response`, `response_status`, `response_error`, `created_at`, `updated_at`) VALUES
(240, 9, 19, 'atom-property-services', 'jobs', '/property/detailmortgage', 'https://api.gateway.attomdata.com/propertyapi/v1.0.0/property/detailmortgage?attomid=15797493', '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"0b9967b41ac741f9b5cb61639952f6a2\",\"attomId\":15797493},\"property\":[{\"identifier\":{\"Id\":15797493,\"attomId\":15797493,\"fips\":\"17113\",\"apn\":\"03-12-130-002\"},\"lot\":{\"lotnum\":\"28\",\"lotsize1\":0.3300046,\"lotsize2\":14375,\"pooltype\":\"NO POOL\"},\"area\":{\"loctype\":\"VIEW - NONE\",\"countrysecsubd\":\"McLean\",\"countyuse1\":\"0030 \",\"muncode\":\"ML\",\"munname\":\"MCLEAN\",\"subdname\":\"2ND ADD SUNRISE\",\"taxcodearea\":\"810\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C001\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.740046\",\"longitude\":\"-88.709990\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, PL1712931, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"5ee429c51dd1f7d069f007b4188785ba\",\"PL\":\"eb9e46e9c2d26e33fe55f86f6eae48b4\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Vacant\",\"propsubtype\":\"Residential\",\"proptype\":\"RESIDENTIAL - VACANT LAND\",\"propertyType\":\"RESIDENTIAL - VACANT LAND\",\"propLandUse\":\"RESIDENTIAL - VACANT LAND\",\"propIndicator\":\"80\",\"legal1\":\"2ND ADD TO SUNRISE LOT 28\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"LIVING SQFT\"},\"rooms\":{},\"interior\":{},\"construction\":{},\"parking\":{},\"summary\":{\"view\":\"VIEW - NONE\"}},\"mortgage\":{\"lender\":{},\"title\":{},\"date\":\"\",\"duedate\":\"\"},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"}}]}', 'success', NULL, '2024-05-16 13:49:32', '2024-05-16 13:49:32'),
(241, 9, 19, 'atom-property-services', 'jobs', '/allevents/detail', 'https://api.gateway.attomdata.com/propertyapi/v1.0.0/allevents/detail?id=15797493', '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"e366a688cd7f4f4d363343cd1cd951d7\",\"attomId\":15797493},\"property\":[{\"identifier\":{\"Id\":15797493,\"fips\":\"17113\",\"apn\":\"03-12-130-002\",\"attomId\":15797493},\"lot\":{\"lotnum\":\"28\",\"lotsize1\":0.3300046,\"lotsize2\":14375,\"pooltype\":\"NO POOL\"},\"area\":{\"loctype\":\"VIEW - NONE\",\"countrysecsubd\":\"McLean\",\"countyuse1\":\"0030 \",\"muncode\":\"ML\",\"munname\":\"MCLEAN\",\"subdname\":\"2ND ADD SUNRISE\",\"taxcodearea\":\"810\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C001\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.740046\",\"longitude\":\"-88.709990\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, PL1712931, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"5ee429c51dd1f7d069f007b4188785ba\",\"PL\":\"eb9e46e9c2d26e33fe55f86f6eae48b4\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Vacant\",\"propsubtype\":\"Residential\",\"proptype\":\"RESIDENTIAL - VACANT LAND\",\"propertyType\":\"RESIDENTIAL - VACANT LAND\",\"propLandUse\":\"RESIDENTIAL - VACANT LAND\",\"propIndicator\":\"80\",\"legal1\":\"2ND ADD TO SUNRISE LOT 28\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"LIVING SQFT\"},\"rooms\":{},\"interior\":{},\"construction\":{},\"parking\":{},\"summary\":{\"view\":\"VIEW - NONE\",\"viewCode\":\"000\"}},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"},\"avm\":{\"amount\":{\"scr\":0,\"high\":0,\"low\":0},\"AVMChange\":{},\"calculations\":{},\"condition\":{\"avmpoorlow\":0.0,\"avmpoorhigh\":0.0,\"avmgoodlow\":0.0,\"avmgoodhigh\":0.0,\"avmexcellentlow\":0.0,\"avmexcellenthigh\":0.0}},\"sale\":{\"amount\":{\"saledisclosuretype\":0},\"calculation\":{},\"interfamily\":\"N\"},\"assessment\":{\"appraised\":{},\"assessed\":{\"assdlandpersizeunit\":0.36,\"assdlandvalue\":5141,\"assdttlvalue\":5141},\"calculations\":{\"calcimprind\":\"MARKET VALUE\",\"calclandind\":\"MARKET VALUE\",\"calclandpersizeunit\":1.07,\"calclandvalue\":15423,\"calcttlind\":\"MARKET VALUE\",\"calcttlvalue\":15423},\"market\":{\"mktlandvalue\":15423,\"mktttlvalue\":15423},\"tax\":{\"taxamt\":489.7,\"taxyear\":2023}}}]}', 'success', NULL, '2024-05-16 13:49:32', '2024-05-16 13:49:33'),
(242, 9, 19, 'atom-property-services', 'jobs', '/valuation/rentalavm', 'https://api.gateway.attomdata.com/propertyapi/v1.0.0/valuation/rentalavm?address1=Velacheri&address2=chennai', '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":858,\"page\":1,\"pagesize\":10,\"transactionID\":\"a400ee24e1e1a05a4682c9e7f80f53d8\"},\"property\":[{\"identifier\":{\"Id\":15797493,\"fips\":\"17113\",\"apn\":\"03-12-130-002\",\"attomId\":15797493},\"lot\":{\"lotsize1\":0.3300046,\"lotsize2\":14375},\"area\":{\"countrysecsubd\":\"McLean\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C001\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.740046\",\"longitude\":\"-88.709990\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, PL1712931, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"5ee429c51dd1f7d069f007b4188785ba\",\"PL\":\"eb9e46e9c2d26e33fe55f86f6eae48b4\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Vacant\",\"propsubtype\":\"Residential\",\"proptype\":\"RESIDENTIAL - VACANT LAND\",\"propertyType\":\"RESIDENTIAL - VACANT LAND\",\"propLandUse\":\"RESIDENTIAL - VACANT LAND\",\"propIndicator\":\"80\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"LIVING SQFT\"},\"rooms\":{},\"interior\":{},\"parking\":{},\"summary\":{}},\"rentalAvm\":{\"estimatedRentalValue\":0,\"estimatedMinRentalValue\":0,\"estimatedMaxRentalValue\":0},\"assessment\":{\"assessed\":{\"assdttlvalue\":5141},\"market\":{\"mktttlvalue\":15423,\"mktlandvalue\":15423}},\"owner\":{\"owner1\":{\"fullname\":\"MICHAEL R CLEINMARK\",\"lastname\":\"CLEINMARK \",\"firstnameandmi\":\"MICHAEL R\"},\"owner2\":{},\"owner3\":{},\"owner4\":{},\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"6602 E 1550 NORTH RD, DANVERS, IL 61732-9100\"},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"}},{\"identifier\":{\"Id\":29825810,\"fips\":\"17113\",\"apn\":\"03-01-312-005\",\"attomId\":29825810},\"lot\":{\"lotsize1\":0.4100092,\"lotsize2\":17860},\"area\":{\"countrysecsubd\":\"McLean\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C002\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.746208\",\"longitude\":\"-88.714191\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, PL1712931, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"5ee429c51dd1f7d069f007b4188785ba\",\"PL\":\"eb9e46e9c2d26e33fe55f86f6eae48b4\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Vacant\",\"propsubtype\":\"Residential\",\"proptype\":\"RESIDENTIAL - VACANT LAND\",\"propertyType\":\"RESIDENTIAL - VACANT LAND\",\"propLandUse\":\"RESIDENTIAL - VACANT LAND\",\"propIndicator\":\"80\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"LIVING SQFT\"},\"rooms\":{},\"interior\":{},\"parking\":{},\"summary\":{}},\"rentalAvm\":{\"estimatedRentalValue\":0,\"estimatedMinRentalValue\":0,\"estimatedMaxRentalValue\":0},\"assessment\":{\"assessed\":{\"assdttlvalue\":6394},\"market\":{\"mktttlvalue\":19182,\"mktlandvalue\":19182}},\"owner\":{\"owner1\":{\"fullname\":\"CHARLES RHOADS\",\"lastname\":\"RHOADS \",\"firstnameandmi\":\"CHARLES \"},\"owner2\":{},\"owner3\":{\"fullname\":\"TINA L RHOADS\",\"lastname\":\"RHOADS \",\"firstnameandmi\":\"TINA L\"},\"owner4\":{},\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"116 N 3RD AVE, CHENOA, IL 61726-1034\"},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"}},{\"identifier\":{\"Id\":31844822,\"fips\":\"17113\",\"apn\":\"03-02-487-015\",\"attomId\":31844822},\"lot\":{},\"area\":{\"countrysecsubd\":\"McLean\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C001\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.743857\",\"longitude\":\"-88.719845\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, PL1712931, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"5ee429c51dd1f7d069f007b4188785ba\",\"PL\":\"eb9e46e9c2d26e33fe55f86f6eae48b4\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Vacant\",\"propsubtype\":\"Commercial\",\"proptype\":\"COMMERCIAL ACREAGE\",\"propertyType\":\"VACANT COMMERCIAL\",\"propLandUse\":\"COMMERCIAL ACREAGE\",\"propIndicator\":\"80\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"BUILDING SQFT\"},\"rooms\":{},\"interior\":{},\"parking\":{},\"summary\":{}},\"rentalAvm\":{\"estimatedRentalValue\":0,\"estimatedMinRentalValue\":0,\"estimatedMaxRentalValue\":0},\"assessment\":{\"assessed\":{\"assdttlvalue\":1287},\"market\":{\"mktttlvalue\":3861,\"mktlandvalue\":3861}},\"owner\":{\"owner1\":{\"fullname\":\"JABIER CARRANZA\",\"lastname\":\"CARRANZA \",\"firstnameandmi\":\"JABIER \"},\"owner2\":{\"fullname\":\"CLAIR CARRANZA\",\"lastname\":\"CARRANZA \",\"firstnameandmi\":\"CLAIR \"},\"owner3\":{},\"owner4\":{},\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"6620 RENALDO WAY S, SAINT PETERSBURG, FL 33707-3925\"},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"}},{\"identifier\":{\"Id\":42265426,\"fips\":\"17113\",\"apn\":\"04-04-400-005\",\"attomId\":42265426},\"lot\":{\"lotsize1\":49.84,\"lotsize2\":2171030},\"area\":{\"countrysecsubd\":\"McLean\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"R002\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.747951\",\"longitude\":\"-88.646988\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"29a123c12ed4d6b0b2786efb6530e7c9\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Agricultural\",\"propsubtype\":\"AGRICULTURE / FARMING\",\"proptype\":\"FARMS\",\"propertyType\":\"FARM (IRRIGATED OR DRY)\",\"propLandUse\":\"FARMS\",\"propIndicator\":\"70\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"BUILDING SQFT\"},\"rooms\":{},\"interior\":{},\"parking\":{},\"summary\":{}},\"rentalAvm\":{\"estimatedRentalValue\":0,\"estimatedMinRentalValue\":0,\"estimatedMaxRentalValue\":0},\"assessment\":{\"assessed\":{\"assdttlvalue\":20719},\"market\":{\"mktttlvalue\":62157}},\"owner\":{\"owner1\":{\"fullname\":\"DAVID WINTERLAND\",\"lastname\":\"WINTERLAND \",\"firstnameandmi\":\"DAVID \"},\"owner2\":{},\"owner3\":{},\"owner4\":{},\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"621 WASHINGTON ST, MINONK, IL 61760-1264\"},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"}},{\"identifier\":{\"Id\":46225563,\"fips\":\"17113\",\"apn\":\"03-12-159-004\",\"attomId\":46225563},\"lot\":{\"lotsize1\":0.2800046,\"lotsize2\":12197},\"area\":{\"countrysecsubd\":\"McLean\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"R001\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.734483\",\"longitude\":\"-88.718015\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, PL1712931, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"5ee429c51dd1f7d069f007b4188785ba\",\"PL\":\"eb9e46e9c2d26e33fe55f86f6eae48b4\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Single Family Residence / Townhouse\",\"propsubtype\":\"Residential\",\"proptype\":\"SFR\",\"propertyType\":\"SINGLE FAMILY RESIDENCE\",\"yearbuilt\":1989,\"propLandUse\":\"SFR\",\"propIndicator\":\"10\"},\"utilities\":{},\"building\":{\"size\":{\"bldgsize\":1288,\"grosssizeadjusted\":1288,\"livingsize\":1288,\"sizeInd\":\"LIVING SQFT\",\"universalsize\":1288},\"rooms\":{},\"interior\":{},\"parking\":{\"prkgType\":\"Garage, Detached\"},\"summary\":{}},\"rentalAvm\":{\"estimatedRentalValue\":1811,\"estimatedMinRentalValue\":1200,\"estimatedMaxRentalValue\":2500,\"valuationDate\":\"2024-03-25\"},\"assessment\":{\"assessed\":{\"assdttlvalue\":12749},\"market\":{\"mktttlvalue\":38247,\"mktlandvalue\":13083}},\"owner\":{\"owner1\":{\"fullname\":\"BRITTANY WATSON\",\"lastname\":\"WATSON \",\"firstnameandmi\":\"BRITTANY \"},\"owner2\":{},\"owner3\":{},\"owner4\":{},\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"919 S DIVISION ST, CHENOA, IL 61726-1361\"},\"vintage\":{\"lastModified\":\"2024-04-30\",\"pubDate\":\"2024-04-30\"}},{\"identifier\":{\"Id\":173190960,\"fips\":\"17113\",\"apn\":\"04-22-400-001\",\"attomId\":173190960},\"lot\":{\"lotsize1\":160.0,\"lotsize2\":6969600},\"area\":{\"countrysecsubd\":\"McLean\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C031\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.702435\",\"longitude\":\"-88.626705\",\"distance\":0.0,\"geoid\":\"CO17113, CS1706639, DB1706480, PL1706613, SB0000083654, SB0000083655, SB0000083656, ZI61701\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"29a123c12ed4d6b0b2786efb6530e7c9\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Agricultural\",\"propsubtype\":\"AGRICULTURE / FARMING\",\"proptype\":\"FARMS\",\"propertyType\":\"FARM (IRRIGATED OR DRY)\",\"propLandUse\":\"FARMS\",\"propIndicator\":\"70\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"BUILDING SQFT\"},\"rooms\":{},\"interior\":{},\"parking\":{},\"summary\":{}},\"rentalAvm\":{\"estimatedRentalValue\":0,\"estimatedMinRentalValue\":0,\"estimatedMaxRentalValue\":0},\"assessment\":{\"assessed\":{\"assdttlvalue\":68306},\"market\":{\"mktttlvalue\":204918}},\"owner\":{\"owner1\":{\"fullname\":\"HENNING & STOLL FARMS LLC\",\"lastname\":\"HENNING & STOLL FARMS LLC \"},\"owner2\":{},\"owner3\":{},\"owner4\":{},\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"9582 S FAIRWAY CIR, FRANKLIN, WI 53132-8851\"},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"}},{\"identifier\":{\"Id\":173193828,\"fips\":\"17113\",\"apn\":\"04-14-100-003\",\"attomId\":173193828},\"lot\":{\"lotsize1\":50.0,\"lotsize2\":2178000},\"area\":{\"countrysecsubd\":\"McLean\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C031\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.721923\",\"longitude\":\"-88.617494\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"29a123c12ed4d6b0b2786efb6530e7c9\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Agricultural\",\"propsubtype\":\"AGRICULTURE / FARMING\",\"proptype\":\"FARMS\",\"propertyType\":\"FARM (IRRIGATED OR DRY)\",\"propLandUse\":\"FARMS\",\"propIndicator\":\"70\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"BUILDING SQFT\"},\"rooms\":{},\"interior\":{},\"parking\":{},\"summary\":{}},\"rentalAvm\":{\"estimatedRentalValue\":0,\"estimatedMinRentalValue\":0,\"estimatedMaxRentalValue\":0},\"assessment\":{\"assessed\":{\"assdttlvalue\":22762},\"market\":{\"mktttlvalue\":68286}},\"owner\":{\"owner1\":{\"fullname\":\"E HUGH HENNING\",\"lastname\":\"HENNING \",\"firstnameandmi\":\"E HUGH \"},\"owner2\":{\"fullname\":\"MARIAN J HENNING\",\"lastname\":\"HENNING \",\"firstnameandmi\":\"MARIAN J\"},\"owner3\":{\"fullname\":\"E HUGH HENNING AND MARIAN J HENNING\",\"lastname\":\"E HUGH HENNING AND MARIAN J HENNING \"},\"owner4\":{},\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"9582 S FAIRWAY CIR, FRANKLIN, WI 53132-8851\"},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"}},{\"identifier\":{\"Id\":173416858,\"fips\":\"17113\",\"apn\":\"03-15-400-001\",\"attomId\":173416858},\"lot\":{\"lotsize1\":102.9,\"lotsize2\":4482324},\"area\":{\"countrysecsubd\":\"McLean\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C001\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.716193\",\"longitude\":\"-88.743656\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, PL1712931, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"5ee429c51dd1f7d069f007b4188785ba\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Agricultural\",\"propsubtype\":\"AGRICULTURE / FARMING\",\"proptype\":\"FARMS\",\"propertyType\":\"FARM (IRRIGATED OR DRY)\",\"propLandUse\":\"FARMS\",\"propIndicator\":\"70\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"BUILDING SQFT\"},\"rooms\":{},\"interior\":{},\"parking\":{},\"summary\":{}},\"rentalAvm\":{\"estimatedRentalValue\":0,\"estimatedMinRentalValue\":0,\"estimatedMaxRentalValue\":0},\"assessment\":{\"assessed\":{\"assdttlvalue\":47877},\"market\":{\"mktttlvalue\":143631}},\"owner\":{\"owner1\":{\"fullname\":\"NANCY JO FINFROCK\",\"lastname\":\"FINFROCK \",\"firstnameandmi\":\"NANCY JO\"},\"owner2\":{},\"owner3\":{\"fullname\":\"THE FINFROCK FARM TRUST\",\"lastname\":\"THE FINFROCK FARM TRUST \"},\"owner4\":{},\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"1208 EDGEVIEW DR, MAHOMET, IL 61853-8999\"},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"}},{\"identifier\":{\"Id\":175204262,\"fips\":\"17113\",\"apn\":\"03-02-427-003\",\"attomId\":175204262},\"lot\":{\"lotsize1\":0.4,\"lotsize2\":17424},\"area\":{\"countrysecsubd\":\"McLean\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C002\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.747860\",\"longitude\":\"-88.720976\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, PL1712931, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"5ee429c51dd1f7d069f007b4188785ba\",\"PL\":\"eb9e46e9c2d26e33fe55f86f6eae48b4\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Vacant\",\"propsubtype\":\"Residential\",\"proptype\":\"RESIDENTIAL - VACANT LAND\",\"propertyType\":\"RESIDENTIAL - VACANT LAND\",\"propLandUse\":\"RESIDENTIAL - VACANT LAND\",\"propIndicator\":\"80\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"LIVING SQFT\"},\"rooms\":{},\"interior\":{},\"parking\":{},\"summary\":{}},\"rentalAvm\":{\"estimatedRentalValue\":0,\"estimatedMinRentalValue\":0,\"estimatedMaxRentalValue\":0},\"assessment\":{\"assessed\":{\"assdttlvalue\":2551},\"market\":{\"mktttlvalue\":7653,\"mktlandvalue\":7653}},\"owner\":{\"owner1\":{\"fullname\":\"MERRITT L THOMPSON\",\"lastname\":\"THOMPSON \",\"firstnameandmi\":\"MERRITT L\"},\"owner2\":{\"fullname\":\"MERRITT SANDY THOMPSON\",\"lastname\":\"THOMPSON \",\"firstnameandmi\":\"MERRITT SANDY\"},\"owner3\":{},\"owner4\":{},\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"318 N LETCHER ST, CHENOA, IL 61726-1062\"},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"}},{\"identifier\":{\"Id\":175206670,\"fips\":\"17113\",\"apn\":\"03-02-476-005\",\"attomId\":175206670},\"lot\":{\"lotsize1\":0.1100092,\"lotsize2\":4792},\"area\":{\"countrysecsubd\":\"McLean\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C002\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.744797\",\"longitude\":\"-88.722425\",\"distance\":0.0,\"geoid\":\"CO17113, CS1712944, DB1700005, PL1712931, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"5ee429c51dd1f7d069f007b4188785ba\",\"PL\":\"eb9e46e9c2d26e33fe55f86f6eae48b4\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Vacant\",\"propsubtype\":\"Residential\",\"proptype\":\"RESIDENTIAL - VACANT LAND\",\"propertyType\":\"RESIDENTIAL - VACANT LAND\",\"propLandUse\":\"RESIDENTIAL - VACANT LAND\",\"propIndicator\":\"80\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"LIVING SQFT\"},\"rooms\":{},\"interior\":{},\"parking\":{},\"summary\":{}},\"rentalAvm\":{\"estimatedRentalValue\":0,\"estimatedMinRentalValue\":0,\"estimatedMaxRentalValue\":0},\"assessment\":{\"assessed\":{\"assdttlvalue\":1983},\"market\":{\"mktttlvalue\":5949,\"mktlandvalue\":5949}},\"owner\":{\"owner1\":{\"fullname\":\"LAURA M FERGUSON\",\"lastname\":\"FERGUSON \",\"firstnameandmi\":\"LAURA M\"},\"owner2\":{},\"owner3\":{\"fullname\":\"JOHN D CORRIE\",\"lastname\":\"CORRIE \",\"firstnameandmi\":\"JOHN D\"},\"owner4\":{},\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"204 E MILL ST, CHENOA, IL 61726-1155\"},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"}}]}', 'success', NULL, '2024-05-16 13:49:33', '2024-05-16 13:49:34'),
(243, 1, 2, 'home-detail', 'user', '/valuation/rentalavm', 'https://api.gateway.attomdata.com/propertyapi/v1.0.0/valuation/rentalavm?address1=4529+Winona+Court&address2=Denver%2C+CO', '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"6c6f18fc495d516d10a094aaf020367a\",\"attomId\":184713191},\"property\":[{\"identifier\":{\"Id\":184713191,\"fips\":\"08031\",\"apn\":\"02192-04-018-000\",\"attomId\":184713191},\"lot\":{\"lotsize1\":0.1076676,\"lotsize2\":4690},\"area\":{\"countrysecsubd\":\"Denver\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"CO\",\"line1\":\"4529 WINONA CT\",\"line2\":\"DENVER, CO 80212\",\"locality\":\"DENVER\",\"matchCode\":\"ExaStr\",\"oneLine\":\"4529 WINONA CT, DENVER, CO 80212\",\"postal1\":\"80212\",\"postal2\":\"2512\",\"postal3\":\"C037\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"39.778926\",\"longitude\":\"-105.047775\",\"distance\":0.0,\"geoid\":\"CO08031, CS0891007, DB0803360, ND0000119198, ND0004861239, PL0820000, SB0000076114, SB0000076155, SB0000076161, SB0000135819, SB0000143772, ZI80212\",\"geoIdV4\":{\"CO\":\"1291dc1937525d78f89cebb6a43a50de\",\"CS\":\"4c0507d0d7894d2d48e4e03e1c0240fc\",\"DB\":\"d8ca7ea08abbe9efdd7e3b78f23d120e\",\"N1\":\"b26d02d9330761156fc0cfd4ed8bf9a1\",\"N2\":\"27e220314436f6edd5e606ddcd28156d\",\"PL\":\"7de845f7ba9b234a2c5adfca1db76c64\",\"SB\":\"9e0b497fb1337405c4dfe64e51568f68, 3b4cd5c56026e2e1f0e5c553b74cf05d, 93e5fef8956253c5642a335fc4a4395f, 3d0771574d56c6eae9184bc5aa3ebe19, 8a506b574561c5bab4f163492c7a386a\",\"ZI\":\"0149d0a55ef2d6b71071a39f4e13d6eb\"}},\"summary\":{\"absenteeInd\":\"OWNER OCCUPIED\",\"propclass\":\"Single Family Residence / Townhouse\",\"propsubtype\":\"Residential\",\"proptype\":\"SFR\",\"propertyType\":\"SINGLE FAMILY RESIDENCE\",\"yearbuilt\":1900,\"propLandUse\":\"SFR\",\"propIndicator\":\"10\"},\"utilities\":{\"heatingfuel\":\"GAS\",\"heatingtype\":\"CENTRAL\"},\"building\":{\"size\":{\"bldgsize\":934,\"grosssize\":1414,\"grosssizeadjusted\":934,\"groundfloorsize\":934,\"livingsize\":934,\"sizeInd\":\"LIVING SQFT\",\"universalsize\":934},\"rooms\":{\"bathstotal\":1.0,\"beds\":2,\"roomsTotal\":5},\"interior\":{\"bsmtsize\":480,\"fplccount\":1,\"fplcind\":\"Y\",\"fplctype\":\"YES\"},\"parking\":{\"prkgSize\":240,\"prkgType\":\"Garage, Detached\"},\"summary\":{\"levels\":1,\"unitsCount\":\"1\"}},\"rentalAvm\":{\"estimatedRentalValue\":3264,\"estimatedMinRentalValue\":2567,\"estimatedMaxRentalValue\":4368,\"valuationDate\":\"2024-04-22\"},\"assessment\":{\"assessed\":{\"assdttlvalue\":40770},\"market\":{\"mktttlvalue\":663500,\"mktlandvalue\":412000}},\"owner\":{\"owner1\":{\"fullname\":\"JENNIFER NICOLE GUBNER\",\"lastname\":\"GUBNER \",\"firstnameandmi\":\"JENNIFER NICOLE\"},\"owner2\":{},\"owner3\":{\"fullname\":\"SYBNEY FRANCES STENTO\",\"lastname\":\"STENTO \",\"firstnameandmi\":\"SYBNEY FRANCES\"},\"owner4\":{},\"absenteeownerstatus\":\"O\",\"mailingaddressoneline\":\"4529 WINONA CT, DENVER, CO 80212-2512\"},\"vintage\":{\"lastModified\":\"2024-04-23\",\"pubDate\":\"2024-04-23\"}}]}', 'success', NULL, '2024-05-17 03:16:14', '2024-05-17 03:16:14'),
(244, 1, 2, 'home-detail', 'user', '/valuation/rentalavm', 'https://api.gateway.attomdata.com/propertyapi/v1.0.0/valuation/rentalavm?address1=4529+Winona+Court&address2=Denver%2C+CO', '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"78e38c856081e9421589493f1fa3401a\",\"attomId\":184713191},\"property\":[{\"identifier\":{\"Id\":184713191,\"fips\":\"08031\",\"apn\":\"02192-04-018-000\",\"attomId\":184713191},\"lot\":{\"lotsize1\":0.1076676,\"lotsize2\":4690},\"area\":{\"countrysecsubd\":\"Denver\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"CO\",\"line1\":\"4529 WINONA CT\",\"line2\":\"DENVER, CO 80212\",\"locality\":\"DENVER\",\"matchCode\":\"ExaStr\",\"oneLine\":\"4529 WINONA CT, DENVER, CO 80212\",\"postal1\":\"80212\",\"postal2\":\"2512\",\"postal3\":\"C037\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"39.778926\",\"longitude\":\"-105.047775\",\"distance\":0.0,\"geoid\":\"CO08031, CS0891007, DB0803360, ND0000119198, ND0004861239, PL0820000, SB0000076114, SB0000076155, SB0000076161, SB0000135819, SB0000143772, ZI80212\",\"geoIdV4\":{\"CO\":\"1291dc1937525d78f89cebb6a43a50de\",\"CS\":\"4c0507d0d7894d2d48e4e03e1c0240fc\",\"DB\":\"d8ca7ea08abbe9efdd7e3b78f23d120e\",\"N1\":\"b26d02d9330761156fc0cfd4ed8bf9a1\",\"N2\":\"27e220314436f6edd5e606ddcd28156d\",\"PL\":\"7de845f7ba9b234a2c5adfca1db76c64\",\"SB\":\"9e0b497fb1337405c4dfe64e51568f68, 3b4cd5c56026e2e1f0e5c553b74cf05d, 93e5fef8956253c5642a335fc4a4395f, 3d0771574d56c6eae9184bc5aa3ebe19, 8a506b574561c5bab4f163492c7a386a\",\"ZI\":\"0149d0a55ef2d6b71071a39f4e13d6eb\"}},\"summary\":{\"absenteeInd\":\"OWNER OCCUPIED\",\"propclass\":\"Single Family Residence / Townhouse\",\"propsubtype\":\"Residential\",\"proptype\":\"SFR\",\"propertyType\":\"SINGLE FAMILY RESIDENCE\",\"yearbuilt\":1900,\"propLandUse\":\"SFR\",\"propIndicator\":\"10\"},\"utilities\":{\"heatingfuel\":\"GAS\",\"heatingtype\":\"CENTRAL\"},\"building\":{\"size\":{\"bldgsize\":934,\"grosssize\":1414,\"grosssizeadjusted\":934,\"groundfloorsize\":934,\"livingsize\":934,\"sizeInd\":\"LIVING SQFT\",\"universalsize\":934},\"rooms\":{\"bathstotal\":1.0,\"beds\":2,\"roomsTotal\":5},\"interior\":{\"bsmtsize\":480,\"fplccount\":1,\"fplcind\":\"Y\",\"fplctype\":\"YES\"},\"parking\":{\"prkgSize\":240,\"prkgType\":\"Garage, Detached\"},\"summary\":{\"levels\":1,\"unitsCount\":\"1\"}},\"rentalAvm\":{\"estimatedRentalValue\":3264,\"estimatedMinRentalValue\":2567,\"estimatedMaxRentalValue\":4368,\"valuationDate\":\"2024-04-22\"},\"assessment\":{\"assessed\":{\"assdttlvalue\":40770},\"market\":{\"mktttlvalue\":663500,\"mktlandvalue\":412000}},\"owner\":{\"owner1\":{\"fullname\":\"JENNIFER NICOLE GUBNER\",\"lastname\":\"GUBNER \",\"firstnameandmi\":\"JENNIFER NICOLE\"},\"owner2\":{},\"owner3\":{\"fullname\":\"SYBNEY FRANCES STENTO\",\"lastname\":\"STENTO \",\"firstnameandmi\":\"SYBNEY FRANCES\"},\"owner4\":{},\"absenteeownerstatus\":\"O\",\"mailingaddressoneline\":\"4529 WINONA CT, DENVER, CO 80212-2512\"},\"vintage\":{\"lastModified\":\"2024-04-23\",\"pubDate\":\"2024-04-23\"}}]}', 'success', NULL, '2024-05-17 03:27:20', '2024-05-17 03:27:20');

-- --------------------------------------------------------

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `position` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `title`, `subtitle`, `url`, `image`, `status`, `position`, `created_at`, `updated_at`) VALUES
(3, 'Never Miss a Refinance Opportunity Ever Again!!!', 'Get the best offers for your home refinancing needs', 'http://yahoo.com', 'eyJpdiI6IlZRUkNDd0R1a09GQXRnWmVyT1Z2U1E9PSIsInZhbHVlIjoiRERENGNpVDFxWHRwdG00UGpCTmN2Zz09IiwibWFjIjoiMjkwYjEzOTRhYTljMjk0ZWY3N2ExNmYxZDI2MTM5NzU0NmJmOWMwYzE5MTlhYTI0MmQyNzhlNjZlNThlY2I2ZSIsInRhZyI6IiJ9-gallery5.jpg', 1, 1, '2023-02-05 03:31:51', '2024-05-09 14:29:22');

-- --------------------------------------------------------

--
-- Table structure for table `contact_loan_officers`
--

CREATE TABLE `contact_loan_officers` (
  `id` bigint UNSIGNED NOT NULL,
  `officer_id` int NOT NULL,
  `user_id` int NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `home_sections`
--

CREATE TABLE `home_sections` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `position` int NOT NULL DEFAULT '0',
  `image_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_sections`
--

INSERT INTO `home_sections` (`id`, `title`, `content`, `url`, `image`, `status`, `position`, `image_position`, `created_at`, `updated_at`) VALUES
(1, 'About Loan Camp', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s</p>', NULL, 'eyJpdiI6Ii9nRGNSVFlsNFJ1Nko0blRwbll2Qmc9PSIsInZhbHVlIjoiQit2eDZlbTBkVzdGbFU5V3VzbWVIUT09IiwibWFjIjoiNTZiMDNlZDczMGYxZTY1MGZlMDk3YmRlMjcwOGM2ODFjMjlmNDU5N2U5ZmMwZjYxZTljNjAzYWNmMmRmOTJkNSIsInRhZyI6IiJ9-about2.jpg', 1, 1, 'left', '2023-02-05 04:39:40', '2023-02-05 05:07:58'),
(2, 'Never miss a refinancing window again.', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s,</p>', 'http://yahoo.com', 'eyJpdiI6IlBHVEJ4T2w1RHB4UCtITlZhaldnQkE9PSIsInZhbHVlIjoia0hINzVId0FqR3hXUllqZU5lTE1aUT09IiwibWFjIjoiYTVkZjc5NTBjNWNkMGJlN2RkNDc4Y2Q0NWUyMjY5YzQ4ZDVjMzc5MWZlYWQ3NGM4YzI4MDRhMDk1NjljOGFkZiIsInRhZyI6IiJ9-about.jpg', 1, 0, 'right', '2023-02-05 04:40:45', '2023-02-05 04:40:45'),
(4, 'Benefits of Loan Camp', '<ul><li>Mortgage payment and amortization calculator</li><li>Get a Rate Quote</li><li>List of all properties with loan details including current loan balance</li><li>Credit Score as input by the borrower along with the option to do a soft-pull</li><li>Estimated Home Value (Zillow and Xome api)</li><li>Option to edit the information and add new properties</li><li>Education - Mortgageblog.com RSS Feed</li></ul>', NULL, NULL, 1, 2, 'left', '2023-02-05 04:42:21', '2023-02-05 05:11:24');

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `loan_officer_notes`
--

CREATE TABLE `loan_officer_notes` (
  `id` bigint UNSIGNED NOT NULL,
  `officer_id` int NOT NULL,
  `property_id` int NOT NULL,
  `contact_id` int DEFAULT NULL,
  `note` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `priority` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `due_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `loan_officer_state_licenses`
--

CREATE TABLE `loan_officer_state_licenses` (
  `id` bigint UNSIGNED NOT NULL,
  `lo_id` int NOT NULL,
  `sl_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_01_31_180154_add_column_to_users_table', 2),
(6, '2023_01_31_180451_create_properties_table', 2),
(7, '2023_02_02_140848_create_admins_table', 3),
(9, '2023_02_04_220114_create_banners_table', 4),
(10, '2023_02_04_224806_create_abouts_table', 5),
(13, '2023_02_04_232957_create_home_sections_table', 6),
(16, '2023_02_07_141907_create_mortgage_information_table', 7),
(18, '2023_02_09_143309_create_atom_api_logs_table', 8),
(20, '2023_02_10_124054_add_column_to_properties_table', 9),
(21, '2023_02_14_164259_add_info_option_to_properties_table', 10),
(22, '2023_02_20_121723_add_property_type_other_to_properties_table', 11),
(23, '2023_02_23_145911_add_attomid_to_properties_table', 12),
(24, '2023_02_23_145936_create_property_nearby_schools_table', 12),
(25, '2023_02_23_145952_create_property_transport_noises_table', 12),
(26, '2023_02_26_052942_add_geoidv4_n1_to_properties_table', 13),
(27, '2023_02_26_053058_create_property_sales_trends_table', 14),
(28, '2023_03_02_132046_create_property_detail_mortgages_table', 15),
(29, '2023_03_02_132117_create_property_all_events_details_table', 15),
(32, '2023_03_09_135716_create_property_building_permits_table', 16),
(33, '2023_03_09_135736_create_property_detail_owners_table', 16),
(35, '2023_03_21_130825_create_opportunity_alerts_table', 17),
(36, '2023_03_30_085618_add_rate_to_opportunity_alerts_table', 18),
(37, '2023_04_11_144108_change_property_fields', 18),
(38, '2023_04_18_170611_create_contact_loan_officers_table', 18),
(39, '2023_04_21_153923_add_settings_to_users_table', 18),
(40, '2023_04_22_144931_add_index_to_mortgage_informations_table', 18),
(41, '2023_05_04_152308_add_assigned_to_to_properties_table', 18),
(42, '2023_05_05_150418_create_loan_officer_notes_table', 18),
(43, '2023_05_08_134500_add_mobile_to_admins_table', 18),
(44, '2023_05_09_140708_add_city_to_admins_table', 18),
(45, '2023_05_17_144716_add_twilio_sms_response_to_opportunity_alerts_table', 18),
(46, '2023_05_22_023817_add_column_to_loan_officer_notes_table', 18),
(47, '2023_07_02_163326_add_property_tax_to_properties_table', 18),
(48, '2023_07_03_152704_add_pdf_name_to_opportunity_alerts_table', 18),
(49, '2023_07_17_125403_change_new_rate_opportunity_alerts', 18),
(50, '2023_08_23_053943_create_neat_capital_responses_table', 18),
(51, '2023_08_23_065633_add_status_to_properties_table', 18),
(52, '2023_09_14_135154_add_columns_to_loan_officer_notes_table', 18),
(53, '2023_09_20_103822_create_state_licenses_table', 18),
(54, '2023_09_20_131619_create_loan_officer_state_licenses_table', 18),
(55, '2023_09_20_144103_add_loan_type_to_mortgage_information_table', 18),
(56, '2023_10_07_143721_create_jobs_table', 18),
(57, '2023_10_23_070710_create_property_rental_avms_table', 18),
(58, '2023_11_03_080733_change_current_interest_rate_mortgage_information', 18),
(59, '2023_11_03_125736_add_read_status_to_opportunity_alerts_table', 18),
(60, '2023_11_06_154550_add_deleted_at_to_properties_table', 18),
(61, '2023_11_07_130148_add_status_to_users_table', 18),
(62, '2024_01_09_113946_demo_form', 18),
(63, '2024_01_10_121807_create_privacies_table', 18),
(64, '2024_03_14_162437_add_message_to_contact_loan_officers_table', 18);

-- --------------------------------------------------------

--
-- Table structure for table `mortgage_information`
--

CREATE TABLE `mortgage_information` (
  `id` bigint UNSIGNED NOT NULL,
  `property_id` int NOT NULL,
  `user_id` int NOT NULL,
  `current_interest_rate` double DEFAULT NULL,
  `current_loan_balance` double DEFAULT NULL,
  `loan_term` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `loan_program` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `loan_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_loan_balance` double DEFAULT NULL,
  `pmi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mortgage_start_date` date DEFAULT NULL,
  `monthly_pmi_payment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `estimated_credit_score` double(8,2) DEFAULT NULL,
  `mortgage_statement` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mortgage_information`
--

INSERT INTO `mortgage_information` (`id`, `property_id`, `user_id`, `current_interest_rate`, `current_loan_balance`, `loan_term`, `loan_program`, `loan_type`, `original_loan_balance`, `pmi`, `mortgage_start_date`, `monthly_pmi_payment`, `estimated_credit_score`, `mortgage_statement`, `created_at`, `updated_at`) VALUES
(1, 6, 1, 1, 1000, 'Incidunt unde sequi', 'Irure minim et odio', NULL, NULL, 'Y', '1984-10-31', '9', NULL, 'CAXGBsPktGipsB8eAydeH7pvWbd4OGQyPEjUYD1v.xls', '2023-02-08 21:46:27', '2023-02-08 21:46:27'),
(2, 2, 1, 1, 1500, 'Incidunt unde sequi', 'Irure minim et odio', NULL, 1, 'Y', '1984-10-31', '1', 1.00, 'MRFn4uSrXUP7t7pYfGZwth3TgAJaDQdvfAMxsWCS.xls', '2023-02-13 19:04:47', '2023-02-15 16:24:54'),
(3, 8, 1, 1, 2000, 'Nulla dolor totam au', 'In nulla qui alias q', NULL, NULL, 'Y', '2023-02-13', '8', NULL, '', '2023-02-13 19:05:25', '2023-02-13 19:05:25'),
(4, 9, 1, 1, 154000, '359', '1', NULL, NULL, 'Y', '2007-03-21', '1', NULL, '', '2023-02-14 21:41:41', '2023-02-14 21:41:41'),
(5, 10, 1, 1, 1800, 'Nulla dolor totam au', 'In nulla qui alias q', NULL, NULL, 'Y', '2023-02-14', '1', NULL, '', '2023-02-14 21:44:51', '2023-02-14 21:44:51'),
(6, 11, 1, 1, 154000, '359', '1', NULL, NULL, 'Y', '2007-03-21', '1', NULL, '', '2023-02-16 18:47:28', '2023-02-16 18:47:28'),
(7, 12, 1, 1, 3000, 'Conventional', 'FHA', NULL, NULL, 'Y', '2023-02-20', '1', NULL, '', '2023-02-20 17:11:11', '2023-02-20 17:11:11'),
(8, 15, 5, 10, 2200, '120', 'Conventional', 'Fixed', 300, 'Y', '2024-05-13', '10.00', 20.00, NULL, '2024-05-13 10:32:00', '2024-05-13 10:32:00'),
(9, 19, 9, 10, 100000, '120', 'I don\'t know', 'Fixed', 100000, 'Y', '2023-05-02', '1000.00', 3.00, '', '2024-05-16 13:49:30', '2024-05-16 13:49:30');

-- --------------------------------------------------------

--
-- Table structure for table `neat_capital_responses`
--

CREATE TABLE `neat_capital_responses` (
  `id` bigint UNSIGNED NOT NULL,
  `term` int NOT NULL,
  `product` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` double(8,3) DEFAULT NULL,
  `apr` double(8,3) DEFAULT NULL,
  `points` double(8,3) DEFAULT NULL,
  `monthlyPayment` double(8,3) DEFAULT NULL,
  `totalCredits` double(8,3) DEFAULT NULL,
  `totalFees` double(8,3) DEFAULT NULL,
  `closingCosts` double(8,3) DEFAULT NULL,
  `ltv` double(8,3) DEFAULT NULL,
  `miType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `miPayment` double(8,3) DEFAULT NULL,
  `requiredAssets` double(15,3) DEFAULT NULL,
  `requiredIncomeFrontend` double(15,3) DEFAULT NULL,
  `effectiveDate` date DEFAULT NULL,
  `signUpUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `opportunity_alerts`
--

CREATE TABLE `opportunity_alerts` (
  `id` bigint UNSIGNED NOT NULL,
  `alert_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `property_id` int NOT NULL,
  `mortgage_id` int DEFAULT NULL,
  `current_estimated_home_value` double DEFAULT NULL,
  `current_loan_balance` double DEFAULT NULL,
  `occupancy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `property_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `email_sent` tinyint(1) NOT NULL DEFAULT '0',
  `sms_sent` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `new_rate` double DEFAULT NULL,
  `new_term` double(8,2) DEFAULT NULL,
  `new_loan_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twilio_sms_response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pdf_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read_status` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `opportunity_alerts`
--

INSERT INTO `opportunity_alerts` (`id`, `alert_type`, `user_id`, `property_id`, `mortgage_id`, `current_estimated_home_value`, `current_loan_balance`, `occupancy`, `property_type`, `other_info`, `email_sent`, `sms_sent`, `created_at`, `updated_at`, `new_rate`, `new_term`, `new_loan_type`, `twilio_sms_response`, `pdf_name`, `read_status`) VALUES
(7, 'remove_mortgage_insurance', 1, 2, 2, 519400, 1, NULL, NULL, '{\"address\":\"4529 Winona Court\",\"city\":\"Denver, CO\",\"zipcode\":\"12100\"}', 0, 0, '2023-03-21 18:07:01', '2024-05-17 03:40:11', NULL, NULL, NULL, NULL, NULL, 1),
(8, 'remove_mortgage_insurance', 1, 9, 4, 506200, 154000, NULL, NULL, '{\"address\":\"4500 Winona Court\",\"city\":\"Denver, CO\",\"zipcode\":\"80015\"}', 0, 0, '2023-03-21 18:07:01', '2024-05-17 03:15:03', NULL, NULL, NULL, NULL, NULL, 1),
(9, 'take_cash_out', 1, 2, 2, 519400, 1, 'Primary', 'Single Family', '{\"address\":\"4529 Winona Court\",\"city\":\"Denver, CO\",\"zipcode\":\"12100\",\"potential_cash_out_value\":415519}', 0, 0, '2023-03-21 18:07:01', '2023-03-21 18:07:01', NULL, NULL, NULL, NULL, NULL, 0),
(10, 'take_cash_out', 1, 9, 4, 506200, 154000, 'Vacation', 'Single Family', '{\"address\":\"4500 Winona Court\",\"city\":\"Denver, CO\",\"zipcode\":\"80015\",\"potential_cash_out_value\":225650}', 0, 0, '2023-03-21 18:07:01', '2023-03-21 18:07:01', NULL, NULL, NULL, NULL, NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `privacies`
--

CREATE TABLE `privacies` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `privacies`
--

INSERT INTO `privacies` (`id`, `title`, `image`, `content`, `meta_title`, `meta_keywords`, `meta_description`, `created_at`, `updated_at`) VALUES
(1, 'Privacy Policy', NULL, '<p>Privacy Policy.</p>', 'Privacy Policy', 'Privacy Policy', 'Privacy Policy', '2024-05-07 18:10:37', '2024-05-09 14:33:51');

-- --------------------------------------------------------

--
-- Table structure for table `properties`
--

CREATE TABLE `properties` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `zipcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `property_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occupancy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `number_of_bedrooms` int UNSIGNED DEFAULT NULL,
  `number_of_bathrooms` int UNSIGNED DEFAULT NULL,
  `size_sqft` int DEFAULT NULL,
  `current_estimated_home_value` double DEFAULT NULL,
  `estimated_home_equity` double DEFAULT NULL,
  `info_option` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `property_type_other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attomid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transportation_noise_summary` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `geoidv4_n1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assigned_to` int DEFAULT NULL,
  `property_tax` double DEFAULT NULL,
  `home_insurance` double DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `properties`
--

INSERT INTO `properties` (`id`, `user_id`, `address`, `city`, `state`, `zipcode`, `property_type`, `occupancy`, `created_at`, `updated_at`, `number_of_bedrooms`, `number_of_bathrooms`, `size_sqft`, `current_estimated_home_value`, `estimated_home_equity`, `info_option`, `property_type_other`, `attomid`, `transportation_noise_summary`, `geoidv4_n1`, `assigned_to`, `property_tax`, `home_insurance`, `status`, `deleted_at`) VALUES
(2, 1, '4529 Winona Court', 'Denver, CO', 'Haryana', '12100', 'Single Family', 'Primary', '2023-02-01 18:51:53', '2023-02-27 09:10:37', 2, 1, 934, 519400, 0, NULL, NULL, '184713191', 'Traffic noise is medium.  Also, there may be frequent ambulance traffic nearby.', 'b26d02d9330761156fc0cfd4ed8bf9a1', NULL, NULL, NULL, 1, NULL),
(3, 1, '4500 Winona Court', 'Denver, CO', '', '80015', 'Manufactured', 'Vacation', '2023-02-08 21:41:24', '2023-03-02 21:30:15', 2, 2, 812, 506200, 382735, NULL, NULL, '13657586', 'Traffic noise is medium.  Also, there may be frequent ambulance traffic nearby.', 'b26d02d9330761156fc0cfd4ed8bf9a1', NULL, NULL, NULL, 1, NULL),
(4, 1, 'Minim ad rerum conse', 'Voluptatibus soluta', '', '50729', 'Manufactured', 'Vacation', '2023-02-08 21:43:24', '2023-02-08 21:43:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(5, 1, 'Minim ad rerum conse', 'Voluptatibus soluta', '', '50729', 'Manufactured', 'Vacation', '2023-02-08 21:45:00', '2023-02-08 21:45:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(6, 1, 'Facere do harum in e', 'Eos quia officiis q', '', '43218', 'Town Home', 'Vacation', '2023-02-08 21:46:27', '2023-02-08 21:46:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(7, 1, 'Noida', 'Greater Noida West', '', '20101', 'Single Family', 'Primary', '2023-02-13 19:04:47', '2023-02-13 19:04:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(8, 1, 'Noida', 'Greater Noida West', '', '50729', 'Town Home', 'Primary', '2023-02-13 19:05:25', '2023-02-13 19:05:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(9, 1, '4500 Winona Court', 'Denver, CO', '', '80015', 'Single Family', 'Vacation', '2023-02-14 21:41:41', '2023-03-21 16:38:19', 2, 2, 812, 506200, NULL, NULL, NULL, '13657586', NULL, 'b26d02d9330761156fc0cfd4ed8bf9a1', NULL, NULL, NULL, 1, NULL),
(10, 1, 'sdfsdfs', 'Greater Noida West', '', '20100', 'Condo', 'Primary', '2023-02-14 21:44:51', '2023-02-14 21:44:51', NULL, NULL, NULL, NULL, NULL, 'ENTER_MANUALLY', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(11, 1, '4500 Winona Court1', 'Denver, CO', '', '80015', 'Town Home', 'Primary', '2023-02-16 18:47:28', '2023-02-16 18:47:28', NULL, NULL, NULL, NULL, NULL, 'ENTER_MANUALLY', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(12, 1, 'Test Address', 'Greater Noida West', '', '20102', 'Other', 'Vacation', '2023-02-20 17:11:11', '2023-02-20 17:20:11', NULL, NULL, NULL, NULL, NULL, 'ENTER_MANUALLY', 'OPT', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(13, 3, 'Noida', 'Greater Noida West', '', '20100', 'Other', 'Vacation', '2023-02-20 17:23:00', '2023-02-20 17:23:00', NULL, NULL, NULL, NULL, NULL, NULL, 'XXXXX1234', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(14, 4, 'tests', 'test', '', '70080', 'Single Family Residence', 'Primary Residence', '2024-05-13 07:15:53', '2024-05-13 07:16:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '251177', NULL, NULL, NULL, 1000, 1000, 1, NULL),
(15, 5, 'Alaska', 'Alasks', '', '56545', 'Single Family Residence', 'Primary Residence', '2024-05-13 10:29:10', '2024-05-13 10:29:40', NULL, NULL, 11874, NULL, NULL, NULL, NULL, '27489600', NULL, 'b6e319de42ce733bc8ece056227072f5', NULL, 1.11, 20, 1, NULL),
(16, 6, '7875 Cresmtont Ave', 'Newark', '', '94560', 'Single Family Residence', 'Primary Residence', '2024-05-13 15:27:29', '2024-05-13 15:27:59', 4, 3, 1761, 1429500, NULL, NULL, NULL, '34671462', NULL, '92598b4a8a5ab06190f399cd84e7015c', NULL, 12000, 1400, 1, NULL),
(17, 7, 'hj', 'Dodge City', '', '67801', 'Single Family Residence', 'Second Home', '2024-05-14 02:50:52', '2024-05-14 02:51:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '295062378', NULL, NULL, NULL, 1000, 1000, 1, NULL),
(18, 11, 'Testing', 'Test', '', '22312', 'Single Family Residence', 'Primary Residence', '2024-05-15 13:01:07', '2024-05-15 13:01:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '310553258', NULL, NULL, NULL, 7.12, 5000, 1, NULL),
(19, 9, 'Velacheri', 'chennai', '', '12345', 'Single Family Residence', 'Primary Residence', '2024-05-16 13:49:30', '2024-05-17 04:02:05', NULL, NULL, NULL, NULL, NULL, 'ENTER_MANUALLY', NULL, '15797493', NULL, NULL, NULL, 5000, 5000, 1, '2024-05-17 04:02:05');

-- --------------------------------------------------------

--
-- Table structure for table `property_all_events_details`
--

CREATE TABLE `property_all_events_details` (
  `id` bigint UNSIGNED NOT NULL,
  `property_id` int NOT NULL,
  `api_response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_all_events_details`
--

INSERT INTO `property_all_events_details` (`id`, `property_id`, `api_response`, `created_at`, `updated_at`) VALUES
(1, 3, '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"55bac7e4b8d3bc67f11f684fd1edb71b\"},\"property\":[{\"identifier\":{\"Id\":13657586,\"fips\":\"08031\",\"apn\":\"02192-03-015-000\",\"attomId\":13657586},\"lot\":{\"lotnum\":\"23,24\",\"lotsize1\":0.1434803,\"lotsize2\":6250,\"pooltype\":\"NO POOL\"},\"area\":{\"blockNum\":\"1-40\",\"loctype\":\"VIEW - NONE\",\"countrysecsubd\":\"Denver\",\"countyuse1\":\"113  \",\"muncode\":\"DE\",\"munname\":\"DENVER\",\"srvyRange\":\"68W\",\"srvySection\":\"19\",\"srvyTownship\":\"03S\",\"subdname\":\"BERKELEY\",\"taxcodearea\":\"DENV\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"CO\",\"line1\":\"4500 WINONA CT\",\"line2\":\"DENVER, CO 80212\",\"locality\":\"DENVER\",\"matchCode\":\"ExaStr\",\"oneLine\":\"4500 WINONA CT, DENVER, CO 80212\",\"postal1\":\"80212\",\"postal2\":\"2513\",\"postal3\":\"C037\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"39.778532\",\"longitude\":\"-105.047116\",\"distance\":0,\"geoid\":\"CO08031, CS0891007, DB0803360, ND0000119198, ND0004861239, PL0820000, SB0000076114, SB0000076155, SB0000076161, SB0000135819, SB0000143772, ZI80212\",\"geoIdV4\":{\"CO\":\"1291dc1937525d78f89cebb6a43a50de\",\"CS\":\"4c0507d0d7894d2d48e4e03e1c0240fc\",\"DB\":\"d8ca7ea08abbe9efdd7e3b78f23d120e\",\"N1\":\"b26d02d9330761156fc0cfd4ed8bf9a1\",\"N2\":\"27e220314436f6edd5e606ddcd28156d\",\"PL\":\"7de845f7ba9b234a2c5adfca1db76c64\",\"SB\":\"4287d95a26357a9a1474f9cb99e6e816,6dee2c66470af6400265dd11b87cdb7d,906cf6aada87fa5bad0a13f2f86ff5aa,b95eac0d6a8385db6771b9d54f2a6a1c,b9980ca738ece2e06f9086da927317fe\",\"ZI\":\"0149d0a55ef2d6b71071a39f4e13d6eb\"}},\"summary\":{\"absenteeInd\":\"OWNER OCCUPIED\",\"propclass\":\"Single Family Residence \\/ Townhouse\",\"propsubtype\":\"Residential\",\"proptype\":\"SFR\",\"yearbuilt\":1941,\"propLandUse\":\"SFR\",\"propIndicator\":\"10\",\"legal1\":\"BERKELEY B35 L23 & 24 EXC REAR 8FT TO CITY RESUB OF BLKS 1 TO 40\"},\"utilities\":{\"heatingfuel\":\"GAS\",\"heatingtype\":\"CENTRAL\"},\"building\":{\"size\":{\"bldgsize\":812,\"grosssize\":1624,\"grosssizeadjusted\":812,\"groundfloorsize\":812,\"livingsize\":812,\"sizeInd\":\"LIVING SQFT\",\"universalsize\":812},\"rooms\":{\"bathfixtures\":8,\"bathsfull\":2,\"bathstotal\":2,\"beds\":2,\"roomsTotal\":4},\"interior\":{\"bsmtsize\":812,\"bsmttype\":\"FINISHED\"},\"construction\":{\"condition\":\"AVERAGE\",\"constructiontype\":\"FRAME\",\"frameType\":\"WOOD\",\"wallType\":\"WOOD\"},\"parking\":{\"prkgSize\":640,\"prkgSpaces\":\"2\"},\"summary\":{\"archStyle\":\"OTHER\",\"levels\":1,\"quality\":\"HIGH QUALITY RESIDENTIAL\",\"unitsCount\":\"1\",\"view\":\"VIEW - NONE\",\"viewCode\":\"000\"}},\"vintage\":{\"lastModified\":\"2023-02-15\",\"pubDate\":\"2023-02-15\"},\"avm\":{\"eventDate\":\"2023-01-24\",\"amount\":{\"scr\":98,\"value\":736410,\"high\":751138,\"low\":721681,\"valueRange\":14728},\"AVMChange\":{\"avmlastmonthvalue\":702599,\"avmamountchange\":33811,\"avmpercentchange\":4},\"calculations\":{\"perSizeUnit\":906,\"ratioTaxAmt\":263.22,\"ratioTaxValue\":1,\"rangePctOfValue\":4},\"condition\":{\"avmpoorlow\":685596.95,\"avmpoorhigh\":713581.1,\"avmpoorscore\":93,\"avmgoodlow\":721681,\"avmgoodhigh\":751138,\"avmgoodscore\":98,\"avmexcellentlow\":739723.02,\"avmexcellenthigh\":769916.45,\"avmexcellentscore\":100.5}},\"sale\":{\"salesearchdate\":\"2007-03-21\",\"saleTransDate\":\"2007-02-01\",\"amount\":{\"saleamt\":220000,\"salecode\":\"SALE PRICE (FULL) Full sales price as per documents\",\"salerecdate\":\"2007-03-21\",\"saledisclosuretype\":0,\"saledocnum\":\"0000045666\",\"saletranstype\":\"Resale\"},\"calculation\":{\"priceperbed\":110000,\"pricepersizeunit\":270.94},\"interfamily\":\"N\",\"resaleornewconstruction\":\"M\",\"cashormortgagepurchase\":\"M\"},\"assessment\":{\"appraised\":{},\"assessed\":{\"assdimprpersizeunit\":6.07,\"assdimprvalue\":4930,\"assdlandpersizeunit\":5,\"assdlandvalue\":31270,\"assdttlpersizeunit\":44.58,\"assdttlvalue\":36200},\"calculations\":{\"calcimprind\":\"ASSESSED VALUE\",\"calcimprpersizeunit\":6.07,\"calcimprvalue\":4930,\"calclandind\":\"ASSESSED VALUE\",\"calclandpersizeunit\":5,\"calclandvalue\":31270,\"calcttlind\":\"ASSESSED VALUE\",\"calcttlvalue\":36200,\"calcvaluepersizeunit\":44.58},\"market\":{\"mktimprvalue\":68900,\"mktlandvalue\":437300,\"mktttlvalue\":506200},\"tax\":{\"taxamt\":2797.7,\"taxpersizeunit\":3.45,\"taxyear\":2022}}}]}', '2023-03-02 21:21:04', '2023-03-02 21:21:04'),
(3, 2, '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"7ea8ab35420f09e0b0534d675c6b5e84\"},\"property\":[{\"identifier\":{\"Id\":184713191,\"fips\":\"08031\",\"apn\":\"02192-04-018-000\",\"attomId\":184713191},\"lot\":{\"lotnum\":\"31,32\",\"lotsize1\":0.1076676,\"lotsize2\":4690,\"pooltype\":\"NO POOL\"},\"area\":{\"blockNum\":\"36\",\"loctype\":\"VIEW - NONE\",\"countrysecsubd\":\"Denver\",\"countyuse1\":\"113  \",\"muncode\":\"DE\",\"munname\":\"DENVER\",\"srvyRange\":\"68W\",\"srvySection\":\"19\",\"srvyTownship\":\"03S\",\"subdname\":\"BERKELEY\",\"taxcodearea\":\"DENV\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"CO\",\"line1\":\"4529 WINONA CT\",\"line2\":\"DENVER, CO 80212\",\"locality\":\"DENVER\",\"matchCode\":\"ExaStr\",\"oneLine\":\"4529 WINONA CT, DENVER, CO 80212\",\"postal1\":\"80212\",\"postal2\":\"2512\",\"postal3\":\"C037\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"39.778926\",\"longitude\":\"-105.047775\",\"distance\":0,\"geoid\":\"CO08031, CS0891007, DB0803360, ND0000119198, ND0004861239, PL0820000, SB0000076114, SB0000076155, SB0000076161, SB0000135819, SB0000143772, ZI80212\",\"geoIdV4\":{\"CO\":\"1291dc1937525d78f89cebb6a43a50de\",\"CS\":\"4c0507d0d7894d2d48e4e03e1c0240fc\",\"DB\":\"d8ca7ea08abbe9efdd7e3b78f23d120e\",\"N1\":\"b26d02d9330761156fc0cfd4ed8bf9a1\",\"N2\":\"27e220314436f6edd5e606ddcd28156d\",\"PL\":\"7de845f7ba9b234a2c5adfca1db76c64\",\"SB\":\"4287d95a26357a9a1474f9cb99e6e816,6dee2c66470af6400265dd11b87cdb7d,906cf6aada87fa5bad0a13f2f86ff5aa,b95eac0d6a8385db6771b9d54f2a6a1c,b9980ca738ece2e06f9086da927317fe\",\"ZI\":\"0149d0a55ef2d6b71071a39f4e13d6eb\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Single Family Residence \\/ Townhouse\",\"propsubtype\":\"Residential\",\"proptype\":\"SFR\",\"yearbuilt\":1900,\"propLandUse\":\"SFR\",\"propIndicator\":\"10\",\"legal1\":\"BERKELEY B36 L31 & S\\/2 OF L32 EXC REAR 8FT TO CITY\"},\"utilities\":{\"heatingfuel\":\"GAS\",\"heatingtype\":\"CENTRAL\"},\"building\":{\"size\":{\"bldgsize\":934,\"grosssize\":1414,\"grosssizeadjusted\":934,\"groundfloorsize\":934,\"livingsize\":934,\"sizeInd\":\"LIVING SQFT\",\"universalsize\":934},\"rooms\":{\"bathfixtures\":5,\"bathsfull\":1,\"bathstotal\":1,\"beds\":2,\"roomsTotal\":5},\"interior\":{\"bsmtsize\":480,\"fplccount\":1,\"fplcind\":\"Y\",\"fplctype\":\"YES\"},\"construction\":{\"condition\":\"GOOD\",\"wallType\":\"BRICK\"},\"parking\":{\"prkgSize\":240,\"prkgSpaces\":\"1\"},\"summary\":{\"archStyle\":\"OTHER\",\"levels\":1,\"quality\":\"HIGH QUALITY RESIDENTIAL\",\"unitsCount\":\"1\",\"view\":\"VIEW - NONE\",\"viewCode\":\"000\",\"yearbuilteffective\":2014}},\"vintage\":{\"lastModified\":\"2023-02-15\",\"pubDate\":\"2023-02-15\"},\"avm\":{\"eventDate\":\"2023-01-24\",\"amount\":{\"scr\":98,\"value\":755614,\"high\":770726,\"low\":740501,\"valueRange\":15112},\"AVMChange\":{\"avmlastmonthvalue\":721127,\"avmamountchange\":34487,\"avmpercentchange\":4},\"calculations\":{\"perSizeUnit\":809,\"ratioTaxAmt\":263.2,\"ratioTaxValue\":1,\"rangePctOfValue\":4},\"condition\":{\"avmpoorlow\":703475.95,\"avmpoorhigh\":732189.7,\"avmpoorscore\":93,\"avmgoodlow\":740501,\"avmgoodhigh\":770726,\"avmgoodscore\":98,\"avmexcellentlow\":759013.52,\"avmexcellenthigh\":789994.15,\"avmexcellentscore\":100.5}},\"sale\":{\"salesearchdate\":\"2021-06-29\",\"saleTransDate\":\"2021-06-28\",\"amount\":{\"salerecdate\":\"2021-06-29\",\"saledisclosuretype\":0,\"saledocnum\":\"0000123161\",\"saletranstype\":\"Resale\"},\"calculation\":{},\"interfamily\":\"N\",\"resaleornewconstruction\":\"M\",\"cashormortgagepurchase\":\"C\"},\"assessment\":{\"appraised\":{},\"assessed\":{\"assdimprpersizeunit\":15.24,\"assdimprvalue\":14230,\"assdlandpersizeunit\":4.88,\"assdlandvalue\":22910,\"assdttlpersizeunit\":39.76,\"assdttlvalue\":37140},\"calculations\":{\"calcimprind\":\"ASSESSED VALUE\",\"calcimprpersizeunit\":15.24,\"calcimprvalue\":14230,\"calclandind\":\"ASSESSED VALUE\",\"calclandpersizeunit\":4.88,\"calclandvalue\":22910,\"calcttlind\":\"ASSESSED VALUE\",\"calcttlvalue\":37140,\"calcvaluepersizeunit\":39.76},\"market\":{\"mktimprvalue\":199000,\"mktlandvalue\":320400,\"mktttlvalue\":519400},\"tax\":{\"taxamt\":2870.88,\"taxpersizeunit\":3.07,\"taxyear\":2022}}}]}', '2023-03-02 22:36:44', '2023-03-02 22:37:06'),
(4, 14, '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"8b9aa173dacacc4b7fe616706fa853bf\",\"attomId\":251177},\"property\":[{\"identifier\":{\"Id\":251177,\"fips\":\"48021\",\"apn\":\"R25324\",\"attomId\":251177},\"lot\":{\"lotnum\":\"7\",\"lotsize1\":0.58000459999999998128572542555048130452632904052734375,\"lotsize2\":25265,\"pooltype\":\"NO POOL\"},\"area\":{\"loctype\":\"VIEW - NONE\",\"countrysecsubd\":\"Bastrop\",\"countyuse1\":\"C3   \",\"muncode\":\"BA\",\"munname\":\"BASTROP\",\"subdname\":\"AUSTIN, STEPHEN F\",\"taxcodearea\":\"ESD2,G01,RD1,S04\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"TX\",\"line2\":\", TX \",\"matchCode\":\"ExaStr\",\"oneLine\":\", , TX \",\"postal1\":\"\",\"postal2\":\"\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"30.151587\",\"longitude\":\"-97.316112\",\"distance\":0,\"geoid\":\"CO48021\",\"geoIdV4\":{\"CO\":\"88c0c2fbc60666aafc1e324b330fb897\",\"CS\":\"62bce7e8224dae2d67af7ac014dc4a2e\",\"DB\":\"b44e02e7093843c0b7b3cc5196c18db8\",\"PL\":\"e5e7a6beee5b76cb9e1f818f41486238\",\"SB\":\"cc0728e53728624a8450f6f21073b31c, 7e08434bce8dc69d7190f0b0d7838e55, 9d770f09d5ba1683031a58839166ec94, c9723125843646b84045781b2671eb5d\",\"ZI\":\"0e11b022df6f7bd5bc152421c599e417\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Vacant\",\"propsubtype\":\"PUBLIC WORKS\",\"proptype\":\"RECREATIONAL ACREAGE\",\"propertyType\":\"RECREATIONAL - VACANT LAND\",\"propLandUse\":\"RECREATIONAL ACREAGE\",\"propIndicator\":\"80\",\"legal1\":\"A3 AUSTIN, STEPHEN F., ACRES 0.58, (SHADOW OAKS, LOT 7)\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"BUILDING SQFT\"},\"rooms\":{},\"interior\":{},\"construction\":{},\"parking\":{},\"summary\":{\"view\":\"VIEW - NONE\",\"viewCode\":\"000\"}},\"vintage\":{\"lastModified\":\"2023-11-07\",\"pubDate\":\"2023-11-07\"},\"avm\":{\"amount\":{\"scr\":0,\"high\":0,\"low\":0},\"AVMChange\":{},\"calculations\":{},\"condition\":{\"avmpoorlow\":0,\"avmpoorhigh\":0,\"avmgoodlow\":0,\"avmgoodhigh\":0,\"avmexcellentlow\":0,\"avmexcellenthigh\":0}},\"sale\":{\"salesearchdate\":\"2011-08-12\",\"saleTransDate\":\"2011-07-20\",\"amount\":{\"salerecdate\":\"2011-08-12\",\"saledisclosuretype\":1,\"saledocnum\":\"002087\\/271\",\"saletranstype\":\"Resale\"},\"calculation\":{},\"interfamily\":\"N\",\"resaleornewconstruction\":\"M\",\"cashormortgagepurchase\":\"C\"},\"assessment\":{\"appraised\":{},\"assessed\":{\"assdlandpersizeunit\":2.189999999999999946709294817992486059665679931640625,\"assdlandvalue\":55355,\"assdttlvalue\":55355},\"calculations\":{\"calcimprind\":\"ASSESSED VALUE\",\"calclandind\":\"ASSESSED VALUE\",\"calclandpersizeunit\":2.189999999999999946709294817992486059665679931640625,\"calclandvalue\":55355,\"calcttlind\":\"ASSESSED VALUE\",\"calcttlvalue\":55355},\"market\":{\"mktlandvalue\":55355,\"mktttlvalue\":55355},\"tax\":{\"taxyear\":2022}}}]}', '2024-05-13 07:16:20', '2024-05-13 07:16:20'),
(5, 15, '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"d3ac837fc0f27559ce0c722dedc146dc\",\"attomId\":27489600},\"property\":[{\"identifier\":{\"Id\":27489600,\"fips\":\"02020\",\"apn\":\"004-082-05-000\",\"attomId\":27489600},\"lot\":{\"lotnum\":\"11\",\"lotsize1\":0.51652889999999995751522874343208968639373779296875,\"lotsize2\":22500,\"pooltype\":\"NO POOL\"},\"area\":{\"blockNum\":\"7\",\"loctype\":\"VIEW - NONE\",\"countrysecsubd\":\"Anchorage\",\"countyuse1\":\"339-C\",\"muncode\":\"AN\",\"munname\":\"ANCHORAGE\",\"subdname\":\"ALASKA INDUSTRIAL\",\"taxcodearea\":\"1\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"AK\",\"line2\":\", AK \",\"matchCode\":\"ExaStr\",\"oneLine\":\", , AK \",\"postal1\":\"\",\"postal2\":\"\",\"postal3\":\"C044\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"61.220407\",\"longitude\":\"-149.821488\",\"distance\":0,\"geoid\":\"CO02020, CS0203050, DB0200180, ND0000281249, PL0203000, SB0000065442, SB0000065452, SB0000065489, ZI99501\",\"geoIdV4\":{\"CO\":\"a593655c66bd715b32d1a9cc5e2eb33b\",\"CS\":\"6b6f2cbc05bad3858cad6f585700ce31\",\"DB\":\"e1f8e693e827aeaddc9ea2e6d6f53d81\",\"N2\":\"b6e319de42ce733bc8ece056227072f5\",\"PL\":\"c127a45071c86bbb01402cba330a303a\",\"SB\":\"52f551615024cad056becddf3c69db93, 42ee5db10d89ba3bd194161fdf8d4bac, 987c7d20c481928cca6c8e29d5fa5979\",\"ZI\":\"6ba73eff04b79f272dfa532fe99bbc39\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Parking\",\"propsubtype\":\"Commercial\",\"proptype\":\"PARKING LOT\",\"yearbuilt\":1959,\"propertyType\":\"PARKING LOT\",\"propLandUse\":\"PARKING LOT\",\"propIndicator\":\"31\",\"legal1\":\"ALASKA INDUSTRIAL BLK 7 LT 11\"},\"utilities\":{\"coolingtype\":\"NONE\",\"sewertype\":\"MUNICIPAL\",\"watertype\":\"COMMERCIAL\"},\"building\":{\"size\":{\"bldgsize\":11874,\"grosssize\":11874,\"grosssizeadjusted\":11874,\"livingsize\":11874,\"sizeInd\":\"BUILDING SQFT\",\"universalsize\":11874},\"rooms\":{},\"interior\":{},\"construction\":{\"condition\":\"AVERAGE\",\"wallType\":\"CONCRETE BLOCK\"},\"parking\":{},\"summary\":{\"bldgsNum\":1,\"bldgType\":\"COMMERCIAL\",\"imprType\":\"COMMERCIAL\",\"quality\":\"GOOD\",\"storyDesc\":\"COMMERCIAL\",\"view\":\"VIEW - NONE\",\"viewCode\":\"000\"}},\"vintage\":{\"lastModified\":\"2023-11-02\",\"pubDate\":\"2023-11-02\"},\"avm\":{\"amount\":{\"scr\":0,\"high\":0,\"low\":0},\"AVMChange\":{},\"calculations\":{},\"condition\":{\"avmpoorlow\":0,\"avmpoorhigh\":0,\"avmgoodlow\":0,\"avmgoodhigh\":0,\"avmexcellentlow\":0,\"avmexcellenthigh\":0}},\"sale\":{\"salesearchdate\":\"2008-06-30\",\"saleTransDate\":\"2008-06-26\",\"amount\":{\"salerecdate\":\"2008-06-30\",\"saledisclosuretype\":1,\"saledoctype\":\"DEED\",\"saledocnum\":\"0000038208\",\"saletranstype\":\"Resale\"},\"calculation\":{},\"interfamily\":\"N\",\"resaleornewconstruction\":\"M\",\"cashormortgagepurchase\":\"C\"},\"assessment\":{\"appraised\":{},\"assessed\":{\"assdimprpersizeunit\":0.270000000000000017763568394002504646778106689453125,\"assdimprvalue\":3200,\"assdlandpersizeunit\":19.07000000000000028421709430404007434844970703125,\"assdlandvalue\":429000,\"assdttlpersizeunit\":36.39999999999999857891452847979962825775146484375,\"assdttlvalue\":432200},\"calculations\":{\"calcimprind\":\"MARKET VALUE\",\"calcimprpersizeunit\":0.270000000000000017763568394002504646778106689453125,\"calcimprvalue\":3200,\"calclandind\":\"MARKET VALUE\",\"calclandpersizeunit\":19.07000000000000028421709430404007434844970703125,\"calclandvalue\":429000,\"calcttlind\":\"MARKET VALUE\",\"calcttlvalue\":432200,\"calcvaluepersizeunit\":36.39999999999999857891452847979962825775146484375},\"market\":{\"mktimprvalue\":3200,\"mktlandvalue\":429000,\"mktttlvalue\":432200},\"tax\":{\"taxamt\":7360.3699999999998908606357872486114501953125,\"taxpersizeunit\":0.61999999999999999555910790149937383830547332763671875,\"taxyear\":2023}}}]}', '2024-05-13 10:29:41', '2024-05-13 10:29:41'),
(6, 16, '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"e983b468e683c5636bfbc690c8f5f229\",\"attomId\":34671462},\"property\":[{\"identifier\":{\"Id\":34671462,\"fips\":\"06001\",\"apn\":\"92A-513-48\",\"attomId\":34671462},\"lot\":{\"lotsize1\":0.21809000000000000607514039074885658919811248779296875,\"lotsize2\":9500,\"poolind\":\"YES\"},\"area\":{\"loctype\":\"VIEW - NONE\",\"countrysecsubd\":\"Alameda\",\"countyuse1\":\"1100 \",\"muncode\":\"AL\",\"munname\":\"ALAMEDA\",\"subdname\":\"2298\",\"taxcodearea\":\"11-010\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"CA\",\"line1\":\"7875 CRESTMONT AVE\",\"line2\":\"NEWARK, CA 94560\",\"locality\":\"NEWARK\",\"matchCode\":\"ExaStr\",\"oneLine\":\"7875 CRESTMONT AVE, NEWARK, CA 94560\",\"postal1\":\"94560\",\"postal2\":\"1521\",\"postal3\":\"C019\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"37.535704\",\"longitude\":\"-122.055285\",\"distance\":0,\"geoid\":\"CO06001, CS0691070, ND0000018013, PL0650916, SB0000072222, SB0000072223, SB0000072228, ZI94560\",\"geoIdV4\":{\"CO\":\"1f38d16644cb82edb00a245a91495bfe\",\"CS\":\"12745abe42e4008071cc2fa66708b0ea\",\"DB\":\"f94a2ad0c88d2bc4700bae6880f32e98\",\"N2\":\"92598b4a8a5ab06190f399cd84e7015c\",\"PL\":\"83ce8c0b07633c4aaf150c0ed15e80fb\",\"SB\":\"d4e6c47aaccd4d38f33485844f8a1371, b501ca76d484afc479ea00e25cf2a915, 117cf3acc7e693722ef0b02f66c53477\",\"ZI\":\"a4b87282a8f60c3cea34de0725488a0c\"}},\"summary\":{\"absenteeInd\":\"OWNER OCCUPIED\",\"propclass\":\"Single Family Residence \\/ Townhouse\",\"propsubtype\":\"Residential\",\"proptype\":\"SFR\",\"yearbuilt\":1968,\"propertyType\":\"SINGLE FAMILY RESIDENCE\",\"propLandUse\":\"SFR\",\"propIndicator\":\"10\",\"legal1\":\"TR 2298\"},\"utilities\":{},\"building\":{\"size\":{\"bldgsize\":1761,\"grosssize\":1761,\"grosssizeadjusted\":1761,\"livingsize\":1761,\"sizeInd\":\"LIVING SQFT\",\"universalsize\":1761},\"rooms\":{\"bathsfull\":3,\"bathstotal\":3,\"beds\":4,\"roomsTotal\":8},\"interior\":{},\"construction\":{\"constructiontype\":\"WOOD\",\"frameType\":\"WOOD\"},\"parking\":{\"prkgSpaces\":\"2\"},\"summary\":{\"archStyle\":\"OTHER\",\"bldgsNum\":1,\"levels\":1,\"quality\":\"AVERAGE\",\"view\":\"VIEW - NONE\",\"viewCode\":\"000\",\"yearbuilteffective\":1969}},\"vintage\":{\"lastModified\":\"2023-09-28\",\"pubDate\":\"2023-09-28\"},\"avm\":{\"eventDate\":\"2024-04-26\",\"amount\":{\"scr\":98,\"value\":1429500,\"high\":1458090,\"low\":1400910,\"valueRange\":28590},\"AVMChange\":{\"avmlastmonthvalue\":1369750,\"avmamountchange\":59750,\"avmpercentchange\":4},\"calculations\":{\"perSizeUnit\":811,\"ratioTaxAmt\":156.090000000000003410605131648480892181396484375,\"rangePctOfValue\":4},\"condition\":{\"avmpoorlow\":1330864.5,\"avmpoorhigh\":1385185.5,\"avmgoodlow\":1400910,\"avmgoodhigh\":1458090,\"avmexcellentlow\":1435932.75,\"avmexcellenthigh\":1494542.25}},\"sale\":{\"salesearchdate\":\"2008-12-10\",\"saleTransDate\":\"2008-12-05\",\"amount\":{\"saleamt\":585000,\"salecode\":\"SALE PRICE (FULL) Full sales price as per documents\",\"salerecdate\":\"2008-12-10\",\"saledisclosuretype\":0,\"saledoctype\":\"DEED\",\"saledocnum\":\"0000348024\",\"saletranstype\":\"Resale\"},\"calculation\":{\"priceperbed\":146250,\"pricepersizeunit\":332.19999999999998863131622783839702606201171875},\"interfamily\":\"N\",\"resaleornewconstruction\":\"M\",\"cashormortgagepurchase\":\"C\"},\"assessment\":{\"appraised\":{},\"assessed\":{\"assdimprpersizeunit\":294.76999999999998181010596454143524169921875,\"assdimprvalue\":519092,\"assdlandpersizeunit\":23.510000000000001563194018672220408916473388671875,\"assdlandvalue\":223359,\"assdttlpersizeunit\":421.6100000000000136424205265939235687255859375,\"assdttlvalue\":742451},\"calculations\":{\"calcimprind\":\"ASSESSED VALUE\",\"calcimprpersizeunit\":294.76999999999998181010596454143524169921875,\"calcimprvalue\":519092,\"calclandind\":\"ASSESSED VALUE\",\"calclandpersizeunit\":23.510000000000001563194018672220408916473388671875,\"calclandvalue\":223359,\"calcttlind\":\"ASSESSED VALUE\",\"calcttlvalue\":742451,\"calcvaluepersizeunit\":421.6100000000000136424205265939235687255859375},\"market\":{},\"tax\":{\"taxamt\":9158.3199999999997089616954326629638671875,\"taxpersizeunit\":5.20000000000000017763568394002504646778106689453125,\"taxyear\":2023}}}]}', '2024-05-13 15:27:59', '2024-05-13 15:27:59'),
(7, 17, '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"4589e0744df410bf3c3cb62e9a31caf7\",\"attomId\":295062378},\"property\":[{\"identifier\":{\"Id\":295062378,\"fips\":\"20057\",\"apn\":\"087-25-0-10-08-001.00-0\",\"attomId\":295062378},\"lot\":{\"depth\":132,\"frontage\":274,\"lotnum\":\"7-12\",\"lotsize1\":0.8399908000000000374285491488990373909473419189453125,\"lotsize2\":36590},\"area\":{\"blockNum\":\"2\",\"countrysecsubd\":\"Ford\",\"countyuse1\":\"9910 \",\"muncode\":\"FO\",\"munname\":\"FORD\",\"subdname\":\"H S HAGGARD ADDITION\",\"taxcodearea\":\"001\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"KS\",\"line1\":\"AVE J\",\"line2\":\"DODGE CITY, KS 67801\",\"locality\":\"DODGE CITY\",\"matchCode\":\"ExaStr\",\"oneLine\":\"AVE J, DODGE CITY, KS 67801\",\"postal1\":\"67801\",\"postal2\":\"\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"37.758599\",\"longitude\":\"-100.003489\",\"distance\":0,\"geoid\":\"CO20057, CS2059300, DB2005580, SB0000087908, SB0000140492, SB0000142232, SB0000142233, SB0000145835, SB0000145836, SB0000147582, SB0000149350, SB0000151148, SB0000153003, SB0000153004, SB0000153005, ZI67801\",\"geoIdV4\":{\"CO\":\"ee22eea0650ac655b6abb28497a95d08\",\"CS\":\"c943c9eafc8697f5a68a7110c3e2d26d\",\"DB\":\"61c4c84e8e89064296b3e86a4c0c9f1b\",\"PL\":\"1bb150b1f34e013bcd5bcc8e446f1d91\",\"SB\":\"6c9f73805f7318dbddeee8f5d01ac1ae, ccfdee2b76451dd7528ebb5969fe18f2, 1dcbcc28292b23534bc0b2a6598fe425, 80aa27135dba03da583bb7ed9b7b7f5d, 51f855dce8bdae7947d0f874e2802c48, dbbc9f23a9a1e4e12411671a5094425e, 013d9933a2cee28d57974155cb11413a, bc0d7fbbf91406c4ab8aea929b67f911, 77d6198ed096fc93dbeb72bdf96e6a46, d16b8ff32a1ffb31b03d7870ff100655, 2643201d29dd16041614ceaf1a8ec237, ed787eadf922b2dc3ea7b71606c6420b\",\"ZI\":\"676af15a03363b244ad54824eb29e138\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Vacant\",\"propsubtype\":\"Residential\",\"proptype\":\"RESIDENTIAL - VACANT LAND\",\"propertyType\":\"RESIDENTIAL - VACANT LAND\",\"propLandUse\":\"RESIDENTIAL - VACANT LAND\",\"propIndicator\":\"80\",\"legal1\":\"H S HAGGARD ADDITION, S25, T26, R25, BLOCK 2, LOT 7 - 12\"},\"utilities\":{\"sewertype\":\"MUNICIPAL\",\"watertype\":\"COMMERCIAL\"},\"building\":{\"size\":{\"sizeInd\":\"LIVING SQFT\"},\"rooms\":{},\"interior\":{\"fplctype\":\"UNKNOWN\"},\"construction\":{},\"parking\":{},\"summary\":{}},\"vintage\":{\"lastModified\":\"2023-08-01\",\"pubDate\":\"2023-08-01\"},\"avm\":{\"amount\":{\"scr\":0,\"high\":0,\"low\":0},\"AVMChange\":{},\"calculations\":{},\"condition\":{\"avmpoorlow\":0,\"avmpoorhigh\":0,\"avmgoodlow\":0,\"avmgoodhigh\":0,\"avmexcellentlow\":0,\"avmexcellenthigh\":0}},\"sale\":{\"amount\":{\"saledisclosuretype\":1},\"calculation\":{},\"interfamily\":\"N\"},\"assessment\":{\"appraised\":{},\"assessed\":{\"assdlandpersizeunit\":0.01000000000000000020816681711721685132943093776702880859375,\"assdlandvalue\":232,\"assdttlvalue\":232},\"calculations\":{\"calcimprind\":\"MARKET VALUE\",\"calclandind\":\"MARKET VALUE\",\"calclandpersizeunit\":0.05000000000000000277555756156289135105907917022705078125,\"calclandvalue\":1930,\"calcttlind\":\"MARKET VALUE\",\"calcttlvalue\":1930},\"market\":{\"mktlandvalue\":1930,\"mktttlvalue\":1930},\"tax\":{\"taxamt\":40.5,\"taxyear\":2023}}}]}', '2024-05-14 02:51:09', '2024-05-14 02:51:09'),
(8, 18, '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"711cfe32be3beb0f0ebab65991860847\",\"attomId\":310553258},\"property\":[{\"identifier\":{\"Id\":310553258,\"fips\":\"56001\",\"apn\":\"12710430001200\",\"attomId\":310553258},\"lot\":{\"lotsize1\":640,\"lotsize2\":27878400},\"area\":{\"countrysecsubd\":\"Albany\",\"countyuse1\":\"40307\",\"muncode\":\"AL\",\"munname\":\"ALBANY\",\"taxcodearea\":\"0101\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"WY\",\"line2\":\"TIE SIDING, WY 82084\",\"locality\":\"TIE SIDING\",\"matchCode\":\"ExaStr\",\"oneLine\":\", TIE SIDING, WY 82084\",\"postal1\":\"82084\",\"postal2\":\"\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"41.026177\",\"longitude\":\"-105.365420\",\"distance\":0,\"geoid\":\"CO56001, CS5693135, DB5600730, SB0000130686, SB0000130687, SB0000130689, ZI82084\",\"geoIdV4\":{\"CO\":\"9ae5b7f6abb163d85fe3d8f036d3b69f\",\"CS\":\"cb95f01d0b2c90f9e2952e055f074af6\",\"DB\":\"588a4a4ad632daac1c461b173c9dbac0\",\"SB\":\"f460b83f9a1f0caeee2b9030a458a20f, 03b966cca44425acc17732e99185d7aa, 2733db09286df6736ef8a276e6de3420\",\"ZI\":\"6e7b184761f15aac69031dc94cdba8c8\"}},\"summary\":{\"propclass\":\"Agricultural\",\"propsubtype\":\"AGRICULTURE \\/ FARMING\",\"proptype\":\"FARMS\",\"propertyType\":\"RANGE LAND (GRAZING)\",\"propLandUse\":\"FARMS\",\"propIndicator\":\"70\",\"legal1\":\"12 N 71 W 4 S2SW 80.000, W2SE 80.000, 8 E2 320.000, 9 W2SW 80.000, W2NW 80.000 TOTAL ACRES: 640.000\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"BUILDING SQFT\"},\"rooms\":{},\"interior\":{\"fplctype\":\"UNKNOWN\"},\"construction\":{},\"parking\":{},\"summary\":{}},\"vintage\":{\"lastModified\":\"2023-07-04\",\"pubDate\":\"2023-07-04\"},\"avm\":{\"amount\":{\"scr\":0,\"high\":0,\"low\":0},\"AVMChange\":{},\"calculations\":{},\"condition\":{\"avmpoorlow\":0,\"avmpoorhigh\":0,\"avmgoodlow\":0,\"avmgoodhigh\":0,\"avmexcellentlow\":0,\"avmexcellenthigh\":0}},\"sale\":{\"amount\":{\"saledisclosuretype\":1},\"calculation\":{},\"interfamily\":\"N\"},\"assessment\":{\"appraised\":{},\"assessed\":{\"assdlandpersizeunit\":0,\"assdlandvalue\":5557,\"assdttlvalue\":5557},\"calculations\":{\"calcimprind\":\"MARKET VALUE\",\"calclandind\":\"MARKET VALUE\",\"calclandpersizeunit\":0,\"calclandvalue\":58490,\"calcttlind\":\"MARKET VALUE\",\"calcttlvalue\":58490},\"market\":{\"mktlandvalue\":58490,\"mktttlvalue\":58490},\"tax\":{\"taxyear\":2022}}}]}', '2024-05-15 13:01:41', '2024-05-15 13:01:41'),
(9, 19, '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"e366a688cd7f4f4d363343cd1cd951d7\",\"attomId\":15797493},\"property\":[{\"identifier\":{\"Id\":15797493,\"fips\":\"17113\",\"apn\":\"03-12-130-002\",\"attomId\":15797493},\"lot\":{\"lotnum\":\"28\",\"lotsize1\":0.33000459999999998128572542555048130452632904052734375,\"lotsize2\":14375,\"pooltype\":\"NO POOL\"},\"area\":{\"loctype\":\"VIEW - NONE\",\"countrysecsubd\":\"McLean\",\"countyuse1\":\"0030 \",\"muncode\":\"ML\",\"munname\":\"MCLEAN\",\"subdname\":\"2ND ADD SUNRISE\",\"taxcodearea\":\"810\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"IL\",\"line2\":\"CHENOA, IL 61726\",\"locality\":\"CHENOA\",\"matchCode\":\"ExaStr\",\"oneLine\":\", CHENOA, IL 61726\",\"postal1\":\"61726\",\"postal2\":\"\",\"postal3\":\"C001\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"40.740046\",\"longitude\":\"-88.709990\",\"distance\":0,\"geoid\":\"CO17113, CS1712944, DB1700005, PL1712931, ZI61726\",\"geoIdV4\":{\"CO\":\"68b283fc9051cf980160138d2df57f2b\",\"CS\":\"5ee429c51dd1f7d069f007b4188785ba\",\"PL\":\"eb9e46e9c2d26e33fe55f86f6eae48b4\",\"ZI\":\"d480ab42f3026ff338ffda2f0881d992\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Vacant\",\"propsubtype\":\"Residential\",\"proptype\":\"RESIDENTIAL - VACANT LAND\",\"propertyType\":\"RESIDENTIAL - VACANT LAND\",\"propLandUse\":\"RESIDENTIAL - VACANT LAND\",\"propIndicator\":\"80\",\"legal1\":\"2ND ADD TO SUNRISE LOT 28\"},\"utilities\":{},\"building\":{\"size\":{\"sizeInd\":\"LIVING SQFT\"},\"rooms\":{},\"interior\":{},\"construction\":{},\"parking\":{},\"summary\":{\"view\":\"VIEW - NONE\",\"viewCode\":\"000\"}},\"vintage\":{\"lastModified\":\"2023-11-17\",\"pubDate\":\"2023-11-17\"},\"avm\":{\"amount\":{\"scr\":0,\"high\":0,\"low\":0},\"AVMChange\":{},\"calculations\":{},\"condition\":{\"avmpoorlow\":0,\"avmpoorhigh\":0,\"avmgoodlow\":0,\"avmgoodhigh\":0,\"avmexcellentlow\":0,\"avmexcellenthigh\":0}},\"sale\":{\"amount\":{\"saledisclosuretype\":0},\"calculation\":{},\"interfamily\":\"N\"},\"assessment\":{\"appraised\":{},\"assessed\":{\"assdlandpersizeunit\":0.35999999999999998667732370449812151491641998291015625,\"assdlandvalue\":5141,\"assdttlvalue\":5141},\"calculations\":{\"calcimprind\":\"MARKET VALUE\",\"calclandind\":\"MARKET VALUE\",\"calclandpersizeunit\":1.0700000000000000621724893790087662637233734130859375,\"calclandvalue\":15423,\"calcttlind\":\"MARKET VALUE\",\"calcttlvalue\":15423},\"market\":{\"mktlandvalue\":15423,\"mktttlvalue\":15423},\"tax\":{\"taxamt\":489.69999999999998863131622783839702606201171875,\"taxyear\":2023}}}]}', '2024-05-16 13:49:33', '2024-05-16 13:49:33');

-- --------------------------------------------------------

--
-- Table structure for table `property_building_permits`
--

CREATE TABLE `property_building_permits` (
  `id` bigint UNSIGNED NOT NULL,
  `property_id` int NOT NULL,
  `effectivedate` date DEFAULT NULL,
  `permitnumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `projectname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fees` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `businessname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `homeownername` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jobvalue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_building_permits`
--

INSERT INTO `property_building_permits` (`id`, `property_id`, `effectivedate`, `permitnumber`, `status`, `description`, `type`, `projectname`, `fees`, `businessname`, `homeownername`, `jobvalue`, `created_at`, `updated_at`) VALUES
(15, 2, '2013-04-04', '00347672', NULL, NULL, NULL, NULL, '35', 'Doctor Fix-it Plumbing, Heating & Electr', 'Stcherbak,lidia', '2000', '2023-03-09 19:48:34', '2023-03-09 19:48:34'),
(16, 2, '2017-05-17', '2016-ELEC-0004720', 'withdrawn', 'R/r air conditioning', 'Electrical permit', 'Electrical Permit', '20', 'Positively Electric INC', 'Mattice,michael Scott', NULL, '2023-03-09 19:48:34', '2023-03-09 19:48:34'),
(17, 2, '2016-05-27', '2016-MECH-0003896', 'final', 'R/r air conditioning', 'Mechanical permit', 'Mechanical Permit', '59', 'Seasonal Comfort Systems LLC', 'Mattice,michael Scott', NULL, '2023-03-09 19:48:34', '2023-03-09 19:48:34'),
(18, 2, '2016-06-17', '2015-ROOFSIDE-0014621', 'final', 'Re/re: 4529 winona ct', 'Roofing and siding permit', 'Roofing Permit', '91', 'Reitz Roofing INC', 'Mattice,michael Scott', NULL, '2023-03-09 19:48:34', '2023-03-09 19:48:34'),
(19, 2, '2017-09-22', '2017-ROOFSIDE-0013232', 'final', 'Tear off existing material house and garage redeck garage only and reroof house and garage. Pitch 7 & 3/12 (ice and water all)', 'Roofing and siding permit', 'Aca Roofing Permit', '99', 'J&K Roofing INC', 'Mattice,michael Scott', '9447', '2023-03-09 19:48:34', '2023-03-09 19:48:34'),
(20, 2, '2015-06-04', '2013-MECH-0000347672', 'issued', NULL, 'Mechanical permit', 'Permit # 00347672', '35', 'Doctor FIX IT Plumbing Heating &E', 'Stcherbak, Lidia', NULL, '2023-03-09 19:48:34', '2023-03-09 19:48:34'),
(21, 2, '2018-11-30', '2018-ELEC-0014039', 'final', '200 amp service change and 50 amp sub-panel to garage', 'Electrical permit', 'Aca Electrical Permit', '51', 'Positively Electric INC', 'Mattice,michael Scott', '4000', '2023-03-09 19:48:34', '2023-03-09 19:48:34');

-- --------------------------------------------------------

--
-- Table structure for table `property_detail_mortgages`
--

CREATE TABLE `property_detail_mortgages` (
  `id` bigint UNSIGNED NOT NULL,
  `property_id` int NOT NULL,
  `lender_lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lender_companycode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_companyname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `mort_date` date DEFAULT NULL,
  `deedtype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `term` int DEFAULT NULL,
  `duedate` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_detail_mortgages`
--

INSERT INTO `property_detail_mortgages` (`id`, `property_id`, `lender_lastname`, `lender_companycode`, `title_companyname`, `amount`, `mort_date`, `deedtype`, `term`, `duedate`, `created_at`, `updated_at`) VALUES
(2, 3, 'MOUNTAIN HOME LENDING', '102082', 'NONE AVAILABLE', 154000, '2007-03-21', 'WD', 359, '2037-02-01', '2023-03-02 22:37:59', '2023-03-02 22:37:59');

-- --------------------------------------------------------

--
-- Table structure for table `property_detail_owners`
--

CREATE TABLE `property_detail_owners` (
  `id` bigint UNSIGNED NOT NULL,
  `property_id` int NOT NULL,
  `api_response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_detail_owners`
--

INSERT INTO `property_detail_owners` (`id`, `property_id`, `api_response`, `created_at`, `updated_at`) VALUES
(1, 2, '{\"status\":{\"version\":\"1.0.0\",\"code\":0,\"msg\":\"SuccessWithResult\",\"total\":1,\"page\":1,\"pagesize\":10,\"transactionID\":\"1ca12b31e80f437fe4c4afd6b667e559\"},\"property\":[{\"identifier\":{\"Id\":184713191,\"fips\":\"08031\",\"apn\":\"02192-04-018-000\",\"attomId\":184713191},\"lot\":{\"lotnum\":\"31,32\",\"lotsize1\":0.1076676,\"lotsize2\":4690,\"pooltype\":\"NO POOL\"},\"area\":{\"blockNum\":\"36\",\"loctype\":\"VIEW - NONE\",\"countrysecsubd\":\"Denver\",\"countyuse1\":\"113  \",\"muncode\":\"DE\",\"munname\":\"DENVER\",\"srvyRange\":\"68W\",\"srvySection\":\"19\",\"srvyTownship\":\"03S\",\"subdname\":\"BERKELEY\",\"taxcodearea\":\"DENV\"},\"address\":{\"country\":\"US\",\"countrySubd\":\"CO\",\"line1\":\"4529 WINONA CT\",\"line2\":\"DENVER, CO 80212\",\"locality\":\"DENVER\",\"matchCode\":\"ExaStr\",\"oneLine\":\"4529 WINONA CT, DENVER, CO 80212\",\"postal1\":\"80212\",\"postal2\":\"2512\",\"postal3\":\"C037\"},\"location\":{\"accuracy\":\"Rooftop\",\"latitude\":\"39.778926\",\"longitude\":\"-105.047775\",\"distance\":0,\"geoid\":\"CO08031, CS0891007, DB0803360, ND0000119198, ND0004861239, PL0820000, SB0000076114, SB0000076155, SB0000076161, SB0000135819, SB0000143772, ZI80212\",\"geoIdV4\":{\"CO\":\"1291dc1937525d78f89cebb6a43a50de\",\"CS\":\"4c0507d0d7894d2d48e4e03e1c0240fc\",\"DB\":\"d8ca7ea08abbe9efdd7e3b78f23d120e\",\"N1\":\"b26d02d9330761156fc0cfd4ed8bf9a1\",\"N2\":\"27e220314436f6edd5e606ddcd28156d\",\"PL\":\"7de845f7ba9b234a2c5adfca1db76c64\",\"SB\":\"4287d95a26357a9a1474f9cb99e6e816,6dee2c66470af6400265dd11b87cdb7d,906cf6aada87fa5bad0a13f2f86ff5aa,b95eac0d6a8385db6771b9d54f2a6a1c,b9980ca738ece2e06f9086da927317fe\",\"ZI\":\"0149d0a55ef2d6b71071a39f4e13d6eb\"}},\"summary\":{\"absenteeInd\":\"ABSENTEE(MAIL AND SITUS NOT =)\",\"propclass\":\"Single Family Residence \\/ Townhouse\",\"propsubtype\":\"Residential\",\"proptype\":\"SFR\",\"yearbuilt\":1900,\"propLandUse\":\"SFR\",\"propIndicator\":\"10\",\"legal1\":\"BERKELEY B36 L31 & S\\/2 OF L32 EXC REAR 8FT TO CITY\"},\"utilities\":{\"heatingfuel\":\"GAS\",\"heatingtype\":\"CENTRAL\"},\"building\":{\"size\":{\"bldgsize\":934,\"grosssize\":1414,\"grosssizeadjusted\":934,\"groundfloorsize\":934,\"livingsize\":934,\"sizeInd\":\"LIVING SQFT\",\"universalsize\":934},\"rooms\":{\"bathfixtures\":5,\"bathsfull\":1,\"bathstotal\":1,\"beds\":2,\"roomsTotal\":5},\"interior\":{\"bsmtsize\":480,\"fplccount\":1,\"fplcind\":\"Y\",\"fplctype\":\"YES\"},\"construction\":{\"condition\":\"GOOD\",\"wallType\":\"BRICK\"},\"parking\":{\"prkgSize\":240,\"prkgSpaces\":\"1\"},\"summary\":{\"archStyle\":\"OTHER\",\"levels\":1,\"quality\":\"HIGH QUALITY RESIDENTIAL\",\"unitsCount\":\"1\",\"view\":\"VIEW - NONE\",\"yearbuilteffective\":2014}},\"owner\":{\"corporateindicator\":\"Y\",\"owner1\":{\"lastname\":\"MATTICE, MICHAEL S LIVING TRUST \"},\"owner2\":{},\"owner3\":{\"lastname\":\"MATTICE, SHAREE LIVING TRUST \"},\"owner4\":{},\"ownerrelationshiprightscode\":\"LV\",\"ownerrelationshiptype\":\"LT\",\"absenteeownerstatus\":\"A\",\"mailingaddressoneline\":\"2829 N FRANKLIN ST, DENVER, CO 80205-4510\"},\"vintage\":{\"lastModified\":\"2023-02-15\",\"pubDate\":\"2023-02-15\"}}]}', '2023-03-09 19:48:31', '2023-03-09 19:48:31');

-- --------------------------------------------------------

--
-- Table structure for table `property_nearby_schools`
--

CREATE TABLE `property_nearby_schools` (
  `id` bigint UNSIGNED NOT NULL,
  `property_id` int NOT NULL,
  `geoidv4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `institutionname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gstestrating` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schoolrating` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gradelevel1lotext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gradelevel1hitext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lowassignedgrade` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `highassignedgrade` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filetypetext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `geocodinglatitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `geocodinglongitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `distance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_nearby_schools`
--

INSERT INTO `property_nearby_schools` (`id`, `property_id`, `geoidv4`, `institutionname`, `gstestrating`, `schoolrating`, `gradelevel1lotext`, `gradelevel1hitext`, `lowassignedgrade`, `highassignedgrade`, `filetypetext`, `geocodinglatitude`, `geocodinglongitude`, `distance`, `created_at`, `updated_at`) VALUES
(21, 3, '8a506b574561c5bab4f163492c7a386a', 'Skinner Middle School', '0', 'B ', '6', '8', '6 ', '8 ', 'Public', '39.7724', '-105.0323', '0.9', '2023-03-02 21:32:43', '2023-03-02 21:32:43'),
(22, 3, '9e0b497fb1337405c4dfe64e51568f68', 'Centennial School', '0', 'B-', 'EE', '5', 'EE', '5 ', 'Public', '39.7813', '-105.0422', '0.32', '2023-03-02 21:32:43', '2023-03-02 21:32:43'),
(23, 3, '3b4cd5c56026e2e1f0e5c553b74cf05d', 'Bryant Webster Dual Language ECE-8 School', '0', 'D-', '6', '8', '6 ', '8 ', 'Public', '39.7674', '-105.0084', '2.2', '2023-03-02 21:32:43', '2023-03-02 21:32:43'),
(24, 3, '93e5fef8956253c5642a335fc4a4395f', 'Strive Prep - Sunnyside', '0', 'C+', '6', '8', '6 ', '8 ', 'Public', '39.782013', '-105.00681', '2.16', '2023-03-02 21:32:43', '2023-03-02 21:32:43'),
(25, 3, '3d0771574d56c6eae9184bc5aa3ebe19', 'North High School', '0', 'C+', '9', '12', '9 ', '12', 'Public', '39.7605', '-105.0222', '1.82', '2023-03-02 21:32:43', '2023-03-02 21:32:43'),
(26, 2, '8a506b574561c5bab4f163492c7a386a', 'Skinner Middle School', '0', 'B ', '6', '8', '6 ', '8 ', 'Public', '39.7724', '-105.0323', '0.94', '2023-03-09 19:41:23', '2023-03-09 19:41:23'),
(27, 2, '9e0b497fb1337405c4dfe64e51568f68', 'Centennial School', '0', 'B-', 'EE', '5', 'EE', '5 ', 'Public', '39.7813', '-105.0422', '0.34', '2023-03-09 19:41:23', '2023-03-09 19:41:23'),
(28, 2, '3b4cd5c56026e2e1f0e5c553b74cf05d', 'Bryant Webster Dual Language ECE-8 School', '0', 'D-', '6', '8', '6 ', '8 ', 'Public', '39.7674', '-105.0084', '2.24', '2023-03-09 19:41:23', '2023-03-09 19:41:23'),
(29, 2, '93e5fef8956253c5642a335fc4a4395f', 'Strive Prep - Sunnyside', '0', 'C+', '6', '8', '6 ', '8 ', 'Public', '39.782013', '-105.00681', '2.19', '2023-03-09 19:41:23', '2023-03-09 19:41:23'),
(30, 2, '3d0771574d56c6eae9184bc5aa3ebe19', 'North High School', '0', 'C+', '9', '12', '9 ', '12', 'Public', '39.7605', '-105.0222', '1.86', '2023-03-09 19:41:23', '2023-03-09 19:41:23');

-- --------------------------------------------------------

--
-- Table structure for table `property_rental_avms`
--

CREATE TABLE `property_rental_avms` (
  `id` bigint UNSIGNED NOT NULL,
  `property_id` int NOT NULL,
  `estimated_rental_value` double DEFAULT NULL,
  `estimated_min_rental_value` double DEFAULT NULL,
  `estimated_max_rental_value` double DEFAULT NULL,
  `valuation_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_rental_avms`
--

INSERT INTO `property_rental_avms` (`id`, `property_id`, `estimated_rental_value`, `estimated_min_rental_value`, `estimated_max_rental_value`, `valuation_date`, `created_at`, `updated_at`) VALUES
(1, 14, 0, 0, 0, NULL, '2024-05-13 07:16:24', '2024-05-13 07:16:24'),
(2, 15, 0, 0, 0, NULL, '2024-05-13 10:29:48', '2024-05-13 10:29:48'),
(3, 16, 4629, 4118, 5058, '2024-04-22', '2024-05-13 15:28:00', '2024-05-13 15:28:00'),
(4, 17, 0, 0, 0, NULL, '2024-05-14 02:51:10', '2024-05-14 02:51:10'),
(5, 18, 0, 0, 0, NULL, '2024-05-15 13:01:42', '2024-05-15 13:01:42'),
(6, 19, 0, 0, 0, NULL, '2024-05-16 13:49:34', '2024-05-16 13:49:34'),
(7, 2, 3264, 2567, 4368, '2024-04-22', '2024-05-17 03:16:14', '2024-05-17 03:16:14'),
(8, 2, 3264, 2567, 4368, '2024-04-22', '2024-05-17 03:27:20', '2024-05-17 03:27:20');

-- --------------------------------------------------------

--
-- Table structure for table `property_sales_trends`
--

CREATE TABLE `property_sales_trends` (
  `id` bigint UNSIGNED NOT NULL,
  `property_id` int NOT NULL,
  `geoidv4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `interval` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_year` int NOT NULL,
  `end_year` int NOT NULL,
  `homesalecount` int DEFAULT NULL,
  `avgsaleprice` int DEFAULT NULL,
  `medsaleprice` int DEFAULT NULL,
  `pubdate` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_sales_trends`
--

INSERT INTO `property_sales_trends` (`id`, `property_id`, `geoidv4`, `interval`, `start_year`, `end_year`, `homesalecount`, `avgsaleprice`, `medsaleprice`, `pubdate`, `created_at`, `updated_at`) VALUES
(13, 2, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2018, 2018, 2628, 562094, 515000, '2022-02-12', '2023-02-27 09:28:19', '2023-02-27 09:28:19'),
(14, 2, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2019, 2019, 2695, 600044, 548000, '2022-02-12', '2023-02-27 09:28:19', '2023-02-27 09:28:19'),
(15, 2, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2020, 2020, 3183, 602664, 549000, '2022-02-12', '2023-02-27 09:28:19', '2023-02-27 09:28:19'),
(16, 2, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2021, 2021, 3701, 695690, 630700, '2022-02-10', '2023-02-27 09:28:19', '2023-02-27 09:28:19'),
(17, 2, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2022, 2022, 2219, 784110, 694900, '2022-02-10', '2023-02-27 09:28:19', '2023-02-27 09:28:19'),
(18, 2, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2023, 2023, 80, 726392, 666000, '2023-02-07', '2023-02-27 09:28:19', '2023-02-27 09:28:19'),
(25, 3, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2018, 2018, 2628, 562094, 515000, '2022-02-12', '2023-03-02 21:30:29', '2023-03-02 21:30:29'),
(26, 3, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2019, 2019, 2695, 600044, 548000, '2022-02-12', '2023-03-02 21:30:29', '2023-03-02 21:30:29'),
(27, 3, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2020, 2020, 3183, 602664, 549000, '2022-02-12', '2023-03-02 21:30:29', '2023-03-02 21:30:29'),
(28, 3, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2021, 2021, 3701, 695690, 630700, '2022-02-10', '2023-03-02 21:30:29', '2023-03-02 21:30:29'),
(29, 3, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2022, 2022, 2219, 784110, 694900, '2022-02-10', '2023-03-02 21:30:29', '2023-03-02 21:30:29'),
(30, 3, 'b26d02d9330761156fc0cfd4ed8bf9a1', 'yearly', 2023, 2023, 80, 726392, 666000, '2023-02-07', '2023-03-02 21:30:29', '2023-03-02 21:30:29'),
(31, 15, 'b6e319de42ce733bc8ece056227072f5', 'yearly', 2019, 2019, 16, 245790, 212309, '2022-02-12', '2024-05-13 10:29:40', '2024-05-13 10:29:40'),
(32, 15, 'b6e319de42ce733bc8ece056227072f5', 'yearly', 2020, 2020, 17, 229492, 229900, '2022-02-12', '2024-05-13 10:29:40', '2024-05-13 10:29:40'),
(33, 15, 'b6e319de42ce733bc8ece056227072f5', 'yearly', 2021, 2021, 25, 240497, 239112, '2022-02-10', '2024-05-13 10:29:40', '2024-05-13 10:29:40'),
(34, 15, 'b6e319de42ce733bc8ece056227072f5', 'yearly', 2022, 2022, 28, 270947, 270586, '2022-02-10', '2024-05-13 10:29:40', '2024-05-13 10:29:40'),
(35, 15, 'b6e319de42ce733bc8ece056227072f5', 'yearly', 2023, 2023, 20, 296084, 303066, '2023-03-07', '2024-05-13 10:29:40', '2024-05-13 10:29:40'),
(36, 16, '92598b4a8a5ab06190f399cd84e7015c', 'yearly', 2019, 2019, 610, 1031130, 950000, '2022-02-12', '2024-05-13 15:27:58', '2024-05-13 15:27:58'),
(37, 16, '92598b4a8a5ab06190f399cd84e7015c', 'yearly', 2020, 2020, 587, 1101793, 1015000, '2022-02-12', '2024-05-13 15:27:58', '2024-05-13 15:27:58'),
(38, 16, '92598b4a8a5ab06190f399cd84e7015c', 'yearly', 2021, 2021, 766, 1121372, 1111250, '2022-02-10', '2024-05-13 15:27:58', '2024-05-13 15:27:58'),
(39, 16, '92598b4a8a5ab06190f399cd84e7015c', 'yearly', 2022, 2022, 500, 1222932, 1215000, '2022-02-10', '2024-05-13 15:27:58', '2024-05-13 15:27:58'),
(40, 16, '92598b4a8a5ab06190f399cd84e7015c', 'yearly', 2023, 2023, 427, 1189628, 1225000, '2023-02-07', '2024-05-13 15:27:58', '2024-05-13 15:27:58'),
(41, 16, '92598b4a8a5ab06190f399cd84e7015c', 'yearly', 2024, 2024, 86, 1310860, 1332500, '2024-03-07', '2024-05-13 15:27:58', '2024-05-13 15:27:58');

-- --------------------------------------------------------

--
-- Table structure for table `property_transport_noises`
--

CREATE TABLE `property_transport_noises` (
  `id` bigint UNSIGNED NOT NULL,
  `property_id` int NOT NULL,
  `noise_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `level_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `noise_sources` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_transport_noises`
--

INSERT INTO `property_transport_noises` (`id`, `property_id`, `noise_type`, `level`, `level_description`, `noise_sources`, `created_at`, `updated_at`) VALUES
(1, 2, 'road_noise', '2', 'Busy traffic nearby', '[{\"source_type\":\"road\",\"source_sub_type\":\"motorway\",\"source_description\":\"\"},{\"source_type\":\"road\",\"source_sub_type\":\"residential\",\"source_description\":\"Winona Court\"},{\"source_type\":\"road\",\"source_sub_type\":\"motorway_link\",\"source_description\":\"\"},{\"source_type\":\"road\",\"source_sub_type\":\"primary\",\"source_description\":\"Sheridan Boulevard\"},{\"source_type\":\"road\",\"source_sub_type\":\"service\",\"source_description\":\"\"}]', '2023-02-23 22:29:44', '2023-02-23 22:29:44'),
(2, 2, 'aviation_noise', '0', 'No nearby airports', '[]', '2023-02-23 22:29:44', '2023-02-23 22:29:44'),
(3, 2, 'emg_vehicle_noise', '3', 'Possible frequent or loud ambulance or fire truck sirens', '[{\"source_type\":\"fire-station\",\"source_description\":\"Denver Fire Department Station 17\",\"source_dist_km\":0.4},{\"source_type\":\"fire-station\",\"source_description\":\"Lakeside Fire Department Station 2\",\"source_dist_km\":0.6}]', '2023-02-23 22:29:44', '2023-02-23 22:29:44'),
(4, 2, 'rail_whistle_noise', '0', 'There aren\'t any train crossings with whistles nearby', '[{\"source_type\":\"rail-whistle\",\"source_description\":\"BNSF Railway & Tennyson Street\",\"source_dist_km\":2.8},{\"source_type\":\"rail-whistle\",\"source_description\":\"Union Pacific Railroad & Tennyson Street\",\"source_dist_km\":2.9},{\"source_type\":\"rail-whistle\",\"source_description\":\"Union Pacific Railroad & Tennyson Street\",\"source_dist_km\":2.9},{\"source_type\":\"rail-whistle\",\"source_description\":\"RTD & Tennyson Street\",\"source_dist_km\":2.9},{\"source_type\":\"rail-whistle\",\"source_description\":\"RTD & Tennyson Street\",\"source_dist_km\":2.9}]', '2023-02-23 22:29:44', '2023-02-23 22:29:44'),
(5, 2, 'rail_noise', '1', 'Audible trains', '[{\"source_type\":\"rail\",\"source_sub_type\":\"rail\",\"source_description\":\"UP Moffat Tunnel Subdivision\"},{\"source_type\":\"rail\",\"source_sub_type\":\"rail\",\"source_description\":\"RTD G Line\"},{\"source_type\":\"rail\",\"source_sub_type\":\"rail\",\"source_description\":\"Golden Subdivision\"},{\"source_type\":\"rail\",\"source_sub_type\":\"rail\",\"source_description\":\"\"}]', '2023-02-23 22:29:44', '2023-02-23 22:29:44'),
(6, 3, 'road_noise', '2', 'Busy traffic nearby', '[{\"source_type\":\"road\",\"source_sub_type\":\"motorway\",\"source_description\":\"\"},{\"source_type\":\"road\",\"source_sub_type\":\"residential\",\"source_description\":\"West 45th Avenue\"},{\"source_type\":\"road\",\"source_sub_type\":\"residential\",\"source_description\":\"Winona Court\"},{\"source_type\":\"road\",\"source_sub_type\":\"motorway_link\",\"source_description\":\"\"},{\"source_type\":\"road\",\"source_sub_type\":\"primary\",\"source_description\":\"Sheridan Boulevard\"}]', '2023-03-02 21:29:54', '2023-03-02 21:29:54'),
(7, 3, 'aviation_noise', '0', 'No nearby airports', '[]', '2023-03-02 21:29:54', '2023-03-02 21:29:54'),
(8, 3, 'emg_vehicle_noise', '3', 'Possible frequent or loud ambulance or fire truck sirens', '[{\"source_type\":\"fire-station\",\"source_description\":\"Denver Fire Department Station 17\",\"source_dist_km\":0.3},{\"source_type\":\"fire-station\",\"source_description\":\"Lakeside Fire Department Station 2\",\"source_dist_km\":0.6}]', '2023-03-02 21:29:54', '2023-03-02 21:29:54'),
(9, 3, 'rail_whistle_noise', '0', 'There aren\'t any train crossings with whistles nearby', '[{\"source_type\":\"rail-whistle\",\"source_description\":\"BNSF Railway & Tennyson Street\",\"source_dist_km\":2.9},{\"source_type\":\"rail-whistle\",\"source_description\":\"Union Pacific Railroad & Tennyson Street\",\"source_dist_km\":2.9},{\"source_type\":\"rail-whistle\",\"source_description\":\"Union Pacific Railroad & Tennyson Street\",\"source_dist_km\":2.9},{\"source_type\":\"rail-whistle\",\"source_description\":\"RTD & Tennyson Street\",\"source_dist_km\":2.9},{\"source_type\":\"rail-whistle\",\"source_description\":\"RTD & Tennyson Street\",\"source_dist_km\":2.9}]', '2023-03-02 21:29:54', '2023-03-02 21:29:54'),
(10, 3, 'rail_noise', '1', 'Audible trains', '[{\"source_type\":\"rail\",\"source_sub_type\":\"rail\",\"source_description\":\"UP Moffat Tunnel Subdivision\"},{\"source_type\":\"rail\",\"source_sub_type\":\"rail\",\"source_description\":\"RTD G Line\"},{\"source_type\":\"rail\",\"source_sub_type\":\"rail\",\"source_description\":\"Golden Subdivision\"},{\"source_type\":\"rail\",\"source_sub_type\":\"rail\",\"source_description\":\"\"}]', '2023-03-02 21:29:54', '2023-03-02 21:29:54');

-- --------------------------------------------------------

--
-- Table structure for table `request_demos`
--

CREATE TABLE `request_demos` (
  `id` bigint UNSIGNED NOT NULL,
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `companyname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `companyvalue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `request_demos`
--

INSERT INTO `request_demos` (`id`, `firstname`, `lastname`, `companyname`, `email`, `companyvalue`, `created_at`, `updated_at`) VALUES
(1, 'ghgh', 'ghgh', 'ghghgh', 'theshan@birbals.com', 'Mortage', '2024-05-09 15:40:03', '2024-05-09 15:40:03'),
(2, 'TEST', 'TEST', 'TEST', 'theshan@birbals.com', 'Mortage', '2024-05-14 03:21:08', '2024-05-14 03:21:08');

-- --------------------------------------------------------

--
-- Table structure for table `state_licenses`
--

CREATE TABLE `state_licenses` (
  `id` bigint UNSIGNED NOT NULL,
  `state_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lms_license_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `consent_to_receive_message` tinyint(1) NOT NULL DEFAULT '0',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zipcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lrst_frequency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lrst_frequency_opt` tinyint DEFAULT NULL,
  `lrnst_frequency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lrnst_frequency_opt` tinyint DEFAULT NULL,
  `clt_frequency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clt_frequency_opt` tinyint DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `mobile`, `consent_to_receive_message`, `address`, `city`, `state`, `zipcode`, `lrst_frequency`, `lrst_frequency_opt`, `lrnst_frequency`, `lrnst_frequency_opt`, `clt_frequency`, `clt_frequency_opt`, `status`) VALUES
(1, 'Pranab Mukherjee', 'pawan2@birbals.com', NULL, '$2y$10$LwHRVc8gPD6G97.vabG36OGKpWxX3HWAhi6TgaMz4jdJFO4xLIvCW', NULL, '2023-01-31 23:52:20', '2024-05-17 03:14:38', '9899619733', 1, 'Noida', 'Greater Noida West', 'UP', '201009', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(2, 'Ram', 'ram@dixinfotech.in', NULL, 'ded60790373ddeebde56a5573e623714', NULL, '2023-02-01 18:51:25', '2023-02-01 18:51:25', '9971015233', 1, 'Faridabad', 'Faridabad', 'Haryana', '121001', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(3, 'Varsha', 'varsha@mail.com', NULL, '$2y$10$VHLsrPOwskMFczWOgQcrmOOnLKiZVSwekC1gJRKmw6BFMX7mttHq2', NULL, '2023-02-20 17:22:34', '2023-02-20 17:22:34', '9205715363', 1, 'Noida', 'Greater Noida West', NULL, '20100', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(4, 'theshan', 'theshan2@birbals.com', NULL, '$2y$10$E0QYoguRHUQ3ZKul8w./zet2Z7KATakb72ai0rkJnNInegHkc4/dK', NULL, '2024-05-13 07:15:41', '2024-05-13 07:16:13', '4111111111', 1, 'tests', 'test', NULL, '70080', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(5, 'Prabaharan Rajendran', 'prabaharan@birbals.com', NULL, '$2y$10$AYgyYg4A9S.Wd60w6Ucf3uFb9HQ.xwB9WK5zo4xU7d6D23UOIcglq', NULL, '2024-05-13 10:27:40', '2024-05-17 03:05:08', '8248749492', 1, 'Alaska', 'Alasks', NULL, '56545', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(6, 'Pawan Bangar', 'birbals@gmail.com', NULL, '$2y$10$viGL3hLwD3dRAGruItv.Nu.I1j5txV87F/G.AtVugCLO0XIsNleVi', NULL, '2024-05-13 15:27:21', '2024-05-13 15:27:56', '5104499049', 1, '7875 Cresmtont Ave', 'Newark', NULL, '94560', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(7, 'jfjh', '123@gmail.com', NULL, '$2y$10$H8RHMx34tkhWP1Zxkhq9SeIHyowlCBtQRiZKU2u7IW/3E.4gmnc2C', NULL, '2024-05-14 02:50:43', '2024-05-14 02:51:06', '4111111115', 1, 'hj', 'Dodge City', NULL, '67801', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(8, 'Guna', 'guna@birbals.com', NULL, '$2y$10$5Yqmm4hrcb/bFhDkKtRb9O2YaU3xRyfJA5SdMpzxG2B1K6f2eDCc6', NULL, '2024-05-15 10:24:38', '2024-05-15 10:24:38', '8945212313', 0, 'asd', 'city', NULL, '94583', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(9, 'Vinoth', 'vk@birbals.com', NULL, '$2y$10$MSDWOLltLNf1XvJvXfApgewqrmh14nU3AW3eYaYqnmkstnUwkIcLS', NULL, '2024-05-15 12:31:23', '2024-05-15 13:15:06', '9345874635', 0, 'Velacheri', 'chennai', NULL, '90231', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(10, 'shuv', 'pawan@birbals.com', NULL, '$2y$10$KFjvoRCyGqyIxsiKV5JcHe9YFTqK2eqhKLz.Du8qgPjxc7.CDf4Xy', NULL, '2024-05-15 13:00:00', '2024-05-15 13:00:00', '0571224844', 0, 'Testing', 'Test', NULL, '22312', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(11, 'shuv', 'Shuv@birbals.com', NULL, '$2y$10$H4MmFHsRpyELsUFUP2wPy.4LFE5gdXLj8IYFvLk9yU3fWFCRnrWcG', NULL, '2024-05-15 13:00:55', '2024-05-15 13:01:39', '0571224845', 1, 'Testing', 'Test', NULL, '22312', NULL, NULL, NULL, NULL, NULL, NULL, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `abouts`
--
ALTER TABLE `abouts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_email_unique` (`email`);

--
-- Indexes for table `atom_api_logs`
--
ALTER TABLE `atom_api_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact_loan_officers`
--
ALTER TABLE `contact_loan_officers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `home_sections`
--
ALTER TABLE `home_sections`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `loan_officer_notes`
--
ALTER TABLE `loan_officer_notes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `loan_officer_state_licenses`
--
ALTER TABLE `loan_officer_state_licenses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mortgage_information`
--
ALTER TABLE `mortgage_information`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mortgage_information_property_id_index` (`property_id`),
  ADD KEY `mortgage_information_user_id_index` (`user_id`);

--
-- Indexes for table `neat_capital_responses`
--
ALTER TABLE `neat_capital_responses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `opportunity_alerts`
--
ALTER TABLE `opportunity_alerts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `privacies`
--
ALTER TABLE `privacies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `properties`
--
ALTER TABLE `properties`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_all_events_details`
--
ALTER TABLE `property_all_events_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_building_permits`
--
ALTER TABLE `property_building_permits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_detail_mortgages`
--
ALTER TABLE `property_detail_mortgages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_detail_owners`
--
ALTER TABLE `property_detail_owners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_nearby_schools`
--
ALTER TABLE `property_nearby_schools`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_rental_avms`
--
ALTER TABLE `property_rental_avms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_sales_trends`
--
ALTER TABLE `property_sales_trends`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_transport_noises`
--
ALTER TABLE `property_transport_noises`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `request_demos`
--
ALTER TABLE `request_demos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `state_licenses`
--
ALTER TABLE `state_licenses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `abouts`
--
ALTER TABLE `abouts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `atom_api_logs`
--
ALTER TABLE `atom_api_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=245;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `contact_loan_officers`
--
ALTER TABLE `contact_loan_officers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `home_sections`
--
ALTER TABLE `home_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_officer_notes`
--
ALTER TABLE `loan_officer_notes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_officer_state_licenses`
--
ALTER TABLE `loan_officer_state_licenses`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `mortgage_information`
--
ALTER TABLE `mortgage_information`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `neat_capital_responses`
--
ALTER TABLE `neat_capital_responses`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `opportunity_alerts`
--
ALTER TABLE `opportunity_alerts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `privacies`
--
ALTER TABLE `privacies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `properties`
--
ALTER TABLE `properties`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `property_all_events_details`
--
ALTER TABLE `property_all_events_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `property_building_permits`
--
ALTER TABLE `property_building_permits`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `property_detail_mortgages`
--
ALTER TABLE `property_detail_mortgages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `property_detail_owners`
--
ALTER TABLE `property_detail_owners`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `property_nearby_schools`
--
ALTER TABLE `property_nearby_schools`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `property_rental_avms`
--
ALTER TABLE `property_rental_avms`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `property_sales_trends`
--
ALTER TABLE `property_sales_trends`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `property_transport_noises`
--
ALTER TABLE `property_transport_noises`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `request_demos`
--
ALTER TABLE `request_demos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `state_licenses`
--
ALTER TABLE `state_licenses`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
COMMIT;

