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-12-30T15:37:42.293' ,`MLSNumber` = '10396247' ,`ListAgentFullName` = 'Timothy Williams' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152516' ,`Longitude` = '-94.316120' ,`PhotoCount` = '44' ,`PostalCode` = '77659' ,`RoomCount` = '10' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinecone' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Lane' ,`City` = 'Sour Lake' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Updated Home with Clean Lines nestled on almost an acre is a Must See. The Kitchen Features Quartz Countertops, Penny Tile Backsplash, Sleek Cabinets, Waterfall Style Breakfast Bar, Electric Stove, Stainless Steel Vent Hood, Stainless Steel Dishwasher, and Walk-In Pantry. Living Room includes Wood-Burning Fireplace, Easy to Maintain LVT Wood Style Flooring, and French Doors leading to the Large Covered Patio. Spacious Master Bedroom features His & Hers Walk-In Closets and Designer En Suite Master Bathroom. The Luxurious Master Bathroom includes Soaking Tub with Accent Light, Walk-In Shower with Rain Showerhead and Double Vanities. The Main Floor also includes an Entry & Dining Area with Updated Lighting, 3 More Bedrooms (2 with En Suite Bathrooms with Walk-In Showers), Main Bathroom, and Inside Laundry Room. Upstairs Features a 5th Bedroom, Game Room, 5th Bathroom and Hobby Room (Or 6th Bedroom). House completely updated from the studs in, including electrical and plumbing.' ,`Acres` = '0.959' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 13 BLK 2 PINEWOOD #1 P# HJ25-2-13 I# 2018-89895 10/31/20' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '41774' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinewood #1' ,`TaxAmount` = '3681' ,`TaxRate` = '2.158' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097551' WHERE `Matrix_Unique_ID` = '205054338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T16:06:57.417' ,`MLSNumber` = '70130624' ,`ListAgentFullName` = 'Setha Ponce' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.849717' ,`Longitude` = '-95.198437' ,`PhotoCount` = '34' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '27500.00' ,`Status` = 'Active' ,`StreetName` = 'Mosquito' ,`StreetNumber` = '124' ,`StreetSuffix` = 'Road' ,`City` = 'Trinity' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outdoorsman\'s and family delight! Don\'t miss your chance to own a little piece of \'Heaven\' near the second largest Lake in Texas! This cute cabin sleeps 6 comfortably with tall ceilings and everything you need for weekend get aways! Situated on two beautiful lots with mature trees and wildlife roaming freely. It is located in a deed restricted, Lake Livingston Community. This subdivision has a boat ramp with lake access, a clubhouse, a pier to fish off of, and a playground as well. Schedule a showing today!' ,`Acres` = '0.287' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'HAWG HEAVEN LOT 36,37' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '12501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hawg Heaven Sec 3' ,`TaxAmount` = '231' ,`TaxRate` = '1.6133' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097552' WHERE `Matrix_Unique_ID` = '208299065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T15:53:43.990' ,`MLSNumber` = '35910280' ,`ListAgentFullName` = 'Erik Jeffreys' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.420721' ,`Longitude` = '-95.554835' ,`PhotoCount` = '28' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgecrest' ,`StreetNumber` = '12339' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come relax and enjoy this spacious 3 bed, 2 and-a-half bath with a game room in the envied Lake Conroe Hills subdivision. Kick off your shoes, sit back, and enjoy the sunshine and smell of the fresh-air flowing from Lake Conroe after a hard day\'s work! New appliances! New paint! New carpet! Residents enjoy a neighborhood boat ramp, private docking facilities, community parks and a corner grocery store within the neighborhood. With easy access to I-45 and comfortable living, Lake Conroe Hills provides residents with a peaceful year-round escape!' ,`Acres` = '0.2152' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE HILLS 02, BLOCK 11, LOT 68' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Hills 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097552' WHERE `Matrix_Unique_ID` = '210534870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T16:02:53.843' ,`MLSNumber` = '10324529' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Julie Husband' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.773000' ,`Longitude` = '-94.682696' ,`PhotoCount` = '29' ,`PostalCode` = '77514' ,`RoomCount` = '10' ,`ListPrice` = '289990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Little Spring' ,`StreetNumber` = '111' ,`StreetSuffix` = 'Court' ,`City` = 'Anahuac' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton One Story Ranch Home Under Construction! Come Home to the Trees! Upgraded Brick Elevation on a Huge Lot! Large Covered Patio! Grand Entry with High Ceilings! Amazing Carefree Vinyl Like Wood Floors throughout! Outstanding Family Area has a Wall of Windows looking out to your Patio, High Ceilings all that flows into the Gourmet Kitchen & Casual Dining Area! Gourmet Kitchen has Beautiful Tall Cabinets, Tile Backsplash, Stainless Steel Appliances, Huge Eat In Working Station Island, Gorgeous Granite Counters, Undermount Sink, Walk In Pantry & More! Primary Suite tucked away from all Guest Bedrooms Features High Ceilings, Plush Carpet, Luxurious Bathroom with His & Her Private Undermount Sinks Vanity, Granite Countertops, Soaker Tub, Seamless Glass Shower, Huge Walk In Closet! Two Guest Bedrooms tucked away & Full Bathroom W/Granite Countertops & More! Low Tax Rate! No Flooding! Close to the Bay, & along the banks of the Trinity River for all your Outdoor Water Fun & More' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Cypress Point: lot 22 /Block 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9083' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`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` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cypress Point' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097552' WHERE `Matrix_Unique_ID` = '210609152' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T15:42:27.907' ,`MLSNumber` = '45650235' ,`ListAgentFullName` = 'Evan Compean' ,`ListOfficeName` = 'Compean Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809543' ,`Longitude` = '-95.836066' ,`PhotoCount` = '34' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Tanager' ,`StreetNumber` = '2818' ,`StreetSuffix` = 'Trace' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with many upgrades built by Perry Homes and finished March 2022, with 2 year builder warranty! You\'re welcomed by an architecturally interesting entry that first has a tray ceiling, then a vaulted ceiling! Home office with French doors at entry. Kitchen, dining & living rooms have an open flow and are filled with natural light by a wall of windows with automatic shades. Spacious kitchen offers corner walk-in pantry & generous island + extra seating while the dining room has additional cabinetry & counter space. The large primary suite has plantation shutters, double doors that lead to primary bath with dual vanities, garden tub, separate glass-enclosed shower & 2 walk-in closets. Secondary bedrooms include walk-in closets. Spacious covered backyard patio has a textured & sealed coating. Other upgrades include; built-in mud room off garage which has epoxy coated floors, water softener & reverse osmosis water systems, alarm system, gutters & decked attic space for storage.' ,`Acres` = '0.1433' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422387 CANE ISLAND SECTION 27 BLK 4 LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6242' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island Sec 27' ,`TaxAmount` = '2241' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097552' WHERE `Matrix_Unique_ID` = '211617723' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T16:04:27.193' ,`MLSNumber` = '36278832' ,`ListAgentFullName` = 'Allen Frieze' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830191' ,`Longitude` = '-95.473650' ,`PhotoCount` = '31' ,`PostalCode` = '77092' ,`RoomCount` = '8' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Hewitt' ,`StreetNumber` = '5511' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just Reduced $20K! Located on a great street within Oak Forest. 4 bedroom home over 2000sf! Never flooded/Not in a flood zone. Well maintained and ready for immediate occupancy. This Backyard is perfect for entertaining! Easy access to all major freeways. See Pictures for Details! Agent has list of Improvements and Exclusions.' ,`Acres` = '0.1818' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 18 OAK FOREST SEC 17 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Forest 17 Rp' ,`TaxAmount` = '4923' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097553' WHERE `Matrix_Unique_ID` = '212385403' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T16:36:33.347' ,`MLSNumber` = '43424951' ,`ListAgentFullName` = 'Selina Ponniah' ,`ListOfficeName` = 'Homewise Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.288270' ,`Longitude` = '-95.636210' ,`PhotoCount` = '37' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '649900.00' ,`Status` = 'Active' ,`StreetName` = 'Tiffanys Ct' ,`StreetNumber` = '8808' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2685' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'UNINCORPORATED AREA GRAND LAKE ESTATES 02, BLOCK 2, LOT 1' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Waterfront' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lake Estates' ,`TaxAmount` = '5807' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097553' WHERE `Matrix_Unique_ID` = '212447458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T15:39:21.307' ,`MLSNumber` = '44759905' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.320924' ,`Longitude` = '-96.111719' ,`PhotoCount` = '14' ,`PostalCode` = '77488' ,`RoomCount` = '4' ,`ListPrice` = '264999.00' ,`Status` = 'Active' ,`StreetName` = 'N Spanish Camp' ,`StreetNumber` = '803' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Overlooks a scenic farm view that must be seen in person! This home is on 2 lots - The property is expected to be completed December - January of 2023 - ready to tour today. No HOA! \r\nThis 2 story plan with 4 bedrooms, 2 and a half baths, is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. All bedrooms are upstairs with lush carpeting in the bedrooms. 3 of the rooms have walk-in closets. Beautiful loft area at the top of the stairs. Perfect for reading or homework. Black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\n—Follow link to the builder website to see floorplan—\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1579' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WHARTON A.JACKSON BLK.52 LOT 2A' ,`LotDesciption` = 'Other' ,`LotSize` = '6878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wharton A jackson' ,`TaxAmount` = '2394' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097553' WHERE `Matrix_Unique_ID` = '212956995' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T16:24:23.770' ,`MLSNumber` = '71326885' ,`ListAgentFullName` = 'Tesia Harris' ,`ListOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145338' ,`Longitude` = '-96.366841' ,`PhotoCount` = '19' ,`PostalCode` = '77833' ,`RoomCount` = '8' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress' ,`StreetNumber` = '2708' ,`StreetSuffix` = 'Circle' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1713' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2708 Cypress Cir. in Springcreek Village! If you\'re seeking a home with a great location, this is it! Easy access to Hwy 290 and the heart of Brenham, TX! This 3 bedroom, 2.5 bath is a spacious, two story home that offers 1,713 sqft of living space. Situated in a cul-de-sac on an oversized lot. Warm, neutral & inviting color scheme throughout. Kitchen and dining area features gas stove/oven connection, granite countertops that is open to the living room. New HVAC system! Second story offers additional space for a den or game room. Primary bathroom features a large vanity, separate showing and soaking tub. The huge backyard offers a privacy fence, patio area with a pergola which ideal for soaking up the outdoors and plenty of room for the entire family unit. Don\'t miss out and schedule an appointment today!' ,`Acres` = '0.2152' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SPRINGCREEK VILLAGE S/D, LOT 36' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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` = 'Springcreek Village' ,`TaxAmount` = '4433' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097553' WHERE `Matrix_Unique_ID` = '214009516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T15:30:25.430' ,`MLSNumber` = '60725819' ,`ListAgentFullName` = 'M. Carmen Fujimoto' ,`ListOfficeName` = 'Maddie Lowe Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.382172' ,`Longitude` = '-96.620702' ,`PhotoCount` = '35' ,`PostalCode` = '77836' ,`RoomCount` = '4' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 412' ,`StreetNumber` = '2278' ,`StreetSuffix` = '' ,`City` = 'Caldwell' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Barndominium sits on 1 Acre fenced surround! As you drive in you\'ll notice the circle driveway in front of the home! The interior space has open concept Floor Plan of 2000 Sq ft! Kitchen has walk-in pantry, custom cabinets with beautiful Granite counters and Island kitchen open to the Dining Area and Family Room. The attached Workshop with 1000 sq ft of space has two Roll-up doors on each side and a 1/2 bath recently installed.' ,`Acres` = '1' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0064 AUSTIN, S.F., ACRES 1' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'N/A' ,`TaxAmount` = '4525' ,`TaxRate` = '1.78' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097554' WHERE `Matrix_Unique_ID` = '214653971' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T15:39:39.807' ,`MLSNumber` = '28751984' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = 'Aarav Sajan' ,`SellingOfficeName` = 'MIH REALTY, LLC' ,`Latitude` = '30.015063' ,`Longitude` = '-95.650220' ,`PhotoCount` = '44' ,`PostalCode` = '77429' ,`RoomCount` = '14' ,`ListPrice` = '446990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Eastern Meadowlark' ,`StreetNumber` = '15723' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You’ll love every moment spent in this incredible Lake Ridge Builders home in Telge Ranch. Situated on a spacious lot, this 3-sided brick home boasts a premium stone elevation, open ceilings, tile flooring, wrought iron spindles, faux wood blinds, a study with French doors, dual vanities in the primary suite, a sprinkler system, and a covered patio. Impress your guests in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Telge Ranch’s amenities include a recreational park and splash pad. The community is located near the Grand Parkway and Hwy 249, giving residents easy access to a variety of dining, shopping, and entertainment options. Students attend schools in the acclaimed Cypress-Fairbanks ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Telge Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.07' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097554' WHERE `Matrix_Unique_ID` = '214772242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T16:47:39.900' ,`MLSNumber` = '18949417' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.093440' ,`Longitude` = '-95.244945' ,`PhotoCount` = '20' ,`PostalCode` = '77365' ,`RoomCount` = '5' ,`ListPrice` = '292990.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn Cabin Ln' ,`StreetNumber` = '22322' ,`StreetSuffix` = '' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! Beautiful home by Century Communities! Features in this home include granite countertops in kitchen and all baths, 42-inch cabinets, whirlpool brand appliances, tankless water heater, covered patio, full sod front and back, home automation powered by Google, coach lights and more! This home is located near numerous parks; within proximity to I-69 & TX-99!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19, Block 1, Section 14' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '790' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097554' WHERE `Matrix_Unique_ID` = '214788357' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215144787','1675097554','215144787','2022-12-30T15:34:04.870','57246235','Hylara Azevedo','Pearl Realty','','','30.726217','-95.560013','15','77320','0','165000.00','Active','Old Madisonville','1002','Road','Huntsville','1','1','3','1283','Single-Family','Beautiful historic house with great potential. Close to freeways, minutes away from the Sam Houston University and right in the heart of Huntsville. Home has large window which bring in lots of natural light and a unique charm. Perfect Fixer upper, great for a first home or an investment property.','0.204','43','','','','','Other Disclosures,Sellers Disclosure','','','','Huntsville Area','Central Electric','0','SMITHER, LOT 4.1, ACRES 0.204, (AKA LT 3 FAR HILLS SEC 4)','Cleared','8886','Appraisal District','','','0','','0','','0','','','','','Composition','64 - Huntsville','SAMUEL W HOUSTON ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Smither','1337','1.8868','Public Water','1920','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215401603','1675097554','215401603','2022-12-30T15:43:57.543','9619401','Gary Moynihan','Connect Realty','','','30.850249','-95.199326','17','75862','3','185000.00','Active','Moore','226','Road','Trinity','2','0','2','880','Single-Family','The Property Encompasses Almost a Half-Acre. This 2019 Legacy Mobile Home set down on the property 2021. First time use so basically new. New Aerobic Septic System. New 3 Ton HVAC System. Upgrades include Smart Panel Siding, HVAC vents in the ceiling, Crown Molding. New Exterior Paint this year. Great weekend getaway or live full time. Subdivision has boat ramp and fishing pier. Property has been under brushed and ready for your ideas. Seller will install Decks with railing 12x10 on front and 12x8 on the back of home with an acceptable offer. All furnishings and Appliances are negotiable.','0.43','42','Legacy','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Lake Livingston Area','Central Electric','1','HAWG HEAVEN SECTION 3, LOT 75 & 76 & 74','Cleared,Subdivision Lot','18750','Appraisal District','','120','0','','0','Electric Oven','0','','','Electric Range','','Composition','59 - Groveton','GROVETON ELEMENTARY SCHOOL','GROVETON J H-H S','GROVETON J H-H S','Appointment Required,Controlled Access,Leave Business Card','Builder','1','Ranch','Hawg Heaven','','1.5582','Aerobic','2019','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215751169','1675097554','215751169','2022-12-30T16:27:00.860','6678508','Jennifer Arriaga','Daniel Real Estate','','','29.792276','-95.417132','8','77008','13','1839000.00','Active','Timbergrove','1115','Lane','Houston','4','1','5','4498','Single-Family','One-of-a-kind custom home to be built in Timbergrove Manor by award-winning Abby Custom Homes. This spacious 5-bedroom home is perfectly planned for entertaining with an open gourmet kitchen, large island, wet bar, spacious family room, covered pavilion, and large porch. The master suite is located on the first floor with a large walk-in wardrobe closet. Every secondary bedroom has a walk-in closet. Expansive game room located on the second floor with a bonus room that can be used as an exercise room, hobby room, and more. If you are interested in being involved in the selection process, now is the time! The Interior is preliminarily planned to have light-colored engineered wood floors, white cabinets, neutral colors, and transitional lighting.','0.1818','9','Abby Custom Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Wood Burning Fireplace','1','Timbergrove/Lazybrook','Central Gas,Zoned','0','LT 9 BLK 5 TIMBERGROVE MANOR','Cleared,Subdivision Lot','7920','Appraisal District','','100','1','To Be Built/Under Construction','2','Double Oven','0','','','Gas Range','','Composition,Other','27 - Houston','LOVE ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required','Builder','2','Other Style,Traditional','Timbergrove Manor','10611','2.3307','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215944217','1675097554','215944217','2022-12-30T15:46:27.080','21918250','Michael Seder','RE/MAX The Woodlands & Spring','','','30.460248','-95.558833','23','77318','5','650000.00','Active','Cozy Cove','15124','Lane','Willis','1','1','2','1401','Single-Family','Waterfront Lake House property sitting on .28 acres on the ever so popular area of Lake Conroe! Enjoy sunsets, various water sports and fishing on this beautiful lake! Some of the home highlights include a carport for two cars, covered front porch, a spacious kitchen, dining and living area, two bedrooms and one and a half baths. There\'s a boat dock with ladder for swimming and an abundance of mature shade trees.','0.285813','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Lake Conroe Area','Central Electric','0','S659001 - LAKE CONROE HEIGHTS 01, BLOCK 1, LOT 12, 25.000000','Cleared,Subdivision Lot,Water View,Waterfront','12450','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','1','Other Style','Lake Conroe Heights Sec 1','5654','1.8448','Septic Tank,Well','1975','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215948482','1675097554','215948482','2022-12-30T16:23:14.790','52656279','Alicia Grifaldo','Redfin Corporation','','','30.424699','-95.554137','28','77318','9','325000.00','Active','Valleywood','13041','Circle','Willis','2','1','4','2415','Single-Family','Prepare to fall in love with this beautiful home in a quiet community, just minutes from Lake Conroe! Situated on an oversized cul-de-sac corner lot, you will find this well-maintained home that features a freshly painted interior and new carpet. The foyer is flanked by a formal dining room to the right and soaring high ceilings. The spacious family room boasts a wood-burning fireplace and is open to the breakfast room and kitchen with granite counters and ample counter space. The first-floor primary bedroom is large and has an ensuite bathroom with double sinks, a soaking tub, and a walk-in closet. Three additional generous-sized bedrooms and a second family room / game room are located upstairs. The backyard space is HUGE with a large covered back patio, mature trees, and plenty of room to install a swimming pool, play area, or gardening. Don’t miss this opportunity to make this amazing house your home!','0.2551','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Lake Conroe Area','Central Electric','1','LAKE CONROE HILLS 01, BLOCK 6, LOT 37','Cleared,Corner,Cul-De-Sac,Subdivision Lot','11112','Appraisal District','','237','0','','2','Electric Oven,Single Oven','0','','','Electric Cooktop','','Composition','56 - Willis','W. LLOYD MEADOR ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Lake Conroe Hills','5301','2.2948','Public Sewer,Water District','2015','Appraisal District'); --> New record created successfully