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-11-18T04:43:51.400' ,`MLSNumber` = '24733943' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.067615' ,`Longitude` = '-95.722901' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '385897.00' ,`Status` = 'Active' ,`StreetName` = 'Palfrey Prairie' ,`StreetNumber` = '19426' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Feel right at home in this lovely Beazer Home on a corner lot in Amira, boasting sloped ceilings, tile flooring, a study with French doors, an open great room, and a covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, stainless steel appliances, and 42” cabinets. Spend evenings relaxing in the primary suite, featuring a walk-in closet, dual vanities, a tub, and a separate shower. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are a part of the top-rated Tomball ISD. You don’t want to miss this home – call now!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668790728' WHERE `Matrix_Unique_ID` = '210406761'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T04:41:51.780' ,`MLSNumber` = '69463035' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061746' ,`Longitude` = '-95.720553' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '369353.00' ,`Status` = 'Active' ,`StreetName` = 'Carriage Harness' ,`StreetNumber` = '20935' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Magnificent Beazer home on a cul-de-sac in the gorgeous 484-acre community of Amira features elevated amenities, including a beautiful brick exterior, sloped ceilings, wood-look tile flooring, sprinkler system, energy-efficient features, open great room, and an extended covered patio. Entertain your guests in the kitchen, equipped with quartz countertops, tile backsplash, large cove molding, stainless steel Whirlpool® appliances, 42” upper cabinets, Silgranit® single bowl sink, and pendant lighting. The primary suite has many luxuries, complete with a walk-in closet, dual vanities, and a shower. Stroll through 100-year-old oak trees to find Amira’s world-class comforts, including a glistening infinity-edge pool, clubhouse, dog park, and full fitness center. Situated off the Grand Parkway and Hwy 249, residents are minutes from popular restaurants, shops, and parks in central Tomball and Cypress. Zoned to the top-rated Tomball ISD.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668790728' WHERE `Matrix_Unique_ID` = '211476852'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T04:13:24.850' ,`MLSNumber` = '59184317' ,`ListAgentFullName` = 'Elisa Hanson-Linton' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047510' ,`Longitude` = '-95.373733' ,`PhotoCount` = '22' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Winter Maple' ,`StreetNumber` = '22619' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new 1-story, 1535 sq ft open concept living. Home has been tastefully decorated with the highly sought-after gray scale pallet with a hint of color. Spacious family and dining room area to host all your family and friends. Gourmet island kitchen acts as a center piece in the heart of the home waiting to prepare all your delicious meals. Large primary suite located in the rear for true privacy. Owners baths has double sinks and walk-in closet. Two additional bedrooms flanked by a bathroom.  Easement located to the front of the home so you have more use of your backyard.' ,`Acres` = '0.1648' ,`Area` = '12' ,`BuilderName` = 'Dr. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 4 BRECKENRIDGE WEST SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge West Sec 9' ,`TaxAmount` = '573' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668790728' WHERE `Matrix_Unique_ID` = '212114606'  --> 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','214654365','1668790729','214654365','2022-11-18T03:48:10.273','64917689','MeiMei JamesOu','RE/MAX Fine Properties','','','29.557823','-95.565529','19','77459','12','475000.00','Active','Portuguese Bend','6522','Drive','Missouri City','3','0','5','3458','Single-Family','Beautiful lakefront home in a gated community. This is the dream home you have been waiting for. Don\'t miss!','0.1494','29','','','','','Mud,Sellers Disclosure','1','','1','Missouri City Area','Central Gas','1','WATER\'S EDGE AT COLONY LAKES SEC 2, BLOCK 2, LOT 3','Water View,Waterfront','6509','Appraisal District','','853','0','','2','','0','','','Gas Cooktop','','Composition','19 - Fort Bend','AUSTIN PARKWAY ELEMENTARY SCHOOL','ELKINS HIGH SCHOOL','FIRST COLONY MIDDLE SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Waters Edge At Colony Lakes Sec 2','10876','3.16','Public Sewer','1998','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T03:25:02.860' ,`MLSNumber` = '53599336' ,`ListAgentFullName` = 'Karina B. Flores' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729512' ,`Longitude` = '-95.771863' ,`PhotoCount` = '1' ,`PostalCode` = '77494' ,`RoomCount` = '4' ,`ListPrice` = '674000.00' ,`Status` = 'Active' ,`StreetName` = 'Roberts Run' ,`StreetNumber` = '22938' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3907' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificently astonishing 4 bedroom 4 bathroom remodeled home, in the middle of a quiet cul de sac surrounded by nature walking trails in the heart of Cinco Ranch!\r\nThis 3,907 square foot home offers all of the ideal settings to entertain and enjoy!\r\nWhich include formal living room, formal dining room, office space enclosed with French doors, double split floor plan, various light settings thought out staircase area to achieve the perfect ambience at all times! \r\nA family living room with tall ceilings and high wall windows with a view of the heated pool and jacuzzi! \r\nAn immensely spacious chef’s kitchen with breakfast area and view of the pool! \r\nWith a 15,000 sq foot lot this home also includes a basket ball court, fire glass pit area and so much more yard space to get creative with and enjoy! \r\nLocated a few mins from 99 & La Centerra!' ,`Acres` = '0.3535' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH CINCO FOREST SEC 3, BLOCK 1, LOT 67' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15397' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cinco Ranch Cinco Forest Sec 3' ,`TaxAmount` = '11586' ,`TaxRate` = '2.4795' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668790729' WHERE `Matrix_Unique_ID` = '214781247'  --> 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','214901205','1668790729','214901205','2022-11-18T03:22:49.347','40986442','Gary Lidiak','Berkshire Hathaway HomeServicePremier Properties','','','30.019983','-95.328857','50','77338','12','375000.00','Active','Juniper Springs','6306','Drive','Humble','2','1','4','3672','Single-Family','Better than New Home in Cypresswood Point! This home has it all!  With curb appeal galore, and situated on a spacious cul-de-sac lot, this home boasts a Grand Entry featuring a curved staircase and wrought iron spindles. The chef\'s kitchen has granite countertops, 48\" cabinets and overlooks the large family room and formal dining area. The beautiful 1st floor primary bedroom has a gorgeous bathroom and a \"must-see\" walk-in closet. Upstairs you\'ll find 3 bedrooms, a large media/game room and a bonus room currently being used as an office. There is a covered patio for outdoor entertaining and a sprinkler system and tankless water heater!. The Community includes a recreation area with a park, pool, and playground. With proximity to Deerbrook Mall, Cypresswood Golf Club, and Bush Intercontinental Airport. Ideal for commuters with easy access to U.S. 59 and the Hardy Toll Road.','0.2979','12','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Humble Area West','Central Gas','1','LT 9 BLK 1 CYPRESSWOOD POINT SEC 7','Cul-De-Sac,Subdivision Lot','12976','Appraisal District','','310','0','','2','Freestanding Oven,Gas Oven,Single Oven','0','','','Gas Range','','Composition','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Cypresswood Point Sec 7','9473','2.7734','Public Sewer,Public Water','2019','Appraisal District');  --> New record created successfully<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','214922555','1668790729','214922555','2022-11-18T03:20:32.053','90382143','Judy Anderson','Texas United Realty','','','30.306675','-95.573602','42','77316','8','929900.00','Active','Rolling Oak DR','6467','Drive','Montgomery','2','1','3','2906','Single-Family','Equestrian Estate nestled in 5.882  acres of park-like setting with privacy gate/key pad entrance!! Home features:4 bedrooms, 2 1/2 baths, upstairs game room w/oak wainscoting & custom cabinets, kitchen w/tile floor, granite counters, walk-in pantry, double oven, island & breakfast bar, solar panels for electricity savings, tankless water heaters, dual zone A/C & furnace, large front & back porches. Property boasts over-sized 2 car garage w/custom cabinets, large toy barn/shop garage w/ engineered trusses (no poles), RV porte-cochere w/elec & water, custom 4-stall metal horse barn w/storage, climate-controlled tack room &\r\nautomatic waters/flow meters, & separate hay bldg. Majority of property is fenced with heavy-duty 3-rail vinyl cross fenced paddock area. Invisible Fence dog area and \"Doorman\" dog door. Easy access 2nd entrance for larger vehicles/trailers on Fisher Lake Court. Minutes away from shopping , Woodforest golf course &Woodland Express P&R to Downtown Houston.','5.882','39','','','Electric Dryer Connections','','Home Protection Plan,Sellers Disclosure','1','Gaslog Fireplace','1','Conroe Southwest','Central Electric,Solar Assisted','1','S728109 - MONTGOMERY TRACE 09, BLOCK 3, LOT 16, 17, 18, 19,','Corner','256220','Appraisal District','','1750','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Call Occupant,Controlled Access,Leave Business Card,Supra Keybox','Appraisal District','1.5','Traditional','Montgomery Trace','13095','1.8488','Public Water,Septic Tank','2002','Appraisal District');  --> New record created successfully<br />