Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:25:32.643' ,`MLSNumber` = '90070815' ,`ListAgentFullName` = 'Paul King' ,`ListOfficeName` = 'Texas Land and Commercial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748050' ,`Longitude` = '-95.836365' ,`PhotoCount` = '46' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '2000000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow' ,`StreetNumber` = '26910' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRESTRICTED...+/-2.25 acre property, with fantastic custom built home, priced at land value; Outstanding opportunity for the live/work buyer, developer, or investor. Live in the home, and build your office; convert the home to office; start fresh with a complete redevelopment of the property, or live in the home and hold for investment. Property is a hard corner at the intersection of Katy Flewellen and Willow Ln. with over 400\' of frontage on Katy Flewellen, and 265\' on Willow Ln. Utilities are available from the neighboring MUD upon annexation.' ,`Acres` = '2.25' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0157 JAS CONNER, TRACT 11 (LT 1, 2), ACRES 2.3542' ,`LotDesciption` = 'Corner' ,`LotSize` = '102549' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jas Conner' ,`TaxAmount` = '14287' ,`TaxRate` = '1.942' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702136' WHERE `Matrix_Unique_ID` = '199659783' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:12:53.913' ,`MLSNumber` = '70619938' ,`ListAgentFullName` = 'Veronica Mullenix' ,`ListOfficeName` = 'Veronica Mullenix Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.793219' ,`Longitude` = '-95.820890' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '1295000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue A' ,`StreetNumber` = '1506' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2071' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Excellent location in the heart of Old Towne Katy! The only 1.3 acre lot with frontage on both Avenue A to the west and East Avenue on the east! See attached survey and map image. A beautiful update and renovation has been completed! See attached Amenities PDF. Property interior was renovated in 2020-2021 with commercial use in mind. Kitchen and baths updated, new windows throughout. Roof has been replaced. An application for rezoning for commercial use has been submitted to the City.' ,`Acres` = '1.3636' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 & N 1/2 OF LT 23 KATY OUTLOTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '59400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Katy Outlots' ,`TaxAmount` = '14248' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702136' WHERE `Matrix_Unique_ID` = '203730250' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:55:44.810' ,`MLSNumber` = '29061394' ,`ListAgentFullName` = 'Carla Abendshein' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.190657' ,`Longitude` = '-95.726465' ,`PhotoCount` = '39' ,`PostalCode` = '77355' ,`RoomCount` = '7' ,`ListPrice` = '318000.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '38234' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and see this lovely brick home nestled in the quiet neighborhood, Lakes of Magnolia. This home offers 4 bedrooms and 2.5 bathrooms and a highly coveted open concept layout. The primary suite is conveniently located on the first floor. Dual sinks in the primary bath with separate tub and shower, and an oversized walk-in closet. A half bath is located just off of the living area for easy access. Gorgeous granite countertops in the kitchen that overlooks the living area allowing the cook to be part of the fun. A new dog park is being constructed across the street. The neighborhood also offers a playground and a \r\nbeautiful lake with fountains to enjoy a day outside with the family and neighbors. Adjacent to the \r\nneighborhood sits the Magnolia baseball fields. So close to schools, hospitals, restaurants, and \r\nshopping, yet still outside of city limits. Easy access to 249 making a trip to Tomball a breeze. Grass Digitally enhanced to show potential.' ,`Acres` = '0.1745' ,`Area` = '15' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S666100 - LAKES OF MAGNOLIA, BLOCK 6, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7602' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Magnolia' ,`TaxAmount` = '3783' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702136' WHERE `Matrix_Unique_ID` = '207911777' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:15:32.190' ,`MLSNumber` = '68177224' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842583' ,`Longitude` = '-94.828097' ,`PhotoCount` = '5' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '413049.00' ,`Status` = 'Active' ,`StreetName` = 'Lakewood' ,`StreetNumber` = '15219' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! **LENNAR IS IN LAKES OF CHAMPIONS!!! The inviting single story Travertine II with Brick/Stone Elevation \"F\" floor plan from the Brookstone Collection by Lennar features a welcoming covered front porch and entry foyer, a formal dining room, kitchen with a walk-in pantry, an open breakfast room and family room that offers access to a covered rear patio, a game room, and a walk-in utility room. The master bedroom features and en suite master bathroom with dual sinks, separate shower and tub, and dual master closets. *HOME ESTIMATED TO BE COMPLETE, December, 2022*' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0004 BLK 004 LOT 005' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '518' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Champions Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702136' WHERE `Matrix_Unique_ID` = '208971553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:24:08.580' ,`MLSNumber` = '72604855' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342672' ,`Longitude` = '-95.590496' ,`PhotoCount` = '28' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '271325.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury' ,`StreetNumber` = '911' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Ridgeland floorplan - This beautiful 4 bedroom 2 bath home is a dream come true. Neutral gray 42\" cabinets with White North granite on the giant island located in the heart of the home. The open concept allows for entertaining and gathering in the family area with ceilings sloped up to 9\'. Your luxury vinyl flooring is laid in planks for a completely real wood look. Walls are Sherwin Williams Agreeable Gray and go with both beige and gray color schemes. The brick elevation is in a very light Oxford brick. The home is located on oversized corner lot to enjoy the outdoors to it\'s fullest. Such a plus since this is located less than a mile from Lake Conroe. A true steal in today\'s market.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7685' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702136' WHERE `Matrix_Unique_ID` = '209058248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:26:25.217' ,`MLSNumber` = '29162260' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342672' ,`Longitude` = '-95.590496' ,`PhotoCount` = '28' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '274990.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury' ,`StreetNumber` = '955' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Ridgeland floorplan - This beautiful 4 bedroom 2 bath home is a dream come true. Neutral gray 42\" cabinets with White North granite on the giant island located in the heart of the home. The open concept allows for entertaining and gathering in the family area with ceilings sloped up to 9\'. Your luxury vinyl flooring is laid in planks for a completely real wood look. Walls are Sherwin Williams Agreeable Gray and go with both beige and gray color schemes. The brick elevation is in a very light Oxford brick. The home is located on oversized corner lot to enjoy the outdoors to it\'s fullest. Such a plus since this is located less than a mile from Lake Conroe. A true steal in today\'s market.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6126' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702136' WHERE `Matrix_Unique_ID` = '209109875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:18:08.107' ,`MLSNumber` = '19738156' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682304' ,`Longitude` = '-95.831786' ,`PhotoCount` = '7' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '749900.00' ,`Status` = 'Active' ,`StreetName` = 'Dappled Glade' ,`StreetNumber` = '26127' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry. Formal dining room. Open family room with wall of windows and a wood mantel fireplace flows into kitchen and morning area. Kitchen features island and walk-in pantry, double wall oven and 5-burner gas cooktop. Secluded Primary suite with curved wall of windows. Primary bath includes corner garden tub, separate glass-enclosed shower, dual vanities and two deep walk-in closets. Game room with French doors. Mud room. Abundant closet and storage space. Extended covered backyard patio. Three-car garage.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Candela Lot 30, Blk 1, Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9730' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702136' WHERE `Matrix_Unique_ID` = '209652440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:21:48.153' ,`MLSNumber` = '26396212' ,`ListAgentFullName` = 'Michael Crider' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.128035' ,`Longitude` = '-95.814459' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Creek' ,`StreetNumber` = '25234' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quite the find in Hockley! Over 2 and a half acres of land with a 3 bedroom. 2 full bath home, large barn, huge work shop and detached garage. Another plus is the covered parking and plug for a motor home if you have one. Home has a covered front porch and back porch. Updated tile floors in entry & kitchen. Updated laminate floors in main living areas and bedrooms. Formal living area and large family connects to the updated kitchen. Kitchen features Granite counter tops, tile backsplash, new wood cabinet, updated hardware, light fixtures, faucet and sink, recent stainless steel dishwasher, stove and vent. Plenty of cabinet and counter space, plus a breakfast bar open to the family room. Makes for easy living and entertaining. Lots of possibilities with this property. Bring your imaginatation. Don\'t miss this great opportunity!' ,`Acres` = '2.697' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S433200 CLEAR CREEK FOREST 2 LOT 7 & RES B ACRES 2.697' ,`LotDesciption` = 'Wooded' ,`LotSize` = '117481' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Clear Creek Forest' ,`TaxAmount` = '4908' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702136' WHERE `Matrix_Unique_ID` = '209668457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:05:23.680' ,`MLSNumber` = '58756704' ,`ListAgentFullName` = 'Zuri Perez-Majul' ,`ListOfficeName` = 'Zuri Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.004629' ,`Longitude` = '-95.752587' ,`PhotoCount` = '25' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Leaf' ,`StreetNumber` = '15422' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2545' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 2 story home with 2 car detached garage. Home offers an open floor plan with the primary bedroom downstairs and en-suite bathroom featuring dual sinks, jetted tub, separate shower and large walk in closet. Kitchen offers stainless steel appliances, island, granite countertops and tile floors. Formal dining room with high ceilings. Upstairs you\'ll find a game room plus three additional spare bedrooms and a full bathroom. Half bathroom conveniently located downstairs for your guest. Never flooded, zoned to highly acclaimed schools within CFISD, within walking distance to the park, pool and rec center.' ,`Acres` = '0.1558' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 FAIRFIELD VILLAGE WEST SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6788' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1021' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Village West' ,`TaxAmount` = '6953' ,`TaxRate` = '2.616' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702137' WHERE `Matrix_Unique_ID` = '210134757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:36:47.590' ,`MLSNumber` = '68059625' ,`ListAgentFullName` = 'Lauren Allen' ,`ListOfficeName` = 'Rise Texas Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678078' ,`Longitude` = '-95.059422' ,`PhotoCount` = '32' ,`PostalCode` = '77571' ,`RoomCount` = '9' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Lomax' ,`StreetNumber` = '2203' ,`StreetSuffix` = 'Drive' ,`City` = 'Lomax' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS! This amazing custom home is nestled on just under 2 acres of land in the Lomax Community of La Porte, TX! This Community Features a Horse Riding Arena, 2 Newly Renovated Parks, Community Swimming Pool and just minutes from the Sylvan Beach! This home is a Tropical Paradise in the City with a Lagoon Style Pool & 8\' Waterfall (All Automated), Hot Tub w/ Stream, and a Huge Palapas For Amazing Shade! Outdoors A Rustic Storage Barn with Water and Electric is in the Back, Automatic sprinkler system, Many Fruit trees, and a Fish pond to enjoy from 3 Windows. This Home is a 3 Bedroom Home w/ a Home Office or Study that could be 4th Bedroom! Two HUGE Family Rooms! One Den features Hand Carved Custom Fireplace w/ Gas Logs and Tons of Windows to enjoy your Amazing Outdoor Views! Formal Dining Room and Breakfast Area Provide Plenty of Room for Entertaining indoors too! Whole Home Generator! Three Car Garage! 45\' x 15\' RV Carport with 50 amp and sewer hookup! Make your appointment today!' ,`Acres` = '1.7139' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lomax Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 GARAGE LOMAX GARDENS' ,`LotDesciption` = 'Corner' ,`LotSize` = '74658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lomax Gardens' ,`TaxAmount` = '7413' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702137' WHERE `Matrix_Unique_ID` = '210394127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:46:11.263' ,`MLSNumber` = '68830102' ,`ListAgentFullName` = 'Lisa Taylor' ,`ListOfficeName` = 'DBL Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.800292' ,`Longitude` = '-95.468460' ,`PhotoCount` = '24' ,`PostalCode` = '77320' ,`RoomCount` = '3' ,`ListPrice` = '184000.00' ,`Status` = 'Active' ,`StreetName` = 'Hilltop View' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Court' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this quiet, private subdivision tucked away in northeastern Huntsville offering an updated manufactured home on a spacious 3/4-acre lot. The home features 3 bedrooms, 2 full bathrooms, split plan, open concept kitchen/dining/living areas, bonus room/office, new real wood kitchen cabinets, woodburning fireplace, new expanded walk-in shower, new front porch, and one new added back porch. The .761-acre lot has several shade trees, a new backyard fence that would accommodate your pets perfectly. Quick and easy access to Highway 19; located a short drive from Trinity River access and Lake Livingston. Also, nearby is Sam Houston State University, public and private schools, medical facilities, shopping and restaurants.' ,`Acres` = '0.761' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CROWE ADDITION - SEC 2, BLOCK 1, LOT 15, ACRES 0.761' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '33149' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crowe Add' ,`TaxAmount` = '77' ,`TaxRate` = '1.7134' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702137' WHERE `Matrix_Unique_ID` = '210464980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:32:32.660' ,`MLSNumber` = '57307661' ,`ListAgentFullName` = 'Robyn Jones' ,`ListOfficeName` = 'NextHome Real Estate Place' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.478227' ,`Longitude` = '-95.504998' ,`PhotoCount` = '43' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekside Breeze' ,`StreetNumber` = '2191' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Almost new modern open-concept David Weekly Devon floor plan Cul de Sac home shows like a model w/ walls of windows filling home with sunlight & contemporary finishes throughout. Sun filled Kitchen has large granite island & breakfast bar for entertaining, stainless steel appliances, & crisp modern finishes. Dining Area features a new West Elm gold chandelier & opens to Family Room, sharing a wall of windows. New Plantation Shutters in Family Room & all others have blinds. First Floor Primary Bedroom features En Suite Bathroom w/ dual sinks, walk-in shower, soaking tub & large Walk-In Closet. 2nd Floor Game Room is open & airy overlooking Foyer through lovely wrought iron railing continuing from the staircase. Outdoor space consists of 2 perfectly sized side yards for someone who enjoys grilling or landscaping, but doesn\'t want to be burdened w/ upkeep & maintenance of a large yard. Garage & parking is accessed at back of home. Approx. 6 months old. 2 SIDE YARDS & NO BACKYARD.' ,`Acres` = '0.1475' ,`Area` = '38' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA SEC 27, BLOCK 3, LOT 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6427' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1229' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '1265' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702137' WHERE `Matrix_Unique_ID` = '210478567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:37:16.713' ,`MLSNumber` = '75639222' ,`ListAgentFullName` = 'David Haley' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.896991' ,`Longitude` = '-95.476885' ,`PhotoCount` = '22' ,`PostalCode` = '77088' ,`RoomCount` = '9' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Fair Forest' ,`StreetNumber` = '5718' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The house is a beautiful one-story three bedroom two bath with an open floor plan, recently remodeled. The property features updated flooring, paint, and granite countertop (kitchen, bathrooms, wt bar). The house has a new roof and new gutters. New AC coils, vents. New garage door, new mini blinds, new appliances, new toilettes, new garbage disposal, and new wet bar. The breakfast area has a built-in desk. House has nice size bedrooms. Master has a walk-in closet. House has storm windows, doors, and custom siding.' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 3 017*I5645955-006-003-019 INWOOD NORTH SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NITSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood North' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702137' WHERE `Matrix_Unique_ID` = '210572678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:06:49.120' ,`MLSNumber` = '21332081' ,`ListAgentFullName` = 'Kathryn Jean' ,`ListOfficeName` = 'TexasLife Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.152335' ,`Longitude` = '-95.026250' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '1389000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluewing Teal' ,`StreetNumber` = '4111' ,`StreetSuffix` = 'Court' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to exclusive Sunset Cove. This home was originally owned by the sales agent for Sunset Cove. He had the pick of any lot in the neighborhood and selected this prime location. The decks overlook the canal and can see both Galveston Bay and the Beach with southern winds all summer long. The boat house is extra long with a fish cleaning station, picnic area, floating dock for jet skis, fishing opportunities, etc. Underneath the home has so much room for entertaining - granite bar, enclosed TV, room for games, extra seating, outdoor shower, bathroom downstairs in the garage, etc. The kitchen, dining, living room, master bedroom and spare bedroom #1 all have amazing views of the water. There is a spacious bunkroom upstairs as well as coffee bar, loft with extra bed and oversized bathroom. A quick boat ride and you are in the open water. Gated community on Galveston Bay with neighborhood pool, tennis court, amenities. This home has it all - Welcome home to 4111 Bluewing Teal' ,`Acres` = '0.201' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNSET COVE (2005), ABST 121, BLOCK F, LOT 9, ACRES 0.201' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Waterfront' ,`LotSize` = '8754' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sunset Cove' ,`TaxAmount` = '25520' ,`TaxRate` = '2.2124' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702137' WHERE `Matrix_Unique_ID` = '210636278' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:01:15.837' ,`MLSNumber` = '73541419' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760031' ,`Longitude` = '-95.788133' ,`PhotoCount` = '35' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Saddlebrook' ,`StreetNumber` = '2907' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing location and RARE opportunity to own a Ranch style home on a stunning 1 ACRE property with beautiful trees in Katy! Formal living and dining room with wood floors, fireplace & crown moulding! Island kitchen features granite countertops, travertine tile backsplash, stainless steel appliances and plenty of cabinet space! Den opens to the kitchen breakfast area with huge windows to view the backyard oasis! Owners suite with double sinks, spa tub and separate shower! Spacious secondary rooms and a study(or 4th bedroom). Relax in this wonderful backyard with a sparkling pool, hot tub, an oversized covered patio, & outdoor kitchen! Sprinkler system covers entire property!! Country feel with Garden and 240’ deep water well(never had a water shortage)! Never Flooded! Just minutes away from shopping and dining at LaCenterra, easy access to Grand Pkwy and I-10 and zoned to award-winning Katy ISD schools!' ,`Acres` = '1' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '0262 I AND GN RY, TRACT 3B, ACRES 1.00, (127.91 X 310.57)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'I & Gn Ry' ,`TaxAmount` = '9067' ,`TaxRate` = '1.9045' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702137' WHERE `Matrix_Unique_ID` = '210894732' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:20:05.850' ,`MLSNumber` = '18654415' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342672' ,`Longitude` = '-95.590496' ,`PhotoCount` = '26' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '263350.00' ,`Status` = 'Active' ,`StreetName` = 'Faison' ,`StreetNumber` = '802' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This brand new floor plan has a large open great room with a \r\ngiant white granite island to coordinate with the 42\" \r\nCabinets. There is a covered patio for sunny days, and a small \r\nfront porch as well. The primary bedroom has a separate \r\nsoaking tub and walk in shower. The front of the home is a \r\nbeautiful brick and stone combination.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8339' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702138' WHERE `Matrix_Unique_ID` = '211127221' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:19:29.190' ,`MLSNumber` = '24486501' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342672' ,`Longitude` = '-95.590496' ,`PhotoCount` = '26' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '259325.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury' ,`StreetNumber` = '943' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Covered front and back porch, 60\" walk in shower in primary \r\nsuite, Grey 42\" Cabinets, coordinating countertops.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7370' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702138' WHERE `Matrix_Unique_ID` = '211127299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:22:14.403' ,`MLSNumber` = '28278816' ,`ListAgentFullName` = 'Sherry Williams' ,`ListOfficeName` = 'Bay City Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.982689' ,`Longitude` = '-95.973835' ,`PhotoCount` = '19' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = '7th' ,`StreetNumber` = '1320' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely historic home converted to commercial office space. All new plumbing, electrical, HVAC and roof in 2016. 33 solar panels on roof. New insulated vinyl siding and all new windows within the past 3 years. Huge lot with loads of parking. Bathrooms both upstairs and downstairs. Beautiful hardwood floors throughout all the main rooms.' ,`Acres` = '0.4304' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAY CITY ORIGINAL TOWNSITE, BLOCK 35, LOT 7-8 & E/2 LOT 9' ,`LotDesciption` = 'Corner' ,`LotSize` = '18750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Bay City Original Townsite' ,`TaxAmount` = '5202' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1928' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702138' WHERE `Matrix_Unique_ID` = '211237201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:28:14.520' ,`MLSNumber` = '9970210' ,`ListAgentFullName` = 'Justin Lee' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.629199' ,`Longitude` = '-96.277575' ,`PhotoCount` = '8' ,`PostalCode` = '75860' ,`RoomCount` = '3' ,`ListPrice` = '139999.00' ,`Status` = 'Active' ,`StreetName` = '9th' ,`StreetNumber` = '306' ,`StreetSuffix` = 'Avenue' ,`City` = 'Teague' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the last! This spacious two-one has been recently remodeled. The home boasts a huge back yard, living room fireplace, shower-tub combo, and large outdoor sitting area while only 1 block from the Teague Elementary School. Call today to schedule a showing!' ,`Acres` = '0.344' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OTS TEAGUE LOTS 3 & 4 BLK 19' ,`LotDesciption` = 'Other' ,`LotSize` = '14985' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '244 - Teague' ,`SchoolElementary` = 'TEAGUE ELEMENTARY SCHOOL (TEAGUE)' ,`SchoolHigh` = 'TEAGUE HIGH SCHOOL' ,`SchoolMiddle` = 'TEAGUE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Town/Teague' ,`TaxAmount` = '1764' ,`TaxRate` = '2.3478' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1926' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702138' WHERE `Matrix_Unique_ID` = '211342978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:09:45.740' ,`MLSNumber` = '41961681' ,`ListAgentFullName` = 'Geoffrey Hyatt' ,`ListOfficeName` = 'Greater Houston REP, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.907468' ,`Longitude` = '-95.642435' ,`PhotoCount` = '36' ,`PostalCode` = '77095' ,`RoomCount` = '3' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Crystal' ,`StreetNumber` = '8634' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 3-bedrooms home with plantation blinds throughout home, laminate Wood Floors downstairs. The kitchen features Granite Counter tops, large Island, Tile Backslash, and Upgraded Appliances. The double livingroom features a Two-Sided Fireplace and large windows for natural light.The back yard feature a large pool, gazebo and gives a wonderful oasis feel to come home and relax! Great Location Walking Distance To School & Shopping! Recent upgrades include: Pool Resurfacing, New Roof in last month, New Solar Screens on Windows, Newer HVAC, Newer Pool Heater, Newer Tankless Water Heater, Full Master Bath Remodel, New Garage Door Opener, Newer Kenmore Elite Appliances and more! So this home is literally ready to move in and start enjoying life worry free!' ,`Acres` = '0.1637' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 35 COPPERFIELD NORTHMEAD VLG 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '565' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Northmead Village' ,`TaxAmount` = '4952' ,`TaxRate` = '2.3216' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702138' WHERE `Matrix_Unique_ID` = '211390214' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:35:36.300' ,`MLSNumber` = '93173556' ,`ListAgentFullName` = 'Giannina Hadfield' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806829' ,`Longitude` = '-95.426488' ,`PhotoCount` = '43' ,`PostalCode` = '77008' ,`RoomCount` = '2' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = '23rd' ,`StreetNumber` = '1507' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Surrounded by new construction on all sides, this property is in a stellar location - walking distance to awesome restaurants, trails, and businesses (like Lowe\'s, Home Depot, Officemax) plus quick access to 610 loop, Hwy 290, Hwy 45. West 23rd Street is one of Shady Acres most gorgeous, widest, and walkable streets with sidewalks on both sides and no ditches. The 150\' x 60\' lot is absolutely stunning and features a nice lawn and large mature tree. Selling for lot value only. All measurements to be independently verified.' ,`Acres` = '0.2066' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 162C SHADY ACRES SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shady Acres Sec 02' ,`TaxAmount` = '9694' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702138' WHERE `Matrix_Unique_ID` = '211401157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:02:06.453' ,`MLSNumber` = '87108431' ,`ListAgentFullName` = 'Anthony Pham' ,`ListOfficeName` = 'Pearl Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685325' ,`Longitude` = '-95.364249' ,`PhotoCount` = '6' ,`PostalCode` = '77021' ,`RoomCount` = '3' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Mount Pleasant' ,`StreetNumber` = '3915' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Income producing property. Tenant is occupied. The house is located on a private street with only four houses. Within miles to Medical Center, museum district, NRG Center, University of Houston, Rice and Baylor College of Medicine, Texas Southern University and easy access to major freeway. The shopping center is located adjacent to the house and also for sale.' ,`Acres` = '0.1377' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 BIAMONTE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHIDBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Biamonte' ,`TaxAmount` = '1805' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702138' WHERE `Matrix_Unique_ID` = '211402616' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:19:07.603' ,`MLSNumber` = '97243984' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342672' ,`Longitude` = '-95.590496' ,`PhotoCount` = '6' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '254325.00' ,`Status` = 'Active' ,`StreetName` = 'Faison' ,`StreetNumber` = '810' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Ridgeland floorplan - A Beautiful open floor plan with giant island, 42\" Grey Cabinets, raised ceilings in the main living area. 4th bedroom has a window in the closet which could double as a great computer room or craft closet.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5794' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702139' WHERE `Matrix_Unique_ID` = '211429916' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:18:43.983' ,`MLSNumber` = '2808935' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342672' ,`Longitude` = '-95.590496' ,`PhotoCount` = '6' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Faison' ,`StreetNumber` = '806' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Conway floorplan - Two bedrooms down and two up. Grand granite island is surrounded by 42\" cabinets and become the heart of the home. Perched on a long lot this home is ideal for the person who enjoys the outdoor life.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6535' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702139' WHERE `Matrix_Unique_ID` = '211430166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T14:17:17.440' ,`MLSNumber` = '31700362' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342672' ,`Longitude` = '-95.590496' ,`PhotoCount` = '9' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '314215.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury' ,`StreetNumber` = '938' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Conway floorplan - Gorgeous 2 bedroom down, 2 bedroom up plan. Granite countertops, a grand island and 42\" cabinets make this a great place to make home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6284' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702139' WHERE `Matrix_Unique_ID` = '211431180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:22:50.643' ,`MLSNumber` = '55239802' ,`ListAgentFullName` = 'Gillus Blanchard' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.826951' ,`Longitude` = '-95.091455' ,`PhotoCount` = '8' ,`PostalCode` = '77360' ,`RoomCount` = '8' ,`ListPrice` = '217000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Bud' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom, 2 bath, 1 car, detached garage home, is tucked away in the waterfront community of Yaupon Cove, only a 2\r\nminute drive off of Lake Livingston! Why look any where else? When you enter this beauty, you will be greeted with a spacious\r\nopen concept living room that opens into the dining room, then graduates into the kitchen. Upon entry, you will also notice the\r\nunhindered light pouring into this space from every direction. The kitchen is graced with granite counter tops, tiled back\r\nsplash and ample cabinet space for all of your dishes. The hall bath features a granite singlee vanity, over-the-toilet cabinet\r\nand a full tub and shower combo. The master bath features a double vanity, trimmed with granite counter tops and fitted with\r\ndrawer space for storage. You will be pleased with your new home close to one of the most beautiful lakes in Texas! This\r\nproperty is being offered through TSAHC’s Hero Program.' ,`Acres` = '0.1894' ,`Area` = '44' ,`BuilderName` = 'Homes by Cooper' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'YAUPON COVE BLK 7 LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Cove' ,`TaxAmount` = '127' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702139' WHERE `Matrix_Unique_ID` = '211737573' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:48:47.397' ,`MLSNumber` = '28572578' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222485' ,`Longitude` = '-95.240223' ,`PhotoCount` = '15' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '260490.00' ,`Status` = 'Active' ,`StreetName` = 'Valley Ridge' ,`StreetNumber` = '14596' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT 1 STORY! Pretty Elevation with Front Porch! Spacious Family Room & Dining Area Are Conveniently Located Next to the Island Kitchen for Functionality - Also Great for Entertaining! Spacious Corner Walk-In Pantry & Espresso Colored Cabinetry! Privately Located Primary Suite Features Generously Sized Walk-In Closet & Lovely Bathroom with Oversized Shower! Convenient Indoor Utility Room! Home Automation System Included! Wonderful Community with Playground, Pool, Trails, Recreation Center, & Elementary School in Subdivision! MUST SEE!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S573305 - Harrington Trails 05A, BLOCK 5, Lot 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.42832' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702139' WHERE `Matrix_Unique_ID` = '211739044' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:53:55.083' ,`MLSNumber` = '49686762' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.951629' ,`Longitude` = '-95.509562' ,`PhotoCount` = '46' ,`PostalCode` = '77066' ,`RoomCount` = '11' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Brittany Park' ,`StreetNumber` = '6414' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3221' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love with this gorgeous 4-bedroom, 3.5-bathroom (2 upstairs) home in Cutten Green, which features a brick elevation, high ceilings, wood and tile flooring, crown molding, a fireplace, wet bar, large study, formal dining room, game room, and open great room. The sprawling backyard has plenty of room for outdoor recreation, complete with a patio and a detached garage with covered walkway. Spend time in the serene kitchen, which boasts quartz countertops, a tile backsplash, ample cabinet space, breakfast bar, and dining nook. The comfortable primary suite is fully equipped with a walk-in closet, dual vanities, soaking tub, and separate shower. Community comforts include a swimming pool, dog park, clubhouse, playgrounds, walking trails, nature parks, and tennis courts. Situated off Highway 249 and the Sam Houston Tollway, residents are minutes to Vintage Park, Willowbrook, and the North Oaks Shopping Center. Walking distance to schools in Klein ISD.' ,`Acres` = '0.2101' ,`Area` = '13' ,`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` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 15 017*C7917560-002-015-023 CUTTEN GREEN SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KLENK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cutten Green' ,`TaxAmount` = '6462' ,`TaxRate` = '2.5008' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702139' WHERE `Matrix_Unique_ID` = '211740905' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T15:57:46.020' ,`MLSNumber` = '89328166' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.259390' ,`Longitude` = '-95.506825' ,`PhotoCount` = '35' ,`PostalCode` = '77384' ,`RoomCount` = '7' ,`ListPrice` = '369645.00' ,`Status` = 'Active' ,`StreetName` = 'Westslope' ,`StreetNumber` = '2576' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in River\'s Edge in Conroe, TX - zoned to The Woodlands schools! The Poole floor plan is a spacious two-story home with 4 bedrooms, 2.5 baths, and 2-car garage. This home has it all - including blinds and a Texas-sized game room! The gourmet kitchen is sure to please with tons of COUNTER SPACE, 42\" cabinets, granite countertops, and center island! Enjoy the privacy and convenience of having the Owner\'s Suite on the first floor! Retreat to the Owner\'s Suite featuring a beautiful bay window, separate tub and shower, and spacious walk-in closet. Enjoy the great outdoors with full sod, sprinkler system, and a covered patio! Don\'t miss your opportunity to call River\'s Edge home, schedule a visit today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 5 Section 1' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5575' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River\'s Edge' ,`TaxAmount` = '' ,`TaxRate` = '3.34' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702140' WHERE `Matrix_Unique_ID` = '211741164' --> Updated record success