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-31T19:38:38.243' ,`MLSNumber` = '86429322' ,`ListAgentFullName` = 'Donna Patterson' ,`ListOfficeName` = 'R.E.D (Real Estate Driven)' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.361784' ,`Longitude` = '-95.797241' ,`PhotoCount` = '50' ,`PostalCode` = '77461' ,`RoomCount` = '10' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Morgan' ,`StreetNumber` = '13220' ,`StreetSuffix` = 'Lane' ,`City` = 'Needville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller! Fabulous 2 acres of land with a beautifully modified custom home! Over 4300 square feet of country living space ready for your customization. Enormous Master suite downstairs (includes a private entrance). Also on the first floor, just off the kitchen, is an-law suite with a private full bath and jetted tub (or an office). Three bedrooms upstairs share a full bathroom. Bonus space is the enclosed Porte Cochere. Move In Ready! No HOA!' ,`Acres` = '2' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MORGAN ACRES, LOT 3, ACRES 2.00' ,`LotDesciption` = 'Cleared' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Morgan Acres' ,`TaxAmount` = '7699' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705287' WHERE `Matrix_Unique_ID` = '204345320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T19:25:37.470' ,`MLSNumber` = '6704344' ,`ListAgentFullName` = 'Steven Ciapi' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805028' ,`Longitude` = '-95.377164' ,`PhotoCount` = '6' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Tabor' ,`StreetNumber` = '1502' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing opportunity to purchase 9000 Sq. ft. corner lot of unrestricted land in one of the most up and coming Heights area locations (Brooksmith.) Property has a house and garage apartment that can be rehabbed or build new in a prime location for new construction matching the higher priced new construction that is nearby. Please do not disturb tenants.' ,`Acres` = '0.2066' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 & TR 4 BLK 97 BROOKE SMITH' ,`LotDesciption` = 'Corner' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brooke Smith' ,`TaxAmount` = '10931' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1943' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705287' WHERE `Matrix_Unique_ID` = '208371902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T18:23:54.983' ,`MLSNumber` = '914830' ,`ListAgentFullName` = 'Rocio Salas' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924287' ,`Longitude` = '-95.485246' ,`PhotoCount` = '35' ,`PostalCode` = '77086' ,`RoomCount` = '7' ,`ListPrice` = '257500.00' ,`Status` = 'Active' ,`StreetName` = 'Northwest Park' ,`StreetNumber` = '10174' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful House in a well maintain subdivision, fully updated with a green new grass front and back of house, new stove and dishwasher, ready to move in. NEW... paint, doors, new windows, laminate floors, complete exterior siding and trim, complete plumbing and some electrical. House is ready to welcome you!' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARMICHAEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Northwest Park' ,`TaxAmount` = '3162' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705287' WHERE `Matrix_Unique_ID` = '208597729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T19:42:49.783' ,`MLSNumber` = '26071278' ,`ListAgentFullName` = 'Eric Singh' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.623728' ,`Longitude` = '-95.683062' ,`PhotoCount` = '45' ,`PostalCode` = '77498' ,`RoomCount` = '5' ,`ListPrice` = '487700.00' ,`Status` = 'Active' ,`StreetName` = 'Brushy Knoll' ,`StreetNumber` = '13206' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3388' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to luxury living at its finest! Pristine Brick home in the prestigious gated Orchard Lake Estates! This 5 bedroom, 4 bathroom home showcases an open concept living, formal dining, breakfast room, and a chef\'s dream kitchen with granite countertops, large island, double ovens, gas cooktop, stainless steel appliances and generous storage. Family room features cozy fireplace, soaring ceilings and large picture windows for abundant natural light. Relax in the owner\'s retreat with it\'s spacious en-suite bath, double vanities, walk in shower, and custom walk in closet! Don\'t miss this stunning beauty! This home will not last!' ,`Acres` = '0.2254' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ORCHARD LAKE ESTATES SEC 1, BLOCK 5, LOT 33' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9819' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other,Wood Shingle' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OYSTER CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Orchard Lake Estates' ,`TaxAmount` = '8570' ,`TaxRate` = '2.6329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705287' WHERE `Matrix_Unique_ID` = '209388536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T19:44:16.953' ,`MLSNumber` = '2032080' ,`ListAgentFullName` = 'Rachel Anderson' ,`ListOfficeName` = 'Rachel Anderson Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.953018' ,`Longitude` = '-96.267782' ,`PhotoCount` = '43' ,`PostalCode` = '75859' ,`RoomCount` = '11' ,`ListPrice` = '864999.00' ,`Status` = 'Active' ,`StreetName` = 'Russell' ,`StreetNumber` = '6007' ,`StreetSuffix` = 'Place' ,`City` = 'Streetman' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront, Rustling Oaks on RC Lake just an hour south of DFW. Foyer with TX Star Tile opens to the dining & living rms, gas log firepl & breathtaking view of the lake. Open concept, island kitchen, GAS range, brkft bar, bay window brft nook. From water\'s edge, stunning sunrises & sunsets with the covered back porch providing the perfect place to relax. Split bdrms, Master with Ext door to porch, en suite bath, jetted tub & sep shr, cabinet storage, his & hers sink vanities, walk-in closet, bedrms 2 & 3, walk-in closets, hall bath, tub & shr combo, 4th bdrm or OFFICE upstairs, 2 walk in closets & half bath, sep laundry rm, sink, frzer space, cabinets. GUEST SUITE, Island kitchen open to the living rm with exterior dr to back porch, en suite divided bath, make up vanity, tub & shower combo, walk-in closet & under stairs storage. 3 car att garage. Amazing home with so many possibilities for accommodating home schooling or work with all the perks of recreational living on the lake!!' ,`Acres` = '0.51' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'R1550.04 RUSTLING OAKS ESTATES PHASE IV LOT 27 .51 ACRES' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '22216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '144' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '226 - Fairfield' ,`SchoolElementary` = 'FAIRFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FAIRFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRFIELD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rustling Oaks Estates Ph IV' ,`TaxAmount` = '8617' ,`TaxRate` = '2.062' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705287' WHERE `Matrix_Unique_ID` = '209474399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T19:01:44.620' ,`MLSNumber` = '41993954' ,`ListAgentFullName` = 'Adriane Taylor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.188673' ,`Longitude` = '-95.699315' ,`PhotoCount` = '21' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Gossamer' ,`StreetNumber` = '36934' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1571' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FULLY REMODELED FROM TOP TO BOTTOM. No detail missed on this completely renovated home situated on a private wooded 0.6 acre lot. ALL NEW EVERYTHING in 2022; Doors, Windows, Baseboards, Trim, Carpet, Tile, Cabinets, Vanities, Light Fixtures, Showers, Sinks, and More! Has fresh paint throughout and NEW exterior siding on house and front of single car garage. NEW HVAC, Duct Work, Fiberglass Insulation, CPVC Plumbing, Hot Water Heater, Sewer Lines, and Wood Deck. Electrical has been rewired and features New Switches, Outlets, and Fixtures. Conveniently located minutes from FM 1774 and TX-249. Zoned to Magnolia ISD. Enjoy the low taxes and no HOA\'s while living in this cute country cottage!' ,`Acres` = '0.6' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HAZY HOLLOW EAST EST 06, BLOCK 41, LOT 8, ACRES 0.600' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '26136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hazy Hollow East Estate' ,`TaxAmount` = '2132' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705288' WHERE `Matrix_Unique_ID` = '209991735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T18:11:34.100' ,`MLSNumber` = '70472356' ,`ListAgentFullName` = 'Victoria Christie' ,`ListOfficeName` = 'DiMassa Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385387' ,`Longitude` = '-95.077088' ,`PhotoCount` = '18' ,`PostalCode` = '77510' ,`RoomCount` = '3' ,`ListPrice` = '162500.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue G 1/2' ,`StreetNumber` = '4026' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful half acre with a beautiful flagstone patio. Has covered decks on front and rear. Recent central unit and comes with all appliances.' ,`Acres` = '0.5' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CHRISTIE SUB (2002) ABST 149, LOT 2, MH SERIAL # TXFL1ABO389' ,`LotDesciption` = 'Cleared' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Christie Sub 2002' ,`TaxAmount` = '640' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705288' WHERE `Matrix_Unique_ID` = '210035337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T19:28:01.093' ,`MLSNumber` = '22516784' ,`ListAgentFullName` = 'Rene Gustavo Rivas' ,`ListOfficeName` = 'Steeplechase Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.948250' ,`Longitude` = '-95.566072' ,`PhotoCount` = '31' ,`PostalCode` = '77070' ,`RoomCount` = '5' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Vita' ,`StreetNumber` = '9822' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is located very close to major rd. 1960 & SH 249. Brick all around 1st story, no carpet. TILE & Vinyl flooring throughout the home. The 5th bedroom was professionally built above the garage, \"Previously an attic space.\" The garage was converted into a complete apartment. Living/ dining space, plenty cabinets, full kitchen, and large room suite with full bathroom with access from the side of the home by the entrance. Large covered patio. 2 New large A/C UNITS 1 YRS OLD.. WATER HEATER IS 4YRS , REFRIGERATOR included. HOME HAS NEVER FLOODED' ,`Acres` = '0.0837' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 2 GREEN CREEK ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3644' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DANISH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Creek Estates Sec 02' ,`TaxAmount` = '4749' ,`TaxRate` = '2.8087' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705288' WHERE `Matrix_Unique_ID` = '210142194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T19:46:21.127' ,`MLSNumber` = '68541049' ,`ListAgentFullName` = 'Minh Tran' ,`ListOfficeName` = 'Kinh Do Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932736' ,`Longitude` = '-93.908796' ,`PhotoCount` = '8' ,`PostalCode` = '77619' ,`RoomCount` = '5' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Berry' ,`StreetNumber` = '2421' ,`StreetSuffix` = 'Avenue' ,`City` = 'Groves' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintain home locate near Texas 73. Large back yard, tile most of the house, A/C 2018, car garage remote/remote. Never flooded. No HOA.' ,`Acres` = '0.225' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HOLLIER HTS LT 5 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'ADAMS ELEMENTARY SCHOOL (PORT ARTHUR)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hollier Heights' ,`TaxAmount` = '3079' ,`TaxRate` = '3.1797' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705288' WHERE `Matrix_Unique_ID` = '210164531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T19:18:05.503' ,`MLSNumber` = '98860997' ,`ListAgentFullName` = 'Eric Garcia' ,`ListOfficeName` = 'Carlos Garcia Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782966' ,`Longitude` = '-95.360964' ,`PhotoCount` = '30' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Gentry' ,`StreetNumber` = '2324' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Northside single family brick home features 3 bedrooms 2 baths sitting on a corner lot near Boundary and Fulton street, close to the light rail! Tenant occupied- do not disturb! Tenant pays $1500 / month, tenants pay all utilities including water! Owner supplies the appliances. Seller prefers to sell this property together with 3 other properties along Gentry St ( 2408- Triplex, 2316- Duplex, 2314-Single Family ) Great opportunity to secure multiple properties along the same street inside the loop in the near northside! Proof of funds or approval letter required with offer.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 64 RUBYS U/R' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KETELSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rubys U/R' ,`TaxAmount` = '4715' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705288' WHERE `Matrix_Unique_ID` = '210251430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T19:19:14.440' ,`MLSNumber` = '64968880' ,`ListAgentFullName` = 'Eric Garcia' ,`ListOfficeName` = 'Carlos Garcia Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782550' ,`Longitude` = '-95.360783' ,`PhotoCount` = '20' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Gentry' ,`StreetNumber` = '2314' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Northside single family brick home features 3 bedrooms 1 baths sitting on a 5000 SF lot near Boundary and Fulton street, close to the light rail! Tenant occupied- do not disturb! Tenant pays $1300 / month, tenants pay all utilities including water! Owner supplies the window units. Seller prefers to sell this property together with 3 other properties along Gentry St ( 2408- Triplex, 2316- Duplex, 2324-Single Family ) Great opportunity to secure multiple properties along the same street inside the loop in the near northside! Proof of funds or approval letter required with offer.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 64 RUBYS U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KETELSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rubys U/R' ,`TaxAmount` = '4275' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705288' WHERE `Matrix_Unique_ID` = '210252385' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T18:06:25.293' ,`MLSNumber` = '32718982' ,`ListAgentFullName` = 'Martha Sanford' ,`ListOfficeName` = 'Sticks & Bricks Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.667693' ,`Longitude` = '-95.536289' ,`PhotoCount` = '33' ,`PostalCode` = '77340' ,`RoomCount` = '8' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'River Oaks' ,`StreetNumber` = '1400' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is under construction with approximate completion date end of September. Beautiful one-story home with custom home features. Impressive entry with high ceilings and arches opens to formal dining and family room have tray ceilings and crown moldings. Enjoy cooking and entertaining in your kitchen with granite counters, canister lighting, on-site built 42\' cabinets, Samsung stainless appliances including stove, dishwasher and microwave. Island provides extra workspace and storage. Primary suite is large enough for a sitting area and oversized furniture, tray ceiling with ceiling fan/light + canister lights. Your primary bath includes granite counters with undermount sinks, jetted tub + glass enclosed oversized walk-in shower. His & her closets with built-ins. Your covered back patio includes a ceiling fan with lights. Builder to erect very nice retaining wall. Vacation year round on Elkins Lake 27-hole golf course, tennis court, walking trails and 2 pools. Park & pavilion 3 lakes' ,`Acres` = '0.2811' ,`Area` = '43' ,`BuilderName` = 'AG Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ELKINS LAKE - SEC 4, BLOCK 45, LOT 70' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '12243' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '190' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elkins Lake' ,`TaxAmount` = '255' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705288' WHERE `Matrix_Unique_ID` = '210326499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T19:48:34.020' ,`MLSNumber` = '8675466' ,`ListAgentFullName` = 'Larry Bogany' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681566' ,`Longitude` = '-95.748596' ,`PhotoCount` = '21' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '524900.00' ,`Status` = 'Active' ,`StreetName` = 'Eden Prairie' ,`StreetNumber` = '6106' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this Gorgeous corner lot 4-bedroom, 3-bath and 3 Car Garage!!! Your house is located in the subdivision of Long Meadow Farms. Grand entry with High Ceilings, fireplace and granite countertops in the kitchen. Master suite on the first floor for privacy. Beautiful open floor plan that is amazing for gatherings, and massive bedrooms. The beautiful kitchen flows nicely into the breakfast nook with an opening to the living area. Tons of natural lights and located only minutes from the freeway. This home will go fast!' ,`Acres` = '0.1777' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LONG MEADOW FARMS SEC 32, BLOCK 1, LOT 24' ,`LotDesciption` = 'Corner' ,`LotSize` = '7739' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Long Meadow Farms Sec 32' ,`TaxAmount` = '11465' ,`TaxRate` = '2.9048' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705289' WHERE `Matrix_Unique_ID` = '210931676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T18:18:28.143' ,`MLSNumber` = '66997741' ,`ListAgentFullName` = 'George Snyder' ,`ListOfficeName` = 'Southern Star Properties, LLC' ,`SellingAgentFullName` = 'Kyler Ferris' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.341692' ,`Longitude` = '-95.437504' ,`PhotoCount` = '40' ,`PostalCode` = '77303' ,`RoomCount` = '6' ,`ListPrice` = '264990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hunnington' ,`StreetNumber` = '1922' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 3 bedroom home with fenced back yard, on corner lot with no back neighbors! Covered patio/breezeway makes it great for entertaining family and friends. Quiet, well established neighborhood with great amenities, community pool/park. Zoned to Conroe ISD. Call and schedule your showing today!' ,`Acres` = '0.1542' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ROBINWOOD 01, BLOCK 3, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6717' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Robinwood 01' ,`TaxAmount` = '3734' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705289' WHERE `Matrix_Unique_ID` = '211138985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T18:56:38.870' ,`MLSNumber` = '97336373' ,`ListAgentFullName` = 'Gina Wesneske' ,`ListOfficeName` = 'Zuri Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820377' ,`Longitude` = '-95.417289' ,`PhotoCount` = '30' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Judiway' ,`StreetNumber` = '827' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! This single story home is centrally located in the established quiet neighborhood of Tesslynn in close proximity to the Garden Oaks and Shepherd Forest Subdivisions. Close to HISD Montessori Elementary and St. Rose of Lima Church and School (Pre-K-8). This home also features 3 bedrooms and 1 1/2 bathrooms. Single car garage is still in place or utilize as extra livable square footage in the future. Large mature trees in front and backyard and close to shopping, restaurants and major freeways with easy access to I-610 and US-290. Original hardwood flooring throughout living, dining and bedrooms. New roof installed August 2022! Primary bathroom and kitchen were remodeled in 2016. Spacious, fenced backyard with a large storage shed to provide extra storage. This home is move-in ready or an open canvas ready for your own creative design. No flooding!' ,`Acres` = '0.1566' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 TESSLYNN' ,`LotDesciption` = 'Wooded' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tesslynn' ,`TaxAmount` = '6515' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705289' WHERE `Matrix_Unique_ID` = '211177652' --> 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','211585044','1663705289','211585044','2022-08-31T19:56:18.230','72384533','Wayne Cohen','Bernstein Realty, Inc.','','','29.804497','-95.377173','19','77009','4','439000.00','Active','Tabor','1410','Street','Houston','1','0','2','1086','Single-Family','Quintessential Heights Bungalow with recent updates, including fresh paint inside and out, stunning refinished 1930\'s wood floors, a new roof in 2022 (per seller), and a new energy-efficient HVAC in 2021 (per seller). The previous owner remodeled from the studs with all new electrical and plumbing (per seller). Well maintained and move-in ready Bright and light open floor plan with 9ft ceilings throughout. The home boasts an island kitchen with granite countertops, a walk-in pantry, and a tile backsplash. Fully fenced 6ft wrought iron fence with remote access commercial quality automatic driveway gate, an oversized single detached garage, a huge backyard deck, plus a 16x7 ft storage shed.','0.1148','9','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure,Special Addendum','1','','0','Heights/Greater Heights','Central Gas','0','LT 2 BLK 98 BROOKE SMITH','Subdivision Lot','5000','Appraisal District','','','0','','1','Convection Oven,Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','27 - Houston','JEFFERSON ELEMENTARY SCHOOL (HOUSTON)','HEIGHTS HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Ranch,Traditional','Brooke Smith','6990','2.3307','Public Sewer,Public Water','1930','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T19:47:20.500' ,`MLSNumber` = '34017493' ,`ListAgentFullName` = 'Mazna Ayub' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694638' ,`Longitude` = '-95.458207' ,`PhotoCount` = '46' ,`PostalCode` = '77401' ,`RoomCount` = '12' ,`ListPrice` = '1239000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine' ,`StreetNumber` = '4627' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House has a great location. It is inside 610 loop and has proximity to Medical Center and to some of the best schools, colleges and universities of Houston. House has a grand entrance with 12 feet chandelier in the foyer and another one in the formal dining room. It has an open floor plan with large living room (having high ceiling foyer), huge kitchen (equipped with Sub-Zero and Wolf appliances), and spacious breakfast area. The master bedroom is on the first floor while the rest of the bedrooms are on the second floor with en-suite bathroom and walk-in closets. One of the bedrooms can be used as 2nd Master Bedroom. Game Room and Media Room are next to each other. Backyard has enough space to accommodate swimming pool in future.' ,`Acres` = '0.2014' ,`Area` = '17' ,`BuilderName` = 'Castle Rock' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 1 POST OAK TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8775' ,`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` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Oak Terrace' ,`TaxAmount` = '24827' ,`TaxRate` = '2.3734' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705289' WHERE `Matrix_Unique_ID` = '211591437' --> 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','211947560','1663705289','211947560','2022-08-31T18:08:18.827','47249440','Jack Allen','Allen Sims Real Estate','','','30.013050','-95.512320','18','77379','10','330000.00','Active','York Minster','16015','Drive','Spring','2','1','3','2448','Single-Family','Come see our designer-inspired features throughout this move-in ready home! Minutes from 249 and I-45, this 2-story home has fresh updates throughout. You’re going to love the wood-look tile, new fixtures and beautifully updated kitchen featuring two dining spaces, quartz counters, stainless appliances, glass tile backsplash, Shaker-style cabinets and farmhouse sink. Generous-sized family room features soaring ceilings, recessed lighting and stacked stone gas log fireplace. Downstairs primary with ensuite bath offers dual sinks, dual closets and a glass-enclosed shower. Game room and two beds are located upstairs. Double-paned windows enhance energy efficiency. This home also offers a recent AC unit (2018) and a new garage door. Covered breezeway connects the home to the 2-car garage and oversized back yard with mature trees, sprinkler system and lush St. Augustine grass. Walking distance to Klein ISD schools and Meyer Park. Close to shopping, dining and entertainment in North Houston.','0.2313','13','','','','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Champions Area','Central Gas','1','LT 13 BLK 2 WIMBLEDON PARK','Subdivision Lot','10075','Appraisal District','','664','0','','1','Gas Oven','0','','','Gas Cooktop','','Composition','32 - Klein','MITTELSTADT ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Wimbledon Estates','4713','2.1875','Water District','1975','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','212035573','1663705289','212035573','2022-08-31T18:59:08.737','8270204','Massiel Romero','2M Realty Advisors, LLC','','','30.390630','-95.311367','24','77303','7','250000.00','Active','Williams','10860','Road','Conroe','2','0','3','1524','Single-Family','','1.043','19','','','','','No Disclosures','','','','Conroe Northeast','Other Heating','0','A0529 STEWART THOS G, TRACT 8, MH SERIAL # GDVKMS479624200A,','Other','45433','Appraisal District','','','0','','0','','0','','','','','Other','11 - Conroe','AUSTIN ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Call Occupant,Leave Business Card','Appraisal District','1','Other Style','Steward Thos','809','1.8488','Other Water/Sewer','1997','Appraisal District'); --> New record created successfully