Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T08:58:37.640' ,`MLSNumber` = '31139819' ,`ListAgentFullName` = 'David Peterson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732277' ,`Longitude` = '-95.364647' ,`PhotoCount` = '8' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'live oak st' ,`StreetNumber` = '3404' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lt22 Travis' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'White Holman' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663693573' WHERE `Matrix_Unique_ID` = '201182036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:02:01.293' ,`MLSNumber` = '25151214' ,`ListAgentFullName` = 'Trish Tran' ,`ListOfficeName` = 'Chodrow Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746120' ,`Longitude` = '-95.323840' ,`PhotoCount` = '29' ,`PostalCode` = '77011' ,`RoomCount` = '8' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Brady' ,`StreetNumber` = '5005' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely renovated ‘down to the studs’. Beautifully remodeled one-story home with modern open plan and contemporary finishes. 10 FT high ceilings. NEW ROOF w/ 5 year warranty. Newly installed luxury vinyl plank and tile floors throughout; no carpet. All new electrical, plumbing, HVAC, tankless water heater, windows, lighting and doors. All exterior doors have smart lock. Kitchen features quartz countertop, custom shaker cabinetry, pull-out spice cabinet, lazy Susan cabinet. All cabinets/drawers are soft closing. Newly installed baseboard vacuum. Property features a main house and a guest house perfect for a Mother-in-Law Suite or can be used as an Income Producing Property! Main house has 3 Beds 2 Baths at 1,264 SQFT, Guest House offers same finishes with 1 Bed 1 Bath includes kitchen at 512 SQFT. Master bedroom has 2 walk-in closets and ensuite bathroom featuring frameless glass walk-in shower. French drain system in back yard. Completely fenced with automatic driveway gate.' ,`Acres` = '0.1488' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 43 OAK LAWN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Lawn' ,`TaxAmount` = '2615' ,`TaxRate` = '2.330662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693573' WHERE `Matrix_Unique_ID` = '204195122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:16:05.090' ,`MLSNumber` = '36904948' ,`ListAgentFullName` = 'Eliesa Wright' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.311896' ,`Longitude` = '-95.443058' ,`PhotoCount` = '34' ,`PostalCode` = '75835' ,`RoomCount` = '3' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Briar' ,`StreetNumber` = '124' ,`StreetSuffix` = 'Lane' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEAT AS A PIN! \r\n Very well loved and well-maintained home in the heart of Crockett, TX! This three bedroom, two bath house is ready for a new family to call it home. There is a large, fenced backyard, attached two-car garage, and rain gutters with leaf filter along the front of the home. The living area adjoins the kitchen and breakfast area and features a wood-burning fireplace and pretty wood beams along the ceiling. There is a separate formal dining/living area in the front of the home that can be accessed near the front door and through the kitchen. Through the garage, there is a good-sized laundry room with shelving and a window to the backyard. On the opposite side of the living room from the kitchen, there are three bedrooms and two bathrooms. There is ample closet and storage space in this home. Through the siding glass door to the backyard, there is a covered patio area to relax under. Come and see this home today to see if it’s the one for you!' ,`Acres` = '0.308' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CRESTWOOD LOT 28' ,`LotDesciption` = 'Other' ,`LotSize` = '13416' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '1940' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693573' WHERE `Matrix_Unique_ID` = '206526256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:31:03.093' ,`MLSNumber` = '53206551' ,`ListAgentFullName` = 'Lynn Winget' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.230533' ,`Longitude` = '-94.892553' ,`PhotoCount` = '22' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '1299000.00' ,`Status` = 'Active' ,`StreetName` = 'Neptune' ,`StreetNumber` = '3827' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful beachside home located steps from the beach in Galveston\'s Beachside Village. 4 bedrooms and 2.5 bathrooms make this house great for entertaining. Spacious open living room and kitchen with custom white cabinets, quartz countertops and oil finish wood floors. Covered decks to enjoy the gulf breeze. Louvered ground floor storage for a more favorable flood insurance rate. More features include: outdoor shower, double paver drive.\r\nSeller is motivated in this market' ,`Acres` = '0.0891' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BEACHSIDE VILLAGE (2004) ABST 121, LOT 33, ACRES 0.089' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '3880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1244' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Beachside Village 2004' ,`TaxAmount` = '12093' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693573' WHERE `Matrix_Unique_ID` = '207593134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:52:21.627' ,`MLSNumber` = '83478412' ,`ListAgentFullName` = 'Cynthia Block' ,`ListOfficeName` = 'CB&A, Realtors- Loop Central' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664315' ,`Longitude` = '-95.510349' ,`PhotoCount` = '32' ,`PostalCode` = '77071' ,`RoomCount` = '5' ,`ListPrice` = '619000.00' ,`Status` = 'Active' ,`StreetName` = 'Rollingbrook' ,`StreetNumber` = '7603' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4030' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcoming spacious home with bonus area available. Circular drive leads you to an enclosed tiled entry. Entering the house your choice is to go into the the naturally lit, entertainment friendly, living area or the bedroom wing. The entertainment area, has a generously sized living room which boasts a gas fireplace and abuts a spacious sunroom. The eat in kitchen is remodeled and has new cabinets, appliances and countertops. Storage is plentiful.The sunroom leads to a large backyard patio and jacuzzi. The bedroom wing contains a large primary bedroom with sitting area, modern oversized en suite, walk-in, built-in closet, 3 additional bedrooms, two full newly remodeled bathrooms.The bonus area, accessed through the house or by separate entrance, has an additional kitchen,1 bedroom with en suite (part of house/5th room), 3 additional rooms and a full bathroom. Can be used as both an extension of the home or a separate income producing apartment. An oversized garage completes the picture.' ,`Acres` = '0.3516' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 FONDREN SW NORTHFIELD SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '15317' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '545' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MILNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Fondren Sw Northfield Sec 03' ,`TaxAmount` = '5697' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663693573' WHERE `Matrix_Unique_ID` = '207824935' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:07:20.717' ,`MLSNumber` = '2990967' ,`ListAgentFullName` = 'Neha Sutrave' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.102297' ,`Longitude` = '-94.187818' ,`PhotoCount` = '50' ,`PostalCode` = '77713' ,`RoomCount` = '4' ,`ListPrice` = '284900.00' ,`Status` = 'Active' ,`StreetName` = 'Sunflower' ,`StreetNumber` = '2275' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful family home in one of Beaumont\'s sought-out neighborhoods with no HOA.' ,`Acres` = '0.2112' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GLADYS WEST SECT 1 LOT 18 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Gladys West Sec 1' ,`TaxAmount` = '6313' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693573' WHERE `Matrix_Unique_ID` = '207915749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:33:16.130' ,`MLSNumber` = '423136' ,`ListAgentFullName` = 'Jacqueline Nargang' ,`ListOfficeName` = 'Nargang Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872434' ,`Longitude` = '-95.688002' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Betonica' ,`StreetNumber` = '6631' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful 3 bedroom single level home. Tile throughout the entire home. No carpet! Large bedrooms and living room space. Water Heater recently replaced. Interior of the home has been freshly painted! Main bathroom has double stand up shower. Outdoor covered patio in the back yard. This is a must see for anyone!' ,`Acres` = '0.1446' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 3 AUTUMN RUN SEC 2 2ND R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Autumn Run Sec 02' ,`TaxAmount` = '5432' ,`TaxRate` = '2.586' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693573' WHERE `Matrix_Unique_ID` = '208641195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:44:05.270' ,`MLSNumber` = '79592322' ,`ListAgentFullName` = 'Doris Ostrander' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771358' ,`Longitude` = '-95.865652' ,`PhotoCount` = '30' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '539800.00' ,`Status` = 'Active' ,`StreetName` = 'Cranford Sage' ,`StreetNumber` = '28618' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Former Model Home and READY for You Now! Unique Owner Assist Program with No Credit Check, No Income Verification, Deed in your name, No Prepayment Penalty, No soon Expected timeframe to pay off, No SSN. HIGHLY DESIRED Katy Schools Make the List! Save on Gas as you are right down the street to H.E.B., Kroger\'s, Costco, Katy Mills Mall and more; 4 Minutes to Main Highways; Gorgeous naturally light filtered home, Two Story Foyer, Two Dining areas, Two Living areas, Primary bedroom En-Suite Downstairs, 4 Generously sized Bedrooms, 3.5 Baths PLUS a Flex/Study Downstairs; Island Kitchen with Beautiful Granite open to the Den and Two Story Breakfast area, Breathtaking! Huge Game Room upstairs, Covered Patio and sweet Backyard for those BBQ\'s; Beautifully Covered Porch for your Morning Tea/Coffee; Area Pool for those Summer Days, Bike trails, Blocks to the Lake; Former Model Home, Days on Market due to older children\'s schedule...Will not last long now! Close fast!' ,`Acres` = '0.1777' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ANSERRA SEC 2, BLOCK 2, LOT 6' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7741' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric 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,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anserra Sec 2' ,`TaxAmount` = '9563' ,`TaxRate` = '3.2845' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693574' WHERE `Matrix_Unique_ID` = '209720430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:18:24.037' ,`MLSNumber` = '10705135' ,`ListAgentFullName` = 'Natalie Malla' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835825' ,`Longitude` = '-95.435359' ,`PhotoCount` = '33' ,`PostalCode` = '77018' ,`RoomCount` = '11' ,`ListPrice` = '1595000.00' ,`Status` = 'Active' ,`StreetName` = 'Candlelight' ,`StreetNumber` = '1353' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '8400 square foot corner lot zoned to the highly sought after Oak Forest Elementary! Contemporary elegance with a well-thought-out and spacious layout. Master bedroom suite offers separate luxury bath and gorgeous custom closet. Luxury light fixtures throughout the home. Subzero/ Wolf appliances. Quality custom finishes. First floor study with a full bath can be used as a 5th bedroom. Home is elevator ready (elevator shaft currently allows for additional storage areas). Large backyard space with plenty of room for a pool and more! Walking distance to park. No previous flooding.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'N & T Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 34' ,`LotDesciption` = 'Corner' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Forest Sec 3' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693574' WHERE `Matrix_Unique_ID` = '210066384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T08:33:31.037' ,`MLSNumber` = '33903971' ,`ListAgentFullName` = 'Bonnie Schinnerer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818604' ,`Longitude` = '-94.386480' ,`PhotoCount` = '34' ,`PostalCode` = '77665' ,`RoomCount` = '8' ,`ListPrice` = '79900.00' ,`Status` = 'Active' ,`StreetName` = 'Elm' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Avenue' ,`City` = 'Winnie' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors special! Great rental opportunity. 3/2 single wide in the hearth of Winnie. The home has a covered concrete front porch to sit under and enjoy the shade. Added extract room for office or extra bedroom.' ,`Acres` = '0.1607' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BK 38 LT 9 WINNIE T/S' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '18 - East Chambers' ,`SchoolElementary` = 'EAST CHAMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EAST CHAMBERS HIGH SCHOOL' ,`SchoolMiddle` = 'EAST CHAMBERS J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'James Hoggatt League' ,`TaxAmount` = '617' ,`TaxRate` = '2.1546' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663693574' WHERE `Matrix_Unique_ID` = '210364361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:35:58.947' ,`MLSNumber` = '80995791' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.332495' ,`Longitude` = '-95.296622' ,`PhotoCount` = '19' ,`PostalCode` = '77306' ,`RoomCount` = '6' ,`ListPrice` = '298385.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Place' ,`StreetNumber` = '2320' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1553' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the upcoming Cedar Crossing subdivision, the Linden is a 1,553 Sq Ft single story home boasting 3 beds, 2 baths and an abundance of stunning features! Upon entering the home, you are greeted by soaring high ceilings, vinyl plank flooring, and a masterfully planned open concept. The gourmet-style kitchen is open to the family room and dining area, boasting a walk-in pantry with built in shelves, a large island, SS appliances, and an abundance of storage space. The primary bedroom is located off of the family room and offers a private en-suite bath flaunting dual sinks, walk-in shower, separate soaking tub, and a large walk-in closet. Exterior features include a fenced-in backyard, covered patio, and a 2 car garage. This home is priced to sell and won\'t last long! Schedule a tour today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Alta Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S345900 - Cedar Crossing 01, BLOCK 4, Lot 11' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693574' WHERE `Matrix_Unique_ID` = '210452547' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:35:43.533' ,`MLSNumber` = '90006708' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.332495' ,`Longitude` = '-95.296622' ,`PhotoCount` = '35' ,`PostalCode` = '77306' ,`RoomCount` = '6' ,`ListPrice` = '290670.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Crest' ,`StreetNumber` = '17726' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1553' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the upcoming Cedar Crossing subdivision, the Linden is a 1,553 Sq Ft single story home boasting 3 beds, 2 baths and an abundance of stunning features! Upon entering the home, you are greeted by soaring high ceilings, vinyl plank flooring, and a masterfully planned open concept. The gourmet-style kitchen is open to the family room and dining area, boasting a walk-in pantry with built in shelves, a large island, SS appliances, and an abundance of storage space. The primary bedroom is located off of the family room and offers a private en-suite bath flaunting dual sinks, walk-in shower, separate soaking tub, and a large walk-in closet. Exterior features include a fenced-in backyard, covered patio, and a 2 car garage. This home is priced to sell and won\'t last long! Schedule a tour today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Alta Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S345900 - Cedar Crossing 01, BLOCK 3, Lot 13' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693574' WHERE `Matrix_Unique_ID` = '210456764' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:29:07.767' ,`MLSNumber` = '85968434' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.333836' ,`Longitude` = '-95.293944' ,`PhotoCount` = '37' ,`PostalCode` = '77306' ,`RoomCount` = '9' ,`ListPrice` = '328547.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Crest' ,`StreetNumber` = '17683' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the upcoming Cedar Crossing subdivision, the Linden is a 2,002 Sq Ft 2-story home boasting 4 beds, 2.5 baths and an abundance of stunning features! Upon entering the home, you are greeted by soaring high ceilings, vinyl plank flooring, and a masterfully planned open concept. The gourmet-style kitchen is open to the family room and dining area, boasting a walk-in pantry with built in shelves, a large island, SS appliances, and an abundance of storage space. The primary bedroom is located off of the family room and offers a private en-suite bath flaunting dual sinks, walk-in shower, separate soaking tub, and a large walk-in closet. Upstairs is the game room, 2 additional bedrooms, and a full bath with dual sinks! Exterior features include a fenced-in backyard, covered patio, and a 2 car garage. This home is priced to sell and won\'t last long! Schedule a tour today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Alta Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S345900 - Cedar Crossing 01, BLOCK 4, Lot 16' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693574' WHERE `Matrix_Unique_ID` = '210468142' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:28:50.153' ,`MLSNumber` = '98133816' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.333836' ,`Longitude` = '-95.293944' ,`PhotoCount` = '38' ,`PostalCode` = '77306' ,`RoomCount` = '6' ,`ListPrice` = '321421.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Place' ,`StreetNumber` = '2324' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the upcoming Cedar Crossing subdivision, the Pinehurst is a 1,815 Sq Ft single story home boasting 3 beds, 2 baths and an abundance of stunning features! Upon entering the home, you are greeted by soaring high ceilings, vinyl plank flooring, and a masterfully planned open concept. The gourmet-style kitchen is open to the family room and dining area, boasting a walk-in pantry with built in shelves, a large island, SS appliances, and an abundance of storage space. The primary bedroom offers a private en-suite bath flaunting dual sinks, walk-in shower, separate soaking tub, and a large walk-in closet. Exterior features include a fenced-in backyard, covered patio, and a 2 car garage. This home is priced to sell and won\'t last long! Schedule a tour today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Alta Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S345900 - Cedar Crossing 01, BLOCK 4, Lot 10' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693574' WHERE `Matrix_Unique_ID` = '210472136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:06:34.637' ,`MLSNumber` = '68753030' ,`ListAgentFullName` = 'Shawn Kneale' ,`ListOfficeName` = 'Realty United' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.115155' ,`Longitude` = '-95.248429' ,`PhotoCount` = '46' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Sweetbay Magnolia' ,`StreetNumber` = '21337' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1995' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super cute, move-in ready,*2018* home located on a cul-de-sac street in the Azalea District. Spacious open floor plan with the kitchen and dining area overlooking the family room. Relax in your secluded primary suite with a private bath that includes double sinks, a vanity area, a separate shower, soaking tub and a large walk-in closet. There\'s also an open flex space across from the primary suite, perfect for an office, nursery or workout area. A few other features include high ceilings, 2\" cordless blinds, walk-in pantry, large utility room, split bedroom layout, 4- sided brick and a covered patio. Another big plus is the security system that\'s installed within the community. Great location and just minutes away from I69, Grand Parkway, IAH, shopping, dining and entertainment. Refrigerator included.' ,`Acres` = '0.1214' ,`Area` = '40' ,`BuilderName` = 'Castle Rock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S222404 - AZALEA DISTRICT 04, BLOCK 1, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5288' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '822' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Azalea District' ,`TaxAmount` = '7273' ,`TaxRate` = '3.2331' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693575' WHERE `Matrix_Unique_ID` = '210927575' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T09:56:58.697' ,`MLSNumber` = '47777879' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975144' ,`Longitude` = '-95.746078' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '583744.00' ,`Status` = 'Active' ,`StreetName` = 'Paseo De La Paz' ,`StreetNumber` = '13907' ,`StreetSuffix` = 'Place' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning two-story home boasts great curb appeal. As you enter the home, you are greeted by an elegant foyer. Continuing into the family room, you will be impressed by the spacious open concept floor plan and high ceilings. The gourmet kitchen features a grand island that overlooks the family room and breakfast nook. Impress guests by hosting a barbeque on your Texas-sized covered patio, or serve an elegant dinner in the formal dining room. You will discover additional entertaining space in the upstairs game room and media room. This home was built for entertaining. Come visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 2' ,`LotDesciption` = 'Other' ,`LotSize` = '6333' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'English,Traditional' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693575' WHERE `Matrix_Unique_ID` = '210938881' --> Updated record success