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-23T09:32:01.917' ,`MLSNumber` = '95112330' ,`ListAgentFullName` = 'Norma Lewis' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809850' ,`Longitude` = '-95.321731' ,`PhotoCount` = '29' ,`PostalCode` = '77026' ,`RoomCount` = '5' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Loop' ,`StreetNumber` = '4907' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1451' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute single-story home with three bedrooms, two bathrooms, and a detached garage. Granite countertops tops., laminate floors, new roof (9/21). This home is in a very convenient location. Easily hop on Houston\'s 610 Loop or I-69 freeways to quickly get to major locations including Downtown Houston, The Port of Houston and Bush Airport within minutes.' ,`Acres` = '0.1377' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1465B BLK 61 KASHMERE GARDENS EXTN' ,`LotDesciption` = 'Other' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kashmere Gardens Ext' ,`TaxAmount` = '2423' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702043' WHERE `Matrix_Unique_ID` = '194665133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T08:40:44.487' ,`MLSNumber` = '36091665' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.184621' ,`Longitude` = '-95.518504' ,`PhotoCount` = '27' ,`PostalCode` = '77381' ,`RoomCount` = '13' ,`ListPrice` = '2920000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn' ,`StreetNumber` = '64' ,`StreetSuffix` = 'Crescent' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6142' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled home on nearly an acre lot in Hollymead! Located on a corner lot and walking distance to the Woodlands Country Club and Palmer Golf Course! Stunning curb appeal with a circular drive and covered front porch. Endless updates include a brand new roof and HVAC, Pella exterior doors and windows, Emtek door hardware, Madeval cabinetry, quartz counters, over 2,000 sf addition, pre-wired for security and surround sound, all new lighting, and much more! The sleek, open concept kitchen with all new Dacor appliances, waterfall island, vaulted beam ceiling, and under cabinet lighting, overlooks the dining and den with floor to ceiling brick fireplace; private study with built-ins; gorgeous sun room; owner\'s retreat and 2nd guest suite down; 3 bedrooms and game room up; oversized 3 car garage with epoxy floor; fabulous backyard with heated pool, spa, outdoor kitchen, and cedar pergola.' ,`Acres` = '0.8588' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'S972209 - WDLNDS VIL COCHRANS CR 09, BLOCK 4, LOT 16' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '37409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 09' ,`TaxAmount` = '25144' ,`TaxRate` = '2.2784' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702043' WHERE `Matrix_Unique_ID` = '208035411' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:49:57.957' ,`MLSNumber` = '5900601' ,`ListAgentFullName` = 'Colby Walters' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.384015' ,`Longitude` = '-94.760901' ,`PhotoCount` = '16' ,`PostalCode` = '77650' ,`RoomCount` = '4' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Madison' ,`StreetNumber` = '1905' ,`StreetSuffix` = 'Avenue' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy 4 bedroom, 2 bath beach home located in Port Bolivar on 1/3 acre with Bay views! 3 BR 2 Bath on main floor. 1 BR with walk in closet and large TV/Game room on second floor. Spacious privacy fenced backyard with fire pit, covered grill shack, lounge area and two car garage downstairs. Many updates have been done throughout the house. Bluetooth speakers in both bathrooms. Generac transfer station, elevated generator platform are ready for your generator. These are just a few of the upgrades this home has to offer! Short drive to the ferry and a short drive to all the attractions that Crystal Beach has to offer' ,`Acres` = '0.337' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 162 S PARR LOTS 1-2-3-4 BLK 489 PT BOLIVAR ACS .337 MH' ,`LotDesciption` = 'Other' ,`LotSize` = '14679' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Port Bolivar Townsite' ,`TaxAmount` = '4497' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702043' WHERE `Matrix_Unique_ID` = '208285718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:58:34.067' ,`MLSNumber` = '97673373' ,`ListAgentFullName` = 'John Prell' ,`ListOfficeName` = 'Creekview Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751506' ,`Longitude` = '-95.471533' ,`PhotoCount` = '24' ,`PostalCode` = '77056' ,`RoomCount` = '11' ,`ListPrice` = '2795000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Creek' ,`StreetNumber` = '5505' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6676' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant, Southern-style home located on a corner lot in the heart of Tanglewood, steps away from the Boulevard. The professionally landscaped & inviting courtyard welcomes guests to this beautiful, well-maintained home. The downstairs offers hardwoods throughout with designer details. The large island kitchen has plentiful storage and includes 2 dishwashers & double ovens. Three over-sized sec. bedrooms are on the 2nd floor with the primary suite and the fifth bedroom (which can also serve as a game room) on the 3rd. The house has a 3-car garage, gated driveway, and backyard w/ pool. An additional 515 sqft (not included in house bed/bath count) was added above the garage' ,`Acres` = '0.3601' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 30 TANGLEWOOD SEC 6' ,`LotDesciption` = 'Corner' ,`LotSize` = '15688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Tanglewood Sec 06' ,`TaxAmount` = '54475' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702043' WHERE `Matrix_Unique_ID` = '208972346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T08:41:50.050' ,`MLSNumber` = '58386591' ,`ListAgentFullName` = 'Jo Krejci' ,`ListOfficeName` = 'Champion Real Estate ' ,`SellingAgentFullName` = 'Lanette Cassidy' ,`SellingOfficeName` = 'Redfin Corporation' ,`Latitude` = '29.934345' ,`Longitude` = '-95.180363' ,`PhotoCount` = '37' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '300000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cambridge Eagle' ,`StreetNumber` = '12919' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2275' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a Gem! Beautifully landscaped front yard! Amazing floor plan in this 4 Bedroom, 2-1/2 bath home ready for family and friends. Fresh interior paint, recent Quartz Countertops in Hall and Primary Baths. New Garage Door Opener and Back Yard Fence. Buyer/buyer agent to independently verify all property information and independently measure room dimensions, if important.' ,`Acres` = '0.1793' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 SEVEN OAKS VILLAGE SUMMERWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '815' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood Sec 1' ,`TaxAmount` = '6628' ,`TaxRate` = '2.683' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702043' WHERE `Matrix_Unique_ID` = '208983342' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:05:20.857' ,`MLSNumber` = '20051684' ,`ListAgentFullName` = 'Crystal Mason' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847268' ,`Longitude` = '-95.423001' ,`PhotoCount` = '5' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Knox' ,`StreetNumber` = '6728' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction located in the Acres Homes Community. 3bedroom, 2 bathroom, covered back porch w/just enough backyard space, and a spacious 1-car garage ! Completion is approximately July1st… Come by and see this beauty… Let’s make this your new home today!' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = 'Kensli Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 16 & 17 BLK 25 HIGHLAND HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Heights' ,`TaxAmount` = '1154' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702043' WHERE `Matrix_Unique_ID` = '209003517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:08:09.160' ,`MLSNumber` = '30113865' ,`ListAgentFullName` = 'Wanda Taylor' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = 'Marie Gilbert' ,`SellingOfficeName` = 'RE/MAX Signature' ,`Latitude` = '29.800150' ,`Longitude` = '-95.491575' ,`PhotoCount` = '26' ,`PostalCode` = '77055' ,`RoomCount` = '9' ,`ListPrice` = '999000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Huge Oaks' ,`StreetNumber` = '1617' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2998' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Extra Special Monarch Oaks Home! So many unique features in this lovely 4 bedroom home. Entry opens to formal Living and Dining rooms. Den has hardwood floors and vaulted ceiling with large windows overlooking the backyard. Fantastic spacious kitchen with custom made cabinetry, views to the backyard and a coffee bar. Unbelievable storage throughout. Bonus storage area in attic. Owners Retreat has door to backyard and 2 walk in closets. Hardwood floors in bedrooms. THREE car garage with extra garage door to backyard to pull through. Huge lot! Zoned to Valley Oaks and Memorial High. Monarch Oak residents can waive to Spring Branch Middle automatically.' ,`Acres` = '0.4132' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 6 MONARCH OAKS SEC 2 PAR AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Monarch Oaks' ,`TaxAmount` = '23788' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702043' WHERE `Matrix_Unique_ID` = '209035619' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:01:26.460' ,`MLSNumber` = '89609035' ,`ListAgentFullName` = 'Tesia Harris' ,`ListOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.032295' ,`Longitude` = '-95.876556' ,`PhotoCount` = '43' ,`PostalCode` = '77484' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cherokee' ,`StreetNumber` = '29115' ,`StreetSuffix` = 'Lane' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 29115 Cherokee Ln in Waller, TX. Location, Location, Location!! Rare find in Harris County is minutes away from Hwy 290! This 4BR/2Bath home is situated on a 2.78 +/- Acre lot. Home is filled with updates and upgrades! Kitchen features new appliances & island with cooktop. Neutral color scheme and remodeled touches throughout. Metal roof is ~2 years old! No restrictions & has never flooded! Spacious lot is ideal for outdoor projects and offers endless opportunity! A variety of trees are scattered throughout to provide shade and privacy. Fully fenced tract with manned gate. Schedule your appointment today!' ,`Acres` = '2.783' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 45 KICKAPOO FARMS U/R' ,`LotDesciption` = 'Other' ,`LotSize` = '121227' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = '' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kickapoo Farms U/R' ,`TaxAmount` = '2031' ,`TaxRate` = '2.006' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702043' WHERE `Matrix_Unique_ID` = '210128560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T08:09:45.193' ,`MLSNumber` = '92584721' ,`ListAgentFullName` = 'Juliana Polanco' ,`ListOfficeName` = 'AroundTown Properties Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.291696' ,`Longitude` = '-94.820925' ,`PhotoCount` = '48' ,`PostalCode` = '77551' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue K' ,`StreetNumber` = '4816' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this gorgeous duplex in the heart of Galveston Island! Close enough to Galveston\'s beaches and entertainment but far enough away for privacy, this recently remodeled duplex has a large driveway - great for parties and summer entertaining (or parking all your cars.) The front is a 3 bedroom unit with both front and rear entrances. The rear is a gorgeous 1 bedroom unit, complete with its own private entrance and a 1-car garage. Even better - it\'s fully furnished and needs nothing except your own washer and dryer. The garage could easily be converted into a first-floor apartment - it\'s ideal as a rental property with a little work!\r\n\r\nThis great property will go fast, so grab it while you can!' ,`Acres` = '0.124' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 18 & E 10 FT OF LOT 19 & W 10 FT' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Denver Resurvey' ,`TaxAmount` = '5744' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702044' WHERE `Matrix_Unique_ID` = '210333446' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:50:02.010' ,`MLSNumber` = '79233024' ,`ListAgentFullName` = 'Elaine Gerren' ,`ListOfficeName` = 'Integrity Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.531265' ,`Longitude` = '-96.700010' ,`PhotoCount` = '26' ,`PostalCode` = '77836' ,`RoomCount` = '2' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Alligator' ,`StreetNumber` = '600' ,`StreetSuffix` = 'Street' ,`City` = 'Caldwell' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '908' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 2-bedroom 1 bath home with hardwood floors. Large attached 3 car garage. Close to the schools.' ,`Acres` = '0.1377' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S1500 CITY OF CALDWELL BLK 10A LOT 5 0.1377 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '209 - Caldwell' ,`SchoolElementary` = 'CALDWELL ELEMENTARY SCHOOL (CALDWELL)' ,`SchoolHigh` = 'CALDWELL HIGH SCHOOL' ,`SchoolMiddle` = 'CALDWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'City Of Caldwell' ,`TaxAmount` = '1572' ,`TaxRate` = '2.1939' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702044' WHERE `Matrix_Unique_ID` = '210456310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:14:48.603' ,`MLSNumber` = '24626855' ,`ListAgentFullName` = 'Amalia Kazilas' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763564' ,`Longitude` = '-95.470830' ,`PhotoCount` = '34' ,`PostalCode` = '77056' ,`RoomCount` = '12' ,`ListPrice` = '1650000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodway' ,`StreetNumber` = '5312' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '5387' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfectly located within a private gated Pine Shadow W/ 5 bedrooms and 5 bathrooms\r\narchitectural features throughout including beautiful iron finishes, archways/windows leading\r\nto the lush grounds & outdoor living,island kitchen w/breakfast area opens to a Livingroom with\r\nfireplace, hardwood flooring and beamed ceilings. Butlers area with wet bar flows from kitchen\r\nto formal dining, wine enclosure,primary bedroon 1st floor,with bath has separate vanities,jett\r\nbath w/ tub/glass shower ,massive walk in closets with built ins,extra 6 parking space. Completely remodeled with high end appliances and luxuriously material. Brand new kitchen and bathrooms, completely updated' ,`Acres` = '0.2882' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 PINE SHADOWS PAR R/P NO 2' ,`LotDesciption` = 'Other' ,`LotSize` = '12553' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Shadows Pt Rep 2' ,`TaxAmount` = '36837' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702044' WHERE `Matrix_Unique_ID` = '210495797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:48:37.807' ,`MLSNumber` = '83813124' ,`ListAgentFullName` = 'Hangwen Liang' ,`ListOfficeName` = 'Turbo Realty of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747584' ,`Longitude` = '-95.785613' ,`PhotoCount` = '40' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Falcon Knoll' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a very spacious five bedrooms home. Spread out the family with two living areas and a\r\ngame-room. There is an upstairs primary suite with jacuzzi tub, separate shower and his and her\r\nvanities. The fifth bedroom is downstairs with another full bath. The center kitchen supports a formal\r\ndining room and breakfast area. The oversized backyard is large enough to accommodate a pool. The\r\nFalcon Ranch HOA is continually active within the community. The subdivision shows pride of\r\nownership, and all entry ways are maintained with colorful landscaping. This award-winning, Katy\r\ncommunity features something for everyone in the family. \r\n\r\nEnjoy 2 parks, Tennis Courts, a Pool and Splash Pad, Adjacent Walking Trails, and a Neighborhood Clubhouse. Close to 99, coffee shops, Katy outlet mall, La Centerra shopping, trendy restaurants, parks and more! Act now and be ready for the start of Katy’s school year. The roof was replaced in 2020 per seller.' ,`Acres` = '0.2236' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FALCON RANCH SEC 4, BLOCK 6, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9739' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '694' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falcon Ranch Sec 4' ,`TaxAmount` = '8426' ,`TaxRate` = '2.9495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702044' WHERE `Matrix_Unique_ID` = '210893882' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T08:36:17.813' ,`MLSNumber` = '16241765' ,`ListAgentFullName` = 'Monica LaFuente' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986879' ,`Longitude` = '-95.512022' ,`PhotoCount` = '37' ,`PostalCode` = '77069' ,`RoomCount` = '10' ,`ListPrice` = '334990.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Erica' ,`StreetNumber` = '13506' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous remodeled, well taken care of home located in the well established Huntwick neighborhood!! This beauty offers a stunning well landscaped front and backyard with full sprinkler system with double pane windows and a detached 2 car garage. The home has fresh paint throughout and 2 bedrooms downstairs with 3 bedrooms upstairs. The extra bedroom downstairs makes for a great nursey, study, or aging parent room. Schedule your appointment today!!' ,`Acres` = '0.2204' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 5 HUNTWICK FOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntwick Forest' ,`TaxAmount` = '5279' ,`TaxRate` = '2.4306' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702044' WHERE `Matrix_Unique_ID` = '210919529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T08:31:33.747' ,`MLSNumber` = '9301175' ,`ListAgentFullName` = 'Kathy Jones' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = 'Chris Wooldridge' ,`SellingOfficeName` = 'Chris Properties' ,`Latitude` = '29.865386' ,`Longitude` = '-95.626888' ,`PhotoCount` = '37' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '339000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cross Junction' ,`StreetNumber` = '14607' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ideally situated in the heart of highly desirable Jamestown Colony, this gorgeous one-story beauty has been professionally updated throughout & presents like a model home! Ideally situated on an enormous 17,546 square foot lot (per HCAD), this 4 bedroom, 2.5 bath home is a superb blend of style and comfort. The open & spacious floor plan makes entertaining a true delight!*Addl. Upgrades & Features Incl: Gorgeous custom cabinetry & granite counters in kitchen & all baths; Gourmet kitchen w/ expanded granite covered island provides seamless access to the generously proportioned family room; Custom porcelain tile flooring & neutral plush carpet; Lovely art niches w/lighting at entry & family room; Primary suite enhanced w/ two spacious closets, whirlpool tub, & oversized walk-in frameless shower; Plywood floored attic; Expanded concrete patio & driveway; oversized detached garage, custom landscaping + a Rain Bird sprinkler system covering all yard areas & flower beds+ More!*= per owner.' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 2 JAMESTOWN COLONY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17546' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '445' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jamestown Colony' ,`TaxAmount` = '6227' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702044' WHERE `Matrix_Unique_ID` = '211264965' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:28:39.073' ,`MLSNumber` = '87402912' ,`ListAgentFullName` = 'Kyle Jefferson' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062847' ,`Longitude` = '-95.427573' ,`PhotoCount` = '33' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Cypresswood Ridge' ,`StreetNumber` = '715' ,`StreetSuffix` = 'Ridge' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable one story home in a gated community with EASY access to I-45 that provides a short drive to the Woodlands or IAH Airport! This ready-to-move in home has been freshly painted and has brand new carpet throughout. This home also features 3 spacious bedrooms and a flex room/study! The community offers a peaceful lake with a walking and running path, outdoor pool, and beach volleyball court. What a great location and an even better home!' ,`Acres` = '0.1149' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 CYPRESSWOOD LAKE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5005' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '733' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GINGER MCNABB ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Lake Sec 04' ,`TaxAmount` = '4562' ,`TaxRate` = '2.4967' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702044' WHERE `Matrix_Unique_ID` = '211336329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:37:40.363' ,`MLSNumber` = '48115920' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748787' ,`Longitude` = '-95.883746' ,`PhotoCount` = '12' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore Wood' ,`StreetNumber` = '2875' ,`StreetSuffix` = 'Trace' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar\'s Vista Collection \"Amistad\" Plan with Elevation \"B\" in Jordan Ranch! A spacious single-story design, this home features an open layout with a shared kitchen, and family room with access to the covered patio for outdoor leisure. Three bedrooms and a formal dining room add versatility in the front of the home, while the owner’s suite is tucked away, boasting privacy and a spa-inspired bathroom. *HOME ESTIMATED TO BE COMPLETE, NOVEMBER, 2022.*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0028 BLK 002 LOT 014' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702045' WHERE `Matrix_Unique_ID` = '211439846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:39:08.093' ,`MLSNumber` = '10722993' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749580' ,`Longitude` = '-95.884190' ,`PhotoCount` = '12' ,`PostalCode` = '77423' ,`RoomCount` = '10' ,`ListPrice` = '475198.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore Wood' ,`StreetNumber` = '2858' ,`StreetSuffix` = 'Trace' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2423' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Vista Collection \"Hilltop\" Plan with Elevation \"B\" in Jordan Ranch! The largest single-story home in the collection features a shared living design where the kitchen overlooks the family room and covered patio. A flexible study and three secondary bedrooms make up the front of the home, while tucked away for privacy is the owner’s suite with a lavish bathroom and dual closets. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0028 BLK 002 LOT 027' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702045' WHERE `Matrix_Unique_ID` = '211515896' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T08:20:38.470' ,`MLSNumber` = '50692415' ,`ListAgentFullName` = 'Blake Vincent' ,`ListOfficeName` = 'DUX Realty, LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.731008' ,`Longitude` = '-95.456514' ,`PhotoCount` = '38' ,`PostalCode` = '77027' ,`RoomCount` = '14' ,`ListPrice` = '799900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'MERWIN' ,`StreetNumber` = '4714' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home, zoned to St. George Place elementary, features a large backyard with close to 1,350 sf of green space with plenty of room for a pool! Mazzarino Construction & Development\'s new division is here in Houston\'s well established inner loop neighborhoods. MAZZTAO Homes features a new, stylish, well priced, quality home, but with an entirely different price point. You no longer have to compromise your location to buy somewhere or something else, that you just don’t really want. This home features an extremely versatile and functional floor plan. The floor plan has 4 bedrooms, 3.5 bath rooms, first floor living, a private driveway, flex room, game room, and approx. 1,350 sf backyard! Retail, restaurants, gym, groceries, you name it, it\'s walking distance away. Major freeways, downtown, medical center, parks, theater, art & museum districts are all within minutes. Contact us today to learn more about customization options available during construction only!' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'MAZZTAO HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Royden Oaks/Afton Oaks' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 MERWIN GREEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3663' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'MERWIN GREEN' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702045' WHERE `Matrix_Unique_ID` = '211621524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T08:54:04.027' ,`MLSNumber` = '25830629' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806621' ,`Longitude` = '-95.837188' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '13' ,`ListPrice` = '649857.00' ,`Status` = 'Active' ,`StreetName` = 'Eden Terrace' ,`StreetNumber` = '6610' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Lorraine II, Elevation A) CURRENTLY BEING BUILT. One Story cul-de-sac lot. 4 bedrooms, 3.5 baths. Study as well as spacious island kitchen open to Family Room and Dining room. Primary suite with large walk-in closet. Covered patio and attached 3 car tandem garage. Located in the heart of Katy and minutes from the Grand Parkway and I-10, the Falls at Green Meadows is Katy’s premiere Community! Residents of the Falls at Green Meadows can enjoy the Community Recreation Center that features a crystal-blue pool and outdoor patio area. Other amenities include sparkling lakes, meandering walking trails, and a playground. Stop by the Westin Homes model home today to find out more about the Falls at Green Meadows!' ,`Acres` = '' ,`Area` = '25' ,`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 4 BLK 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9134' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls at Green Meadows' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702045' WHERE `Matrix_Unique_ID` = '211629248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:41:55.807' ,`MLSNumber` = '8750947' ,`ListAgentFullName` = 'Erik Frankson' ,`ListOfficeName` = 'Ward Real Estate, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.963147' ,`Longitude` = '-95.966764' ,`PhotoCount` = '19' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '199500.00' ,`Status` = 'Active' ,`StreetName` = 'Candlewood' ,`StreetNumber` = '1904' ,`StreetSuffix` = 'Drive' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is so welcoming from the start with the extra wide driveway and big front porch! Inside you\'ll find tile floors throughout & an open concept living/dining/kitchen area. So, the flex room in front can be used however you desire. The kitchen has tons of cabinets plus a pantry to meet all your storage needs. A unique feature of this home is the covered back porch that spans the whole backside! Is outdoor storage space what you\'re looking for? Then check out the 2 car attached garage AND 3 car detached garage that could be turned into more living space if needed. New roof done in 2020! Seller is a licensed real estate broker in the state of Texas.' ,`Acres` = '0.215' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAYWOOD S/D, BLOCK 5, LOT 2, SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9365' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Baywood' ,`TaxAmount` = '5415' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702045' WHERE `Matrix_Unique_ID` = '211635816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T08:33:14.970' ,`MLSNumber` = '38790496' ,`ListAgentFullName` = 'Alex Harper' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.265766' ,`Longitude` = '-94.199629' ,`PhotoCount` = '1' ,`PostalCode` = '77656' ,`RoomCount` = '4' ,`ListPrice` = '439800.00' ,`Status` = 'Active' ,`StreetName` = 'Cody Lane' ,`StreetNumber` = '222' ,`StreetSuffix` = '' ,`City` = 'Lumberton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning new construction by RTC Homes in Woosley Palms! This home features 4 bedrooms, and 2 full bathrooms as well as a 2 cargarage with plenty of storage space. Prepare yourself for breathtaking views as you enter the large foyer with built in bench seating andrecessed ceilings that open into a spacious living room with vaulted ceilings equipped with a gas corner fireplace that showcases anopen concept to the beautiful kitchen. The kitchen features a large center island with a breakfast bar, great use of counter space for mealpreparation and entertaining, ample cabinet space as well as a walk-in pantry. The master bedroom is a dream come true with all thedetails to match including recessed ceilings, huge walk-in closet with laundry room access, dual sinks, a large soaking tub, and aseparate tiled shower. Estimated construction completion is in February 2023.' ,`Acres` = '' ,`Area` = '49' ,`BuilderName` = 'RTC Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 7 Woosley Palms Phase 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Woosley Palms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663702045' WHERE `Matrix_Unique_ID` = '211696309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:41:02.487' ,`MLSNumber` = '10727314' ,`ListAgentFullName` = 'Ethan Cameron' ,`ListOfficeName` = 'Cameron Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.454827' ,`Longitude` = '-94.936765' ,`PhotoCount` = '14' ,`PostalCode` = '77371' ,`RoomCount` = '5' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'Mid' ,`StreetNumber` = '391' ,`StreetSuffix` = 'Lane' ,`City` = 'Shepherd' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this great opportunity to join the rural community! 2 bedroom, 1 bath wood frame home on 1 acre in Shepherd ISD. Property includes a workshop, carport with storage and a additional meter and septic for in-laws or rental potential. With a little TLC, this home would make a great starter home!' ,`Acres` = '1' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE TEJAS, LOT 136 & 137, ACRES 1.0' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '130 - Shepherd' ,`SchoolElementary` = 'SHEPHERD PRIMARY SCHOOL' ,`SchoolHigh` = 'SHEPHERD HIGH SCHOOL' ,`SchoolMiddle` = 'SHEPHERD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Tejas' ,`TaxAmount` = '1168' ,`TaxRate` = '1.8509' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702045' WHERE `Matrix_Unique_ID` = '211700899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T08:23:28.833' ,`MLSNumber` = '95455169' ,`ListAgentFullName` = 'Jimmy Zarate' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750142' ,`Longitude` = '-95.323870' ,`PhotoCount` = '13' ,`PostalCode` = '77011' ,`RoomCount` = '4' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Burr' ,`StreetNumber` = '402' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1075' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice house in the heart of EDO Houston. This home needs some TLC. Investor and Handyman Special.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 2 WILLIAMS' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams' ,`TaxAmount` = '3585' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702046' WHERE `Matrix_Unique_ID` = '211712012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T09:35:38.797' ,`MLSNumber` = '51193592' ,`ListAgentFullName` = 'Bradley Beene' ,`ListOfficeName` = 'WBI Financial Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.329972' ,`Longitude` = '-95.604316' ,`PhotoCount` = '47' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '2250000.00' ,`Status` = 'Active' ,`StreetName` = 'Capitol Hill' ,`StreetNumber` = '15794' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Extremely well commercially constructed home. Granite countertops, metal roof, large in-ground swimming pool, fountain with waterfall with bridge over lazy river. Fantastic pipe fencing and gateways. Separate entrance to upstairs apartment suite. \r\n\r\nLarge manufacturing shop or huge garage area for your toys.\r\n11 separate offices with conference room, reception area and kitchen. All offices have built-ins.' ,`Acres` = '6.29' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0281 - HAMLET R G, TRACT 40F-2, 40-J, ACRES 6.29' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'R G Hamlet Surv Abs # 281' ,`TaxAmount` = '7259' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702046' WHERE `Matrix_Unique_ID` = '211717603' --> Updated record success