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-09-04T12:58:57.637' ,`MLSNumber` = '82060382' ,`ListAgentFullName` = 'Michele Kimmons' ,`ListOfficeName` = 'Michele Kimmons Properties,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.734494' ,`Longitude` = '-95.212643' ,`PhotoCount` = '26' ,`PostalCode` = '77364' ,`RoomCount` = '0' ,`ListPrice` = '315888.00' ,`Status` = 'Active' ,`StreetName` = 'Hwy 156' ,`StreetNumber` = '641' ,`StreetSuffix` = '' ,`City` = 'Point Blank' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '3200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous barndominium on main highway 156, 3200 SF with plenty of parking.  Office is in the commercial area of the subdivision. Subdivision has lake access, a pool, and recreational area. 1200 SF of space that\'s has a reception area up front, conference room, 4 rooms can be used as extra offices, kitchen, bath,room, and storage area.  3 sections to this building, Section A & C have 1000 SF and are open and have electrical wiring, and pre-plumbed. Section B is the 1200 SF built out.   Tons of unfinished space available to be designed however you\'d like.  A Sections A & C are wired for electricity, pre-plumbed, and has a security system set to section B. Great for any type of business, or personal residence.  Can be used as a single family home.  Don\'t miss!!!' ,`Acres` = '0.626' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GOVERNORS POINT, LOT PT OF RESERVE B, ACRES .4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '27269' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'Governors Point (commercial section)' ,`TaxAmount` = '2713' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706703' WHERE `Matrix_Unique_ID` = '203885716'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T12:29:35.497' ,`MLSNumber` = '72291253' ,`ListAgentFullName` = 'Ginger Mosley' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Yazmin Prado' ,`SellingOfficeName` = 'Keller Williams HoustonCentral' ,`Latitude` = '29.546456' ,`Longitude` = '-95.271797' ,`PhotoCount` = '37' ,`PostalCode` = '77581' ,`RoomCount` = '11' ,`ListPrice` = '300000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Maryfield' ,`StreetNumber` = '3211' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Refreshed & Ready to go!  You Will be Wowed by this Fabulous & Spacious Floor Plan. This Lovely Home is in a Quiet, Well Kept Neighborhood With Easy Access for Commuting. Large Combined Living and Dining Area Opens to Cozy Family Room W/Corner Fireplace. Island Kitchen With Granite Countertops and Recent Tile Adjoins Sunlit Breakfast Room and  Connects to Family Room.  Double French Doors Open From Breakfast Room for You to Enjoy The Partially Covered and Large Extended Stone Patio in the Large Back Yard With No Back Neighbors. Most Fencing Recently Replaced. Downstairs Guest Bath Has Custom Furniture Style Vanity With Granite Top. Upstairs Find a Spacious Game Room With Custom Built-Ins. Primary Suite is ENORMOUS and Includes a Large Sitting Area/En-Suite Bath w/Soaking Tub,Shower,Updated Farm House Style Vanity &Walk-In Closet w/Custom Shelving.Fresh Interior&Exterior Paint. *room sizes esimates,extra room is the combined size of the Formal living/dining area-buyer verify all info' ,`Acres` = '0.1515' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER MIST SEC 1 (A0507 ACH&B) PEARLAND , BLOCK 1, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Mist Sec 1&2' ,`TaxAmount` = '7008' ,`TaxRate` = '2.8851' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706703' WHERE `Matrix_Unique_ID` = '209273906'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T12:13:03.207' ,`MLSNumber` = '48279200' ,`ListAgentFullName` = 'Edgar Rodriguez' ,`ListOfficeName` = 'Spark Real Estate Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.948305' ,`Longitude` = '-95.380663' ,`PhotoCount` = '30' ,`PostalCode` = '77032' ,`RoomCount` = '6' ,`ListPrice` = '169888.00' ,`Status` = 'Active' ,`StreetName` = 'Gateside' ,`StreetNumber` = '855' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1999 Built Double Wide Manufactured home. 4 bedroom 2 bath approximately 1760 Square feet with detached carport. Fully fenced. Dimensions of rooms are approximate, buyer to verify all dimensions. Easy access to N. Beltway 8 and Hardy Toll road.' ,`Acres` = '0.2704' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 BLK 1 GATEWOOD' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CALVERT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Gatewood Sec 01' ,`TaxAmount` = '801' ,`TaxRate` = '2.1545' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706703' WHERE `Matrix_Unique_ID` = '210684736'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T13:55:17.607' ,`MLSNumber` = '24040864' ,`ListAgentFullName` = 'Jyothi Reddy' ,`ListOfficeName` = 'Excel Realty Co' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932435' ,`Longitude` = '-95.631415' ,`PhotoCount` = '16' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'White Oak Trace' ,`StreetNumber` = '10834' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2295' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING SINGLE FAMILY RANCH HOME IN THE WELL MAINTAINED NEIBHORHOOD. OPEN FLOOR PLAN, PLENTY OF SUNLIGHT, OPEN KITCHEN.PRE-WIRED, SECURITY SYSTEM,  NICE BACK-YARD WITH COVERED PATIO/PERGOLA AND SWING, SPRINKLER SYSTEM. CLOSE TO SCHOOLS, SHOPPING, HOSPTIALS, 290 FREEWAY. CFISD SCHOOLS. WALKING DISTANCE TO NORTH CYPRESS MEDICAL CENTER. YOU DON\'T WANT TO MISS IT!\r\nSCHEDULE YOUR APPOINTMENT TODAY.' ,`Acres` = '0.1653' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 1 WHITE OAK SPRINGS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7201' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LAMKIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'White Oak Spgs Sec 1' ,`TaxAmount` = '5307' ,`TaxRate` = '2.551' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706703' WHERE `Matrix_Unique_ID` = '211333565'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T12:20:53.713' ,`MLSNumber` = '23327984' ,`ListAgentFullName` = 'Hai Huynh' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986553' ,`Longitude` = '-95.446681' ,`PhotoCount` = '24' ,`PostalCode` = '77014' ,`RoomCount` = '4' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Bonnyton' ,`StreetNumber` = '1606' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated home with 4 bedrooms, 2.5 bathrooms, 2-story. No carpet, laminate and New vinyl flooring throughout. This home is located near I-45 and Beltway 8 with easy commute to Downtown, Medical Center and The Woodlands. Only 10-15 to Bush International Airport. Please schedule your showing today!' ,`Acres` = '0.101' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 GLEN ABBEY SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Abbey Sec 4' ,`TaxAmount` = '4711' ,`TaxRate` = '2.7192' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706703' WHERE `Matrix_Unique_ID` = '211743342'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T12:16:04.977' ,`MLSNumber` = '36708335' ,`ListAgentFullName` = 'Tessa Flight' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = 'Alexsandra Velez' ,`SellingOfficeName` = 'Nextgen Real Estate Properties' ,`Latitude` = '29.803493' ,`Longitude` = '-95.355224' ,`PhotoCount` = '6' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '415000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Gano' ,`StreetNumber` = '4804' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2037' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Imagine living just a few blocks from downtown, with views of Houston’s iconic skyline and easy access to major freeways and METROrail. Now imagine acquiring a newly built home here at an unbeatable price. At Gano Square, you can do both—and you can do so in style. There are wows as soon as you walk in, from engineered hardwood, stainless steel intersects with quartz, and contemporary light fixtures.  From bike lanes and boutique retail to the epic cultural hub of Hardy Yards, the future of Houston’s North Downtown is bright and happening. With the buzz of the Heights, the bars of Washington, and the business center of America’s fourth largest city but a few minutes away, this up-and-coming neighborhood with a small-town feel has the best of both worlds: historic charm and big plans ahead. Scheduled for completion in late Summer 2022, reserve your unit today! 6 total units available in this outstanding development! Perfect for Living or investing!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Stoneworks' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Block 1, Lot 6, Reserve 1' ,`LotDesciption` = 'Other' ,`LotSize` = '1800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Gano' ,`TaxAmount` = '' ,`TaxRate` = '2.4' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706703' WHERE `Matrix_Unique_ID` = '211783611'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T12:29:43.950' ,`MLSNumber` = '52674459' ,`ListAgentFullName` = 'Aric Rodriguez' ,`ListOfficeName` = 'West Bloc Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.180592' ,`Longitude` = '-95.159554' ,`PhotoCount` = '11' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Cassius' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Court' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quiet country living on almost half an acre in lovely Roman Forest Subdivision. Two story home sparkling private swimming pool, detached garage, and fully fenced back yard. Updates include, crown molding, tile flooring throughout first floor, new carpet, recent paint inside, indoor laundry, tons of storage, large master closet, granite counter tops. Make your appointment today!' ,`Acres` = '0.4373' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 02, BLOCK 2, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19047' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest 02' ,`TaxAmount` = '3099' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706704' WHERE `Matrix_Unique_ID` = '211935882'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T12:42:58.280' ,`MLSNumber` = '16434062' ,`ListAgentFullName` = 'Tom Virippan' ,`ListOfficeName` = 'TV International Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.591568' ,`Longitude` = '-95.540434' ,`PhotoCount` = '7' ,`PostalCode` = '77489' ,`RoomCount` = '8' ,`ListPrice` = '369990.00' ,`Status` = 'Active' ,`StreetName` = 'Heritage' ,`StreetNumber` = '2438' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2494' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular2020 built, comparatively new home, featured 5 Bedrooms 3 Full Bath with 2 Bed Rooms on first Floor. Fabulous Primary bedroom and Game room. Covered Patio with Gas connection is another attraction. Stainless steel appliances and granite counter top. Situated with in easy reach of shopping and leisure centers. HWY 6, HWY59, are just minutes away. Walking distance to Elementary school and Community Park. Come Grab this Gem of a Home.' ,`Acres` = '0.1231' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LIBERTY RIDGE SEC 1, BLOCK 1, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5361' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'EDGAR GLOVER JR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Ridge Sec 1' ,`TaxAmount` = '7080' ,`TaxRate` = '2.5525' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706704' WHERE `Matrix_Unique_ID` = '211958592'  --> 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','212128849','1663706704','212128849','2022-09-04T13:41:02.923','5369457','Jimmy Franklin','Newmark Homes','','','29.565029','-95.745411','23','77469','9','715000.00','Active','Wilkinson','23419','Trail','Richmond','4','1','4','3291','Single-Family','NEWMARK HOMES\' new construction the Cambridge has a 3 car split garage. You are greeted by a courtyard entry with double 8 foot entry doors. The open bright family room has a 20 foot ceiling. The beautiful open main entry has wood floors throughout the main 1st floor living areas including the main bedroom and guest room on the 1st floor. The kitchen features upgraded appliances and a large serving island and separate butler\'s pantry adjacent to the formal dining room for convenient guest serving. There are two beds up. There are 4.1 baths giving each bed its\' own bath. Go upstairs and you will find plenty of entertaining space in the 20x14 spacious game room and the nearby media room. This home is for beauty, entertaining, luxury living and relaxation.','','30','Newmark Homes','','Electric Dryer Connections,Washer Connections','','Levee District,Mud','1','Mock Fireplace','1','Fort Bend South/Richmond','Central Gas','1','Lot 17 Block 1','Corner,Subdivision Lot','9718','Survey','','1095','1','To Be Built/Under Construction','3','Convection Oven,Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','PHELAN ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Accompany','Builder','2','Contemporary/Modern','Veranda','','3.17','Public Sewer,Public Water,Water District','2022','Builder');  --> New record created successfully<br />