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-16T13:22:22.200' ,`MLSNumber` = '65860008' ,`ListAgentFullName` = 'Yekcira Burnom' ,`ListOfficeName` = 'Braggs Broker Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735005' ,`Longitude` = '-95.349607' ,`PhotoCount` = '24' ,`PostalCode` = '77004' ,`RoomCount` = '2' ,`ListPrice` = '233000.00' ,`Status` = 'Active' ,`StreetName` = 'Hadley' ,`StreetNumber` = '3428' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market!!! Great location in the inside the loop for new construction or townhouse development. It even has good renovation / flip potential. Tenant occupied. No showings without accepted contract. Seller is motivated and ready to sell. Don\'t miss out on this Good Deal!!!! Very Motivated Seller!!! Bring All Offers!!!' ,`Acres` = '0.0918' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 6 PRAIRIE HOME' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Prairie Home' ,`TaxAmount` = '2537' ,`TaxRate` = '2.5144' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699446' WHERE `Matrix_Unique_ID` = '199133909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:15:45.927' ,`MLSNumber` = '69854754' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.366795' ,`Longitude` = '-95.665587' ,`PhotoCount` = '24' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '402040.00' ,`Status` = 'Active' ,`StreetName` = 'Youth Water' ,`StreetNumber` = '939' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2733' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNBELIEVABLE NEW D. R. HORTON BUILT 5 BEDROOM! Great Interior Layout with Two Bedrooms & Baths Downstairs! Lovely Foyer Leads to Gourmet Island Kitchen with Big Corner Pantry, Light & Bright Dining Area, & Supersized Family Room! Privately Located First Floor Primary Suite Offers Garden Bath with Dual Sinks, Separate Tub & Shower, & Huge Walk-In Closet! Guest Suite/Second Bedroom Downstairs with Adjoining Full Bath! Enormous Gameroom/Media Room Upstairs, Along with Three Big Secondary Bedrooms! Covered Patio & Sprinkler System! High Ceilings, Recessed Lighting, Linen & Coat Closets, Tons of Storage Space - Too Much to List! HURRY! Estimated Completion - August 2022. Nestled in the rolling hills along FM 2854, you\'ll find FAIRWATER the NEWEST community in Montgomery, TX! Zoned to the prestigious Montgomery ISD students receive the best education in some of the HIGHEST rated schools in the state! Come see why we are the FASTEST growing community in Montgomery, TX' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S503207 - Fairwater 07, BLOCK 3, Lot 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7797' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '3.1742' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699446' WHERE `Matrix_Unique_ID` = '207942715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:37:32.310' ,`MLSNumber` = '15300108' ,`ListAgentFullName` = 'Shannon Sudderth' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.414540' ,`Longitude` = '-95.400503' ,`PhotoCount` = '24' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Side' ,`StreetNumber` = '11726' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! You will not find a better home on 2 acreas in the area and located on a cul de sac. This property offers so many great features. Enjoy the relaxed mornings sitting in the back yard on the swing listening to the birds sing and sipping on your morning cup of coffee. This property offers the best kind of country living there is... nice country feel yet still not far from stores, entertainment, and shopping. There are also 4 additional acres for sale next to the property, so you have the ability to purchase 2, 4, or 6 acres to call your new home. Either way the neighborhood is quaint and quiet and doesn\'t have a lot of traffic. What are you waiting for, call today and schedule your private showing.' ,`Acres` = '2' ,`Area` = '5' ,`BuilderName` = 'Tilson Homes Inc.' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRYSIDE ESTATES SEC II (UNRCD) (A0511 H T & B R R) LOT 3' ,`LotDesciption` = 'Cul-De-Sac,Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Countryside Estates' ,`TaxAmount` = '6507' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699447' WHERE `Matrix_Unique_ID` = '208390083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:05:32.130' ,`MLSNumber` = '7396731' ,`ListAgentFullName` = 'Adam Lambert' ,`ListOfficeName` = 'Real Equity TX LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.929371' ,`Longitude` = '-94.838235' ,`PhotoCount` = '15' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 4281' ,`StreetNumber` = '140' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready 2 bed 2 bath home on over 1/2 acre in a great neighborhood. Why rent when you can own? Schedule your showing today!' ,`Acres` = '0.551' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WOODWAY, SEC 2, BLOCK 1, LOT 13, ACRES .551, MH LABEL# HWC04' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '24002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodway, Sec 2' ,`TaxAmount` = '1305' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699447' WHERE `Matrix_Unique_ID` = '209831542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:12:40.277' ,`MLSNumber` = '26487140' ,`ListAgentFullName` = 'Kourtney Walker' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.187936' ,`Longitude` = '-95.832858' ,`PhotoCount` = '50' ,`PostalCode` = '77355' ,`RoomCount` = '10' ,`ListPrice` = '899490.00' ,`Status` = 'Active' ,`StreetName` = 'FM 1488' ,`StreetNumber` = '25064' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this gorgeous 12-acre property with frontage to Farm to Market 1488 between Waller and Magnolia. Check out the video of the private road. This unrestricted property has acreage cleared near home and shop. The home offers over 4500 square feet of living space. It boasts a large primary bedroom on the first floor as well as 2 secondary bedrooms and secondary bathroom. The kitchen/dining room/living area is a large open space great for gatherings. The first level\'s split plan allows privacy for the primary bedroom and bathroom. The second floor has a flex space and a large bedroom with a full bathroom. The home is surrounded by a variety of trees. An extensive workshop is adjacent to the home with a 20X20 porta cochere to park cars, recreational vehicles or tractors. The 40X40 shop is well insulated, has controlled temp, a full bathroom and a hefty door that will accommodate machinery for a variety of projects. This amazing private/unrestricted property is move-in ready.' ,`Acres` = '12' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A311400 A-114 JAMES COOPER TRACT 2-2 ACRES 14.209' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '' ,`TaxRate` = '2.1322' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699447' WHERE `Matrix_Unique_ID` = '210170902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:20:49.243' ,`MLSNumber` = '8821372' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059830' ,`Longitude` = '-95.359750' ,`PhotoCount` = '12' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '255990.00' ,`Status` = 'Active' ,`StreetName` = 'Pinetree Crescent Lane' ,`StreetNumber` = '5426' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful brand NEW Express Home in Breckenridge Forest! Fantastic location! Charming curb appeal! Perfect floor plan with open living spaces and modern finishes! Lovely island kitchen with espresso cabinetry! Great Primary suite with large closet and oversized shower! Great outdoor space with covered back patio and landscape package! Hurry and call today!!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Express Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 35, Bkl 1, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5275' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699447' WHERE `Matrix_Unique_ID` = '210176918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:18:53.680' ,`MLSNumber` = '72477302' ,`ListAgentFullName` = 'Beau Green' ,`ListOfficeName` = 'The Wolf Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.522285' ,`Longitude` = '-95.469723' ,`PhotoCount` = '22' ,`PostalCode` = '77545' ,`RoomCount` = '9' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Peacham' ,`StreetNumber` = '1211' ,`StreetSuffix` = 'Court' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1899' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This immaculate 3 bed 2 bath home in Teal Run has been completely remodeled with no detail forgotten. With modern finishes throughout, this home features tile and vinyl flooring, quartz countertops, a gas fireplace with white stacked stone, a new gas range stove, recent landscaping, walk-in primary closet with built-ins, jetted tub, and dual vanity in the primary bath, and much more! Book your private showing today! A/C replaced 2022.' ,`Acres` = '0.1386' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TEAL RUN SEC 10, BLOCK 4, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6037' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BURTON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Teal Run Sec 10' ,`TaxAmount` = '4602' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699447' WHERE `Matrix_Unique_ID` = '210302555' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T13:09:05.267' ,`MLSNumber` = '27507548' ,`ListAgentFullName` = 'Rebecca May' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096106' ,`Longitude` = '-95.123106' ,`PhotoCount` = '50' ,`PostalCode` = '77336' ,`RoomCount` = '12' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = 'Commons Lakeview' ,`StreetNumber` = '519' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '1.2277' ,`Area` = '32' ,`BuilderName` = 'Custom' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 COMMONS OF LAKE HOUSTON SEC 8' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '53477' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Vinyl Lined' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Commons of Lake Houston' ,`TaxAmount` = '8909' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699447' WHERE `Matrix_Unique_ID` = '210400438' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:46:32.787' ,`MLSNumber` = '64892069' ,`ListAgentFullName` = 'Angela Reagan' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752566' ,`Longitude` = '-95.610667' ,`PhotoCount` = '40' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Beaconshire' ,`StreetNumber` = '1607' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2449' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for immediate move-in and located in Stonehenge subdivision this nicely updated 3 bedroom, 2.5 bath patio home has lots to offer. Marble entry with high vaulted ceilings welcome you as you enter. Lots of natural light, updated kitchen with double ovens and granite counters. Wood floors in living areas. Tile in all wet areas. Recent dishwasher and hot water heater 2019. AC unit; 2021 - new heavy gauge copper piping in attic; 2022 - master shower pan replaced and retiled, deck refinished. New carpet upstairs 2022. Beautiful Granite fireplace and mantle. Primary bath features separate shower and jacuzzi tub. French Doors lead to private backyard area with deck. Solar Screens, and Sprinkler System. Convenient access to I-10 and the Energy Corridor! Just minutes to City Centre, Memorial city mall and Katy. No flooding per seller.' ,`Acres` = '0.1079' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 110 STONEHENGE SEC 3 U/R R/P' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '4700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '878' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonehenge' ,`TaxAmount` = '6260' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699447' WHERE `Matrix_Unique_ID` = '210428411' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:30:53.540' ,`MLSNumber` = '72201814' ,`ListAgentFullName` = 'Shani Daigle' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.062685' ,`Longitude` = '-94.094285' ,`PhotoCount` = '18' ,`PostalCode` = '77701' ,`RoomCount` = '4' ,`ListPrice` = '160000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Park' ,`StreetNumber` = '2456' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '2' ,`SqFtTotal` = '1380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Totally remodeled duplex, fully rented and ready for new ownership. Each unit is a 1 bedroom 1.5 bath. This is an awesome income generating opportunity! Both units have professionally installed window units for cooling & heating.' ,`Acres` = '0.3444' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ELLIS L 14 L 15 B 2 2456-60-62 PARK ST' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CHARLTON-POLLARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ellis' ,`TaxAmount` = '251' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699448' WHERE `Matrix_Unique_ID` = '210715305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:19:24.960' ,`MLSNumber` = '31959681' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.060673' ,`Longitude` = '-95.357852' ,`PhotoCount` = '7' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '262990.00' ,`Status` = 'Active' ,`StreetName` = 'Kentwood Springs' ,`StreetNumber` = '24062' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE NEW D. R. HORTON BUILT 1 STORY! Fantastic Location - Easy Access to I-45 & the Hardy Toll Road! Great Interior Layout with Open Living Spaces & Modern Finishes! Lovely Island Kitchen with Espresso Cabinetry - Opens to Spacious Dining Area & Living Room! Privately Located Primary Suite Features Incredible Bath with Oversized Shower & Walk-In Closet! Big Secondary Bedrooms! Convenient Indoor Utility Room! Covered Back Patio & Landscaping Package! Fantastic Community! MUST SEE! Estimated Completion - October 2022.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 6 Breckenridge East Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6071' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.112' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699448' WHERE `Matrix_Unique_ID` = '210987411' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:08:38.407' ,`MLSNumber` = '86776774' ,`ListAgentFullName` = 'Edmundo Tijerina' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022349' ,`Longitude` = '-95.309088' ,`PhotoCount` = '19' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '234500.00' ,`Status` = 'Active' ,`StreetName` = 'Rezanof' ,`StreetNumber` = '21239' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfectly situated in the Humble area, five minutes away from Deerbrook Mall. \r\nAdorable 1 story home featuring 3 bedrooms, 2 full baths with 2 car garage. Ready with fresh interior paint, luxury vinyl plank flooring in living areas and tile flooring in bedrooms. Open concept floorplan features a spacious family room which is open to the formal dining room and spacious kitchen. In this split plan the primary bedroom is located off the family room on the back of the home and the two secondary bedrooms along with a hall bath are located off a small hallway at the front of the home. A great design for privacy. The backyard features a large, covered patio with fans and above heaters. Easy access to FM 1960 and Hwy 59 (aka I-69).' ,`Acres` = '0.1125' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 KENSWICK MEADOWS AMEND' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4902' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Meadows Amd' ,`TaxAmount` = '4105' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699448' WHERE `Matrix_Unique_ID` = '211027100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:23:53.223' ,`MLSNumber` = '38909091' ,`ListAgentFullName` = 'Karen Melgar' ,`ListOfficeName` = 'Boncler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860883' ,`Longitude` = '-95.291422' ,`PhotoCount` = '11' ,`PostalCode` = '77016' ,`RoomCount` = '7' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Parker' ,`StreetNumber` = '7613' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this great one-story starter home on a well-established neighborhood. This property has been well maintained and has a formal living room, dining room, a covered porch with huge back yard. Schools, parks and shopping are minutes away.' ,`Acres` = '0.1918' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 14 SCENIC WOODS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8356' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Scenic Woods' ,`TaxAmount` = '3051' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699448' WHERE `Matrix_Unique_ID` = '211393136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T13:46:52.767' ,`MLSNumber` = '55933700' ,`ListAgentFullName` = 'Mark Bland' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510235' ,`Longitude` = '-95.737120' ,`PhotoCount` = '25' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Shoal Valley' ,`StreetNumber` = '2406' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2406 Shoal Valley Ln! This spacious Lennar Terrazzo 2 is a 4brd 3.5bth has a downstairs study with a half bath. Upstairs has a game room or it can be used as a media room. Master bedroom is downstairs with a stand up shower, soak tube and a large walk-in closet. Home is laid out for those family get-togethers or entertaining friends.' ,`Acres` = '0.1531' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT CREEK SEC 16, BLOCK 2, LOT 40' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6671' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'THOMAS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Creek Sec 16' ,`TaxAmount` = '6986' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699448' WHERE `Matrix_Unique_ID` = '211396699' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:57:52.007' ,`MLSNumber` = '71753966' ,`ListAgentFullName` = 'Rene Sorola' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515373' ,`Longitude` = '-95.485255' ,`PhotoCount` = '33' ,`PostalCode` = '77545' ,`RoomCount` = '11' ,`ListPrice` = '1750000.00' ,`Status` = 'Active' ,`StreetName` = 'Darby' ,`StreetNumber` = '1819' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well appointed Mediterranean estate ideally situated on 5 acres in the esteemed Newpoint Estates community. The foyer welcomes you with two story ceilings and a beautiful curved staircase with detailed ironwork. Impressive floor plan includes formal living, formal dining, 2 gas log fireplaces, private office and upstairs game room. Classic crown molding, recessed lighting, attractive travertine and sparkling hardwood flooring throughout. Spacious den features custom built ins and walls of windows creating a light and bright space. Gourmet kitchen offers custom cabinets, granite countertops, Jenn Air 6 burner cooktop with griddle, pot filler, built-in refrigerator and wine fridge. Resort style back yard is perfect for outdoor entertaining with large pool, hot tub, rock waterfall, fire pit, travertine decking and outdoor kitchen outfitted with Viking built-ins. This great property is complete with a 48KW integrated generator fueled by a 1000-gallon LP tank. Schedule your showing today!' ,`Acres` = '4.999' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NEWPOINT ESTATES SEC 1, BLOCK 1, LOT 12, ACRES 4.999' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Newpoint Estates Sec 1' ,`TaxAmount` = '23258' ,`TaxRate` = '2.34' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699448' WHERE `Matrix_Unique_ID` = '211474339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T12:54:10.930' ,`MLSNumber` = '32445176' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755328' ,`Longitude` = '-95.879137' ,`PhotoCount` = '14' ,`PostalCode` = '77494' ,`RoomCount` = '6' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Alder Wood' ,`StreetNumber` = '2510' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Entry leads past utility room and mud room. Home office with French door entry. Large family room opens to dining area. Kitchen hosts a corner walk-in pantry. Secluded primary suite. Primary bath features dual vanities, a walk-in closet, linen closet, and a large glass enclosed shower. Secondary bedrooms with walk-in closets. Covered backyard patio. Two-car garage' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Block 1, Section 31' ,`LotDesciption` = 'Other' ,`LotSize` = '5491' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699448' WHERE `Matrix_Unique_ID` = '211474357' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T13:30:29.450' ,`MLSNumber` = '65643367' ,`ListAgentFullName` = 'Ayesha Shelton' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.642246' ,`Longitude` = '-95.378002' ,`PhotoCount` = '34' ,`PostalCode` = '77051' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunnydale' ,`StreetNumber` = '3131' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Park Street Homes presents 3131 Sunnydale! This 2022 built Modern Farmhouse is everything you desire. 4 bedrooms 2 1/2 baths including a primary suite with a HUGE primary closet with built-ins. Freestanding tub and shower with double vanity in the primary suite. Recessed LED lighting throughout and an open kitchen with a large walk in pantry. Enjoy your mornings in the LARGE backyard with covered patio perfect for entertaining. 10 mins from the Texas Medical Center & NRG Stadium, Pearland shopping and retail and 15 mins from Downtown Houston.' ,`Acres` = '0.1389' ,`Area` = '3' ,`BuilderName` = 'Park Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 10 SUGAR VALLEY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sugar Valley' ,`TaxAmount` = '705' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663699449' WHERE `Matrix_Unique_ID` = '211475754' --> Updated record success