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-31T13:41:29.557' ,`MLSNumber` = '27893113' ,`ListAgentFullName` = 'Megan Daugherty' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.351328' ,`Longitude` = '-95.118309' ,`PhotoCount` = '40' ,`PostalCode` = '77517' ,`RoomCount` = '12' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'McGinnes' ,`StreetNumber` = '6402' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful CUSTOM built home sits on 1.5 fenced acres in Santa Fe. The spacious, open floorplan offers 4 bedrooms (2 PRIMARY SUITES), 3 full and 1 half bathrooms, 3 car attached garage and 2 car detached garage and workshop. There is also an office/media room, dining room and large kitchen with breakfast bar, island with second sink, stainless appliances-including a double oven, walk-in pantry and breakfast room. The Primary Suite boasts a large ensuite bathroom with 2 walk-in closets, double sinks, make-up vanity and oversized shower. The SECOND Primary Suite would make the perfect teen retreat or Mother-In-Law Suite with a oversized walk-in shower, walk-in closet and private access to the large covered porch. Other features include sprayfoam insulation, beautiful wood tile floors throughout the home, and mobile home on the property that can continue to be income producing or a second home. All of this with NO HOA and a low tax rate. MOTIVATED SELLERS! No flooding per sellers.' ,`Acres` = '1.5' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 47 L CRAWFORD SUR PT OF OUTLOT 412 (412-2) ALTA LOMA OU' ,`LotDesciption` = 'Cleared' ,`LotSize` = '65340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Alta Loma Outlots' ,`TaxAmount` = '11922' ,`TaxRate` = '2.1677' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705190' WHERE `Matrix_Unique_ID` = '206380335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:58:18.567' ,`MLSNumber` = '28210163' ,`ListAgentFullName` = 'Erik Platou' ,`ListOfficeName` = 'J. Lindsey Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975928' ,`Longitude` = '-95.120195' ,`PhotoCount` = '12' ,`PostalCode` = '77532' ,`RoomCount` = '2' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Appaloosa' ,`StreetNumber` = '20535' ,`StreetSuffix` = 'Trail' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = ' Lakefront home on Lake Houston. Beautiful view from entire property. \n\nSet up showing today!' ,`Acres` = '0.2837' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 1 INDIAN SHORES SEC 1' ,`LotDesciption` = 'In Golf Course Community,Water View,Waterfront' ,`LotSize` = '12360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Shores Sec 01' ,`TaxAmount` = '7304' ,`TaxRate` = '2.7056' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705190' WHERE `Matrix_Unique_ID` = '206554082' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:57:10.833' ,`MLSNumber` = '67336708' ,`ListAgentFullName` = 'Pam Holmes' ,`ListOfficeName` = 'Eastex Real Estate Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.699207' ,`Longitude` = '-94.939779' ,`PhotoCount` = '35' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Mockingbird' ,`StreetNumber` = '129' ,`StreetSuffix` = 'Lane' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2075' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come Fall in Love with this Recently Updated Brick home in the Desirable Enchanted Forest Subdivision. This 2,075SF, 3 bedroom, 2 bath home offers: NEW roof, NEW vinyl flooring, NEW Primary bathroom with NEW cabinets, and NEW Countertops . This home\'s charm will win you over with its inviting warm-modern paint colors and LARGE living room with a wood buring Fireplace. The spacious Primary bedroom features en-suite bathroom with split double vanity, gorgeous soaking tub and separate walk-in shower. The converted garage is currently being used as a gameroom/utility room. Large backyard has separate parking and area to build your own shop. Property is conveniently located near Community Golf Course, City park, City Pool and within walking distance to a Restaurant. Call today for your private tour.' ,`Acres` = '0.3444' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ENCHANTED FOREST LOT 26' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enchanted Forest' ,`TaxAmount` = '4054' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705190' WHERE `Matrix_Unique_ID` = '207884056' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:01:24.483' ,`MLSNumber` = '72451598' ,`ListAgentFullName` = 'Robert Perez' ,`ListOfficeName` = 'The Real Estate Service' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.202289' ,`Longitude` = '-96.291659' ,`PhotoCount` = '20' ,`PostalCode` = '77437' ,`RoomCount` = '9' ,`ListPrice` = '179500.00' ,`Status` = 'Active' ,`StreetName` = 'Linnwood' ,`StreetNumber` = '1302' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New roof was put on about a year ago, Fenced back yard, 13,713.00 Sq ft. lot... Home will need some updating and minor repairs...' ,`Acres` = '0.3148' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'I & GN (ABST.249) BLOCK 7D-7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13713' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'I & GN (Abst.249) Block 7D-7 Acres: 0.31' ,`TaxAmount` = '3465' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705191' WHERE `Matrix_Unique_ID` = '207919960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:02:41.823' ,`MLSNumber` = '63722931' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.620565' ,`Longitude` = '-95.382477' ,`PhotoCount` = '15' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Skyview Glen' ,`StreetNumber` = '2647' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1955' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0964' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 62 BLK 1 SKYVIEW PARK SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '4201' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Skyview Park Sec 04' ,`TaxAmount` = '5241' ,`TaxRate` = '2.9307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705191' WHERE `Matrix_Unique_ID` = '208447931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:04:33.393' ,`MLSNumber` = '25567433' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.609038' ,`Longitude` = '-95.378871' ,`PhotoCount` = '20' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Dunhurst' ,`StreetNumber` = '13818' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1429' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 BRUNSWICK MEADOWS SEC 10' ,`LotDesciption` = 'Other' ,`LotSize` = '6223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brunswick Mdws Sec 10' ,`TaxAmount` = '5470' ,`TaxRate` = '2.6498' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705191' WHERE `Matrix_Unique_ID` = '208448908' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:40:30.437' ,`MLSNumber` = '64803158' ,`ListAgentFullName` = 'Arinze Ezebuilo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.522306' ,`Longitude` = '-95.465453' ,`PhotoCount` = '32' ,`PostalCode` = '77545' ,`RoomCount` = '4' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Avery Bay Court' ,`StreetNumber` = '4407' ,`StreetSuffix` = '' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2546' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ANDOVER FARMS SEC 6, BLOCK 1, LOT 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BURTON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Andover Farms' ,`TaxAmount` = '5729' ,`TaxRate` = '2.5734' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705191' WHERE `Matrix_Unique_ID` = '208457302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:52:01.353' ,`MLSNumber` = '86905124' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864700' ,`Longitude` = '-95.282900' ,`PhotoCount` = '6' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '274325.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Saffron' ,`StreetNumber` = '10530' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing one story home will be move-in ready upon the completion in September or October of 2022. The Camden floorplan showcases 3 bedrooms 2 full bathrooms and a 2 car garage! This open concept kitchen is full of high quality cabinetry, a pantry and a large eating area that is blanketed with natural lighting illuminating from the breakfast area windows. It is completed with hard surface flooring throughout the common areas. And for family fun times, it has an amazing covered front porch and back patio that comes standard with this home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '8/1/11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Village' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705191' WHERE `Matrix_Unique_ID` = '208783890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:30:58.510' ,`MLSNumber` = '83382857' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147504' ,`Longitude` = '-95.484395' ,`PhotoCount` = '50' ,`PostalCode` = '77380' ,`RoomCount` = '14' ,`ListPrice` = '3897000.00' ,`Status` = 'Active' ,`StreetName` = 'McDonald' ,`StreetNumber` = '26442' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '8445' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story home on 3.6 acres in gated McDonald Estates! This custom home backs to a lush greenbelt for ultimate privacy, and offers a gated entry, circular drive, oversized 3 car garage + 2 car porte-cochere, Hill Country stone exterior with metal roof, covered front porch, well and septic, and whole house generator. This home was built with entertaining in mind, with open living spaces and a ton of natural light throughout the many windows. Island kitchen opens to the sunny breakfast room; both formals open to one another for an easy flow; huge game room with wet bar; sun room with wall of windows and doors that lead to the wood deck; owner\'s retreat has luxurious bath with dry sauna; 3 additional bedrooms with en-suite baths + guest quarters above the garage. Upstairs could be built out with another 2,000 sf! Private backyard in a park-like setting with extensive wood deck and no rear neighbors.' ,`Acres` = '3.645' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'S696000 - MCDONALD R D-WEST, LOT 52-D, ACRES 3.645' ,`LotDesciption` = 'Greenbelt,Wooded' ,`LotSize` = '158776' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'MCDONALD ESTATES' ,`TaxAmount` = '29861' ,`TaxRate` = '1.8478' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705191' WHERE `Matrix_Unique_ID` = '208790257' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:08:44.217' ,`MLSNumber` = '60608913' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864700' ,`Longitude` = '-95.282900' ,`PhotoCount` = '6' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '246875.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Saffron' ,`StreetNumber` = '10534' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1362' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing one story home will be move-in ready upon the completion in September or October of 2022. The Mitchell floorplan showcases 3 bedrooms 2 full bathrooms and a 2 car garage! This open concept kitchen is full of high quality cabinetry, a pantry and a large eating area that is blanketed with natural lighting illuminating from the breakfast area windows. It is completed with hard surface flooring throughout the common areas. And for family fun times, it has an amazing covered front porch and back patio that comes standard with this home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '9/1/11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Village' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705191' WHERE `Matrix_Unique_ID` = '208837542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:59:36.503' ,`MLSNumber` = '83999153' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560674' ,`Longitude` = '-95.718084' ,`PhotoCount` = '26' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '394900.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Field' ,`StreetNumber` = '1911' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2057' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK WEST SEC 1, BLOCK 1, LOT 8' ,`LotDesciption` = 'Other' ,`LotSize` = '8960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverpark West Sec 1' ,`TaxAmount` = '7527' ,`TaxRate` = '2.8748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705192' WHERE `Matrix_Unique_ID` = '208979021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:06:47.440' ,`MLSNumber` = '77025642' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495033' ,`Longitude` = '-95.051066' ,`PhotoCount` = '23' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Ponte Leone' ,`StreetNumber` = '1622' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1421' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TUSCAN LAKES SEC SF 50-1 SE (2007) ABST 19, BLOCK 2, LOT 1,' ,`LotDesciption` = 'Other' ,`LotSize` = '6191' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SILBERNAGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tuscan Lakes Sec Sf 50-1 Se' ,`TaxAmount` = '8268' ,`TaxRate` = '3.2297' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705192' WHERE `Matrix_Unique_ID` = '209027055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:36:47.830' ,`MLSNumber` = '41576177' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884238' ,`Longitude` = '-95.686719' ,`PhotoCount` = '21' ,`PostalCode` = '77433' ,`RoomCount` = '5' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Thornmeadow' ,`StreetNumber` = '7302' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.193' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 WESTGATE SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '8407' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westgate Sec 01' ,`TaxAmount` = '6655' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705192' WHERE `Matrix_Unique_ID` = '209283127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:08:03.253' ,`MLSNumber` = '58613277' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864700' ,`Longitude` = '-95.282900' ,`PhotoCount` = '6' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '237875.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Saffron' ,`StreetNumber` = '10526' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing one story home will be move-in ready upon the completion in September or October of 2022. The Cooper floorplan showcases 3 bedrooms 2 full bathrooms and a 2 car garage! This open concept kitchen is full of high quality cabinetry, a pantry and a large eating area that is blanketed with natural lighting illuminating from the breakfast area windows. It is completed with hard surface flooring throughout the common areas. And for family fun times, it has an amazing covered front porch and back patio that comes standard with this home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '7/1/11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Village' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705192' WHERE `Matrix_Unique_ID` = '209293057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:49:35.267' ,`MLSNumber` = '61568003' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864700' ,`Longitude` = '-95.282900' ,`PhotoCount` = '6' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '264875.00' ,`Status` = 'Active' ,`StreetName` = 'Hollow Root' ,`StreetNumber` = '7927' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing one story home will be move-in ready upon the completion in September or October of 2022. The Camden floorplan showcases 3 bedrooms 2 full bathrooms and a 2 car garage! This open concept kitchen is full of high quality cabinetry, a pantry and a large eating area that is blanketed with natural lighting illuminating from the breakfast area windows. It is completed with hard surface flooring throughout the common areas. And for family fun times, it has an amazing covered front porch and back patio that comes standard with this home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '12/1/11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Village' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705192' WHERE `Matrix_Unique_ID` = '209296018' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:59:09.080' ,`MLSNumber` = '52110334' ,`ListAgentFullName` = 'Arinze Ezebuilo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759192' ,`Longitude` = '-95.876586' ,`PhotoCount` = '32' ,`PostalCode` = '77494' ,`RoomCount` = '4' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Rose Ct' ,`StreetNumber` = '29306' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful well maintained four bedroom home is situated on a Cul-De-Sac lot. It has a brand new carpet. Home is vacant but requires an appointment.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Firethorne West Sec 12, Block 3, Lot 21' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6541' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Firethorne West' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705192' WHERE `Matrix_Unique_ID` = '209638521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:34:09.730' ,`MLSNumber` = '26196654' ,`ListAgentFullName` = 'Ryan Moody' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.141314' ,`Longitude` = '-95.053350' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '975000.00' ,`Status` = 'Active' ,`StreetName` = 'Matagorda' ,`StreetNumber` = '22218' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely STUNNING canal front home located in a cul-de-sac affording 117ft of water frontage. Plenty of room for that pool that you have been wanting. This meticulously maintained home boasts wide open entertaining spaces from wall to wall. Great split floor plan with souring ceilings in living area. Enjoy a famous Galveston sunset while relaxing on the oversized deck. Ground level entertaining mecca offers multiple gathering spaces both inside and out. Inside area features a bedroom, bathroom, kitchenette, and living area that’s not included in the sq footage. Walking outside you will find a boat house with lift, fishing pier, and plenty of yard space. Amazing opportunity to own a like-new canal house on an amazing lot.' ,`Acres` = '0.1924' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 15 LOT 1880 SEA ISLE 9TH EXTENSION' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8383' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle' ,`TaxAmount` = '11616' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705192' WHERE `Matrix_Unique_ID` = '209892516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:36:26.443' ,`MLSNumber` = '77232973' ,`ListAgentFullName` = 'Teresa Conrad' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.192907' ,`Longitude` = '-95.447919' ,`PhotoCount` = '50' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Centro' ,`StreetNumber` = '18531' ,`StreetSuffix` = 'Row' ,`City` = 'Shenandoah' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2105' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the Urban Living but in quiet setting. Former Model Home. Next Door to the Woodlands. Modern Architecture, designed for pack-to-go lifestyle. 2 attached garage with Electric car outlet on the ground level. Large Living room, Open Floor plan with walls of windows on the 2 level. Upgraded Quartz countertop and sleek high gloss cabinets & gorgeous wood flooring. Enjoy the outdoor with glass of wine either in the balcony on the 2nd level or patio on the ground level. Primary suite with soaring ceiling & another bedroom located on the 3rd floor. Private fenced courtyard. This modern enclave also enjoys a refreshing community pool & Pet-friendly green space park. Maintenance free lawns. Walkability to shopping, dining, and entertainment (restaurants, retail, and entertainment such as AMC theaters,' ,`Acres` = '0.0427' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S336900 - CENTRO 01, BLOCK 4, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Centro 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705192' WHERE `Matrix_Unique_ID` = '210071075' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:21:14.790' ,`MLSNumber` = '85246807' ,`ListAgentFullName` = 'Bridget Moore' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.337853' ,`Longitude` = '-95.700755' ,`PhotoCount` = '33' ,`PostalCode` = '77316-6759' ,`RoomCount` = '3' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Stone Creek' ,`StreetNumber` = '22041' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2837' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a little bit of country living, close to schools and shopping? Come see this beautiful brick home on 2.1 acres in a sought-after neighborhood in the Montgomery School District. This home has gorgeous wood floors throughout. Front room offers large custom built-in shelves, beautiful french doors and plantation shutters that would be perfect for an office or library. The kitchen offers granite countertops, stainless appliances (including a gas range), and a custom wood island. The primary bedroom suite is massive and features a sitting area as well as a beautiful claw tub. There is also a massive walk-in attic that has been fully decked out with storage space galore! And if you\'re worried about power outages, no need - this home offers a whole house generator. Enjoy your evenings outside under the large covered back patio overlooking the large, fenced backyard. This home offers all the comforts of country living with the accessibility to downtown Montgomery in 4 minutes.' ,`Acres` = '2.1' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S9032000 - Stone Creek 01, Block 1, Lot 42 & 43, Acres 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705193' WHERE `Matrix_Unique_ID` = '210227577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:25:20.907' ,`MLSNumber` = '69402452' ,`ListAgentFullName` = 'John Cragar' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.505916' ,`Longitude` = '-95.934539' ,`PhotoCount` = '29' ,`PostalCode` = '77417' ,`RoomCount` = '5' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Lehman' ,`StreetNumber` = '7550' ,`StreetSuffix` = 'Road' ,`City` = 'Beasley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Texas Land Board and USDA Eligible. No Deed Restriction!!! All Unrestricted land with fabulous ranch-style homestead on 10+ acres. Only 15 minutes from Rosenberg\'s HEB. The town of Beasley gives you the best of both worlds, bucolic living with the convenience of nearby amenities. While at home, relax or do automotive work in a 1200 sq.ft. garage space. Shelter your horses in a 4-stable barn. Relax in your master-bath jacuzzi on the expansive grounds of your homestead. Make this place a compound for the family. (or) Buy as an investment property & rent this one of a kind homesite. Cotton to the west; corn to the north. Key features: softened water, high ceilings, open floor plan with spacious rooms. Home office/study & kitchen are well designed & offer extended entertaining space. Kitchen has granite tile counters, kitchen island, appliances, ample counter/cabinet space, & breakfast room overlooking the backyard oasis. One floor living so that no stairs need be mastered.' ,`Acres` = '10.8642' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0417 LESTER E CROSS, BLOCK 36 (PT), ACRES 10.8642, SEC 14, T' ,`LotDesciption` = 'Other' ,`LotSize` = '473245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BEASLEY ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lester E Cross' ,`TaxAmount` = '8468' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705193' WHERE `Matrix_Unique_ID` = '210249705' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:41:46.530' ,`MLSNumber` = '25144325' ,`ListAgentFullName` = 'Arinze Ezebuilo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823721' ,`Longitude` = '-95.712357' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumnglade Place' ,`StreetNumber` = '19631' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2994' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has a new roof, brand new A/C units, microwave, dishwasher and stove. The carpet is also new! This beautiful home was a model home with a lot of upgrades including surround sound, front/back sprinkler system, intercom system, hardwood floors, tile, mirrored dining room, second floor ceiling entry with extended tiles, arched entry into the formal living/dining, tile backsplash in kitchen. Home is on a Cup-De-Sac lot.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 1 WESTFIELD ESTATES SEC 8' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '326' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RHOADS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705193' WHERE `Matrix_Unique_ID` = '210428332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:32:38.017' ,`MLSNumber` = '61759592' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.192332' ,`Longitude` = '-95.608135' ,`PhotoCount` = '31' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '1975000.00' ,`Status` = 'Active' ,`StreetName` = 'Doerner' ,`StreetNumber` = '30315' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '3' ,`BedsTotal` = '4' ,`SqFtTotal` = '3467' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional 1.5 story home on 10 wooded acres in Woodlane Forest! This original owner is a beekeeper, and the hives and agricultural evaluation will transfer to the new owners, providing incredible tax exemptions! This secluded home features a gated entry, circular drive, covered front porch, tankless water heater, PEX piping, crown moulding and transom windows that provide natural light. Spacious kitchen with granite counters, 6 burner gas cooktop, large pantry and plenty of cabinet storage opens to the breakfast room and den with wood burning stove; owner\'s retreat and two bedrooms down; game room, full bath and 4th bedroom up. In addition to the beehives, this property offers a 30,000 gallon heated remote controlled pool and separate spa, stocked pond with fountain, covered patio, outdoor fireplace with pavilion and cabana with pool bath, and endless shade trees. Close to all Woodlands amenities and just 40 min. from Bush Intercontinental Airport!' ,`Acres` = '10' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S973302 - WOODLANE FOREST 02, LOT 59, 60, ACRES 9' ,`LotDesciption` = 'Wooded' ,`LotSize` = '435600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlane Forest 02' ,`TaxAmount` = '76' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705193' WHERE `Matrix_Unique_ID` = '210456614' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:46:13.690' ,`MLSNumber` = '12644683' ,`ListAgentFullName` = 'Jeffrey Morris' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.279629' ,`Longitude` = '-95.543887' ,`PhotoCount` = '38' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Carson Cub' ,`StreetNumber` = '222' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully bright one story in the amazing community of Woodforest. This 3-bed, 2 bath, PLUS a study, house exudes modern luxury. The light brick & stunning glass entry door set the tone for the rest of the home. Gorgeous wood plank tile throughout the main living areas. Work from home or need an extra guest room, the study offers the ultimate interruption-free work from home experience and features stunning French doors. Each of the spacious secondary rooms have plush carpet and plenty of closet space. This light & bright kitchen opens right into the dining room which opens right into the living room for a true open concept. The primary retreat has a wonderful soaking tub along with a large separate shower, & it is finished with a large closet\r\nfor plenty of storage. The large extended slate patio makes for the perfect spot to unwind at the end of the day and enjoy those summer breezes. Come see this gorgeous home for yourself and experience all that Woodforest has to offer.' ,`Acres` = '0.1312' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965269 - WOODFOREST 69, BLOCK 2, LOT 52' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '5715' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '6055' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705193' WHERE `Matrix_Unique_ID` = '210719104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:05:54.123' ,`MLSNumber` = '68429332' ,`ListAgentFullName` = 'David Young' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719696' ,`Longitude` = '-95.579758' ,`PhotoCount` = '40' ,`PostalCode` = '77082' ,`RoomCount` = '18' ,`ListPrice` = '1395000.00' ,`Status` = 'Active' ,`StreetName` = 'Legend Manor' ,`StreetNumber` = '11415' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Secure, luxury living in Royal Oaks Country Club. Brick & stone home on golf course with 2 bedrooms down, home office, gameroom and media room. Beautiful golf course views (#12 green / #13 fairway) through expansive windows in living areas and primary bedroom. Island kitchen is open to living areas with breakfast bar, GE Monogram appliances, including built in refrigerator, convection oven, microwave and two gas cooktops (1 is Wolf). Large bedroom up has balcony and can be used as 2nd primary bedroom. Large media room has sound proof walls and bar for entertaining. Study area with 2 desks upstairs between bedrooms. Back yard features patio with pergola, landscape lighting, wired for speakers. Exterior AC units and 1 evaporator coil replaced 2021. 3 car garage.' ,`Acres` = '0.2721' ,`Area` = '31' ,`BuilderName` = 'Fedrick Harris' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 4 ROYAL OAKS COUNTRY CLUB SEC 10' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '11851' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Oaks Country Club' ,`TaxAmount` = '27968' ,`TaxRate` = '2.6086' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705193' WHERE `Matrix_Unique_ID` = '210730747' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:17:27.550' ,`MLSNumber` = '5634802' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.212890' ,`Longitude` = '-95.330989' ,`PhotoCount` = '36' ,`PostalCode` = '77302' ,`RoomCount` = '6' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Watermelon' ,`StreetNumber` = '17215' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the combination of function and luxury that makes each day superb with this new construction home in ARTAVIA! Your open-concept living spaces allows gentle sunlight to shine on your interior design style from energy-efficient windows. The dining space is distinguished by a ceiling that opens to the second floor. The kitchen island faces the dining space, making it an ideal staging area for gourmet dinners and relaxed family breakfasts. Each upstairs bedroom offers unique appeal and an abundance of closet space. The upstairs retreat makes a great game room or family movie theater. The glamorous Owner’s Retreat includes a deluxe en suite bathroom and walk-in closet.\r\n\r\nContact the David Weekley at ARTAVIA Team to schedule your in-person or video tour of this sensational new construction home in Conroe, Texas!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 36 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705193' WHERE `Matrix_Unique_ID` = '210760176' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:52:03.740' ,`MLSNumber` = '7692828' ,`ListAgentFullName` = 'Patricia Alvarez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.292418' ,`Longitude` = '-94.816092' ,`PhotoCount` = '24' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue K' ,`StreetNumber` = '4409' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently renovated home with new siding master bedroom addition, master Bathroom, Central Air, main bathroom redone, Solar Panels, and paint. Centrally located in Galveston.' ,`Acres` = '0.118' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 5 BLK 104 GALVESTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '1750' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705194' WHERE `Matrix_Unique_ID` = '210783696' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:43:41.950' ,`MLSNumber` = '47371826' ,`ListAgentFullName` = 'Fausto Nolasco' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022828' ,`Longitude` = '-95.317122' ,`PhotoCount` = '32' ,`PostalCode` = '77338' ,`RoomCount` = '12' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Foxwalk' ,`StreetNumber` = '7119' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow! Plenty of upgrades to relax and enjoy comfortable living in this 5/3/2 home, such as two large living areas, two dining areas, five spacious bedrooms, a full three baths, a very large covered patio at 13\'x34\' to enjoy entertaining family and friends or just enjoy sitting under the ceiling fans. The home also features a security camera system, a sprinkler system, two 80-gallon water heaters, double pane windows, a remodeled kitchen with granite countertops and plenty of cabinet space, a new a/c system (7/2022), indoor utility room. The master bath features a separate tub and shower, double sinks, and a walk-in closet. The home backs up to a small park, so there are no neighbors behind this home. Come and see!' ,`Acres` = '0.1193' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 4 FOXWOOD SEC 9' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5198' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '390' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Foxwood Sec 09' ,`TaxAmount` = '5605' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705194' WHERE `Matrix_Unique_ID` = '210893860' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:59:45.597' ,`MLSNumber` = '97129562' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.188263' ,`Longitude` = '-94.179756' ,`PhotoCount` = '35' ,`PostalCode` = '77657' ,`RoomCount` = '11' ,`ListPrice` = '475000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cooks Lake Rd' ,`StreetNumber` = '9012' ,`StreetSuffix` = '' ,`City` = 'Lumberton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This unique masterpiece is waiting for you with tranquil water views! Situated on nearly 2 acres with sprawling space both inside and out. Enjoy a peaceful rain storm from the expansive back patio or from inside through the eye-catching cathedral windows! Upstairs loft overlooks main living area with a prime view, perfect for play or creative space! Attached efficiency apartment with private entrance includes a full bathroom and kitchen for overflow guests or an at-home business space. There\'s plenty more to treasure- take your chance to see this Lumberton retreat yourself!' ,`Acres` = '1.89' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 139 D CHOATE P# 139-12-A I# 2020-109010 11/04/2020' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '82590' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookdale Gdns Homes' ,`TaxAmount` = '7218' ,`TaxRate` = '1.8866' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705194' WHERE `Matrix_Unique_ID` = '210897329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:16:24.017' ,`MLSNumber` = '96600050' ,`ListAgentFullName` = 'Lynda Beck' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.980052' ,`Longitude` = '-95.459292' ,`PhotoCount` = '12' ,`PostalCode` = '77014' ,`RoomCount` = '3' ,`ListPrice` = '277000.00' ,`Status` = 'Active' ,`StreetName` = 'Candlewood Glen' ,`StreetNumber` = '13135' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Original owners. Well maintained one story, very large backyard. 3/2/2. Large eat in kitchen. Primary ensuite, with jacuzzi tub and walk in shower. Open floorplan, fireplace. Never Flooded.' ,`Acres` = '0.2284' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 3 SILVERGLEN NORTH SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9947' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '530' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'DELORAS E THOMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silverglen North' ,`TaxAmount` = '5616' ,`TaxRate` = '2.8867' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705194' WHERE `Matrix_Unique_ID` = '210963813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:27:43.937' ,`MLSNumber` = '57588150' ,`ListAgentFullName` = 'Mary Velasquez' ,`ListOfficeName` = 'Coldwell Banker The Ron BrownCompany' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.513724' ,`Longitude` = '-97.442455' ,`PhotoCount` = '10' ,`PostalCode` = '78629' ,`RoomCount` = '0' ,`ListPrice` = '105000.00' ,`Status` = 'Active' ,`StreetName` = 'Dallas' ,`StreetNumber` = '1506' ,`StreetSuffix` = 'Street' ,`City` = 'Gonzales' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT INVESTMENT OPPORTUNITY!! Operating as a church for many years sitting in the historic town of Gonzales. This great 2 bathroom facility with a storage room and fencing along the back of property is perfect for converting to your new home. Come rebuild the home of your dreams and relax under the beautiful oak trees. Several appliances will also convey. This corner lot provides easy access to all your major shopping and grocery hubs. Come and see all the possibilities this property has to offer!' ,`Acres` = '0.2' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = '1 & 2 12 BURCHARD' ,`LotDesciption` = 'Corner' ,`LotSize` = '8642' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '550 - Gonzales' ,`SchoolElementary` = 'GONZALES ELEMENTARY SCHOOL (GONZALES)' ,`SchoolHigh` = 'GONZALES HIGH SCHOOL' ,`SchoolMiddle` = 'GONZALES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Burchard' ,`TaxAmount` = '1741' ,`TaxRate` = '2.4121' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705194' WHERE `Matrix_Unique_ID` = '211078567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:52:09.107' ,`MLSNumber` = '27858315' ,`ListAgentFullName` = 'Carmen Leung' ,`ListOfficeName` = 'Midland Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708211' ,`Longitude` = '-95.605438' ,`PhotoCount` = '12' ,`PostalCode` = '77072' ,`RoomCount` = '7' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Wisteria Park' ,`StreetNumber` = '12718' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2733' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located minutes from the heart of Chinatown with convenient access to shopping, dining, commuting, and entertainment. Easy access to & Beltway 8, Highway 6, and US 59. All bedrooms are upstairs, a family room with open and bright 2 stories with high ceilings, and a spacious open kitchen with an island. Roof was replaced in 2020. The property is located across the street from Elsik High School. Room dimensions are approximate, buyers to verify if it\'s important. Tenant occupied, please do not disturb tenant without contacting the listing agent. The pictures were taken before the tenant moved in, sell in as-is condition.' ,`Acres` = '0.0878' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 HIGH STAR SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '467' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'MAHANAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'High Star Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705194' WHERE `Matrix_Unique_ID` = '211192781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:04:39.183' ,`MLSNumber` = '13163593' ,`ListAgentFullName` = 'Joel Garza' ,`ListOfficeName` = 'Abundant Living Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.550136' ,`Longitude` = '-97.977997' ,`PhotoCount` = '21' ,`PostalCode` = '78155' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Chapparral' ,`StreetNumber` = '110' ,`StreetSuffix` = 'Drive' ,`City` = 'Seguin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious 3BR 2 BA newly remodeled home is situated on a beautiful .7545 acre lot near the Guadalupe River featuring mature trees. If you\'re looking for a weekend getaway or a place to call home, you\'ll want to schedule a personal tour today! Kayaking, hiking, 18 hole golf course and great restaurants/bars are all minutes away! Centrally located from San Antonio, New Braunsfels and Austin! Features include All LED lighting, New flooring, New plumbing, Samsung stainless steel appliances, new granite counter tops and custom lighting! All measurements approximate, buyer to independently verify.' ,`Acres` = '0.7545' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT: 76A BLK:0 ADDN: CATERS PARKVIEW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '157 - Seguin' ,`SchoolElementary` = 'VOGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEGUIN HIGH SCHOOL (SEGUIN)' ,`SchoolMiddle` = 'A.J. BRIESEMEISTER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Caters Parkview' ,`TaxAmount` = '6650' ,`TaxRate` = '2.2057' ,`WaterSewer` = 'Public Water,Septic Tank,Well' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705195' WHERE `Matrix_Unique_ID` = '211371442' --> 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','211497308','1663705195','211497308','2022-08-31T13:26:02.023','75946036','Teri Le','B & W Realty Group LLC','','','29.880502','-95.670893','21','77095','8','315990.00','Active','Eden Falls','17206','Court','Houston','2','0','3','1910','Single-Family','This beautiful charming one story home with 3 bedroom, 2 bathroom, 1 study, 2 car garage. Open floor plan into the living room with a cozy fireplace. Upgrade Granite countertops for kitchen and both bathrooms. New ceiling fans for living room and all bedrooms. Cover patio. NO CARPET!!! Tile and wood floor throughout.','','8','NEWMARK','','','','Mud','1','','','Copperfield Area','Central Gas','1','LT 13 BLK 2 SHEFFIELD SEC 1','Cul-De-Sac','7087','Appraisal District','','625','0','','2','Electric Oven','0','','','','','Composition','13 - Cypress-Fairbanks','HOLMSLEY ELEMENTARY SCHOOL','LANGHAM CREEK HIGH SCHOOL','ARAGON MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Sheffield Sec 01','5661','2.706','Water District','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:51:28.250' ,`MLSNumber` = '87382074' ,`ListAgentFullName` = 'Angela James' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.521588' ,`Longitude` = '-95.539869' ,`PhotoCount` = '32' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'Isidore Lane' ,`StreetNumber` = '5227' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '5560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your Happy Place. This 6 bedroom 5 1/2 bath home built by Taylor Morrison is a castle in it\'s own right boasting over 5500 sq ft of living space and just under 1/2 acre for luxurious entertaining. Gated private courtyard, 2 backyard covered sitting areas, free form pool, lots of deck space, basketball sized court. An open concept design with vaulted ceilings, spacious kitchen, island seating for 4, bar and dining area. Kitchen equipped with double dishwashers, double ovens, stainless steel appliances and gas range. Three laundry rooms, including in the primary closet and upstairs hall. Two fireplaces located in Family living area and primary bedroom. Three bedrooms up and three bedrooms down. Two walk in Attic spaces. Green space behind home. . Quick access to Fort Bend Toll & Hwy 6. 20 mins from Medical center, 27 minutes from Downtown. 3 minutes to grocery store, 5 mins to restaurants. Sienna has more than 4+ pools, 3+ clubhouses, 2 gyms and growing.' ,`Acres` = '0.4975' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT SIENNA PLANTATION SEC 1, BLOCK 4, LOT 18' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '21673' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Avalon At Sienna Plantation' ,`TaxAmount` = '21285' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705195' WHERE `Matrix_Unique_ID` = '211519464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:52:55.500' ,`MLSNumber` = '40255950' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864700' ,`Longitude` = '-95.282900' ,`PhotoCount` = '24' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '249890.00' ,`Status` = 'Active' ,`StreetName` = 'Red Orchid' ,`StreetNumber` = '10535' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Sommerville floorplan showcases 3 bedrooms 2 full bathrooms and a 2 car garage! This open concept kitchen is full of high quality cabinetry, a pantry and a large eating area that is blanketed with natural lighting illuminating from the breakfast area windows. It is completed with hard surface flooring throughout the common areas. And for family fun times, it has an amazing covered front porch and back patio that comes standard with this home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '9/4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Village' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705195' WHERE `Matrix_Unique_ID` = '211622045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:07:31.980' ,`MLSNumber` = '96783352' ,`ListAgentFullName` = 'Michelle Garza- Beason' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151059' ,`Longitude` = '-95.382381' ,`PhotoCount` = '37' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Serrano Bluff' ,`StreetNumber` = '31747' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully appointed 4 BDRM/ 3 Bath home in the highly sought-after Falls at Imperial Oaks! Home offers hard to find Primary AND Secondary bedroom downstairs! The sleek, sophisticated kitchen offers granite counters, ample cabinetry, an eat in space and an oversize island that is sure to be the sociable center of the house. The kitchen, breakfast and living area flow together in this open concept home and are highlighted with rich wood flooring. Walls of windows provide the rooms with natural light and connects the home with the backyard space Upstairs game room is an informal and friendly space to relax or play. The generous sized secondary bedrooms upstairs are a dream! Casual living spaces spill effortlessly outdoors onto your covered patio. New roof 2022. Neighborhood includes 2 resort style pools, club house with workout facility, miles of trails, YMCA and area lake. Close to schools, shopping, I-45 and 99. Come fall in love with all this home has to offer!' ,`Acres` = '0.1663' ,`Area` = '15' ,`BuilderName` = 'David Weekly' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S504212 - FALLS AT IMPERIAL OAKS 12, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7242' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks 12' ,`TaxAmount` = '11001' ,`TaxRate` = '3.0687' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705195' WHERE `Matrix_Unique_ID` = '211687414' --> 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','211808976','1663705195','211808976','2022-08-31T13:34:11.257','43024537','Melina Ortiz-Guevara','Redfin Corporation','','','29.776319','-95.575362','36','77079','9','650000.00','Active','Wilcrest','714','Drive','Houston','2','1','4','2593','Single-Family','Gorgeous updated home with wonderful curb appeal in the heart of the Houston Energy Corridor! This recently updated home is located in the highly sought-after Wilchester neighborhood and features a formal living room, formal dining room, bright and well-equipped kitchen with a breakfast nook, and a spacious family room with a beautiful brick fireplace. First-floor primary bedroom with en-suite bathroom, 3 additional generous-sized bedrooms upstairs. Relax or entertain in the great backyard space with plenty of room to install a swimming pool, play area, or gardening. Enjoy all the amenities offered by the Wilchester community, including community pools, a park, and tennis courts. Easy access to I-10, close proximity to City Centre, Memorial City Mall and Zoned to Spring Branch ISD. Please be sure to view the walk-through video and schedule your private showing today!','0.2169','23','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Memorial West','Central Gas','1','LT 4 BLK 17 WILCHESTER SEC 3','Subdivision Lot','9450','Appraisal District','','732','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','49 - Spring Branch','RUMMEL CREEK ELEMENTARY SCHOOL','STRATFORD HIGH SCHOOL (SPRING BRANCH)','MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)','Supra Keybox','Appraisal District','1.5','Traditional','Wilchester Sec 03','11548','2.4415','Public Sewer,Public Water','1969','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:14:33.133' ,`MLSNumber` = '4379311' ,`ListAgentFullName` = 'Rayne Leonard' ,`ListOfficeName` = 'RAYNE REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218259' ,`Longitude` = '-95.610581' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '17' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Clubhouse' ,`StreetNumber` = '9519' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '5159' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WATERFRONT, GOLF COURSE COMMUNITY, GATED TRIPLE WIDE DRIVEWAY, SPRINKLER SYSTEM and WHOLE HOUSE GENERATOR SYSTEM ON OVER AN ACRE: You know this home is perfect for you from the moment you enter the foyer and see straight ahead the view of the water, the lush greenery while glancing around to catch a glimpse of the spaciousness, and elegance of the SPACIOUS beautiful interior of this home. The large windows provide an abundance of natural lighting as well as a wonderful view of backyard. With a large open floor plan, high ceilings, large spacious rooms, this home is perfect for entertaining. This home offers granite counter tops, breakfast bar, double oven, under cabinet lighting, a kitchen that overlooks the breakfast room, flex room with bath, office, owners retreat with cozy fireplace, sitting area and view of backyard, bedroom and full bath, both formals on the first floor with 2 bedrooms with Hollywood bath and game room up, 3 car Garage w/ 3 car attached carport, gated driveway.' ,`Acres` = '1.066' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE WINDCREST 05, BLOCK 1, LOT 155' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '46435' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Windcrest 05' ,`TaxAmount` = '13597' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705195' WHERE `Matrix_Unique_ID` = '211902040' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:21:40.453' ,`MLSNumber` = '95100738' ,`ListAgentFullName` = 'Aijaz Chaudary' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.323808' ,`Longitude` = '-95.472061' ,`PhotoCount` = '30' ,`PostalCode` = '77301' ,`RoomCount` = '5' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Robinhood' ,`StreetNumber` = '10' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1987' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully renovated, freshly painted, featuring BRAND NEW Roof shingles, AC, Water heater, custom kitchen & bath cabinets, flooring, stain-less steel appliances, granite counter tops, & elegant fixtures (fans, LED lights), gives this home an exquisite look. Master-bath with double sink vanity, remodeled standing shower with frameless glass door and tiles/backsplash. Every element carefully selected to compliment the exemplary features of the home. This is a must see!' ,`Acres` = '0.4024' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SHERWOOD FOREST, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17530' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSTON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sherwood Forest' ,`TaxAmount` = '3596' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705195' WHERE `Matrix_Unique_ID` = '211911289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T12:13:52.060' ,`MLSNumber` = '94888737' ,`ListAgentFullName` = 'Marcey Nelson' ,`ListOfficeName` = 'Evans and Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.697632' ,`Longitude` = '-94.747845' ,`PhotoCount` = '35' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '135000.00' ,`Status` = 'Active' ,`StreetName` = 'Baletka' ,`StreetNumber` = '318' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute spacious home sitting on beautiful 1+/- acre, 2/2/2 possible 3 bedrooms, office, screened in back porch, large hobby room/utility , storage/workshop, fenced in back yard, whole house generator for when the weather gets bad, security cameras and manuals stay with home, wood burning fireplace, nice size kitchen and dining area. Covered front porch and attached carport. Don’t miss out on this one!.' ,`Acres` = '1.0044' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'INDIAN SPRINGS LAKE ESTATES SEC 17 lOT 19 & 20,21,22,23,,24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Indian Spgs Lake Estates Se' ,`TaxAmount` = '23' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705195' WHERE `Matrix_Unique_ID` = '211914576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:54:09.613' ,`MLSNumber` = '23038732' ,`ListAgentFullName` = 'Jeffrey Lutz' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746801' ,`Longitude` = '-95.876978' ,`PhotoCount` = '46' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Jarvis Bay' ,`StreetNumber` = '29410' ,`StreetSuffix` = 'Pass' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ORIGINAL OWNER, TRUE PRIDE OF OWNERSHIP. Lovely and perfectly maintained home in desired community. This fabulous one story offers +/- 2094 Sqft with a wonderful and open concept. Step in the front door and you will be amazed how open and large the family space is. From the spacious and beautiful kitchen with rich granite and stainless appliances, tons of cabinets, plus a big island that looks out onto the open dining and family room. All the family space is done in large ceramic tile through all traffic areas. High ceilings and lots of windows make it all come together. Then step right out on to the huge concrete patio with paver stone finish, stretching across the entire back of the home. Back inside you find the primary en-suite tucked in the back corner of the home, with oversized shower, double sinks and dream size walk in closet. There are three other bedrooms, one of which could easily be used as a home office or play room. The front Two bedrooms feature a bath between them.' ,`Acres` = '0.1446' ,`Area` = '30' ,`BuilderName` = 'Dr Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 30, BLOCK 2, LOT 45' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron Sec 30' ,`TaxAmount` = '7699' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705196' WHERE `Matrix_Unique_ID` = '211925970' --> 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','211926999','1663705196','211926999','2022-08-31T13:41:35.640','20771595','Hien Truong','Truss Real Estate','','','29.689257','-95.472081','19','77096','2','520000.00','Active','Beechnut','5202','Street','Houston','2','0','2','1591','Single-Family','Welcome to your new home! A bright and spacious home with wood tile floors throughout. As you walk in you\'re greeted by an open floor plan filled with tons of natural lighting. A chef\'s kitchen designed with entertainment in mind. From the living room you\'ll have views of the covered patio that\'s perfect for enjoying with your family and friends. Enjoy the large green space as the home sits on a huge 11,120SF lot. Conveniently located near Godwin and Lafayette park, zoned to the Bellaire High! Schedule your tour today! \r\n\r\nPlease allow a 4 hour notice for showings since the owner works from home.','0.2553','20','','','Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','','Mock Fireplace','1','Bellaire Area','Central Gas','1','LT 13 BLK 21 MEYERLAND SEC 3','Corner,Subdivision Lot','11120','Appraisal District','','493','0','','2','Double Oven,Electric Oven','0','','','Gas Range,Grill','','Composition','27 - Houston','LOVETT ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Meyerland Sec 03','','','Public Sewer,Public Water','1957','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T13:14:15.317' ,`MLSNumber` = '66444844' ,`ListAgentFullName` = 'Jade Arneson' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.994950' ,`Longitude` = '-95.233952' ,`PhotoCount` = '32' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Palm' ,`StreetNumber` = '4522' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Location! Close to the beach in a small community, where the public beach is located just minutes away. As you enter, you are greeted with an abundance of natural light flowing through the windows, as well as a large open floor plan with open area living and kitchen area - perfect for entertaining. The kitchen features granite countertops and stainless steel appliances, a separate dining area, and one downstairs bedroom, with the other two located upstairs. This home generously offers you both ocean and bay views from its multiple raised decks and outside patio areas, as well as convenient access to a community boat ramp, as well as large docks located in the front and back of the home. There also have been many recent updates including a new roof (2022), new HVAC (2022), new carpet and freshly coated paint throughout. Furnishings can also convey with home.' ,`Acres` = '0.1148' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SAN LUIS BEACH (A0029 S F AUSTIN) BLK 5 LOT 6' ,`LotDesciption` = 'Cleared,Other,Water View' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'San Luis Beach' ,`TaxAmount` = '4919' ,`TaxRate` = '1.9981' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705196' WHERE `Matrix_Unique_ID` = '211939364' --> 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','212014624','1663705196','212014624','2022-08-31T13:46:27.803','90816605','Donn Clark','R. Alexa Group LLC','','','30.101419','-95.294657','14','77365','4','229900.00','Active','Fire Fly','18691','Drive','Porter','2','0','4','1920','Single-Family','Recently refurbished 4-bedroom 2 bath in Porter TX, home is on almost a 1/2 acre. Rear of home has wonderful deck off of the eat in kitchen, perfect for grilling. Kitchen is large and has an island for those who want to help prepare the family meals. Master bath has a large walk-in closet, double sinks, large soaker tub plus a large separate shower. Buyers or listing agent should verify all room measurements','0.475','40','','','','','No Disclosures','','','','Porter/New Caney West','Central Electric','1','S906301 - SUMMER HILLS 01, LOT 111, SERIAL # CW2014839TXA, L','Other','20691','Appraisal District','','','0','','0','','0','','','','','Composition','39 - New Caney','BROOKWOOD FOREST ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WOODRIDGE FOREST MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal','1','Traditional','Summer Hills 01','1471','2.1331','Aerobic','2012','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','212016948','1663705196','212016948','2022-08-31T12:36:10.487','94841054','Jeffrey Morris','RE/MAX The Woodlands & Spring','','','30.284578','-95.560149','49','77316','10','565000.00','Active','Cherry Oak','177','Lane','Montgomery','3','0','4','3052','Single-Family','Charming 4 bedroom Darling Classic on one of the most desired streets in Woodforest! This home has it all-3 car garage, a floorplan with two bedrooms on the first floor, & a large lot with mature landscaping. Inside you will find custom millwork throughout beginning in the entryway, breakfast nook, hallway from the garage entrance, & around all the windows on the first floor. Rich engineered hardwood floors paired with the light & bright fresh new paint, & new lighting fixtures really add to the luxury. The large home office is perfect for working from home. The primary retreat features a closet that opens right into the laundry room! This home has plenty of storage with under stairs closets & walk-in attic access. The back yard has an extended patio & is plumbed with gas…ready for you transform into your dream yard! Experience all that Woodforest has to offer with dining and shopping at Pine Market, Pools at Forest Island and loads of parks and trails for all!','0.2035','39','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Conroe Southwest','Central Gas','1','S965219 - WOODFOREST 19, BLOCK 2, LOT 7','Cul-De-Sac,In Golf Course Community,Subdivision Lot','8865','Appraisal District','','1265','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Woodforest','9438','2.6888','Water District','2013','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','212019163','1663705196','212019163','2022-08-31T13:56:07.653','34273811','R. J. Boncler','Boncler Realty','','','30.706897','-95.023305','6','77351','6','175000.00','Active','Burchfield','436','Drive','Livingston','2','0','3','','Single-Family','Property needs a little TLC but located on about one acre of land. Manufactured home close to Lake Livingston, shopping and I-69.','0.287','44','','','','','Sellers Disclosure','','','','Lake Livingston Area','Central Electric','0','MANGUM ESTATES SECTION 1 LOT 32 & 33','Wooded','12500','Appraisal District','','','0','','0','','0','','','','','Aluminum','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','','1','Traditional','Mangum Estates Sec 1','23','1.8745','Public Sewer,Public Water','1996','Appraisal District'); --> New record created successfully