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-11-16T05:43:07.620' ,`MLSNumber` = '25820524' ,`ListAgentFullName` = 'Robert Miles' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Violet Brooks' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.721256' ,`Longitude` = '-95.572579' ,`PhotoCount` = '38' ,`PostalCode` = '77082' ,`RoomCount` = '9' ,`ListPrice` = '635000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'St Laurent' ,`StreetNumber` = '11215' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy a quiet secure lifestyle in this guard gated community. Located on a quiet cul-de-sac street in fabulous Royal Oaks Country Club, this 3 bedroom property features no carpet and a delightful pool/spa with tranquil water feature & pergola. Downstairs primary suite with hardwood floors has an elegant en-suite bath with whirlpool tub & two walk in closets. The large family room features gleaming hardwood floors, gas log fireplace, and a view of the beautiful pool/spa. The kitchen is open to the family & breakfast rooms. Kitchen features include granite counters, 5 burner gas cooktop, builtin refrigerator, convection oven, microwave, under cabinet lighting, and plenty of storage and prep space. The adjacent butlers pantry area makes for easy serving to the dining room. Upstairs is an extra large gameroom with wood floors. Two bedrooms & hollywood bath complete the upstairs - one bedroom includes a computer/study niche. Close to shopping, entertainment and major roads.' ,`Acres` = '0.1397' ,`Area` = '31' ,`BuilderName` = 'McVaugh Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 62 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 9' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '6086' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3295' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Oaks Country Club' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623760' WHERE `Matrix_Unique_ID` = '206935858' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:57:16.977' ,`MLSNumber` = '13774390' ,`ListAgentFullName` = 'Jennifer Auer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.192950' ,`Longitude` = '-95.343460' ,`PhotoCount` = '42' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 210' ,`StreetNumber` = '18120' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Paradise right in front of your eyes! Modern home with all the luxuries of the city right at your fingertips. This beautiful quiet country location is in a prime location. Plenty of room to do whatever you like. Shade trees all over this beautiful property. Separate MIL quarters with covered parking for all your guest privacy needs. Screened in patio and swimming pool with hot tub for your relaxing evenings and entertaining weekends. 2 stall barn for all your farming or workshop needs. Another workshop/changing room attached to the pool area. This is one you wont want to miss. Call today to schedule your private viewing before it\'s gone!!' ,`Acres` = '3.84' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Danbury' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0023 S F AUSTIN, BLOCK 22, TRACT 747D-747F, ACRES 3.840' ,`LotDesciption` = 'Other' ,`LotSize` = '167270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '7557' ,`TaxRate` = '2.0772' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623761' WHERE `Matrix_Unique_ID` = '209198496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:19:01.910' ,`MLSNumber` = '27672162' ,`ListAgentFullName` = 'Maria Bonilla' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860700' ,`Longitude` = '-95.294451' ,`PhotoCount` = '18' ,`PostalCode` = '77016' ,`RoomCount` = '6' ,`ListPrice` = '211289.00' ,`Status` = 'Active' ,`StreetName` = 'Wileyvale' ,`StreetNumber` = '7407' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Contruction! Make new memories in this amazing One story 3-bedroom open concept, no carpet Home. This house is near shopping centers and freeways Minutes from Downtown. Amazing Price don’t miss out this great opportunity. Please verify room dimensions and schools.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Europa Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5760' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trinity Gardens' ,`TaxAmount` = '' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623761' WHERE `Matrix_Unique_ID` = '211378913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T05:24:16.107' ,`MLSNumber` = '54664530' ,`ListAgentFullName` = 'Tamra Kolin' ,`ListOfficeName` = 'Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789673' ,`Longitude` = '-95.427693' ,`PhotoCount` = '33' ,`PostalCode` = '77008' ,`RoomCount` = '10' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodbrook' ,`StreetNumber` = '6407' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1699' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6407 Woodbrook where its all about Location and Convenience! This home is located in the well established neighborhood of Timbergrove Manor where streets are lined with beautifully mature trees. Property offers 3 bedrooms, 2 baths, formal living room near front entry and an over-sized family room with ceiling to floor windows. Roof approximately 5 years old. Endless possibilities! HOME SOLD AS-IS WITH NO SELLER REPAIRS.' ,`Acres` = '0.194' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 39 TIMBERGROVE MANOR SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Timbergrove Manor' ,`TaxAmount` = '9496' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623761' WHERE `Matrix_Unique_ID` = '211436404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:54:18.410' ,`MLSNumber` = '10485625' ,`ListAgentFullName` = 'John Newsom' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801049' ,`Longitude` = '-95.888083' ,`PhotoCount` = '9' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '899999.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Canyon' ,`StreetNumber` = '1634' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House is in the process of many updates and renovations, including granite replacement in kitchen, 2 new A/C units, paint inside and outside, upstairs and downstairs carpet being replaced, bathroom vanities being upgraded to quartz with new facuets. Kitchen cabinets to be painted. Now is the time to make your purchase you may have the opportunity to pick your colors.' ,`Acres` = '1.4263' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S733104 REMINGTON TRAILS 4 BLK 2 LOT 3 ACRES 1.4263' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot' ,`LotSize` = '62130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`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` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Remington Trails 4' ,`TaxAmount` = '10986' ,`TaxRate` = '2.1293' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623761' WHERE `Matrix_Unique_ID` = '212117562' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:15:33.517' ,`MLSNumber` = '46091404' ,`ListAgentFullName` = 'Penny Salter' ,`ListOfficeName` = 'Penny Salter Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834672' ,`Longitude` = '-95.451319' ,`PhotoCount` = '29' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'De Milo' ,`StreetNumber` = '2202' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great New Price! Custom built in 1955 , on 9,000 sq ft lot per HCAD. Ranch with amazing floor plan with flagstone entry, formal living/dining plus very large den with gas log brick fireplace. 3-2-2 detached, original hardwoods under carpet, partially in den except where addition was made. Lots of kitchen cabinets, cooktop with built in oven and microwave. Large primary with en suite. Large walk in closet in hallway and den for additional storage. Two additional bedrooms. Iron fence with two gates entry to backyard with very inviting patio which is also viewed from the oversized window in the den. Hot water heater 10/22. Not in the flood zone, never flooded per seller who is the original owner. Remodel or build your dream home, possibilities are endless!' ,`Acres` = '0.2066' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 & TR 20B BLK 8 OAK FOREST SEC 18' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 18' ,`TaxAmount` = '8691' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623762' WHERE `Matrix_Unique_ID` = '212178038' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:15:47.400' ,`MLSNumber` = '50537796' ,`ListAgentFullName` = 'Charity Yarborough' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.737996' ,`Longitude` = '-95.420727' ,`PhotoCount` = '49' ,`PostalCode` = '77098' ,`RoomCount` = '11' ,`ListPrice` = '2650000.00' ,`Status` = 'Active' ,`StreetName` = 'Virginia' ,`StreetNumber` = '3007' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '6001' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fabulous soft contemporary home is located in the desirable Upper Kirby District. This show stopping home has it all, starting w/impressive curb appeal & dynamic open concept floor plan featuring high ceilings & walls of windows & doors.The wide entrance foyer is flanked by lovely formal rooms & leads into the huge great room w/a fireplace & large chef-ready kitchen & breakfast area, perfect for entertaining cozy dinner parties or large functions. The spacious gourmet kitchen w/top line SS appliances features a Thermador full size wine fridge and Butler\'s pantry w/ wet bar. Dramatic staircase leads to an upstairs living area, enormous owner\'s retreat w/ sitting area & large balcony and fireplace, spa like bath w/a large shower & deep soaking tub, 2 water closets & separate walk in closets & dual vanities. 3 additional bedrooms w/ensuite baths. The outdoor living room & deluxe kitchen are complete w/wood-burning pizza oven, gas grill, wet-bar, cascading fountain wall & outdoor FP!!' ,`Acres` = '0.1791' ,`Area` = '16' ,`BuilderName` = 'Blackstone Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Upper Kirby' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 6 DAVID CROCKETT R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'David Crockett 02 Rep' ,`TaxAmount` = '48455' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623762' WHERE `Matrix_Unique_ID` = '212251256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:43:20.280' ,`MLSNumber` = '51093631' ,`ListAgentFullName` = 'Otilia Robles' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.351767' ,`Longitude` = '-95.123107' ,`PhotoCount` = '35' ,`PostalCode` = '77517' ,`RoomCount` = '11' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Rd' ,`StreetNumber` = '6503' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country Living is calling you!! This updated manufactured home with four bedrooms and two baths nestled on 2.5 acres in Santa Fe is a must-see. Features include an updated island kitchen with granite countertops, breakfast bar, and gorgeous pot rack. The adjacent laundry room has a standalone sink and accesses the back porch area. The wood-burning fireplace flanked by windows is the focal point of the spacious living/dining combo. Ample storage in the updated primary bath ensuite includes a walk-in closet. The primary bedroom holds a king-size bed with room to spare. The guest bath updates include granite-topped cabinets. Three secondary bedrooms are currently being used for an office, cycling studio, and storage. The back porch area is decked and provides the perfect spot to enjoy early morning coffee and watch the sunrise. \r\n\r\nNo deed restrictions. No HOA.' ,`Acres` = '2.5' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 47 L CRAWFORD SUR PT OF OUTLOT 414 (414-19) ALTA LOMA O' ,`LotDesciption` = 'Cleared' ,`LotSize` = '108900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Alta Loma Outlots' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623762' WHERE `Matrix_Unique_ID` = '212591389' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:56:15.560' ,`MLSNumber` = '22159747' ,`ListAgentFullName` = 'Daniel DiPetta' ,`ListOfficeName` = 'Bayou City Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.613121' ,`Longitude` = '-95.259804' ,`PhotoCount` = '33' ,`PostalCode` = '77075' ,`RoomCount` = '6' ,`ListPrice` = '254950.00' ,`Status` = 'Active' ,`StreetName` = 'Summerset Meadow' ,`StreetNumber` = '8815' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1477' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated house in a mature neighborhood awaits you! New modern interior paint throughout! New modern flooring throughout the house. Updated kitchen with granite counter tops and subway tile backsplash. Updated bathrooms with granite counter tops and tile flooring. Spacious backyard perfect for those gatherings!' ,`Acres` = '0.1136' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 98 BLK 1 CLEARWOOD CROSSING SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clearwood Xing Sec 04' ,`TaxAmount` = '5760' ,`TaxRate` = '3.1563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623762' WHERE `Matrix_Unique_ID` = '212968947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:58:15.257' ,`MLSNumber` = '89048495' ,`ListAgentFullName` = 'Daniel DiPetta' ,`ListOfficeName` = 'Bayou City Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752601' ,`Longitude` = '-95.633826' ,`PhotoCount` = '50' ,`PostalCode` = '77077' ,`RoomCount` = '11' ,`ListPrice` = '899950.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage Landing' ,`StreetNumber` = '1723' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3967' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mediterranean Style Custom Home on a beautifully landscaped corner lot, tucked inside Lakes of Parkway gated community! Fabulous home with spacious main living spaces with plenty of room for entertaining family and friends. This property has been completely updated with modern finishes throughout. No expense was spared. Property has a new roof, new HVAC, new energy efficient windows, custom island was added, and new wood flooring throughout. All the bathrooms were remodeled with ceramic tile, granite, and high-end fixtures.' ,`Acres` = '0.1834' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 LAKES OF PARKWAY SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '7989' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Lakes Pkwy Sec 03' ,`TaxAmount` = '13849' ,`TaxRate` = '2.3907' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623763' WHERE `Matrix_Unique_ID` = '212969390' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:14:08.360' ,`MLSNumber` = '38162822' ,`ListAgentFullName` = 'Wendy Richardson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Lauren Blaschke' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.128794' ,`Longitude` = '-95.490681' ,`PhotoCount` = '25' ,`PostalCode` = '77380' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wilderness' ,`StreetNumber` = '24902' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Custom Built 3 bedroom, 2 bath Ranch, original owner! Open beam ceiling in living room that is open to dining space. Windows frame the white brick fireplace overlooking the .31 of an acre lot. Mature trees front and back with unique landscaping. Custom kitchen with granite counters, breakfast bar, pull drawer pantry, double ovens and cute corner window over the sink. Primary features a walk-in closet and double shower. The two other bedrooms are a good size with window ledges and walk-in closets. This home has NEVER FLOODED! It is ready for you to put your mark on it with your design and decor preferences. View at your own risk - you will fall in love!' ,`Acres` = '0.3655' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TIMBER RIDGE 02, BLOCK 9, LOT 225' ,`LotDesciption` = 'Wooded' ,`LotSize` = '15920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '22' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Timber Ridge 02' ,`TaxAmount` = '4285' ,`TaxRate` = '2.5954' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623763' WHERE `Matrix_Unique_ID` = '213281644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:42:14.917' ,`MLSNumber` = '52640442' ,`ListAgentFullName` = 'James Green' ,`ListOfficeName` = 'Green & Associates Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362409' ,`Longitude` = '-95.619047' ,`PhotoCount` = '16' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Ivanhoe' ,`StreetNumber` = '16680' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like new 2 story home with granite counters, soft closing drawers/cabinets, 42\" upper cabinets, walk in pantry and tiled floors downstairs. Master bedroom with private bath and large walk-in shower is located downstairs, with 3 bedrooms and a full bath upstairs. Located close to Lake Conroe!!' ,`Acres` = '0.0416' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE VILLAGE, BLOCK 6, LOT 57' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Village' ,`TaxAmount` = '126' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623763' WHERE `Matrix_Unique_ID` = '213319075' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T05:59:09.207' ,`MLSNumber` = '88244474' ,`ListAgentFullName` = 'Carlos Guerra' ,`ListOfficeName` = 'Exit Realty 360' ,`SellingAgentFullName` = 'Dustin Young' ,`SellingOfficeName` = 'Compean Group' ,`Latitude` = '29.641026' ,`Longitude` = '-95.548000' ,`PhotoCount` = '22' ,`PostalCode` = '77031' ,`RoomCount` = '7' ,`ListPrice` = '257000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'AIRPORT' ,`StreetNumber` = '9579' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT LOCATION ONE OF THE HEART PART OF THE SOUTHWEST AREA BEAUTIFULL INSIDE LIGHT HOUSE EASY ACCESS,20 MINUTES TO DOWNTOWN TO FREEWAY 12 MINUTES TO GALLERIA AND EASY ACCESS TO SUGARLAND AND AREAS AROUND A LOT SPACE TO ENTERTEIMENT FAMILY AND FRIENDS HAS NICE BACK YRAD READY TO BUILD A POOL ,LARGE DRIVE WAY TO HOLD PEOPLE OVER AND HIGH CATEDRAL CEILING AT LIVING ROOM AND MASTER BEDROOM ,NEW PORCELAIN FLOORS,LAMINATE FLOORS,QUARTZ TOP COUNTER KITCHEN ,NEW A/C DUCTS BEEN REPLACED COME TO SEE!!!!' ,`Acres` = '0.2182' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 28 GLENSHIRE SEC 9' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '9504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '516' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Glenshire' ,`TaxAmount` = '3775' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623763' WHERE `Matrix_Unique_ID` = '213354234' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:16:37.350' ,`MLSNumber` = '80164016' ,`ListAgentFullName` = 'Charity Yarborough' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776942' ,`Longitude` = '-95.460625' ,`PhotoCount` = '46' ,`PostalCode` = '77024' ,`RoomCount` = '17' ,`ListPrice` = '2200000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinehaven' ,`StreetNumber` = '551' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4517' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing close in Memorial home is in a prime location in one of Houston\'s most sought after neighborhood, Pinewood Estates.This gorgeously renovated & expanded home sits on a huge lot & is zoned to outstanding SBISD schools, including Hunter\'s Creek Elementary & Memorial High School. The home boasts a gracious foyer opening to the Formal Living Room, Formal Dining Room & large Family Room that is open to the chef\'s Kitchen & Breakfast Room. The fabulous walk in Wet Bar is accessible from the Family Room & Kitchen - all amazing for entertaining. The downstairs Primary Bedroom suite opens to the New Orleans style patio & features a spa like Bath w/dual vanities, separate shower and jetted tub. Downstairs there are 3 other Bedrooms, 2 full Baths & a beautiful Powder Room.The amazing upstairs addition features a large Bedroom with ensuite Bath & opens to a huge balcony, the Game Room & large Den/Office/Family Room. HOA includes private neighborhood security & trash services. A MUST SEE' ,`Acres` = '0.6006' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Close In' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 PINE WOOD ESTATES' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '26160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '115' ,`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` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Wood Estates' ,`TaxAmount` = '39992' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623763' WHERE `Matrix_Unique_ID` = '213413737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:30:27.150' ,`MLSNumber` = '78179429' ,`ListAgentFullName` = 'Crystle Neumann' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.010249' ,`Longitude` = '-95.744548' ,`PhotoCount` = '32' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '348000.00' ,`Status` = 'Active' ,`StreetName` = 'Bouganvilla Blossom' ,`StreetNumber` = '20515' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Call Fairfield HOME in this beautifully updated gem! Enormous covered patio with gabled roof ,overlooking lush mature landscaping.Recently painted interior with neutral grey tones ,downstairs flooring recently upgraded to engineered hardwood flooring.Six inch baseboards in the entryway,dining,living room.Fireplace upgraded with new tile.Large gameroom upstairs .Full size bathroom upstairs with upgraded shower tile. \r\nSpacious primary room with oversized closet.\r\nMany neighborhood amenities in this Master Planned Community :including parks, pools, walking trails,gym and lakes. CFISD schools!' ,`Acres` = '0.1377' ,`Area` = '35' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 4 FAIRFIELD VILLAGE WEST SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '970' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KEITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Village West' ,`TaxAmount` = '6762' ,`TaxRate` = '2.616' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623764' WHERE `Matrix_Unique_ID` = '213593208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:23:02.140' ,`MLSNumber` = '8901075' ,`ListAgentFullName` = 'Deanna Zugheri' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826334' ,`Longitude` = '-95.424663' ,`PhotoCount` = '42' ,`PostalCode` = '77018' ,`RoomCount` = '8' ,`ListPrice` = '653000.00' ,`Status` = 'Active' ,`StreetName` = '42nd' ,`StreetNumber` = '1006' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The curb appeal welcomes you into this updated traditional Garden Oaks home on a desirable block within walking distance to popular neighborhood restaurants and retail. As you enter the home you are greeted by fabulous wood ship-stairs in the entryway. The living room is filled with natural light and is open to the kitchen through the breakfast bar next to the shiplap accent wall. Spacious kitchen features cabinets with Texas hardware and glass fronts, granite counters, under-counter lighting, and a beautiful wood slat ceiling. The cozy dining is accessible through the kitchen and entry and is perfect for entertaining. Barn doors open to the primary suite with a large walk-in closet, corner soaking tub, and separate shower with stone floor. Secondary bedrooms are downstairs and the possible 4th bedroom upstairs can also be a home office or playroom. The backyard oasis is shaded by an amazing Oak surrounded by a huge deck. Imagine you are on vacation with the beach mural and cabana bar.' ,`Acres` = '0.1942' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Garden Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 52 GARDEN OAKS 5 GARDEN OAKS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Oaks' ,`TaxAmount` = '9794' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623764' WHERE `Matrix_Unique_ID` = '213594186' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:47:18.687' ,`MLSNumber` = '14219708' ,`ListAgentFullName` = 'Jon Shuler' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292667' ,`Longitude` = '-95.484315' ,`PhotoCount` = '38' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Upton' ,`StreetNumber` = '1126' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in the cozy neighborhood of Cayden Creek, you don\'t want to miss this exquisite find. This home offers a functional floor plan with a large primary bedroom, two guest bedrooms, a flex room and an open concept kitchen/living space. Enjoy the tasteful upgrades in the kitchen including double paned silestone countertops, over-sized stainless-steel sink, 42\" cabinets with newly installed hardware and updated light fixtures. The primary bathroom boasts updates including painted accent wall, new light fixture, painted vanity with hardware, trendy round mirrors, jet black faucets and additional shelving. Take advantage of the sizeable flex room with a custom built-in 8\' x 2.5\' desktop. This space is perfect for an office, game room or even an extra bedroom. Other notable upgrades: herringbone accent wall addition to guest bedroom, covered patio, Dupure water softening system, paint throughout entire home, window treatments. Full list of upgrades in attachments.' ,`Acres` = '0.1299' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S336600 - CAYDEN CREEK 01, BLOCK 2, LOT 17' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '485' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cayden Creek 01' ,`TaxAmount` = '6548' ,`TaxRate` = '2.8863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623764' WHERE `Matrix_Unique_ID` = '213914134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:42:45.447' ,`MLSNumber` = '22828622' ,`ListAgentFullName` = 'Elizabeth Villarreal' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835724' ,`Longitude` = '-95.465405' ,`PhotoCount` = '30' ,`PostalCode` = '77092' ,`RoomCount` = '4' ,`ListPrice` = '439500.00' ,`Status` = 'Active' ,`StreetName` = 'Verdome' ,`StreetNumber` = '5005' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely gorgeous Oak Forest mid-mod brick cottage with many recent updates including new kitchen with farm sink, freshly painted exterior, insulated windows (2021), renovated guest bath with timeless marble (2021), HVAC system (2022). Full of natural light and graced with mature oak trees in the front yard, this special 4 bedroom home with 2 full baths has an invaluable secret: a detached 2 car garage off the beautiful backyard patio which is utilized as a workshop, home gym and outdoor living area. Garage plus patio & yard provide an incredible space for entertaining & parties. Sellers report low utility bills and still thoroughly enjoy their 50 gal water heater! Security system, all kitchen appliances, washer & dryer stay. Never flooded; flood insurance not required per Sellers. Just a hop, skip & jump from gathering spots such as Local Table, D’Alba, Aladdin, Common Bond, The Stomping Grounds, Les Baget, Walking Stick Brewery & T.C Jester Park\'s acres of space to run free.' ,`Acres` = '0.166' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 9 OAK FOREST SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7232' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '6203' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623764' WHERE `Matrix_Unique_ID` = '213974016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:46:44.260' ,`MLSNumber` = '22004245' ,`ListAgentFullName` = 'Travis Wade' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.631989' ,`Longitude` = '-95.347676' ,`PhotoCount` = '25' ,`PostalCode` = '77048' ,`RoomCount` = '10' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Bungalow' ,`StreetNumber` = '5123' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1655' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a completely remodeled house completed in February or 2022. New flooring, fans and light fixtures, appliances, paint, granite countertops, sinks and plumbing fixtures, back glass door, AC system, electrical panel and water heater. This house has a large corner lot on a quiet street. 5 miles from Hobby Airport. Come by and see it.' ,`Acres` = '0.1713' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 35 CRESTMONT PARK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CODWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crestmont Park Sec 05' ,`TaxAmount` = '1546' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623765' WHERE `Matrix_Unique_ID` = '214023025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:08:29.643' ,`MLSNumber` = '65011785' ,`ListAgentFullName` = 'Alisa Griffin' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.916853' ,`Longitude` = '-95.680476' ,`PhotoCount` = '35' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '348000.00' ,`Status` = 'Active' ,`StreetName` = 'Deep Prairie' ,`StreetNumber` = '17315' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2941' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful home in the prestigious gated neighborhood of \"Canyon Lakes at Stonegate\". This well-maintained home WOWS you as you enter the front door. It features 4 bedrooms 2.5 baths Let\'s not forget one of the main features of this home is the bright kitchen that boasts plenty of storage with an SS refrigerator and full-length windows in the den that overlooks the backyard. Soaring ceilings in the den and these amazing windows allow the outdoors in! The elegantly designed Primary Suite with a separate tub, and shower with his and her closets. This beautiful haven is waiting for its new owner.' ,`Acres` = '0.1515' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 CANYON LAKES AT STONEGATE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lakes At Stonegate 06' ,`TaxAmount` = '6865' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623765' WHERE `Matrix_Unique_ID` = '214152495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:10:06.870' ,`MLSNumber` = '36042528' ,`ListAgentFullName` = 'Alisa Griffin' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.899706' ,`Longitude` = '-95.683903' ,`PhotoCount` = '25' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Brighton Lake' ,`StreetNumber` = '8331' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2486' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A REAL SHOWSTOPPER! Highly coveted custom 1-story with all the bells and whistles located in the beautiful Copper Lakes neighborhood. A light, bright and sophisticated decor theme is featured throughout this meticulously maintained home that looks and feels like new construction. Granite countertops, elegant lighting, wood and tile floors throughout carpet in bedrooms. Plus, blinds, high ceilings, a niche, recessed LED lighting, and the office can be used as 4th bedroom. Great location close to US 290, Grand Parkway, This one won\'t last!' ,`Acres` = '0.1896' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 COPPER LAKES SEC 10' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '915' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Copper Lakes Sec 10' ,`TaxAmount` = '7560' ,`TaxRate` = '2.5535' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623765' WHERE `Matrix_Unique_ID` = '214152901' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T05:11:57.263' ,`MLSNumber` = '8006303' ,`ListAgentFullName` = 'Cindy Boyd' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = 'Nancy WeHunt' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.280981' ,`Longitude` = '-95.551741' ,`PhotoCount` = '34' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '825000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mayfield' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'EXCEPTIONAL EXECUTIVE HOME in Woodforest\'s master planned golf course community! GATED section on oversized lot, pool with waterfalls, spa, outdoor kitchen, gas firepit & expansive covered patio. Other features: full home generator, spray foam insulation, 3 car tandem garage, plantation shutters, wood-look tile & soaring ceilings throughout. This open-concept floor plan showcases a study with custom shelving, fully equipped media room, surround sound inside and out, and en-suite baths in each bedroom. Stunning kitchen boasts high end finishes: sub zero fridge, GE monogram gas cooktop, double ovens, double stacked upper cabinets with lighting & oversized kitchen island. Wine grotto with iron door, tiled fireplace surrounded with custom wall feature & wood beams in living room & kitchen/dining areas. Elegant primary has custom stained wood barrel ceiling and oversized walk-in custom closet. Bath has custom tile, marble counters, soaking tub & expansive walk-in shower. A must see' ,`Acres` = '0.2811' ,`Area` = '39' ,`BuilderName` = 'Darling Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965263 - WOODFOREST 63, BLOCK 1, LOT 33' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '12246' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1749' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Woodforest 63' ,`TaxAmount` = '12169' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623765' WHERE `Matrix_Unique_ID` = '214252913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:24:21.153' ,`MLSNumber` = '11746893' ,`ListAgentFullName` = 'Rhonda Power' ,`ListOfficeName` = 'Boulevard Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825810' ,`Longitude` = '-95.465077' ,`PhotoCount` = '39' ,`PostalCode` = '77092' ,`RoomCount` = '3' ,`ListPrice` = '388000.00' ,`Status` = 'Active' ,`StreetName` = 'Hialeah' ,`StreetNumber` = '5015' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You can have an urban lifestyle and a spacious home in a darling neighborhood for under $400K! Two living areas provide the flexibility our ever changing lifestyles need. The kitchen, open to the den and dining area, has copious cabinets and counter space designed for everyday living and those holiday affairs. Ambience is created in the den with inviting views of the backyard and the fireplace flanked by bookcases. True hardwoods abound. Tastefully refreshed with new lighting and recent paint in shades of grey and white on interior walls, cabinets, bookcases and exterior. Unexpectedly spacious primary bedroom welcomes a king-sized bed. Well-maintained home with updated double-paned windows, whole house surge protector, electrical panel & sprinkler system. Pergola, brick paver patio and recent privacy fence enhances your backyard sanctuary. Minutes to neighborhood parks, bike trails, dining, entertainment, shopping and freeways = urban living. No flooding history.' ,`Acres` = '0.1725' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 3 MANGUM MANOR SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7514' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mangum Manor Sec 01' ,`TaxAmount` = '7406' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623765' WHERE `Matrix_Unique_ID` = '214366781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:57:29.143' ,`MLSNumber` = '17833367' ,`ListAgentFullName` = 'Charles Pritchett' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.162412' ,`Longitude` = '-95.615721' ,`PhotoCount` = '9' ,`PostalCode` = '77486' ,`RoomCount` = '7' ,`ListPrice` = '357500.00' ,`Status` = 'Active' ,`StreetName` = 'Merion' ,`StreetNumber` = '2' ,`StreetSuffix` = 'Lane' ,`City` = 'Columbia Lakes' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2 Merion Lane. This charming and well-maintained two-story home is situated on a 1/2-acre lot in the gated community of Columbia Lakes. 3 bedrooms, 2 1/2 bath Includes Plantation shutters throughout, built in entertainment and fireplace, shiplap and crown molding. Bamboo and Slate flooring in living and kitchen area. Granite countertops. Bonus room could be used for office, work out or game room. New A/C in 2021, Brick and Hardy exterior, Sprinkler system throughout the yard, water softener, Security System. Garage includes extra storage. Backyard is spacious, beautifully landscaped, fenced and ready to relax and entertain. This HOA subdivision has an attended front gate, swimming pool, great walking, running, biking and golf cart riding as well as Lagoons for fishing. This remarkable home is a must see! Owners are motivated!' ,`Acres` = '0.5233' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 1 (A0133 M VARNER) BLK 3 LOT 47-48' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '22795' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '5522' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623766' WHERE `Matrix_Unique_ID` = '214378550' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:29:39.663' ,`MLSNumber` = '56599664' ,`ListAgentFullName` = 'Jamie Terry' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.519630' ,`Longitude` = '-95.039969' ,`PhotoCount` = '38' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'White Sands' ,`StreetNumber` = '3204' ,`StreetSuffix` = 'Way' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2437' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulously maintained single story home perfectly nestled amongst the mature trees. Enter to a covered front porch, high ceilings and arched entries. An abundance of windows illuminate the home with morning light. Chef\'s kitchen open to the living room features lengthy countertops, an abundance of cabinets offering ample storage and a breakfast bar perfect for entertaining. Formal dining room off of the kitchen. Home office/study perfect for the one working from home. Living room features high ceilings, laminate flooring and a cozy fireplace for those cold winter nights. Primary bedroom with en-suite bath features double sinks, new paint, walk-in shower, soaking tub and a walk-in closet. New interior paint in the kitchen and primary bath Nov 2022 and new carpet in all four bedrooms Nov 2022. All new duct work 2019. New roof 2017. Fridge, washer and dryer stay with the home. Zoned to CCISD. No flooding. Hurry and schedule your tour today; you will fall in love.' ,`Acres` = '0.1701' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 PAGE 11 SOUTH SHORE VILLAGE SEC 6 (98), BLOCK 1, LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7408' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Village Sec 6 98' ,`TaxAmount` = '7133' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623766' WHERE `Matrix_Unique_ID` = '214566811' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:46:41.233' ,`MLSNumber` = '2343472' ,`ListAgentFullName` = 'Gabriel Mendoza' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = 'Gabriel Mendoza' ,`SellingOfficeName` = 'Orchard Brokerage' ,`Latitude` = '29.636209' ,`Longitude` = '-95.763538' ,`PhotoCount` = '30' ,`PostalCode` = '77406' ,`RoomCount` = '15' ,`ListPrice` = '499000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Velda May' ,`StreetNumber` = '2927' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Stunning curb appeal welcomes you home! This 4 bed/3.5 bath features an office, formal dining room, and an upstairs loft. A farmhouse sink, ample cabinetry, and tile backsplash are just a few highlights in the beautiful kitchen. The kitchen opens up to both the breakfast nook and family room, allowing guests to move as they please. High ceilings, natural light, and a fireplace will definitely captivate guests in the family room. Hard surfaced floors throughout the main level are ideal for easy cleaning. Tucked away for extra privacy, the primary bedroom features a spa-like 5 piece en-suite bath. Modern tile flooring can be found in the half bath and primary bathroom. The upstairs loft can be turned into an extra living space, game room, or playroom. The private backyard that is a blank slate to make it your own! Head over to the recently built park just down the road. Welcome home to your new oasis!' ,`Acres` = '0.1722' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MCCRARY MEADOWS SEC 2 PARTIAL REPLAT NO 1 AND EXTENSION, BLO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mccrary Meadows Sec 2 Pt Rep 1 & Ext' ,`TaxAmount` = '9286' ,`TaxRate` = '2.8548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623766' WHERE `Matrix_Unique_ID` = '214626134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T06:47:36.423' ,`MLSNumber` = '69852230' ,`ListAgentFullName` = 'Shelby Crowe' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.428725' ,`Longitude` = '-95.412404' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '13' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Bach' ,`StreetNumber` = '3714' ,`StreetSuffix` = '' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home 3714 Bach-This Fabulous 2 story very popular Highland floor plan-Primary bed/bath down-2nd bed/bath down-2 beds /bath upstairs and game room-first floor large open floor plan-family-room and kitchen dining area room for a very large family-large island room for 5 bar stools-your family gatherings-granite counter tops-stainless steel appliances-laundry first floor with a window to let in natural light-Grand entrance with a beautiful staircase leading to game room-2 bedrooms-bath up stairs which over looks the family room which makes it even more open and spacious-this wonderful home is located within walking distance to the 20 acre lake to go fishing are just taking a stroll around the lake -most of all you have no back neighbors lots of privacy-walking distance to Freedom Stadium to enjoy football without getting in all the traffic-the perfect spot-not to mention all the amenities Meridiana has to offer-a must see-Won\'t last long-Call for your private showing' ,`Acres` = '0.1' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 75 (A0513 HT&BRR) (IOWA COLONY) BLK 2 LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '11369' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623766' WHERE `Matrix_Unique_ID` = '214719612' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214738016','1668623767','214738016','2022-11-16T06:41:04.547','54562471','Jenny Dinh','B & W Realty Group LLC','','','29.889373','-95.724357','32','77433','5','280000.00','Active','Pinos Verde','20503','Drive','Cypress','2','0','3','1791','Single-Family','Welcome to this Beautiful 3 bed and 2 bath home in Prime location of Cypress. This CORNER LOT home is very well maintained that you will be able to move-in in good condition. All appliances are in perfect conditions. NO CARPET at all. RENOVATED KITCHEN AND CABINET with self closing gives the home a NEW LOOK. WASHER AND DRYER STAY. Easy access to I-10 and Grand Parkway, local shops, and restaurants. SCHEDULE YOUR SHOWING TODAY','0.1458','25','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Cypress South','Central Gas','1','LT 39 BLK 3 CANYON VILLAGE AT CYPRESS SPRINGS SEC 8','Subdivision Lot','6349','Appraisal District','','550','0','','2','Electric Oven,Gas Oven','0','','','Gas Cooktop','','Wood Shingle','13 - Cypress-Fairbanks','WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS PARK HIGH SCHOOL','HOPPER MIDDLE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Canyon Spgs Sec 08','5185','2.69','Public Sewer,Public Water','2007','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214788211','1668623767','214788211','2022-11-16T06:27:37.020','66931910','Penny Salter','Penny Salter Properties','','','29.871631','-95.461385','14','77088','8','254500.00','Active','Black Locust','3902','Drive','Houston','2','0','3','1725','Single-Family','Awesome updates to this 3-2-2 detached garage on cul de sac street, Fresh interior paint, wood look tile in all areas except two bedrooms, formal living/dining entertaining area with builtin cabinet w/glass fronts, wine rack, tiled backsplash, quartzite countertop. Kitchen w/shaker style cabinets, apron ss sink, ss gas stove, vent & dishwasher, quartzite countertop w/leather finish, pendant lights over breakfast bar, recessed lighting, breakfast room w/french doors to covered patio, family room w/beamed ceiling, corner curved brick fireplace. Primary bedroom has french door to patio, w/en suite, vanity w/quartzite countertop & copper color glass sink, oversized shower w/glass enclosure & quartzite trim. Hall bath w/granite countertop. Tiled exterior patio between house w/lighting & ceiling fan. Roof 2017, ring door bell, 2 motion lights, alarm. Don\'t want to miss this one! Professional photos coming soon!','0.1776','11','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Northwest Houston','Central Gas','1','LT 15 BLK 6 INWOOD PINES SEC 1','Subdivision Lot,Wooded','7735','Appraisal District','','270','0','','2','Freestanding Oven,Single Oven','0','','','Gas Cooktop','','Composition','1 - Aldine','CARAWAY ELEMENTARY SCHOOL (ALDINE)','EISENHOWER HIGH SCHOOL','HOFFMAN MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Inwood Pines Sec 01','3824','2.5119','Public Sewer,Public Water','1972','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214801320','1668623767','214801320','2022-11-16T06:36:54.597','42845172','Salvador Caballero','ListWithFreedom.com','','','29.644303','-95.353082','37','77048','8','196000.00','Active','Roandale','10618','Drive','Houston','2','0','4','1320','Single-Family','4 bedroom 2 bath Single-Family House fenced and gated with about 1500 sq ft recently remodeled in 2018. Property is located in a family-oriented community in South Acres with easy access to highway system and good schools.','0.1736','3','','','','','Sellers Disclosure','','','','Medical Center South','Central Gas','0','LT 21 BLK 6 SOUTH ACRES ESTATES SEC 2','Corner','7560','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','WOODSON ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','South Acres Estates Sec 02','3277','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214801384','1668623767','214801384','2022-11-16T06:48:01.820','11530962','Kristi Halphen','RE/MAX Cinco Ranch','','','29.801514','-95.568886','35','77043','9','485000.00','Active','Kyler Oaks','10823','Place','Houston','3','1','3','2941','Single-Family','RARE FIND! ELEVATOR INSTALLED to all three levels. Conveniently located in the beautifully GATED community of City Heights on Brittmoore features a 3 Bedroom, 3.5 Bath home with high ceilings, natural light, crown molding, granite and an Elevator for easy access to all three levels. Entertain in the Great Room open to the island kitchen, complete with granite countertops, decorative tile backsplash, gas cooktop, breakfast bar. Relax in the spacious ensuite bath featuring a soak tub and walk-in shower w/bench seating. Enjoy your morning coffee on the covered patio balcony or stone patio in the backyard. Daily walks around the area neighborhood lake. Located near Sam Houston Tollway and I-10, only minutes away from Memorial City Mall, Energy Corridor and Village Plaza at Bunker Hill. Hospitals, shopping, entertainment and area Parks/Nature trails are all nearby. Spring Branch ISD schools. LOW TAX RATE!','0.0609','24','K. Hovnanian','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gaslog Fireplace','1','Spring Branch','Central Gas,Zoned','1','LT 97 BLK 1 CITY HEIGHTS AT BRITTMOORE','Subdivision Lot','2651','Appraisal District','','975','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','49 - Spring Branch','SHERWOOD ELEMENTARY SCHOOL','SPRING WOODS HIGH SCHOOL','SPRING OAKS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal','3','Contemporary/Modern','City Hts/Brittmoore','10057','2.4415','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully