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-19T10:54:32.240' ,`MLSNumber` = '35643997' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292143' ,`Longitude` = '-94.812288' ,`PhotoCount` = '23' ,`PostalCode` = '77327' ,`RoomCount` = '2' ,`ListPrice` = '152999.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreline' ,`StreetNumber` = '129' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TINY HOME AVAILABLE! 2 bedrooms and 1 bathroom with amazing details! Gorgeous wood-like flooring extends throughout the home. Espresso cabinets and black appliances make the kitchen pop in a bright vaulted living area. Restroom has a walk in shower with a double vanity. Master bedroom is tucked away towards the back of the home with two closet spaces and built in drawers. Perfect home for families as it is a part of the AMAZING Tarkington School District! The PreserveOfTexas.com offers an outdoor atmosphere with tons of amenities: 4 pools, outdoor pavilion, splash pad, equestrian center, parks, natural lakes, fishing, and much more! You get access to all of these amenities! Easy seller terms.' ,`Acres` = '0.3056' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Heat Pump,No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CYPRESS LAKES, BLOCK 7 UNIT 2, LOT 415' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '13312' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Lakes' ,`TaxAmount` = '25' ,`TaxRate` = '1.6866' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700560' WHERE `Matrix_Unique_ID` = '188462479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:05:19.340' ,`MLSNumber` = '6634310' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816480' ,`Longitude` = '-95.784092' ,`PhotoCount` = '18' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Velvet Woods' ,`StreetNumber` = '2531' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Cherish unforgettable moments in this Briarwood Homes in Morton Creek Ranch. Resting on a green belt lot, this 4-sided brick home boasts no back neighbors, tile flooring, crown molding, faux wood blinds, a cast stone fireplace, a study with French doors, a sprinkler system, a wrought iron fence along the back, and a covered patio. Spend afternoons in the kitchen, fully equipped with granite countertops, a tile backsplash, a double oven, an oversized refrigerator, stainless steel appliances, 42” upper cabinets, and pendant lighting. Unwind in the primary suite, featuring dual vanities and a shower. Community residents enjoy a playground, splash pad, children’s play area, and a recreation center with a pavilion. Commuters enjoy easy access to I-10 and the Grand Parkway. Delve into premier shopping, dining, and entertainment at Katy Mills Mall and LaCenterra at Cinco Ranch. Schools are zoned to the Katy Independent School District. Call now to learn more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '598' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.39' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700560' WHERE `Matrix_Unique_ID` = '199788474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:04:13.883' ,`MLSNumber` = '94739037' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064094' ,`Longitude` = '-95.394889' ,`PhotoCount` = '10' ,`PostalCode` = '77373' ,`RoomCount` = '12' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Skerne Forest' ,`StreetNumber` = '2827' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Be amazed by this beautiful Briarwood Homes property in Bradbury Forest. Resting on a spacious lot, this 4-sided brick home features a premium elevation, no back neighbors, tile flooring, entry crown molding, faux wood blinds, a cast stone fireplace, a study, media room, dining room with French doors, full gutters, and covered patio. Impress your guests in the kitchen, fully equipped with granite countertops, a tile backsplash, stainless steel appliances, 42” upper cabinets, and pendant lighting. The tranquil primary suite boasts a walk-in closet, dual vanities, a drop-in tub, and a 42” separate shower. Commuters will love the close proximity to the Grand Parkway, the Hardy Toll Road, and I-45. Residents enjoy shopping and dining at the nearby Market Street and The Woodlands Mall, plus easy access to Bush Intercontinental Airport. Students attend the highly-acclaimed Spring ISD. Call today to book your private showing!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '544' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bradbury Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.12' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700560' WHERE `Matrix_Unique_ID` = '199924257' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:25:07.480' ,`MLSNumber` = '82902122' ,`ListAgentFullName` = 'Jordan Hogan' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472786' ,`Longitude` = '-94.593404' ,`PhotoCount` = '10' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '619880.00' ,`Status` = 'Active' ,`StreetName` = 'Cove' ,`StreetNumber` = '963' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CONSTRUCTION COMMENCEMENT DATE 3/28/22. Anticipated Construction Completion Date is July 31, 2022. This is an exceptional opportunity to purchase a brand new ocean side, custom beach villa that is a 30 second golf cart ride to the beach. This will make the perfect weekend getaway or a primary residence. The floor plan is wide open with vaulted ceilings, eat up kitchen island, 3 bedrooms, 3 bathrooms, incredible finishes, etc. IT WILL NOT LAST AT THIS PRICE.' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = 'TRI Contracting' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 11 LOT 20 BLK 4 STINGAREE COVE ADDN' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`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` = 'No Appointment Required' ,`SqFtSource` = 'Condo Documents' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Stingaree Cove' ,`TaxAmount` = '333' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663700560' WHERE `Matrix_Unique_ID` = '203813852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:24:56.247' ,`MLSNumber` = '80106504' ,`ListAgentFullName` = 'Jordan Hogan' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.441911' ,`Longitude` = '-94.663588' ,`PhotoCount` = '9' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '569880.00' ,`Status` = 'Active' ,`StreetName` = 'Selwyn Road' ,`StreetNumber` = '979' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CONSTRUCTION COMMENCEMENT DATE 3/28/22. Anticipated Construction Completion Date is July 31, 2022. This is an exceptional opportunity to purchase a brand new ocean side, custom beach villa that is moments from the beach. This will make the perfect weekend getaway or a primary residence. The floor plan is wide open with vaulted ceilings, eat up kitchen island, 3 bedrooms, 3 bathrooms, incredible finishes, etc. IT WILL NOT LAST AT THIS PRICE.' ,`Acres` = '0.1631' ,`Area` = '33' ,`BuilderName` = 'TRI Contracting' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 241 BLUE WATER ADDN #2' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '7105' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`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` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Blue Water 2' ,`TaxAmount` = '727' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700560' WHERE `Matrix_Unique_ID` = '203859593' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:31:28.840' ,`MLSNumber` = '38402506' ,`ListAgentFullName` = 'Jack Simmons' ,`ListOfficeName` = 'Allstar Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.377230' ,`Longitude` = '-95.497908' ,`PhotoCount` = '42' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Thunderbird' ,`StreetNumber` = '186' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a 3 bedroom, 3 full bath home, It is located on the 15th fairway. Beautiful view of the 15th green. Home is on a 17,000 SF lot. The garage has been converted to a 3rd bedroom, it is 19X17 with a full bath. Fenced backyard .' ,`Acres` = '0.3903' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S774000 - PANORAMA-THUNDERBIRD, LOT 186' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '17000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'A.R. TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Panorama-Thunderbird' ,`TaxAmount` = '4295' ,`TaxRate` = '2.4982' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700561' WHERE `Matrix_Unique_ID` = '207207349' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:35:33.393' ,`MLSNumber` = '92370881' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723321' ,`Longitude` = '-95.929675' ,`PhotoCount` = '15' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '392880.00' ,`Status` = 'Active' ,`StreetName` = 'Rustic Ruby' ,`StreetNumber` = '5407' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is under construction. This beautiful Lake Ridge Builders home in Vanbrooke could be your dream home. Resting on a cul-de-sac lot, this 4-sided brick home boasts a premium elevation, tile flooring, full gutters, a sprinkler system, and a covered patio. Whip up meals for guests in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Relax in the serene primary suite, featuring dual vanities, a 36” tub, and a separate shower. Community comforts include a playground, splash pad, pavilion with a fire pit, and a swimming pool with a lounge. Residents enjoy easy access to I-10 and the Grand Parkway. Nearby schools are zoned to Lamar Consolidated ISD. You don’t want to miss this home!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700561' WHERE `Matrix_Unique_ID` = '207756676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:35:05.113' ,`MLSNumber` = '79630171' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727478' ,`Longitude` = '-95.930457' ,`PhotoCount` = '19' ,`PostalCode` = '77423' ,`RoomCount` = '11' ,`ListPrice` = '403950.00' ,`Status` = 'Active' ,`StreetName` = 'Dew Crest' ,`StreetNumber` = '32626' ,`StreetSuffix` = 'Street' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is under construction. Feel at ease in this lovely Lake Ridge Builders home in Vanbrooke. Resting on a spacious lot, this 4-sided brick home boasts tile flooring, crown molding, faux wood blinds, cast stone fireplace, sprinkler systems, and a covered patio. Create new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Spend evenings relaxing in the primary suite featuring dual vanities, a 42” tub, and a separate shower. Community comforts include a playground, splash pad, pavilion with a fire pit, and a swimming pool with a lounge. Residents enjoy easy access to I-10 and the Grand Parkway. Nearby schools are zoned to Lamar Consolidated ISD. Arrange your private showing today – call now!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700561' WHERE `Matrix_Unique_ID` = '207762394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T11:22:29.000' ,`MLSNumber` = '64937223' ,`ListAgentFullName` = 'Kyle Ward' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.231156' ,`Longitude` = '-95.570920' ,`PhotoCount` = '13' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Levi' ,`StreetNumber` = '802' ,`StreetSuffix` = 'Bend' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home when you enter this home set on a large parcel of land occupying a peaceful street position.\r\n\r\nConstructed over two levels, this home enjoys abundant natural light and a layout designed for easy living and entertaining. \r\n\r\nThe ground floor incorporates a generously proportioned kitchen, welcoming living and dining room, guest powder room and laundry. The office boasts beautiful wooden custom built-in shelves and bookcases.\r\n\r\nUpstairs, you will find three dreamy bedrooms, a loft, and a bathroom. The master bedroom suite with walk-in closet, and spacious bathroom encourages relaxation.\r\n\r\nOther highlights of the property include central air, polished hardwood floors, quality fittings & fixtures and plentiful storage.\r\n\r\nWith transport, schools, shops, dining & leisure facilities within easy reach, this is the ideal place to call home.' ,`Acres` = '0.1262' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S406600 - DURANGO CREEK 01, BLOCK 2, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Durango Creek' ,`TaxAmount` = '4539' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700561' WHERE `Matrix_Unique_ID` = '209309700' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T11:14:52.650' ,`MLSNumber` = '59169855' ,`ListAgentFullName` = 'Lorannette Lewis' ,`ListOfficeName` = 'In Town Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819785' ,`Longitude` = '-95.430110' ,`PhotoCount` = '33' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '534900.00' ,`Status` = 'Active' ,`StreetName` = 'Balzy' ,`StreetNumber` = '3502' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Lisbon is one of Sandcastle Homes\' specialty floor plans. The functional layout features three bedrooms, two full baths, and one-half bath. In addition to the spacious bedrooms, the home boasts a large multi-purpose game room located on the second level. This home in particular will have a large backyard the whole family, including the furry relatives, can enjoy! Future residents can park either in their two-car garage or in their private driveway. The home is in the early stages of construction allowing potential homebuyers to select alternative finishes and/or upgrades. Move-In Ready December 2022!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Sandcastle Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 9, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4673' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric 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' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'East Judiway Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700561' WHERE `Matrix_Unique_ID` = '209906366' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T11:19:51.210' ,`MLSNumber` = '39315382' ,`ListAgentFullName` = 'Lorannette Lewis' ,`ListOfficeName` = 'In Town Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779777' ,`Longitude` = '-95.411959' ,`PhotoCount` = '35' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '569900.00' ,`Status` = 'Active' ,`StreetName` = 'Darling' ,`StreetNumber` = '5105' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Sandcastle Homes, the Bordeaux floor plan features a spacious living and dining area, with large windows filling up the home with tons of natural light! \r\n\r\nThe kitchen is highlighted by the quartz countertops, custom cabinets, and stainless-steel appliances. All of the bedrooms are located on the second floor with large walk-in closets. The Master Bedroom features a spa-like bath with a large shower and separate tub. The Bordeaux\'s large game room makes for the perfect flex space and provides plenty of storage with its built-in shelves. Come home and park in your attached 2-car garage or in your private driveway! \r\n\r\nThis home will be move-in ready in December 2022.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Sandcastle Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2, Blk 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700561' WHERE `Matrix_Unique_ID` = '210105016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:35:41.710' ,`MLSNumber` = '49426379' ,`ListAgentFullName` = 'Taunia Browning' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.101305' ,`Longitude` = '-95.651766' ,`PhotoCount` = '47' ,`PostalCode` = '77486' ,`RoomCount` = '3' ,`ListPrice` = '416000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 823' ,`StreetNumber` = '5610' ,`StreetSuffix` = '' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home on 2 acres with majestic oaks & fenced yard with pole barn , extra parking, shop, large covered porch. Kitchen has large beautiful Island and breakfast bar, Granite countertops in kitchen & bathrooms, glass door on both showers. Game room & office . Don\'t miss out on this one. It has it all!!' ,`Acres` = '2' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0020 S F AUSTIN TRACT 14A1J-14A1K (DIV 1) ACRES 2.' ,`LotDesciption` = 'Corner' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '4970' ,`TaxRate` = '1.6563' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700561' WHERE `Matrix_Unique_ID` = '210713398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:33:45.383' ,`MLSNumber` = '94261364' ,`ListAgentFullName` = 'Elizabeth Aguilar' ,`ListOfficeName` = 'Bayou Vista Realty, LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.551573' ,`Longitude` = '-95.519842' ,`PhotoCount` = '46' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '430000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Volterra Lake' ,`StreetNumber` = '2406' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a unique subdivision that has a beautiful lake in your back yard! Spacious two story home, with four bedrooms, 3 full baths and 1 half restroom. A modern kitchen with stone countertops. You can see the lake view from the kitchen, living room, master bedroom, upstairs second living room/flex room, and two upstairs bedrooms. Down stairs is a spacious dining room and breakfast area. Brick pillared back patio with deck that leads to lower deck for full contact onto the lake. You can go Kayaking, paddle boating, and have so much fun! Very tranquil views.\r\n\r\nPlease remove shoes upon entering the property. Please wear masks and use hand sanitizer located at the entry.' ,`Acres` = '0.1647' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE SHORE HARBOUR SEC 7, BLOCK 1, LOT 65' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '7174' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Lake Shore Harbour Sec 7' ,`TaxAmount` = '10499' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700562' WHERE `Matrix_Unique_ID` = '210855066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T11:58:35.993' ,`MLSNumber` = '82620824' ,`ListAgentFullName` = 'Chase Boeker' ,`ListOfficeName` = 'Marsae\'s Coastal Living Proper' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.453884' ,`Longitude` = '-94.631266' ,`PhotoCount` = '28' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue H' ,`StreetNumber` = '1962' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptionally floor-planned three-bedroom 3 and 1/2-bathroom Beachside home with second floor living and spectacular views of the Gulf of Mexico. The home offers an open floor plan with a large open kitchen and dining area as well as an additional study, and all this opens up to an oversize second floor patio with loads of seating and entertaining area for all friends and family. Large bedrooms that each have their own bathrooms offer superior comfort and entertaining potential. Loads of potential for modifications and reworking of the downstairs driveway area.' ,`Acres` = '0.1221' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 46 HI POINT BEACH ADDN' ,`LotDesciption` = 'Other,Water View' ,`LotSize` = '5317' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`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` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Hi Point Beach Add' ,`TaxAmount` = '5825' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700562' WHERE `Matrix_Unique_ID` = '210973454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:40:12.033' ,`MLSNumber` = '65260358' ,`ListAgentFullName` = 'Janet Davila' ,`ListOfficeName` = 'JD Realty Advisors, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.203237' ,`Longitude` = '-96.266109' ,`PhotoCount` = '35' ,`PostalCode` = '77437' ,`RoomCount` = '6' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Pierce' ,`StreetNumber` = '501' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors or owners this is a rare opportunity to buy this smart rental. Instead of paying duplex price you pay one home price and the garage apartment also has an additional 2 beds, 1 bath & garage parking. The main house is rented till January. Roof replaced2018 in main house, garage apartment was remodeled and owner sprayed new foam insulation in 2021, New refrigerator & stove in 2022 in apartment, remodeled bathroom in 2021 in apartment. Potentially pay off your investment in 9-10yrs.' ,`Acres` = '0.1607' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A20250 ABST.250 TRACT 82B, LOT 85' ,`LotDesciption` = 'Corner' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sanford Add' ,`TaxAmount` = '2869' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700562' WHERE `Matrix_Unique_ID` = '211104094' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:07:19.240' ,`MLSNumber` = '29201158' ,`ListAgentFullName` = 'Ray Faragher' ,`ListOfficeName` = 'Clearview Real Estate, LLC' ,`SellingAgentFullName` = 'Chanel Raesis' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '30.277631' ,`Longitude` = '-95.627797' ,`PhotoCount` = '38' ,`PostalCode` = '77316' ,`RoomCount` = '11' ,`ListPrice` = '1029000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Marys' ,`StreetNumber` = '11408' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful brand new home under construction within the sought after gated community of Grand Lake Estates.. Home has a very nice/functional open floor plan with 4 bedrooms (two are downstairs, and three are en-suites), four and a half baths, plus a study, formal dining, and game room, along with an oversize 3 car garage! Nice 1.89 acre lot has plenty of room for a pool and play area, and is located on a low traffic cul-de-sac with beautiful homes surrounding.\r\nGrand Lake Estates feeds in to the highly-rated Montgomery ISD; Keenan Elementary, Oak Hill Jr high, and Lake Creek High School. Community has beautiful lakes, a golf course, and a community park. Estimated completion is October of this year.' ,`Acres` = '1.83' ,`Area` = '39' ,`BuilderName` = 'KLH Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKE ESTATES 08, BLOCK 5, LOT 16, ACRES 1.830' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Wooded' ,`LotSize` = '79715' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lake Estates 08' ,`TaxAmount` = '1670' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700562' WHERE `Matrix_Unique_ID` = '211132778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:04:24.040' ,`MLSNumber` = '94811023' ,`ListAgentFullName` = 'Pat Dunaway' ,`ListOfficeName` = '4 B Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.798444' ,`Longitude` = '-95.103842' ,`PhotoCount` = '50' ,`PostalCode` = '77360' ,`RoomCount` = '7' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Crest' ,`StreetNumber` = '287' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNIQUE RETREAT! No exaggeration, this place is an eye catcher. If you love the outdoors,\r\nthis could be the perfect place for you with wrap around porch, porte-cochere/carport, pergola\r\nand 1.625 acres. Strategic styling makes this custom-built home a win-win for your permanent\r\nor vacation home. Study/library/lookout or escape room is accessed by a spiral staircase. Lots of\r\nwindows, efficient kitchen with dining area and open living room with fireplace. All bedrooms\r\nhave access to a porch or balcony with two being upstairs and two down. Picky owners have\r\nmade many repairs/additions. House and garage roof has been sealed, painted and 600 screws\r\nreplaced. Work bench and shelving added to garage. New kitchen faucets, instant hot water\r\nfixture, microwave, dishwasher and water softener with filter. Several doors replaced. Updated\r\nsprinkler system, Fireplace and whole house generator serviced with annual contracts. Boat\r\nlaunch is just steps away. Truly, A RARE FIND!' ,`Acres` = '1.625' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANDY SHORES LOT 10' ,`LotDesciption` = 'Water View' ,`LotSize` = '70785' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '30' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Sandy Shores' ,`TaxAmount` = '6268' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700562' WHERE `Matrix_Unique_ID` = '211257666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:07:35.557' ,`MLSNumber` = '97221797' ,`ListAgentFullName` = 'Saundra McCulloch' ,`ListOfficeName` = 'Longitude Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075923' ,`Longitude` = '-96.001180' ,`PhotoCount` = '42' ,`PostalCode` = '77446' ,`RoomCount` = '3' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Prospect Avenue' ,`StreetNumber` = '405' ,`StreetSuffix` = '' ,`City` = 'Prairie View' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tucked under the trees this brick home sits on a half acre lot in Prairie View. The Prairie Gables neighborhood is an established neighborhood just off Old Hwy 290, with quick access to Hwy 290 and Hwy 6....an easy commute whether your heading towards Brenham, College Station, Cypress or Katy. This 3 bedroom 1.5 bathroom home offers 1543 square feet with 2 living rooms and a sunroom. Tile flooring is found through most of the home. A 280 sf deck sits off the sunroom and adds additional outdoor living space for family gatherings and entertaining. The large lot is bordered by a beautiful hedgerow of shrubs. Two storage sheds will convey with the sale. Fruit bearing trees are found throughout including pecan, pear and fig trees. Although this home feels to be in the country, it actually has convenient city services, including trash pickup. The HVAC was installed in 2016 and the roof was installed in 2011 and many updates were done in 2013 and 2014.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Prairie Gables 1' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Prairie Gables' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700562' WHERE `Matrix_Unique_ID` = '211563328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:06:45.170' ,`MLSNumber` = '95992985' ,`ListAgentFullName` = 'Nancy Lawrence' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.488538' ,`Longitude` = '-95.482922' ,`PhotoCount` = '14' ,`PostalCode` = '75844' ,`RoomCount` = '2' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'Maple' ,`StreetNumber` = '602' ,`StreetSuffix` = 'Street' ,`City` = 'Grapeland' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This historical home built in the early 1900’s in downtown Grapeland, TX is a one-owner home and still has its original homestead feel. This two bedroom, one and one-half bath home is very spacious with tall ceiling. The first thing you see is the large living space and comfortable dining room, perfectly attached to the kitchen. Just off the kitchen, you will find the main living area/entertainment room. It once seems the porch continually wrapped around the house and in later years, the back porch was enclosed to gain more living space. The remaining wrap around porch in the front is still intact and really gives that early 19th century feel. Outside, you will enjoy two covered carports as well as 2 large storage sheds. This home sits on two lots of land, one of which was used for a home garden; it is now fenced and looking for some attention. For your private showing give us a call today!' ,`Acres` = '0.41' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Grapeland Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'J ERWIN AB 396 .41 AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '17860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '58 - Grapeland' ,`SchoolElementary` = 'GRAPELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAPELAND HIGH SCHOOL' ,`SchoolMiddle` = 'GRAPELAND JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '1506' ,`TaxRate` = '2.1104' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1902' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663700562' WHERE `Matrix_Unique_ID` = '211583832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T11:27:10.387' ,`MLSNumber` = '94244962' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841883' ,`Longitude` = '-95.859553' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '424990.00' ,`Status` = 'Active' ,`StreetName` = 'Newport Creek' ,`StreetNumber` = '901' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The San Francisco Plan houses 4 Bedrooms , 3.5 Bathrooms, Game Room, Study, Covered Outdoor Living Space + 2 Car Garage on a Waterview Lot! The Wide Open Great Space includes the Gourmet Island Kitchen, Spacious Casual Dining, Private Primary Suite offers Retreat Bath w/ His & Hers Vanities, Texas-sized Walk-in Shower. Upstairs has Game Room overlooking Family Room, 3 Bedrooms, and a Convenient Jack-N-Jill Bath and additional full bath . Wood Baluster Stairway, 2\" Blinds, Stainless Steel Appliances, Tile Flooring throughout the first floor, Security System, Full Gutters, Sprinkler System, Fully Sodded Yard + Landscaping Pkg all included! **HOME IS UNDER CONSTRUCTION. Photos are REPRESENTATIVE of the plan/layout and are not of the actual home. Selections, colors, and finishes will vary. For more info, contact Chesmar Homes in _SUNTERRA___ community. SEPTEMBER 2022 estimated completion.**' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 1 Block: 2 Section: 9' ,`LotDesciption` = 'Water View' ,`LotSize` = '6532' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700563' WHERE `Matrix_Unique_ID` = '211608509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T10:57:03.990' ,`MLSNumber` = '44493287' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.462294' ,`Longitude` = '-95.539745' ,`PhotoCount` = '6' ,`PostalCode` = '77318' ,`RoomCount` = '3' ,`ListPrice` = '99000.00' ,`Status` = 'Active' ,`StreetName` = 'Calendar' ,`StreetNumber` = '10021' ,`StreetSuffix` = 'Street' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1446' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'S946201 - WALNUT COVE 01, BLOCK 7, LOT 66,67,68, SERIAL 3306' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '83' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Walnut Cove 01' ,`TaxAmount` = '560' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700563' WHERE `Matrix_Unique_ID` = '211610054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T11:00:15.367' ,`MLSNumber` = '75284350' ,`ListAgentFullName` = 'Chalyris Burgos' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022006' ,`Longitude` = '-95.314709' ,`PhotoCount` = '30' ,`PostalCode` = '77338' ,`RoomCount` = '5' ,`ListPrice` = '288888.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Hall' ,`StreetNumber` = '7302' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2301' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the Ideal Home. Warm and Cozy, floor plan to accommodate the whole family. This beautiful two story home has 5 bedrooms and 3 dull bathrooms. On the first floors spacious areas like family room with a fireplace, formal dinning, breakfast area and a bedroom with a full bathroom ideal for visitors or a office room. Extended fence on the right side of the patio for more private space and a ground pool 18\' x 48\'\' with a salt water system filter and sand. Second floor have a huge primary suite with spacius bathroom and 2 waking closet. The house has another huge secondary bedroom. Plus two more rooms with close access to the bathroom. Laundry room is on the second floor for more convenient access. Everything on the house is well design for comfort. This neighborhood has many amenities for the whole family to enjoy, pool tennis court, soccer field and clubhouse. Great place to call them Home!!! Don\'t miss this opportunity!!!!!!!!!!!!!!!!!!' ,`Acres` = '0.1295' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 4 FOXWOOD SEC 7' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5642' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxwood Sec 07' ,`TaxAmount` = '5364' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700563' WHERE `Matrix_Unique_ID` = '211611012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T11:27:07.717' ,`MLSNumber` = '12095522' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014436' ,`Longitude` = '-95.414603' ,`PhotoCount` = '27' ,`PostalCode` = '77073' ,`RoomCount` = '5' ,`ListPrice` = '284990.00' ,`Status` = 'Active' ,`StreetName` = 'Sovereign Heights' ,`StreetNumber` = '22211' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Imperial Heights in Houston, TX! The Shannon Plan is a spacious 2-story home with 3 bedrooms, 2.5 bathrooms and a 2-car garage. This home has it all, including blinds and a FLEX ROOM on the first floor! With an open kitchen, dining, and family room, you\'ll love entertaining in this home! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances. Upstairs offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a separate tub and shower and walk-in closet. Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 4 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3244' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700563' WHERE `Matrix_Unique_ID` = '211612847' --> Updated record success