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-10-17T07:27:12.890' ,`MLSNumber` = '22035709' ,`ListAgentFullName` = 'Bill Gardner' ,`ListOfficeName` = 'Gardner Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.086123' ,`Longitude` = '-95.893045' ,`PhotoCount` = '38' ,`PostalCode` = '77484' ,`RoomCount` = '9' ,`ListPrice` = '1499900.00' ,`Status` = 'Active' ,`StreetName` = 'Binford' ,`StreetNumber` = '21321' ,`StreetSuffix` = 'Road' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2733' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '7.25 Unrestricted acres on Binford Road in Waller, Texas and future major thoroughfare. Binford Road to be expanded to 4 lanes; 2733 sf, 3 br/2.5 bath custom home built in 2019. High ceilings throughout, crown molding throughout, custom features in all rooms; ceramic tile floors throughout, granite counter tops in kitchen, bathrooms and laundry room, upgraded fixtures, wide hall ways, open concept for great entertaining, split floor plan, light & bright, huge utility room, large back patio, with a front patio currently used as carport for vehicles. Perfect for commercial/residential or both. Cleared and well maintained 7.25 acres, NO RESTRICTIONS, with easy access to Hwy 290, AG EXEMPT, NO FLOODING, LOW TAX RATE . Survey available.' ,`Acres` = '7.25' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PT LT 1 BLK 1 (HOMESITE) RODRIGUEZ EL PORVENIR' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '315810' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'UNRESTRICTED' ,`TaxAmount` = '5416' ,`TaxRate` = '2.006' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666042330' WHERE `Matrix_Unique_ID` = '206955599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:05:36.077' ,`MLSNumber` = '71589643' ,`ListAgentFullName` = 'Suzan Zachariah' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.956107' ,`Longitude` = '-95.280862' ,`PhotoCount` = '19' ,`PostalCode` = '77541' ,`RoomCount` = '2' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Coral' ,`StreetNumber` = '215' ,`StreetSuffix` = 'Court' ,`City` = 'Surfside Beach' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your wish was granted. The seller is selling her home near the beach. Stop in your tracks. These opportunities do not come up often. This property has is off Coral near the beach. The house is on one of the lots; the new owner has first right of refusal to purchase the lot next door. Come check it out and see if this 2/1 could be your new get a way. Well priced for the location, this property will not last long. Come see!!! The listing is only for the home on Lot 13 and doesn\'t include Lot 12 which is in the Brazoria CAD account. Compare what sales have been for homes with this proximity to the beach. This home can be a doll house for a lucky and smart buyer will with the gift of ideas. That buyer will find their \"deal\". Buy the lot next door for an investment...we are running out of land near the beach.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'S/D TR 48 (A0051 F J CALVIT DIV 2 (B C I C)) LOT 13 (SURF' ,`LotDesciption` = 'Water View' ,`LotSize` = '5497' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'S/D Tr 48' ,`TaxAmount` = '4179' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042330' WHERE `Matrix_Unique_ID` = '207001324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:34:15.977' ,`MLSNumber` = '18109568' ,`ListAgentFullName` = 'Rocio Guajardo' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.079816' ,`Longitude` = '-95.031144' ,`PhotoCount` = '30' ,`PostalCode` = '77535' ,`RoomCount` = '5' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 6242' ,`StreetNumber` = '265' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream new built Home sitting on 1 ACRE!\r\nCustom Kitchen cabinets, massive custom built kitchen island with beautiful granite, huge master bathroom with separate shower and tub, large size closets, luxury vinyl floors, brick on all 4 sides of the house, rain gutters... just to mention a few of the many great features this lovely Home has to offer.\r\nYou don\'t want to miss this one out. Call today to schedule a viewing and make this house your new Home!' ,`Acres` = '1' ,`Area` = '52' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000764 A G PENN #1006, TRACT 40, ACRES 3.46' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'A G Penn' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042330' WHERE `Matrix_Unique_ID` = '207593330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:41:33.893' ,`MLSNumber` = '6706088' ,`ListAgentFullName` = 'Terry Stanley' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595402' ,`Longitude` = '-95.485701' ,`PhotoCount` = '7' ,`PostalCode` = '77489' ,`RoomCount` = '4' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgerock' ,`StreetNumber` = '15902' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1765' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this income producing property! Large fenced yard. Open kitchen. Convenient to Fort Bend Tollway and Beltway 8.' ,`Acres` = '0.1641' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRIARGATE SEC 3, BLOCK 4, LOT 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRIARGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Briargate Sec 3' ,`TaxAmount` = '3577' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042330' WHERE `Matrix_Unique_ID` = '208425935' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:50:55.330' ,`MLSNumber` = '39180372' ,`ListAgentFullName` = 'Carla Wade' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.204651' ,`Longitude` = '-94.938738' ,`PhotoCount` = '40' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '664900.00' ,`Status` = 'Active' ,`StreetName` = 'San Domingo' ,`StreetNumber` = '13839' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom, 3 bath beach house has been beautifully updated with soft coastal hues and is sold furnished with just a few exclusions. This beauty has it\'s own lift to make life easy for those that don\'t love walking upstairs! \r\n It features 2 decks on the main living level and a roof top deck for nice views. Pirates beach is a very desirable beachfront neighborhood with beach access. This house offers an extended 2 car garage, so much storage including 2 ground level storage rooms. There is a breezeway, a double covered parking area plus a covered patio area at the back of the house. The large driveway allows for lots of friends and family gatherings. House has been a successful vacation rental, and would make a fantastic full time home or investment property!' ,`Acres` = '0.14' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 45 LOT 2 BLK 11 PIRATES BEACH SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pirates Beach' ,`TaxAmount` = '10909' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042330' WHERE `Matrix_Unique_ID` = '209626000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:56:10.230' ,`MLSNumber` = '48940902' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838713' ,`Longitude` = '-94.824138' ,`PhotoCount` = '21' ,`PostalCode` = '77523' ,`RoomCount` = '13' ,`ListPrice` = '463149.00' ,`Status` = 'Active' ,`StreetName` = 'Oakmont' ,`StreetNumber` = '7510' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to South Lake Estate. The one-story Willard II brick home with stone accents features 4 bedrooms, 3 baths and 3 car attached garage on an oversized lot. Convenient home office off hall 2 with two storage closets. Elegant dining room with easy access to gourmet kitchen. Beautiful maple cabinets, quartz countertops and farmhouse sink in kitchen. Cozy cast stone fireplace in great room. The owner\'s luxury bath has a huge walk-in closet, linen closet, double sinks, separate tub and shower. Grill outside or relax under the covered patio. Students are zoned to Barbers Hill ISD. South Lake Estate is located within close proximity to Eagle Pointe Golf Course and Mont Belvieu City Park. South Lake Estate is offered by K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '20/4/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14523' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Lake Estate' ,`TaxAmount` = '' ,`TaxRate` = '2.16' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042331' WHERE `Matrix_Unique_ID` = '209669014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:59:28.113' ,`MLSNumber` = '6575687' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892292' ,`Longitude` = '-95.483315' ,`PhotoCount` = '10' ,`PostalCode` = '77088' ,`RoomCount` = '8' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Bold Forest' ,`StreetNumber` = '8619' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1735' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Contemporary home in Inwood. Open plan for today’s modern lifestyles. The dining room is just off the entry & opens to the spacious living room featuring a vaulted ceiling & fireplace. Stunning kitchen features granite counters/subway tile backsplash. Refrigerator included. Adjacent breakfast room w/corner windows for natural light. Spacious primary suite features an ensuite bath with a long vanity with new granite counter. Off the ensuite is a large walk-in closet. Two additional bedrooms share a hall bath. A bonus room is located off the dining room and is perfect as a gameroom, office or music room. This space was converted space of the original 2 car garage. Home still has a 1 car garage space. Covered patio overlooks the lush landscaped backyard. A separate storage building for additional storage in the back yard. Recent updates include fresh interior and exterior paint, new carpet in bedrooms, several new light fixtures and ceiling fan in living room. New Roof! Come tour today!' ,`Acres` = '0.1896' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 20 017*I5645955-002-020-007 INWOOD NORTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NITSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Ranch' ,`Subdivision` = 'Inwood North' ,`TaxAmount` = '4085' ,`TaxRate` = '2.6055' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042331' WHERE `Matrix_Unique_ID` = '211314524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:23:14.200' ,`MLSNumber` = '57441045' ,`ListAgentFullName` = 'Alma Puerto' ,`ListOfficeName` = 'Texas Fast Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649978' ,`Longitude` = '-95.234103' ,`PhotoCount` = '28' ,`PostalCode` = '77034' ,`RoomCount` = '4' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Globe' ,`StreetNumber` = '818' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home has been completely renovated and has lots of space. This house is located down the street from it\'s designated Elementary & Jr High School. Garage has been converted into an extra area for home so you can use your creativity and make it your own. Kitchen has granite countertops and stainless-steel appliances. Great for first time home buyers has a spacious backyard and covered patio for entertaining. Contact and schedule your showing today! Yo hablo español!' ,`Acres` = '0.1584' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 30 FREEWAY MANOR SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FREEMAN ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeway Manor Sec 03' ,`TaxAmount` = '4125' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042331' WHERE `Matrix_Unique_ID` = '211391672' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:49:40.653' ,`MLSNumber` = '60535333' ,`ListAgentFullName` = 'Jennifer Guillen' ,`ListOfficeName` = 'Guillen Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028828' ,`Longitude` = '-95.471556' ,`PhotoCount` = '40' ,`PostalCode` = '77388' ,`RoomCount` = '14' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Edsall Drive' ,`StreetNumber` = '17319' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your next home in the sought after subdivision of \"Cypresswood\"!! Beautifully updated home on a cul-de-sac with plenty of room for a family with 5 bedrooms, 2.5 bathrooms, Office, Enormous Primary Bathroom, Sunroom, Flex Room, and big backyard!! Surrounded by nature\'s beauty with mature trees on the front lawn, enjoy your view of Magnolia, Sycamore, Sago Palms, and an Ornamental Pear Tree(s). Freshly painted interior, wood-like tile and new carpet throughout all secondary bedrooms; Silestone countertops in Kitchen. Foundation already repaired and comes with a transferrable warranty. Schedule an appt. today - won\'t last long!! **Approx. Room Measurements - Buyer to verify room dimensions**' ,`Acres` = '0.2112' ,`Area` = '13' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 11 CYPRESSWOOD SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Sec 04' ,`TaxAmount` = '4649' ,`TaxRate` = '2.4565' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042331' WHERE `Matrix_Unique_ID` = '211537302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:34:00.410' ,`MLSNumber` = '95782898' ,`ListAgentFullName` = 'Michelle Carruthers' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Tracy Strong' ,`SellingOfficeName` = 'Strong Real Estate Co.' ,`Latitude` = '30.466468' ,`Longitude` = '-95.568214' ,`PhotoCount` = '38' ,`PostalCode` = '77318' ,`RoomCount` = '4' ,`ListPrice` = '415000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Carmel' ,`StreetNumber` = '15478' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story home featuring 3 bedrooms with flex room, 2 1/2 baths & open concept living area with an abundance of natural light!\r\nWarm and rich hickory wood floors, high ceilings, and concrete wood burning fireplace. The gourmet kitchen has a functional island, granite countertops, SS appliances & walk in pantry. Generous primary bedroom with ensuite bath providing a spa like feel with double sinks, step-in rainfall shower, jetted soaking tub, and spacious walk-in closet.\r\nLarge back yard with covered patio for outdoor enjoyment or relax on the front porch and sip coffee in the morning. Plenty of room for a pool!\r\n\r\nThis Lake Conroe waterfront community offers pool, clubhouse, tennis courts, pickleball court, basketball court, boat launch, and lakefront green spaces throughout for residents to enjoy. Corinthian Point is a hidden gem on the north side of Lake Conroe. \r\nMinutes from The Woodlands and world class dining and medical facilities.' ,`Acres` = '0.2487' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CORINTHIAN POINT 02, BLOCK 16, LOT 244' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10832' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '81' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Corinthian Point 02' ,`TaxAmount` = '5271' ,`TaxRate` = '2.2463' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042331' WHERE `Matrix_Unique_ID` = '211678651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:29:17.963' ,`MLSNumber` = '12750101' ,`ListAgentFullName` = 'Juana Macias' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.593441' ,`Longitude` = '-95.217766' ,`PhotoCount` = '32' ,`PostalCode` = '77089' ,`RoomCount` = '9' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Sageriver' ,`StreetNumber` = '11307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2078' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'To be enamored by such a property is knowing that it was meant to be. This 3 bedroom, 2 full bath, and attached 2-car garage may be yours. This beautiful neighborhood is near beltway 8 and I-45 for easy access. WAIT! DO NOT MISS OUT ON THE EXTRA BEDROOM AND BATHROOM OUT IN THE BACKYARD! WOW! AMAZING! HURRY AND COME SEE!' ,`Acres` = '0.2164' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 21 SAGEMONT SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'STUCHBERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemont Sec 05' ,`TaxAmount` = '4136' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042332' WHERE `Matrix_Unique_ID` = '211994155' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:27:14.513' ,`MLSNumber` = '82596294' ,`ListAgentFullName` = 'Tammi Blalack' ,`ListOfficeName` = 'Logos Investment Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514279' ,`Longitude` = '-94.986815' ,`PhotoCount` = '10' ,`PostalCode` = '77518' ,`RoomCount` = '2' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayshore' ,`StreetNumber` = '3914' ,`StreetSuffix` = 'Drive' ,`City` = 'Bacliff' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated 2/1 with a view of Galveston Bay. And across from the community park pier. Updates include foundation leveling, new 3/4\" pressure treated subfloors, new vinyl planks, updated bathroom. All stainless appliances. Stackable washer and dryer. 12\' x 12\' storage building. Land footage is approximate. Upon signing of contract, new survey paid by seller. Back property line will be where picket fence is currently located. Owner to build new back fence before closing.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'To be determined' ,`LotDesciption` = 'Water View' ,`LotSize` = '6500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'KENNETH E. LITTLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Perkins Beach 2nd' ,`TaxAmount` = '5135' ,`TaxRate` = '2.2342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042332' WHERE `Matrix_Unique_ID` = '212177825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:36:01.773' ,`MLSNumber` = '29141053' ,`ListAgentFullName` = 'Kaysea West' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.225546' ,`Longitude` = '-95.350467' ,`PhotoCount` = '18' ,`PostalCode` = '77534' ,`RoomCount` = '4' ,`ListPrice` = '289999.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue J' ,`StreetNumber` = '1714' ,`StreetSuffix` = '' ,`City` = 'Danbury' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this 4 bedroom, 2 bath home that boasts over 1,800 sq ft. The floor plan has an excellent flow for entertaining. Fabulous kitchen with custom cabinetry and granite countertops, breakfast bar perfect for those early morning meals, wood grain tile flooring though-out house, indoor utility room, two car garage. Step outside to the fully fenced backyard, showcases a newly built deck, perfect for the family gatherings. Call today for your private showing.' ,`Acres` = '0.166' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Danbury' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DANBURY BLK 62 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7231' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '15 - Danbury' ,`SchoolElementary` = 'DANBURY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DANBURY HIGH SCHOOL' ,`SchoolMiddle` = 'DANBURY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Danbury' ,`TaxAmount` = '6254' ,`TaxRate` = '2.8783' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042332' WHERE `Matrix_Unique_ID` = '212270020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:11:29.820' ,`MLSNumber` = '29890102' ,`ListAgentFullName` = 'Eugene Chua' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.410094' ,`Longitude` = '-95.221905' ,`PhotoCount` = '50' ,`PostalCode` = '77511' ,`RoomCount` = '7' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 422' ,`StreetNumber` = '2852' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1949' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in Alvin South is a charming ranch-style home that rests on more than 1 acre! Landscaped beds line the walkway to the entry. Wood-like flooring runs continuously throughout the 1,949 sq. ft. of living space. Bathed in light tones, you\'ll love the versatility to apply your own color scheme. A spacious living room/dining room combination creates plenty of space for gatherings. Rich intersecting beams offer dimensionality to the space, while the gas fireplace and brick hearth add a lovely focal point. Adjacent is a country-style kitchen that features ALL NEW stainless steel appliances! You\'ll love the counter space available to prepare your favorite meals. The house contains 3 sizable bedrooms and 2 full baths. The primary bedroom suite offers a tub and shower combination, a vanity area resting under a framed mirror, and distinctive track lighting. The charming country-style home even includes a closet with a built-in gun rack. No HOA! Mins. to CVS, Home Depot and Chik-Fil-A.' ,`Acres` = '1.09' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0481 H T & B R R TRACT 26D-26F ACRES 1.09' ,`LotDesciption` = 'Other' ,`LotSize` = '47480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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` = 'H T & B R R' ,`TaxAmount` = '4894' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042332' WHERE `Matrix_Unique_ID` = '212469286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:40:16.910' ,`MLSNumber` = '68216428' ,`ListAgentFullName` = 'Brian Clark' ,`ListOfficeName` = 'ABC Capital Group , LLC' ,`SellingAgentFullName` = 'Dacia Hernandez' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.680157' ,`Longitude` = '-95.343766' ,`PhotoCount` = '24' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '99900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Burma' ,`StreetNumber` = '5034' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fixer home being sold as is.' ,`Acres` = '0.1307' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 34 BLK 8 SOUTH PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5692' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KELSO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Park Sec 02' ,`TaxAmount` = '1424' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042332' WHERE `Matrix_Unique_ID` = '212634546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:56:46.203' ,`MLSNumber` = '70837205' ,`ListAgentFullName` = 'Daniel DiPetta' ,`ListOfficeName` = 'Bayou City Realty, LLC' ,`SellingAgentFullName` = 'Kiley Rapier' ,`SellingOfficeName` = 'CB&A, Realtors- Loop Central' ,`Latitude` = '29.800806' ,`Longitude` = '-95.517747' ,`PhotoCount` = '32' ,`PostalCode` = '77080' ,`RoomCount` = '6' ,`ListPrice` = '459950.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rosstown' ,`StreetNumber` = '9301' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully remodeled house in a mature neighborhood awaits you! So many upgrades! Seller spent over $175,000 in repairs! New energy efficient windows, New Roof, New Electrical, New PEX Piping, New Drain lines and MORE!! New flooring, cabinets and vanities throughout the entire house. Updated kitchen with Quartz countertops and waterfall island, tile backsplash, and stainless steel appliances. Bathrooms completely updated with new countertops and ceramic tile. Brand New wooden Pergola which is perfect for backyard gatherings!' ,`Acres` = '0.2984' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2 SPRING BRANCH OAKS' ,`LotDesciption` = 'Corner' ,`LotSize` = '13000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Branch Oaks' ,`TaxAmount` = '7601' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042333' WHERE `Matrix_Unique_ID` = '212971459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:17:01.270' ,`MLSNumber` = '48637885' ,`ListAgentFullName` = 'Cynthia Ramos' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.889840' ,`Longitude` = '-94.810445' ,`PhotoCount` = '32' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 401' ,`StreetNumber` = '199' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy coming home to your own slice of country living with a beautiful residence that sits on 5 acres. This property has mature trees throughout two of the cleared, fenced acres. Even comes with a pecan and an apple tree! This home offers a relaxing atmosphere, with a cozy feel. The backyard boasts wide open spaces for gardening or animals. There is plenty of room for a swing set and/or firepit--fun for the whole family! This 4 bedroom, 2 bath, brick home is a must see! It has granite counter tops in the kitchen and a wood/gas fireplace in the living room. It also has a large covered patio, perfect for being outside. There is also a 12 by 24 storage building for storing all your supplies or lawn equipment! The countryside views are an excellent place to enjoy the outdoors, away from the hustle and bustle of everyday life. The three wooded acres can become anything you can dream of! Schedule a showing today…. and don\'t let this one slip away!' ,`Acres` = '5' ,`Area` = '52' ,`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` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WYLIE ESTATES, LOT 1, ACRES 5.0' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wylie Estates' ,`TaxAmount` = '7369' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042333' WHERE `Matrix_Unique_ID` = '213057498' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:39:56.160' ,`MLSNumber` = '72690392' ,`ListAgentFullName` = 'Joy Samuel' ,`ListOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586755' ,`Longitude` = '-95.575299' ,`PhotoCount` = '30' ,`PostalCode` = '77459' ,`RoomCount` = '6' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Ring' ,`StreetNumber` = '2511' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow!!!!!! Huge Cul-de- sac lot for swimming pool etc.!!!! Enjoy the Pecan trees at the backyard. NEVER FLOODED! Very tenderly cared 4-bedroom 3 bath High elevation overlooking to Oyster Creek and walk trail. Iron fence, contemporary interior, crown molding, huge primary room with two closets, jetted tub and standing shower.\r\none bedroom downstairs. All bedrooms are with new carpet. All modification has done in timely manner. Fort Bend\'s rated school zone and in First colony. Elementary school within the subdivision. All the amenities are with in 5 minutes of distance. All the measurements are approximate. Please verify upon visit.' ,`Acres` = '0.3388' ,`Area` = '29' ,`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` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PLANTATION CREEK SEC 2-A, BLOCK 2, LOT 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEXINGTON CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Creek Sec 2-A' ,`TaxAmount` = '7996' ,`TaxRate` = '2.71' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042333' WHERE `Matrix_Unique_ID` = '213090594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:49:43.213' ,`MLSNumber` = '9331761' ,`ListAgentFullName` = 'Kevin Hansel' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725791' ,`Longitude` = '-95.790189' ,`PhotoCount` = '32' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Huntswell' ,`StreetNumber` = '5206' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Fantastic 2 bedroom 2 bath is a well maintained home in a highly desired 55+ Gate Active Adult Community of Heritage Grand. Beautiful backyard with covered patio. AC and Furnace replaced 2021 with new Lennox unit. Home has 2 bedrooms and an office/sudy. Inviting open floor plan with kitchen opening up to living room and dining room. Primary bathroom has seperate showwer, jetted tub and dual sinks. Large walk in closet in primary bedroom. HOA covers many amenities please see attached sheet. Heritage Grand is an active adult 55+ community with a full service clubhouse with activities 7 days a week as well as a beautiful pool, gym, miniture golf, bocce ball and pickle ball courts. Conveniently located in Cinco Ranch near shopping, dinning, and beautiful La Centera shopping center. All room sizes are approximate please verify.' ,`Acres` = '0.1341' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH WEST SEC 10, BLOCK 3, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '289' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GRIFFIN ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Grand' ,`TaxAmount` = '6158' ,`TaxRate` = '2.6245' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042333' WHERE `Matrix_Unique_ID` = '213099783' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:38:02.657' ,`MLSNumber` = '91677838' ,`ListAgentFullName` = 'Patrick Rollins' ,`ListOfficeName` = 'City Cottage Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835324' ,`Longitude` = '-95.432454' ,`PhotoCount` = '50' ,`PostalCode` = '77018' ,`RoomCount` = '10' ,`ListPrice` = '1299900.00' ,`Status` = 'Active' ,`StreetName` = 'Richelieu' ,`StreetNumber` = '1255' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction not in flood plain. Zoned to Oak Forest Elementary! Hardwood floors, quartz cabinets, gorgeous trim work and more! Garage wired for electric car charger.' ,`Acres` = '0.167' ,`Area` = '9' ,`BuilderName` = 'City Cottage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 33 OAK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7274' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 03' ,`TaxAmount` = '8335' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042333' WHERE `Matrix_Unique_ID` = '213232987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:07:01.180' ,`MLSNumber` = '31188753' ,`ListAgentFullName` = 'Suzy Pittman' ,`ListOfficeName` = 'Texas Made Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.529854' ,`Longitude` = '-95.734226' ,`PhotoCount` = '37' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Clover Leaf' ,`StreetNumber` = '8311' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFULLY RENOVATED Pulte home with stunning LAKE VIEWS nestled in the heart of River\'s Run with 4 bedrooms & 2.5 bathrooms. One bedroom with large closet is located downstairs and is currently being used as a study/office but can also be a great guest room/Mother-in-Law suite. Upgrades include LVP flooring in the family room, formal living and dining areas, plus new carpet in bedrooms. FRESH PAINT throughout. The kitchen is well-equipped with SS appliances, SUBWAY backsplash & quartz countertops. Primary bedroom is spacious with ensuite bathroom featuring oversized shower & deep soaking tub. Primary closet is HUGE!!! Large GAME ROOM upstairs! MODERN LIGHTING throughout, cabinet hardware, & upgraded mirrors. The 3-car garage has been upgraded with EPOXY COATING!! Neighborhood amenities include: swimming pool, gym, walking trails & parks. Located minutes from Brazos Town Center! Close to I-69/Hwy 59 with easy access to Downtown Houston and the Medical Center.' ,`Acres` = '0.1974' ,`Area` = '30' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER RUN AT THE BRAZOS SEC 1, BLOCK 2, LOT 12' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Run At The Brazos Sec 1' ,`TaxAmount` = '7099' ,`TaxRate` = '2.7148' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042334' WHERE `Matrix_Unique_ID` = '213300606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:43:29.723' ,`MLSNumber` = '66598238' ,`ListAgentFullName` = 'Shannon Patton' ,`ListOfficeName` = 'Prestige Properties Texas' ,`SellingAgentFullName` = 'Susan Allen' ,`SellingOfficeName` = 'Stanfield Properties' ,`Latitude` = '29.821195' ,`Longitude` = '-95.781346' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '335000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Quarry Path' ,`StreetNumber` = '23438' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful four-bedroom two-bathroom home located in Morton Creek Ranch. This stunning floor plan is a showstopper with the beautiful water view and NO back yard neighbors. NO BACK NEIGHBORS!!!\r\nThis backyard is ready for entertaining. Vinyl plank floors, new appliances, granite counters with island kitchen & so much more. The open floor plan is terrific for entertaining. Walk-in closets in spacious bedrooms. Easy access to I-10 & Grand Parkway, plus minutes from retail, dining and entertainment. Too many details to list and a home you must see. Located in the highly sought after KISD. Schedule a showing today, this home won\'t last long!!!' ,`Acres` = '0.1488' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 MORTON CREEK RANCH SEC 5' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '595' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Creek Ranch' ,`TaxAmount` = '7926' ,`TaxRate` = '3.3333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042334' WHERE `Matrix_Unique_ID` = '213374284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:59:25.370' ,`MLSNumber` = '72856061' ,`ListAgentFullName` = 'Joy Aracena' ,`ListOfficeName` = 'Kay Stimson Properties , LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.757149' ,`Longitude` = '-95.633241' ,`PhotoCount` = '38' ,`PostalCode` = '77077' ,`RoomCount` = '9' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Lochshire' ,`StreetNumber` = '14003' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3055' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 bedroom, 3.5 baths, ONE STORY corner lot home on a cul-de-sac in the heart of Energy Corridor. Beautiful crown moldings, 10ft high ceilings, open floor plan. Double-pane windows installed 2020 in common living spaces, primary, and guest room. Kitchen includes granite countertops, Kenmore Elite stainless-steel appliances as well as under-cabinet lighting. Main living area open to kitchen, with gas fireplace with beautiful engineered hardwood floors. Spacious primary suite with sitting area and gas fireplace. Primary bathroom with a soaking tub, double sinks, and walk-in closet. 2 additional bedrooms, plus guest bedroom with ensuite bath. Updated bathrooms, ceiling fans, LED lighting, and engineered hardwood flooring throughout. Generous laundry with separate ice maker. Main living area extends to a relaxing outdoor patio. Fully fenced backyard with sprinkler system installed. Abundant storage, as well as attic storage over the garage. Call and schedule your appointment!' ,`Acres` = '0.1853' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 PARKWAY VILLAGES SEC 5' ,`LotDesciption` = 'Corner,Cul-De-Sac,Patio Lot' ,`LotSize` = '8073' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1708' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Parkway Villages' ,`TaxAmount` = '11687' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042334' WHERE `Matrix_Unique_ID` = '213414257' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:22:15.987' ,`MLSNumber` = '91215581' ,`ListAgentFullName` = 'Shantel Landry' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.856024' ,`Longitude` = '-95.206938' ,`PhotoCount` = '13' ,`PostalCode` = '75862' ,`RoomCount` = '10' ,`ListPrice` = '75000.00' ,`Status` = 'Active' ,`StreetName` = 'Channel' ,`StreetNumber` = '130' ,`StreetSuffix` = 'Street' ,`City` = 'Trinity' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you like boating, fishing, and hunting you would love living here. Trinity is a small community. This wooded land is conveniently located close to Westwood Shores-resort community, Lake Livingston and Onalaska. Metal roof. Central air and heat. Great for investors or anyone seeking to make this home their own. An affordable home site makes a perfect starter home, a nice place for comfortable and safe retirement, or could also be used as an investment property. Rediscover the trinity river and its natural features.' ,`Acres` = '0.355' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'POLLY RYAN, .355 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '15463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Camp Branch Polly Ryan' ,`TaxAmount` = '' ,`TaxRate` = '1.6' ,`WaterSewer` = 'Other Water/Sewer,Public Sewer' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042334' WHERE `Matrix_Unique_ID` = '213447166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:50:26.143' ,`MLSNumber` = '97826443' ,`ListAgentFullName` = 'Carla Wade' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.206803' ,`Longitude` = '-94.954322' ,`PhotoCount` = '44' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '514900.00' ,`Status` = 'Active' ,`StreetName` = 'Cade' ,`StreetNumber` = '14539' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The views from this beautiful home are stunning! The home has the feel of its historic Galveston roots, but with all of the beauty and comfort that you want today. The home also has a vast oversized garage that will accommodate your boat and golf cart in addition to your cars! The kitchen features quartz counters, glass tile backsplash, recessed spot lighting, stainless appliances including a gas cooktop and white cabinetry. The breakfast bar serves 6 people and is open to the living and dining area. The French doors open from the family room to the beautiful first floor balcony with incredible views of West Bay, Lake Como and the State Park. The primary and secondary bedrooms are on the second floor and both have ensuite baths. The primary has a private balcony with gorgeous views, soaring ceilings with a cupola feature for added beauty. The home is sold fully furnished with its pretty coastal decor. It is an active and successful vacation rental.' ,`Acres` = '0.0655' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAYSIDE AT WATERMAN\'S FISH CAMP (2017) ABST 121, BLOCK 9, LO' ,`LotDesciption` = 'Water View' ,`LotSize` = '2853' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Minor Plat/Fish Camp/Waterman' ,`TaxAmount` = '4494' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042334' WHERE `Matrix_Unique_ID` = '213477068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:35:24.180' ,`MLSNumber` = '57398963' ,`ListAgentFullName` = 'Jamie Butler' ,`ListOfficeName` = 'Brighthouse Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.123095' ,`Longitude` = '-95.459585' ,`PhotoCount` = '44' ,`PostalCode` = '77380' ,`RoomCount` = '9' ,`ListPrice` = '379999.00' ,`Status` = 'Active' ,`StreetName` = 'Trestletree' ,`StreetNumber` = '86' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Updated 4 bedroom 2.5 bath home with 2 car garage on a Large Corner Lot located on a cul-de-sac in Grogans Mill. Gourmet island style kitchen features granite, gas cooking & stainless appliances. Home features high ceilings, open floor plan, fireplace, updated flooring, updated fixtures throughout, Roof Replaced in 2017, primary suite located on the first floor, features updated bath with granite, frameless shower & walk-in closet Texas Size Backyard with new fence, custom deck & storage shed ! Short distance to parks and school. Zoned to outstanding CISD schools. Low Tax rate. close proximity to shopping and entertainment. Easy access to the Houston park and ride, I45, Hardy toll, and Hwy 99.' ,`Acres` = '0.2412' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S972865 - WDLNDS VIL GROGANS ML 65, BLOCK 4, LOT 6' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '10505' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 65' ,`TaxAmount` = '5328' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042335' WHERE `Matrix_Unique_ID` = '213490235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:41:57.077' ,`MLSNumber` = '90064285' ,`ListAgentFullName` = 'Aurelio Diaz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.862970' ,`Longitude` = '-95.774632' ,`PhotoCount` = '34' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Birchwood Valley' ,`StreetNumber` = '23011' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1797' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Welcome home to 23011 Birchwood Valley Lane! This stunning 1,773 sqft single story home boasts 3 bedrooms (ALL BEDROOMS DOWN), 2 bathrooms, an elegant brick and stone elevation, and features beautiful upgrades throughout. Located in the master-planned community of Elyson, featuring a neighborhood swimming pool, splash pad, parks, trails, tennis courts, fitness center, the Elyson Cafe, event space, soccer field (coming soon), and much more all zoned to Katy ISD! The home is highlighted by a fantastic open floor plan, large master bedroom suite, granite countertops, stainless steel appliances, stunning finishes, and so much more. With an amazing location featuring easy access to 99 and I-10, and nearby shopping (Katy Mills and Houston Premium Outlets) and restaurants, this wonderful home has everything! Schedule your private showing today!' ,`Acres` = '0.1265' ,`Area` = '25' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 ELYSON SEC 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5511' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '9095' ,`TaxRate` = '3.5368' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042335' WHERE `Matrix_Unique_ID` = '213525497' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:02:16.010' ,`MLSNumber` = '64523318' ,`ListAgentFullName` = 'Haley Brenner' ,`ListOfficeName` = 'Realty Kings Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769240' ,`Longitude` = '-95.723631' ,`PhotoCount` = '41' ,`PostalCode` = '77450' ,`RoomCount` = '7' ,`ListPrice` = '394900.00' ,`Status` = 'Active' ,`StreetName` = 'Laurel Lock' ,`StreetNumber` = '20227' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2297' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This splendid 3-bedroom, 2-bathroom home in the highly sought-after community of Nottingham Country is ready to be yours! Loads of updates and custom touches throughout. Home features spacious family room w/ vaulted ceiling & stone fireplace, chef’s kitchen w/double ovens, quartz countertops w/mosaic tile backsplash, stainless steel appliances & adjacent breakfast area. Formal dining is located just off the kitchen & features floor to ceiling windows with plenty of space to make family dinners a delight. Dreamy primary bedroom has direct access to light filled sunroom for your evening enjoyment. Primary bedroom boasts ensuite bath w/double sinks, oversized shower w/frameless glass door and two walk-in closets. Other updates include double pane vinyl windows, PEX plumbing, sprinkler system, lighting on auto timers and plantation shutters. Vacation in your own backyard with covered patio, in-ground PebbleTec surfaced pool and recent tile. This home has it all! Must see!' ,`Acres` = '0.1716' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 7 NOTTINGHAM COUNTRY SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'NOTTINGHAM COUNTRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nottingham Country Sec 04' ,`TaxAmount` = '6198' ,`TaxRate` = '2.3693' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042335' WHERE `Matrix_Unique_ID` = '213538732' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:24:31.807' ,`MLSNumber` = '37974631' ,`ListAgentFullName` = 'Christina Limon' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.670818' ,`Longitude` = '-95.187870' ,`PhotoCount` = '31' ,`PostalCode` = '77502' ,`RoomCount` = '3' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Peach' ,`StreetNumber` = '2714' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1538' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Roof from 2012 and water pipes updated in 2016.' ,`Acres` = '0.1702' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 20 PARK VIEW MANOR SEC 5' ,`LotDesciption` = 'Other' ,`LotSize` = '7412' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FISHER ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park View Manor Sec 05' ,`TaxAmount` = '3579' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042335' WHERE `Matrix_Unique_ID` = '213569938' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:36:04.550' ,`MLSNumber` = '93428756' ,`ListAgentFullName` = 'Mariam Kadhim' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684706' ,`Longitude` = '-95.637339' ,`PhotoCount` = '34' ,`PostalCode` = '77083' ,`RoomCount` = '8' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Diamond Lake' ,`StreetNumber` = '8703' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Welcome home to 8703 Diamond Lake Court! This beautiful home is simply spectacular inside and out! Located on a cul-de-sac and highlighting an elegant tile entry, beautiful arches and rounded corners, 3 beautifully appointed bedrooms, a kitchen with granite countertops, a flex room that you can use as an office or game room, and incredible attention to detail throughout! This home has a HUGE backyard and a screened in back porch! With easy access to US59, I-10, and Westpark Tollway. Also, close to Sugar Land Town Center, parks, and riding trails.' ,`Acres` = '0.3303' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 KINGSBRIDGE PARK SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14390' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HICKS ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingsbridge Park' ,`TaxAmount` = '5188' ,`TaxRate` = '2.553' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042335' WHERE `Matrix_Unique_ID` = '213570203' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:01:40.037' ,`MLSNumber` = '32250144' ,`ListAgentFullName` = 'Tiffany Bean' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.558706' ,`Longitude` = '-95.432067' ,`PhotoCount` = '39' ,`PostalCode` = '77584' ,`RoomCount` = '9' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakmist Ridge' ,`StreetNumber` = '2905' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hurry Home to this stunning Perry home in the coveted Windy Shores community of Shadow Creek Ranch. Sitting on a corner lot, this 4/ 3.5 estate with an immaculate brick facade and manicured landscaping has everything you could want in a home. Upon entry, your eyes are drawn to the soaring ceilings, floor-to-ceiling windows, and sun-drenched interiors. The house is decked out with top-of-the-line finishes and appliances, freshly painted interiors, generous living spaces, an oversized walk-in pantry, and ample storage. \r\nPerfect for entertaining, the open floor plan flows beautifully from the grand dining room to the chef’s kitchen, equipped with sprawling countertops, to the breakfast nook and living area with panoramic views of the beautiful backyard. The private owner\'s suite, ensuite bathroom with double granite sinks, soaking tub, and glass-enclosed shower is the perfect place to rest after a long day.' ,`Acres` = '0.1599' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-58 REPLAT NO 1 FINAL PLAT, BLOCK 2, LO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6965' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-58 Rep 1 Final' ,`TaxAmount` = '9679' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042336' WHERE `Matrix_Unique_ID` = '213590053' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213595280','1666042336','213595280','2022-10-17T07:51:21.370','43298040','Ashley Day','Compass RE Texas, LLCHeights','','','29.787677','-95.400910','39','77008','7','775000.00','Active','Rutland','914','Street','Houston','2','0','3','2082','Single-Family','Picture Perfect Home in the Heights, featuring sizable lot with Front & Back Yard. Charming home lives large, featuring historical characteristics along with functional semi-open floor plan. Ample windows throughout, allowing for abundant natural light. Spectacular Kitchen. Primary Suite features recently remodeled Bath with separate tub and walk in shower. 2 spacious Secondary Bedrooms on main floor plus an upstairs bonus room, suitable for office, home gym, or media room. 2 Car Garage, accessed via alley, features bonus space room for overflow storage, workout or hobby room. Additional parking pad out front. Amazing Backyard features deck, turf, and ample space to entertain and play. Premier Block. Walkable to MKT, Heights Mercantile, White Oak, 11th Street, and the Hike and Bike Trail. Zoned to Harvard Elementary.','0.1222','9','','','','','No Disclosures','1','','1','Heights/Greater Heights','Central Gas','0','LT 25 & TR 26A BLK 233 HOUSTON HEIGHTS','Cleared','5324','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','HARVARD ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','2','Traditional','Houston Heights','14909','2.3307','Public Sewer,Public Water','1910','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:25:01.650' ,`MLSNumber` = '41932650' ,`ListAgentFullName` = 'Yvonne Cazares' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659507' ,`Longitude` = '-95.493751' ,`PhotoCount` = '50' ,`PostalCode` = '77096' ,`RoomCount` = '6' ,`ListPrice` = '536990.00' ,`Status` = 'Active' ,`StreetName` = 'Sanford' ,`StreetNumber` = '5927' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 5927 Sanford! This 3 bedroom/2.5 full bath home is one of the nicest in the area! Sellers took it down to the studs. Those recent (2022) structural/mechanical upgrades include: plumbing with PEX water lines, underground pipes, electric water heater, updated electrical & grounding, new electrical box, windows, roof & HVAC. french drain system, Majority of the home features gorgeous tile floors! The gourmet kitchen boasts beautiful light countertops, 36\"gas cooktop & stainless range hood. Living area is open, spacious, and bright. Separate dining area opens to kitchen and living room. The secondary rooms are spacious with plenty of storage in the closets. Primary suite features, tray ceiling, large walk-in closet, and lots of natural light. Large primary bath has double sinks, and huge shower with bench. Come see this beauty today!' ,`Acres` = '0.1708' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'E 34 FT OF LT 13 & W 28 FT OF LT 14 BLK 159 WESTBURY SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 05' ,`TaxAmount` = '5324' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666042336' WHERE `Matrix_Unique_ID` = '213633757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:56:54.283' ,`MLSNumber` = '90241916' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919048' ,`Longitude` = '-95.157921' ,`PhotoCount` = '13' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Mountain' ,`StreetNumber` = '13911' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Designer features throughout this stunning home located on a quiet cul-de-sac in Summerwood. Beautiful one-story feature a full brick exterior w/ stone accent. The open plan is perfect for entertaining. Upon entering, the foyer features a designer pendent and wainscoting. Off the foyer, the front room could be a formal dining room, living room or study. The kitchen features granite counters w/ a decorative tile backsplash & stainless-steel appliances including the refrigerator. Kitchen is open to an adjoining dining room & spacious family room w/ a 2-sided gas fireplace. The primary suite shares the 2-sided fireplace. A luxurious ensuite features dual sinks, separate shower & large soaking tub plus a generous walk-in closet. Two additional bedrooms share a hall bath. Home backs to a green space so no immediate back neighbors. Updates include fresh interior paint, new LVP and carpet. Community is located minutes from Lake Houston, Alexander Deussen Park & Dwight D Eisenhower Park.' ,`Acres` = '0.1589' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 51 BLK 1 SUMMERWOOD SEC 21' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6923' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '926' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood' ,`TaxAmount` = '5991' ,`TaxRate` = '2.8532' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042336' WHERE `Matrix_Unique_ID` = '213655693' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:11:36.357' ,`MLSNumber` = '53995160' ,`ListAgentFullName` = 'Barbara Provada' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740794' ,`Longitude` = '-95.333175' ,`PhotoCount` = '20' ,`PostalCode` = '77023' ,`RoomCount` = '11' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'Mckinney' ,`StreetNumber` = '4430' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1588' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gated, absolutely stunning home that has 3 wonderful bedrooms, 2 baths and new 2-car carport garage adn new storage area. This home is in wonderful Eastwood subdivision. The home offers a wonderful relaxing porch (22 x 9.5) with swing, for your morning coffee or tea and backyard for grilling. Gleaming hardwoods, fabulous gourmet kitchen with island and bar and huge dining area to have your many wonderful meals, stainless steel appliances, custom cabinets, and granite countertops. Large living area to just relax or watch your favorite program. Master bedroom, two primary bathrooms with huge shower, secondary primary bath has double sinks and tub/shower, which offers relaxing soaking tub. Two new carports/garage with huge storage storage unit (20 x 7). This home should be on your short list to see.' ,`Acres` = '0.1559' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 & TR 9A BLK 25 EASTWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastwood' ,`TaxAmount` = '6209' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042336' WHERE `Matrix_Unique_ID` = '213667825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:16:01.800' ,`MLSNumber` = '53666088' ,`ListAgentFullName` = 'Minerva Garza' ,`ListOfficeName` = 'Can-2 Realty' ,`SellingAgentFullName` = 'David Tello' ,`SellingOfficeName` = 'Lions Gate Realty' ,`Latitude` = '29.804410' ,`Longitude` = '-95.237810' ,`PhotoCount` = '33' ,`PostalCode` = '77013' ,`RoomCount` = '4' ,`ListPrice` = '225900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Debra' ,`StreetNumber` = '10912' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1317' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PROPERTY WAS CONVERT TO A 4PLEX EACH ROOM HAS SMALL AREA WITH KITCHEN AND FULL BATHROOM, THE 2 FRONT ROOMS HAS SMALL LIVING AREA DINING ROOM KITCHEN AND FULL BATHROOM, OUTSIDE 1/2 BATH FOR VISITORS, WITH A LARGE METAL CAR PORT, ON ALMOST A ACRE LAND' ,`Acres` = '0.8768' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'TR 8B BLK 2 (PR YR IMPS 2010-2012*0621940020019) WILSON L M' ,`LotDesciption` = 'Cleared' ,`LotSize` = '38193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OATES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Wilson L M Acres' ,`TaxAmount` = '2212' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042336' WHERE `Matrix_Unique_ID` = '213670494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T07:43:22.330' ,`MLSNumber` = '86817682' ,`ListAgentFullName` = 'Cody Scurlock' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.612672' ,`Longitude` = '-95.115449' ,`PhotoCount` = '48' ,`PostalCode` = '77059' ,`RoomCount` = '12' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Sterling Wood' ,`StreetNumber` = '4430' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3556' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 5-bedroom, 3.5-bath updated home that is situated at the back of a peaceful neighborhood and minutes away from the Bay Oaks Country Club! This exquisite home has so much to offer. Stepping in you are greeted with a grand foyer and beautiful chandelier. an office and the formal dining room are to the left and right of the entranceway. Make your way further into the home to see the amazing living room that offers a fireplace and tons of large windows to allow for natural light. The living area is also open to the stunning chef\'s kitchen that is complete with white marble countertops, a backsplash complementing the white cabinets, and stainless-steel appliances. As you tour the downstairs, you\'ll find the Master bedroom that offers s stunning updated bathroom and walk-in closet! Make your way up the wrought iron staircase to find the large game room and the other four bedrooms that offer an abundance of space!' ,`Acres` = '0.2135' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 PINE BROOK SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BROOKWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Brook Sec 11' ,`TaxAmount` = '9507' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042337' WHERE `Matrix_Unique_ID` = '213721595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T06:58:01.767' ,`MLSNumber` = '35254055' ,`ListAgentFullName` = 'Janell Johnson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.870730' ,`Longitude` = '-95.603344' ,`PhotoCount` = '10' ,`PostalCode` = '77041' ,`RoomCount` = '4' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Briarpine' ,`StreetNumber` = '12926' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Calling all investors! This distressed property sits on a corner lot in an ideal location close to the Energy Corridor, City Centre and easy access to Beltway 8 and 290! Established, quiet neighborhood perfect as long term rental or fix and flip. Recent solds (past 30 days) support an ARV of $405-$415! \r\nThis property has never flooded and is outside of the special flood hazard area. Areas of distress are due to indoor pets with the bulk of the repair cosmetic in nature.' ,`Acres` = '0.1615' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 3 MCKENDREE PARK SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7037' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mckendree Park Sec 02' ,`TaxAmount` = '7894' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042337' WHERE `Matrix_Unique_ID` = '213736400' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213743654','1666042337','213743654','2022-10-17T07:46:43.723','38030468','Belinda Gaines','Belinda Gaines Realty','','','29.406303','-95.054447','29','77568','7','345000.00','Active','Vanilla Sky','2630','Lane','Texas City','2','0','4','1795','Single-Family','Awesome 3/4 bedroom, 2 bath with open living and dining, water view in the back yard and sunlight all around. Home was built approximately 3 years ago and offers a variety of many amenities for family living and relaxation . Large back yard with community beach and swimming are just a few. Home is designed to enjoy the open floor plan throughout and provide more than adequate space for family enjoyment any time. Call now for an appointment This will not last long.','0.1577','33','','','','','Sellers Disclosure','','','','Texas City','Central Electric','1','LOT 25 BLK 1 LAGO MAR POD 5 SEC 1 (2021) ABST 11','Subdivision Lot','6869','Appraisal District','','1730','0','','2','','0','','','','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Lago Mar Pod 5 Sec 1','9536','3.5512','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213747650','1666042337','213747650','2022-10-17T07:33:00.943','69561201','San Juanita Mena','World Wide Realty','','','29.588949','-95.210493','0','77089','3','200599.00','Active','Gullwood','11622','Drive','Houston','2','0','3','1165','Single-Family','3 BEDROOM 2 BATH, PROPERTY IS BEING LEASED. PLEASE CALL AGENT FOR SHOWING.\r\n\r\nTHANK YOU FOR SHOWING,','0.0976','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Southbelt/Ellington','Central Electric','0','LT 38 BLK 3 HIGHLAND MEADOW SEC 2','Cleared','4251','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','41 - Pasadena','STUCHBERY ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','THOMPSON INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment','Appraisal District','1','Traditional','Highland Meadow Sec 02','4228','2.7255','Public Water','1983','Appraisal District'); --> New record created successfully