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-05T21:25:28.033' ,`MLSNumber` = '43327128' ,`ListAgentFullName` = 'Andrea Parker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.476987' ,`Longitude` = '-95.528755' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '1335000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Fox' ,`StreetNumber` = '2203' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Home located in the highly sought after gated section of Fox Bend! Situated on over half an acre at the end of the cul-de-sac with only one neighbor and other side wooded. Finely finished and thoughtfully designed, this home offers 6374 sq plus an additional 140 sq loft in upstairs bedroom, 5 bed, 5.5 bath, study,formal dining, butlers pantry, oversized breakfast, game room and media room. Many custom features to the home including....wood floors throughout, all LED lights, wood shutters throughout, Kitchen w/large island, 6 burner cooktop, double ovens & all Jenn Air applicances. Two story stone fireplace in family, custom built ins in study, whole home generator, oversized 4 car garage w/epoxy floor and huge walk out attic over entire garage. Backyard oasis includes, outdoor kitchen w/grill,fridge,sink,vent hood,dual side burner, heated pool w/spa, water features & fire bowls and travertine deck.' ,`Acres` = '0.5206' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF DESTREHAN SEC 6, BLOCK 2, LOT 19' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt' ,`LotSize` = '22677' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Destrehan Sec 6' ,`TaxAmount` = '32080' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707207' WHERE `Matrix_Unique_ID` = '207632525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T20:17:06.590' ,`MLSNumber` = '47099089' ,`ListAgentFullName` = 'Alexandra McCauley' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.104235' ,`Longitude` = '-95.609186' ,`PhotoCount` = '35' ,`PostalCode` = '77375' ,`RoomCount` = '3' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Carrell' ,`StreetNumber` = '521' ,`StreetSuffix` = 'Street' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 521 Carrell St in the heart of Tomball. This fully remodeled ranch style home is an absolute dream. Ideal for someone looking to purchase as an investment property (home was previously a rental) or short term rental (no restrictions, allowing you to market as an airbnb or other short term rental if desired). Sitting on a 10K+ corner lot just minutes from downtown Tomball this remodeled 3 bed, 3 bath will impress. Major upgrades include: updated flooring, interior and exterior paint, shaker cabinets in the kitchen and baths, gorgeous backsplash in the kitchen with stainless steel appliances, fresh light fixtures, full exterior fence, fresh landscaping, electrical, plumbing and so much more. This property is sitting at the edge of a newly developed neighborhood, close to local eateries, shopping, restaurants and bars. Minutes from the tollway and major freeways with a quick commute into the city. Currently zoned to Tomball Jr. High and High School. NEVER FLOODED!' ,`Acres` = '0.241' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 46 47 & 48 BLK 84 TOMBALL' ,`LotDesciption` = 'Corner' ,`LotSize` = '10500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kana Place' ,`TaxAmount` = '4121' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663707207' WHERE `Matrix_Unique_ID` = '211138650' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T21:35:26.927' ,`MLSNumber` = '16997011' ,`ListAgentFullName` = 'Jennifer Atkins' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.132651' ,`Longitude` = '-95.562682' ,`PhotoCount` = '38' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '464999.00' ,`Status` = 'Active' ,`StreetName` = 'Winchester' ,`StreetNumber` = '638' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1749' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this charmer of a home situated on over 2 acres in Bar X Ranch. The moment you pull into the driveway you will notice all of the mature trees on this property along with the eye-catching landscape. This home has it all. From walking up to the warm brick exterior, red door entry, and covered porch makes this home picture perfect! As you enter the home, take in the open concept floor plan. You will be able to enjoy the wood burning fireplace in the living room while entertaining guests at the substantial sized bar in the kitchen. This 3 bedroom 2.5-bathroom home boasts over 1,700 sq ft with a covered patio with ceiling fans overlooking the impeccable backyard view backing up to the bayou. \r\nFAST FACTS: Soft roof cleaning 8/22. A/C is 6 years old. Wells electrical controls were replaced and updated in 2017. Septic is serviced every 3 months. Washer, dryer, and refrigerator stay. The decking in the attic is sprayed with Cool Ply for energy saving plus the normal insulation.' ,`Acres` = '2.39' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BAR X RANCH SEC 2 (A0038 J B BAILEY) BLK 1 LOT 56 ACRES 2.3' ,`LotDesciption` = 'Water View' ,`LotSize` = '104108' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'BAR X' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707207' WHERE `Matrix_Unique_ID` = '211510670' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T20:51:42.660' ,`MLSNumber` = '17997593' ,`ListAgentFullName` = 'Christopher Garcia' ,`ListOfficeName` = 'Haven Properties' ,`SellingAgentFullName` = 'Julia Pecina' ,`SellingOfficeName` = 'Camelot Realty' ,`Latitude` = '29.827363' ,`Longitude` = '-95.520942' ,`PhotoCount` = '44' ,`PostalCode` = '77080' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Autauga' ,`StreetNumber` = '9254' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly a picture perfect Spring Branch home. Surrounded by a stunning oak tree, this completely remodeled home includes 4 beds, 2.5 baths, offering plenty of flexibility and functionality throughout. Open layout in the living, kitchen and dining areas are accentuated with crown molding, engineered hardwoods, LED lights and modern decorative fixtures. Kitchen is fully equipped with custom built cabinetry, soft close doors/drawers, marble countertops and stainless appliances. Primary bedroom leads to a tranquil bath with custom built cabinetry, double sinks, quartz countertop, shower, relaxing soaking tub and a walk-in closet. Secondary bedrooms feature a jack and jill bath with custom cabinetry, quartz countertops and elevated decorative fixtures. Spacious back yard provides plenty of room for a pool and patio and features a newly-built storage shed. Recent updates include: a new roof, gutters, electrical panel box, all wiring, 16 Seer HVAC, tankless water heater, plumbing & sewer lines.' ,`Acres` = '0.2231' ,`Area` = '24' ,`BuilderName` = 'Cadema Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 70 BLK H OUTPOST ESTATES SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUFFALO CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Outpost Estates' ,`TaxAmount` = '4344' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707207' WHERE `Matrix_Unique_ID` = '211745779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T20:16:07.683' ,`MLSNumber` = '91673362' ,`ListAgentFullName` = 'Nining Maharddhika' ,`ListOfficeName` = 'Indostar Realty&Property Mgmt' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943878' ,`Longitude` = '-95.626067' ,`PhotoCount` = '34' ,`PostalCode` = '77065' ,`RoomCount` = '8' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Meisterwood' ,`StreetNumber` = '13607' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Honey stop the car!! Please come and see this open layout 1 story home with 3 bedrooms, 2 bathrooms, 2 car garage with formal dining, living area or den with fireplace, and good size covered patio to complete your search. New roof, Lots of updates throughout, including tile wood, fresh paint, new fixtures, and much more. Come and take a look at this house because it wont last long!' ,`Acres` = '0.1848' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 MEISTERWOOD R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '547' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meisterwood R/P' ,`TaxAmount` = '4083' ,`TaxRate` = '2.381' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707207' WHERE `Matrix_Unique_ID` = '211965617' --> 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','212184643','1663707207','212184643','2022-09-05T21:02:35.217','27768111','Jade Ngoc Truong','V-Pro Realtors','','','29.833645','-95.674650','22','77084','8','324900.00','Active','Pine Forest Hollow','3927','Trail','Houston','2','0','3','2195','Single-Family','Nice one story David Weekley home. 4 sides exterior brick. Brand new roof 08 2022. New paint whole house 08 2022. Nice elevation with front porch. Open floor plan. Hardwood floor through out. High ceiling. Breakfast bar open to family room. Many large windows around house. Large primary bedroom. Separate shower and garden bathtub in master bathroom. A small game room between 2nd & 3rd bedrooms. Nice tile floor in garage. Ideal covered patio for big family gathering. Good Cy-Fair ISD Schools. Minutes to I-10, Highway 6, FM 529, Texas Children Hospital and Energy Corridor. House has never flooded. The only 1 story listing in the subdivision. Hurry !','0.1492','8','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Bear Creek South','Central Gas','1','LT 2 BLK 2 PINE FOREST GREEN SEC 1 AMEND','Subdivision Lot','6501','Appraisal District','','495','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS LAKES HIGH SCHOOL','WATKINS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','PINE FOREST GREEN','6059','2.861','Public Sewer,Public Water','2005','Appraisal District'); --> 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','212188400','1663707207','212188400','2022-09-05T20:09:31.587','76682885','Eric Nelson','Compass RE Texas, LLC','','','29.887952','-95.527761','33','77040','4','425000.00','Active','Andante','8726','Drive','Houston','3','1','4','3160','Single-Family','Lovely home in hidden treasure neighborhood of Woodwind Lakes! Roof, paint and carpet in July 2022! Home features four spacious bedrooms, with the primary down, along with a study. The living and kitchen area is open and great for entertainment. Sought after detached, oversized, garage with a long driveway. The backyard has a lovely patio with access off the primary bedroom as well. Call for a tour today!','0.1824','11','','','','','Mud,Sellers Disclosure','','','1','Northwest Houston','Central Gas','1','LT 6 BLK 2 WOODWIND LAKES SEC 3','Other','7944','Appraisal District','','815','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','GLEASON ELEMENTARY SCHOOL','JERSEY VILLAGE HIGH SCHOOL','COOK MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Woodwind Lakes Sec 03','9051','2.591','Water District','1997','Appraisal District'); --> 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','212197884','1663707207','212197884','2022-09-05T20:25:19.573','49106731','Valerie Ward','Texas United Realty','','','29.386170','-94.989268','20','77591','3','164900.00','Active','Anderson','7011','Street','Texas City','1','0','3','1176','Single-Family','Remodeled home features a large kitchen and dining room as the center of a welcoming home. It has lots of natural light with a spacious layout and a large utility room. Updates include new flooring, lighting, cabinets, paint, HVAC, water heater and much more. It\'s a great location close to a neighborhood parks, schools, shopping and much more.','0.1193','33','','','','','Sellers Disclosure','1','','','Texas City','Central Electric','0','ABST 2 S F AUSTIN SUR LOT 45 OLLIE BELL SUB','Subdivision Lot','5197','Appraisal District','','','0','','0','Freestanding Oven','0','','','Freestanding Range','','Composition','52 - Texas City','SIMMS ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required','Appraisal District','1','Ranch','Bell Ollie','','','Public Sewer,Public Water','1947','Appraisal District'); --> New record created successfully