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-30T15:50:39.843' ,`MLSNumber` = '25946623' ,`ListAgentFullName` = 'Monica Montez' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822510' ,`Longitude` = '-95.414798' ,`PhotoCount` = '19' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '619900.00' ,`Status` = 'Active' ,`StreetName` = 'Fisher St' ,`StreetNumber` = '805-B' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Independent drive, first floor living, elevator capable, backyard, chef’s kitchen, grand master suite, large closet & game room. \r\nSpacious home with timeless architecture, thoughtful design, exquisite finishes, tastefully executed intricate craftsmanship. \r\nThis home is designed to a be hardworking, functional yet elegant show home. Let it showcase your lifestyle.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'TITAN HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 3, BLK 1' ,`LotDesciption` = 'Other' ,`LotSize` = '2364' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Mediterranean,Spanish,Traditional' ,`Subdivision` = 'Oak Park South' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704847' WHERE `Matrix_Unique_ID` = '202388412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:22:21.120' ,`MLSNumber` = '31645242' ,`ListAgentFullName` = 'Rayanna Eury' ,`ListOfficeName` = 'Gulf Coast Star Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.767815' ,`Longitude` = '-95.646155' ,`PhotoCount` = '11' ,`PostalCode` = '77414' ,`RoomCount` = '0' ,`ListPrice` = '324000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 201' ,`StreetNumber` = '36105' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION 3 LOTS plus a 20 ft wide BOAT RAMP!!! This fish camp is located within 2 minutes of the mouth of the Caney and ICW. Great bulkhead, house and yard are well kept. \"The Sugar Shack\" location is ready for you to make your dreams come true. Fishing and crabbing are fabulous!!! You can build your dream home or keep the fishing cabin or bring in RVs. There is room to do everything on these 3 lots. Minutes to Sargent beach for shelling, fishing or just a day relaxing. Restaurants and bait camps are close by. Come check this one out! Sunrises and sunsets are amazing...The house is being sold \"AS IS\"' ,`Acres` = '0.3616' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'DOWNEY CANEY CREEK SEC 3, BLOCK 6, LOT 104-106' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '15751' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Downey Caney Creek Sec 3' ,`TaxAmount` = '4508' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704848' WHERE `Matrix_Unique_ID` = '203451980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:07:54.473' ,`MLSNumber` = '26340920' ,`ListAgentFullName` = 'Yvonne Chatelain' ,`ListOfficeName` = 'Sunrise Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.390933' ,`Longitude` = '-95.116146' ,`PhotoCount` = '39' ,`PostalCode` = '77517' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine' ,`StreetNumber` = '14312' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '8000 SQUARE FOOT, 2 STORY, BOTTOM IS ALL OPEN (4000 SQUARE FEET). UPSTAIRS HAS 4 BEDROOMS, 2BATHS, ETC. NOT COMPLETE. FINISH OUT TO YOUR TASTE. NO ELECTRIC TIED IN. No water tied in. PROPERTY IS 2 ACRES AND HAS A 18X21 SECOND BLDG. ON THE PROPERTY. Sales price is $245,000.' ,`Acres` = '2.009' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 604 I & G N RR SUR SEC 16 PT OF LOT B (2-3) BLK 72 ANGE' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '87512' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Barndominium' ,`Subdivision` = 'Angell-Runge Add' ,`TaxAmount` = '3729' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'No Sewer,No Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704848' WHERE `Matrix_Unique_ID` = '205347793' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:25:51.697' ,`MLSNumber` = '25260692' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = 'Jeffrey Kastendieck' ,`SellingOfficeName` = 'RE/MAX Universal' ,`Latitude` = '30.292474' ,`Longitude` = '-95.413140' ,`PhotoCount` = '12' ,`PostalCode` = '77301' ,`RoomCount` = '15' ,`ListPrice` = '409990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cypress Canyon' ,`StreetNumber` = '1811' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Step into this beautiful Lake Ridge Builders home in Barton Creek Ranch. This 3-sided brick home boasts a premium elevation, tile flooring, wrought iron spindles, faux wood blinds, full gutters, and a covered patio. Cook up new cuisines 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. Located just off I-45, commuters enjoy a direct route to Downtown Houston and the Galleria. The community is only minutes away from The Woodlands Mall, Market Street, and the Cynthia Woods Mitchell Pavilion. Schools are a part of the highly-acclaimed Conroe ISD. Don’t wait – arrange your private showing today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`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` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barton Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704848' WHERE `Matrix_Unique_ID` = '207717718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:23:25.763' ,`MLSNumber` = '21541032' ,`ListAgentFullName` = 'Currie Luedecke' ,`ListOfficeName` = 'Leyco Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707268' ,`Longitude` = '-96.540711' ,`PhotoCount` = '11' ,`PostalCode` = '78934' ,`RoomCount` = '1' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Milam' ,`StreetNumber` = '1024' ,`StreetSuffix` = 'Street' ,`City` = 'Columbus' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '4620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is a rare find! 1st floor offers many possibilities to become any business model desired. This property offers large areas sectioned off from one another, allowing you to create a work flow that works best for you and your business. The back section of the building has the possibility of being turned into a multilevel space. The second floor is a one bedroom apartment with a roof top deck that is currently occupied and has been for a number of years by the same tenant. The pictures depict how the property would look vacant since it is currently occupied. *Square footage is per the owner.' ,`Acres` = '0.06' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 9 LT PT 5 COLUMBUS & BLDG-D/B/A COLUMBUS HEALTH & FITNES' ,`LotDesciption` = 'Other' ,`LotSize` = '2614' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Columbus' ,`TaxAmount` = '3288' ,`TaxRate` = '1.8359' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1895' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704848' WHERE `Matrix_Unique_ID` = '207769218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:29:37.810' ,`MLSNumber` = '9087847' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.200333' ,`Longitude` = '-95.338417' ,`PhotoCount` = '33' ,`PostalCode` = '77302' ,`RoomCount` = '18' ,`ListPrice` = '619934.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor Trail' ,`StreetNumber` = '18107' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VII, Elevation B) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Family room, formal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Extended covered rear patio and attached 2-car garage. Artavia, a master-planned community, will thrill you with endless possibilities just minutes from your home in Conroe, Texas. You’ll enjoy wide, outdoor spaces great for an active lifestyle and its convenient location. Onsite school is currently under construction! Stop by the Westin Homes model home today to find out more about Artavia!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 27 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7717' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704848' WHERE `Matrix_Unique_ID` = '207953975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:18:08.177' ,`MLSNumber` = '61372770' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Kay Eastland' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.200970' ,`Longitude` = '-95.337590' ,`PhotoCount` = '30' ,`PostalCode` = '77302' ,`RoomCount` = '17' ,`ListPrice` = '624463.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Berry Brook' ,`StreetNumber` = '15024' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, Family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. Artavia, a master-planned community, will thrill you with endless possibilities just minutes from your home in Conroe, Texas. You’ll enjoy wide, outdoor spaces great for an active lifestyle and its convenient location. Onsite school is currently under construction! Stop by the Westin Homes model home today to find out more about Artavia!' ,`Acres` = '0.2086' ,`Area` = '19' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7873' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704848' WHERE `Matrix_Unique_ID` = '207962947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:10:13.083' ,`MLSNumber` = '11336503' ,`ListAgentFullName` = 'Shayna Andrews' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789935' ,`Longitude` = '-95.462444' ,`PhotoCount` = '16' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '1325000.00' ,`Status` = 'Active' ,`StreetName` = 'Little Caprese' ,`StreetNumber` = '7503' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction well underway in gorgeous gated community Ravenna with 77\' Resort Style Pool, Club House, and oversized Dog Park. Central Spring Branch location with easy access to I-10 and the Loop 610, just 2.5 miles to Memorial Park, zoned to Memorial High School, and less than one mile away from The Awty International School. Corner lot offers loads of natural light and first floor living spaces with 12\' ceiling height. Home features a first-floor bedroom with full bath that can be used as a study. The fenced in yard is ample, ~ 20’ x 25\'. Three-car garage has storage overhead. The 2nd floor has primary plus two oversized secondary bedrooms as well as a large game room. Gorgeous neutral selections accentuate any décor. Home is slated to be completed by year-end 2022. Luxurious lifestyle in a vibrant lock-and-leave neighborhood. Elevator to be installed.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'Ravenna Building Gro' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 5 RAVENNA AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5521' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3447' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Ravenna' ,`TaxAmount` = '5078' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704848' WHERE `Matrix_Unique_ID` = '208224740' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:14:17.233' ,`MLSNumber` = '86902739' ,`ListAgentFullName` = 'Randy Hodde' ,`ListOfficeName` = 'Hodde Real Estate Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.158397' ,`Longitude` = '-96.391121' ,`PhotoCount` = '17' ,`PostalCode` = '77833' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Tom Dee' ,`StreetNumber` = '1306' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic brick home with a beautifully manicured lawn on a quiet street in the heart of Brenham. The home boasts ±2074 sq. ft., 2 bedrooms, 2 baths, spacious living area with bay windows and fireplace, formal dining room, kitchen with large breakfast area, craft/hobby room and oversized three car garage. The home has been immaculately maintained and sits on a roomy ±0.266 acre lot with mature trees that shade the entire back yard area.' ,`Acres` = '0.2661' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WHITEHEAD PLACE, LOT ALL 12 & N PT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11593' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Whitehead Place' ,`TaxAmount` = '4178' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704848' WHERE `Matrix_Unique_ID` = '208337276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:17:26.240' ,`MLSNumber` = '2481051' ,`ListAgentFullName` = 'Wei Fang' ,`ListOfficeName` = '3H Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.646437' ,`Longitude` = '-95.547628' ,`PhotoCount` = '7' ,`PostalCode` = '77031' ,`RoomCount` = '8' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Millbanks' ,`StreetNumber` = '12215' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.184' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 13 GLENSHIRE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '513' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenshire Sec 03' ,`TaxAmount` = '4831' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704849' WHERE `Matrix_Unique_ID` = '208470003' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:26:48.480' ,`MLSNumber` = '22027331' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.894912' ,`Longitude` = '-95.075550' ,`PhotoCount` = '15' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '345990.00' ,`Status` = 'Active' ,`StreetName` = 'Alaska Cedar' ,`StreetNumber` = '702' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious CastleRock \"Creede\" 1 story home with 4 bedrooms. Covered patio, granite countertops in the kitchen, 42\" cabinets, High ceilings, large island in the kitchen and vinyl plank flooring. July Completion' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 5 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6706' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.6256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704849' WHERE `Matrix_Unique_ID` = '208648758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:09:05.687' ,`MLSNumber` = '28507641' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.960004' ,`Longitude` = '-95.196757' ,`PhotoCount` = '27' ,`PostalCode` = '77346' ,`RoomCount` = '17' ,`ListPrice` = '659867.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ruellia Field' ,`StreetNumber` = '16707' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, Family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '0.2012' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8765' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '2351' ,`TaxRate` = '3.5373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704849' WHERE `Matrix_Unique_ID` = '208746015' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:00:38.110' ,`MLSNumber` = '42123329' ,`ListAgentFullName` = 'Jo Ann Holba' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.939613' ,`Longitude` = '-96.260194' ,`PhotoCount` = '10' ,`PostalCode` = '77418' ,`RoomCount` = '8' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak' ,`StreetNumber` = '951' ,`StreetSuffix` = 'Street' ,`City` = 'Bellville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Rare Find! A very special and unique 3 bedroom 2.5 bath on 1.24 gorgeous acres. Beautiful shade trees front and back, circular drive in front and located in a fantastic neighborhood with all city conveniences. The spacious living rooms opens to country views in back. Also includes a study, large dining room with built-ins and a 3-car garage. One family has owned the home. It\'s a show stopper!' ,`Acres` = '1.24' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST A073 J NICHOLS' ,`LotDesciption` = 'Other' ,`LotSize` = '54014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'None' ,`TaxAmount` = '7997' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704849' WHERE `Matrix_Unique_ID` = '209010843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:30:43.147' ,`MLSNumber` = '20484906' ,`ListAgentFullName` = 'YoLanda Fultz' ,`ListOfficeName` = 'Fultz Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145313' ,`Longitude` = '-96.392327' ,`PhotoCount` = '27' ,`PostalCode` = '77833' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Valley' ,`StreetNumber` = '2410' ,`StreetSuffix` = 'Drive' ,`City` = 'Brenham' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled away in an established neighborhood, this 5 bedroom and 3 bath home sits on a large lot with a canopy of mature trees. The charming home welcomes anyone who walks through the door with it\'s warm colors and cozy features such as the wood-burning fireplace, large bay window and vinyl wood flooring. The primary bedroom is downstairs along with two other bedrooms and two baths decorated with granite countertops, custom cabinetry and tile flooring. The living space opens to a cozy, eating area adjacent to the kitchen that has a subway-tile backsplash, granite countertops and custom cabinetry. Upstairs, there are two more large bedrooms and a full bath with the same decor features. The backyard is completely fenced and large enough for entertaining by the firepit or cooking on the patio. This home is so close to all that Brenham has to offer including a range of dining, entertainment and shopping all while still having a small town feel. Short drive to Houston.' ,`Acres` = '0.2288' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTH PARK SEC II , LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9965' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Park Sec II' ,`TaxAmount` = '4259' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704849' WHERE `Matrix_Unique_ID` = '209334893' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:21:06.333' ,`MLSNumber` = '14628589' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.204667' ,`Longitude` = '-95.338399' ,`PhotoCount` = '33' ,`PostalCode` = '77302' ,`RoomCount` = '18' ,`ListPrice` = '619834.00' ,`Status` = 'Active' ,`StreetName` = 'Misty Brook' ,`StreetNumber` = '17794' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VII, Elevation B) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Family room, formal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Extended covered rear patio and attached 2-car garage. Artavia, a master-planned community, will thrill you with endless possibilities just minutes from your home in Conroe, Texas. You’ll enjoy wide, outdoor spaces great for an active lifestyle and its convenient location. Onsite school is currently under construction! Stop by the Westin Homes model home today to find out more about Artavia!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7530' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704849' WHERE `Matrix_Unique_ID` = '209688913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:46:56.057' ,`MLSNumber` = '79153156' ,`ListAgentFullName` = 'Jacqueline Short' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.917545' ,`Longitude` = '-96.880661' ,`PhotoCount` = '42' ,`PostalCode` = '78945' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Jefferson' ,`StreetNumber` = '1152' ,`StreetSuffix` = 'Street' ,`City` = 'La Grange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1472' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.48' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HIGHSMITH LOT 1 0.4837 HSE, GAR, SHED' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '205 - La Grange' ,`SchoolElementary` = 'HERMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA GRANGE HIGH SCHOOL' ,`SchoolMiddle` = 'LA GRANGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = '.' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704849' WHERE `Matrix_Unique_ID` = '209700732' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:28:02.940' ,`MLSNumber` = '84309591' ,`ListAgentFullName` = 'Ashley Diep' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395114' ,`Longitude` = '-95.619643' ,`PhotoCount` = '16' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Nottingham' ,`StreetNumber` = '3429' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1938' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Check out video tour!* \r\nWelcome in!! For rent/sale. This home comes fully furnished. As you enter the home you are welcomed by the open spaced living room and kitchen. The wrap around kitchen bar and granite kitchen island gives you so much space to cook. All the appliances are also included.\r\nYou have no left and backdoor neighbors! Enjoy a cup of coffee on the patio in the mornings before you hit the lake! At lake conroe you can come to relax, fish, and boat. Sam Houston Forest envelopes on the north shore and there you can find miles of hiking and biking trails\r\nMake your vacation your staycation. Walden has an 18 hole Golf Course that is annually ranked as one of Texas’ top ten courses by Dallas Morning News. Enjoy NOT ONLY for the challenging course but also for the SPECTACULAR views. In addition to this, Walden residents can enjoy a 16 court tennis facility, Olympic sized swimming pools, a Rec center and their own boat ramp with watercraft rentals.' ,`Acres` = '0.1884' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S945518 - WALDEN 18, BLOCK 4, LOT 110' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8205' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 18' ,`TaxAmount` = '5060' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704850' WHERE `Matrix_Unique_ID` = '209731011' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:41:46.017' ,`MLSNumber` = '96283972' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.438189' ,`Longitude` = '-95.490902' ,`PhotoCount` = '27' ,`PostalCode` = '77378' ,`RoomCount` = '7' ,`ListPrice` = '294990.00' ,`Status` = 'Active' ,`StreetName` = 'Briana Brook' ,`StreetNumber` = '13636' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in South Meadows in Willis, TX! Conveniently located less than a mile from I-45, South Meadows enjoys a low property tax rate AND close proximity to Lake Conroe, The Woodlands and Huntsville! The Briscoe floor plan is a two-story home with soaring ceilings in the foyer! Complete with 4 bedrooms, 2.5 baths, game room, and 2-car garage. The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances. 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, garden tub and shower, and a walk-in closet. Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call South Meadows home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 49 Blk. 2 Sec.1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4478' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.57' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704850' WHERE `Matrix_Unique_ID` = '209949879' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:02:19.107' ,`MLSNumber` = '92842056' ,`ListAgentFullName` = 'Trinh Tran' ,`ListOfficeName` = 'Aimpro Realty & Management LLC' ,`SellingAgentFullName` = 'Rohit Mathews' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.529583' ,`Longitude` = '-95.733045' ,`PhotoCount` = '20' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '274000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Butterfly' ,`StreetNumber` = '803' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This oversized corner lot home is a great buy! Extensive tile & laminate floors ( NO CARPET)* 4 Bedrooms * Front & Rear Porch! Recent upgrade granite kitchen counter tops.' ,`Acres` = '0.232' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER RUN AT THE BRAZOS SEC 1, BLOCK 4, LOT 14' ,`LotDesciption` = 'Corner' ,`LotSize` = '10104' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'River Run At The Brazos Sec 1' ,`TaxAmount` = '5342' ,`TaxRate` = '2.7148' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704850' WHERE `Matrix_Unique_ID` = '210271477' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:27:08.337' ,`MLSNumber` = '90037558' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893668' ,`Longitude` = '-95.075456' ,`PhotoCount` = '22' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '380990.00' ,`Status` = 'Active' ,`StreetName` = 'Alberta Spruce' ,`StreetNumber` = '14307' ,`StreetSuffix` = 'Lane' ,`City` = 'Crosby' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The roomy Concho plan claims five bedrooms, four bathrooms, and an upstairs game room!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.6256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704850' WHERE `Matrix_Unique_ID` = '210292871' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:23:03.330' ,`MLSNumber` = '89544950' ,`ListAgentFullName` = 'Gina McDaniel' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.060945' ,`Longitude` = '-95.131158' ,`PhotoCount` = '24' ,`PostalCode` = '75845' ,`RoomCount` = '5' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = '4th' ,`StreetNumber` = '524' ,`StreetSuffix` = 'Street' ,`City` = 'Groveton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The large five bedroom, three bath, two-story home with a welcoming front porch is within walking distance to Groveton schools and it will impress you as you step in the front door with a living room that offers high ceilings, a fireplace, and pretty view of the stairway. The eat-in kitchen has an abundance of cabinets, a large center island, double ovens, and window that overlooks the pool. In addition to the large open living area downstairs, you will also enjoy a spacious primary ensuite with four closets, a private entrance to the back deck, double vanity, and an oversized tub with jets, as well as a second bedroom and bath, and utility room/mud room that opens to the pool. Upstairs, you will find three additional bedrooms, and a third bathroom, plus a bonus room that could be an office or additional living area. The yard is filled with mature pecan and oak trees that provide beautiful shade, a two-car garage, barn, and livestock pen that would be great for an ag project.' ,`Acres` = '1.272' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Groveton Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GROVETON, CITY OF, BLOCK 39 LOT 7' ,`LotDesciption` = 'Other' ,`LotSize` = '55408' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '4642' ,`TaxRate` = '2.4366' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704850' WHERE `Matrix_Unique_ID` = '210368020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:55:59.060' ,`MLSNumber` = '66919027' ,`ListAgentFullName` = 'Hester Bell' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080754' ,`Longitude` = '-94.156155' ,`PhotoCount` = '41' ,`PostalCode` = '77707' ,`RoomCount` = '5' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Caldwood' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4142' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled, perfectly blending elegance with functional living space. Excellent floor plan with 4 bedrooms downstairs, each with its own full bath, and 1 master suite upstairs on a separate wing. Open living, brand new kitchen & dining with plenty of space for social gatherings.\r\nLocated in a friendly, upscale neighborhood with circular driveway in the front, large backyard with swimming pool and outdoor kitchen that is perfect for private parties and entertaining. Gorgeous master suite with fireplace, and modern en-suite bathroom connecting to the sprawling, walk-in his & her closet rooms .\r\nThis modern home features all-new basics from flooring, electrical to energy efficient lighting, along with stainless-steel appliances, granite counters, coffee bar, custom cabinets, and a wine room in the kitchen with a huge breakfast nook. The living and dining rooms get plenty of natural sunlight via wall-to-wall glass windows overlooking the vast front yardandthepool,respectively.' ,`Acres` = '0.84' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 7 Block 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CALDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'ODOM MIDDLE SCHOOL' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Caldwood' ,`TaxAmount` = '11688' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704850' WHERE `Matrix_Unique_ID` = '210463274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:12:37.870' ,`MLSNumber` = '70290742' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Luis Rivas' ,`SellingOfficeName` = 'World Wide Realty' ,`Latitude` = '30.203310' ,`Longitude` = '-95.336595' ,`PhotoCount` = '28' ,`PostalCode` = '77302' ,`RoomCount` = '17' ,`ListPrice` = '629832.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Misty Brook' ,`StreetNumber` = '17807' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. Artavia, a master-planned community, will thrill you with endless possibilities just minutes from your home in Conroe, Texas. You’ll enjoy wide, outdoor spaces great for an active lifestyle and its convenient location. Onsite school is currently under construction! Stop by the Westin Homes model home today to find out more about Artavia!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8150' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704850' WHERE `Matrix_Unique_ID` = '210573702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:16:25.120' ,`MLSNumber` = '34767961' ,`ListAgentFullName` = 'Ruksanah Pirani' ,`ListOfficeName` = 'Hometrust Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.677697' ,`Longitude` = '-95.646785' ,`PhotoCount` = '50' ,`PostalCode` = '77083' ,`RoomCount` = '13' ,`ListPrice` = '509000.00' ,`Status` = 'Active' ,`StreetName` = 'Ravenscroft' ,`StreetNumber` = '14702' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home in a super clean condition on a cul de sac lot. Gorgeous front facade. Bright, cozy, well connected, good sized living spaces, nice big windows, lots of natural light, lovelychandeliars, and bay window in breakfast area. Fresh paint, new carpet, new dishwasher, nice window treatments, all furniture/fixture present in the house at the time of contract signing will remain with the home. Furniture includes formal dining set , formal living room sofa set, family room sofa set, some bedroom set, fully decored china set. Garage apartment adds 682 sq ft to the space which previous owner used as a CPA office. Lovely sunroom with spa included. Second bedroom down can be used as a home office. Three car garage with good size driveway. Very easy access to Bissonet and Highway 6. Walking distance to elementary school and zoned to Kempner High School. You will fall in love with this beauty. Bring you picky buyers.' ,`Acres` = '0.2204' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'KINGSBRIDGE PLACE SEC 3, BLOCK 1, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '544' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingsbridge Place Sec 3' ,`TaxAmount` = '7952' ,`TaxRate` = '2.3389' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704851' WHERE `Matrix_Unique_ID` = '210608568' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:21:04.837' ,`MLSNumber` = '26382296' ,`ListAgentFullName` = 'Cherry Ruffino' ,`ListOfficeName` = 'Coldwell Banker Apex, REALTORS LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.657435' ,`Longitude` = '-96.397186' ,`PhotoCount` = '25' ,`PostalCode` = '77803' ,`RoomCount` = '10' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Beck' ,`StreetNumber` = '2713' ,`StreetSuffix` = 'Street' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2283' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Builder home conveniently located 5 minutes from Downtown Bryan, 10 minutes to Blinn campus, 11 minutes to RELLIS campus, 11 minutes to Texas A&M Health Science Center, and less than 15 minutes to Texas A&M main campus! Great 2-story home with 4 bedrooms, 2.5 bathrooms, and a 2-car garage. The kitchen has a large island with an eating bar and opens to the spacious living room and dining area with a beautiful neutral color scheme and lots of natural light. Great space for spending time with family and entertaining friends! There is a home office on the main floor along with the master bedroom which was designed with efficiency in mind and has easy access from the master bath to a large walk-in closet and to the laundry room. Beautiful wood grain steps take you upstairs where you will find 3 bedrooms along with a bonus room that could be used for a second living space, reading, or game area. Call TODAY and schedule your private showing!' ,`Acres` = '0.2771' ,`Area` = '61' ,`BuilderName` = 'Historic Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FOUR POINT O SOUTH, BLOCK 1, LOT 7' ,`LotDesciption` = 'Other' ,`LotSize` = '12070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'MARY BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Four Point O North' ,`TaxAmount` = '496' ,`TaxRate` = '2.3493' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704851' WHERE `Matrix_Unique_ID` = '210810063' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:34:37.980' ,`MLSNumber` = '19640005' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.108503' ,`Longitude` = '-93.742616' ,`PhotoCount` = '25' ,`PostalCode` = '77630' ,`RoomCount` = '7' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Jayway St' ,`StreetNumber` = '1218' ,`StreetSuffix` = '' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a peek at this cozy 3 bedroom home situated off of Highway 87 in Orange. Sitting on a .27 acre lot, this home boasts 1,656 square feet of living space! With a mixture of warm and cool tones throughout, it is the perfect canvas to make your own! Whip up your favorite recipe in the beautiful kitchen while your guests sit around the island. Unwind after a long day by taking a dip in your very own pool! Sip coffee and listen to the birds chirp in the morning or watch the sun set on your deck! This home is perfect for you! Call us today!' ,`Acres` = '0.27' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 6 BLK 1 WREN PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11761' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '270 - West Orange-Cove Consolidated' ,`SchoolElementary` = 'WEST ORANGE-STARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST ORANGE-STARK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST ORANGE-STARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wren Park' ,`TaxAmount` = '1965' ,`TaxRate` = '2.779' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704851' WHERE `Matrix_Unique_ID` = '210903253' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:02:19.443' ,`MLSNumber` = '78834651' ,`ListAgentFullName` = 'Monica Montez' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810837' ,`Longitude` = '-95.406761' ,`PhotoCount` = '21' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '815000.00' ,`Status` = 'Active' ,`StreetName` = '27th St' ,`StreetNumber` = '533' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious home with timeless architecture by Titan Homes. Thoughtful design, exquisite finishes, tastefully executed intricate craftsmanship. This is a hardworking, functional yet elegant show home. \r\n\r\nIndependent drive, expansive first floor living, elevator capable, oversize backyard, chef’s kitchen, grand master suite and massive game room. Let this elegant home showcase your lifestyle.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Titan Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 32, BLK 18' ,`LotDesciption` = 'Other' ,`LotSize` = '3275' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Mediterranean,Spanish' ,`Subdivision` = 'Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704851' WHERE `Matrix_Unique_ID` = '210975116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:23:24.360' ,`MLSNumber` = '8904089' ,`ListAgentFullName` = 'Brandi Jackson' ,`ListOfficeName` = 'Cornerstone Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029556' ,`Longitude` = '-95.448299' ,`PhotoCount` = '33' ,`PostalCode` = '77090' ,`RoomCount` = '7' ,`ListPrice` = '264885.00' ,`Status` = 'Active' ,`StreetName` = 'Misty Lea' ,`StreetNumber` = '714' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2495' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this beautifully remodeled home in the Westador Subdivision. This home has an easy flowing floor plan, with the living room open to the kitchen and breakfast area. This beauty has been completely remodeled throughout and along with new vinyl windows, custom bathroom with tiled flooring and an oversized shower, double vanities, fresh paint throughout. This home also includes a formal living/game room that is adjoining main living room. This home is a must see!' ,`Acres` = '0.215' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 block 3 Westador Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BAMMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westador' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704851' WHERE `Matrix_Unique_ID` = '211173324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:16:07.217' ,`MLSNumber` = '62394315' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Billy By' ,`SellingOfficeName` = 'CitiQuest Properties' ,`Latitude` = '30.168290' ,`Longitude` = '-95.183537' ,`PhotoCount` = '28' ,`PostalCode` = '77357' ,`RoomCount` = '16' ,`ListPrice` = '514857.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Silver Palm' ,`StreetNumber` = '23696' ,`StreetSuffix` = 'Trail' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston, Elevation D) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Spacious island kitchen open to Family room. Formal Dining and Study. Game room and Media Room upstairs. Covered back patio and attached 2 car garage. Tavola, northeast Houston\'s newest master-planned community, features amenities such as a recreation center with a pool, park with a unique zip line and clubhouse, pocket parks and miles of wooded greenbelt trails that wind throughout the community. Tavola’s convenient location caters to major employment centers including the Greenspoint Business District and the new ExxonMobil campus. Located seven miles north of Kingwood and just two exits north of the new Grand Parkway, Tavola’s ideal location will easily link this community to any area of Houston. Stop by the Westin Homes home to learn more about Tavola!' ,`Acres` = '0.1692' ,`Area` = '40' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 3, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7372' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '932' ,`TaxRate` = '3.34' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704851' WHERE `Matrix_Unique_ID` = '211180877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:43:09.163' ,`MLSNumber` = '63177859' ,`ListAgentFullName` = 'Christie Scroggins' ,`ListOfficeName` = 'Landmark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.822104' ,`Longitude` = '-95.748679' ,`PhotoCount` = '39' ,`PostalCode` = '75861' ,`RoomCount` = '5' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'An County Road 431' ,`StreetNumber` = '1412' ,`StreetSuffix` = '' ,`City` = 'Palestine' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Barndo meets Custom one owner home built in 2020 and located in the desirable North side of Anderson County! This Impeccable five bedroom, two bath home sits on 56.890 acres of producing hay field with a pond and is cross fenced. Home features 9\' ceilings w/lots of space for entertaining! Front Entry is vaulted to the upper loft. Open Concept Kitchen, Breakfast area and Living with crown moldings throughout. Kitchen is spacious w/a large island , granite counter tops, a walk in pantry and solid wood cabinetry. Split Large Primary bedroom & expansive bath w/double vanity & walk-in closet. Beautiful outdoor covered patio and pipe/wire fencing in backyard. 30x40 insulated shop in back w/15x40 covered over hang & overhead door. Wont Last!' ,`Acres` = '56.89' ,`Area` = '75' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Palestine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0005 AGUILERA, JOSE YGNACIO BLOCK 1609 TRACT 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2478128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '71 - Palestine' ,`SchoolElementary` = 'CAYUGA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PALESTINE HIGH SCHOOL' ,`SchoolMiddle` = 'PALESTINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Barndominium' ,`Subdivision` = 'other' ,`TaxAmount` = '5062' ,`TaxRate` = '2.0073' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704851' WHERE `Matrix_Unique_ID` = '211227407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:14:20.360' ,`MLSNumber` = '76171340' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Tai Le' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.842080' ,`Longitude` = '-95.861710' ,`PhotoCount` = '26' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '549452.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bahia Bay' ,`StreetNumber` = '812' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation GL) CURRENLTY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 9 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7267' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704852' WHERE `Matrix_Unique_ID` = '211233487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:38:19.693' ,`MLSNumber` = '33438388' ,`ListAgentFullName` = 'Chad Corley' ,`ListOfficeName` = 'Miller Homes Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.245275' ,`Longitude` = '-95.187269' ,`PhotoCount` = '38' ,`PostalCode` = '77372' ,`RoomCount` = '5' ,`ListPrice` = '374500.00' ,`Status` = 'Active' ,`StreetName` = 'Morgan' ,`StreetNumber` = '14398' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2090' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedroom 2 bath home sitting on 0.9997 acre in highly sought after Splendora ISD! Roof was replaced 4-5 yrs ago with a 35 yr shingle, updates throughout the home. The original garage is in the process of being converted into a 950+ sq ft apartment with kitchen, bath and w/d hookups. Property features an approx 10\' x 16\' storage shed and 12\' x 33\' shop with electricity and 11\' x 33\' awning to park lawn mowers, trailers, or enclose to have a larger shop area. You have the country feel with city convenances right around the corner. Possibilities are endless with this home. Call today...' ,`Acres` = '0.9997' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SPLENDORA FARMS 03, LOT 51-B, ACRES .9997' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43547' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PINEY WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Farms 03' ,`TaxAmount` = '2509' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704852' WHERE `Matrix_Unique_ID` = '211236064' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:08:27.490' ,`MLSNumber` = '11552709' ,`ListAgentFullName` = 'Connie Hugon' ,`ListOfficeName` = 'Connie Hugon Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.387049' ,`Longitude` = '-94.760111' ,`PhotoCount` = '3' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '717500.00' ,`Status` = 'Active' ,`StreetName` = '2112 Laguna Harbor Cove' ,`StreetNumber` = '2112' ,`StreetSuffix` = 'Road' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION-Come enjoy great fishing and boating in this quaint gated waterfront community! Home is under construction and will be completed at end of September. If you move quickly, buyer can pick out floor covering and granite counters. Features include 10 ft ceilings, custom cabinetry, granite counter tops, large kitchen with island, stainless appliances, deck over looking your boat deck and canal, and concrete bulkhead with fishing right off your dock! Make an appointment to view this beauty!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Michael Manley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 47 Block 2' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '456' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Laguna Cove Harbor - Gated Community' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704852' WHERE `Matrix_Unique_ID` = '211312775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:21:03.623' ,`MLSNumber` = '53349808' ,`ListAgentFullName` = 'Warren Reed' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405026' ,`Longitude` = '-94.896734' ,`PhotoCount` = '27' ,`PostalCode` = '77590' ,`RoomCount` = '9' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = '20th' ,`StreetNumber` = '138' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1938' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic 3 bedroom, 2 bathroom home in the heart of Texas City. Beautiful backyard. Established neighborhood with mature trees. Great neighbors. This home is ready for updates or live in the nostalgia of a retro house. Two front doors are a quirky oddity that the new owner will enjoy. Call agent for an appointment Thanks for showing!' ,`Acres` = '0.2666' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 PAGE 4 & 5 LOT 24 & W 13 FT OF LOT 23 BLK 15 MAINLA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11613' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mainland Park' ,`TaxAmount` = '4157' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704852' WHERE `Matrix_Unique_ID` = '211620030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:13:26.230' ,`MLSNumber` = '66056501' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.988036' ,`Longitude` = '-95.144995' ,`PhotoCount` = '43' ,`PostalCode` = '77346' ,`RoomCount` = '12' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Aquatic' ,`StreetNumber` = '18707' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3197' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live merely steps from the shores of Lake Houston in this stunning 4-bedroom, 4-bathroom home in Walden on Lake Houston, boasting a brick exterior, tile flooring, crown molding, new roof (2019) recently updated sprinkler system (2022), 2 new water heaters, gas log fireplace, study with French doors, media room with speaker pre-wiring, and an open great room. Spend quality time in the spacious backyard, complete with a covered patio, golf cart garage, and sparkling swimming pool. Try a new recipe in the island kitchen, equipped with Corian countertops, tile backsplash, gas cooktop, dining nook, and breakfast bar. The serene primary suite features a walk-in closet, dual vanities, jetted tub, and separate shower. Community residents enjoy scenic water views, walking trails, a dog park, golf course, and country club. Located near FM 1960 and I-69, this home is down the road from the Atascocita Shopping Plaza and Deerbrook Mall. Zoned to Humble ISD.' ,`Acres` = '0.175' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 29 CHAMPIONS VILLAGE WALDEN ON LAKE HOUSTON PH 5' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '7622' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '399' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston' ,`TaxAmount` = '7898' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704852' WHERE `Matrix_Unique_ID` = '211805651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:27:56.043' ,`MLSNumber` = '61622163' ,`ListAgentFullName` = 'Shirley Sebesta' ,`ListOfficeName` = 'Shirley Sebasta, Broker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932277' ,`Longitude` = '-95.073944' ,`PhotoCount` = '43' ,`PostalCode` = '77532' ,`RoomCount` = '13' ,`ListPrice` = '517000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2100' ,`StreetNumber` = '17411' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PROPERTY IS RESIDENTIAL OR COMMERCIAL...UNRESTRICTED..... Bring the kids//Bring the horses//OR\r\nBring your business. Beautiful 1.9 acres that is very well maintained. Live here or have your business at your home. The home is in very good condition, minus a little updating. Relax in the SunRoom at the end of the day while you entertain and have your favorite beverage. Perfect for investment, a restaurant, a real estate office, or a nice quiet place to call home. DON\'T LET THIS ONE GET PAST YOU. BRING OFFERS!!' ,`Acres` = '1.9204' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 4G ABST 517 L A LEVY' ,`LotDesciption` = 'Other' ,`LotSize` = '83653' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'U/R' ,`TaxAmount` = '5478' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704852' WHERE `Matrix_Unique_ID` = '211914146' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:04:43.363' ,`MLSNumber` = '26335148' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.232586' ,`Longitude` = '-95.705397' ,`PhotoCount` = '13' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '302490.00' ,`Status` = 'Active' ,`StreetName` = 'BIRCH SHADOWS COURT' ,`StreetNumber` = '40502' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming Brand New Express 1 Story Home!! Features Include Open Concept living w/large dining room open to family room & kitchen! Primary bathroom suite offers huge walk in closet! Features include 30\" Flat panel maple cabinets w/crown molding, exotic granite, 4 burner gas cooktop w/SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard with so much room for a pool! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '35/5/5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6344' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704852' WHERE `Matrix_Unique_ID` = '211978593' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:44:48.313' ,`MLSNumber` = '23569981' ,`ListAgentFullName` = 'Angela Allen' ,`ListOfficeName` = 'Keller Williams City View' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.994198' ,`Longitude` = '-97.895697' ,`PhotoCount` = '50' ,`PostalCode` = '78640' ,`RoomCount` = '5' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Forest' ,`StreetNumber` = '302' ,`StreetSuffix` = 'Drive' ,`City` = 'Kyle' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy your home in, \"The Texas Hill Country.\" Purchase this as a main residence or a second home! An amazing buy. This almost new David Weekley, \"RIDGEGATE\" plan is available now in the popular Cypress Forest neighborhood. (It sells new for over $720k) Only 23 minutes away from downtown Austin and less than 5 miuntes from all the local Kyle shopping. This house has spared no detail and includes an extended grand entry, lead glass front door, real hard wood floors, four bedrooms, 3 baths, one of which is tucked away and private on a split floor plan, perfect for a growing teen or mother-in-law suite. Upgrades include an open study or flex area space. Kitchen overlooks the great size family room! The garage has a 3 car garage space that is oversized and perfect for a workshop, craft or gym area. Enjoy your morning coffee on the extended back patio overlooking the oversized private lot, perfect for a swimming pool. Schedule your private showing today!' ,`Acres` = '0.2281' ,`Area` = '83' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CYPRESS FOREST PHASE ONE, BLOCK K, LOT 23' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9934' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '121 - Hays Consolidated' ,`SchoolElementary` = 'NEGLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAYS HIGH SCHOOL' ,`SchoolMiddle` = 'BARTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Forest Ph One' ,`TaxAmount` = '9686' ,`TaxRate` = '2.5176' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704853' WHERE `Matrix_Unique_ID` = '211980446' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:02:44.870' ,`MLSNumber` = '30113776' ,`ListAgentFullName` = 'Scott Miller' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.673069' ,`Longitude` = '-95.650065' ,`PhotoCount` = '9' ,`PostalCode` = '77340' ,`RoomCount` = '4' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Deborah' ,`StreetNumber` = '29' ,`StreetSuffix` = 'Street' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '10\' ceilings in kitchen/Living, beautiful open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Great lighting and all LED! Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.' ,`Acres` = '0.2852' ,`Area` = '43' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MALONE - SEC 1, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12423' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Malone - Sec 1' ,`TaxAmount` = '331' ,`TaxRate` = '1.6534' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704853' WHERE `Matrix_Unique_ID` = '211980617' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:16:53.907' ,`MLSNumber` = '32492362' ,`ListAgentFullName` = 'Scott Miller' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.473480' ,`Longitude` = '-95.673836' ,`PhotoCount` = '8' ,`PostalCode` = '77356' ,`RoomCount` = '3' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore' ,`StreetNumber` = '15617' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '10\' ceilings in kitchen/Living, beautiful open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Great lighting and all LED! Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.' ,`Acres` = '0.1438' ,`Area` = '39' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HIDDEN FOREST EST 03, LOT 71' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6264' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '36' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Forest Estate 03' ,`TaxAmount` = '109' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704853' WHERE `Matrix_Unique_ID` = '211981375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:57:23.970' ,`MLSNumber` = '63962334' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000424' ,`Longitude` = '-95.463765' ,`PhotoCount` = '7' ,`PostalCode` = '77014' ,`RoomCount` = '5' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Bammelwood Drive' ,`StreetNumber` = '2515' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 BAMMEL VILLAGE SEC 02 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '366' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MAJOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bammel Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704853' WHERE `Matrix_Unique_ID` = '211982511' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T14:50:52.030' ,`MLSNumber` = '54738418' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471839' ,`Longitude` = '-95.520735' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '839900.00' ,`Status` = 'Active' ,`StreetName` = 'Serenity Grove' ,`StreetNumber` = '10015' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3868' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 5031 plan with stucco exterior. Unique 2-story open concept plan with many upgrades and large rooms throughout. The home has 4/5 bedrooms, 4.5 bathrooms, and a 3 car garage. It sits on a premium oversized lot large enough for a pool. A unique standout is the casita that sits at the front of the courtyard with a fireplace. The casita could be a 5th bedroom or used in many other ways. The spacious kitchen features double ovens and opens up to the great room. The stacking slider door flows from the great room to your covered extended outdoor patio. Relax in the spacious primary bedroom with bay window and tray ceiling. The upstairs has three bedrooms with walk in closets, game room, and comfortable media room. The fully sodded yard includes a full irrigation system. The home is bright and spacious with a light color scheme. Come live the difference in this gorgeous Shea Home!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12, Block 1, Section 34B' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11206' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.1484' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704853' WHERE `Matrix_Unique_ID` = '211983942' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T15:30:43.610' ,`MLSNumber` = '79515773' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.620399' ,`Longitude` = '-95.207647' ,`PhotoCount` = '20' ,`PostalCode` = '77034' ,`RoomCount` = '6' ,`ListPrice` = '304650.00' ,`Status` = 'Active' ,`StreetName` = 'Adobe Shores' ,`StreetNumber` = '12414' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home to be complete in January. 1 story stunner. 3 beds plus office, 2 baths. No rear neighbors! Modern Farmhouse exterior elevation will have full gutters, sprinkler system, and a 36\' x 26\' backyard. Wood look LVP flooring throughout main living, and carpet only in the bedrooms. Home will have marble look laminate counters in the kitchen and baths along with white cabinets. This is one of the few remaining 1 story homes available in Clearwick.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25, Block 1, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'GENOA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clearwick' ,`TaxAmount` = '' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704853' WHERE `Matrix_Unique_ID` = '211986333' --> Updated record success