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-22T16:24:03.410' ,`MLSNumber` = '62213413' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '17' ,`PostalCode` = '77327' ,`RoomCount` = '2' ,`ListPrice` = '109999.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Lakes' ,`StreetNumber` = '5449' ,`StreetSuffix` = 'Circle' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 bedroom and 1 bathroom tiny home available at the Preserve of Texas! Walk into an open concept living/kitchen area with vaulted wood ceilings. Home comes FURNISHED and ready for your family. Huge loft area allows for privacy from the rest of the home. Master bedroom provides great space and a back door for easy access to a deck to enjoy the sunset. Second bedroom is perfect for guests or extended family. Move away from the hustle and bustle of the city and into the tranquility that this established community offers. Plenty of amenities available for property owners including access to the Trinity River with beach area, pools, lakes, splash pad, putt putt course, and so much more. Looking for a home with great schools? We are part of the STELLAR Tarkington School District! What are you waiting for? Give us a call today! Easy seller terms!' ,`Acres` = '0.2697' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'CYPRESS LAKES, BLOCK 3 UNIT 9, LOT 96' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '11749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701789' WHERE `Matrix_Unique_ID` = '179959771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:20:35.390' ,`MLSNumber` = '59466946' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.299771' ,`Longitude` = '-94.801111' ,`PhotoCount` = '24' ,`PostalCode` = '77327' ,`RoomCount` = '2' ,`ListPrice` = '130999.00' ,`Status` = 'Active' ,`StreetName` = 'Inwood' ,`StreetNumber` = '199' ,`StreetSuffix` = 'Street' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy waterfront home in the Preserve of Texas consisting of 2 bedrooms and 1 bathroom. This home features a roof replacement, new front and back stairs railing, new exterior paint, new vinyl flooring in the living room, den, kitchen and bathroom. The property also features new ceiling fans, and new carpet in both bedrooms. The PreserveOfTexas.com offers an outdoor atmosphere with tons of amenities: 4 pools, outdoor pavilion, splash pad, equestrian center, parks, natural lakes, fishing, and much more! We offer owner financing, no credit ok! Give us a call or visit our Houston office for more details!' ,`Acres` = '0.1387' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'CYPRESS LAKES, BLOCK 4 UNIT 4, LOT 68' ,`LotDesciption` = 'Other' ,`LotSize` = '6044' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cypress Lakes' ,`TaxAmount` = '948' ,`TaxRate` = '1.6866' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701789' WHERE `Matrix_Unique_ID` = '184283819' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:01:12.470' ,`MLSNumber` = '54681955' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.556659' ,`Longitude` = '-94.388793' ,`PhotoCount` = '17' ,`PostalCode` = '75670' ,`RoomCount` = '4' ,`ListPrice` = '66999.00' ,`Status` = 'Active' ,`StreetName` = 'Madam Queen' ,`StreetNumber` = '1407' ,`StreetSuffix` = 'Street' ,`City` = 'Marshall' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A cute little home sitting on ALMOST A WHOLE ACRE! An investor special that requires a little bit of work and then it can be your dream home. This home features a wide porch perfect for outdoor lounging and plenty of yard space for all kinds of outdoor activities. Easy access to HWY 390 & HWY 80. Literally minutes away from East Texas Baptist University. A prime location surrounded by many dining and shopping options! AS IS!' ,`Acres` = '0.972' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.972, LOT: 3-6 & 12, BLK: 1, SUBD: HARLEM NORTH 2ND,' ,`LotDesciption` = 'Other' ,`LotSize` = '42340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '99 - Other' ,`SchoolElementary` = 'J H MOORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (MARSHALL)' ,`SchoolMiddle` = 'MARSHALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Harlem North 2nd' ,`TaxAmount` = '594' ,`TaxRate` = '2.157' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701790' WHERE `Matrix_Unique_ID` = '192041006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:17:38.570' ,`MLSNumber` = '7623470' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676189' ,`Longitude` = '-95.278981' ,`PhotoCount` = '17' ,`PostalCode` = '77061' ,`RoomCount` = '4' ,`ListPrice` = '278999.00' ,`Status` = 'Active' ,`StreetName` = 'Dover' ,`StreetNumber` = '8107' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What an opportunity! It\'s the perfect home for someone who is looking for a place to make their own. It features a covered patio as you walk out of the garage to keep your cars out of the Texas heat. New plumbing and electrical installed. The master suite is HUGE! The backyard consists of a covered area perfect for those who enjoy spending time outside. This home has easy access to I-45 off of the busy Bellfort Ave. As Is.' ,`Acres` = '0.2619' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 23 GLENBROOK VALLEY SEC 5 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '11410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARK PLACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'ORTIZ MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Glenbrook Valley Sec 05 R/P' ,`TaxAmount` = '5506' ,`TaxRate` = '2.5494' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701790' WHERE `Matrix_Unique_ID` = '200970376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T17:51:31.403' ,`MLSNumber` = '7305465' ,`ListAgentFullName` = 'Nikki White' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823964' ,`Longitude` = '-95.333287' ,`PhotoCount` = '16' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Corto' ,`StreetNumber` = '3804' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '8 ROOM, 1-STORY, 1-CAR GARAGE/ ENTERTAINING ROOM, 3 BED 1-1/2 BATH, 2 MASTER BEDROOM OPTIONS, BRICK EXTERIOR, LARGE FRONT/BACK YARD WITH DECK IN BACK YARD. CARPETED WITH HARDWOOD AND CERAMIC TILE FLOORS UNDERNEATH CARPET.' ,`Acres` = '0.2328' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 8 WESTCOTT GARDENS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PAIGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westcott Gardens Sec 04' ,`TaxAmount` = '1917' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701790' WHERE `Matrix_Unique_ID` = '206466625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:09:56.260' ,`MLSNumber` = '88489295' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700099' ,`Longitude` = '-95.358038' ,`PhotoCount` = '18' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '229999.00' ,`Status` = 'Active' ,`StreetName` = 'Tolnay' ,`StreetNumber` = '3919' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely home consisting of 4 bedrooms and 1 bathroom in South Houston! Close to Downtown Houston and the Museum District. This property features a large yard, large windows for natural sunlight, fresh interior paint, and cosmetic repairs! This is the perfect place to call home! Call us to schedule your tour today!' ,`Acres` = '0.1412' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 3 SCOTT TERRACE SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Scott Terrace Sec 01' ,`TaxAmount` = '2816' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701790' WHERE `Matrix_Unique_ID` = '206931366' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:09:00.133' ,`MLSNumber` = '87149804' ,`ListAgentFullName` = 'Diane Colby-Honerkamp' ,`ListOfficeName` = 'Realtynet' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.520129' ,`Longitude` = '-95.712986' ,`PhotoCount` = '50' ,`PostalCode` = '77469' ,`RoomCount` = '12' ,`ListPrice` = '999999.00' ,`Status` = 'Active' ,`StreetName` = 'Waterwalk' ,`StreetNumber` = '5810' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '6013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Definitely one of a kind! Elaborate custom home only 35 minutes from the Med center. This unique property is located on a lake & is fenced with over 100 trees on 1.53 acres of land. This home features 2 master suites, 2 fireplaces, new carpet, tile, & wood flooring. Custom woodwork throughout the home features crown molding, a built in China cabinet, desks, & display cabinets in the oversized butler’s pantry. A recreational & entertainment high light in this home is the large indoor pool/spa, waterfall, bar & game room. This home also features an oversized chef’s pantry, huge laundry with built in sink and cabinets with a 2nd washer/dryer setup in the single garage with oversized garage door. Additional features include high ceilings, huge closets, 3 attic stairways & a workshop areas in the oversized garage. The home is appointed with decorative brickwork inside & out with Austin Stone accents. This home can be your own secluded paradise on a cul-de-sac street! Great schools & low tax' ,`Acres` = '1.5771' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRIDLEWOOD ESTATES SEC 1, BLOCK 9, LOT 25, ACRES 1.523' ,`LotDesciption` = 'Cul-De-Sac,Water View,Wooded' ,`LotSize` = '68697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '646' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridlewood Estates' ,`TaxAmount` = '11960' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663701790' WHERE `Matrix_Unique_ID` = '207220985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T17:56:59.243' ,`MLSNumber` = '50353486' ,`ListAgentFullName` = 'Boris Ackerman' ,`ListOfficeName` = 'Texas Advantage Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.232853' ,`Longitude` = '-95.536589' ,`PhotoCount` = '42' ,`PostalCode` = '77384' ,`RoomCount` = '21' ,`ListPrice` = '6500000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Conroe' ,`StreetNumber` = '15589' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '7' ,`BathsHalf` = '1' ,`BedsTotal` = '9' ,`SqFtTotal` = '17589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Mediterranean-style estate offering luxury living on a private, unrestricted 3.4-acre lot. Enjoy the extremely private courtyard pool which includes a beautiful hot tub and an outdoor kitchen. A home built with the finest materials, this home includes 13,491 sqft of travertine floors throughout the inside, outdoor living area, and balcony. This estate boasts 9 bedrooms with en-suite baths, an elevator, mahogany libraries, a media room, a game room, an office, and a safe room. The 29-foot ceilings make for a very open and naturally lighted living area with a beautiful fossil fireplace. This 7-year-old estate also includes a detached 750 square-foot housekeeping home with the finest quarters for your home’s assistance. Expansive balconies throughout the home include outdoor stairs for easy access during outdoor entertainment. This palace-like estate is a must-see for those who enjoy exclusivity and privacy while also valuing the convenience of this centrally located estate.' ,`Acres` = '3.425' ,`Area` = '15' ,`BuilderName` = 'Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S262500 - BIG TREE EST 01, LOT 24-B, ACRES 3.425' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '149193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Big Tree Estate 01' ,`TaxAmount` = '47690' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701790' WHERE `Matrix_Unique_ID` = '207507655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T17:06:16.650' ,`MLSNumber` = '94500311' ,`ListAgentFullName` = 'Cameron Foster' ,`ListOfficeName` = 'Nexus One Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766017' ,`Longitude` = '-95.713279' ,`PhotoCount` = '50' ,`PostalCode` = '77094' ,`RoomCount` = '10' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Green' ,`StreetNumber` = '1519' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live the Life of Luxury in this Estate Home located on an oversized lot. Don\'t you deserve a home that mirrors your achievements? This home combines architecture and craftsmanship in a home that whispers \"success.\" Unmatched quality, and an address that\'s second to none. You must experience this striking entry and grand staircase. Home did not flood! No rear neighbors. Guest Suite over the garage w/full bath. Includes two wet bars, oversized 3 car garage, stunning gourmet island kitchen with granite counter tops, and beautiful hardwood floors. 2 story den w/wall of windows facing covered patio/backyard. Large master suite w/ soaking tub great for relaxing and separate walk in shower! Huge back patio with outdoor kitchen overlooking the pool, full landscaped, sprinklered, and extremely private. This is what success is all about.' ,`Acres` = '0.3644' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 10 GREEN TRAILS SEC 1' ,`LotDesciption` = 'Greenbelt,Ravine,Subdivision Lot' ,`LotSize` = '15874' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'PATTISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Trails' ,`TaxAmount` = '13320' ,`TaxRate` = '2.2423' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701790' WHERE `Matrix_Unique_ID` = '207629843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:56:26.550' ,`MLSNumber` = '36978601' ,`ListAgentFullName` = 'Dana Staples' ,`ListOfficeName` = 'Staples Sotheby\'sInternational' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.770928' ,`Longitude` = '-95.626040' ,`PhotoCount` = '48' ,`PostalCode` = '75801' ,`RoomCount` = '8' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Hodges' ,`StreetNumber` = '601' ,`StreetSuffix` = 'Street' ,`City` = 'Palestine' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '6244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An impeccable example of the grandeur of historical homes of the South is now for sale in historic Palestine Texas! . A generous wrap around porch, massive classical columns and a two\r\nstory pedimented portico grace the Greek Revival style home, with equally significant interior features. Upon entering you will be amazed by the beauty of the grand entry hall with carved staircase, extensive solid wood crown molding, soaring coffered ceilings, wood floors, elegant light fixtures, leaded glass transoms, and floor to ceiling windows. With 7 bedrooms and 3.5 baths plus 3 living areas, a dining area that welcomes dining tables seating 12 +, a large kitchen breakfast area, 3 wood burning fireplaces and so much more, this home has the craftsmanship and quality of materials that are no longer available for new homes. This majestic estate is located on 3.22 wooded and landscaped acres in the hills and trees of East\r\nTexas.' ,`Acres` = '3.2' ,`Area` = '75' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Palestine Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'A0065 Wells Samuel G, Block 867 Tract 6' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '71 - Palestine' ,`SchoolElementary` = '' ,`SchoolHigh` = 'PALESTINE HIGH SCHOOL' ,`SchoolMiddle` = 'PALESTINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'City of Palestine' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1911' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701790' WHERE `Matrix_Unique_ID` = '208828726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:04:01.400' ,`MLSNumber` = '33904053' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.895019' ,`Longitude` = '-98.467764' ,`PhotoCount` = '7' ,`PostalCode` = '76301' ,`RoomCount` = '2' ,`ListPrice` = '36999.00' ,`Status` = 'Active' ,`StreetName` = 'Old Windthorst' ,`StreetNumber` = '1921' ,`StreetSuffix` = 'Road' ,`City` = 'Wichita Falls' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this 2 bedroom, 1 bathroom home in need of TLC to become the home for you! Located in a quiet neighborhood in Wichita Falls. Easy access to Waurika FWY. As Is.' ,`Acres` = '0.163' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1 REPLAT BLK E SOUTH SIDE ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '7100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1036 - Wichita Falls' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (WICHITA FALLS)' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Side Acre' ,`TaxAmount` = '653' ,`TaxRate` = '2.7399' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701791' WHERE `Matrix_Unique_ID` = '209054374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:06:31.360' ,`MLSNumber` = '22297190' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '34.034285' ,`Longitude` = '-98.917140' ,`PhotoCount` = '7' ,`PostalCode` = '76360' ,`RoomCount` = '3' ,`ListPrice` = '26999.00' ,`Status` = 'Active' ,`StreetName` = 'Waggoner' ,`StreetNumber` = '509' ,`StreetSuffix` = 'Street' ,`City` = 'Electra' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1124' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fixer upper home located in Electra, TX. Great opportunity for a handyman! Give us a call today for more information!' ,`Acres` = '0.1607' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOTS 17 & 18 BLK 49 ORIGINAL TOWN, E' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '498 - Electra' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'ELECTRA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Original Town E' ,`TaxAmount` = '627' ,`TaxRate` = '3.0719' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701791' WHERE `Matrix_Unique_ID` = '209298400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:05:22.720' ,`MLSNumber` = '72244662' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '34.025283' ,`Longitude` = '-98.918045' ,`PhotoCount` = '6' ,`PostalCode` = '76360' ,`RoomCount` = '2' ,`ListPrice` = '39999.00' ,`Status` = 'Active' ,`StreetName` = 'Ida' ,`StreetNumber` = '306' ,`StreetSuffix` = 'Avenue' ,`City` = 'Electra' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An awesome investment opportunity! This home comes with 2 bedrooms, 1 bathroom, an attached carport, and plenty of yard space. This home is equipped with plenty of cabinet space, cozy rooms, tile and wood flooring in select areas. Easy access to HWY 25 and HWY 287 and only a few minutes away from Wichita Falls. As-is!' ,`Acres` = '0.1607' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 4 BLK 13 SOUTHLAND ADDITION' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '498 - Electra' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'ELECTRA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southland Add' ,`TaxAmount` = '681' ,`TaxRate` = '3.0719' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701791' WHERE `Matrix_Unique_ID` = '209300209' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T17:59:03.930' ,`MLSNumber` = '6133170' ,`ListAgentFullName` = 'Cody Horn' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.248609' ,`Longitude` = '-95.178142' ,`PhotoCount` = '50' ,`PostalCode` = '77372' ,`RoomCount` = '14' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'West Holly Lane' ,`StreetNumber` = '24844' ,`StreetSuffix` = '' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This custom built home sits on a 1 acre tract in Splendora ISD. It has 4 bedrooms and 3 1/2 baths. Very open concept with tile flooring throughout the 1st floor and carpet on the stairs and room on 2nd floor that can be used for a game room or bedroom. Lots of custom built cabinetry throughout the house with soft closing doors and drawers in the kitchen. Quartz and granite countertops throughout the home. Mud room/utility room has custom built in cabinetry and easy access to the garage and kitchen area. Large oversized garage that is 25x25 with a separate area off to the side that is roughly 10x12. Exterior walls of the home are 2x6 construction instead of the normal 2x4. Covered front and back porches with tongue and groove ceiling. This property is not located in the flood plain.' ,`Acres` = '1' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S780001 - PEACH CK EST 01, BLOCK 19-D, ACRES 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PINEY WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Peach Ck Estate 01' ,`TaxAmount` = '374' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663701791' WHERE `Matrix_Unique_ID` = '209413598' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:35:57.747' ,`MLSNumber` = '6940130' ,`ListAgentFullName` = 'Tony Foster' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956805' ,`Longitude` = '-95.731266' ,`PhotoCount` = '40' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '413900.00' ,`Status` = 'Active' ,`StreetName` = 'Raven Shore' ,`StreetNumber` = '12302' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2284' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'How would you like to own this lovely home on a large, oversized lot in the desirable Lakeland Village of Bridgeland? Great curb appeal with open front porch leading from the separate pathway and nestled in a cul-de-sac. Kitchen with RO filter system opens to the living area with plenty of countertop space and a large island. Wired ethernet/cable to every room and built-in surround sound. 3 good sized bedrooms and office for working from home plus a bonus game room. Custom built-ins throughout for much needed storage. Covered patio in the pool-sized backyard which backs up to a hiking/biking trail. New roof and water softener in 2021, and newly painted interior in 2022. Spacious decked attic space above entire garage. With over 250 miles of trails, numerous parks and playgrounds, leisure pools and heated lap pools open year-round, this community has something to offer everyone. Zoned to Bridgeland High School in the highly acclaimed Cy-Fair ISD. Book your private showing now!!' ,`Acres` = '0.2817' ,`Area` = '25' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 BLK 4 SHORES SEC 1 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '12271' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1255' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POPE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '8810' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701791' WHERE `Matrix_Unique_ID` = '209643733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:44:41.077' ,`MLSNumber` = '75409378' ,`ListAgentFullName` = 'Kimberlea Story' ,`ListOfficeName` = 'Story Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.786708' ,`Longitude` = '-96.458778' ,`PhotoCount` = '42' ,`PostalCode` = '76693' ,`RoomCount` = '7' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue C' ,`StreetNumber` = '108' ,`StreetSuffix` = '' ,`City` = 'Wortham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1865' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wortham Texas! Nice farm house on a large lot in Wortham Texas! Just minutes from downtown this home is ready for the kiddos and animals. 2-3 bedrooms, 2 bath, 3 car carport detached. Fenced for your animals and includes a chicken coop and a storage bldg. This home features an Eatin kitchen, tall ceilings, a large family room with a metal wood burning stove, and a dining room. Central air and heat is 2 +- years old. Home was replumbed 3 yrs ago with new pex pipe. New Sears windows installed on entire home, April 2022. 16 new windows per seller. Covered back porch and trim was newly painted August 2022. New roof and new hardi board siding were installed 5+- years old. A bonus is the underground storm cellar. The large yard will keep the kiddos busy for hours.' ,`Acres` = '0.496' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding,Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OTS WORTHAM PT LOT 10 DIV 13' ,`LotDesciption` = 'Other' ,`LotSize` = '21606' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1048 - Wortham' ,`SchoolElementary` = 'WORTHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHAM HIGH SCHOOL' ,`SchoolMiddle` = 'WORTHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sub Div' ,`TaxAmount` = '1705' ,`TaxRate` = '2.292' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701791' WHERE `Matrix_Unique_ID` = '210302858' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:58:28.960' ,`MLSNumber` = '14895652' ,`ListAgentFullName` = 'Marjorie Lucero' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724512' ,`Longitude` = '-95.793654' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumnwind' ,`StreetNumber` = '25510' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Village Builders \'\'Valencia\'\' floorplan. Over 3000 sqft 1 story in Cinco Ranch on culdesac st, w/4 bdrms, 3 full baths, 3 car garage,gameroom, covered patio w/a great size bkyd,& 4 sides brick. Kitchen is the heart of this home w/large gas cooktop island, stainless appliances, double ovens, built in microwave & Fridge,&planning station. Oversize master has beautiful views of the backyard, bath has oversize shower w/seat, whirlpool tub, sep sinks & vanity area. Zoned with the best rated schools in Katy ISD. Recently painted from top to bottom.New A/C/Furnace units and new roof.' ,`Acres` = '0.2086' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH WEST SEC 17, BLOCK 4, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9086' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Built Up' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GRIFFIN ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch West Sec 17' ,`TaxAmount` = '10690' ,`TaxRate` = '2.6245' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701791' WHERE `Matrix_Unique_ID` = '210344835' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:55:54.460' ,`MLSNumber` = '53573571' ,`ListAgentFullName` = 'Elissa Campbell' ,`ListOfficeName` = 'Lucid Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.479501' ,`Longitude` = '-94.942078' ,`PhotoCount` = '28' ,`PostalCode` = '77539' ,`RoomCount` = '5' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = '23rd' ,`StreetNumber` = '1327' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy a priceless open water view from your own waterfront home. Pull your boat right up to your boathouse and relax. Take a dip in your pool all while still enjoying the amazing view. This recently updated home is the perfect place to call home. The bottom floor has been fully remodeled with new bathrooms and a full kitchen, the doors can be opened up to enjoy the sea breeze. The top floor has been updated as well, a gorgeous kitchen, beautiful floors and remodeled bathrooms. You wont want to miss this opportunity. Come see it today.' ,`Acres` = '0.165' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 10 A EDWARDS SUR LOT 27 & PT ADJ CANAL EDWARDS LANDING' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '7187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Edwards Landing' ,`TaxAmount` = '6686' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701792' WHERE `Matrix_Unique_ID` = '210535826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:08:56.950' ,`MLSNumber` = '56177689' ,`ListAgentFullName` = 'Toni Awadin' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669451' ,`Longitude` = '-95.432131' ,`PhotoCount` = '32' ,`PostalCode` = '77025' ,`RoomCount` = '6' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Clearview Villa' ,`StreetNumber` = '3446' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your Dream Home Awaits! Located in a gated community with easy access to major highways for abundant commute routes. Short driving distance to the Medical Center and Downtown. With lots of natural light this stunning home features 3 stories, 3 bedrooms, 3.5 baths, and an attached 2-car garage. The kitchen comes with stained cabinetry with Quartz countertops, stainless-steel appliances and room for bar seating. The living room leads out to a relaxing balcony which is perfect for entertaining. The primary bedroom is located on the third floor and offers fully renovated bathroom with dual sinks, relaxing soaking tub plus a convenient separate shower. Renovated bathrooms, kitchen, and laminate flooring done in 2020. The backyard offers ample space & patio. Water included with HOA. Never flooded per the seller. Washer, Dryer & Refrigerator included. You don\'t want to miss all this home has to offer. Check out the listing pictures for more details.' ,`Acres` = '0.0405' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 VILLAS ON CLEARVIEW AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1764' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1693' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Villas/Clearview' ,`TaxAmount` = '6721' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701792' WHERE `Matrix_Unique_ID` = '210695587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:03:05.197' ,`MLSNumber` = '56970120' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842571' ,`Longitude` = '-94.828120' ,`PhotoCount` = '6' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakmont' ,`StreetNumber` = '7314' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW CONSTRUCTION by Lennar Homes, Wildflower Collection \'\'Lantana II\" Brick/Stone Elevation \"C\" in South Lakes! Providing an excellent layout for families, this single-level home has an airy design that’s shared by the kitchen, nook and family room. A covered patio invites outdoor living, while a formal dining room and two secondary bedrooms add flexibility. The owner’s suite enjoys privacy, nestled in a back corner location. \r\n*HOME ESTIMATED TO BE COMPLETE, November, 2022*' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 004 LOT 008' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.309' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701792' WHERE `Matrix_Unique_ID` = '211428251' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:08:22.633' ,`MLSNumber` = '71616779' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698115' ,`Longitude` = '-95.349362' ,`PhotoCount` = '17' ,`PostalCode` = '77021' ,`RoomCount` = '2' ,`ListPrice` = '184999.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsbury' ,`StreetNumber` = '4506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this lovely 2 bedroom, 1+ bathroom home located South of Houston. This home features historic details, hardwood floors, a fireplace, and a laundry room. Easy access to 45 and 610 FWY. 3 miles from Texas Medical center and 4 miles from Houston Zoo. Contact us today for more information!' ,`Acres` = '0.1598' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 6 SOUTHERN VILLAGE SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6961' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Village Sec 01' ,`TaxAmount` = '1728' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701792' WHERE `Matrix_Unique_ID` = '211441848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T17:54:47.490' ,`MLSNumber` = '17084895' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514097' ,`Longitude` = '-95.443496' ,`PhotoCount` = '16' ,`PostalCode` = '77545' ,`RoomCount` = '8' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Lenox Grove' ,`StreetNumber` = '4943' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Lennar Homes Wildflower Collection, \'\'Clover II\'\' Plan Elevation \"A\" in Lakes of Savannah. This single-story home showcases a generous open floorplan shared between the family room, dining room and kitchen, leading directly to a covered patio for seamless indoor-outdoor living. A flex room off the foyer is perfect as a home office or bonus room. Four bedrooms complete this home. *HOME ESTIMATED TO BE COMPLETE, AUGUST, 2022*' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0017 BLK 003 LOT 018' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701792' WHERE `Matrix_Unique_ID` = '211561606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:37:05.820' ,`MLSNumber` = '35074146' ,`ListAgentFullName` = 'Deborah Stepanek' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.776585' ,`Longitude` = '-95.918044' ,`PhotoCount` = '37' ,`PostalCode` = '77831' ,`RoomCount` = '3' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Bracewell' ,`StreetNumber` = '20594' ,`StreetSuffix` = 'Road' ,`City` = 'Bedias' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look Investors if you want a fixer upper. A home on 5 + acres of land with a metal roof, lots of land to have horses on or plant a garden. This is an unrestricted subdivision and there are no HOA dues. Own a piece of Texas. Easy access to the main road, Hardtop road to the property. Great property if you drive an 18 wheeler you can park your truck on the property. In Grimes county less than 30 minutes from Huntsville, 45 minutes to College Station, and 1 hour and 20 minutes from downtown Houston, 55 minutes to Conroe. Do not drive on the property without an appointment. This is an amazing priced property for 5 acres and a home. Property is priced just a little over tax value. The property is in the 100 year flood plain but it has never flooded according to the seller. Seller does not have a survey, Buyers Expense' ,`Acres` = '5.069' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bedias/Roans Prairie Area' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'S4581 - PRIMELAND ESTATES, UNREC SUB, LOT 27-B, ACRES 5.069' ,`LotDesciption` = 'Cleared' ,`LotSize` = '220806' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '175 - Madisonville Consolidated' ,`SchoolElementary` = 'MADISONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MADISONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Primeland Estates Ph 1 Tr #27b' ,`TaxAmount` = '1800' ,`TaxRate` = '1.7056' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701792' WHERE `Matrix_Unique_ID` = '211695444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:42:48.213' ,`MLSNumber` = '44405928' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831093' ,`Longitude` = '-95.804863' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '292990.00' ,`Status` = 'Active' ,`StreetName` = 'Landolfi' ,`StreetNumber` = '24910' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1849' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Camillo Lakes in Katy, TX! The Chestnut plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all, including blinds, upgraded carpet in the bedrooms, and NO BACK NEIGHBORS! The first floor offers the perfect entertainment space with vinyl plank flooring and a large kitchen island overlooking the family and dining rooms! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod, sprinkler system, and covered patio! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 69 BLK 1 CAMILLO LAKES SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '2850' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701792' WHERE `Matrix_Unique_ID` = '211699843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T16:08:31.913' ,`MLSNumber` = '93323540' ,`ListAgentFullName` = 'Daphne Brown' ,`ListOfficeName` = 'Beyond the Home Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836930' ,`Longitude` = '-95.307987' ,`PhotoCount` = '14' ,`PostalCode` = '77016' ,`RoomCount` = '4' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Lanewood' ,`StreetNumber` = '8333' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOtivated Seller- Don\'t miss out on this incredible opportunity to own your own home in TRINITY GARDENS - This cozy home situated on a nice sized lot has been completely rehabbed.' ,`Acres` = '0.1928' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 84 BLK 5 LAURA KOPPE PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Laura Koppe Place' ,`TaxAmount` = '571' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701793' WHERE `Matrix_Unique_ID` = '211699859' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T17:32:13.093' ,`MLSNumber` = '34524343' ,`ListAgentFullName` = 'Gloria Bolanos' ,`ListOfficeName` = 'Houston Homes Legacy Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.008219' ,`Longitude` = '-95.286578' ,`PhotoCount` = '45' ,`PostalCode` = '77338' ,`RoomCount` = '5' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Barred Owl' ,`StreetNumber` = '21807' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect House!!!LOCATED CLOSE TO GEORGE BUSH AIRPORT, SHOPPING AND LOTS MORE.\r\nTHE 1427 FLOOR PLAN IS A COZY, 3 BEDROOM,2 BATHS, 1 STORY HOME WITH LOTS OF CHARM.\r\nTHIS HOME OFFERS A SPLIT FLOOR PLAN WITH AN OPEN FAMILY /KITCHEN/DINING ROOM SPACE. FEATURES INCLUDE WOOD GRAIN VINYL PLANK FLOORING, TWO CAR GARAGE, BLINDS AND FENCE BACKYARD.\r\n\r\nCOME SEE THIs HOME TODAY, IT WILL NOT LAST LONG!!!!!!!!' ,`Acres` = '0.1145' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 ARBOR TRAILS SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4987' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arbor Trls Sec 3' ,`TaxAmount` = '5823' ,`TaxRate` = '2.9808' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701793' WHERE `Matrix_Unique_ID` = '211700752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T17:21:02.733' ,`MLSNumber` = '2974140' ,`ListAgentFullName` = 'Tracie Conyers' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.295882' ,`Longitude` = '-95.275134' ,`PhotoCount` = '8' ,`PostalCode` = '77577' ,`RoomCount` = '4' ,`ListPrice` = '149999.00' ,`Status` = 'Active' ,`StreetName` = '8th' ,`StreetNumber` = '2311' ,`StreetSuffix` = 'Street' ,`City` = 'Liverpool' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment property- Garage has been converted.' ,`Acres` = '0.53' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0006 A H & B TRACT 51D (SD TR 50) ACRES .53 (LIVERPOOL)' ,`LotDesciption` = 'Other' ,`LotSize` = '23087' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'A H & B' ,`TaxAmount` = '3224' ,`TaxRate` = '2.3984' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701793' WHERE `Matrix_Unique_ID` = '211703275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T17:00:49.760' ,`MLSNumber` = '71194717' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831097' ,`Longitude` = '-95.804569' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Landolfi' ,`StreetNumber` = '24862' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1849' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Camillo Lakes in Katy, TX! The Chestnut plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all, including blinds, upgraded carpet in the bedrooms, and NO BACK NEIGHBORS! The first floor offers the perfect entertainment space with vinyl plank flooring and a large kitchen island overlooking the family and dining rooms! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod, sprinkler system, and covered patio! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 72 BLK 1 CAMILLO LAKES SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '2645' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701793' WHERE `Matrix_Unique_ID` = '211703770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T17:07:10.810' ,`MLSNumber` = '88810803' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.545821' ,`Longitude` = '-94.377682' ,`PhotoCount` = '14' ,`PostalCode` = '75670' ,`RoomCount` = '3' ,`ListPrice` = '56999.00' ,`Status` = 'Active' ,`StreetName` = 'Bishop' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Street' ,`City` = 'Marshall' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Handy-man special with great opportunities! 3 bedroom, 1.5 bath brick home with 1-car garage. Own it today and turn this home into something spectacular. Contact us today for more information! As Is.' ,`Acres` = '0.42' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.42, LOT: S/PT 3-4 PT 6-8, BLK: 40, SUBD: HENDRICKS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '18295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '710 - Marshall' ,`SchoolElementary` = 'R E LEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (MARSHALL)' ,`SchoolMiddle` = 'MARSHALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hendricks 2nd' ,`TaxAmount` = '1879' ,`TaxRate` = '2.1753' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701793' WHERE `Matrix_Unique_ID` = '211704350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T17:41:26.097' ,`MLSNumber` = '95806047' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.542581' ,`Longitude` = '-94.387156' ,`PhotoCount` = '25' ,`PostalCode` = '75670' ,`RoomCount` = '3' ,`ListPrice` = '69999.00' ,`Status` = 'Active' ,`StreetName` = 'Acorn' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Drive' ,`City` = 'Marshall' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2021' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this single family home built in 1928. It consists of 3 bedrooms, 3 bathrooms, a fireplace, and a large back patio that leads to the big backyard where your children and furry friends can play, and you can enjoy! This home also has a new roof! The property is just waiting for the right person to give it some love and bring out its true beauty. This home is located In the West Oaks area. Nearby schools include, G W Carver Elementary School, Marshall J High School and Marshall High School. Make an appointment today and find out how you can make it yours before it\'s too late!' ,`Acres` = '0.397' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.397, LOT: 7 & 12, BLK: 1, SUBD: WEST OAKS, HSE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '17293' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '710 - Marshall' ,`SchoolElementary` = 'G W CARVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (MARSHALL)' ,`SchoolMiddle` = 'MARSHALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West Oaks' ,`TaxAmount` = '1432' ,`TaxRate` = '2.1753' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1928' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701793' WHERE `Matrix_Unique_ID` = '211705660' --> Updated record success