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-07T10:57:29.627' ,`MLSNumber` = '41572662' ,`ListAgentFullName` = 'Ricky Rodriguez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218159' ,`Longitude` = '-95.581286' ,`PhotoCount` = '40' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Charred Pine' ,`StreetNumber` = '7402' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3123' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**New Construction**Gorgeous two story home on 1/2 ACRE lot in Westwood right next to The Woodlands. Spacious open floor plan, quartz counter tops and stainless steel appliances. High ceilings featuring a gas/wood fireplace. Private study can also be used as a fifth bedroom. Huge gameroom! The large yard has plenty of room for a pool. Highly rated schools. LOW HOA and NO MUD!' ,`Acres` = '0.4591' ,`Area` = '15' ,`BuilderName` = 'Stonewood Landmark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD 01, BLOCK 2, LOT 9' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood' ,`TaxAmount` = '1059' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105975' WHERE `Matrix_Unique_ID` = '212969118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T09:18:53.497' ,`MLSNumber` = '84169889' ,`ListAgentFullName` = 'Cindy Villatoro' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.366048' ,`Longitude` = '-94.954125' ,`PhotoCount` = '20' ,`PostalCode` = '77568' ,`RoomCount` = '3' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Stubbs' ,`StreetNumber` = '804' ,`StreetSuffix` = 'Street' ,`City` = 'La Marque' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1218' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rental income property for investors. Tenant occupied until Dec/2023. Renovated 2-3 bed/ 1 bath home. Open the door to your living-room with tile flooring and natural lightning. The kitchen has tons of cabinets for storage and a double sink for the chef. Slide the double doors for your side porch and enjoy the outdoors. Spacious room ready to be converted into a 3rd bedroom, second living area, game-room, or office space. Great lot size for any gatherings or pets. Peaceful area near Hwy 146, Tanger Outlets, and Galveston. New paint, fixtures, and carpet. Appliances included. Call directly to apply for a loan.' ,`Acres` = '0.2971' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR LOT 11 STUBBS ADDN TO LAMARQUE' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '12940' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stubbs' ,`TaxAmount` = '2230' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105975' WHERE `Matrix_Unique_ID` = '213111001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T10:20:23.353' ,`MLSNumber` = '48118045' ,`ListAgentFullName` = 'Norma Moore' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658641' ,`Longitude` = '-95.193612' ,`PhotoCount` = '35' ,`PostalCode` = '77504' ,`RoomCount` = '8' ,`ListPrice` = '790000.00' ,`Status` = 'Active' ,`StreetName` = 'Federal' ,`StreetNumber` = '3508' ,`StreetSuffix` = 'Road' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '3028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An amazing property just like new, on a 35,414 sq. ft.lot. As you enter the foyer you will feel the spacious high ceiling open concept of the living space w/ a fireplace.Living room has coffer ceiling & custom built in TV cabinet unit that opens into the dining room & kitchen.Kitchen has beautiful custom cabinets & granite counter tops w/ 5 burner gas stove & a generous storage space. All bedroom rooms are generous in size w/ large wake-in closets. The two secondary bedrooms are en-suite, w/ possible 4th bedroom that is being use as an office now. Master bathroom has a large jacuzzi tub, separate shower & two vanities. Spacious 3 car garage w/ a half bathroom in garage and a large sink area for cleanup.The east side of the house has a port-a-call plus a large cover area for three additional cars (30X18) or for entertaining. A large custom builded dog run/house completely self contained. Property also has a well for watering the immaculate lawn, security cameras and alarm system.' ,`Acres` = '0.813' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 170A ALTA VISTA ACRES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '35414' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'JENSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Alta Vista Acres Sec 03' ,`TaxAmount` = '11014' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105975' WHERE `Matrix_Unique_ID` = '213588531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T10:58:01.640' ,`MLSNumber` = '31368221' ,`ListAgentFullName` = 'Dawn Faust' ,`ListOfficeName` = 'Flat Fee Discount Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.289472' ,`Longitude` = '-94.801181' ,`PhotoCount` = '35' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '296000.00' ,`Status` = 'Active' ,`StreetName` = '33rd' ,`StreetNumber` = '1811' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Craftsman Raised Bungalow Remodeled 2/1/1, Refinished hardwood floors throughout except for bathroom and kitchen. Remodeled bath has new porcelain tile on floor and in shower/bath surround with stone inlay accents. Remodeled kitchen has porcelain tiles on floor, farmhouse sink, original all wood cabinets with glass front upper cabinets to preserve the craftsman feel of the kitchen. New countertops have brought a natural, but artistic feel with black walnut live edge boards and a 6 color epoxy pour that brings the feel of our island and coastal beachfront to the kitchen. Spacious downstairs allows for a laundry area, workshop and plenty of storage area. 1\r\ncar garage provides enough room for a car or golf cart. Newly constructed outside deck for relaxing in the shaded backyard with newly landscaped yard. Rainwater catch system tied into gutters on garage with large storage tank. Centrally located, close to Strand district, UTMB, TAMUG, GC. Walk to Beach & Mardi Gras Parades.' ,`Acres` = '0.059' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric,Central Gas,Other Heating,Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR N 15 FT OF LOTS 8,9 & S 15 FT OF ADJ' ,`LotDesciption` = 'Other' ,`LotSize` = '2570' ,`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,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '2655' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105976' WHERE `Matrix_Unique_ID` = '213687238' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T09:04:40.873' ,`MLSNumber` = '68358143' ,`ListAgentFullName` = 'Lacy Lewis' ,`ListOfficeName` = 'Mr. Real Estate' ,`SellingAgentFullName` = 'Lacy Lewis' ,`SellingOfficeName` = 'Mr. Real Estate' ,`Latitude` = '29.621917' ,`Longitude` = '-95.359817' ,`PhotoCount` = '17' ,`PostalCode` = '77047' ,`RoomCount` = '5' ,`ListPrice` = '339900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Donegal' ,`StreetNumber` = '12933' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant New custom home beauty on a large corner lot! Beautiful front stone elevation with covered front entryway. High ceilings & built in\'s throughout! Engineered wood flooring. This 3 bedroom 2.5 bath home is a one of kind with open layout and high end kitchen with a waterfall island. This is the largest lot of 3 homes to be built, its a must see home!' ,`Acres` = '0.1639' ,`Area` = '3' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 16 SHAMROCK MANOR' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '7140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shamrock Manor' ,`TaxAmount` = '494' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105976' WHERE `Matrix_Unique_ID` = '214609906' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T10:03:32.237' ,`MLSNumber` = '46960276' ,`ListAgentFullName` = 'Michelle Brecker' ,`ListOfficeName` = 'Pathway to Home Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681873' ,`Longitude` = '-95.233342' ,`PhotoCount` = '31' ,`PostalCode` = '77017' ,`RoomCount` = '4' ,`ListPrice` = '135000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Creek' ,`StreetNumber` = '5655' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1666' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor Special. HOUSE IS OCCUPIED. DO NOT SHOW UP TO TRY TO GET IN. Home with rear apartment ready to rent. 3 bedroom 2 bath home with 1 bedroom apartment addition to gargage. Home needs Foundation repair and Subfloor repair. TITLE ISSUES ARE BEING WORKED ON. WILL UPDATE STATUS WHEN OFFER CAN BE ACCEPTED.' ,`Acres` = '0.1716' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 10 MEADOW CREEK VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'PASADENA HIGH SCHOOL' ,`SchoolMiddle` = 'QUEENS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Meadow Creek Village Sec 02' ,`TaxAmount` = '5114' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105976' WHERE `Matrix_Unique_ID` = '214648336' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T10:33:34.623' ,`MLSNumber` = '70344188' ,`ListAgentFullName` = 'Brandon Brewer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.716915' ,`Longitude` = '-95.028510' ,`PhotoCount` = '15' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '99000.00' ,`Status` = 'Active' ,`StreetName` = 'Mangum' ,`StreetNumber` = '2195' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cozy home is ready for it\'s new owner! It\'s ready to go as a two bedroom one bath but has a second bathroom ready to finish out. So much character left and will make a wonderful home or home away from home for you. Minutes away from the city of Livingston with private neighborhood access to Lake Livingston, one of the largest lakes in the state. There\'s many memories left to be made here!!' ,`Acres` = '0.37' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LAKELAND HIDEAWAY SECTION 4 LOT 65 & 66' ,`LotDesciption` = 'Cleared' ,`LotSize` = '16294' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeland Hideaway' ,`TaxAmount` = '1311' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105976' WHERE `Matrix_Unique_ID` = '214910996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T10:32:31.633' ,`MLSNumber` = '95008069' ,`ListAgentFullName` = 'Paul Edwards' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.465574' ,`Longitude` = '-95.814145' ,`PhotoCount` = '40' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Run' ,`StreetNumber` = '28668' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Peacefully Situated on 10+ acres, this Stunning custom home is built to last with 2x6 construction and metal roof. Home site of 5.03 acres and adjoining 5.39 acres being sold together. Extra large (5’8”) windows bring the outdoors in to view the beauty of the property from every room in the house. Primary bedroom with a spa-like bath includes a gorgeous over sized tub that looks out on the garden, huge walk-in shower and double vanity. All bedrooms are en-suite. Beautiful sealed and waxed concrete floors downstairs and reclaimed wood upstairs. Two large upstairs storage spaces easily convert to additional closets. Enjoy the outdoors from your Second story balcony or the Spacious back deck overlooking the picturesque balance of cleared land and natural landscape. Two back acres newly cleared for cultivating/seed. You don\'t want to miss out on this one!' ,`Acres` = '10.42' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOOD CREEK1,LOT 19 & 20, 10.42 acres' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '453895' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Wood Creek 01' ,`TaxAmount` = '9240' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105977' WHERE `Matrix_Unique_ID` = '215038458' --> 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','215275228','1675105977','215275228','2023-01-07T09:24:15.877','83854051','Tom Stutz','Texas Signature Realty','','','29.848726','-95.325066','18','77093','6','145900.00','Active','Trigg','4406','Street','Houston','1','0','2','980','Single-Family','Wow, what an adorable cute lil home. This home has been renovated with a new kitchen, bathroom, hot water heater, and roof, along with new flooring and paint, HGTV color scheme, fyi. Walk into the living room, then a formal dining room that can be a flex room/den. The kitchen also offers a laundry in it, along w a stainless range/oven. There is cute lil front covered patio too. Oh, great neighbors too. Close to downtown as well. Owner is agent.','0.1625','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure','','','','Aldine Area','No Heating','0','LT 864 BUCKINGHAM PLACE SEC 7','Wooded','7080','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','ESCAMILLA ELEMENTARY SCHOOL','MACARTHUR HIGH SCHOOL (ALDINE)','HAMBRICK MIDDLE SCHOOL','Appointment Required,Request Online Appointment','Appraisal District','1','Other Style','Buckingham Place Sec 2 Thru 7','2169','2.5119','Public Sewer,Public Water','1940','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','216100881','1675105977','216100881','2023-01-07T09:10:24.407','48564394','Laura Bonck','eXp Realty, LLC','','','29.766988','-95.479170','47','77057','18','2499000.00','Active','Shady River','5729','Drive','Houston','4','2','5','5463','Single-Family','Located in the highly coveted area of Tanglewood, 5729 Shady River Dr features 5 beds, 4 full\r\nand 2 half baths, and sits on a 15,000 square foot lot. This gorgeous French style home features\r\nupscale finishes all throughout with timeless stone flooring, wood coffered ceiling beams, and\r\nmore. The large office space features tons of custom built-in shelves and glass paned double\r\ndoors. The formal living area houses a double-sided fireplace connecting to the family room & kitchen.\r\nThe kitchen features sleek stone countertops with tile backsplash, spacious island, bar\r\nseating, and a separate butler’s pantry. The primary suite features large windows that let in an\r\nabundance of natural light and beautiful coffered ceilings. The spa-like primary bath is complete\r\nwith a standing glass shower, luxurious soaking tub, and palatial walk-in closet with custom\r\ncabinetry. The resort-style backyard has a covered patio, perfect for entertaining, along with a\r\nglistening pool.','0.3444','22','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Tanglewood Area','Central Gas,Zoned','1','LT 18 BLK 53 TANGLEWOOD SEC 11','Subdivision Lot','15000','Appraisal District','','1650','0','','2','Double Oven,Electric Oven','1','Gunite','','Gas Cooktop','','Composition','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','2','French,Traditional','Tanglewood','46910','2.3307','Public Sewer,Public Water','1998','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','216165778','1675105977','216165778','2023-01-07T09:34:39.423','90701607','Cathy Carter','Carter Signature Properties','','','28.958313','-95.278534','49','77541','6','2900000.00','Active','Blue Water','702 - 710','Highway','Surfside Beach','6','2','6','4644','Single-Family','Experience the ultimate in beachfront living with 3 beachfront homes!! The 3 homes featured on HGTV Battle of the Beach Season 2, boast 3 bedrooms and 2 baths with open concept living and window water views. The furnished interior excludes comfort and style, while the beachfront location and private walkover provides direct access to the Gulf of Mexico. Property is not only a multi-family retreat, but also a business opportunity, as it is situated on commercial property with additional bay side acreage ripe for development. Don\'t miss this unique chance to own a piece of paradise in Surfside Beach, Texas.','3.757','5','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Mock Fireplace','1','Surfside','Central Electric','0','B C I C DIV 1 LOT 1 (TEJAS SANDS SD) (A0009 B T ARCHER) (SUR','Waterfront','163638','Appraisal District','','','0','','3','Freestanding Oven','0','','','Electric Range','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Other Style','B C I C Div 1','10563','1.8695','Public Water,Septic Tank','2001','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','216166783','1675105977','216166783','2023-01-07T10:09:57.187','13747640','Robert Hedrick','Executive Texas Realty','','','30.813320','-95.254102','21','77320','4','94900.00','Active','Shawnee','28632','Court','Huntsville','1','0','2','780','Single-Family','This property is located on a quiet cul-de-sac near world-class fishing at Lake Livingston. This property has two bedrooms located upstairs with the living/dining and kitchen on the main level. The attached carport includes two great storage/utility areas. This property is perfect property for an investor or for a first time home buyer. With a little TLC you will have the perfect home to enjoy all Water wood has to offer. More Pictures to come!!! Motivated Seller.','0.1148','64','','','Electric Dryer Connections,Washer Connections','','Mud','','','','Lake Livingston Area','Central Electric','1','WATERWOOD - GREENTREE VILLAGE #11A, BLOCK 5, LOT 9, ACRES 0.','Cul-De-Sac,In Golf Course Community','5001','Appraisal District','','515','0','','0','','0','','','','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Seller','2','Traditional','Waterwood Greentree Vill #11a','1436','2.2916','Public Sewer,Public Water,Water District','1978','Appraisal District'); --> New record created successfully