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-23T13:45:45.503' ,`MLSNumber` = '24473849' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.055410' ,`Longitude` = '-95.352140' ,`PhotoCount` = '11' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Finely Run' ,`StreetNumber` = '5626' ,`StreetSuffix` = 'Street' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available in October! The two-story Granville’s first-floor owner’s suite, with luxurious bath and walk-in closet, attracts seeking privacy and convenience. The gourmet kitchen with island and adjacent dining area are perfect for entertaining. The study makes for an ideal home office or hobby space, and the second floor game room leaves ample room for the kids.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '06202' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4730' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Grove' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218038' WHERE `Matrix_Unique_ID` = '207139822' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:17:24.123' ,`MLSNumber` = '66680753' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515612' ,`Longitude` = '-95.800468' ,`PhotoCount` = '22' ,`PostalCode` = '77469' ,`RoomCount` = '5' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Seabourne Landing' ,`StreetNumber` = '4423' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new community with modern farmhouse designs near the Fort Bend County Fair Grounds with large homesites conveniently located just minutes away from Seabourne County Park, Hwy. 36, and Hwy. 59. Abundant shopping is just minutes away in nearby downtown Rosenberg and Richmond. One-story | 3 bedrooms | 2 baths | Study | 2-car attached garage | covered patio.\r\nPlans, Prices & Features are subject to change w/o notice. Square Footage estimates are approximate. The home is under construction, as such, photos are REPRESENTATIVE and NOT of the actual home. For more info, contact Chesmar Homes in Seabourne Landing. AUGUST 2022 estimated completion.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Seabourne Landing Sec 2, BLOCK 1, Lot 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Seabourne Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.94' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218038' WHERE `Matrix_Unique_ID` = '207260647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:44:02.097' ,`MLSNumber` = '46803094' ,`ListAgentFullName` = 'Michelle Soderberg' ,`ListOfficeName` = 'Michelle Mathenia Soderberg' ,`SellingAgentFullName` = 'Erica Sprague' ,`SellingOfficeName` = 'Layne Realty, LLC' ,`Latitude` = '30.290164' ,`Longitude` = '-95.555514' ,`PhotoCount` = '16' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '329000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Aster View' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great, open floor plan, 1 story with lots of extras. The garage has epoxy floors with a wash sink. The backyard has an extended porch with an area for a firepit. Even has a gas hook-up for your grill. HUGE kitchen island for entertaining. All room dimensions should be independently verified.' ,`Acres` = '0.1658' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965275 - WOODFOREST 75, BLOCK 1, LOT 43' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7222' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 75' ,`TaxAmount` = '7200' ,`TaxRate` = '2.8388' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218038' WHERE `Matrix_Unique_ID` = '207885089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:42:41.570' ,`MLSNumber` = '22410673' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.366965' ,`Longitude` = '-95.672237' ,`PhotoCount` = '16' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '432990.00' ,`Status` = 'Active' ,`StreetName` = 'Mainland Shores' ,`StreetNumber` = '1309' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The well-designed Yuma plan includes four bedrooms, three bathrooms, an upstairs gameroom, and a 2.5-car garage!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 3, Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218038' WHERE `Matrix_Unique_ID` = '208970483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:56:56.317' ,`MLSNumber` = '68994096' ,`ListAgentFullName` = 'Sara Wright' ,`ListOfficeName` = 'Realty Solution' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771931' ,`Longitude` = '-95.854570' ,`PhotoCount` = '37' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '495500.00' ,`Status` = 'Active' ,`StreetName` = 'Hawkeye Ridge' ,`StreetNumber` = '27922' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for quick move in! Well maintained 1.5 story home in the heart of Katy and only 4 years old! This home has 4 bedrooms and a study, all downstairs. Also features 2.5 car garage, extended back porch, large kitchen/breakfast room combo; game room, media room, and 2nd 1/2 bath upstairs. The primary bedroom is large with a beautiful bay window, large primary bath with separate shower and garden tub, and primary closet the size of a bedroom! The laundry room is in home with a large soaking sink, space for an extra fridge/freezer, and cabinets for extra storage. The home has just been completely painted inside and brand new carpet installed. Home located conveniently to I-10 and close to all the amenities Katy has to offer, near great schools and shopping all near by, this home is a gem! Come check it out!' ,`Acres` = '0.2144' ,`Area` = '36' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRAILS OF KATY SEC 2, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9339' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Trails Of Katy Sec 2' ,`TaxAmount` = '10359' ,`TaxRate` = '3.2845' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675218039' WHERE `Matrix_Unique_ID` = '209794551' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:58:40.040' ,`MLSNumber` = '61375179' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368317' ,`Longitude` = '-95.670920' ,`PhotoCount` = '13' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '355990.00' ,`Status` = 'Active' ,`StreetName` = 'Tilia Creek' ,`StreetNumber` = '1258' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The favorable Whitman plan features three large bedrooms, two full bathrooms & a formal dining room!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Block 2, Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218039' WHERE `Matrix_Unique_ID` = '210119564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:58:21.227' ,`MLSNumber` = '70949971' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841742' ,`Longitude` = '-94.989159' ,`PhotoCount` = '10' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Stoney Terrace' ,`StreetNumber` = '4807' ,`StreetSuffix` = 'Trail' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW LENNAR Community - STERLING POINT!!! New Lennar Brookstone Collection Homes in Sterling Point! The Travertine III, Brick/Stone Elevation \"F\" is the only single-story layout in the collection that offers a game room, this home features a dining room with a window seat, which joins a generous family room, complete with a covered patio for indoor-outdoor living. The owner’s suite features dual walk-in closets and an en-suite bathroom with vanities to match..\r\n**Estimated Completion Date, December 2022**' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0003 BLK 001 LOT 009' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Point' ,`TaxAmount` = '' ,`TaxRate` = '3.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218039' WHERE `Matrix_Unique_ID` = '210245314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:34:48.250' ,`MLSNumber` = '95281191' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.167078' ,`Longitude` = '-95.637734' ,`PhotoCount` = '12' ,`PostalCode` = '77486' ,`RoomCount` = '6' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '545' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 95281191 No Back Neighbors! By CastleRock, HOME UNDER CONSTRUCTION! Whitman Plan(C-Elevation) 1-Story 3 BD 2 BA 3 Car Garage 1,857 sqft! High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets! Quartz Counters! Stainless steel appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! 2\'\' Faux blinds! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low TaxRate 2.186 before homestead! Covered Patio! Offers a golf course family-friendly gated community, Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Bay City, Sweeney & Lake Jackson! Experience the breathtaking sandy beach views just 30 mins away! CastleRock offers NEW HOMES in various stages of construction for those who are looking for spacious 1 & 2-story layouts and Quick Move-Ins. Nestled in Natural Splendor Enjoy Country Living in Columbia Lakes! Best kept secret south of Houston! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 99, Block 31, Section 3' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9372' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218039' WHERE `Matrix_Unique_ID` = '210441945' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:21:51.033' ,`MLSNumber` = '66015561' ,`ListAgentFullName` = 'Misti Bruton' ,`ListOfficeName` = 'AVO Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659958' ,`Longitude` = '-98.828517' ,`PhotoCount` = '28' ,`PostalCode` = '78023' ,`RoomCount` = '7' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon' ,`StreetNumber` = '451' ,`StreetSuffix` = 'Forest' ,`City` = 'Helotes' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own a piece of Texas Hill Country in this gorgeous property on 6.5 acres of land! Vaulted ceilings, open floor plan, large glass windows to let lots of natural light in and a fully remodeled farm-type kitchen. Primary bedroom has an en-suite toilet and bath and double sinks. Enjoy breathtaking views from the outside, lots of trees and room to grow. All this while only 13 miles from San Antonio. Come see this gem and schedule your showing today!' ,`Acres` = '6.51' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON CREEK PRESERVE PHASE 5 BLOCK B LOT 6' ,`LotDesciption` = 'Wooded' ,`LotSize` = '283576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '595' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '247 - Northside (Bexar)' ,`SchoolElementary` = 'LOS REYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'O\'CONNOR HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (NORTHSIDE)' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Creek Preserve Ph 5' ,`TaxAmount` = '7822' ,`TaxRate` = '1.9806' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218040' WHERE `Matrix_Unique_ID` = '210772915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:18:21.810' ,`MLSNumber` = '14191335' ,`ListAgentFullName` = 'Sharon Ballas' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765870' ,`Longitude` = '-95.509921' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '18' ,`ListPrice` = '4300000.00' ,`Status` = 'Active' ,`StreetName` = 'Claymore' ,`StreetNumber` = '11111' ,`StreetSuffix` = 'Road' ,`City` = 'Piney Point Village' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '9289' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on an amazing 41,447 sf lot (HCAD), this remarkable home features superb quality throughout. Grand rooms & beautiful vistas + ELEVATOR & WHOLE HOUSE GENERATOR. Dramatic entry has views to the extraordinary grounds. Generously sized formals w/walnut floors. Bar & temperature controlled wine room for 2200+ bottles (per seller). Private study w/ mesquite flooring. The incredible primary suite enjoys an exercise room, coffee bar, motorized drapes, elegant bath w/ soaking tub & wonderful closets. The well-equipped kitchen features a furniture quality island, country French cabinetry, a delightful breakfast room overlooking the pool & family room w/ limestone fireplace. Media room up. Secondary bedrooms w/ beautifully finished baths. Stylish 4th bedroom suite features an elegant gray & white marble bath w/ double basins, deep soaking tub & separate shower. 5th bedroom w/ 20 X 12 extra room. 2 utility rooms. Mom’s office. Fabulous location!' ,`Acres` = '0.9514' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 PINEY OAKS ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '41447' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Piney Point Village' ,`TaxAmount` = '77951' ,`TaxRate` = '2.1721' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218040' WHERE `Matrix_Unique_ID` = '210881302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:00:56.390' ,`MLSNumber` = '14226046' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655640' ,`Longitude` = '-95.118381' ,`PhotoCount` = '22' ,`PostalCode` = '77505' ,`RoomCount` = '15' ,`ListPrice` = '554837.00' ,`Status` = 'Active' ,`StreetName` = 'Highland' ,`StreetNumber` = '5515' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story Louise home with 4 bedrooms, 3.5 baths and 2 car attached garage with storage. Convenient home office with French doors and open dining room tucked off foyer. Beautiful maple cabinets, quartz countertops and farmhouse sink in gourmet kitchen. Cozy tile fireplace with maple mantel in great room. Huge walk-in closet in owner\'s suite. Dual vanity sinks, separate tub and shower in owner\'s bath. Versatile activity room located upstairs. Bedrooms 2 and 3 share a Jack and Jill bath. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '7/2/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.470865' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218040' WHERE `Matrix_Unique_ID` = '211464552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:00:32.210' ,`MLSNumber` = '65936106' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655938' ,`Longitude` = '-95.117791' ,`PhotoCount` = '27' ,`PostalCode` = '77505' ,`RoomCount` = '15' ,`ListPrice` = '557083.00' ,`Status` = 'Active' ,`StreetName` = 'Fairfield' ,`StreetNumber` = '5530' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story Louise home with 4 bedrooms, 3.5 baths and 2 car attached garage with storage. Convenient home office with French doors and open dining room tucked off foyer. Beautiful maple cabinets, quartz countertops and farmhouse sink in gourmet kitchen. Cozy tile fireplace with Craftsman mantel in great room. Huge walk-in closet in owner\'s suite. Dual vanity sinks, separate tub and shower in owner\'s bath. Versatile activity room located upstairs. Bedrooms 2 and 3 share a Jack and Jill bath. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '16/2/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.470865' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218040' WHERE `Matrix_Unique_ID` = '211466744' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:34:30.900' ,`MLSNumber` = '2397564' ,`ListAgentFullName` = 'Bridget Moore' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.969127' ,`Longitude` = '-95.668937' ,`PhotoCount` = '32' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Greenwood Manor' ,`StreetNumber` = '13518' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this magnificent home in the sought after Coles Crossing Subdivision. With 5 bedrooms, 3.1 bathrooms, and plenty of space for entertainment, this home is perfect for you. You\'ll love the high ceilings, natural light, and hard-surface flooring in this home. The family room has lovely built-in shelving and a cozy fireplace. You will love spending time in the island kitchen which boasts a walk-in pantry, an island cooktop with a wall oven, tons of storage space and room for multiple chefs. Massive primary suite with soaring ceilings, lots of natural light from two large windows, TWO walk-in closets and an updated ensuite bathroom with a luxe glass walk-in shower with seating area, soaking tub, dual sinks and vanity area. Out back you will find a lush backyard with plenty of space for outdoor activities as well as a covered patio – perfect for enjoying those warm Texas evenings. Don’t miss out on this wonderful opportunity – call today to schedule your private showing!' ,`Acres` = '0.2204' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 1 COLES CROSSING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SAMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coles Crossing Sec 01' ,`TaxAmount` = '10234' ,`TaxRate` = '2.541' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218041' WHERE `Matrix_Unique_ID` = '211511909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:50:29.760' ,`MLSNumber` = '11038183' ,`ListAgentFullName` = 'Amber Morris' ,`ListOfficeName` = 'RE/MAX Opportunities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.338949' ,`Longitude` = '-95.544785' ,`PhotoCount` = '49' ,`PostalCode` = '77583' ,`RoomCount` = '3' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Coffee Plantation' ,`StreetNumber` = '5207' ,`StreetSuffix` = 'Road' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2813' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unrestricted and Charming 4.191+/- Acres on Old Coffee Plantation! This 3 bedroom, 2.5 bath home is the perfect getaway from the hustle and bustle of the city! Enter to Travertine Floors Throughout entire downstairs, with recent granite and STAINLESS appliances in Kitchen! Property has 4 Car - OVERSIZED Metal garage Perfect for that Man Cave! Outdoor Pavilion fully Equipped with outdoor kitchen and oven! Concrete circle drive with fountain adds a level of luxury to this Ranch House! Plenty of room to build more homes, raise farm animals, or produce hay/crops in fenced back and side pasture. Great location close to TX-288/FM 521/HWY 6 makes commuting a breeze to Texas Medical Center, Downtown Houston, Hobby Airport, Freeport and Surfside Beach. Mature trees scattered throughout cross-fenced green pastures. Bring your horses and spend nights gazing at twinkling stars! Perfect for country living and proximity to the city. No HOA!! Call and schedule your private tour today!' ,`Acres` = '4.191' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0068 J W HALL, TRACT 316 LOT 2B & A0125 A ROBINOSN TR 7A32' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '182560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'J W Hall' ,`TaxAmount` = '7707' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218041' WHERE `Matrix_Unique_ID` = '211656368' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:11:57.657' ,`MLSNumber` = '91592136' ,`ListAgentFullName` = 'Kimberly Gaido' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.208636' ,`Longitude` = '-94.929945' ,`PhotoCount` = '35' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '889000.00' ,`Status` = 'Active' ,`StreetName` = 'Sand Crab' ,`StreetNumber` = '4113' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home nestled securely in the second block from the beach has a wonderful Gulf view. The large, expansive decks are amazing with the largest off the living room and the other two on the second level.The kitchen has granite & stainless appliances and opens to the dining room which seats 12. There are two fireplaces and two wet bars as well, one in the living area and one in the upstairs loft. The loft can be a 4th bedroom and has a sofa that sleeps two.Two more bedrooms are on the main level. Great looking vinyl plank flooring with a moisture barrier and a freshly painted exterior. A.C. was new upstairs in 2020 and main level replaced in July 2022. Lots of nooks and crannies in this family friendly home in the highly sought after neighborhood of Pirates Beach.\r\nClose to town and yet restful and beachy. Solid rental history. Sold fully furnished.' ,`Acres` = '0.209' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 56 BLK 2 PIRATES BEACH SEC 7' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '9102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Beach 7' ,`TaxAmount` = '10995' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218041' WHERE `Matrix_Unique_ID` = '211810698' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:33:12.530' ,`MLSNumber` = '13944052' ,`ListAgentFullName` = 'Elizabeth Boles' ,`ListOfficeName` = 'One10 Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.418225' ,`Longitude` = '-94.692744' ,`PhotoCount` = '50' ,`PostalCode` = '77650' ,`RoomCount` = '4' ,`ListPrice` = '1352000.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Shores' ,`StreetNumber` = '180' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large BEACHFRONT New Construction in new Pelican Point sub-division in Crystal Beach!! Gated community at the end of Ocean Shores Drive off Boyt Road. Enjoy the privacy of a gated community in your new home.. Fabulous views to the Gulf!! Wide beach area to enjoy with large protective dune system. A must see! Call today!' ,`Acres` = '1' ,`Area` = '33' ,`BuilderName` = 'Brint Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 PELICAN POINT (2018) ABST 203' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pelican Point' ,`TaxAmount` = '2166' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675218041' WHERE `Matrix_Unique_ID` = '212106845' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:25:51.250' ,`MLSNumber` = '89859237' ,`ListAgentFullName` = 'Cynthia Pierce' ,`ListOfficeName` = 'Gann Medford Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.230276' ,`Longitude` = '-94.717004' ,`PhotoCount` = '37' ,`PostalCode` = '75941' ,`RoomCount` = '7' ,`ListPrice` = '420320.00' ,`Status` = 'Active' ,`StreetName` = 'CC' ,`StreetNumber` = '193' ,`StreetSuffix` = 'Road' ,`City` = 'Diboll' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction on 1.66 acres! 4 bedrooms plus private bonus room. Open, light & bright. Gorgeous island kitchen open to family room, FP, built-ins. Quartz counter tops in kitchen & baths. Large walk-in butler pantry. Split bedrooms. Primary suite with huge walk-in closet, dual sinks, soaking tub and separate shower. Mud room storage and laundry room. So much storage throughout! Covered patio. Attached double garage. Many extras in this stunning new home.' ,`Acres` = '1.661' ,`Area` = '45' ,`BuilderName` = 'Daniel Barrera' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS 0035 PADILLA V.,TRACT 122.10,ACRES 1.661' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '186 - Lufkin' ,`SchoolElementary` = 'ANDERSON ELEMENTARY' ,`SchoolHigh` = 'LUFKIN HIGH SCHOOL' ,`SchoolMiddle` = 'LUFKIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Pines' ,`TaxAmount` = '645' ,`TaxRate` = '1.8544' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675218041' WHERE `Matrix_Unique_ID` = '212207384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:24:32.787' ,`MLSNumber` = '51293221' ,`ListAgentFullName` = 'Wendy Dozier' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = 'Wendy Dozier' ,`SellingOfficeName` = 'RE/MAX On The Water - Bolivar' ,`Latitude` = '29.503055' ,`Longitude` = '-94.522341' ,`PhotoCount` = '50' ,`PostalCode` = '77617' ,`RoomCount` = '2' ,`ListPrice` = '285000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Shady' ,`StreetNumber` = '1087' ,`StreetSuffix` = 'Lane' ,`City` = 'Gilchrist' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE EXTRAORDINARY OPPORTUNITY! Exterior Colors of the homes will depend on lot #. Website/video attached. Brand New Villas Priced in The Mid $200\'s + ADDITIONAL OPTIONS such as a loft area, garage, outside shower, RV connections & Quartz Kitchen Counters. 30 second Golf Cart Ride To The Beach! Incredible Beach Community With Magnificent Views of the Beach & Intracoastal. Community Amenities Featuring; Ponds, Pavilion, Observatory Deck, Splash Pad, BBQ and Lounging Areas. Tongue and Groove Wood Stained Flooring, Stainless Steel Appliances, Stained Butcher Block Counters, Quartz Bathroom Counters. SELLING FAST! Builder Base Price Is Subject To Change.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'LOR Design' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Caplen' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 64 PAGE 3 & 4 LOT 4 NORTH CAPLEN AD' ,`LotDesciption` = 'Water View' ,`LotSize` = '4430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villas at Rollover Bay' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675218042' WHERE `Matrix_Unique_ID` = '212219340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:54:11.647' ,`MLSNumber` = '37360126' ,`ListAgentFullName` = 'Christa Lay' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.123822' ,`Longitude` = '-95.807377' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Ridge' ,`StreetNumber` = '24807' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2.31 Acre Lot with Custom Home and a Huge Shop located in Hockley! This home features Ceramic TILE flooring, oversized kitchen open to the living room, and a large primary bedroom with en suite bathroom. Great size for all secondary bedrooms and have custom build in cabinets in the closets! Peaceful covered patio that is perfect for grilling or lounging, while enjoying a scenic country atmosphere. Spacious shop with studio apartment/office. property fully fenced and gated!' ,`Acres` = '2.31' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'S433100 CLEAR CREEK FOREST 1 LOT 4 ACRES 2.31' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '100624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Clear Creek Forest' ,`TaxAmount` = '6699' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218042' WHERE `Matrix_Unique_ID` = '212236812' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:01:46.233' ,`MLSNumber` = '49227394' ,`ListAgentFullName` = 'Angelique Stockton' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.896937' ,`Longitude` = '-95.723120' ,`PhotoCount` = '27' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '310990.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Retreat' ,`StreetNumber` = '20607' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1714' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 OWNER BEAZER HOME 3/2/2 Beautiful arches and trayed ceiling in the elegant entry leads to Open floor plan with Natural Lighting *Tile flooring in Dining & Kitchen w/Stainless appliances; Tile & stone backsplash & upgraded espresso cabinets with granite countertops & raised bar top. Primary Bed & bath w/his & her sinks *Jetted tub & separate shower. Lots of bronze features & grand walk in closet* Spacious laundry adds cabinetry & 1 of a kind water main control valves* So many extras including attic temps. Neighborhood amenities include pools, tennis courts, splash pads, sand volleyball, dog parks & gym! Come home to Canyon Lakes!!' ,`Acres` = '0.1553' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 PINE CREEK AT CANYON LAKES WEST SEC 7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6763' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Creek at Canyon Lakes West Sec 7' ,`TaxAmount` = '6537' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218042' WHERE `Matrix_Unique_ID` = '212250526' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:35:27.140' ,`MLSNumber` = '70136215' ,`ListAgentFullName` = 'Robert Perez' ,`ListOfficeName` = 'The Real Estate Service' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.185838' ,`Longitude` = '-96.273584' ,`PhotoCount` = '9' ,`PostalCode` = '77437' ,`RoomCount` = '8' ,`ListPrice` = '92550.00' ,`Status` = 'Active' ,`StreetName` = 'Burdette' ,`StreetNumber` = '712' ,`StreetSuffix` = '' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS PROPERTY IS INCLUSIVE OF TWO PARCELS OF PROPERTY ! PROPERTY ID\'S R015078 & R015079.. There is also a 12\' x 24 \' storage building on the property and both lots have water and sewer taps/connections' ,`Acres` = '' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'Fairview Lot 4A, & 4B Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25377' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (EL CAMPO)' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairview' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218042' WHERE `Matrix_Unique_ID` = '212274646' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:25:13.140' ,`MLSNumber` = '86319906' ,`ListAgentFullName` = 'Robert Grimes' ,`ListOfficeName` = '2011 AMERICAN REAL ESTATE CO.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.272438' ,`Longitude` = '-94.721589' ,`PhotoCount` = '49' ,`PostalCode` = '75901' ,`RoomCount` = '4' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Suntory Way' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Way' ,`City` = 'Lufkin' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '6539' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your friends and family will enjoy all of the space in this 4 bedroom, 3 full bath, 2 half bath home in Crown Colony\'s gated community. Over 6000 square feet allows you to do lots of entertaining. The game room and a pool with outdoor kitchen are additional bonuses! One of the en-suites upstairs has additional separate entrance from the the 3 car garage. downstairs office and bonus room on the 3rd floor could be additional bedroom. Primary bedroom with luxurious closets and bathroom is downstairs. Fridge conveys with house. The home is on two lots. If you would like to purchase with only one lot price is $790,000' ,`Acres` = '0.8746' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '3731 CROWN COLONY SEC VI-B BLK 1 LOT 25 - 26 ,1/41 INT IN ST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '38100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '186 - Lufkin' ,`SchoolElementary` = 'ANDERSON ELEMENTARY' ,`SchoolHigh` = 'LUFKIN HIGH SCHOOL' ,`SchoolMiddle` = 'LUFKIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Crown Colony Sec Vi-B' ,`TaxAmount` = '15906' ,`TaxRate` = '2.3856' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218043' WHERE `Matrix_Unique_ID` = '212448868' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:17:54.807' ,`MLSNumber` = '95437565' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515549' ,`Longitude` = '-95.802451' ,`PhotoCount` = '29' ,`PostalCode` = '77471' ,`RoomCount` = '5' ,`ListPrice` = '395015.00' ,`Status` = 'Active' ,`StreetName` = 'Bartagrass' ,`StreetNumber` = '4704' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous single-story, 4 bedrooms, 2 baths, study, 3-car tandem attached garage and covered patio. Large open family room with casual dining area, and kitchen with countertop dining. The study overlooks the covered\r\npatio. Secondary bedrooms feature walk-in closets. Private master suite with spacious master bath with\r\nseparate sinks, garden tub, shower, and ample closet space. NOTE - Home is under construction. As such, photos are REPRESENTATIVE of the floorplan/home and are NOT of the actual home. Selections and features will vary. For more information, contact Chesmar Homes in Seabourne Landing. DECEMBER 2022 estimated completion.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Seabourne Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.94' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218043' WHERE `Matrix_Unique_ID` = '212560222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:38:56.360' ,`MLSNumber` = '93549093' ,`ListAgentFullName` = 'Bruce Sellers' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.455572' ,`Longitude` = '-95.474626' ,`PhotoCount` = '20' ,`PostalCode` = '77378' ,`RoomCount` = '8' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Coaltown' ,`StreetNumber` = '14850' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute One story brick 3/1.5 home located in Arroowhead Lakes. New Septic system installed and fresh paint inside and NEW CARPET. The garage was converted into a 4th bedroom/gameroom/playroom, it\'s just off the kitchen. The primary bedroom is at the back of the house with 1/2 bath. The secondary bedrooms are down the hallway with the full bath, tub/shower combo. Laminate flooring in the living room, kitchen and breakfast area. Kitchen offers tile counters, breakfast bar and white appliances. There are French doors off the breakfast room that leads out onto the back patio. Home is move in ready! Great starter home or for your rental pool. Easy access to Willis & Conroe for your shopping and dining needs. LOW TAXES & HOA! Willis ISD.' ,`Acres` = '0.1549' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ARROWHEAD LAKES 3, BLOCK 28, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arrowhead Lakes' ,`TaxAmount` = '2664' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Aerobic,Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218043' WHERE `Matrix_Unique_ID` = '212689942' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:25:33.373' ,`MLSNumber` = '46409487' ,`ListAgentFullName` = 'Cynthia Pierce' ,`ListOfficeName` = 'Gann Medford Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.309237' ,`Longitude` = '-94.719928' ,`PhotoCount` = '29' ,`PostalCode` = '75901' ,`RoomCount` = '2' ,`ListPrice` = '324000.00' ,`Status` = 'Active' ,`StreetName` = 'Park' ,`StreetNumber` = '105' ,`StreetSuffix` = 'Place' ,`City` = 'Lufkin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1763' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This new construction is complete! 2 bedrooms and 2 baths in the Timber Cove Subdivision. High ceilings throughout, a great flow and lots of storage. Kitchen with breakfast bar and open to dining and living area. Quartz countertops and stainless appliances. So many amenities including spray foam insulation, Trane pump, sod yard, custom closet built-ins, LED recessed lighting throughout, luxury vinyl plank flooring and smart home accessories. These include thermostat, 3 light switches, video doorbell and garage door opener. Double attached garage.' ,`Acres` = '0.1556' ,`Area` = '45' ,`BuilderName` = 'Rodney Moore' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '6400 TIMBER COVE PHASE 1-B BLK 1 LOT 4' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '6776' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '186 - Lufkin' ,`SchoolElementary` = 'ANDERSON ELEMENTARY' ,`SchoolHigh` = 'LUFKIN HIGH SCHOOL' ,`SchoolMiddle` = 'LUFKIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Cove Ph 1-B' ,`TaxAmount` = '373' ,`TaxRate` = '2.3856' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218043' WHERE `Matrix_Unique_ID` = '212761213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:03:08.550' ,`MLSNumber` = '10474538' ,`ListAgentFullName` = 'Lyn Innes' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.082318' ,`Longitude` = '-96.624004' ,`PhotoCount` = '28' ,`PostalCode` = '75002' ,`RoomCount` = '17' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Soapberry' ,`StreetNumber` = '838' ,`StreetSuffix` = 'Drive' ,`City` = 'Allen' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom built home on corner lot, East facing w soaring 20-Foot Ceilings.Walk to elementary across the street. BOB fencing, rear entry Electric Gate, storage unit & extra RV or boat parking. Backyard oasis, palm & banana trees w Pool, Spa & Waterfall. Covered patio w ceiling fan, plumbed for gas. Owners suite downstairs with hardwood floors, sitting area, new updated walk-in shower, separate jetted tub & walk-in-closet. Formal living & Dining room w tray ceilings, Office w closet or can be 6th bedroom, Family Room w fireplace, gas starter, wall of windows & half bath on first floor. Game Room with 4 Extra Large bedrooms & 2 full baths upstairs. Kitchen features granite counters, island, breakfast bar & 5 burner Gas Cooktop. Flagstone tile in kitchen, family room, bathrooms & hallway. Solar screens throughout. Two new gas water heaters, 2 HVAC systems replaced 3 & 5 years ago. Roof 2018.' ,`Acres` = '0.24' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ARBOR LAKES ADDITION (CAL), BLK A, LOT 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10444' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '296 - Allen' ,`SchoolElementary` = 'CHANDLER ELEMENTARY SCHOOL (ALLEN)' ,`SchoolHigh` = 'ALLEN HIGH SCHOOL' ,`SchoolMiddle` = 'FORD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Arbor Lakes Add' ,`TaxAmount` = '8396' ,`TaxRate` = '2.1261' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218044' WHERE `Matrix_Unique_ID` = '212778165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:34:55.640' ,`MLSNumber` = '21860044' ,`ListAgentFullName` = 'Cindy Beltran' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694755' ,`Longitude` = '-95.659883' ,`PhotoCount` = '30' ,`PostalCode` = '77083' ,`RoomCount` = '8' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Empanada' ,`StreetNumber` = '15519' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1656' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION BEND SEC 5, BLOCK 31, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7213' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Bend Sec 5' ,`TaxAmount` = '4074' ,`TaxRate` = '2.0847' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218044' WHERE `Matrix_Unique_ID` = '212787809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:21:25.030' ,`MLSNumber` = '769183' ,`ListAgentFullName` = 'Mary Hickey' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.674636' ,`Longitude` = '-97.833883' ,`PhotoCount` = '30' ,`PostalCode` = '78642' ,`RoomCount` = '12' ,`ListPrice` = '1125000.00' ,`Status` = 'Active' ,`StreetName` = 'Arbolado' ,`StreetNumber` = '113' ,`StreetSuffix` = 'Loop' ,`City` = 'Liberty Hill' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3798' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate Single Story home in Santa Rita Ranch. Pristine landscaping. The flow of this floor plan allows for easy entertainment space for family and friends. Wood patterned stone floors throughout living areas. 2 spacious living areas. 2nd living area can be media room or game room. Large kitchen with quartz countertops Additional counter space for beverage bar. Breakfast room with large windows has views of backyard. Work space/study desk in breakfast room. Dining room is very large and ideal for formal dining.. Private office with double glass doors makes working remotely enjoyable. 4 Bedrooms plus office. Primary bedroom with bay window allows for additional seating area. Upgraded ceiling fans. Extended covered patio with lighting illuminates this spectacular outdoor living space. Plenty of Room for a Pool. Playscape conveys. 3 Car Garage. Enjoy the Santa Rita Ranch amenities Georgetown ISD' ,`Acres` = '' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S12198 - SANTA RITA RANCH PH 1 SEC 12, BLOCK A, LOT 110' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '69' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '223 - Georgetown' ,`SchoolElementary` = 'WOLF RANCH ELEMENTARY' ,`SchoolHigh` = 'EAST VIEW HIGH SCHOOL' ,`SchoolMiddle` = 'JAMES TIPPIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Rita Ranch Ph 1 Sec 12' ,`TaxAmount` = '24699' ,`TaxRate` = '2.5837' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218044' WHERE `Matrix_Unique_ID` = '212823255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:58:25.563' ,`MLSNumber` = '44731608' ,`ListAgentFullName` = 'Jarred DeMore' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467685' ,`Longitude` = '-94.599651' ,`PhotoCount` = '40' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Gulfview' ,`StreetNumber` = '2754' ,`StreetSuffix` = 'Lane' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Awesome rental for STR investors in The Tidelands subdivision! Great location, awesome views and close to beach with automobile/golf cart access to beach! Spacious, open-concept living! Sleeps at least 11, so it\'s perfect for large groups! Sit up on the deck and enjoy the morning and evening views of the Gulf. When the sun goes down, BBQ with family and friend\'s downstairs with tons of room for games and hanging out and creating life-long memories. This home features a nice sized one car garage and a cargo lift. Inside features a large kitchen with granite throughout. Spacious bedrooms with bunks in two of the rooms. Wait no more, let\'s get this party started! Schedule your showing today before this one is gone.' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 7 LOT 2 BLK 7 TIDELANDS ADDN' ,`LotDesciption` = 'Water View' ,`LotSize` = '5000' ,`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` = 'Tidelands' ,`TaxAmount` = '6761' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218044' WHERE `Matrix_Unique_ID` = '212929918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:56:17.473' ,`MLSNumber` = '38084384' ,`ListAgentFullName` = 'Ty Robinson' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841899' ,`Longitude` = '-95.360924' ,`PhotoCount` = '35' ,`PostalCode` = '77022' ,`RoomCount` = '5' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Firnat' ,`StreetNumber` = '1207' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This rare find 5 bedroom home with two bathroom is perfect for your next investment. This home comes move-in ready with an installed fire sprinkler system and a full furnished (not shown in photos) with two beds per room and living room tables and desk which all can be included with the purchase. This home is not located in a HOA. Agent to verify all room sizes.' ,`Acres` = '0.1951' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 BLK 2 PLYMOUTH PLACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURBANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Plymouth Place' ,`TaxAmount` = '5140' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218045' WHERE `Matrix_Unique_ID` = '212998730' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:44:29.517' ,`MLSNumber` = '51566035' ,`ListAgentFullName` = 'Michael Knowles' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729070' ,`Longitude` = '-95.744409' ,`PhotoCount` = '38' ,`PostalCode` = '77450' ,`RoomCount` = '13' ,`ListPrice` = '838738.00' ,`Status` = 'Active' ,`StreetName` = 'Ganton' ,`StreetNumber` = '21315' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5107' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mature shade providing oak trees in the front and back with no rear neighbors! The breakfast nook, open kitchen and Family Room (with fireplace) are on one side of the home and the Primary Bedroom / Bath are on the opposite side. Huge Formal Living Room overlooks the back yard. This beauty has a Formal Living / Formal Dining / Study / Game Room / Wet Bar AND a Media Room with Theater Seating.\r\n5 Big Bedrooms and 4 1/2 baths with room for a pool...all in the award-winning Katy ISD....come see this today!' ,`Acres` = '0.2884' ,`Area` = '36' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KELLIWOOD GREENS SEC 1, BLOCK 1, LOT 7' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '12563' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CREECH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Greens' ,`TaxAmount` = '12045' ,`TaxRate` = '2.495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218045' WHERE `Matrix_Unique_ID` = '213472713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T13:59:04.793' ,`MLSNumber` = '78470244' ,`ListAgentFullName` = 'Caleb Martinez' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.515923' ,`Longitude` = '-97.147696' ,`PhotoCount` = '18' ,`PostalCode` = '76711' ,`RoomCount` = '2' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Columbia' ,`StreetNumber` = '1809' ,`StreetSuffix` = 'Street' ,`City` = 'Waco' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Let\'s move to Waco, TEXAS! Check out this Cute Cute Cute 2 bedroom, 1 bath home in Beverly Hills Waco, Texas. Freshly painted. Laminate & Tile flooring. Ceiling fans in each bedroom & living area. Updated kitchen with Granite counters! Remolded bathroom plus more! Don\'t wait to come see this gem! Will get measurements of rooms this weekend. All measurements are approximate.' ,`Acres` = '0.1722' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TERRACE PARK BLOCK 2 LOT 13 ACRES .1722' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1007 - Waco' ,`SchoolElementary` = 'UNIVERSITY HIGH SCHOOL' ,`SchoolHigh` = 'UNIVERSITY HIGH SCHOOL' ,`SchoolMiddle` = 'CESAR CHAVEZ MIDDLE SCHOOL (WACO)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Terrace Park' ,`TaxAmount` = '2616' ,`TaxRate` = '2.5867' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218045' WHERE `Matrix_Unique_ID` = '213522254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:52:55.540' ,`MLSNumber` = '51460765' ,`ListAgentFullName` = 'Dana Staples' ,`ListOfficeName` = 'Staples Sotheby\'sInternational' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.187953' ,`Longitude` = '-95.851711' ,`PhotoCount` = '47' ,`PostalCode` = '75751' ,`RoomCount` = '6' ,`ListPrice` = '700000.00' ,`Status` = 'Active' ,`StreetName` = 'Palestine' ,`StreetNumber` = '900' ,`StreetSuffix` = 'Street' ,`City` = 'Athens' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3967' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An entertainer\'s delight, this home is located in an established neighborhood on a spacious corner lot with trees that offer plenty of shade. This traditional Chicago Antique brick home features large 3BR, 2.5 Bath, formal dining & LA, den, large kitchen bkfast/dining area, brick, parquet & carpet floors, great backyard. Several living areas, versatile living setups. Large, enclosed patio/sunroom has promises versatile usage.' ,`Acres` = '0.56' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT: LT 1 AB 782 T PARMER SUR PARK HIGHLANDS BLK 16 LT 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '317 - Athens' ,`SchoolElementary` = 'SOUTH ATHENS' ,`SchoolHigh` = 'ATHENS HIGH SCHOOL' ,`SchoolMiddle` = 'ATHENS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Hlnds Add' ,`TaxAmount` = '6136' ,`TaxRate` = '2.6079' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218045' WHERE `Matrix_Unique_ID` = '213666774' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:18:55.070' ,`MLSNumber` = '41040630' ,`ListAgentFullName` = 'Rachel Anderson' ,`ListOfficeName` = 'Rachel Anderson Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.561087' ,`Longitude` = '-96.140113' ,`PhotoCount` = '28' ,`PostalCode` = '75860' ,`RoomCount` = '6' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'FCR 683' ,`StreetNumber` = '139' ,`StreetSuffix` = '' ,`City` = 'Teague' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just off of I-45 near Dew on a non-thru road is this cozy 2 bed, 1 bath, story & half on approximately 11.31 acres. The land is shaded by many mature trees and Caroline Creek runs through the middle. A large pond is near the house & visible from the covered front porch. Nice privacy paired with the convenience of being near I-45. Centrally located between Dallas and Houston. Open living rm with eat in kitchen, refrigerator included, laundry room with full size washer & dryer area right off the kitchen for added convenience. Bathroom with tub & shower combo, Upstairs is a large room with window seat that would be a great 2nd bedroom or office. The back porch has been enclosed for additional living space for an office or guest room. Detached 2 car metal garage with exterior door & two roll up doors, RV Cover, Seller to reserve mineral rights, storage bldg not included.' ,`Acres` = '11.31' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WM OAKLEY A-481' ,`LotDesciption` = 'Wooded' ,`LotSize` = '492664' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '276 - Dew' ,`SchoolElementary` = 'DEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEW SCHOOL' ,`SchoolMiddle` = 'DEW ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'none' ,`TaxAmount` = '1484' ,`TaxRate` = '1.5859' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218046' WHERE `Matrix_Unique_ID` = '213750163' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T14:05:54.000' ,`MLSNumber` = '90094427' ,`ListAgentFullName` = 'Christopher Sambursky' ,`ListOfficeName` = 'Realty Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739937' ,`Longitude` = '-95.750548' ,`PhotoCount` = '46' ,`PostalCode` = '77450' ,`RoomCount` = '4' ,`ListPrice` = '419999.00' ,`Status` = 'Active' ,`StreetName` = 'Norwood Hills' ,`StreetNumber` = '2923' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the wonderful community of Kelliwood. Low tax rate with a great school district & zero flooding. Great curb appeal. This charming home is located in the front of the neighborhood with 4 bedrooms & 2.5 baths. An extremely large drive way for plenty of parking. Very peaceful & quiet backyard. Plenty of closet space in the primary bedroom. Beautiful kitchen with a large walk in pantry. Don\'t miss the opportunity to be moved in before the holidays!' ,`Acres` = '0.1944' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KELLIWOOD TERRACE SEC 1, BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8467' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'EXLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Terrace Sec 1' ,`TaxAmount` = '6402' ,`TaxRate` = '2.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218046' WHERE `Mat