Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:34:16.753' ,`MLSNumber` = '62421712' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805318' ,`Longitude` = '-94.905096' ,`PhotoCount` = '21' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '370990.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Wind' ,`StreetNumber` = '7803' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous plan greets you with three spacious bedrooms with walk-in closets and two full bathrooms. Down the hall lies the large family room, formal dining room, and huge kitchen. Privacy is no worry when it comes to the master bedroom and bath at the back of the home adjacent to the secluded home office.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 2, Section 1' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '9797' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lynnwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702166' WHERE `Matrix_Unique_ID` = '195960267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:34:38.310' ,`MLSNumber` = '66742550' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804977' ,`Longitude` = '-94.908903' ,`PhotoCount` = '14' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '285990.00' ,`Status` = 'Active' ,`StreetName` = 'Brooks Crossing' ,`StreetNumber` = '8002' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The unique Sabine plan boasts three bedrooms with walk-in closets, two bathrooms & a private study!\r\nYour dream home awaits in this family-oriented community of Lynnwood. Conveniently located right off HWY 146, Lynnwood provides an ideal commute time by granting quick access to I-10 and Grand Parkway, while offering a small-town feel. Local attractions are only minutes away including shopping, restaurants and many outside recreational options. Groose Creek ISD.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 1, Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5733' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Lynnwood' ,`TaxAmount` = '' ,`TaxRate` = '3.0568' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702167' WHERE `Matrix_Unique_ID` = '200670672' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:29:52.853' ,`MLSNumber` = '37958833' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826341' ,`Longitude` = '-94.992887' ,`PhotoCount` = '20' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '330990.00' ,`Status` = 'Active' ,`StreetName` = 'Painted Bunting' ,`StreetNumber` = '4430' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenwood features three bedrooms, three bathrooms, and a massive family room for entertaining!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 43, Block 1, Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6833' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702167' WHERE `Matrix_Unique_ID` = '202486346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:52:31.060' ,`MLSNumber` = '67037521' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '26.157462' ,`Longitude` = '-98.015370' ,`PhotoCount` = '31' ,`PostalCode` = '78596' ,`RoomCount` = '3' ,`ListPrice` = '164999.00' ,`Status` = 'Active' ,`StreetName` = 'Coast' ,`StreetNumber` = '2505' ,`StreetSuffix` = 'Drive' ,`City` = 'Weslaco' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous property waiting for you to call it home! You will love the nice backyard, the cute kitchen area, large windows throughout and the easy access to US-83. This home sits in a lovely neighborhood that is close to many shops and eateries. With so much to see and do, it\'s the perfect home for you and your family. The property currently features new interior paint, a new water heater, as well as an upgraded kitchen with a new vent hood and upgraded bathrooms with new vanities and light fixtures. Give us a call to schedule your personal viewing!' ,`Acres` = '0.1383' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TESORO ESTATES PH 3 LOT 78' ,`LotDesciption` = 'Other' ,`LotSize` = '6024' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1019 - Weslaco' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (WESLACO)' ,`SchoolHigh` = 'WESLACO HIGH SCHOOL' ,`SchoolMiddle` = 'CENTRAL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tesoro Estates Ph 3' ,`TaxAmount` = '2377' ,`TaxRate` = '1.9371' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702167' WHERE `Matrix_Unique_ID` = '202502649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:14:09.113' ,`MLSNumber` = '33521171' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.020143' ,`Longitude` = '-95.416002' ,`PhotoCount` = '28' ,`PostalCode` = '77073' ,`RoomCount` = '5' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Queenbury Hills' ,`StreetNumber` = '22354' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1085' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 IMPERIAL GARDEN SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Garden Sec 03' ,`TaxAmount` = '4319' ,`TaxRate` = '2.7904' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702167' WHERE `Matrix_Unique_ID` = '204095000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:20:47.043' ,`MLSNumber` = '16285325' ,`ListAgentFullName` = 'Dalene Zender' ,`ListOfficeName` = 'Zen Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.698912' ,`Longitude` = '-95.546174' ,`PhotoCount` = '32' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '110000.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore' ,`StreetNumber` = '2403' ,`StreetSuffix` = 'Avenue' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nicely updated two bedroom, two bathroom home located near Sam Houston State University. Recent renovations include new flooring and fresh paint throughout. Open concept living, kitchen and dining area. Split bedroom arrangement. Wood-burning fireplace. Master bathroom has separate shower and tub and double sinks. Fenced yard and storage building.' ,`Acres` = '0.2545' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DAVIDS E SURVEY, 17.01 LT 17, MH LABEL# HWC027742' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702167' WHERE `Matrix_Unique_ID` = '205414730' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:01:55.343' ,`MLSNumber` = '45031634' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536106' ,`Longitude` = '-95.487664' ,`PhotoCount` = '28' ,`PostalCode` = '77545' ,`RoomCount` = '8' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Emory Knoll' ,`StreetNumber` = '2319' ,`StreetSuffix` = 'Drive' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1012' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WINFIELD LAKES SEC 3, BLOCK 1, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4407' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Winfield Lakes Sec 3' ,`TaxAmount` = '3510' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702167' WHERE `Matrix_Unique_ID` = '207116865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:35:02.473' ,`MLSNumber` = '37527014' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804977' ,`Longitude` = '-94.908903' ,`PhotoCount` = '16' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '280990.00' ,`Status` = 'Active' ,`StreetName` = 'Brooks Crossing' ,`StreetNumber` = '8018' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The gorgeous Sabine floor plan is a one-story home with an ideal layout that will suit most any lifestyle. Entering this lovely home, you are met with the second and third bedrooms, each boasting convenient walk-in closets, as well as entry to the full secondary bath residing right beside the third bedroom. Also at the front of the home is the entrance to your two-car garage. If you are needing more space to store tools or holiday decorations, opt to include an extra five feet, making it a two-and-a-half-car garage. Down the hall lies the massive family room, formal dining room, and the huge kitchen - this entire living area is perfect for hosting dinner parties and family gatherings of any size!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 1, Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5721' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lynnwood' ,`TaxAmount` = '' ,`TaxRate` = '3.06' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702167' WHERE `Matrix_Unique_ID` = '207652528' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:29:01.830' ,`MLSNumber` = '18387263' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825299' ,`Longitude` = '-94.989199' ,`PhotoCount` = '18' ,`PostalCode` = '77521' ,`RoomCount` = '10' ,`ListPrice` = '380990.00' ,`Status` = 'Active' ,`StreetName` = 'Ruddy Duck' ,`StreetNumber` = '8711' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The captivating Hayden plan has four bedrooms, two-and a half bathrooms & both a gameroom and media!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 6, Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6733' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702168' WHERE `Matrix_Unique_ID` = '208187879' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T16:23:40.620' ,`MLSNumber` = '46612420' ,`ListAgentFullName` = 'Juan Barajas' ,`ListOfficeName` = 'Ponce Realty & Investments' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704456' ,`Longitude` = '-95.191218' ,`PhotoCount` = '16' ,`PostalCode` = '77506' ,`RoomCount` = '5' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Cowan' ,`StreetNumber` = '703' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity!!! Handyman special!! Per the seller the house is 1100 SF & has 3 bdrms per seller. Rm size are approx. Verify. The garage has been converted to 1 Bed, Kitchen and 1 Bath and does also have its own access.(Little apartment on the back)' ,`Acres` = '0.1578' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 15 PASADENA GARDENS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'RED BLUFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PASADENA HIGH SCHOOL' ,`SchoolMiddle` = 'SANJACINTO INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pasadena Gardens' ,`TaxAmount` = '3366' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1944' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702168' WHERE `Matrix_Unique_ID` = '208249253' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:37:59.653' ,`MLSNumber` = '82428961' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895786' ,`Longitude` = '-95.074217' ,`PhotoCount` = '17' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '310990.00' ,`Status` = 'Active' ,`StreetName` = 'Alaska Cedar' ,`StreetNumber` = '530' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Greeley Floorplan features high ceilings, Covered back Patio, open Concept and large Master bedroom. July completion.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6716' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.6256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702168' WHERE `Matrix_Unique_ID` = '208645775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:38:25.750' ,`MLSNumber` = '59737233' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895942' ,`Longitude` = '-95.073908' ,`PhotoCount` = '15' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '328990.00' ,`Status` = 'Active' ,`StreetName` = 'Alaska Cedar' ,`StreetNumber` = '522' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous CastleRock \"Creede\" 1 story home with 4 bedrooms. Covered patio, granite countertops in the kitchen, 42\" cabinets, High ceilings, large island in the kitchen and vinyl plank flooring. July Completion' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6817' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.6256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702168' WHERE `Matrix_Unique_ID` = '208646895' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:25:18.163' ,`MLSNumber` = '2415954' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821451' ,`Longitude` = '-94.988782' ,`PhotoCount` = '20' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '380990.00' ,`Status` = 'Active' ,`StreetName` = 'Seaside Sparrow' ,`StreetNumber` = '4803' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The popular Rio Grande boasts four bedrooms, two-and a half bathrooms & an upstairs gameroom!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8269' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702168' WHERE `Matrix_Unique_ID` = '208679798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:29:34.243' ,`MLSNumber` = '3153514' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824941' ,`Longitude` = '-94.992153' ,`PhotoCount` = '20' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '355990.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Lake' ,`StreetNumber` = '8811' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The popular Rio Grande boasts four bedrooms, two-and a half bathrooms & an upstairs gameroom!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 33, Block 1, Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6249' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702168' WHERE `Matrix_Unique_ID` = '208680368' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:24:31.927' ,`MLSNumber` = '62898332' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823220' ,`Longitude` = '-94.989850' ,`PhotoCount` = '22' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '400990.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Lake' ,`StreetNumber` = '4615' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The well-designed Yuma plan includes four bedrooms, three bathrooms, and an upstairs gameroom!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6368' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702168' WHERE `Matrix_Unique_ID` = '208698165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:27:19.823' ,`MLSNumber` = '58854532' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824270' ,`Longitude` = '-94.991590' ,`PhotoCount` = '22' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '400990.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Lake' ,`StreetNumber` = '8714' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The well-designed Yuma plan includes four bedrooms, three bathrooms, and an upstairs gameroom!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 3, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7128' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702168' WHERE `Matrix_Unique_ID` = '208698685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:30:09.500' ,`MLSNumber` = '83045524' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825050' ,`Longitude` = '-94.992020' ,`PhotoCount` = '15' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '311285.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Lake' ,`StreetNumber` = '8810' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Creede plan consists of three bedrooms, two full attached bathrooms, and a massive family room!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 2, Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6925' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702169' WHERE `Matrix_Unique_ID` = '208699932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:24:10.820' ,`MLSNumber` = '37382081' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823230' ,`Longitude` = '-94.989850' ,`PhotoCount` = '17' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '330990.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Lake' ,`StreetNumber` = '4611' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The attractive Greeley plan presents three bedrooms with large walk-in closets & two full bathrooms!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6387' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702169' WHERE `Matrix_Unique_ID` = '208701279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:28:38.133' ,`MLSNumber` = '59039339' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825177' ,`Longitude` = '-94.990329' ,`PhotoCount` = '17' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '350990.00' ,`Status` = 'Active' ,`StreetName` = 'Goldeneye' ,`StreetNumber` = '4610' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The attractive Greeley plan presents three bedrooms with large walk-in closets & two full bathrooms!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 6, Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7798' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702169' WHERE `Matrix_Unique_ID` = '208701800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:27:49.807' ,`MLSNumber` = '36579644' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824030' ,`Longitude` = '-94.991460' ,`PhotoCount` = '23' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '420990.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Lake' ,`StreetNumber` = '8706' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2697' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The San Marcos home includes four large bedrooms, two-and a half bathrooms & an upstairs gameroom!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 3, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6359' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702169' WHERE `Matrix_Unique_ID` = '208739450' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:25:00.723' ,`MLSNumber` = '55600986' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823010' ,`Longitude` = '-94.989210' ,`PhotoCount` = '16' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '390990.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Lake' ,`StreetNumber` = '4711' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenwood features four bedrooms, two bathrooms, and a massive family room for entertaining!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6824' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702169' WHERE `Matrix_Unique_ID` = '208740329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:25:30.347' ,`MLSNumber` = '76863554' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824410' ,`Longitude` = '-94.991660' ,`PhotoCount` = '21' ,`PostalCode` = '77521' ,`RoomCount` = '10' ,`ListPrice` = '425990.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Lake' ,`StreetNumber` = '8718' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Silverthorne plan boasts four large bedrooms, two-and a half bathrooms, a covered patio & more!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 3, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9120' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702169' WHERE `Matrix_Unique_ID` = '208741833' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:23:03.693' ,`MLSNumber` = '17558667' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821398' ,`Longitude` = '-94.989475' ,`PhotoCount` = '19' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '325990.00' ,`Status` = 'Active' ,`StreetName` = 'Seaside Sparrow' ,`StreetNumber` = '4711' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The unique Sabine plan boasts three bedrooms with walk-in closets, two bathrooms & a private study!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 1, Section 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7880' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702169' WHERE `Matrix_Unique_ID` = '208742768' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:43:14.610' ,`MLSNumber` = '16466891' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040212' ,`Longitude` = '-94.111264' ,`PhotoCount` = '15' ,`PostalCode` = '77705' ,`RoomCount` = '3' ,`ListPrice` = '242999.00' ,`Status` = 'Active' ,`StreetName` = 'Dauphine' ,`StreetNumber` = '2675' ,`StreetSuffix` = 'Place' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom and 2 bathroom brick home! Features iron fence, back yard deck area, custom tiled bath tubs, and wood panel walls throughout living areas. This is the perfect starter home for your and your family. Give us a call today for more information!' ,`Acres` = '0.2755' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'VIRGINIA ESTATES L3 & E40\' L2 BLK E' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`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 Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Virginia Estates' ,`TaxAmount` = '3244' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702170' WHERE `Matrix_Unique_ID` = '209244706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:34:49.590' ,`MLSNumber` = '35051360' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808474' ,`Longitude` = '-94.909331' ,`PhotoCount` = '16' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '325990.00' ,`Status` = 'Active' ,`StreetName` = 'Brooks Crossing' ,`StreetNumber` = '8014' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Blanco is a gorgeous home featuring four bedrooms, two-and a half bathrooms, and a gameroom!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 1, Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lynnwood' ,`TaxAmount` = '' ,`TaxRate` = '3.06' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702170' WHERE `Matrix_Unique_ID` = '209249347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T16:28:23.410' ,`MLSNumber` = '16988684' ,`ListAgentFullName` = 'Rafael Perez' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344427' ,`Longitude` = '-95.393387' ,`PhotoCount` = '34' ,`PostalCode` = '77303' ,`RoomCount` = '5' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Long Tree' ,`StreetNumber` = '11791' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The property has 2 lots for a total of 1.37 Acres home is 2017, plenty of room to expand. The home has front carport and back patio that extends across the back. Property is fully fenced with 2 gated entrances and a work shed in the back of the property. One of the lots is not built, area is unrestricted.' ,`Acres` = '1.37' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S357002 - CRYSTAL CREEK 02, BLOCK 13, LOT 19, IMP ONLY' ,`LotDesciption` = 'Other' ,`LotSize` = '59677' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Crystal Creek 02' ,`TaxAmount` = '1500' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702170' WHERE `Matrix_Unique_ID` = '210190892' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T16:42:29.183' ,`MLSNumber` = '47218512' ,`ListAgentFullName` = 'Jack McLemore' ,`ListOfficeName` = 'Listing Results, LLC' ,`SellingAgentFullName` = 'Caisido Dodson' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.139764' ,`Longitude` = '-95.381993' ,`PhotoCount` = '50' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '485999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Timber Bend' ,`StreetNumber` = '31090' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2-story Traditional home situated on an oversized cul-de-sac lot in North Houston\'s Master Planned Community of the Falls at Imperial Oaks. This open-concept 4 bedroom, 3 bath boasts high ceilings in the living room, media room, office with built-ins, game room, covered outdoor patio with extension, 2.5 car garage with epoxy flooring, utility sink, and so much more. Lots of upgrades including a gourmet kitchen with granite counters, 42\" cabinets, and stainless appliances. There is also a whole house water softener included! Enjoy private access to multiple swimming pools, basketball, tennis courts, playgrounds, soccer fields, & dog park. Nearby, the YMCA is situated on a 100+ acre Lake offering, canoeing, catch & release fishing, wildlife & miles of shaded jogging trails. Minutes to The Woodlands, I-45, Grand Parkway, Hardy, Market Street & Downtown via the Grand Parkway. Shopping, theater, and fine dining are all nearby. MUST SEE!!' ,`Acres` = '0.2758' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S504218 - FALLS AT IMPERIAL OAKS 18, BLOCK 1, LOT 27' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks 18' ,`TaxAmount` = '11092' ,`TaxRate` = '3.0687' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702170' WHERE `Matrix_Unique_ID` = '210296425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T16:32:52.143' ,`MLSNumber` = '2430837' ,`ListAgentFullName` = 'Robert Reyes' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800071' ,`Longitude` = '-95.376023' ,`PhotoCount` = '25' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado' ,`StreetNumber` = '910' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 910 Coronado St. This home was originally built in 1981, and completely remodeled in 2009.\r\nCentrally located in beautiful Houston Heights in the highly desired Brook Smith Subdivision. This beautiful 3/1 was previously used as a rental and can easily be converted into your dream home! Lots of new construction throughout the neighborhood. Close proximity to highly rated Houston bars & restaurants. Easy access to I-45 & 610, Downtown and Med Center.' ,`Acres` = '0.0574' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 6A BLK 91 BROOKE SMITH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brooke Smith' ,`TaxAmount` = '5166' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702170' WHERE `Matrix_Unique_ID` = '211051820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T16:26:46.770' ,`MLSNumber` = '70133047' ,`ListAgentFullName` = 'Loren Miner' ,`ListOfficeName` = 'Eastwood Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755950' ,`Longitude` = '-95.331165' ,`PhotoCount` = '10' ,`PostalCode` = '77003' ,`RoomCount` = '1' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Milby' ,`StreetNumber` = '601' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Corner lot in the ever desirable east end. This property is a 2,400 sqft church on a corner lot, which has been converted to a residential house. The condition of home is either full rehab or tear down. Currently tenant occupied with dogs. Tennant is paying $1,600/month, no showings without pre-approval or proof funds or contract. This will property will not qualify for traditional lending but is a great opportunity for several types of buyers. 1) Covered land play. Buy today, enjoy rent, and redevelop later. 2) BRRR, renovate the property in two units, rent each separately & refinance 3) Renovate for resale. 4) Renovate to make your own 2,400sqft dream home. Rare to have homes of that size. The location is highlighted by walkable to East River project, new nine-hole golf course, bayou trails, navigation blvd restaurants, and easily accessible by I-10 Freeway. The adjacent lot is being marketed separately for $200,000 but can be purchased together.' ,`Acres` = '0.108471' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 6 MERKELS SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Merkels Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702170' WHERE `Matrix_Unique_ID` = '211630956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:02:01.177' ,`MLSNumber` = '49682156' ,`ListAgentFullName` = 'Nikola Knezevic' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.285058' ,`Longitude` = '-95.065044' ,`PhotoCount` = '16' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3311' ,`StreetNumber` = '975' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CORNER LOT ON NEARLEY HALF AN ACRE...Great mobile home with an open concept kitchen/dining room...Spacious bedrooms with a large living area...Beautiful primary bathroom with standing shower and separate soaking tub...This home is READY FOR YOU!' ,`Acres` = '0.4997' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WINDWOOD, BLOCK 6, LOT 12, ACRES .4997' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21767' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windwood' ,`TaxAmount` = '720' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702170' WHERE `Matrix_Unique_ID` = '211681591' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T16:31:47.263' ,`MLSNumber` = '23140785' ,`ListAgentFullName` = 'Tina Hodde' ,`ListOfficeName` = 'Brenham Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.176564' ,`Longitude` = '-96.445307' ,`PhotoCount` = '26' ,`PostalCode` = '77833' ,`RoomCount` = '3' ,`ListPrice` = '643500.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Valley LN' ,`StreetNumber` = '3370' ,`StreetSuffix` = 'Lane' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Discover upscale living and immaculate interiors as you enter this “Beautiful Executive Style Home”! This one story home offers, “Soaring Ceilings, Lots of Light and Walls of Glass over looking a crystal clear blue swimming pool, 3 bedrooms, 2.5 baths and an office/study or flex room. The gourmet kitchen offers granite countertops, a large island, smooth top electric cooktop that is also plumbed for gas, Built-in Microwave and Wall Oven, stainless steel sink and pantry. The Principle Bdrm is spacious with trayed ceiling, lots of windows, a large walk through closet, Master closet is huge, Principal Bath offers, Double Vanities, jetted Soaking Tub and Walk-in Shower. Two guest bedrooms share a full bath, while the flex room shares a half bath. EXTRAS AND UPGRADES: Built-in Bookshelves in Family Room, Outdoor pool and Gazebo….. Kitchen with Granite Counter Tops, 2 Car Attached Garage, alarm.\r\n Seller Needs 1 Hour Showing Notice!!! Text Tina Hodde Agent listing for showing instructions!' ,`Acres` = '1.057' ,`Area` = '58' ,`BuilderName` = 'Union Hill Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S5032 - ROLLING RIDGE ESTATES, LOT 1, ACRES 1.057' ,`LotDesciption` = 'Corner' ,`LotSize` = '45999' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rolling Ridge Estates' ,`TaxAmount` = '7321' ,`TaxRate` = '1.5429' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702171' WHERE `Matrix_Unique_ID` = '211704518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T16:04:39.187' ,`MLSNumber` = '40620163' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675005' ,`Longitude` = '-95.331799' ,`PhotoCount` = '17' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '179999.00' ,`Status` = 'Active' ,`StreetName` = 'Southwind' ,`StreetNumber` = '5911' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'South Houston home consisting of 3 bedrooms and 1.5 bathrooms features foundation repairs and a new roof. It features new interior/exterior paint, new interior lighting, and cosmetic repairs! This location has plenty of schools, shops and eateries that are easily accessible. Only 20 minutes away from Hobby Airport for your traveling needs and quick access to 610 loop. Contact us today for more information!' ,`Acres` = '0.1523' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 40 SOUTHCREST SEC 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6634' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALCOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southcrest Sec 05' ,`TaxAmount` = '2050' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702171' WHERE `Matrix_Unique_ID` = '211741307' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T16:34:20.093' ,`MLSNumber` = '60031445' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835325' ,`Longitude` = '-95.772946' ,`PhotoCount` = '22' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '422490.00' ,`Status` = 'Active' ,`StreetName` = 'San Leo' ,`StreetNumber` = '4211' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW MODERN DESIGN! This beautiful one story home on a cul-da-sac street features an open concept with luxurious finishes and attention to detail! The island kitchen features an abundance of cabinet space, under cabinet lighting, stainless steel built-in appliances & quartz countertops! Beautiful hard surface flooring! The primary bath has quartz counter tops, double sinks and a separate shower and tub!! Smart Home Technology, fully landscaped front & back including sprinkler system. Tankless water heater. Garage door opener. Large covered back patio. 16-SEER A/C and SO MUCH MORE!' ,`Acres` = '0.2117' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 3 VENTANA LAKES EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9221' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`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` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702171' WHERE `Matrix_Unique_ID` = '211742737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T16:47:19.820' ,`MLSNumber` = '29934970' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.638789' ,`Longitude` = '-95.336263' ,`PhotoCount` = '14' ,`PostalCode` = '77048' ,`RoomCount` = '4' ,`ListPrice` = '181999.00' ,`Status` = 'Active' ,`StreetName` = 'Elm Tree' ,`StreetNumber` = '5611' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1551' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Crestmont Park! This home has 3 bedrooms and 2 bathrooms. The attached garage has been converted into a room. This home is perfect for all kinds of family activities with it\'s spacious yards and open floor plan. It features new interior/exterior paint, cosmetic repairs and foundation repairs! Give us a call today for more information!' ,`Acres` = '0.1575' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 12 CRESTMONT PARK SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6859' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cresmont Park Sec 01' ,`TaxAmount` = '2540' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702171' WHERE `Matrix_Unique_ID` = '211743389' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T16:54:52.563' ,`MLSNumber` = '89483089' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672020' ,`Longitude` = '-95.369980' ,`PhotoCount` = '9' ,`PostalCode` = '77051' ,`RoomCount` = '3' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Rosemont' ,`StreetNumber` = '3709' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely home has 3 bedrooms,1 bath, wood floors, and a cute front porch for you to enjoy. Easy access to 288 and the Loop-610, just 10 min away from the Medical Center. Recently updated. Features include a gate for privacy, long extended driveway, nice faux wood ceramic flooring when you walk into the house, tile flooring in the kitchen. Contact us today for more information!' ,`Acres` = '0.1098' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 80 SUNNYSIDE PLACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4785' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Place' ,`TaxAmount` = '2156' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702171' WHERE `Matrix_Unique_ID` = '211743996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:55:49.563' ,`MLSNumber` = '87148291' ,`ListAgentFullName` = 'Heidi Tutor' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.754091' ,`Longitude` = '-94.438091' ,`PhotoCount` = '35' ,`PostalCode` = '75979' ,`RoomCount` = '5' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 1020' ,`StreetNumber` = '1171' ,`StreetSuffix` = '' ,`City` = 'Woodville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has been completely renovated from the bathrooms, kitchen, flooring, paint to the fixtures. Once you enter the home through the kitchen you will fall in love. The kitchen has all new cabinets complete with a farm \r\n house sink, new electric convection/air fry oven and lighting. The kitchen is open to the living room so your never away from the action. Both bathrooms give off a spa like effect with walk in showers. The primary bed room has shiplap accent to the walls which makes this room pop. The 3rd bedroom is also large enough for a king size bed. This home sits on 3.581 acres that are fenced and crossed fenced and ready for your 4H project/horse. There is a 40x35 barn with stalls, work shop, and additional loafing shed. Multiple fruit trees have been planted along with other flowering plants. Make sure you look at the huge hard wood trees in the front and back yard. Come take a look at this amazing home you will not want to leave. Call today for your personal showing.' ,`Acres` = '3.581' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0405 E. L. JENNINGS,ACRES 3.581' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '2155' ,`TaxRate` = '2.1287' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702171' WHERE `Matrix_Unique_ID` = '211744375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:08:10.387' ,`MLSNumber` = '1087479' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '8' ,`PostalCode` = '77327' ,`RoomCount` = '1' ,`ListPrice` = '89999.00' ,`Status` = 'Active' ,`StreetName` = 'Road 7000' ,`StreetNumber` = '159' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Handy-man special! Great opportunity for you to finish building a home to call your own made just how you would like it! Almost half an acre of land with easy access to Plum Grove Rd which leads to downtown Cleveland! Give us a call today for more information! As Is.' ,`Acres` = '0.49' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'VILLA NUEVA, BLOCK 2, LOT 10, ACRES .49' ,`LotDesciption` = 'Cleared' ,`LotSize` = '21344' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Villa Nueva' ,`TaxAmount` = '1429' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702171' WHERE `Matrix_Unique_ID` = '211744626' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:17:02.020' ,`MLSNumber` = '81838747' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.281927' ,`Longitude` = '-94.828185' ,`PhotoCount` = '13' ,`PostalCode` = '77327' ,`RoomCount` = '2' ,`ListPrice` = '88999.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Ridge' ,`StreetNumber` = '362' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 bedroom and 1 bathroom mobile home perfect for you and your family! The Preserve offers an outdoor atmosphere with tons of amenities: 4 pools, outdoor pavilion, splash pad, equestrian center, parks, natural lakes, fishing, and much more! Part of the stellar Tarkington School District. Give us a call today for more information!' ,`Acres` = '0.6887' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CYPRESS LAKES, BLOCK 8 UNIT 11, LOT 363-368' ,`LotDesciption` = 'Cleared' ,`LotSize` = '30000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Lakes' ,`TaxAmount` = '359' ,`TaxRate` = '1.5309' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702172' WHERE `Matrix_Unique_ID` = '211744998' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T17:51:08.163' ,`MLSNumber` = '24339366' ,`ListAgentFullName` = 'Jose Delao' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.774561' ,`Longitude` = '-95.112966' ,`PhotoCount` = '20' ,`PostalCode` = '77530' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Hoover Dr' ,`StreetNumber` = '626' ,`StreetSuffix` = 'Street' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never flooded!! Very quiet community, 4 bedrooms, 2 baths, enough space to park up to 20 cars.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '(1972 HENSLEE 14 X 78 HUD# TXS0613046 SERIAL# 472S2253211890' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'DEZAVALA ELEMENTARY SCHOOL (CHANNELVIEW)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'JOHNSON JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lakeside Park Estates' ,`TaxAmount` = '177' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702172' WHERE `Matrix_Unique_ID` = '211746151' --> Updated record success