Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T01:22:01.430' ,`MLSNumber` = '54334085' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Joely Contreras' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.200899' ,`Longitude` = '-95.337628' ,`PhotoCount` = '39' ,`PostalCode` = '77302' ,`RoomCount` = '16' ,`ListPrice` = '599638.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Berry Brook' ,`StreetNumber` = '14984' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston III, Elevation IS) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Private Primary Suite with large walk-in closet. Spacious kitchen open to Family Room. Dining Room and Study. Media Room and Game Room upstairs. Covered patio and 2 car attached garage. Artavia, a master-planned community, will thrill you with endless possibilities just minutes from your home in Conroe, Texas. You’ll enjoy wide, outdoor spaces great for an active lifestyle and its convenient location. Onsite school is currently under construction! Stop by the Westin Homes model home today to find out more about Artavia!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8534' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707650' WHERE `Matrix_Unique_ID` = '206113375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T01:22:01.430' ,`MLSNumber` = '27493823' ,`ListAgentFullName` = 'Michael Joseph' ,`ListOfficeName` = 'The B-Spot Real Estate & Investment, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.964220' ,`Longitude` = '-95.226416' ,`PhotoCount` = '17' ,`PostalCode` = '77396' ,`RoomCount` = '7' ,`ListPrice` = '258000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Villa' ,`StreetNumber` = '16710' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is a three bedroom two bathroom home. The home has an open floor plan that will allow for plenty family bonding. Primary bath has a garden tub which allows plenty of time to relax after a hard week at work.' ,`Acres` = '0.1143' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 2 ATOSCOCITA TRACE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '366' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIVER PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Trace Sec 5' ,`TaxAmount` = '6063' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707650' WHERE `Matrix_Unique_ID` = '209722481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T01:22:01.430' ,`MLSNumber` = '74404054' ,`ListAgentFullName` = 'Stephany Williams' ,`ListOfficeName` = 'Lakeside Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.425926' ,`Longitude` = '-95.582453' ,`PhotoCount` = '36' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Point Aquarius' ,`StreetNumber` = '12603' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1897' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The perfect vacation home or a homestead! Come park your boat or RV! Situated behind Lake Conroe you are only minutes from open water using the neighborhood boat launch! You are a two-minute walk to the boat launch, pool, volleyball, basketball courts, playground, community center that hosts bridge, bunko, bingo, & exercise classes. This home is on a LARGE 1/2 lot. It has 3 bedrooms w/a flex room that can be used for a study, music room or a 4th bedroom, 2.5 baths, the Primary bath has large garden tub and two closets! Coming through the front door you enter into the living area that is open to the breakfast room & kitchen. Kitchen has the coveted gas cooking and breakfast bar/serving area. PEX piping, ceiling fans in every room, 3 zoned sprinkler system, Large covered concrete patio in the backyard to block the sun & rain! This home has tons of storage. Security motion lights, recent a/c. Golf carts allowed on the streets, 24-hr manned gate, low taxes!' ,`Acres` = '0.49' ,`Area` = '39' ,`BuilderName` = 'Precision Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S809003 - POINT AQUARIUS 03, BLOCK 1, LOT 8, 9' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '21255' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Point Aquarius 03' ,`TaxAmount` = '5323' ,`TaxRate` = '2.2748' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707651' WHERE `Matrix_Unique_ID` = '210291143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T00:05:52.990' ,`MLSNumber` = '44554309' ,`ListAgentFullName` = 'Stephen Sheffer' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.124236' ,`Longitude` = '-95.515533' ,`PhotoCount` = '32' ,`PostalCode` = '77389' ,`RoomCount` = '9' ,`ListPrice` = '539900.00' ,`Status` = 'Active' ,`StreetName` = 'Holden Mills' ,`StreetNumber` = '6306' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3562' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated 4 bedroom 3.5 bath 2-story home in Auburn Lakes on a cul-de-sac lot features a 2-story entry and stunning family room w/ 18 foot ceilings & stacked windows that overlook the oasis like backyard and pool! The home features an open floor plan. Private primary suite down w/ updated primary bath, dual walk in closet & door from the sitting area to the backyard for private escapes! Large gourmet island kitchen with recently updated custom cabinets, lighting, Azurite countertops, & stainless steel appliances. Downstairs is complete with formal dining and study. Oversized game room upstairs with 3 large bedrooms & two baths. 3-car detached garage! Recent roof (\'22), pool resurface (\'22), interior paint (\'22), and new carpet! Zoned to outstanding Klein ISD schools!' ,`Acres` = '0.3017' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 2 VILLAGE OF AUBURN LAKES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Auburn Lakes Sec 01' ,`TaxAmount` = '10408' ,`TaxRate` = '2.914' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707651' WHERE `Matrix_Unique_ID` = '211344269' --> Updated record success
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','211487338','1663707651','211487338','2022-09-07T00:20:40.667','75840333','Anjetta King','Fathom Realty','','','32.453393','-94.721458','2','75602','3','190000.00','Active','Johnson St','411','Street','Longview','2','0','3','1420','Single-Family','New construction 3/2/2 carport located in East Texas in a revitalizing community. Scheduled to be complete by 9/6/2022.','0.5785','84','Mejia Construction','','Electric Dryer Connections','','Sellers Disclosure','','','','','Central Electric','0','LTS 17 & 18 BLK 11 (NCB 1361) ROLLINS SCHOOL','Subdivision Lot','25200','Appraisal District','','','1','Never Lived In','0','','0','','','','','Aluminum','690 - Longview','NED WILLIAMS','LONGVIEW HIGH SCHOOL','FOSTER MIDDLE SCHOOL','Temporarily No Showings','Builder','1','Contemporary/Modern','Rollins School','65','2.2711','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
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','211889808','1663707651','211889808','2022-09-07T01:12:25.437','66256652','Myron Jefferson','Equity House Properties','','','29.667029','-95.611879','16','77099','6','209000.00','Active','Crow Valley','12811','Lane','Houston','2','0','3','1767','Single-Family','Selling as-is. Offers both formals, covered front porch, covered rear patio, private/concealed garage and driveway, and a spacious primary bedroom. A/C and furnace (2016), A/C coil (2022). The home has not flooded.','0.1528','29','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure,Special Addendum','1','Freestanding,Wood Burning Fireplace','1','Stafford Area','Central Electric','1','HUNTINGTON VILLAGE SEC 4, BLOCK 38, LOT 41','Subdivision Lot','6658','Appraisal District','','177','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','MEADOWS ELEMENTARY SCHOOL (FORT BEND)','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Huntington Village Sec 4','2739','2.2137','Public Sewer,Public Water','1975','Appraisal District'); --> New record created successfully