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-12-16T15:51:56.813' ,`MLSNumber` = '94677034' ,`ListAgentFullName` = 'James Monk' ,`ListOfficeName` = 'J. Frank Monk Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947931' ,`Longitude` = '-96.258777' ,`PhotoCount` = '39' ,`PostalCode` = '77418' ,`RoomCount` = '9' ,`ListPrice` = '449500.00' ,`Status` = 'Active' ,`StreetName` = 'Holland' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Street' ,`City` = 'Bellville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built on a large lot with manicured landscaping in the historic town centre of Bellville, Texas. The well layed out generous 4 bed, 2 bath floor plan features spacious room sizes and a open living concept. Adjoiing the living room is the stylish kitchen with granite island perfect for casual dining along with an additional dining area. Outside the generous lot size is reflected with the 2 carports, RV/boat covered parking, seperate 45x27 ft garage/workshop, and covered patio for entertaining. Rounding out this home is location, within walking distance of the town square lined with shops and dining as well as close to schools and lots of other local amenitites. This home is the perfect combination of cozy and functional indoors and out.' ,`Acres` = '0.469' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST A073 J NICHOLS' ,`LotDesciption` = 'Other' ,`LotSize` = '20430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '5351' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091806' WHERE `Matrix_Unique_ID` = '208532467' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T15:33:23.817' ,`MLSNumber` = '74239147' ,`ListAgentFullName` = 'Willie Harris' ,`ListOfficeName` = 'Keyhole Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015620' ,`Longitude` = '-95.383295' ,`PhotoCount` = '11' ,`PostalCode` = '77073' ,`RoomCount` = '11' ,`ListPrice` = '229700.00' ,`Status` = 'Active' ,`StreetName` = 'Travick' ,`StreetNumber` = '2919' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2453' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ULTIMATE IN ELEGANCE THIS BEAUTIFUL MODEL PLAN IS ON A TREED CORNER HOMESITE WITH SIDE ENTRY 3 CAR DETACHED GARAGE, GORGEOUS INTERIOR FEATURES, 4 BEDROOMS, CHARMING KITCHEN AND A LUXURY MASTER BEDROOM RETREAT! HUGE OWNER SUITE THAT OPENS INTO A GORGEOUS SUITE BATH WITH DOUBLE VANITY SINKS, SEPERATE SHOWER AND MASTER TUB AND A HUGH WALK-IN CLOSET' ,`Acres` = '0.225' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 505 BLK 16 WOODCREEK SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '9800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodcreek Sec 02' ,`TaxAmount` = '5214' ,`TaxRate` = '2.6145' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675091806' WHERE `Matrix_Unique_ID` = '209628923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T16:47:54.150' ,`MLSNumber` = '93737039' ,`ListAgentFullName` = 'Wendi Bangoy' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.071602' ,`Longitude` = '-94.035217' ,`PhotoCount` = '48' ,`PostalCode` = '75931' ,`RoomCount` = '6' ,`ListPrice` = '368000.00' ,`Status` = 'Active' ,`StreetName` = 'Parkside' ,`StreetNumber` = '240' ,`StreetSuffix` = 'Loop' ,`City` = 'Brookeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to start living on lake time? This comfy 3 Bed/ 2 Bath located on Parkside Loop just off of Lake Shore Dr in beautiful Rayburn Country is ready to become your temporary or permanent address! This property features an open concept living area with vaulted ceilings in the living/dining space and a spacious kitchen that walks into the utility/Mud room from the garage. A split floor plan gives the master suite with en-suite bath privacy from the 2 additional bedrooms. Walk-out onto the covered porch or spend evenings dining on the patio deck overlooking to the yard with access to a seasonal creek! Whether you\'re here for the summer, weekend or year round, you\'re sure to get all the best of Rayburn\'s southern community with quick access to multiple boat ramps, restaurants, shopping, storage facilities and the Angelina River/National Forest; you are bound to find rest, relaxation and your \'home sweet home.\'' ,`Acres` = '0.25' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PT LOT 40 & PT OF 41 SEC 2 RAYBURN COUNTRY 1163/1088-1169/48' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '10890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '80' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '144 - Brookeland' ,`SchoolElementary` = 'BROOKELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROOKELAND HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKELAND HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rayburn Country Sec 2' ,`TaxAmount` = '3364' ,`TaxRate` = '1.6721' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091807' WHERE `Matrix_Unique_ID` = '210471635' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T15:33:36.810' ,`MLSNumber` = '3722613' ,`ListAgentFullName` = 'Jo Krejci' ,`ListOfficeName` = 'Champion Real Estate ' ,`SellingAgentFullName` = 'Jo Krejci' ,`SellingOfficeName` = 'Champion Real Estate ' ,`Latitude` = '29.887038' ,`Longitude` = '-95.931449' ,`PhotoCount` = '35' ,`PostalCode` = '77423' ,`RoomCount` = '4' ,`ListPrice` = '375000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Quail' ,`StreetNumber` = '32402' ,`StreetSuffix` = 'Run' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living right outside of the city. This beautifully renovated home sits on 1.21 acres with a pond, mature trees, and a detached garage. This home is 4 bedrooms, 2.5 baths, and has an awesome media/game room. It is recently renovated with new flooring throughout the first and second floor with new paint throughout. The kitchen is one-of-a-kind and completely renovated with new stainless steel appliances. This home is situated on a cul-de-sac with great neighbors. It has fencing on the perimeter of the property, including wrought iron fencing and upgraded window treatments for a modern country feel. \r\n New pump for water system, \r\n New ac system, \r\n New flooring upstairs & downstairs, \r\n Quartz countertops, \r\n Paint throughout, \r\n New landscaping, \r\n Solar panels.\r\nBring your horses and chickens to start your country living. Room sizes to be independently verified by buyer. Possession will be within 24 after closing and funding.' ,`Acres` = '1.21' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S669100 PEREGRINE ESTATES 2 LOT TR 105 ACRES 1.21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '52708' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Peregrine Estates 2' ,`TaxAmount` = '3755' ,`TaxRate` = '2.0967' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091807' WHERE `Matrix_Unique_ID` = '210944232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T15:56:07.950' ,`MLSNumber` = '98555854' ,`ListAgentFullName` = 'Will Clark' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.188476' ,`Longitude` = '-95.426357' ,`PhotoCount` = '14' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Gemstone' ,`StreetNumber` = '16' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2941' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow! So much extra thought put into this home. Hidden walk-in pantry in a glamorous kitchen. Built in wine frig and glass front cabinets,large island with ample seating. Primary bath with chic soaking tub, dual shower heads in walk in shower for 2. Tons of closet space. Mud room /utility combo. Primary plus one bedroom downstairs, 2 large bedrooms upstairs.' ,`Acres` = '0.178' ,`Area` = '5' ,`BuilderName` = 'Heritage Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Greystone SD Blk 1 Lot 48' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7772' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Greystone Subdivision' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091807' WHERE `Matrix_Unique_ID` = '211482644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T15:47:53.710' ,`MLSNumber` = '48133612' ,`ListAgentFullName` = 'Donna Dufrene' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Arthur Wayne Garza' ,`SellingOfficeName` = 'Keller Williams Realty-FM' ,`Latitude` = '30.904906' ,`Longitude` = '-94.412718' ,`PhotoCount` = '44' ,`PostalCode` = '75938' ,`RoomCount` = '8' ,`ListPrice` = '699000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Elder' ,`StreetNumber` = '805' ,`StreetSuffix` = 'Street' ,`City` = 'Colmesneil' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Peace and Tranquility! Imagine relaxing in the morning on a 900 ft. covered wrap around porch overlooking rolling hills with shaded trees. This lovely ranch style home has a huge kitchen/living/dining open concept adorned by high ceilings with beautiful beams. There is also a large family area/den, with vaulted ceilings which makes a great party area, game room or TV room. All bedrooms have their own private bath. Beautiful wood floors throughout the home. Home features a huge oversized garage. There is a 48K backup generator included along with a barn, stables, tack room and loafing shed for livestock. Included on property is a separate storage area ,2 basketball goals and an above ground pool for outdoor fun. Home is surrounded with built in mosquito sprayers and has a lasting metal roof. There is also a like-new, lovely mobile home included on the property that can be used for \r\nguests or a rental. No flooding ever, this is an absolutely must-see country living property!' ,`Acres` = '19.12' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0009 W. CAMPBELL, ACRES 19.12' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '427 - Colmesneil' ,`SchoolElementary` = 'COLMESNEIL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLMESNEIL HIGH SCHOOL' ,`SchoolMiddle` = 'COLMESNEIL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Campbell' ,`TaxAmount` = '9105' ,`TaxRate` = '2.0383' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091807' WHERE `Matrix_Unique_ID` = '211674414' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T16:51:20.593' ,`MLSNumber` = '13064714' ,`ListAgentFullName` = 'Ruth Stultz' ,`ListOfficeName` = 'Berkshire Hathaway HomeService' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.294384' ,`Longitude` = '-95.486173' ,`PhotoCount` = '47' ,`PostalCode` = '77304' ,`RoomCount` = '13' ,`ListPrice` = '979900.00' ,`Status` = 'Active' ,`StreetName` = 'Silverstone Way' ,`StreetNumber` = '2625' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Privacy, room to Breath in a Natural setting on 1.1+ acres and an Impressively designed home, are just a few of this home\'s Beautiful assets! Be prepared to be dazzled upon arrival. The flowing, open floor plan focuses on its central Great Room owning a \"Glass Curtain\" view of a park-like setting. A Formal Dining & Executive Study, outstanding Kitchen & Breakfast areas, a Flex room, (possible Nursery, 2nd study, Den, Exercise room), and an inviting Primary Suite Retreat are down. The Entertainment rooms plus 3 Guest Bedrooms with 2 spacious baths are up. The 3 car, oversized rear entry garage and fenced, shaded back yard complete the setting for your new HOME. \r\nSilverstone, a privately, gated community is on S Loop 336, with a 15 acre Reserve & Lakes for residents to enjoy. A second gated entrance exits onto Sgt Ed Holcomb for instant access to Hwy 105, restaurants and shopping, convenient to Medical, The Woodlands and Bush Airport. A must see, Pre-Qualified buyers only please!' ,`Acres` = '1.1171' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S882100 - SILVERSTONE 01, BLOCK 1, LOT 28' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '48661' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Silverstone 01' ,`TaxAmount` = '11567' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091807' WHERE `Matrix_Unique_ID` = '212810180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T15:30:26.793' ,`MLSNumber` = '23332045' ,`ListAgentFullName` = 'Walter Serna' ,`ListOfficeName` = 'W & G Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806731' ,`Longitude` = '-95.151632' ,`PhotoCount` = '10' ,`PostalCode` = '77049' ,`RoomCount` = '4' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Cominsky' ,`StreetNumber` = '15735' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedrooms and 3 full baths & a Half bath. Master bedroom on the 1st floor! Huge Gameroom is located upstairs along with 3 large spacious bedrooms and 2 full size bathrooms that can be used for guest or anyone seeking a bit more privacy. The Tuscany style home provides a wonderful and inviting layout and Wood laminate flooring. Let your children play and enjoy the community park or even public parks only minutes away. Quiet subdivision provides many play areas and a pool for families to enjoy. This lovely home is conveniently located by multiple freeways including I-10, Beltway 8 and Hwy 90. It is minutes away from Downtown, schools, shopping centers and grocery stores.' ,`Acres` = '0.1333' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 6 SONOMA RANCH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5805' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sonoma Ranch Sec 07' ,`TaxAmount` = '6614' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091808' WHERE `Matrix_Unique_ID` = '213729806' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T16:42:17.230' ,`MLSNumber` = '21387689' ,`ListAgentFullName` = 'Robert Fletcher' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.995591' ,`Longitude` = '-95.094413' ,`PhotoCount` = '45' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '639900.00' ,`Status` = 'Active' ,`StreetName` = 'Sierra Madre' ,`StreetNumber` = '22218' ,`StreetSuffix` = '' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME to this beautiful 4 bedroom home on a large 1.068 acre coner lot in convenient Spanish Cove subdivision. With lake access and private boat ramp, this is a great community with county living that has easy access to shopping, Houston and intercontinental airport. The home has been very well maintained with multiple upgrades. This spacious 24\'x31\' covered patio is great for those family and friend gatherings that you will be sure to have in this beautiful setting just waiting to become your new home. In addition to a 2 car garage it has a 30\'x40\' shop/man-cave with A/C and half bath and off the backside it also has a 20\'x30\' covered patio. Also attached to the shop is another 20\'x40\' covered equipment/toy storage area. NEVER FLOODED. Great location in a beauitful neigborhood. The back yard and pool area is a must see to give it full justice of its beauty!! Note: Home also has a 20kw standby generator.' ,`Acres` = '1.068' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '46522' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spanish Cove' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091808' WHERE `Matrix_Unique_ID` = '214494531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T16:01:35.917' ,`MLSNumber` = '66972604' ,`ListAgentFullName` = 'Will Clark' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.189068' ,`Longitude` = '-95.426947' ,`PhotoCount` = '8' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '423000.00' ,`Status` = 'Active' ,`StreetName` = 'Gemstone' ,`StreetNumber` = '6' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'So much to offer from this new build . It has 5 bedrooms, 3 bathrooms, open plan w/ island in kitchen . Primary bedroom plus 3 guest bedrooms are downstairs , 1 guest bedroom & bathroom upstairs.' ,`Acres` = '0.1928' ,`Area` = '5' ,`BuilderName` = 'Heritage Residential' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GREYSTONE SD (REPLAT) (A0380) (ANGLETON) BLK 1 LOT 38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Greystone SD' ,`TaxAmount` = '1272' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091808' WHERE `Matrix_Unique_ID` = '214620479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T15:34:58.070' ,`MLSNumber` = '17822726' ,`ListAgentFullName` = 'Najla Waters' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.460093' ,`Longitude` = '-95.926660' ,`PhotoCount` = '23' ,`PostalCode` = '77417' ,`RoomCount` = '9' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Cardinal' ,`StreetNumber` = '9610' ,`StreetSuffix` = 'Road' ,`City` = 'Beasley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Serene country living about 20 minutes from Sugar Land! This ranch style home sits on 2 acres of beautiful land. This spacious 4-5 bedroom home has some nice upgrades. A possible 5th bedroom is being used as an arts and crafts room and could also be turned into a home office. The primary bedroom has an ensuite bath with double sinks and huge tub. There\'s a nice covered front porch to sit and enjoy your morning coffee. The 25x40x14 foot tall workshop is perfect for storage,working space, or a garage. 20x8 dog run. Above ground pool! The home was repiped with PEX piping so the pipes won\'t freeze! Seller will need a 30 day lease back. There\'s so much that could be done on this property! Schedule your tour today!' ,`Acres` = '2' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0722 L F ASHLEY, TRACT 19, ACRES 2.0, CARDINAL ESTATE' ,`LotDesciption` = 'Other' ,`LotSize` = '86920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'L F Ashley' ,`TaxAmount` = '4113' ,`TaxRate` = '1.9957' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091808' WHERE `Matrix_Unique_ID` = '214698387' --> 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','215167749','1675091809','215167749','2022-12-16T15:06:41.600','54928561','Kathryn Hammond','RE/MAX On The Water - Bolivar','','','29.420875','-94.696619','24','77650','4','449900.00','Active','Jewel','113','','Crystal Beach','2','0','3','1247','Single-Family','UNDER CONSTRUCTION!!! three bedroom, two bath beach-side home located in a great family neighborhood. Very easy beach access. FEMA Insurable. This home would make a wonderful weekly vacation rental or a nice gathering place for your family and friends. Construction will be completed in early 2023.','0.0959','33','Traditional Craftsma','','Electric Dryer Connections,Washer Connections','','Reports Available','','','','Crystal Beach','Central Electric','0','ABST 203 PAGE 8 LOT 288 OCEAN SHORES ADDN SEC 6 UNRECORDED S','Water View','4176','Appraisal District','','','1','To Be Built/Under Construction','0','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Lockbox Front','Seller','1','Traditional','Ocean Shore 6 Unrec','336','1.6103','Aerobic','','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','215355178','1675091809','215355178','2022-12-16T15:29:30.527','80063685','Jill Rives','Rives Real Estate Group','','','29.815330','-95.789499','31','77493','5','389000.00','Active','Katy Town','2914','Lane','Katy','2','0','3','2618','Single-Family','Beautiful one story home located in Katy Oaks! Features include open living spaces, a private home office, 3 bedrooms, modern finishes & high ceilings. The kitchen boasts a large island, sleek granite countertops, tile backsplash, stainless steel appliances & a spacious breakfast area. Recessed lighting in the kitchen & family room. The primary suite offers dual sinks, a soaking tub, an oversized shower & a large walk-in closet. The spacious backyard features a covered patio! Fantastic lot that backs to a greenbelt and next to neighborhood amenities. Zoned to Katy ISD schools. Great location just minutes from 99, I 10, shopping & more. Don\'t miss this one!','0.1653','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Katy - North','Central Gas','1','LT 44 BLK 2 KATY OAKS SEC 1','Subdivision Lot','7200','Appraisal District','','625','0','','2','Gas Oven','0','','','','','Aluminum','30 - Katy','WINBORN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Katy Oaks','7489','2.6083','Public Sewer,Water District','2013','Appraisal'); --> 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','215402722','1675091809','215402722','2022-12-16T15:29:39.840','73491710','Ellyn Mead','Red Door Realty & Associates','','','29.843537','-95.380344','10','77022','8','350000.00','Active','Meta','9214','Street','Houston','2','0','4','1521','Single-Family','WORK FROM HOME.... This property is all about the ability to work and run a business from home. Location Location Location. The 50x70 foot building in the back would make a great shop!\r\nThe home got a new roof after Harvey.','0.2735','9','','','','','Sellers Disclosure','','','','Northwest Houston','Central Gas','0','TRS 2B & 3 BLK 1 CARRICK','Other','11914','Appraisal District','','','0','','3','','0','','','','','Composition','27 - Houston','BURBANK ELEMENTARY SCHOOL','SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER','BURBANK MIDDLE SCHOOL','Appointment Required,Controlled Access','Appraisal District','1','Ranch','Carrick','5407','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully