Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T19:56:15.303' ,`MLSNumber` = '86094189' ,`ListAgentFullName` = 'Jorge Llanas' ,`ListOfficeName` = 'David Hulsey, REALTORS ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781812' ,`Longitude` = '-95.351109' ,`PhotoCount` = '6' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Hardy' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property being sold for lot value only. Buyers do your own due-diligence regarding the structure on the property.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 37 LITTLE & DICKINSON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Little & Dickinson' ,`TaxAmount` = '5250' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704909' WHERE `Matrix_Unique_ID` = '201331760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T18:52:51.170' ,`MLSNumber` = '74177723' ,`ListAgentFullName` = 'Ellen Hogan' ,`ListOfficeName` = 'Register Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018011' ,`Longitude` = '-95.387276' ,`PhotoCount` = '32' ,`PostalCode` = '77073' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Tancah' ,`StreetNumber` = '21211' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property Has Solar Panels that will offer a Huge Savings on Electricity. Home is in need of a lot TLC and cleaning to make it your own. Home has Three living areas. 2 downstairs and 1 upstairs. Also has three large bedrooms and two smaller. The pantry is Huge too! . It also has a large back yard. At 3096 square feet and an 80k solar system this is well worth the price. Come see!' ,`Acres` = '0.1771' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 92 BLK 7 WESTFIELD GLEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7715' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '486' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Glen' ,`TaxAmount` = '6521' ,`TaxRate` = '2.6145' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704910' WHERE `Matrix_Unique_ID` = '205375743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T18:24:30.773' ,`MLSNumber` = '8126080' ,`ListAgentFullName` = 'Diana Aguilar' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.216237' ,`Longitude` = '-95.413595' ,`PhotoCount` = '12' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'River Ridge Drive' ,`StreetNumber` = '2533' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1772' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'It\'s Back on the market, Buyer got cold feet. This Spectacular house has been newly remodeled, the features are New Kitchen Cabinets, New Granite Countertop, New Tile floors, New doors throughout the whole house, rooms have Laminate flooring wood , new vanity in the Master bedroom, out side facial has been updated, along with a New roof. Back of house and breezeway has been freshly painted. all wall inside of the house has been freshly painted . When the reservoir was open during Harvey that\'s the only time water did come the house, this is a nice and and quite neighborhood, that area is growing . No HOA Fees, Low Taxes, No flood insurance required unless your lender want one. It\'s a come and See!' ,`Acres` = '0.29' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S578000 - HICKORY RIDGE, BLOCK 2, LOT 17, ACRES 0.29, 50.000' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hickory Ridge' ,`TaxAmount` = '923' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704910' WHERE `Matrix_Unique_ID` = '207110159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T19:47:32.250' ,`MLSNumber` = '55239744' ,`ListAgentFullName` = 'James Cooper' ,`ListOfficeName` = 'Rochelle Marquee Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668067' ,`Longitude` = '-95.357738' ,`PhotoCount` = '14' ,`PostalCode` = '77051' ,`RoomCount` = '5' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee Otis' ,`StreetNumber` = '8606' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home will be under construction near 288 and 610 located in the up and coming Sunnyside Community, the home\'s floor plan features a great layout and flow throughout. Nice open concept living room with dining and kitchen combo, three bedrooms, two full bath and a single car garage. Enjoy easy access to the Medical Center, Downtown and Pearland. You will surely love this home!' ,`Acres` = '0.101' ,`Area` = '3' ,`BuilderName` = 'BellaMe Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 2 F AND E NO 2 U/R ABST 1281 J M SWISHER' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'F & E Sub 2' ,`TaxAmount` = '1034' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704910' WHERE `Matrix_Unique_ID` = '207183317' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T18:12:00.920' ,`MLSNumber` = '15278172' ,`ListAgentFullName` = 'Bridget Smith' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906527' ,`Longitude` = '-95.060353' ,`PhotoCount` = '11' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '146900.00' ,`Status` = 'Active' ,`StreetName` = 'Gum' ,`StreetNumber` = '5215' ,`StreetSuffix` = 'Street' ,`City` = 'Crosby' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for that perfect \"Investment Property\" for monthly mailbox revenue in an \"unrestricted area\"? This great investment 3 bedroom 1 bath home sits on a nice size corner lot of 6978 sq. ft. with plenty of shade. Property has a fenced in front yard along with a storage building. Located conveniently close to HWY 90 and FM 2100 so one could easily transit into Houston and surrounding areas quickly. Now is the time to BUY!! Especially at this asking price!' ,`Acres` = '0.1602' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 9 BURRIS SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '6979' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Burris' ,`TaxAmount` = '2362' ,`TaxRate` = '2.5468' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704910' WHERE `Matrix_Unique_ID` = '209465151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T19:44:46.570' ,`MLSNumber` = '65368463' ,`ListAgentFullName` = 'Michael Sproba' ,`ListOfficeName` = 'Synergy Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.425472' ,`Longitude` = '-95.632054' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '15' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Tree' ,`StreetNumber` = '153' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Texas living with a Mediterranean flair. At just a 7 minute walk to the Bentwater Club House, this property truly boasts resort style living. Lot next door is available for purchase. NEW ROOF. Head inside to find living area complete with stunning windows and grand entertainment center. This kitchen features ornate cabinetry, ample counter and cabinet space, large island, gas range, breakfast bar and butler\'s pantry. Downstairs you will find a guest suite complete with an attached bath and sizable closet. Primary suite is complete with jetted tub, double sinks, and walk-in shower with double rainfall shower heads. Primary closet is a show-stopper with ample storage room. Upstairs you will find a theater room with surround-sound and 2 additional bedrooms. WHOLE HOUSE GENERATOR. Your backyard is sure to wow with pergola, outdoor fireplace, kitchen and water feature. Pool heater can turn the pool into a giant hot tub! You don\'t want to miss this one - come see it today!' ,`Acres` = '0.2506' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 19, BLOCK 1, LOT 5' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '187' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '10246' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704910' WHERE `Matrix_Unique_ID` = '210512844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T19:23:55.267' ,`MLSNumber` = '45908623' ,`ListAgentFullName` = 'Antonio Bermudez' ,`ListOfficeName` = 'Humble Platinum Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.052291' ,`Longitude` = '-94.913867' ,`PhotoCount` = '18' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 660' ,`StreetNumber` = '180' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this Beautiful designed custom-built home on 3/4 of an acre. From a sophisticated front door that leads you into a spacious Livingroom with high ceilings and 8 ft doors throughout. This one-story offers a Grand Primary Bedroom 20x16 with a separate soaking tub and shower and a large custom walk-in closet. The Livingroom opens to a spectacular island kitchen with a huge amount of cabinet space and a coffee bar. The spacious kitchen has stainless steel appliances with beautiful quartz countertops. There are three good-sized bedrooms and bathroom with dual sinks on the opposite side of the home. Natural light flows beautifully throughout the entire home.' ,`Acres` = '0.762' ,`Area` = '52' ,`BuilderName` = 'Valco Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 1, BLOCK 13, LOT 16, ACRES .762' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '33193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Encino Estates, Sec 1' ,`TaxAmount` = '793' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704910' WHERE `Matrix_Unique_ID` = '210520405' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T19:43:51.377' ,`MLSNumber` = '82790143' ,`ListAgentFullName` = 'Jessica Werner' ,`ListOfficeName` = 'Compass RE Texas, LLC- Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342281' ,`Longitude` = '-95.437569' ,`PhotoCount` = '23' ,`PostalCode` = '77303' ,`RoomCount` = '6' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Oxford' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tucked away in the quiet, mature community of Robinwood, welcome to 302 Oxford Dr. Enjoy a spacious back yard, open floor plan, and wonderful neighborhood with walking sidewalks, pool, and many community events! In addition, you are just minutes to the new HEB and I45 for easy access. This home has updated paint throughout, updated kitchen and bathroom granite countertops and appliances, and water heater 2018. This home has so much potential to turn it into your dream space or investment property!' ,`Acres` = '0.1515' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ROBINWOOD 01, BLOCK 6, LOT 29' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Robinwood' ,`TaxAmount` = '3188' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704910' WHERE `Matrix_Unique_ID` = '210549475' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T18:04:26.583' ,`MLSNumber` = '91474992' ,`ListAgentFullName` = 'Robert Gulitti' ,`ListOfficeName` = 'All Star Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813367' ,`Longitude` = '-95.024529' ,`PhotoCount` = '40' ,`PostalCode` = '77562' ,`RoomCount` = '3' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'Oleander' ,`StreetNumber` = '8019' ,`StreetSuffix` = 'Street' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE OPPORTUNITY to purchase a CHARMING HOME with a spacious, CLIMATE CONTROLLED SHOP, Covered RV PARKING, and a stunning BACKYARD OASIS! Situated on 2 lots and NEARLY AN ACRE, this cute & cozy brick home offers an open concept with the kitchen overlooking a breakfast bar into the living room, primary suite with garden tub, large shower & 2 closets. The SPARKLING POOL is a SHOW-STOPPER with its serene rock fountain and fabulous PALAPALA! Your entertainment area is complete with outdoor speakers, TV, & a lush, landscaped & FENCED back yard. The 30’x50’ shop is functionally maximized with 220/single-phase electric, A/C, heat,2-piece bath! Other features include Solar Screens, Security System, 20’x50’ covered RV or trailer storage & plenty of green space left to grow into!' ,`Acres` = '0.84' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 COUNTRY TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '36528' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Terrace Sec 02' ,`TaxAmount` = '4357' ,`TaxRate` = '2.235' ,`WaterSewer` = 'Other Water/Sewer,Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704910' WHERE `Matrix_Unique_ID` = '210725116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T18:29:40.863' ,`MLSNumber` = '76731542' ,`ListAgentFullName` = 'Jennifer Jaeger-Karp' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065121' ,`Longitude` = '-95.231708' ,`PhotoCount` = '38' ,`PostalCode` = '77339' ,`RoomCount` = '5' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Lavender Jade' ,`StreetNumber` = '26022' ,`StreetSuffix` = 'Court' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular 5 bedroom, 3.5 bathroom, 2-story home on a quiet cul-de-sac. The first thing you will notice when entering the home is the spacious open floor plan and the soaring ceilings. Your home office has French Doors for extra privacy. The spacious formal dining room is perfect for family gatherings and dinner parties. The large family room offers floor to ceilings windows for lots of natural light and a cozy fireplace. Kitchen is open to the family room and has tons of cabinets for storage as well as avanza countertops, a butlers pantry, island and gas range cook top. Downstairs also features the spacious primary bedroom with large jetted bath tub, separate walk in shower and large closet. Roof 6/2021, HVAC system 7/2021, Carpet 2020, Water heater 2019, Wood & tile floor 2018. Never flooded. The property is minutes from US 59, Grand Parkway 99, restaurants, banking, shopping, Lonestar Community College, Kingwood Hospital & more.' ,`Acres` = '0.1515' ,`Area` = '40' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S642400 - KINGS MILL 01, BLOCK 3, LOT 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Mill 01' ,`TaxAmount` = '9591' ,`TaxRate` = '3.1831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704911' WHERE `Matrix_Unique_ID` = '210944997' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T18:51:42.063' ,`MLSNumber` = '14438656' ,`ListAgentFullName` = 'Patricia Sayegh' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706842' ,`Longitude` = '-95.436878' ,`PhotoCount` = '13' ,`PostalCode` = '77005' ,`RoomCount` = '6' ,`ListPrice` = '1299000.00' ,`Status` = 'Active' ,`StreetName` = 'Carlon' ,`StreetNumber` = '3779' ,`StreetSuffix` = 'Street' ,`City` = 'Southside Place' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2397' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to build your dream home in Southside Place. This great lot is 7.500 Sf, Close to Fire truck park and Zone to West University elementary.As a resident of Southside place you will get special access to Southside amenities and communities event, SSP Pool,SSP Tennis Court, etc). \r\nProperty is being sold as lot Value. Sellers will make no repairs.' ,`Acres` = '0.1722' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 41 BLK 3 SOUTHSIDE PLACE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Southside Place' ,`TaxAmount` = '25516' ,`TaxRate` = '2.0986' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704911' WHERE `Matrix_Unique_ID` = '211251900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T18:44:04.420' ,`MLSNumber` = '72761619' ,`ListAgentFullName` = 'Kelley Tassone' ,`ListOfficeName` = 'Resident Realty, Ltd.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.753416' ,`Longitude` = '-95.060662' ,`PhotoCount` = '48' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset' ,`StreetNumber` = '249' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1144' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a quiet serene setting to get away for the weekends, or leave the hustle and bustle behind and enjoy the full time benefits of living on Lake Livingston year round. This quaint cottage is a must see! The views off the back deck provide an instant connection with nature, a perfect way to start each day over your morning coffee. The garage/workshop is perfect for those who like to tinker with projects, tons of space to set up a full working shop - so many possibilities. Plus the additional covered carport provides additional space for parking or better yet hosting family BBQ\'s, get togethers. Need a place for your RV? There is room for that as well. AND Residence also have access to 2 boat ramps just down the road. This property sites on two lots. The lot next door is also for sale be sure to check it out - here is an idea, purchase both build a dream home and make this a guest cottage. This is an amazing opportunity to own a lake house in Lake Livingston Estates.' ,`Acres` = '0.0046' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE LIVINGSTON ESTATES SECTION 4 BLK 9 LOT 44 & 45' ,`LotDesciption` = 'Ravine,Subdivision Lot,Water View,Wooded' ,`LotSize` = '200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Livingston Estates Sectio' ,`TaxAmount` = '4244' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704911' WHERE `Matrix_Unique_ID` = '211256169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T19:01:34.457' ,`MLSNumber` = '42948668' ,`ListAgentFullName` = 'Leneice Lewis' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804141' ,`Longitude` = '-95.330569' ,`PhotoCount` = '35' ,`PostalCode` = '77026' ,`RoomCount` = '5' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Falls Street' ,`StreetNumber` = '4822' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This new construction duplex is a rare find and an investor\'s dream! Located within minutes of downtown Houston, each unit has 3 bedrooms and 2 bathrooms, open and spacious living and kitchen areas separated by a lovely kitchen island, a laundry room and private driveways. Both units have beautiful wood looking tile floors, stainless steel hardware, coffered ceilings and granite countertops throughout. Inside the owner\'s suite is a spacious walk-in closets, stand alone shower and large private bath with double vanity sinks. Through the owner\'s suite, the French doors open to a quaint private backyard area. Each unit is pre-wired for security cameras/systems.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Briscoe' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 7 BLOCK 23' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'VALENCIA PARK' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704911' WHERE `Matrix_Unique_ID` = '211357839' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T18:10:26.013' ,`MLSNumber` = '42541260' ,`ListAgentFullName` = 'Joshua Wisdom' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Holly Bittick' ,`SellingOfficeName` = 'DSG Realty Goup' ,`Latitude` = '30.186644' ,`Longitude` = '-95.798781' ,`PhotoCount` = '6' ,`PostalCode` = '77355' ,`RoomCount` = '3' ,`ListPrice` = '260000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wilde' ,`StreetNumber` = '24127' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 3 bedroom 2 bathroom Open Concept home built in 2018. Upgrades include painted kitchen cabinets, backyard patio, water filtration system, and laminate flooring.' ,`Acres` = '0.1405' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S955200 - WILLIAMS TRACE 01, BLOCK 7, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6121' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '348' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Trace 01' ,`TaxAmount` = '3435' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704911' WHERE `Matrix_Unique_ID` = '211363287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T19:46:04.130' ,`MLSNumber` = '85329295' ,`ListAgentFullName` = 'Norma Lewis' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841893' ,`Longitude` = '-95.715928' ,`PhotoCount` = '25' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Wind Trace' ,`StreetNumber` = '4759' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful corner lot home nestled in Windstone Colony with easy access to Katy Freeway, Grand Parkway, and Highway 6 features brick on three sides, a two-car garage, plenty of room in the back and side yards, an open concept living area, a private master bedroom with an en-suite bathroom, and so much more. Come see this one today before it\'s taken!' ,`Acres` = '0.1606' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 WINDSTONE COLONY SEC 7' ,`LotDesciption` = 'Corner' ,`LotSize` = '6997' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '498' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SHERIDAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Ranch,Traditional' ,`Subdivision` = 'Windstone Colony' ,`TaxAmount` = '5117' ,`TaxRate` = '2.781' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704911' WHERE `Matrix_Unique_ID` = '211512990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T18:49:11.340' ,`MLSNumber` = '55453196' ,`ListAgentFullName` = 'Gift Duffield' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Priscilla Pohlen' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.625591' ,`Longitude` = '-95.018993' ,`PhotoCount` = '50' ,`PostalCode` = '77571' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Shady River' ,`StreetNumber` = '706' ,`StreetSuffix` = 'Road' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Honey stops the car! This move-in ready home with 0.72 acre offers so many opportunities, from the 3 subdivision lots combination (you can separate and sell them or build) to the unfinished 2 story loft attic with outside access from separate staircase, think home gym loft, artist loft, workshop, guest quarter with separate entrance, the opportunity is endless. The owners contently live in the renovated downstairs and had no need to finish this attic, use your HGTV inspirations and this loft will be your dream comes true. 2 full updated bathrooms, beautiful kitchen and elegant entrance to welcome friends and family. Spacious living room and another family room with mock fireplace right off the kitchen perfect for dinner parties. Entertainers dream continues with large formal dining room that opens to the patio with gigantic yard. Outside staircase and living room carpet installed in 2022, 2020 Fence, 2019 Roof and AC. Per sellers, home has never been flooded.' ,`Acres` = '0.72708907' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 SHADY RIVER SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '31672' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Shady River Sec 01' ,`TaxAmount` = '6507' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704912' WHERE `Matrix_Unique_ID` = '211592341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T19:38:49.993' ,`MLSNumber` = '98773729' ,`ListAgentFullName` = 'Laura Lane' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844035' ,`Longitude` = '-95.198951' ,`PhotoCount` = '38' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Van Hut' ,`StreetNumber` = '8323' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2001' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unrestricted 1.25 acres and home! Has commercial potential but is currently residential. Beautiful remodled home on over an acre of land. No HOA! Animals allowed & is cross fenced. Granite counter tops and soft close cabinets thougout the home. Only one min from Old HWY 90 and 3 mins from Beltway 8 for an easy commute. This home features double pane windows, Fireplace, Vaulted ceiling in living room, walk in shower in primary plus two walk in closets. Large covered patio that runs along the lenght of the back of the home. Home has Well & aerobic septic so no water bill. Also features a whole house water softner & purifer. Additionaly it has a sewer hook up on one side of the property for a mobile or RV hook up. The acreage has a barn, shed, well house & 30x40 frame for garage.' ,`Acres` = '1.25' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 69 & 70 BLK 12 HOUMONT PARK SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '54449' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houmont Park Sec 01' ,`TaxAmount` = '4039' ,`TaxRate` = '2.2893' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704912' WHERE `Matrix_Unique_ID` = '211994997' --> Updated record success