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-02-01T11:34:54.687' ,`MLSNumber` = '65380681' ,`ListAgentFullName` = 'Stacie Giroux' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788880' ,`Longitude` = '-95.406733' ,`PhotoCount` = '9' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Lawrence' ,`StreetNumber` = '1002' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great for investors for rehab or tear down to build your dream home. Amazing corner lot with beautiful Magnolia tree. Huge industrial garage.\r\n\r\nNo showings on this home. If we have signed accepted contract then we can accommodate.' ,`Acres` = '0.1205' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 8 WEST HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West Heights' ,`TaxAmount` = '8013' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675347620' WHERE `Matrix_Unique_ID` = '185679519' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:32:13.857' ,`MLSNumber` = '60349396' ,`ListAgentFullName` = 'Martha Zuvieta' ,`ListOfficeName` = 'Century 21 Parisher Prop.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.165189' ,`Longitude` = '-96.066444' ,`PhotoCount` = '12' ,`PostalCode` = '77445' ,`RoomCount` = '2' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1736' ,`StreetNumber` = '34524' ,`StreetSuffix` = 'Road' ,`City` = 'Hempstead' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO RESTRICTIONS. Road frontage is amazing for COMMERCIAL/BUSINESS. Horses and mobile homes allowed. NOT IN FLOOD ZONE. Minutes from major freeway 290 and collage station. Endless possibilities.' ,`Acres` = '0.4436' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A301500 A-15 MC LIN BRACEY TRACT 116 ACRES .4436' ,`LotDesciption` = 'Cleared,Corner,Other' ,`LotSize` = '19323' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NONE' ,`TaxAmount` = '1310' ,`TaxRate` = '1.8575' ,`WaterSewer` = 'No Water,Septic Tank,Well' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675347620' WHERE `Matrix_Unique_ID` = '204107490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:19:23.860' ,`MLSNumber` = '22356527' ,`ListAgentFullName` = 'Marie Lane' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.053224' ,`Longitude` = '-94.106180' ,`PhotoCount` = '14' ,`PostalCode` = '77705' ,`RoomCount` = '6' ,`ListPrice` = '39700.00' ,`Status` = 'Active' ,`StreetName` = 'Southerland' ,`StreetNumber` = '2085' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor Special!!! With some TLC, this 3-bedroom 1 bath home will make a great rental or flip. SOLD AS-IS, ABSOLUTELY NO REPAIRS!' ,`Acres` = '0.1373' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'PENNOCK & POTTS L2 BLK F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'BLANCHETTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'ODOM MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pennock & Potts Add' ,`TaxAmount` = '750' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347621' WHERE `Matrix_Unique_ID` = '204941513' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:45:24.380' ,`MLSNumber` = '8574618' ,`ListAgentFullName` = 'Grace Reutzel' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.039074' ,`Longitude` = '-95.410197' ,`PhotoCount` = '24' ,`PostalCode` = '77531' ,`RoomCount` = '3' ,`ListPrice` = '304900.00' ,`Status` = 'Active' ,`StreetName` = 'Yorktown' ,`StreetNumber` = '400' ,`StreetSuffix` = 'Avenue' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Now READY!! The latest new construction home in College Park is now complete and ready for move-in! You won\'t want to miss this one as it has a large side yard and backyard fenced in with sod. \'The Authur\' floor plan features a split layout with the primary bedroom suite separate from bedrooms 2 and 3. You\'ll love how the living room, dining room, and kitchen overlook the backyard and all the windows let in tons of natural light. The neutral color palette of the house is a blank canvas for you to make it your own. The primary bathroom features a large walk-in shower and closet. Need more space? Additional lots and floor plans are available!! Reach out with any questions; we would love to help you explore your options for a new construction house here in College Park!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'American Crafted Hom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'COLLEGE PARK ESTATES SEC 8 (A0066 J E GROCE) (CLUTE) LOT 17' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7470' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'GRIFFITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'College Park Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347621' WHERE `Matrix_Unique_ID` = '205699536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:31:51.143' ,`MLSNumber` = '37312307' ,`ListAgentFullName` = 'Chester Tucker' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.461781' ,`Longitude` = '-95.089274' ,`PhotoCount` = '29' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Easton Glen' ,`StreetNumber` = '104' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2102' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 3 bedroom, 2 bathroom home! This home offers a covered front porch, covered patio, and a two car garage.' ,`Acres` = '0.1426' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAY COLONY NORTHPOINTE SEC 2 (2005) ABST 19, BLOCK 1, LOT 62' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6210' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '346' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'BAY COLONY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Colony Northpointe Sec 2' ,`TaxAmount` = '6405' ,`TaxRate` = '2.7847' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347622' WHERE `Matrix_Unique_ID` = '207084525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:48:16.783' ,`MLSNumber` = '26732271' ,`ListAgentFullName` = 'Alexandra Berry' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005549' ,`Longitude` = '-95.403252' ,`PhotoCount` = '20' ,`PostalCode` = '77073' ,`RoomCount` = '7' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'Regal Trace' ,`StreetNumber` = '15915' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 4 bedroom, 2.5 bathroom home! This two story home also offers a covered front porch, and a 2 car garage. House is being sold AS IS it is down to the studs due to a fire. It has a new roof and electrical is confirmed to work.' ,`Acres` = '0.1107' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 9 IMPERIAL TRACE SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '4824' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'LEWIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Trace' ,`TaxAmount` = '5031' ,`TaxRate` = '2.7445' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347622' WHERE `Matrix_Unique_ID` = '207314463' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:52:58.467' ,`MLSNumber` = '25000295' ,`ListAgentFullName` = 'Allen Hebert' ,`ListOfficeName` = 'Register Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.174275' ,`Longitude` = '-95.167807' ,`PhotoCount` = '36' ,`PostalCode` = '77357' ,`RoomCount` = '9' ,`ListPrice` = '489990.00' ,`Status` = 'Active' ,`StreetName` = 'Caesars' ,`StreetNumber` = '427' ,`StreetSuffix` = 'Circle' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2283' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWLY CONSTRUCTED! NEVER LIVED IN! UNDER CONSTRUCTION! Located in popular Roman Forest. 4 bedroom with 2 Baths. 3 Car Garage. Porcelain Tile through out home. High ceilings. 16 Seer A/C, Foam Insulation, double pane low E windows! Electric fireplace lifelike and visually stunning. One press of the button its on with or without heat. Kitchen features Quartz counter tops, soft close Shaker cabinets and drawers, SS appliances, Gas stove and range. Pot filler above the stove. Breakfast bar. Covered front porch. Enjoy the covered back patio. Contact listing agent for video link of previous built homes. Fantastic location-convenient. 99,shopping,restaurants etc.Low taxes-No MUD tax.New Caney ISD. Attached video link is a similar home.' ,`Acres` = '0.5739' ,`Area` = '40' ,`BuilderName` = 'Builders Excellent R' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 01, BLOCK 3, LOT 22' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '25000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest 01' ,`TaxAmount` = '727' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347623' WHERE `Matrix_Unique_ID` = '207472534' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:13:26.383' ,`MLSNumber` = '13611422' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572169' ,`Longitude` = '-95.119769' ,`PhotoCount` = '16' ,`PostalCode` = '77062' ,`RoomCount` = '4' ,`ListPrice` = '323000.00' ,`Status` = 'Active' ,`StreetName` = 'Neptune' ,`StreetNumber` = '1635' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming home now on the market! Discover a bright and open interior with plenty of natural light and a neutral color palate, complimented by a fireplace. This lovely kitchen features a stylish backsplash and generous storage space in the walk in pantry. You won’t want to leave the serene primary suite, the perfect space to relax. Extra bedrooms add nice flex space for your everyday needs. Take advantage of the extended counter space in the primary bathroom complete with double sinks and under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Don\'t wait! Make this beautiful home yours today. This home has been virtually staged to illustrate its potential' ,`Acres` = '0.2782' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 255 BLK 24 CLEAR LAKE CITY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '94' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Lake City Sec 03' ,`TaxAmount` = '8028' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675347623' WHERE `Matrix_Unique_ID` = '207578264' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:07:04.083' ,`MLSNumber` = '27821448' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Tamara Mohl' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.655339' ,`Longitude` = '-95.053251' ,`PhotoCount` = '19' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '359794.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Daw Boardwalk' ,`StreetNumber` = '3037' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Step into this amazing Beazer Home on a corner lot in Morgan’s Landing, boasting a brick façade, sloped ceilings, wood-look tile flooring, extended entry, an open great room, and a covered patio. Whip up meals for guests in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. Relax in the serene primary suite, featuring a walk-in closet, dual vanities, a tub, and a separate shower. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Schools are zoned to La Porte ISD. Call now to learn more!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 38 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347624' WHERE `Matrix_Unique_ID` = '207780121' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:39:11.000' ,`MLSNumber` = '73594335' ,`ListAgentFullName` = 'Oliver Carter' ,`ListOfficeName` = 'Connected Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789514' ,`Longitude` = '-95.376668' ,`PhotoCount` = '25' ,`PostalCode` = '77009' ,`RoomCount` = '14' ,`ListPrice` = '1999900.00' ,`Status` = 'Active' ,`StreetName` = 'Redan' ,`StreetNumber` = '506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This incredible modern farmhouse from visionary builder David Gordon of Aspire Fine Homes offers a flexible layout paired with stunning design, all on an oversized lot ONE BLOCK from Travis Elementary!! With the latest in high-end features and designer finishes selected by Dandy Interiors, this remarkable residence features open-concept living, 4 bedrooms and a game room up, an en-suite office AND 5th bedroom down, and a gigantic yard! Upon entering this gorgeous residence, you are met with a grand double height entry filled with natural light! Walk past the spacious 12x15 en-suite office before the open floorplan reveals the bar, kitchen, mudroom, dining, and living! A beautiful covered back porch overlooks the oversized yard! Upstairs you’ll be immediately greeted with a 21x14 game room before finding the luxuriously appointed laundry and 3 secondaries. The palatial master suite boasts a walk-in shower, soaker tub, double vanities, private toilet, and a spectacular 21x12 closet!' ,`Acres` = '0.182' ,`Area` = '9' ,`BuilderName` = 'Aspire Fine Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 & TR 4A BLK 1 CLAYS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Woodland Heights' ,`TaxAmount` = '16439' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347624' WHERE `Matrix_Unique_ID` = '207802021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:55:52.887' ,`MLSNumber` = '68165486' ,`ListAgentFullName` = 'Michael Crider' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = 'Matthew Parker' ,`SellingOfficeName` = 'Keller Williams Platinum' ,`Latitude` = '30.135715' ,`Longitude` = '-95.759206' ,`PhotoCount` = '50' ,`PostalCode` = '77355' ,`RoomCount` = '11' ,`ListPrice` = '689500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Giant Hickory' ,`StreetNumber` = '21811' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful property in Magnolia. Enjoy nearly 2 acres of land. Bring your horse! This property features: a 2-stall barn with tack room, invisible fence, well water (pump was recently replaced), Propane runs to the stove, furnace, and dryer, heated saltwater pool, firepit, added horse fencing and huge covered back patio. There is dusk to dawn exterior lighting, a bricked mailbox, mature trees for shade and privacy, basketball hoop, 2nd driveway with a double wide gate to access the back yard. Inside the home you will find tray ceilings, high ceilings, 4 bathrooms (1 is Jack and Jill), 4 bedrooms down and a game room/guest suite with full bath upstairs. The Huge master suite has a beautiful bay window, separate shower, jetted bathtub, and 2 large closets. The Island kitchen opens to the family room and has granite counters with travertine tiled backsplash.' ,`Acres` = '1.927' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Propane,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'CLEAR CREEK FOREST 13 REPLAT, BLOCK 3, LOT 4, ACRES 1.927' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '83940' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'J.L. LYON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Spanish,Traditional' ,`Subdivision` = 'Clear Creek Forest' ,`TaxAmount` = '9144' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347625' WHERE `Matrix_Unique_ID` = '208837769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:26:16.360' ,`MLSNumber` = '83999153' ,`ListAgentFullName` = 'Alexandra Berry' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560674' ,`Longitude` = '-95.718084' ,`PhotoCount` = '28' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Field' ,`StreetNumber` = '1911' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately two story home with two-story entry that will draw you into the fantastic open layout. The large kitchen in a cooks dream with abundant cabinets and a center island. Room to roam with five bedrooms. The private primary suite is located downstairs. The additional four bedrooms are upstairs along with a bonus room and study nook. Neutral colors allow you to make this home your own. Spend time outdoors in this spacious and welcoming backyard, and don\'t forget to check out the oversized garage. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.2057' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK WEST SEC 1, BLOCK 1, LOT 8' ,`LotDesciption` = 'Other' ,`LotSize` = '8960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverpark West Sec 1' ,`TaxAmount` = '7527' ,`TaxRate` = '2.8748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347625' WHERE `Matrix_Unique_ID` = '208979021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:58:33.277' ,`MLSNumber` = '52965351' ,`ListAgentFullName` = 'Michelle Comstock' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.674314' ,`Longitude` = '-95.474244' ,`PhotoCount` = '33' ,`PostalCode` = '77096' ,`RoomCount` = '15' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Queensloch' ,`StreetNumber` = '5326' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do you ever find yourself thinking, “if only we had an extra room for...”? Well, think no more! This Meyerland home is exploding w/all the possibilities. One look & you will quickly discover the flexibility & functionality of this home. Primary bedroom is downstairs w/access to the back porch and pool, has an incredibly luxurious bath w/separate shower, clawfoot tub, & double sinks w/gorgeous quartzite counters. The additional room down is perfect as an office w/access to powder bath. This home features two staircases that create access from up to down with ease, and the utility room is spacious, offers tons of natural light & pool view. The modern farmhouse kitchen is appointed w/beautiful SS appliances & finishes, touched by Old Bayou brick, and perfect for entertaining. The adjacent built in wet bar goes right along with the entertaining aspect of the home. Enjoy splashing around in the recently refinished pool w/new equipment and slide. Bonus: all under slab plumbing replaced!' ,`Acres` = '0.235' ,`Area` = '20' ,`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` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 22 MEYERLAND SEC 8 R/P H' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10238' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Meyerland Sec 08 R/P H' ,`TaxAmount` = '13803' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347625' WHERE `Matrix_Unique_ID` = '209184687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:56:30.557' ,`MLSNumber` = '13774390' ,`ListAgentFullName` = 'Jennifer Auer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.192950' ,`Longitude` = '-95.343460' ,`PhotoCount` = '42' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 210' ,`StreetNumber` = '18120' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Paradise right in front of your eyes! Modern home with all the luxuries of the city right at your fingertips. This beautiful quiet country location is in a prime location. Plenty of room to do whatever you like. Shade trees all over this beautiful property. Separate MIL quarters with covered parking for all your guest privacy needs. Screened in patio and swimming pool with hot tub for your relaxing evenings and entertaining weekends. 2 stall barn for all your farming or workshop needs. Another workshop/changing room attached to the pool area. This is one you wont want to miss. Call today to schedule your private viewing before it\'s gone!!' ,`Acres` = '3.84' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Danbury' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0023 S F AUSTIN, BLOCK 22, TRACT 747D-747F, ACRES 3.840' ,`LotDesciption` = 'Other' ,`LotSize` = '167270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '7557' ,`TaxRate` = '2.0772' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347626' WHERE `Matrix_Unique_ID` = '209198496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:59:35.240' ,`MLSNumber` = '66361465' ,`ListAgentFullName` = 'Mel Reyna' ,`ListOfficeName` = 'The Reyna Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857345' ,`Longitude` = '-95.442536' ,`PhotoCount` = '32' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Cebra' ,`StreetNumber` = '6424' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6424 Cebra! This NEW CONSTRUCTION Quintessa Home is located in Highland Heights and offers 3/4 bedrooms (Primary Room Down), 2.5 Baths, 1st floor study, 2-Car Garage and a spacious back yard w/ covered patio. Exterior features include Designer Brick & siding w/ over-sized coach lights, finished front patio floors w/ brick & Sod in Front Yard. Interior features include Wood floors (1st Floor Common Areas), 6 in baseboards, Designer selected fixtures & security system pre-wire. Kitchen offers a large island w/ quartz counter tops, Kent-Moore cabinetry w/ under-cabinet lighting, Undermount stainless sink & SS Appliance package. Primary Suite is located on the 1st Floor & includes an over-sized walk-in closet, separate vanities, separate soaking tub & walk-in shower. Secondary bedrooms & 2nd office/Hobby Room located upstairs, along w/ open Game Room. See the craftsmanship in person by scheduling your showing Today!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Quintessa Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5364' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Heights Annex Sec 2 2nd PAR R/P' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347626' WHERE `Matrix_Unique_ID` = '209265234' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:28:50.140' ,`MLSNumber` = '61892106' ,`ListAgentFullName` = 'Mel Reyna' ,`ListOfficeName` = 'The Reyna Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857345' ,`Longitude` = '-95.442536' ,`PhotoCount` = '30' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Cebra' ,`StreetNumber` = '6432' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6432 Cebra! This NEW CONSTRUCTION Quintessa Home is located in Highland Heights and offers 3/4 bedrooms (Primary Suite Down), 2.5 Baths, 1st floor study, 2-Car Garage and a spacious back yard w/ covered patio. Exterior features include Designer Brick & siding w/ over-sized coach lights, finished front patio floors w/ brick & Sod in Front Yard. Interior features include Wood floors (1st Floor Common Areas), 6 in baseboards, Designer selected fixtures & security system pre-wire. Kitchen offers a large island w/ quartz counter tops, Kent-Moore cabinetry w/ under-cabinet lighting, Undermount stainless sink & SS Appliance package. Primary Suite is located on the 1st floor & includes an over-sized walk-in closet, separate vanities, separate soaking tub & walk-in shower. Secondary bedrooms & 2nd office/Hobby Room located upstairs, along w/ open Game Room. See the craftsmanship in person by scheduling your showing Today!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Quintessa Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5364' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Heights Annex Sec 2 2nd PAR R/P' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347627' WHERE `Matrix_Unique_ID` = '209338127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:24:14.000' ,`MLSNumber` = '64669141' ,`ListAgentFullName` = 'Stacey Howard' ,`ListOfficeName` = 'White Glove Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930966' ,`Longitude` = '-95.082508' ,`PhotoCount` = '12' ,`PostalCode` = '77532' ,`RoomCount` = '5' ,`ListPrice` = '242000.00' ,`Status` = 'Active' ,`StreetName` = 'Port O Call' ,`StreetNumber` = '17111' ,`StreetSuffix` = 'Street' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 2.5 bathroom home in Newport! Open floor plan! Home has been updated with fresh interior paint, new laminate flooring and new carpet. Kitchen with granite countertops and new stainless steel appliances including microwave, dishwasher and electric range. Update downstairs half bath. Upstairs features a den, all 3 bedrooms and full bathroom in hall. Fans added to 2 rooms and the upstairs den. New front fence with added double gate. Fresh landscaping.' ,`Acres` = '0.2152' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 17 NEWPORT SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 03' ,`TaxAmount` = '4394' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347627' WHERE `Matrix_Unique_ID` = '209606904' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:24:01.113' ,`MLSNumber` = '50621002' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219483' ,`Longitude` = '-95.163308' ,`PhotoCount` = '10' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '316897.00' ,`Status` = 'Active' ,`StreetName` = 'Willie Mays' ,`StreetNumber` = '15327' ,`StreetSuffix` = 'Court' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S893004 - Splendora Fields 04 Phase One, BLOCK 1, Lot 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8554' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.4881' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347628' WHERE `Matrix_Unique_ID` = '209629937' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:23:37.917' ,`MLSNumber` = '81708811' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220520' ,`Longitude` = '-95.159585' ,`PhotoCount` = '7' ,`PostalCode` = '77372' ,`RoomCount` = '5' ,`ListPrice` = '278733.00' ,`Status` = 'Active' ,`StreetName` = 'Babe Ruth' ,`StreetNumber` = '26035' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1421' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S893004 - Splendora Fields 04 Phase One, BLOCK 2, Lot 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8119' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.4881' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347628' WHERE `Matrix_Unique_ID` = '209630818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:23:16.420' ,`MLSNumber` = '15832647' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219214' ,`Longitude` = '-95.163200' ,`PhotoCount` = '9' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '298728.00' ,`Status` = 'Active' ,`StreetName` = 'Willie Mays' ,`StreetNumber` = '15335' ,`StreetSuffix` = 'Court' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S893004 - Splendora Fields 04 Phase One, BLOCK 1, Lot 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10369' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.4881' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347629' WHERE `Matrix_Unique_ID` = '209631520' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:40:19.127' ,`MLSNumber` = '39993245' ,`ListAgentFullName` = 'Darian Candler' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.001683' ,`Longitude` = '-95.764770' ,`PhotoCount` = '27' ,`PostalCode` = '77433' ,`RoomCount` = '5' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Field Green' ,`StreetNumber` = '22103' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 3 bedroom, 2 bathroom single level home! This home offers a covered front porch, and a two car garage.' ,`Acres` = '0.1458' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 2 FAIRFIELD VILLAGE SOUTH SEC 8' ,`LotDesciption` = 'Other' ,`LotSize` = '6350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Village South Sec 08' ,`TaxAmount` = '6851' ,`TaxRate` = '2.746' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347629' WHERE `Matrix_Unique_ID` = '210120775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:47:55.660' ,`MLSNumber` = '63949949' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362729' ,`Longitude` = '-95.366084' ,`PhotoCount` = '7' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '384727.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel Place' ,`StreetNumber` = '6022' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a spacious 2 story home set on a 1/3 acre lot. Has 5 large bedrooms and 3 full baths with granite throughout the house.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '030205' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '1.844' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347630' WHERE `Matrix_Unique_ID` = '210132181' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:16:40.723' ,`MLSNumber` = '19962838' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219339' ,`Longitude` = '-95.163313' ,`PhotoCount` = '6' ,`PostalCode` = '77372' ,`RoomCount` = '6' ,`ListPrice` = '287144.00' ,`Status` = 'Active' ,`StreetName` = 'Willie Mays' ,`StreetNumber` = '15331' ,`StreetSuffix` = 'Court' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1651' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful single story home was designed with the elegance and style that our customers have come to expect in a First America Home. From the custom ceiling details at the entry and master bedroom, to the exterior construction: Brick and Stone.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S893004 - Splendora Fields 04 Phase One, BLOCK 1, Lot 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.4881' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347630' WHERE `Matrix_Unique_ID` = '210212121' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:05:10.410' ,`MLSNumber` = '32043339' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.163410' ,`Longitude` = '-95.420181' ,`PhotoCount` = '8' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '283777.00' ,`Status` = 'Active' ,`StreetName` = 'Lago' ,`StreetNumber` = '1' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1486' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Lago Court Angleton, TX 77515 is listed for sale for 292,000. It is a 1,486 sq. ft. house with 3 beds and 2 full baths located in Kiber Reserve' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '010209' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347631' WHERE `Matrix_Unique_ID` = '210222433' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:56:42.803' ,`MLSNumber` = '9139406' ,`ListAgentFullName` = 'Jessica Armstrong' ,`ListOfficeName` = 'Armstrong Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.438066' ,`Longitude` = '-96.572607' ,`PhotoCount` = '21' ,`PostalCode` = '77836' ,`RoomCount` = '5' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Teal Lake Dr' ,`StreetNumber` = '799' ,`StreetSuffix` = '' ,`City` = 'Caldwell' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '+/- 1.476 acres of secluded property with a 2020 Clayton Homes Farmhouse Breeze Manufactured home with all of the upgrades available in that year model. This property is just a short drive to Bryan/College Station (20 miles), Caldwell (12 miles), and Snook (8 miles). Enjoy and relax in a perfect farm home, suitable for any family. This property is turn-key and comes with several pieces of personal property at no cost to the buyers. Enjoy great neighborhood amenities at your fingertips, such as a park and local fire department. Don’t miss your chance to own a beautiful little piece of Burleson County.' ,`Acres` = '1.48' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '1.476 acres, S3450 Beaver Creek Lot 638' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '60984' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '192 - Snook' ,`SchoolElementary` = 'SNOOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SNOOK SECONDARY SCHOOL' ,`SchoolMiddle` = 'SNOOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Beaver Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347631' WHERE `Matrix_Unique_ID` = '210369588' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:12:43.717' ,`MLSNumber` = '27734456' ,`ListAgentFullName` = 'Heather Hatfield' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769202' ,`Longitude` = '-95.413177' ,`PhotoCount` = '32' ,`PostalCode` = '77007' ,`RoomCount` = '8' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Reinerman' ,`StreetNumber` = '806' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2383' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Excellent opportunity for INVESTORS! This home is currently leased through June, 2023. Beautiful Spanish/Mediterranean patio home conveniently located in the Memorial Park/Washington area. Huge primary suite features a gorgeous bathroom, large walk-in closet, adjacent sitting room, rooftop terrace, and second balcony. Large open living on the second floor with formal dining, breakfast bar, open kitchen, dry bar area with wine fridge, second bedroom and full-size bathroom. State of the art home automation and sound system in the home. First floor bedroom, bathroom, plus additional space for second living or study. Great fenced in easement offers yard space for exclusive use of 806 Reinerman on the side of the home (owned by City of Houston), accessible via the 1st floor bedroom or the gate beside the driveway. All appliances included. Currently tenant occupied, limited access/ advance notice for showings. Please call for details.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 3, Blk 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1525' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Mediterranean,Spanish' ,`Subdivision` = 'Park Villas at Reinerman' ,`TaxAmount` = '11088' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347632' WHERE `Matrix_Unique_ID` = '210420645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:14:27.940' ,`MLSNumber` = '33870266' ,`ListAgentFullName` = 'Kyle Watters' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.131632' ,`Longitude` = '-95.410262' ,`PhotoCount` = '34' ,`PostalCode` = '77386' ,`RoomCount` = '7' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Creston' ,`StreetNumber` = '1938' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Located on a corner lot in Imperial Oaks, this 3 bedroom, 2 bath has a recently updated downstairs (2021), with the garage having been built out into a fourth bedroom, den, or game room. Kitchen has been recently updated with new cabinets, floors, and countertops, along with new appliances throughout. Two bedrooms upstairs share a full bath with two balconies, one in the front and one in back of the house. 32 windows throughout this home give ample natural lighting, with plenty of privacy from the landscaping and backyard fencing. The backyard features a beautiful sparkling pool with a new pump installed in 2021. Thanks for showing!' ,`Acres` = '0.2009' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS 03, BLOCK 15, LOT 37' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks 03' ,`TaxAmount` = '4780' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347632' WHERE `Matrix_Unique_ID` = '210422992' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:09:12.610' ,`MLSNumber` = '15861677' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872349' ,`Longitude` = '-95.797874' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '454909.00' ,`Status` = 'Active' ,`StreetName` = 'Thief River Falls' ,`StreetNumber` = '6026' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2674' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to 6022 Thief River Falls Drive located in the community of Katy Lakes and zoned to Katy ISD. This home features 4 bedrooms, 2 full baths, 1 half bath and an attached 2 car garage. The first floor includes a home office, kitchen that is open to the family room and breakfast area and owner\'s retreat. Come upstairs where you will find 3 additional bedrooms and a loft space perfect for a game room. Don\'t forget to step out back for a view of the backyard. You don\'t want to miss all this gorgeous home has to offer! Estimated completion is November 2022. Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Katy Lakes Section 5, Lot 3, Block 10' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6020' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Katy Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347633' WHERE `Matrix_Unique_ID` = '210424721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:00:19.073' ,`MLSNumber` = '3993629' ,`ListAgentFullName` = 'Will Clark' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.188591' ,`Longitude` = '-95.428168' ,`PhotoCount` = '34' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Greystone' ,`StreetNumber` = '6' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2472' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one of a kind floor plan is built by Heritage Homes. Open Floor plan, great room , 4 bedroom , 3 baths . Cul-de-sac Lot, separate office, privacy fence, beautiful Greystone Subdivision.' ,`Acres` = '0.19' ,`Area` = '5' ,`BuilderName` = 'Heritage Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Greystone SD Blk 1 Lot 20' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Greystone' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347633' WHERE `Matrix_Unique_ID` = '210449824' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:40:43.583' ,`MLSNumber` = '87642198' ,`ListAgentFullName` = 'Erik Frankson' ,`ListOfficeName` = 'Ward Real Estate, Inc' ,`SellingAgentFullName` = 'AJ Guel' ,`SellingOfficeName` = 'John Petty, REALTORS' ,`Latitude` = '28.967584' ,`Longitude` = '-95.957300' ,`PhotoCount` = '24' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '599000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Valhalla' ,`StreetNumber` = '55' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one has it all! A great layout starting with a large foyer, 2 fireplaces, 2 living rooms, a formal dining room, & big utility room. Kitchen features stainless steel appliances & granite countertops, walk-in pantry, & breakfast nook. Tons of storage throughout, there\'s even a closet under the stairs! Downstairs there\'s office with built-ins galore, a 1/2 bath for guests, & a nice primary suite with 2 walk-in closets. Beautiful staircase leads to 3 more bedrooms & 2 baths. Fabulous backyard is set up for entertaining with the sparkling pool, screened-in outdoor kitchen, & a putting green!' ,`Acres` = '0.6' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'VALHALLA S/D SEC 3, LOT 6 (LESS W 5\')' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Valhalla' ,`TaxAmount` = '9494' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347634' WHERE `Matrix_Unique_ID` = '210558883' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:43:38.940' ,`MLSNumber` = '43563422' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292770' ,`Longitude` = '-95.768934' ,`PhotoCount` = '6' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '310726.00' ,`Status` = 'Active' ,`StreetName` = 'Carnation' ,`StreetNumber` = '25456' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1894' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S711000 - Magnolia Springs 01, BLOCK 7, Lot 48' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Springs' ,`TaxAmount` = '' ,`TaxRate` = '3.1' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347634' WHERE `Matrix_Unique_ID` = '210641985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:43:07.553' ,`MLSNumber` = '12568467' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292228' ,`Longitude` = '-95.765557' ,`PhotoCount` = '13' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '325460.00' ,`Status` = 'Active' ,`StreetName` = 'Pomegranate' ,`StreetNumber` = '25266' ,`StreetSuffix` = 'Place' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S711000 - Magnolia Springs 01, BLOCK 7, Lot 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Springs' ,`TaxAmount` = '' ,`TaxRate` = '3.1' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347635' WHERE `Matrix_Unique_ID` = '210643334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:42:48.740' ,`MLSNumber` = '83065395' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.291628' ,`Longitude` = '-95.769936' ,`PhotoCount` = '12' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '266952.00' ,`Status` = 'Active' ,`StreetName` = 'Carnation' ,`StreetNumber` = '25460' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S711000 - Magnolia Springs 01, BLOCK 7, Lot 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Springs' ,`TaxAmount` = '' ,`TaxRate` = '3.1' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347635' WHERE `Matrix_Unique_ID` = '210644188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T12:00:51.863' ,`MLSNumber` = '94094302' ,`ListAgentFullName` = 'Will Clark' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.188853' ,`Longitude` = '-95.427888' ,`PhotoCount` = '27' ,`PostalCode` = '77515' ,`RoomCount` = '8' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Greystone' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2755' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Need a 4-3.5 with lots of space ? Kitchen with island/breakfast bar opens to dining area & family room . Primary bedroom and study are downstairs. There is a 1/2 bathroom off the utility room downstairs. Upstairs boost 3 bedrooms, 2 baths and a large game room. The 4th bedroom has its own private bathroom. Home has a privacy fence.' ,`Acres` = '0.1928' ,`Area` = '5' ,`BuilderName` = 'Heritage Custom Home' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Greystone SD Blk 1 Lot 19' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Greystone Subdivosion' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347636' WHERE `Matrix_Unique_ID` = '210688660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:56:50.227' ,`MLSNumber` = '50163013' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.332858' ,`Longitude` = '-95.296643' ,`PhotoCount` = '7' ,`PostalCode` = '77306' ,`RoomCount` = '5' ,`ListPrice` = '262841.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Crest' ,`StreetNumber` = '17616' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S345900 - Cedar Crossing 01, BLOCK 2, Lot 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding 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` = '1.9' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347636' WHERE `Matrix_Unique_ID` = '210710437' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:56:30.230' ,`MLSNumber` = '69016056' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.332907' ,`Longitude` = '-95.297953' ,`PhotoCount` = '7' ,`PostalCode` = '77306' ,`RoomCount` = '6' ,`ListPrice` = '303857.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Place' ,`StreetNumber` = '2331' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S345900 - Cedar Crossing 01, BLOCK 5, Lot 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding 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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Crossing' ,`TaxAmount` = '' ,`TaxRate` = '1.9' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347637' WHERE `Matrix_Unique_ID` = '210712023' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:38:39.130' ,`MLSNumber` = '56658434' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.144316' ,`Longitude` = '-94.895061' ,`PhotoCount` = '8' ,`PostalCode` = '77535' ,`RoomCount` = '7' ,`ListPrice` = '413681.00' ,`Status` = 'Active' ,`StreetName` = 'Road 66111' ,`StreetNumber` = '193' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.699' ,`Area` = '52' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 2, BLOCK 4, LOT 4, ACRES 0.6990' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30448' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Encino Estates' ,`TaxAmount` = '618' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347637' WHERE `Matrix_Unique_ID` = '210714962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T11:36:51.573' ,`MLSNumber` = '93111920' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140284' ,`Longitude` = '-94.879249' ,`PhotoCount` = '7' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '383206.00' ,`Status` = 'Active' ,`StreetName` = 'Road 6616' ,`StreetNumber` = '404' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.705' ,`Ar