Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T18:29:37.010' ,`MLSNumber` = '74703197' ,`ListAgentFullName` = 'Abdul Dadabhoy' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.705125' ,`Longitude` = '-95.410698' ,`PhotoCount` = '13' ,`PostalCode` = '77030' ,`RoomCount` = '7' ,`ListPrice` = '689000.00' ,`Status` = 'Active' ,`StreetName` = 'DORRINGTON STREET' ,`StreetNumber` = '2215' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2702' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 BED 3 BATHS ROOF REPLACED 6 YEARS AGO. A/C ALSO REPLACED 6 YEARS AGO' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 8 BL 4 BRAESWOOD' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'BRAESWOOD' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093240' WHERE `Matrix_Unique_ID` = '208394269'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T18:32:18.497' ,`MLSNumber` = '76229023' ,`ListAgentFullName` = 'Tina Bui' ,`ListOfficeName` = 'Red Lion Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932622' ,`Longitude` = '-95.518105' ,`PhotoCount` = '25' ,`PostalCode` = '77086' ,`RoomCount` = '3' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Clarks Fork' ,`StreetNumber` = '13639' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1426' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedrooms, 2 baths and 2 car garage.  Brand new roof with new renovated interiors.  Quiet and friendly neighbors.  Easy access to Methodist Hospital, Groceries, and Willow Brook Mall.  Conveniently fast route to beltway 8 and I45. Don\'t pass up this cozy home!!!! All measurements are approximate. Buyers Agent to Verify.' ,`Acres` = '0.1162' ,`Area` = '11' ,`BuilderName` = 'KB HOME' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 6 BLUE CREEK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5060' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MCDOUGLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Blue Crk Sec 04' ,`TaxAmount` = '3591' ,`TaxRate` = '2.4615' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093240' WHERE `Matrix_Unique_ID` = '209255423'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T17:48:14.497' ,`MLSNumber` = '2845620' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Douglas Chavez' ,`SellingOfficeName` = 'RE/MAX Signature' ,`Latitude` = '30.232141' ,`Longitude` = '-95.705054' ,`PhotoCount` = '8' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '326990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'BIRCH SHADOWS COURT' ,`StreetNumber` = '40511' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW Exceptional 2 story Express Home in the best location!!  This beautiful Open Concept home has a large kitchen that is open to the family room & dining room! Primary suite offers a HUGE walk in closet!  Features include 30\" Flat panel maple cabinets w/ crown molding, exotic granite, 4 burner gas cooktop w/ SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting, Blinds and more! Large covered patio overlooks the private fenced backyard! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '3/5/5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6916' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093241' WHERE `Matrix_Unique_ID` = '212064567'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T17:07:48.563' ,`MLSNumber` = '80039020' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Grace Beakoi' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '291340.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Oakwood Meadows' ,`StreetNumber` = '21619' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW DR Horton One Story Property!! Fantastic kitchen featuring beautiful cabinetry and modern finishes!  Also open to the breakfast and family rooms!   Spacious primary bedroom suite with a great closet and oversized shower!! Hard surface flooring in all living areas. Easy access from the garage to a generous sized utility room.  GREAT LOCATION! Hurry and call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26 - Block 2 - Section 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5951' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093241' WHERE `Matrix_Unique_ID` = '212234988'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T18:04:28.143' ,`MLSNumber` = '24293415' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Anil Godumagadda' ,`SellingOfficeName` = 'Clear Source Realty, LLC' ,`Latitude` = '30.261488' ,`Longitude` = '-95.528916' ,`PhotoCount` = '26' ,`PostalCode` = '77384' ,`RoomCount` = '5' ,`ListPrice` = '431740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Rising Sun Lane' ,`StreetNumber` = '13769' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO BACK NEIGHBORS! New DR Horton home! Beautiful two story home! This new construction home features gorgeous brick and stone exterior and includes 4 bed/3 bath/ with a gameroom Features include SS Appliances a 5 burner built-in gas burner cooktop, Quartz Countertops and 42\" flat cabinets in Kitchen, Separate Shower, Built-In Home Automation, Solid Surface Flooring throughout, Tankless Water Heater, Covered Patio, and Full Sprinkler System. Fosters Ridge offers beautiful community center, playground, and  pool. Zoned to The Woodlands Schools! DR Horton is America\'s #1 Homebuilder! Come out to Fosters Ridge and make this new home yours today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Fosters Ridge 19, BLOCK 1, Lot 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge' ,`TaxAmount` = '' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093241' WHERE `Matrix_Unique_ID` = '212619768'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T18:00:47.423' ,`MLSNumber` = '39604501' ,`ListAgentFullName` = 'Vanessa Cochran' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.111199' ,`Longitude` = '-94.638987' ,`PhotoCount` = '8' ,`PostalCode` = '77533' ,`RoomCount` = '8' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Bobcat' ,`StreetNumber` = '602' ,`StreetSuffix` = 'Lane' ,`City` = 'Daisetta' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2233' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home can be made into a 5 bedroom. Sits on a 1.33 acres lots of room its a huge house floor has been redone' ,`Acres` = '1.33' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000023 J DEVORE, BLOCK (M/3 OF W/2), TRACT 62, ACRES 1.33' ,`LotDesciption` = 'Cleared' ,`LotSize` = '57935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '108 - Hull-Daisetta' ,`SchoolElementary` = 'HULL-DAISETTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HULL-DAISETTA HIGH SCHOOL' ,`SchoolMiddle` = 'HULL-DAISETTA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'J Devore' ,`TaxAmount` = '4791' ,`TaxRate` = '2.2738' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093241' WHERE `Matrix_Unique_ID` = '212991432'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T18:52:04.890' ,`MLSNumber` = '40260636' ,`ListAgentFullName` = 'Kathryn Anne Freeland-Foley' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.938899' ,`Longitude` = '-96.705513' ,`PhotoCount` = '31' ,`PostalCode` = '76639' ,`RoomCount` = '4' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3150' ,`StreetNumber` = '1920' ,`StreetSuffix` = '' ,`City` = 'Dawson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is just minutes from Navarro mills lake, where you can relax, fish, and play. Located just outside a quiet small town, but still close enough to major big cities for shopping and dining and entertainment.\r\nIt has an open concept living, kitchen, and dining area; four bedrooms, two down and two upstairs; along with 2 full bath, large laundry and mudroom. It has two ac units, a covered front porch with a ramp for easy access. \r\nThe owner is leaving all appliances along with shelving in the laundry room and everything in this house is only two years old.\r\nThis country home sits on almost an acre of land and has big, beautiful trees. There is a concrete slab that is perfect to build a shop, she-shed, garage or even a cover for boat storage. \r\nSo, if you are a family looking to plant roots or looking to retire and settle down this is the home you have been looking for.' ,`Acres` = '0.93' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A10732 A J P M SMITH ABST TRACT 7 .93 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '40511' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '464 - Dawson (Navarro)' ,`SchoolElementary` = 'DAWSON ELEMENTARY SCHOOL (DAWSON)' ,`SchoolHigh` = 'DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'DAWSON HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Smith' ,`TaxAmount` = '1764' ,`TaxRate` = '1.8965' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675093241' WHERE `Matrix_Unique_ID` = '213470833'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T17:17:05.903' ,`MLSNumber` = '84787461' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Kiani Komeizi' ,`SellingOfficeName` = 'Kiani Realty, LLC' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '275490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ternberry Forest Lane' ,`StreetNumber` = '5126' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT 1 STORY! Wonderful Split Plan Interior Design! Island Kitchen with Lots of Cabinetry & Corner Walk-In Pantry Opens to Spacious Living Room & Lovely Dining Area! Privately Located Primary Suite Features Great Bath with Large Shower & Big Walk-In Closet! Generously Sized Indoor Utility Room! Covered Patio Enhances Backyard Setting! Easy Access to I-10 & the Grand Parkway! Estimated Completion - November 2022.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 37 - Block 2 - Section 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093242' WHERE `Matrix_Unique_ID` = '213926143'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T18:04:41.010' ,`MLSNumber` = '55543088' ,`ListAgentFullName` = 'Jacque Carter' ,`ListOfficeName` = 'The Carter Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.563908' ,`Longitude` = '-95.568491' ,`PhotoCount` = '45' ,`PostalCode` = '77358' ,`RoomCount` = '9' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Gold Leaf' ,`StreetNumber` = '4' ,`StreetSuffix` = 'Lane' ,`City` = 'New Waverly' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Huge beautiful new/2022 home on 1 ac.  5 yr. Warranty. 2128 Sqft. w/5 bedrooms 3 full baths, Large Living area open to Dining and Kitchen area.  Great for entertaining.  Nice Covered front porch and large back porch off the large utility room.  Has room for Freezer.  Comes with Refreigerator.  Skirting, celing fans and some lighting still being installed.  Corner lot.' ,`Acres` = '1.05' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'New Waverly Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FORGOTTEN FOREST - SEC 1, BLOCK 3, LOT 12' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '45737' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Forgotten Forest' ,`TaxAmount` = '357' ,`TaxRate` = '1.7846' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675093242' WHERE `Matrix_Unique_ID` = '214292669'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T17:37:51.590' ,`MLSNumber` = '52606764' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Mark Haley' ,`SellingOfficeName` = 'eXp Realty LLC' ,`Latitude` = '29.999470' ,`Longitude` = '-95.796825' ,`PhotoCount` = '8' ,`PostalCode` = '77447' ,`RoomCount` = '5' ,`ListPrice` = '359340.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mersmann Ridge Lane' ,`StreetNumber` = '16119' ,`StreetSuffix` = '' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW DR Horton two story home featuring an open concept floor plan!  Modern features include luxurious vinyl plank flooring, beautiful cabinetry, stainless steel appliances and granite countertops!  The primary suite has cultured marble counter tops, double sinks and a separate shower and tub!! Game room!!!  Smart Home Technology, fully landscaped front & back including sprinkler system. Tankless water heater. 3 car garage w/door openers. Large covered back patio. 16-SEER A/C and SO MUCH MORE!  Hurry and call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '22/1/12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6683' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093242' WHERE `Matrix_Unique_ID` = '214384547'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T18:13:53.017' ,`MLSNumber` = '96929917' ,`ListAgentFullName` = 'Brad Shumway' ,`ListOfficeName` = 'Pin Drop Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806282' ,`Longitude` = '-95.377606' ,`PhotoCount` = '14' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Tabor' ,`StreetNumber` = '1612' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This wonderful home is a pleasant surprise and larger than you expect and should not be overlooked… Huge living room with beautiful oak hardwood floors , large original wood windows and French doors that flood the space with Natural light .  Open living  and kitchen for entertaining, offering additional space for island or breakfast table, plus a  separate dining.  Kitchen has site built custom cabinets with tons of storage and two pantries.   Principal Bedroom features vaulted ceilings and French doors to the expansive back yard.  Two spaces currently used as walk-in closets but one can easily accommodate an ensuite bath for the main bedroom. Utility room with side by side W/D.  Quality updates in the last few years and located in a part of the Heights once forgotten, but now on fire!  Call with any questions.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 NORTHWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood J Austin' ,`TaxAmount` = '6673' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093242' WHERE `Matrix_Unique_ID` = '214831976'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T17:02:03.750' ,`MLSNumber` = '82591635' ,`ListAgentFullName` = 'Laura Lujano' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855236' ,`Longitude` = '-95.191357' ,`PhotoCount` = '15' ,`PostalCode` = '77044' ,`RoomCount` = '12' ,`ListPrice` = '309500.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Laurent' ,`StreetNumber` = '9026' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2376' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Have you been looking for the perfect home to start the new year in? This home features close proximity to shopping centers, grocery stores, schools, and the newest addition Starbucks which is NOW OPEN. This home has one of the largest lots in the community. Multiple upgrades throughout the home with an open concept; great for entertainment. Ceramic tile flooring, custom built in wardrobe chest in primary closet, two additional upper wall storage cabinets in primary restroom, frosted and enchanted glass pantry door, soft close cabinetry in kitchen cabinets, base cabinets contain trash can drawer and pot and pan storage organizer. You must come and see all updated features on this home!' ,`Acres` = '0.1663' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2 TIDWELL LAKES SEC 1' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '7245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes Sec 1' ,`TaxAmount` = '7729' ,`TaxRate` = '3.0293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093243' WHERE `Matrix_Unique_ID` = '215085215'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T18:49:23.340' ,`MLSNumber` = '26918932' ,`ListAgentFullName` = 'Kathryn Anne Freeland-Foley' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.917987' ,`Longitude` = '-96.543877' ,`PhotoCount` = '30' ,`PostalCode` = '76679' ,`RoomCount` = '3' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 642' ,`StreetNumber` = '8015' ,`StreetSuffix` = '' ,`City` = 'Purdon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to country living at its best.\r\nThis beautiful home sits on an acre of land out on a quiet paved country road. Just up the way is a cute little county store cafe where you can have a cup of coffee in the morning and catch up on the local talk and on Friday nights have the best catfish dinner and homemade pie.\r\nThis country house is ready for you to move in. It has been well cared for with love and is in excellent condition; and don\'t worry about watering that gorgeous, green yard in the summer because it also has a fully functioning sprinkler system.\r\nIf you love a more modern farmhouse look you can add your own changes and updates to make it your own.\r\nCorsicana is nearby but you are also close to Waco, Waxahachie, Ennis and even Dallas. It\'s the best of both worlds; live a quiet country life with easy access to the city for shopping, eating and entertainment. \r\nSo what are you waiting for?!' ,`Acres` = '1' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A10422 P JACKSON ABST TRACT 14A 1.0 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '464 - Dawson (Navarro)' ,`SchoolElementary` = 'DAWSON ELEMENTARY SCHOOL (DAWSON)' ,`SchoolHigh` = 'DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'DAWSON HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pursley' ,`TaxAmount` = '3046' ,`TaxRate` = '1.8965' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093243' WHERE `Matrix_Unique_ID` = '215106956'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215581479','1675093243','215581479','2022-12-19T17:40:08.913','12707396','Ronnie Matthews','D.R. Horton Homes','David Pichowsky','Redfin Corporation','29.997686','-95.784809','8','77447','4','307740.00','Pending Continue to Show','Mersmann Ridge','16034','','Hockley','2','0','4','1796','Single-Family','FANTASTIC NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! This Open Concept home has a beautiful kitchen/dining room combo open to the living room. Primary bathroom suite with separate soaking tub and shower offers a walk in closet! Features include 36\" Flat panel maple cabinets, exotic granite, 4 burner gas cooktop w/SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard! Call us today to schedule your showing!','','25','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Cypress South','Central Gas','1','LT 39 BLK 2 STONE CREEK RANCH SEC 12','Subdivision Lot','6367','Appraisal District','','800','1','Never Lived In','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Stone Creek Ranch','','','Water District','2022','Builder');  --> New record created successfully<br />