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` = '2023-01-11T22:21:47.630' ,`MLSNumber` = '771059' ,`ListAgentFullName` = 'Hoang Tran' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736978' ,`Longitude` = '-95.343050' ,`PhotoCount` = '12' ,`PostalCode` = '77003' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Hussion' ,`StreetNumber` = '1801' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Investment opportunity. The home located near the University of Houston, and just away from Downtown, easy access to the I-45 freeway. Come with your offer.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 8 PASTORIZA' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pastoriza' ,`TaxAmount` = '5056' ,`TaxRate` = '2.4557' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1927' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675119401' WHERE `Matrix_Unique_ID` = '211132136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-11T22:09:21.100' ,`MLSNumber` = '16681328' ,`ListAgentFullName` = 'Natalie Leal' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.041831' ,`Longitude` = '-95.535291' ,`PhotoCount` = '31' ,`PostalCode` = '77379' ,`RoomCount` = '12' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Lewisham' ,`StreetNumber` = '18407' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2545' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If a cozy community calls to you, this 4/2.5/2 beautiful red brick home is Perfection in a Pocket Neighborhood! A spacious 2-story situated on an interior corner lot is attraction at first sight. Upon entry is a warm and inviting flow; thanks to the combination of tile, engineered wood flooring, carpet, and recently painted walls in uniform color. Expansive Primary Bdrm down, with Primary Bath elegance / 3 Bdrms up, along with a large Gameroom which can peek down below. Extra Walk-In Attic/Storage Space. The home is lovely w/ a location that is prime – convenient access to shops, eateries, parks, and your routes of choice to HWY 249 and the Grand Parkway! Home is ready for Move In, just in time for the New Year!' ,`Acres` = '0.1421' ,`Area` = '13' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 LYNDHURST VILLAGE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6189' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lyndhurst Village' ,`TaxAmount` = '5623' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675119401' WHERE `Matrix_Unique_ID` = '212631428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-11T22:32:18.227' ,`MLSNumber` = '11965147' ,`ListAgentFullName` = 'Mari Berend' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.320854' ,`Longitude` = '-94.770866' ,`PhotoCount` = '11' ,`PostalCode` = '77550' ,`RoomCount` = '3' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Pompano' ,`StreetNumber` = '104' ,`StreetSuffix` = 'Avenue' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your Island Home awaits! Pristine 3br home in desirable Lindale Park on Galveston Island near everything. Blocks from beach, Strand shopping and eateries, UTMB, sports fields with dog park and the Bolivar ferry. Completely remodeled after Hurricane Ike. No broken pipes or loss of power during freeze in 2021 or recently. Lots of open space. Hardwood and Tile Floors throughout. Fenced back yard. This one has it all! Owner works at home please do not disturb. Sellers say Bring us an offer!' ,`Acres` = '0.1344' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 160 LINDALE PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5856' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lindale Park' ,`TaxAmount` = '4306' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675119401' WHERE `Matrix_Unique_ID` = '212703297' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-11T22:28:07.810' ,`MLSNumber` = '85197861' ,`ListAgentFullName` = 'LaNell Shaw' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.724642' ,`Longitude` = '-95.052042' ,`PhotoCount` = '31' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Meridian' ,`StreetNumber` = '342' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable Single Story Log Cabin Style Home on 3 LOTS w/Metal Roof. You’ll be impressed with attention to Rustic Detais - Solid Wood Knotty Pine and Cedar Interior and Vaulted/Beamed Ceiling and Walls that lend quaint Lodge flavor decor. Kitchen offers long Island with full length Breakfast Bar, Knotty Pine Cabinetry and lots of storage and counters. Full Bath has a Separate Tiled Shower and Jetted Tub. Although 2 Bedrooms, Addition to be completed has extra room and plumbing stubbed in for 3rd Bedroom / 2nd Bath and Utility area. Home sits on 2 Lots with Circle Drive leading the way to the Front Sitting Porch with Vaulted Ceiling, so cute. In addition, 1 Car Garage made into Large Workshop. Carport area. Partially Fenced. Adjoining Lot #29 is great for additional elbow room OR a nice Income Rental Producer currently rented - Power, Sewer and Water available to hook up. Central A/C (Window Units can be removed, personal preference). Subdivision Boatlaunch=Access to Lake Livingston.' ,`Acres` = '0.25' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE SECTION 2 LOT 29,30,31' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '11000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '48' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lake Livingston Village Sectio' ,`TaxAmount` = '2499' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675119401' WHERE `Matrix_Unique_ID` = '212868903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-11T22:06:22.983' ,`MLSNumber` = '69999577' ,`ListAgentFullName` = 'Evan Ballew' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.837771' ,`Longitude` = '-95.157274' ,`PhotoCount` = '50' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Mistletoe' ,`StreetNumber` = '247' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This absolutely STUNNING custom 3 bedroom, 2 bath, 1 story NEW home is nestled in the lake community of Creekside Estates in Onalaska. There is no mistaking the amount of quality and pride the builder took in creating this superior home! Inside features upgrades GALORE including crown molding, designer oversize tile flooring, beautiful granite counters w/ a large island in the kitchen, custom cabinets throughout the entire home and Smart stainless steel appliances and lighting! The master suite has elevated ceilings with a walk-in closet complete with custom cabinet organizers. The elegant master ensuite has double sinks and an INCREDIBLE walk-in shower. Both guest suites have wood wrapped windows, ceiling fans, and ample closet space. A fabulous mud room features a built-in desk and additional cubbies and cabinets for extra storage. The wooded lot offers optimal privacy and is ready for a pool or outdoor living area! Neighborhood boat launch into Lake Livingston and community park too' ,`Acres` = '0.2571' ,`Area` = '44' ,`BuilderName` = 'Alejandro Razo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSIDE SECTION 2 BLK 8 LOT 10' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Sec 2' ,`TaxAmount` = '2364' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675119402' WHERE `Matrix_Unique_ID` = '214475667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-11T21:42:55.200' ,`MLSNumber` = '44785633' ,`ListAgentFullName` = 'Robert Saji' ,`ListOfficeName` = 'Zameen Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.449970' ,`Longitude` = '-95.083880' ,`PhotoCount` = '21' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Sawyer Gully' ,`StreetNumber` = '412' ,`StreetSuffix` = 'Court' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2006' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will find this home close to all the amenities your looking for. quick access to the freeway hidden between other neighborhoods. This home has 3 bedroom and 3 full bathrooms. You will notice many wonderful updates throughout the home. An all brick construction is evidence of a well built home. Make an appointment to see it now.' ,`Acres` = '0.1718' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BORDEN\'S GULLY (2007) ABST 19, BLOCK 2, LOT 6, ACRES 0.172' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7483' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bordens Gully 2007' ,`TaxAmount` = '6834' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675119402' WHERE `Matrix_Unique_ID` = '215104540' --> 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','215169892','1675119402','215169892','2023-01-11T21:46:05.453','20292986','Kristin Logan','NB Elite Realty','','','29.599893','-95.121226','40','77059','5','325000.00','Active','Dunmoor','15703','Drive','Houston','2','1','4','2304','Single-Family','Welcome home! Move-in ready. New Luxury Vinyl Plank, New carpet and pad in bedrooms, New Paint, New tile, New Quartz countertops, New Ceiling Fans, New Lighting upstairs and down, Pool was JUST replastered and tiled, New Appliances (under warranty), New Fixtures, New Tubs, New Toilets.....so much love and care has been put into this home, just for you! Bedrooms are all very spacious. Backyard is huge featuring a deck and pergola, with room for a small garden, playset or room for kids or pets to run. CCISD!!!!!! HEB is literally less than a mile (0.6) away. Restaurants, Shopping, Nasa, Space Center, Sam Houston Tollway, Kemah, are all SO close. You\'ll love this home, location, neighbors and the schools. Middlebrook offers great walking trails, tennis courts, pool and playground! Call for a private tour, or have your Realtor schedule a showing with my easy online showing appointment maker.','0.2204','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','','Gas Connections','1','Clear Lake Area','Central Gas','1','LT 30 BLK 26 MIDDLEBROOK SEC 2','Corner,Subdivision Lot','9600','Appraisal District','','500','0','','2','Convection Oven,Electric Oven','1','Gunite,In Ground','','Electric Cooktop','','Composition','9 - Clear Creek','ARMAND BAYOU ELEMENTARY SCHOOL','CLEAR LAKE HIGH SCHOOL','SPACE CENTER INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Mediterranean,Traditional','Middlebrook Sec 02','7487','2.5769','Public Sewer,Public Water','1978','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','215443670','1675119402','215443670','2023-01-11T22:20:08.793','16130827','Katherine Le','1 - Connect Realty','','','30.018062','-95.612757','22','77377','3','268990.00','Active','Gulf Willow','17411','Court','Tomball','2','0','3','1234','Single-Family','Welcome to this 2021 stunning 1 story home in the peaceful Willow Wood Place community. Home is practically new and features modern brick elevation and open floor concept. Modern island kitchen style complete with granite countertops, a tile backsplash, Energy Star® appliances, and 42” cabinets. The relaxing primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. More over is the full gutters, faux wood blinds, and a covered patio. Community amenities include a park with a playground and open green space. Please call today for more details and private showings.','0.1135','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Tomball South/Lakewood','Central Gas','1','LT 3 BLK 1 WILLOW WOOD PLACE SEC 1','Other','4942','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','53 - Tomball','WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)','TOMBALL MEMORIAL H S','WILLOW WOOD JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Willow Wood Place','6613','2.7564','Water District','2021','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','215581543','1675119402','215581543','2023-01-11T21:53:16.703','65218226','Shelly Bishop','316 Realty Group','','','30.421530','-95.628551','43','77356','10','625000.00','Active','Sunnyvale','267','','Montgomery','3','1','3','3174','Single-Family','Location, Location, Location!! This very quiet, lovely home, that has wood floors and plantation shutters, looks out over Bentwater\'s driving range and the lake. One of the highest points in Bentwater. Walking distance to dinner, to workouts, to tennis, to the spa or to the junior Olympic lane pool. Kitchen has island, along with 2 sinks, built in microwave, oven and warming drawer. It\'s also open to the upstairs balcony. Family room has a built in entertainment center & gas log fireplace. Study/office is located on the 1st floor. Primary bedroom located on the 1st floor, has room for a sitting area along with access to the back screened porch w/ 3 fans & tile floor. Primary bathroom was redone in 2018. 2 bedrooms upstairs with 2 full baths. Upstairs also has an extra space that could be a game/media room or 4th bedroom. Make your appointment today, you won\'t be disappointed.','0.2374','39','','','Electric Dryer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Lake Conroe Area','Central Gas','1','BENTWATER 31, BLOCK 1, LOT 9','Cul-De-Sac,In Golf Course Community,On Golf Course,Water View','10341','Appraisal District','','1146','0','','3','Electric Oven','0','','','Electric Cooktop','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Bentwater','8482','2.1142','Public Sewer,Public Water,Water District','2005','Seller'); --> 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','215976878','1675119402','215976878','2023-01-11T22:52:58.080','42578064','David Cole','First Class, Realtors®','','','29.742319','-95.632933','50','77077','18','3000000.00','Active','Chatham Creek','2407','Court','Houston','6','2','5','8404','Single-Family','Truly Custom Mediterranean Home located on one of the best waterfronts in the neighborhood. The property has 180-degree view of the lake, and you can just sit and feel the tranquility on this location. The property features Beautiful double medal doors, a double stairs entry with a gorgeous chandelier. Arch niches throughout the property. Mirrored dance studio/exercise room. 4 car garage with built-ins. Plenty of living and entertaining areas. The primary bedroom and primary bath are must-see along with the custom walk-n closets. The Gourmet kitchen has a Sub-Zero Refrigerator, 5 burner gas range, and Wolf double ovens. All of the marble floors have been imported and the attention to detail is obvious once you drive up the extra-wide driveway. The home is located in a 24-Hour Guard Gated Community. This home shows a pride of ownership, and you feel the positive energy once you enter it. The views of the lake from every room downstairs are priceless. Motivated seller says bring offers.','0.2697','31','Kickerillo Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','4','Energy Corridor','Central Gas','1','LT 5 BLK 3 LAKES OF PARKWAY SEC 16 AMEND 2','Cul-De-Sac,Subdivision Lot,Water View,Waterfront','11749','Appraisal District','','2500','0','','4','Gas Oven','0','','','Gas Range','','Tile','27 - Houston','BUSH ELEMENTARY SCHOOL (HOUSTON)','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Contemporary/Modern,Split Level,Traditional','Lakes of Parkway','44944','2.3907','Public Sewer,Public Water,Water District','2007','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','216225373','1675119402','216225373','2023-01-11T21:42:22.957','78989615','Elizabeth Manriquez','Vive Realty LLC','','','30.178661','-95.167975','36','77357','4','469000.00','Active','Whispering Pine','2218','','Montgomery','3','0','3','2088','Single-Family','Beautiful new custom built home located in popular Roman Forest TX. It is a 3 bedroom, 3 car garage with electrical vehicle charging stations, office/study room with a closet that can be converted into a 4th bedroom. Home features include modern pivot door, tall ceilings, plenty of natural lighting throughout home coming from big windows, electric fireplace, LED lighting throughout home, Samsung appliances, quartz countertops, custom high cabinets, tile floor throughout the home and carpet in bedrooms. Amazing covered back patio with a large backyard. NO BACK NEIGHBORS!! Roman Forest is off of I-69 and minutes from the Grand Pkwy and Valley Ranch Town Center. Quiet, safe and friendly neighborhood which has a community pool, splash pad, pavilion and park for residents. Deed restrictions, No HOA, No Fees!! Minutes from The Grand Parkway/99 and the amazing new Valley Ranch Town Center. Schedule your appointment today!','0.4591','40','EENN HOMES, LLC','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Mock Fireplace','1','Porter/New Caney East','Central Electric,Central Gas','0','ROMAN FOREST 01, BLOCK 11, LOT 5','Subdivision Lot','20000','Appraisal District','','','1','To Be Built/Under Construction','','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','39 - New Caney','DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox','Builder','1','Contemporary/Modern','Roman Forest 01','959','2.9064','Public Sewer,Public Water','','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','216308901','1675119402','216308901','2023-01-11T21:10:32.073','18093644','Shannon Butler','Next Home DA Assests','','','30.044565','-95.369072','26','77373','11','259000.00','Active','Hirschfield','4219','Road','Spring','2','0','4','1984','Single-Family','Fabulous 4 bedroom, 2 bath two-story home located in Birnam Wood with lots of Updates .Oversized huge spacious double lot with large backyard. This home also includes the corner lot next to it. High Vaulted Ceilings. Updated interior and Brand new carpet in ALL carpeted areas. Home is vacant and ready for immediate move-in. This one will not last, Make your appointment to see it today!','','12','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Spring East','Central Electric','1','Res A2 Blk 1 Birnam Wood Sec 2','Corner,Subdivision Lot','23771','Appraisal District','','350','0','','2','Electric Oven','0','','','Electric Range','','Composition','48 - Spring','MILDRED JENKINS ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern','Birnam Wood','','','Public Sewer,Public Water,Water District','1983','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','216310053','1675119402','216310053','2023-01-11T22:00:19.967','73736250','Derek Boles','Legacy Homes & Properties, LLC','','','29.694741','-94.936008','19','77523','3','130000.00','Active','Bluebill Bay','126','','Baytown','2','0','3','1120','Single-Family','Great property and newly renovated, you will love this one once you take a peek at it.','0.0957','2','','','','','Owner/Agent,Sellers Disclosure','','','','Baytown/Harris County','Central Gas','1','LT 5 BLK 8 BAY OAKS HARBOR AMENDED','Subdivision Lot','4170','Appraisal District','','27','0','','0','','0','','','','','Aluminum','23 - Goose Creek Consolidated','LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Appointment Required','Appraisal District','1','Traditional','Bay Oaks Harbor Amd','832','2.97','Water District','1978','Appraisal District'); --> New record created successfully