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-29T19:16:36.337' ,`MLSNumber` = '13049931' ,`ListAgentFullName` = 'Patricia McCulley' ,`ListOfficeName` = 'Country World Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.704474' ,`Longitude` = '-94.853340' ,`PhotoCount` = '50' ,`PostalCode` = '77351' ,`RoomCount` = '7' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Berts Farm' ,`StreetNumber` = '139' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property has it all. Located only minutes from downtown Livingston, this property offers a main dwelling that is 3542 per Polk CAD plus a detached Garage Efficiency Apartment with Bedroom, Kitchen, Living area and 1/2 bath upstairs plus approximately 400 SF bedroom, full bath and utility room downstairs. There is also a one room cabin on the property with bathroom. This property would lend itself to being an Air B & B or a property for extended family members to reside. Fully fenced with fruit trees, garden spot and chicken pen, this is country life at it\'s best. There is a detailed sheet that goes into great detail of all the improvements this property has to offer available upon request.' ,`Acres` = '1.55' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '1.55 acres in the Z.H. Price Survey AB-720' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '67518' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Beech Creek Village South' ,`TaxAmount` = '8819' ,`TaxRate` = '1.9558' ,`WaterSewer` = 'Public Water,Septic Tank,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704532' WHERE `Matrix_Unique_ID` = '200519340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:31:27.823' ,`MLSNumber` = '58190704' ,`ListAgentFullName` = 'Monica Grosu' ,`ListOfficeName` = 'EVERAGENT' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.622913' ,`Longitude` = '-95.011328' ,`PhotoCount` = '13' ,`PostalCode` = '77571' ,`RoomCount` = '5' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest' ,`StreetNumber` = '224' ,`StreetSuffix` = 'Avenue' ,`City` = 'Shoreacres' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this single-story home located in the quiet & beautiful Shoreacres community with access to the lighted fishing pier, & boat ramp with exclusive rights for residents. Minutes walk to The Bay! NO HOA. A golf cart ride away to the Houston Yacht Club which has a magnificent pool and great boat slips. The inside home features neutral paint tones, an open floorplan design. The kitchen has granite countertops and opens up to the dining room. Large living room area. Carpet in all bedrooms, tile bathroom, washer & dryer connections, 2 car garage, covered patio & porch and a spacious partially fenced backyard. Tenant occupied.' ,`Acres` = '0.1791' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shoreacres/La Porte' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 BLK 3 SHOREACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shoreacres' ,`TaxAmount` = '4324' ,`TaxRate` = '2.8597' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704532' WHERE `Matrix_Unique_ID` = '204293607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T19:31:32.517' ,`MLSNumber` = '59256510' ,`ListAgentFullName` = 'Patrick Lalezari' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595866' ,`Longitude` = '-95.243332' ,`PhotoCount` = '40' ,`PostalCode` = '77089' ,`RoomCount` = '9' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkvale' ,`StreetNumber` = '10211' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1868' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home located in the South East of Houston. It has 3 bedrooms, 2 full baths. The home is welcoming with a den to the right. It has a spacious Kitchen with plenty of cabinet space for storage. All NEW stainless steel appliances, NEW granite countertops. The breakfast bar looks into the living room which includes a fireplace that looks out to the backyard. It is unique with a sunroom allowing plenty of natural light. The master bedroom has its own walk-in closet and a master bath with double vanity. The backyard is very spacious with an in-ground pool and patio. The home is located within walking distance of Moore Elementary and Dobie High School. CLose proximity to the freeway, walking trails, and the park. Call and schedule an appointment today!' ,`Acres` = '0.1742' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 7 KIRKMONT SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '176' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Kirkmont Sec 02' ,`TaxAmount` = '5274' ,`TaxRate` = '2.6655' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704532' WHERE `Matrix_Unique_ID` = '207945106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T19:21:26.473' ,`MLSNumber` = '22157352' ,`ListAgentFullName` = 'Cameron Namazi' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023629' ,`Longitude` = '-95.306697' ,`PhotoCount` = '26' ,`PostalCode` = '77338' ,`RoomCount` = '12' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '21314' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 5 bedroom, 3.5 bath home. Fabulous location! Perfect for entertaining inside and out! Features include almost a 1/2 acre lot, swimming pool, enclosed sunroom, grand 2-story entry, gourmet island kitchen opens to the living room, 2 fireplaces, balcony overlooking the lush backyard and patio area, plus a 2 bedroom apartment above the 3-car garage! The Lot on the right side is not included.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 AMBERWOOD U/R ABST 139 A R BODMAN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Amberwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704532' WHERE `Matrix_Unique_ID` = '208648695' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T19:30:23.020' ,`MLSNumber` = '90643728' ,`ListAgentFullName` = 'Shawn Shakir' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.048854' ,`Longitude` = '-95.397076' ,`PhotoCount` = '11' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '244999.00' ,`Status` = 'Active' ,`StreetName` = 'Briarcreek' ,`StreetNumber` = '23426' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*TENANT OCCUPIED* This Beautiful 2-story 3 Bed, 2 Full Bath house is located in a quiet neighborhood of Timber Lane. This property features two spacious living rooms, a covered patio, a balcony, and a huge backyard perfect for family gatherings and enjoying breezy summer nights. The current lease expires 11/30/2022. Home is sold \"AS-IS\". Since it is tenant-occupied, this property offers a great opportunity for any buyer to also invest and generate a stable rental income. Minutes away from Hardy Tollway and major restaurants. Do not miss out. Call TODAY for any further inquiries and to schedule your private tour.' ,`Acres` = '0.1736' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 51 TIMBER LANE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Timber Lane Sec 06' ,`TaxAmount` = '4877' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704532' WHERE `Matrix_Unique_ID` = '208981439' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T19:22:29.853' ,`MLSNumber` = '70744022' ,`ListAgentFullName` = 'Cameron Namazi' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784395' ,`Longitude` = '-95.355038' ,`PhotoCount` = '41' ,`PostalCode` = '77009' ,`RoomCount` = '10' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Morris' ,`StreetNumber` = '1275' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1538' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully renovated home located near the heart of Houston. This FULLY RENOVATED home has soaring high ceilings, NEW FLOORING, NEW QUARTZ CABINETS, STAINLESS STEEL APPLIANCES, AND LIGHT FIXTURES. Both living and dining rooms are very spacious with plenty of natural lighting. The Kitchen has quartz countertops and a backsplash and a complete breakfast bar with cabinets for plenty of storage room. The main bedroom is spacious and it has direct access to the main bathroom shower that has crystal doors and porcelain tile, and gold fixtures. The other two bedrooms have direct access to the second bathroom which also has porcelain tile and crystal doors, and a vanity area. The entire house has luxury vinyl plank flooring. The backyard is fully fenced and both the front and back yard have a wood porch. This home is perfect for unwinding and entertaining family and friends! This beautiful home is ideally located near the metro light rail, downtown, and the 45, 59, and I-10 freeways.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 11A & 12A BLK 57 LITTLE & DICKINSON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARTINEZ C ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Little & Dickinson' ,`TaxAmount` = '4108' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1926' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704533' WHERE `Matrix_Unique_ID` = '209669251' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:27:47.197' ,`MLSNumber` = '85049541' ,`ListAgentFullName` = 'Robert Roca' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654918' ,`Longitude` = '-95.072804' ,`PhotoCount` = '35' ,`PostalCode` = '77571' ,`RoomCount` = '11' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Shell Rock' ,`StreetNumber` = '10402' ,`StreetSuffix` = 'Road' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is an investor or Do It Yourselfer\'s dream. Sitting on just over a 1/4 acre and Full of potential and ready for your amazing ideas to come to life. Just minutes from schools, local shopping, and dining, this home could be your perfect piece of paradise after a little TLC. Contact us today for your personal showing.' ,`Acres` = '0.292' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 20 FAIRMONT PARK SEC 2' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '12720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LEO RIZZUTO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Fairmont Park Sec 02' ,`TaxAmount` = '5922' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704533' WHERE `Matrix_Unique_ID` = '209960126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:06:46.660' ,`MLSNumber` = '58481189' ,`ListAgentFullName` = 'Mary Dorsey' ,`ListOfficeName` = 'Mary Dorsey Texas Real Estate' ,`SellingAgentFullName` = 'Michelle Garcia' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.072930' ,`Longitude` = '-95.562884' ,`PhotoCount` = '42' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '499900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wenbury' ,`StreetNumber` = '22402' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Village Builder, 5 bedroom 3 1/2 bath home. Great family home. No back neighbors. Home backs up to a pretty subdivision Lake. With Lake views both behind and next to the home. Large 5 bedrooms with plenty of closet space. Great subdivision and location. Home features fresh paint, new flooring, new carpet, updated cabinets and much more. Close to schools, shopping, dining downtown Tomball. Easy 99 access.' ,`Acres` = '0.2215' ,`Area` = '14' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 2 INVERNESS ESTATES SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '9650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inverness Estates Sec 2' ,`TaxAmount` = '9726' ,`TaxRate` = '3.0565' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704533' WHERE `Matrix_Unique_ID` = '210031026' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:27:30.477' ,`MLSNumber` = '36713733' ,`ListAgentFullName` = 'Audra O\'Neal' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.466040' ,`Longitude` = '-95.827671' ,`PhotoCount` = '27' ,`PostalCode` = '77461' ,`RoomCount` = '6' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'SADDLE DRIVE' ,`StreetNumber` = '5102' ,`StreetSuffix` = '' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5102 Saddle Drive is COMING SOON to the Market! Located in Needville, Texas. 3.21 ACRES located by a BEAUTIFUL PECAN TREE FARM, better still - you\'ll have your OWN PECAN TREES on Your Land! , Enjoy the View on your Covered Porch - FRONT and BACK! This Stunning Lot offers a 3 BEDROOM and 2.5 BATHROOM Home, Kitchen is OPEN to Living Area, FRESH PAINT on Interior and Exterior 2022. NEW LIGHTING THROUGHOUT. NEW CEILING FANS. HUGE BARN Located Behind the home, with BONUS Upstairs - Ready for you to Make Your OWN! Property has potential to be divided into TWO 1.6 ACRE LOTS! If divided, each Lot could have it\'s own Single Family Residence - Deed Restrictions Apply - COME SEE IT TODAY!' ,`Acres` = '3.21' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0269 I AND GN RY, ACRES 3.21' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '139828' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'I AND GN RY' ,`TaxAmount` = '4978' ,`TaxRate` = '1.9957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704533' WHERE `Matrix_Unique_ID` = '210547310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T19:20:59.173' ,`MLSNumber` = '33228000' ,`ListAgentFullName` = 'Cameron Namazi' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.256187' ,`Longitude` = '-95.493895' ,`PhotoCount` = '50' ,`PostalCode` = '77384' ,`RoomCount` = '12' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Stableridge' ,`StreetNumber` = '2243' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful upgraded built home in Carriage Hills subdivision near WG Jones State Park and 10 mins away from the Woodlands. Three very spacious bedrooms, 2 full baths, and a half powder bathroom. Including a spacious and beautiful open large island kitchen, formal dining, a large den/family room, and a breakfast room. The generous primary suite offers privacy with double sinks, an elevated spa tub, a separate shower, and a walk-in closet with built-in shelving and a door to the backyard area. Den/ Family Room, Dining Room, and Breakfast are all connected, spacious, and filled with plenty of natural light. It includes plenty of storage rooms such as a wet bar, built-in cabinets, and a pantry room. A dedicated utility room with a sink, built-in cabinets, linen closet, and counter area to complete the home. The home has a patio/backyard covered area that includes a hot tub that is not operational with a deck and a small storage building. Welcome to your new home!' ,`Acres` = '3.71' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CARRIAGE HILLS 03, LOT 177' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '161608' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '239' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Carriage Hills 03' ,`TaxAmount` = '6924' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704533' WHERE `Matrix_Unique_ID` = '210738531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:45:57.980' ,`MLSNumber` = '69863977' ,`ListAgentFullName` = 'Lindsay Rose' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723968' ,`Longitude` = '-95.301047' ,`PhotoCount` = '46' ,`PostalCode` = '77023' ,`RoomCount` = '3' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Hill' ,`StreetNumber` = '1826' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3421' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location!! This home offers 3 bedrooms and 2 baths in the main house, and a separate apartment with full kitchen, living space, bedroom and full bath that can be used as income-producing or home office. The main home offers original hardwoods, updated windows, and a large game room. This home is conveniently located close to the city, yet still captures a peace and quiet in this gem of a neighborhood. All within a short walk to Gus Wortham Golf Course, Mason Park and Hike and Bike trails. Transportation is made easy with this home located just minutes from the Metro Rail, Downtown, Medical Center, University of Houston, and Hobby Airport. You don’t want to miss this unique home in heart of the East End! Not in a flood zone nor flooded per seller.' ,`Acres` = '0.1588' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 43C (PRIOR YEAR IMPS 2007-2011*0141910000512) FOREST HILL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6918' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRISCOE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Hill' ,`TaxAmount` = '6439' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704533' WHERE `Matrix_Unique_ID` = '211073595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:12:15.937' ,`MLSNumber` = '51952424' ,`ListAgentFullName` = 'Kristi Jeu' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.870407' ,`Longitude` = '-95.727439' ,`PhotoCount` = '16' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Patriot Park' ,`StreetNumber` = '20924' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this lovely 4 bedroom, 2 1/2 Bath with a game room in quiet Lakeville! This home boast new vinyl 4 inch plank flooring, new washer, dryer, gas range, privacy fence and stainless fridge included. Privacy fence includes a double gate big enough to drive through. Home has a large downstairs primary with bath and walk-in closet. Upstairs you will find three additional bedrooms and a loft game room. This is a must see!' ,`Acres` = '0.068' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 LAKEVILLE SEC 3' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '2961' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeville Sec 03 03' ,`TaxAmount` = '4573' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704533' WHERE `Matrix_Unique_ID` = '211367545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:48:26.860' ,`MLSNumber` = '20510462' ,`ListAgentFullName` = 'Todd Neal' ,`ListOfficeName` = 'Neal Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807818' ,`Longitude` = '-95.427938' ,`PhotoCount` = '15' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = '24th' ,`StreetNumber` = '1605' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely three story home with three bedrooms and three 1/2 bathrooms is located in the heart of the heights. With beautiful hardwood floors, high ceilings and large closets this home has it all. The first floor has an open foyer with one bedroom and a full bath that connects to the garage. Highlighted by natural lighting and high ceilings. the gourmet kitchen, family room, dining room and office/game room is located on the second floor. The kitchen offers granite countertops and stainless steel appliances. The oversized primary bedroom and bathroom as well as the third bedroom and private bathroom are located on the third floor. Walking distance to retail, restaurants, parks and entertainment. All appliances including the washer and dryer are included.' ,`Acres` = '0.0501' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 1 CMC PROPERTIES' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2181' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Georgian' ,`Subdivision` = 'CMC Properties - Heights' ,`TaxAmount` = '8713' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704534' WHERE `Matrix_Unique_ID` = '211392432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T19:13:35.413' ,`MLSNumber` = '62974808' ,`ListAgentFullName` = 'Carla Gentry' ,`ListOfficeName` = 'Texas Select Properties, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164539' ,`Longitude` = '-97.483488' ,`PhotoCount` = '40' ,`PostalCode` = '78612' ,`RoomCount` = '6' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Pecos' ,`StreetNumber` = '142' ,`StreetSuffix` = 'Street' ,`City` = 'Cedar Creek' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3286' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous property located in a Prestigious Equestrian Gated Community of River Crossings. This stunning 3,286 sq ft home, in Cedar Creek has 4 bdrms, 4 baths, 2 car attached garage on 2 acres in a quiet cul-de-sac street! Built in 2001, this all brick home has a study, formal dining room, and a grand living area that flows into the kitchen/breakfast area. Enormous two tiered deck, with jacuzzi and panoramic views for entertaining! The floor plan has three bdrms down, including the master and one bdrm up plus a media room. Granite and custom backsplash in kitchen. Glass breakfront, and center island with storage. 46x20 ft barn with two roll up doors and two side doors. The barn has a 200 Amp service with lights and fans. Adjacent to the larger barn is a separate 17.3x11 ft equipment barn and another 17.3x11 ft barn/artist studio w/ AC. Concrete driveway, gutters covered with mesh, and a complete alarm system with window sensors. The appliances will stay. (Refrigerator/ washer/dryer)' ,`Acres` = '2' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER CROSSING SECTION 1, LOT 14, ACRES 2.0000' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '445' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '210 - Bastrop' ,`SchoolElementary` = 'BLUEBONNET ELEMENTARY SCHOOL (BASTROP)' ,`SchoolHigh` = 'CEDAR CREEK H S' ,`SchoolMiddle` = 'CEDAR CREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Crossing' ,`TaxAmount` = '9663' ,`TaxRate` = '1.895' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704534' WHERE `Matrix_Unique_ID` = '211433304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:47:17.820' ,`MLSNumber` = '60512493' ,`ListAgentFullName` = 'Nathan Balderas' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782744' ,`Longitude` = '-95.331583' ,`PhotoCount` = '9' ,`PostalCode` = '77026' ,`RoomCount` = '2' ,`ListPrice` = '110000.00' ,`Status` = 'Active' ,`StreetName` = 'Hutton' ,`StreetNumber` = '2238' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great investment opportunity! This home is conveniently located close to Downtown, Entertainment, Dinning, Shopping, University Campuses, Metro and so much more!' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'N 25 FT OF LT 1 BLK 11 HOME' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home' ,`TaxAmount` = '748' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704534' WHERE `Matrix_Unique_ID` = '211471595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:45:18.217' ,`MLSNumber` = '92695792' ,`ListAgentFullName` = 'Nathan Balderas' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782606' ,`Longitude` = '-95.331578' ,`PhotoCount` = '12' ,`PostalCode` = '77026' ,`RoomCount` = '2' ,`ListPrice` = '110000.00' ,`Status` = 'Active' ,`StreetName` = 'Hutton' ,`StreetNumber` = '2230' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment Opportunity! This home is located close to Downtown, Entertainment, Dinning, Shopping, University Campuses, Metro and so much more!' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'N 25 FT OF LT 2 BLK 11 HOME' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home' ,`TaxAmount` = '751' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704534' WHERE `Matrix_Unique_ID` = '211472006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:34:15.953' ,`MLSNumber` = '43145377' ,`ListAgentFullName` = 'Karryn Nichols' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.398664' ,`Longitude` = '-96.325299' ,`PhotoCount` = '50' ,`PostalCode` = '75846' ,`RoomCount` = '7' ,`ListPrice` = '1450000.00' ,`Status` = 'Active' ,`StreetName` = 'Lcr 894' ,`StreetNumber` = '827' ,`StreetSuffix` = '' ,`City` = 'Jewett' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3807' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular 1.60 Acre waterfront home on Lake Limestone that has been completely remodeled! This turnkey property is located in Cedar Creek Estates Community! Perfect for large gatherings, this 5-bedroom, 4 bath home features all fresh interior paint, new tile, carpet and vinyl floors, alarm system, amazing storage, and granite countertops in kitchen and baths. The sleek and functional kitchen with all new appliances including icemaker, microwave \r\nvent-a-hood, new cabinets, spice cabinets and pantry cabinets that pull out and drawers! Kitchen opens to the breakfast room/living room with panoramic lake views, custom shutters throughout; huge screened in garden room overlooking the lake! A guest home with 1 bedroom and 1 full bath and kitchenette overlooking the water! The 1600 sq ft metal building has a large garage door that opens towards the lake for privacy and large get togethers! Enjoy breathtaking sunsets on the lake from the Pier! This turnkey property is one of a kind!' ,`Acres` = '1.6008' ,`Area` = '73' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CEDAR CREEK ESTATES LAKE LIMESTONE, BLOCK H, LOT 069 - 071' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '69731' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '222 - Groesbeck' ,`SchoolElementary` = 'GROESBECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROESBECK HIGH SCHOOL' ,`SchoolMiddle` = 'GROESBECK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cedar Creek Estates' ,`TaxAmount` = '12303' ,`TaxRate` = '2.298' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704534' WHERE `Matrix_Unique_ID` = '211539323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:09:22.877' ,`MLSNumber` = '57941908' ,`ListAgentFullName` = 'Kim Crenshaw' ,`ListOfficeName` = 'Legend Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152601' ,`Longitude` = '-96.370831' ,`PhotoCount` = '26' ,`PostalCode` = '77833' ,`RoomCount` = '12' ,`ListPrice` = '468500.00' ,`Status` = 'Active' ,`StreetName` = 'Rindle' ,`StreetNumber` = '2215' ,`StreetSuffix` = 'Court' ,`City` = 'Brenham' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME to the popular Ralston Creek Estates! This 4 bedroom, 3 and a 1/2 bath home has been so meticulously well cared for by it\'s original owners. Just inside the entry, double french doors lead to a quiet space that would be an ideal office or library. Next you will encounter the open concept living room with a corner gas-log fireplace, formal dining room and a large kitchen with a breakfast nook. This home offers high ceilings, island for food prep or serving and a very spacious walk-in pantry. All countertops are an attractive granite. The principal bedroom is located on the first floor and includes a spa-like ensuite with a soaking garden tub, glass shower, double vanity and enormous closet!\r\nOn the second floor you will find the remaining 3 bedrooms, 2 additional full baths and an incredible \r\nmedia room space. You won\'t believe the abundance of storage this plan offers! It truly is move-in ready! \r\nSchedule your showing soon!' ,`Acres` = '0.17' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S4885 - RALSTON CREEK ESTATES, BLOCK 4, LOT 6, ACRES 0.17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ralston Creek Estates' ,`TaxAmount` = '3292' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704534' WHERE `Matrix_Unique_ID` = '211654398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:09:47.913' ,`MLSNumber` = '61620956' ,`ListAgentFullName` = 'Melissa Sadler White' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.175330' ,`Longitude` = '-95.206584' ,`PhotoCount` = '9' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '133550.00' ,`Status` = 'Active' ,`StreetName` = 'Cobbleshire' ,`StreetNumber` = '23445' ,`StreetSuffix` = 'Court' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute mobile home on a dead-end street. Enjoy the quietness this spot has to offer while living the country life but yet being close to city convenances! Take a short drive to Walmart, Valley Ranch Town Center and much more. This is located within the highly sought-after New Caney ISD. Perfect for those who are looking to stop renting and want to buy! This would make a great investment, as it is currently a rental.' ,`Acres` = '0.4263' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S958001 - WILSHIRE, BLOCK 3, LOT 2, SERIAL # TXCTCMW002837,' ,`LotDesciption` = 'Cleared' ,`LotSize` = '18569' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilshire' ,`TaxAmount` = '744' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704534' WHERE `Matrix_Unique_ID` = '211793398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:09:04.373' ,`MLSNumber` = '8081568' ,`ListAgentFullName` = 'Melissa Sadler White' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.176245' ,`Longitude` = '-95.205467' ,`PhotoCount` = '11' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '133550.00' ,`Status` = 'Active' ,`StreetName` = 'Wilshire' ,`StreetNumber` = '18595' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is located on the straightaway yet tucked slightly in before a curve. Don\'t let that scare you as it is a pretty quiet area. Enjoy having no neighbors to the left while being surrounded with woods on that side. Take a short drive into town for all of your shopping and dining needs. This is located within the highly sought-after New Caney ISD. Perfect for those who are looking to stop renting and want to buy! This would make a great investment, as it is currently a rental.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S958001 - WILSHIRE, BLOCK 1, LOT 2, SERIAL # CLW015971TX, TI' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15645' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilshire' ,`TaxAmount` = '672' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704535' WHERE `Matrix_Unique_ID` = '211794259' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T19:26:37.230' ,`MLSNumber` = '51927906' ,`ListAgentFullName` = 'Ofelia Ontiveros' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.330257' ,`Longitude` = '-95.310028' ,`PhotoCount` = '16' ,`PostalCode` = '77306' ,`RoomCount` = '6' ,`ListPrice` = '139900.00' ,`Status` = 'Active' ,`StreetName` = 'Emerson' ,`StreetNumber` = '16479' ,`StreetSuffix` = 'Circle' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great for a First-time buyer or investment property. This cute home has recently been painted and has new floors and a spacious living room area with a Fenced back yard for the family to Entertain with a small building storage for all your tools. Come and see for yourself what this home has to offer So hurry this won\'t last long and set your appointment today!' ,`Acres` = '0.2295' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'EMERSON ESTATES 01, BLOCK 2, LOT 22, MH SERIAL # TXFL112A849' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Emerson Estates 01' ,`TaxAmount` = '1118' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704535' WHERE `Matrix_Unique_ID` = '211869640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:05:58.303' ,`MLSNumber` = '30668769' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734392' ,`Longitude` = '-95.865574' ,`PhotoCount` = '48' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '577568.00' ,`Status` = 'Active' ,`StreetName` = 'Freemans View' ,`StreetNumber` = '28506' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to KATY ISD ZONED! D.R. Horton\'s Chloe Floorplan with upgraded Media Room and Refreshment Center! ATTACHMENTS SHOW COLOR PACKAGE. \"Smart Home\" all controllable through your Hub or smartphone. Kitchen with Silestone counters, 5 burner range and 42\" Cabinets! A secondary bedroom wing for the kiddos with a study nook. Large covered patio with plumed gas! Included is everything you are looking for in a community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails ready for you! Call today for your own private tour! Please verify with sales agent options and any upgrades. **PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY*At this time the builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 140; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6922' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704535' WHERE `Matrix_Unique_ID` = '211950233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:05:04.860' ,`MLSNumber` = '82355002' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734361' ,`Longitude` = '-95.865559' ,`PhotoCount` = '45' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '643538.00' ,`Status` = 'Active' ,`StreetName` = 'Freemans View' ,`StreetNumber` = '28514' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to KATY ISD ZONED! D.R. Horton\'s Chloe Floorplan ON A LAKE LOT with upgraded Media Room and Refreshment Center! ATTACHMENTS SHOW COLOR PACKAGE. \"Smart Home\" all controllable through your Hub or smartphone. Kitchen with Silestone counters, 5 burner range and 42\" Cabinets! A secondary bedroom wing for the kiddos with a study nook. Large covered patio with plumed gas! Included is everything you are looking for in a community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails ready for you! Call today for your own private tour! Please verify with sales agent options and any upgrades. **PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY*At this time the builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 138; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '11536' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704535' WHERE `Matrix_Unique_ID` = '211951310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T18:59:47.360' ,`MLSNumber` = '86710996' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734306' ,`Longitude` = '-95.865551' ,`PhotoCount` = '48' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '555530.00' ,`Status` = 'Active' ,`StreetName` = 'Freemans View' ,`StreetNumber` = '28510' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to KATY ISD ZONED! D.R. Horton\'s Rockdale Floorplan on a HUGE Cul-Du-Sac Lot! ATTACHMENTS SHOW COLOR PACKAGE. \"Smart Home\" all controllable through your Hub or smartphone. Gorgeous Kitchen with Silestone counters and 42\" Cabinets! There is a secondary bedroom wing for the kiddos with a study nook. Large covered patio, ready for week-end BBQ\'s with plumed gas! Included is everything you are looking for in a family friendly community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails ready for you! Call today for your own private tour! Please verify with sales agent options and any upgrades. **PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY***At this time builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 139; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14418' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704535' WHERE `Matrix_Unique_ID` = '211956055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T19:33:11.307' ,`MLSNumber` = '13193301' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734255' ,`Longitude` = '-95.865462' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '586635.00' ,`Status` = 'Active' ,`StreetName` = '28515 Freemans View' ,`StreetNumber` = '28515' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to Katy ISD! PLEASE SEE ATTACHMENTS FOR OFFER INSTRUCTIONS. D.R. Horton\'s Two story Pattison model! ATTACHMENTS SHOW COLOR PACKAGE. 4 Bedrooms! 3.5 baths! Full guest room upstairs with private bath! Gorgeous Kitchen with stunning 42\" Cabinets, Silestone counters and stainless steel 5 burner range! Covered patio ready for the week-end BBQ\'s! This is a \"SMART HOME\" with camera doorbell and whole home system. Controlled from your hub or smart phone! Included is everything you are looking for in a community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails all included and ready for you! Please verify with sales agent options and upgrades.**PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY***At this time the builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 136; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '12246' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704535' WHERE `Matrix_Unique_ID` = '211956676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T19:41:50.943' ,`MLSNumber` = '98559128' ,`ListAgentFullName` = 'Joyce Tang' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696272' ,`Longitude` = '-95.359948' ,`PhotoCount` = '23' ,`PostalCode` = '77021' ,`RoomCount` = '7' ,`ListPrice` = '198000.00' ,`Status` = 'Active' ,`StreetName` = 'Luca' ,`StreetNumber` = '3910' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RENOVATED beautiful home in the University Area, New roof, floor, painting, siding, appliance ,AC units, water heater etc. just minutes away from all the major freeways, medical center, downtown, U of H, and much more! New construction surround this area. garage space converted to flex room, can be third bedroom ,Vinyl plank flooring throughout the house. Enjoy the convenience of your own storage house and an indoor utility room for all your laundering needs! Huge backyard with plenty of space that\'s perfect for your kids and/or fur babies! No HOA fee, low tax! this one won\'t last long at all!' ,`Acres` = '0.1412' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 9 SCOTT TERRACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Scott Terrace Sec 03' ,`TaxAmount` = '2362' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704535' WHERE `Matrix_Unique_ID` = '211957292' --> Updated record success