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-22T15:44:14.280' ,`MLSNumber` = '36448138' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.424754' ,`Longitude` = '-94.106230' ,`PhotoCount` = '22' ,`PostalCode` = '75501' ,`RoomCount` = '4' ,`ListPrice` = '79900.00' ,`Status` = 'Active' ,`StreetName` = 'Arizona' ,`StreetNumber` = '633' ,`StreetSuffix` = 'Avenue' ,`City` = 'Wake Village' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1447' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'re looking for a decent home with good country living, look no further. This home is close to Wake Village Elementary School and a variety of small shops and eateries, making it perfect for you and your family. This home does need some renovating, but offers a great investment for first time home buyers. Property is also close to major highways. Call today to schedule a viewing!' ,`Acres` = '0.2' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'WAKE VILLAGE LOT 10 2016-6892 06/02/16 BLK/TRACT 9 0.2 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '99 - Other' ,`SchoolElementary` = 'WAKE VILLAGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS HIGH SCHOOL' ,`SchoolMiddle` = 'TEXAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wake Village' ,`TaxAmount` = '1275' ,`TaxRate` = '2.2158' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701757' WHERE `Matrix_Unique_ID` = '192203994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:42:58.110' ,`MLSNumber` = '33617847' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.424329' ,`Longitude` = '-94.107189' ,`PhotoCount` = '19' ,`PostalCode` = '75501' ,`RoomCount` = '3' ,`ListPrice` = '75999.00' ,`Status` = 'Active' ,`StreetName` = 'Arizona' ,`StreetNumber` = '612' ,`StreetSuffix` = 'Avenue' ,`City` = 'Wake Village' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single family home in Texarkana, TX that consists of 2 bedrooms and 1 bathroom. Home is located only 10 minutes away from Texarkana Pavilion Shopping Mall and has easy access to many local parks, restaurants and supermarkets. Sitting on 0.50 acres! Make sure to call and schedule a viewing today. This property will soon feature new paint in/out, as well as an upgraded kitchen and bathroom. A new roof is also included!' ,`Acres` = '0.5' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'WAKE VILLAGE LOTS 12 19 LOT 13 BLK 2 2016-8243 07/06/16 BLK/' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '99 - Other' ,`SchoolElementary` = 'WAKE VILLAGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS HIGH SCHOOL' ,`SchoolMiddle` = 'TEXAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wake Village' ,`TaxAmount` = '940' ,`TaxRate` = '2.2158' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701757' WHERE `Matrix_Unique_ID` = '192212355' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:38:26.740' ,`MLSNumber` = '14742379' ,`ListAgentFullName` = 'Emily Wang' ,`ListOfficeName` = 'Intown Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688197' ,`Longitude` = '-95.437485' ,`PhotoCount` = '11' ,`PostalCode` = '77025' ,`RoomCount` = '10' ,`ListPrice` = '1249900.00' ,`Status` = 'Active' ,`StreetName` = 'Linkfair' ,`StreetNumber` = '8710' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3868' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gracious and inviting our CHARMING traditional NEW CONSTRUCTION home soon to start offers a timeless design for modern living For A LIMITED TIME an opportunity to personalize the INTERIOR options that celebrate your style SEE AGENT REMARKS 12\' CEILINGS and HARDWOOD FLOORS throughout the 1st floor provide an UNDERSTATED ELEGANCE and 10\' overlapping sliders highlight the 21x30 living room and perfectly compliment EVERY homes greatest accessory NATURAL LIGHT a LUXURIOUS GOURMET kitchen features inset 42\" double stacked cabinetry fully accessorized with double trash pullouts, spice cutlery and pot and pans drawers a 48\" range with double ovens 6 burners and a griddle a double drawer dishwasher that can run multiple cycles A PRIMARY SUITE is truly a retreat mindfully designed for PRIVACY a few steps up from 3 secondary bedrooms each with its own dedicated FULL BATH A WELCOMING FRONT Porch and GORGEOUS back yard are functionally designed to create experiences and memories to last a lifetime.' ,`Acres` = '0.2124' ,`Area` = '17' ,`BuilderName` = 'Intown-Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 9 LINKWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Linkwood' ,`TaxAmount` = '6582' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701757' WHERE `Matrix_Unique_ID` = '207871138' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:49:17.833' ,`MLSNumber` = '9364483' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Holly Jackson' ,`SellingOfficeName` = 'RE/MAX ONE - Premier' ,`Latitude` = '29.840946' ,`Longitude` = '-94.823335' ,`PhotoCount` = '15' ,`PostalCode` = '77523' ,`RoomCount` = '14' ,`ListPrice` = '469427.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hillside' ,`StreetNumber` = '7323' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to South Lake Estate. The two-story Bella II brick home with stone accents features 5 bedrooms, 3.5 baths and 3 car attached garage. Elegant dining room tucked off foyer. Beautiful maple cabinets, under cabinet lighting, farmhouse sink and quartz countertops in gourmet kitchen. Cozy box mantel fireplace with crown and tile surrounds in great room. The owner\'s luxury bath has a huge walk-in closet, linen closet, double sinks, separate tub and shower. Versatile loft space and all secondary bedrooms located upstairs. Grill outside or relax under the covered patio. Students are zoned to Barbers Hill ISD. South Lake Estate is located within close proximity to Eagle Pointe Golf Course and Mont Belvieu City Park. South Lake Estate is offered by K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '16/1/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Lake Estate' ,`TaxAmount` = '' ,`TaxRate` = '2.16' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701757' WHERE `Matrix_Unique_ID` = '208185746' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:29:29.680' ,`MLSNumber` = '16020679' ,`ListAgentFullName` = 'Nina Pope' ,`ListOfficeName` = 'HOM Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.767451' ,`Longitude` = '-95.617715' ,`PhotoCount` = '18' ,`PostalCode` = '75801' ,`RoomCount` = '3' ,`ListPrice` = '99000.00' ,`Status` = 'Active' ,`StreetName` = 'Johnson' ,`StreetNumber` = '1417' ,`StreetSuffix` = 'Street' ,`City` = 'Palestine' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Centrally located cozy home with spacious bedrooms. Master bedroom with walk-in closet and en suite. Shared hall bathroom with two nicely sized secondary bedrooms. Open concept living, dining, and kitchen. House has central heat but needs the outside unit for central AC. This would make someone willing to put a little work into it a great starter home. Some subfloors need to be replaced in both bathrooms by the tubs as well as one spot in the master bedroom, but not at any fault of the property. Structurally a great little find in the heart of growing Palestine, TX. Property is being sold as-is, seller is unable to make any repairs. Pics coming soon. Price reflects work needing to be done.' ,`Acres` = '0.2092' ,`Area` = '75' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Palestine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NANCE BLOCK A LOT 6 (PT LOT 1 REPLAT)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9113' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '71 - Palestine' ,`SchoolElementary` = '' ,`SchoolHigh` = 'PALESTINE HIGH SCHOOL' ,`SchoolMiddle` = 'PALESTINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Nance' ,`TaxAmount` = '1385' ,`TaxRate` = '2.6911' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701758' WHERE `Matrix_Unique_ID` = '208570504' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:23:53.557' ,`MLSNumber` = '55397422' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.188365' ,`Longitude` = '-95.417069' ,`PhotoCount` = '6' ,`PostalCode` = '77515' ,`RoomCount` = '8' ,`ListPrice` = '352631.00' ,`Status` = 'Active' ,`StreetName` = 'Kelly' ,`StreetNumber` = '140' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Riverwood Ranch! Anglia Homes presents the Bedford! This is a beautiful 2 story home. Features 4 bedrooms, 2.5 bathrooms, with a 2 car garage. The primary bedroom is downstairs and the rest of the bedrooms are upstairs. The office/study is downstairs and the game room is upstairs. Don\'t miss out on this home. Call today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERWOOD RANCH SD SEC 1 (A0318) (ANGLETON) BLK 1 LOT 45' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701758' WHERE `Matrix_Unique_ID` = '208586537' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:29:26.047' ,`MLSNumber` = '59724233' ,`ListAgentFullName` = 'Lylian Alfaro' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.955310' ,`Longitude` = '-95.632107' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '1700000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Creek' ,`StreetNumber` = '14110' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The property has a large parking lot, walking track, play yard, and play structure. Property can be residential/multifamily or commercial' ,`Acres` = '1.08' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 7 & 8 BLK 1 CYPRESS CREEK PLAZA' ,`LotDesciption` = 'Corner' ,`LotSize` = '47045' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Cypress Creek Plaza' ,`TaxAmount` = '6735' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701758' WHERE `Matrix_Unique_ID` = '208765630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:44:36.103' ,`MLSNumber` = '77905410' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843864' ,`Longitude` = '-95.859653' ,`PhotoCount` = '26' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '599574.00' ,`Status` = 'Active' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '863' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston, Elevation D) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Spacious island kitchen open to Family room. Formal Dining and Study. Game room and Media Room upstairs. Covered back patio and attached 2 car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9045' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701758' WHERE `Matrix_Unique_ID` = '209033259' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:43:01.103' ,`MLSNumber` = '10397147' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842330' ,`Longitude` = '-95.860461' ,`PhotoCount` = '27' ,`PostalCode` = '77494' ,`RoomCount` = '15' ,`ListPrice` = '589932.00' ,`Status` = 'Active' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '812' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Ellicott, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms, 3.5 baths. Primary suite with large walk-in closet. Second bedroom on first floor with private bath. First floor study and informal dining adjacent to the island kitchen. Upstairs additional 2 bedrooms, bathroom, game room and media room. Covered patio and attached 2 car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7323' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701758' WHERE `Matrix_Unique_ID` = '209072146' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:18:54.297' ,`MLSNumber` = '97927251' ,`ListAgentFullName` = 'Jennifer Parker' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147373' ,`Longitude` = '-94.772138' ,`PhotoCount` = '19' ,`PostalCode` = '77575' ,`RoomCount` = '8' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1011' ,`StreetNumber` = '3313' ,`StreetSuffix` = 'Road' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom, 2 bathroom brick home sit on a quiet 2.31 acres on FM 1011. The separate mother-in-law suite includes a large living room/kitchen, bedroom and full bathroom. The property also features 2 large buildings. The first building measures 20x30 and is insulated. The second building has 2 roll up garage doors and measures 20x20.' ,`Acres` = '2.31' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000109 S STRONG, TRACT 81, ACRES 2.31' ,`LotDesciption` = 'Cleared' ,`LotSize` = '100624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'S Strong' ,`TaxAmount` = '3745' ,`TaxRate` = '1.8856' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701758' WHERE `Matrix_Unique_ID` = '209296399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:41:18.070' ,`MLSNumber` = '17611890' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842227' ,`Longitude` = '-95.860351' ,`PhotoCount` = '31' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '629753.00' ,`Status` = 'Active' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '808' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Fairfax, Elevation AL). CURRENTLY BEING BUILT. Two story. 5 bedrooms. 3.5 baths. Spacious island kitchen open to family room and informal dining. Primary suite with large walk-in closet. Additional first floor bedroom with private bath. First floor study. 3 additional bedrooms, game room and media room on second floor. Covered patio and 2-car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7323' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701758' WHERE `Matrix_Unique_ID` = '209309860' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:25:33.100' ,`MLSNumber` = '47562048' ,`ListAgentFullName` = 'Nancy Lawrence' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = 'Eliesa Wright' ,`SellingOfficeName` = 'Lawrence Realty' ,`Latitude` = '31.215570' ,`Longitude` = '-95.545503' ,`PhotoCount` = '33' ,`PostalCode` = '75835' ,`RoomCount` = '2' ,`ListPrice` = '349000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'CR 3370' ,`StreetNumber` = '282' ,`StreetSuffix` = '' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This secluded 5+acre property off FM 2110 and Bynum Cemetery Road in Crockett, TX has beautiful trees and a wonderful caliche rock entry and driveway. From the moment you enter the property, you will be amazed. This two bedroom, two bath home is well maintained with fine finishes. Complete with granite countertops, wood floors, and tons of sunlight beaming throughout the home, this home is move-in-ready! The kitchen has pretty granite countertops, stainless appliances, plenty of cabinet space, and a pantry. The primary bedroom is oversized with a private bath complete with tile flooring and a jacuzzi tub. The French doors lead to a cozy outdoor sitting area – the perfect spot to watch the deer roam the yard in the mornings. The guest bedroom is nice sized and also has a private bath. This home is in great condition and has a new metal roof. Outdoors, you will find a 2-car garage, 2-car carport, as well as multiple pens for animals.' ,`Acres` = '5.46' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FOREST COUNTRY LOTS 14 & 15 5.46 AC' ,`LotDesciption` = 'Wooded' ,`LotSize` = '237838' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '1795' ,`TaxRate` = '1.8725' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701758' WHERE `Matrix_Unique_ID` = '209575694' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:45:27.163' ,`MLSNumber` = '2978427' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.450244' ,`Longitude` = '-94.079847' ,`PhotoCount` = '12' ,`PostalCode` = '75501' ,`RoomCount` = '4' ,`ListPrice` = '138999.00' ,`Status` = 'Active' ,`StreetName` = 'Robison' ,`StreetNumber` = '3508' ,`StreetSuffix` = 'Road' ,`City` = 'Texarkana' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this 4 bedroom, 2.5 bathroom home located in a welcoming neighborhood. The home is in need of a little TLC but comes with a brick fireplace and a spacious backyard. Easy access to 30 & 369 HWY. Contact us today for more information! As Is' ,`Acres` = '0.22' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'BROWNWOOD 2ND LOT 3 0670/104 12/03/70 BLK/TRACT 1 0.22 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9583' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '970 - Texarkana' ,`SchoolElementary` = '' ,`SchoolHigh` = 'TEXAS HIGH SCHOOL' ,`SchoolMiddle` = 'TEXAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brownwood 2nd Add' ,`TaxAmount` = '2879' ,`TaxRate` = '2.5041' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701759' WHERE `Matrix_Unique_ID` = '209730499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:46:47.390' ,`MLSNumber` = '69537228' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.412270' ,`Longitude` = '-94.151017' ,`PhotoCount` = '6' ,`PostalCode` = '75501' ,`RoomCount` = '2' ,`ListPrice` = '99599.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 1224' ,`StreetNumber` = '741' ,`StreetSuffix` = '' ,`City` = 'Texarkana' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brick home! Handy-man special! Located in Texarkana, Texas, close to I-30! Great opportunity! Contact us today for more information! As Is' ,`Acres` = '1.219' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'MARK EPPERSON A-185 535/837 10/07/71 BLK/TRACT 82 1.219 ACRE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '53100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '970 - Texarkana' ,`SchoolElementary` = 'NASH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS HIGH SCHOOL' ,`SchoolMiddle` = 'TEXAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mark Epperson Surv Abs 185' ,`TaxAmount` = '1536' ,`TaxRate` = '1.8541' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701759' WHERE `Matrix_Unique_ID` = '209753128' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:31:57.530' ,`MLSNumber` = '27726963' ,`ListAgentFullName` = 'Nyki Deets' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851363' ,`Longitude` = '-95.663681' ,`PhotoCount` = '34' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Gleneviss' ,`StreetNumber` = '17027' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2539' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see all this beautiful home has to offer! ADA apartment in the rear of the home, Apt in back is ideal for office, man cave, play room, mother in law, elderly or theatre room which also adds an additional 456 SQFT. 1st floor tile floors 1 1/2 yrs old, water sprinkler system front & back. There are 4 bedrooms upstairs, Covered patio in back, ready for outdoor sink installation. Washer & dryer included. This is a must see home.' ,`Acres` = '0.1494' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 14 WESTGLEN PAR R/P' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '371' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'TIPPS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westglen Prcl R/P' ,`TaxAmount` = '6218' ,`TaxRate` = '2.861' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701759' WHERE `Matrix_Unique_ID` = '209821592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:37:16.307' ,`MLSNumber` = '59262971' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843817' ,`Longitude` = '-95.860407' ,`PhotoCount` = '26' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '594834.00' ,`Status` = 'Active' ,`StreetName` = 'Marisol Bay' ,`StreetNumber` = '800' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston, Elevation D) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Spacious island kitchen open to Family room. Formal Dining and Study. Game room and Media Room upstairs. Covered back patio and attached 2 car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 22 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11186' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701759' WHERE `Matrix_Unique_ID` = '209902033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:55:17.807' ,`MLSNumber` = '40554727' ,`ListAgentFullName` = 'Jill Henderson' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.056213' ,`Longitude` = '-95.151341' ,`PhotoCount` = '44' ,`PostalCode` = '77345' ,`RoomCount` = '11' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Leafy Aspen' ,`StreetNumber` = '5910' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**PROPERTY HAS NEVER FLOODED***Stately Kings Point beauty is ready for new owners. Large corner CDS lot with lush landscaping. Two story soaring ceilings in den & kitchen makes the space light and bright. Open concept kitchen/breakfast/den. Both formals and impressive study with rich library paneling. Spacious primary bedroom with sitting area and spa like bath with double sinks, separate shower and two large walk-in closets. Fresh paint and carpet through-out. Tile in den, kitchen and wet areas. Private back yard with wrought iron fence separating extended patio from grassy areas. Pristine 3 car garage with new paint on walls and floors. Many updates through-out.' ,`Acres` = '0.2862' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 7 KINGS POINT VILLAGE SEC 6' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '12465' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Point Village Sec 06' ,`TaxAmount` = '9626' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701759' WHERE `Matrix_Unique_ID` = '209949692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:23:53.167' ,`MLSNumber` = '94459968' ,`ListAgentFullName` = 'Amy Lippincott' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159275' ,`Longitude` = '-95.083015' ,`PhotoCount` = '13' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '273990.00' ,`Status` = 'Active' ,`StreetName` = 'Julian' ,`StreetNumber` = '44' ,`StreetSuffix` = 'Court' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home Creations is pleased to offer the “Cypress” Plan. This 4 Bedroom, 2 Bath home will be ready for your family at the end of September and offers 10’ Ceilings in the main living area and in the spacious master bedroom. The master bathroom boasts a standup shower and ample countertop space. Enjoy your evenings sitting out on your oversized front porch or on your covered patio. All Home Creations’ homes in Cleveland come with Tankless Water Heaters, smart home features such as video doorbell, smart switches, and WiFi EcoBee Thermostats. Additional standard features include: garage door openers, quartz countertops throughout, vinyl flooring throughout (except carpeted bedrooms), cabinets with soft close drawers and doors, front gutters, 16 SEER HVAC Unit, Taexx Pest Control System, and much more!\r\nThis home sits on a quiet cul-de-sac street built exclusively by Home Creations. \r\nLet our 40 years of homebuilding experience work for you!' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Home Creations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Santa Fe, Sec 3, Block 50, Lot 6501, Acres .16' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701759' WHERE `Matrix_Unique_ID` = '210823480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:23:05.713' ,`MLSNumber` = '16688529' ,`ListAgentFullName` = 'Amy Lippincott' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159130' ,`Longitude` = '-95.082993' ,`PhotoCount` = '12' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '275990.00' ,`Status` = 'Active' ,`StreetName` = 'Julian' ,`StreetNumber` = '54' ,`StreetSuffix` = 'Court' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1624' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home Creations is pleased to offer the “Pecan” Plan. This 3 Bedroom/2 Bath home will be ready for your family at the end of September and offers 10’ Ceilings in the main living area and in the spacious master bedroom. This unique plan features the kitchen in the front of the home which makes the living space seem even greater as you walk-in the front door. The master bathroom boasts a standup shower and ample countertop space. Enjoy your evenings sitting on your covered patio. Tankless Water Heaters, smart home features such as video doorbell, smart switches, and WiFi EcoBee Thermostats. Additional standard features include: garage door openers, quartz countertops throughout, vinyl flooring throughout (except carpeted bedrooms), cabinets with soft close drawers and doors, front gutters, 16 SEER HVAC Unit, Taexx Pest Control System, and much more! This home sits on a quiet cul-de-sac street built exclusively by Home Creations. Let our 40 years of homebuilding experience work for you!' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Home Creations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Santa Fe, Sec 3, Block 50, Lot 6502, Acres .14' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701759' WHERE `Matrix_Unique_ID` = '210823841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:23:33.217' ,`MLSNumber` = '74239315' ,`ListAgentFullName` = 'Amy Lippincott' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.158990' ,`Longitude` = '-95.083116' ,`PhotoCount` = '12' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Julian' ,`StreetNumber` = '64' ,`StreetSuffix` = 'Court' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1686' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home Creations is pleased to offer the “Pecan” Plan. This 4 Bedroom, 2 Bath home will be ready for your family at the end of September and offers 10’ Ceilings in the main living area and in the spacious master bedroom. This plan centers on the kitchen being the heart of the home, and offers plenty of natural light throughout the main area of the home. The master bathroom boasts a standup shower and ample countertop space. Enjoy your evenings sitting out on your oversized front porch or on your covered patio.Tankless Water Heaters, smart home features such as video doorbell, smart switches, and WiFi EcoBee thermostats. Additional standard features include: garage door openers, quartz countertops throughout, vinyl flooring throughout (except carpeted bedrooms), cabinets with soft close drawers and doors, front gutters, 16 SEER HVAC Unit, Taexx Pest Control System, and much more!This home sits on a quiet cul-de-sac street built exclusively by Home Creations.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Home Creations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Santa Fe, Sec 3, Block 50, Lot 6503, Acres .16' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701760' WHERE `Matrix_Unique_ID` = '210824179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:51:28.543' ,`MLSNumber` = '88646384' ,`ListAgentFullName` = 'Lucy Ware' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.967916' ,`Longitude` = '-95.456226' ,`PhotoCount` = '28' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Stephen F Austin' ,`StreetNumber` = '6951' ,`StreetSuffix` = 'Road' ,`City` = 'Jones Creek' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a home with 1 ACRE? You have to see this one. Large living area, an updated kitchen with granite countertops, 2 big bedrooms and a full bath. Enjoy the outdoors on the front covered porch or in the back yard. 2 car detached garage with an extra room and bathroom with shower only. Just minutes away from SFA Elementary School. Call today and schedule a your showing.' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HERVEY #2 (A0020 S F AUSTIN DIV 18) ACRES 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hervey #2' ,`TaxAmount` = '2597' ,`TaxRate` = '2.5124' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663701760' WHERE `Matrix_Unique_ID` = '210912339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:03:02.753' ,`MLSNumber` = '60220513' ,`ListAgentFullName` = 'Angela Knee' ,`ListOfficeName` = 'Carswell Real Estate Co. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.206718' ,`Longitude` = '-95.803357' ,`PhotoCount` = '50' ,`PostalCode` = '77355' ,`RoomCount` = '15' ,`ListPrice` = '489900.00' ,`Status` = 'Active' ,`StreetName` = 'Nueces' ,`StreetNumber` = '18974' ,`StreetSuffix` = 'Trail' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Park-like grounds with mature trees on a 0.9 acre cul-de-sac lot welcome you home to a sprawling front porch. The entryway opens up to the study & formal dining on either side, then leads to the light & bright living room. The spacious owner\'s retreat includes private landing/study area with built-in desk, huge bath & large closet with safe. An open kitchen & breakfast room offer great views of your nature lover\'s backyard. 3 additional bedrooms & bath complete the first floor. The upstairs features a generous sized gameroom with built-ins, walk-in attic access points & 5th bdrm or flex space. An oversized driveway leads to a backyard drive-thru gate for easy access to your 12X20 workshop on concrete slab with 8 ft roll-up door. The backyard is fully fenced for your 4-legged family members, plus walk-thru side and back gates. You\'ll find plenty of space for a future backyard oasis, gardening & entertaining with a huge back porch to enjoy the sunsets with your glass of wine.' ,`Acres` = '0.9914' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S821102 - RANCH CREST 02, BLOCK 1, LOT 73' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '43187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Ranch Crest' ,`TaxAmount` = '5996' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701760' WHERE `Matrix_Unique_ID` = '211042371' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:08:55.150' ,`MLSNumber` = '98301434' ,`ListAgentFullName` = 'Christopher McChesney' ,`ListOfficeName` = 'Dash Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.428900' ,`Longitude` = '-97.617246' ,`PhotoCount` = '29' ,`PostalCode` = '78660' ,`RoomCount` = '6' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Windsor Hill' ,`StreetNumber` = '908' ,`StreetSuffix` = 'Drive' ,`City` = 'Pflugerville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1862' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Bungalow w/Open Floor Plan at Cambridge Estates featuring 4 bedrooms, 2 baths, amble natural light, Crown molding complimenting high ceilings, neutral paint tones, stainless steel appliances, and modern stone countertops. Enjoy yourself on cool Spring and Falls day relaxing under the pergola while the kids entertain themselves in the clubhouse/playscape. Easy access to SH130 for a speedy drive into Austin. Conveniently located by Samsung, GM IT Innovation center, Yodle, DELL, HP and more. Give us a call today to find out more.' ,`Acres` = '0.1986' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 44 BLK J CAMBRIDGE ESTATES SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '8651' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '117 - Pflugerville' ,`SchoolElementary` = 'PFLUGERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEISS HIGH SCHOOL' ,`SchoolMiddle` = 'BOHLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cambridge Estates' ,`TaxAmount` = '7654' ,`TaxRate` = '2.4535' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701760' WHERE `Matrix_Unique_ID` = '211128616' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:02:55.873' ,`MLSNumber` = '32433787' ,`ListAgentFullName` = 'Peter Van Borssum' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.113779' ,`Longitude` = '-95.086422' ,`PhotoCount` = '20' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '569000.00' ,`Status` = 'Active' ,`StreetName` = 'Sausalito' ,`StreetNumber` = '25126' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 2015 built home with horizon views of the gulf and bay. Low maintenance features include; fiber cement siding, impact resist doors & windows and vinyl plank flooring. All wood kitchen cabinetry, an 11\' serving bar and over 16\' of counter space in kitchen, stainless appliances. Primary bath incudes a full tile surround shower. Large covered elevated deck space plus over 500 sq ft of patio space on the ground level. Plenty of parking for friends and family.' ,`Acres` = '0.1179' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 6 LOT 5 BLK 3 LAGUNA SAN LUIS SUB' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5134' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`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` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Laguna San Luis 88' ,`TaxAmount` = '7055' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701760' WHERE `Matrix_Unique_ID` = '211294718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:54:15.427' ,`MLSNumber` = '78497616' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.392134' ,`Longitude` = '-95.600235' ,`PhotoCount` = '31' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '464000.00' ,`Status` = 'Active' ,`StreetName` = 'Walden' ,`StreetNumber` = '11526' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home ready for move in. Very open floor plan with an over sized family room. 4 bedrooms, formal dining, breakfast room, & large covered back porch. Sits on a larger 80\' wide lot. Ceramic tile plank floors whole house except for bedrooms. Double sinks primary bath, corner garden tub with jets & seperate shower. Granite countertops kitchen & both baths. Located in exemplary rated Montgomery schools. Walden HOA ammenities include a large water front pool on Lake Conroe, 2 kiddie pools, restaurants, exercise room, multiple tennis & pickle ball courts, 2 boat ramps, walking trails, kids playground, & dog park. Low tax rate of 2.13! Come live the Lake Life!' ,`Acres` = '0.2388' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 02, BLOCK 10, LOT 2 SEC 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 02' ,`TaxAmount` = '222' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701760' WHERE `Matrix_Unique_ID` = '211487827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:54:24.350' ,`MLSNumber` = '72327720' ,`ListAgentFullName` = 'Casey Copley' ,`ListOfficeName` = 'Live Oak Real Estate Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.458820' ,`Longitude` = '-94.176983' ,`PhotoCount` = '16' ,`PostalCode` = '77656' ,`RoomCount` = '4' ,`ListPrice` = '128500.00' ,`Status` = 'Active' ,`StreetName` = 'FM 2937' ,`StreetNumber` = '8335' ,`StreetSuffix` = '' ,`City` = 'Silsbee' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute Tiny Home secluded in the middle of 1.92 acres surrounded by mature shade trees. Front of the Land has been left wooded to shield from the highway. Home was built in 2019. All electric with wood burning stove for heat. Open concept kitchen dining and living room with ease access to Bedrooms and Bathroom.' ,`Acres` = '' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Aprox 1.92 acres from AB 40 O C Nelson' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '252 - Silsbee' ,`SchoolElementary` = 'SILSBEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SILSBEE HIGH SCHOOL' ,`SchoolMiddle` = 'EDWARDS-JOHNSON MEMORIAL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Out Of Town' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663701760' WHERE `Matrix_Unique_ID` = '211587421' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:26:23.827' ,`MLSNumber` = '53184974' ,`ListAgentFullName` = 'Antonio Rodriguez' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731625' ,`Longitude` = '-95.370055' ,`PhotoCount` = '23' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Alabama' ,`StreetNumber` = '2120' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2145' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this Original Brick Bungalow off the corner of Alabama/Hutchins. This Property offers a brick veneer exterior, Huge covered front porch, four huge bedrooms & two bathrooms, open living area, central ac/heat, bonus room 18X9, a double driveway with a detached 2 car garage and 2 car carport. Make your appointment today!' ,`Acres` = '0.1205' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 1 WASHINGTON TERRACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Washington Terrace' ,`TaxAmount` = '4105' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701761' WHERE `Matrix_Unique_ID` = '211684552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:54:07.627' ,`MLSNumber` = '49238722' ,`ListAgentFullName` = 'Chip Bubela' ,`ListOfficeName` = 'Bubela & Associates, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683207' ,`Longitude` = '-96.908189' ,`PhotoCount` = '18' ,`PostalCode` = '78956' ,`RoomCount` = '4' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'Wolters' ,`StreetNumber` = '409' ,`StreetSuffix` = 'Avenue' ,`City` = 'Schulenburg' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Corner Lot Cutie!\r\nThis home is ready for a new owner’s touch! Sitting on a corner lot, this 3-bedroom, 1-bath home is in a prime location. Only 3 blocks from lively downtown Schulenburg and walking or biking distance to the local public school. This built-to-last home offers original hardwood floors, spacious rooms, and high tongue and groove detailed ceilings! The dining room and kitchen are an ideal size and blank canvas for personalization. This house is the perfect starter home or an investment. Holding many of its original finishes, with some updating throughout, this home can really be made into a unique abode!\r\nSchedule a personal tour soon!' ,`Acres` = '0.138' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'WITTBECKER ADDN. (515) LOT 2 BLK II .138 RENT HSE' ,`LotDesciption` = 'Corner' ,`LotSize` = '6011' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '207 - Schulenburg' ,`SchoolElementary` = 'SCHULENBURG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCHULENBURG SECONDARY SCHOOL' ,`SchoolMiddle` = 'SCHULENBURG SECONDARY SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wittbecker Add 515' ,`TaxAmount` = '1275' ,`TaxRate` = '1.8323' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701761' WHERE `Matrix_Unique_ID` = '211684684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:53:40.710' ,`MLSNumber` = '84285162' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.350075' ,`Longitude` = '-95.502552' ,`PhotoCount` = '19' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '259990.00' ,`Status` = 'Active' ,`StreetName` = 'Lawrence Park' ,`StreetNumber` = '2914' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1307' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Madison Bend in Conroe, TX! Conveniently located 1.5 miles off I-45 and N FM 3083 W – homeowners enjoy a low property tax rate and close proximity to Lake Conroe and The Woodlands! The Charlotte floorplan is a charming 1-story plan with 3 bedrooms, 2 bathrooms, and a 2-car garage! You’ll love entertaining in this home! The gourmet kitchen is sure to please with a large bar top overlooking the dining and family rooms, 42” cabinets, and granite countertops! Retreat to the Owner’s Suite featuring a beautiful bay window, sizable shower, walk-in closet, and tray ceiling for some dramatic flair! Don’t miss your opportunity to call Madison Bend home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MADISON BEND 02, BLOCK 1, LOT 58' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Madison Bend' ,`TaxAmount` = '' ,`TaxRate` = '2.88' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701761' WHERE `Matrix_Unique_ID` = '211687087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:55:43.173' ,`MLSNumber` = '8199857' ,`ListAgentFullName` = 'Christy Buck' ,`ListOfficeName` = 'Infinity Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811606' ,`Longitude` = '-94.845298' ,`PhotoCount` = '30' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Tallow Wood' ,`StreetNumber` = '8010' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You don\'t want to miss out on this awesome home in Barbers Hill ISD on over .25 acre lot! This split plan, 4 bedroom, 2 bath with a 2 car garage is move-in ready! Many wonderful features - kitchen is open to family room lots of counterspace, tile backsplash, newer stainless appliances and nice cabinets. Family room and entry are flanked beautiful stained concrete floors along with cozy fireplace. Delightful backyard offers above ground pool, covered patio and ceiling fan - great for relaxing and entertaining! Check out the garden shed for additional storage. Property is conveniently located to I-10 and Grand Parkway (99) for the commuter. Great local shopping nearby.' ,`Acres` = '0.273' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 52 COTTON CREEK S/D' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11892' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cotton Creek Sub' ,`TaxAmount` = '3947' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701761' WHERE `Matrix_Unique_ID` = '211691674' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:25:39.463' ,`MLSNumber` = '16769684' ,`ListAgentFullName` = 'Michelle Alejo' ,`ListOfficeName` = 'Coldwell Banker The Ron Brown' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.191240' ,`Longitude` = '-96.279886' ,`PhotoCount` = '30' ,`PostalCode` = '77437' ,`RoomCount` = '4' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue G' ,`StreetNumber` = '211' ,`StreetSuffix` = '' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1967' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One-of-a-kind updated home sits on a large corner lot and includes a private backyard perfect for entertaining. Enjoy the shady backyard area under the covered patio or large shade tree and store your outdoor toys and accessories in the sheds. The comfort inside the home features 4 spacious bedrooms with large closets, 2 updated bathrooms, and kitchen/dining room combo. Kitchen includes an island and the master bedroom has enough room for an office and includes a huge walk-in closet. Property also comes with an outdoor sprinkler system and security cameras. Schedule your viewing today!' ,`Acres` = '0.241' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HARDY BLOCK 2 LOT 5A,6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`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,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hardy' ,`TaxAmount` = '4726' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701761' WHERE `Matrix_Unique_ID` = '211691848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:05:53.723' ,`MLSNumber` = '18054371' ,`ListAgentFullName` = 'Mario Navarro' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.628042' ,`Longitude` = '-95.636751' ,`PhotoCount` = '7' ,`PostalCode` = '77498' ,`RoomCount` = '3' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue H' ,`StreetNumber` = '119' ,`StreetSuffix` = '' ,`City` = 'Sugar Land' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3/1 renovated home with a desired split floor plan located in an established community. It is the perfect place to relax and gather with family and friends. kitchen with luminous granite countertops, Grey cabinetry. Recent modern gray paint and faux wood flooring in main living areas. Spacious primary bedroom . Minutes from restaurants, shopping, and more. Schedule your showing today!' ,`Acres` = '0.1195' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAYFIELD PARK SEC 1, BLOCK 1, LOT 11' ,`LotDesciption` = 'Other' ,`LotSize` = '5204' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LAKEVIEW ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Mayfield Park' ,`TaxAmount` = '3148' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701761' WHERE `Matrix_Unique_ID` = '211693804' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:39:28.907' ,`MLSNumber` = '55652905' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219433' ,`Longitude` = '-95.163798' ,`PhotoCount` = '48' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '291540.00' ,`Status` = 'Active' ,`StreetName` = 'Willie Mays' ,`StreetNumber` = '15323' ,`StreetSuffix` = 'Court' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new 1 story 4 bedroom 3 bath 2 car garage. Colina Home features granite, kitchen includes recess lighting. high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" cabinets, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is Move in ready September 2022. Call to schedule a showing now. Photos are representative.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29 Block 3 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701761' WHERE `Matrix_Unique_ID` = '211693986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:49:05.310' ,`MLSNumber` = '29392306' ,`ListAgentFullName` = 'Mark Cameron' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.656747' ,`Longitude` = '-95.536752' ,`PhotoCount` = '46' ,`PostalCode` = '77340' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'West Green Briar' ,`StreetNumber` = '2536' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2122' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing open concept, single-story home that was built in 2015 is a perfect place to call home! Stately entry greets you with an extended width doorway. This home is a must-see with many updated features, including a whole house generator, custom plantation shutters, tray ceilings, crown moldings, lifetime gutters, a covered porch backing up to the National Forest, storage shed, and a water filter. High-quality wood and tile throughout the home. The home is close to the Tennis Court, the walking trails and park, and the Olympic Swimming Pool. Large rooms for entertaining and privacy out back for a coffee and chat with the deer. The refrigerator is included. The washer and dryer will be removed.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Elkins Lake - Sec 3A, Block 37, lot 27' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9196' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Elkins Lake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701762' WHERE `Matrix_Unique_ID` = '211694036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:39:01.840' ,`MLSNumber` = '35620589' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219471' ,`Longitude` = '-95.162923' ,`PhotoCount` = '48' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '291690.00' ,`Status` = 'Active' ,`StreetName` = 'Cooperstown' ,`StreetNumber` = '26218' ,`StreetSuffix` = 'Way' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new 1 story 4 bedroom 3 bath 2 car garage. Colina Home features granite, kitchen includes recess lighting. high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" cabinets, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is Move in ready October/November 2022. Call to schedule a showing now. Photos are representative.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12668' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701762' WHERE `Matrix_Unique_ID` = '211695301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:26:27.773' ,`MLSNumber` = '77488572' ,`ListAgentFullName` = 'Crystal Hernandez' ,`ListOfficeName` = 'ST Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.532382' ,`Longitude` = '-95.181156' ,`PhotoCount` = '8' ,`PostalCode` = '77546' ,`RoomCount` = '3' ,`ListPrice` = '234900.00' ,`Status` = 'Active' ,`StreetName` = 'Barcelona' ,`StreetNumber` = '16310' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Want a Massive Backyard? This home has it! Must see it before its gone. Home could use some TLC and a backyard big enough for a pool or any outdoor ideas will make it new again! Not in a flood zone and never flooded. SELLING AS IS, NO REPAIRS.' ,`Acres` = '0.3763' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures,Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 32 WEDGEWOOD VILLAGE SEC 6 R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '16392' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEDGEWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wedgewood Village Sec 06 R/P' ,`TaxAmount` = '5024' ,`TaxRate` = '2.2534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701762' WHERE `Matrix_Unique_ID` = '211695765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T14:38:25.680' ,`MLSNumber` = '18487869' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219433' ,`Longitude` = '-95.163798' ,`PhotoCount` = '48' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '288990.00' ,`Status` = 'Active' ,`StreetName` = 'Willie Mays' ,`StreetNumber` = '15332' ,`StreetSuffix` = 'Court' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new 1 story 4 bedroom 3 bath 2 car garage. Colina Home features granite, kitchen includes recess lighting. high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" cabinets, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is Move in ready September 2022. Call to schedule a showing now. Photos are representative.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 32 Block 1 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701762' WHERE `Matrix_Unique_ID` = '211696099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T15:51:15.733' ,`MLSNumber` = '63482859' ,`ListAgentFullName` = 'Bevan Walker' ,`ListOfficeName` = 'Allsource Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.596590' ,`Longitude` = '-94.760461' ,`PhotoCount` = '27' ,`PostalCode` = '75605' ,`RoomCount` = '4' ,`ListPrice` = '561000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest' ,`StreetNumber` = '830' ,`StreetSuffix` = 'Lake' ,`City` = 'Longview' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3882' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful lake view property, Boasting a salt water fenced in pool. The Primary Bedroom is on the 2nd Level with the other Bedrooms Downstairs. Energy efficient lighting with the sliding doors along the house. Bonus guest quarters or playhouse for the kids. Four full bathrooms, with spacious kitchen that opens to the living areas. Hurry & view. Great vacation or 2nd home.' ,`Acres` = '0.4891' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 92 BLK 4 FOREST LAKE #1' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '21306' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '690 - Longview' ,`SchoolElementary` = 'JOHNSTON ELEMENTARY SCHOOL (LONGVIEW)' ,`SchoolHigh` = 'LONGVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'JUDSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Lake' ,`TaxAmount` = '7220' ,`TaxRate` = '1.8108' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701762' WHERE `Matrix_Unique_ID` = '211699453' --> Updated record success