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-09-29T03:17:30.023' ,`MLSNumber` = '43766675' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833729' ,`Longitude` = '-95.651140' ,`PhotoCount` = '36' ,`PostalCode` = '77084' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Scone' ,`StreetNumber` = '4127' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 3 bedroom and 2 bath home with a double car garage. Fully equipped eat-in kitchen includes updated counters, stylish tile back-splash, white cabinets. Discover a bright interior with neutral Vinyl floors and plush carpet in all the right places. Relax in your primary suite, complete with a closet, and an en-suite bathroom with double sinks. Entertain on the covered back patio, perfect for barbecues. A must see! This home has been virtually staged to illustrate its potential' ,`Acres` = '0.1446' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 5 PINE FOREST VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '346' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLFE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Forest Village' ,`TaxAmount` = '3827' ,`TaxRate` = '2.2797' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664444709' WHERE `Matrix_Unique_ID` = '208279555' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T03:17:19.773' ,`MLSNumber` = '74227697' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080285' ,`Longitude` = '-96.096840' ,`PhotoCount` = '24' ,`PostalCode` = '77445' ,`RoomCount` = '3' ,`ListPrice` = '294000.00' ,`Status` = 'Active' ,`StreetName` = '25th' ,`StreetNumber` = '2715' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 3 bedroom and 2.5 bath home with a one car garage. Enjoy cooking in this stylish kitchen with stainless appliances and a center island, great for food preparation.\r\nLighting, ceiling fans, and fixtures flow throughout.\r\nPrimary bathroom features a separate tub and shower, dual sinks and a walk-in closet.\r\nLush green landscape surrounds this beautiful house.\r\nDon\'t miss this incredible opportunity. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.3099' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S519000 HEMPSTEAD BLK 702 LOT 6 & 7 & N/2 LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hempstead' ,`TaxAmount` = '4591' ,`TaxRate` = '2.4184' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664444709' WHERE `Matrix_Unique_ID` = '209460223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T02:35:56.940' ,`MLSNumber` = '49034795' ,`ListAgentFullName` = 'Rhonda Larkins' ,`ListOfficeName` = 'The Virtual Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361426' ,`Longitude` = '-95.620820' ,`PhotoCount` = '24' ,`PostalCode` = '77316' ,`RoomCount` = '2' ,`ListPrice` = '169999.00' ,`Status` = 'Active' ,`StreetName` = 'Kempwood' ,`StreetNumber` = '16851' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further! This beauty is yours! This lovely 2 story 2 bd 2ba updated home awaits its new owner. Open floor plan with plenty of light. Beautiful kitchen with granite countertops and stainless steel appliances. Spacious walk in pantry. Closed in laundry area right off the kitchen. Half bath on the main floor. 2 spacious bedrooms on 2nd floor with a full bath. Nice covered porch at the back of the home with attached storage shed. Spacious corner lot with dual cemented parking area in front. Within minutes of the beautiful Lake Conroe. Close to schools, shopping, fishing, restaurants, and lake activities (boating, jet skiing, canoeing, swimming, etc.). 25 minutes from The Woodlands. Your search stops here!' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE VILLAGE, BLOCK 18, LOT 34' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Village' ,`TaxAmount` = '146' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664444709' WHERE `Matrix_Unique_ID` = '210059985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T03:17:51.397' ,`MLSNumber` = '53575518' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.969405' ,`Longitude` = '-95.239169' ,`PhotoCount` = '35' ,`PostalCode` = '77396' ,`RoomCount` = '4' ,`ListPrice` = '321000.00' ,`Status` = 'Active' ,`StreetName` = 'Fort Baldy' ,`StreetNumber` = '2415' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 4 bedroom and 2.5 bath home with a 2 car garage. The kitchen boasts generous counter space, making cooking and entertaining a delight. Discover a bright interior with neutral tile floors and plush carpet in all the right places. The main bedroom boasts a private ensuite. Other bedrooms offer plush carpet, ceiling fans, and sizable closets. Lush green landscape surrounds this beautiful house. Don\'t wait! Make this beautiful home yours today.This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1194' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 WOODLAND PINES SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5201' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '413' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIVER PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Pines Sec 10' ,`TaxAmount` = '7787' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664444709' WHERE `Matrix_Unique_ID` = '210092163' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T03:43:43.563' ,`MLSNumber` = '92082513' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.125704' ,`Longitude` = '-95.239317' ,`PhotoCount` = '30' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '334000.00' ,`Status` = 'Active' ,`StreetName` = 'Pheasant Bend' ,`StreetNumber` = '22006' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming home now on the market! Enjoy cooking in this stylish kitchen with stainless appliances and a center island, great for food preparation. Lighting, ceiling fans, and fixture flow throughout. Primary bathroom features a separate tub and shower, dual sinks and a walk-in closet. Entertain on the covered back patio, perfect for barbecues. Hurry, this won’t last long!\r\n\r\nThis home has been virtually staged to illustrate its potential' ,`Acres` = '0.1465' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S941207 - VALLEY RANCH 07, BLOCK 1, LOT 40' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Valley Ranch 07' ,`TaxAmount` = '7345' ,`TaxRate` = '3.2331' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664444709' WHERE `Matrix_Unique_ID` = '210196980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T03:18:01.630' ,`MLSNumber` = '10022320' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722036' ,`Longitude` = '-95.850283' ,`PhotoCount` = '35' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '438000.00' ,`Status` = 'Active' ,`StreetName` = 'Gracefield' ,`StreetNumber` = '27723' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 4 bedroom, 3 full and 1 half bathroom home with a 2 car garage. Enjoy preparing meals in this impressive kitchen equipped with ample cabinets, breakfast bar, generous counter space, stainless appliances and stylish tile backsplash. Flow into the living room featuring a cozy fireplace, perfect for entertaining. Relax in your primary suite, complete with a spacious closet and an en-suite bathroom with double sinks. Relax with your favorite drink in the fenced in backyard with lush grass. Hurry, this won’t last long! This home has been virtually staged to illustrate its potential' ,`Acres` = '0.2231' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CHURCHILL FARMS SEC 9, BLOCK 2, LOT 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9719' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '841' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Churchill Farms Sec 9' ,`TaxAmount` = '8404' ,`TaxRate` = '2.8745' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664444710' WHERE `Matrix_Unique_ID` = '210483643' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T03:17:40.087' ,`MLSNumber` = '25602974' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.520717' ,`Longitude` = '-95.427688' ,`PhotoCount` = '35' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '358000.00' ,`Status` = 'Active' ,`StreetName` = 'Spruce Orchard' ,`StreetNumber` = '13314' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom, 2 full and 1 half bathroom stunner in Rosharon! Fully equipped eat-in kitchen includes stylish ample cabinets, updated counters, stainless steel appliances, tiled-backsplash, center island and a breakfast bar. Lighting, ceiling fans, and fixtures flow in all the right places. The primary bedroom features plush carpet, a walk-in closet, and a private bathroom with dual sinks. Lush green landscape surrounds this beautiful house. A must see!\r\n\r\nThis home has been virtually staged to illustrate its potential' ,`Acres` = '0.1601' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAUREL HEIGHTS AT SAVANNAH SEC 8 (A0302 HT&BRR) BLK 4 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6973' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Laurel Heights At Savannah Sec' ,`TaxAmount` = '8775' ,`TaxRate` = '3.3694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664444710' WHERE `Matrix_Unique_ID` = '210484336' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T02:40:05.710' ,`MLSNumber` = '97837605' ,`ListAgentFullName` = 'Felisha Tubbs' ,`ListOfficeName` = 'Jammer Realty' ,`SellingAgentFullName` = 'Oscar Casas' ,`SellingOfficeName` = 'Near Town Properties' ,`Latitude` = '29.860784' ,`Longitude` = '-95.309029' ,`PhotoCount` = '14' ,`PostalCode` = '77016' ,`RoomCount` = '5' ,`ListPrice` = '147000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Onslow' ,`StreetNumber` = '10317' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED on this Great Starter Home or Investor Special, this Cute and Cozy home is nestled in an Established Neighborhood, this 3-Bedroom (Garage Converted into the 3rd Bedroom) & 1-Full Bath offers an Over-Sized Lot, Uncovered Patio slab on an \"Oversized\" Backyard. This Home has unlimited potential to expand or renovate, it does Need some TLC. This Home includes an Inviting Living Area, a Cute Kitchen with a Recent Gas Stove, Original Wood Flooring underneath the carpet and a Cute Dining area. Schedule a Private Showing Today!' ,`Acres` = '0.2173' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 303 BLK 10 FONTAINE PLACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fontaine Place Sec 03' ,`TaxAmount` = '1566' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664444710' WHERE `Matrix_Unique_ID` = '212199259' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T02:02:43.567' ,`MLSNumber` = '29617864' ,`ListAgentFullName` = 'Kashmir Cortave' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572349' ,`Longitude` = '-95.339317' ,`PhotoCount` = '17' ,`PostalCode` = '77581' ,`RoomCount` = '4' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Granite Pass' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Granite Pass Dr. a hidden subdivion in the desired city of Pearland. This 4 bedroom 2 bathroom home has an open concept. Floor to ceiling floor windows in the living space allow the natural lighting to illuminate the home. The primary bedroom in tucked away at the back of the home with a large garden soaking tub, perfect for relaxation. This Plantation built home has soaring ceilings, engineered hardwood floors, and a flex room at the front of the home which makes a perfect home office area.' ,`Acres` = '0.16' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON TERRACE SEC 6 (A0505 H T & B) BLK 2 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Avalon Terrace Sec 6 A0505 H' ,`TaxAmount` = '8422' ,`TaxRate` = '2.6537' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664444710' WHERE `Matrix_Unique_ID` = '212707827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T03:18:44.480' ,`MLSNumber` = '64827733' ,`ListAgentFullName` = 'Eduardo Polack' ,`ListOfficeName` = 'Elite Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975222' ,`Longitude` = '-95.402738' ,`PhotoCount` = '13' ,`PostalCode` = '77073' ,`RoomCount` = '8' ,`ListPrice` = '233000.00' ,`Status` = 'Active' ,`StreetName` = 'Crosshill' ,`StreetNumber` = '19307' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Single Family Cottage Home built by KB Home 5 years ago. Downstairs Features: Foyer, Kitchen with Nice Cabinets, Fridge included and Pantry, Breakfast Area, Living Room, Guest Bathroom, Closet area, 2 Car Garage with Garage Door Opener and additional storage area (Attached), Fenced Patio. Upstairs Features : Principal Bedroom with excellent Walking Closet Space, Principal Bathroom with counter Space and Extra closet, Other two Bedrooms with closets share the Second Bathroom (not Connected) , Game Room area and Utility Room with Full Size Washer and Dryer set included, Cold A/C System with Digital Thermostat and Extra Ceiling Fans in all Bedrooms and Living Room. Storage area in attic Space too.' ,`Acres` = '0.0603' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 2 REMINGTON RANCH SEC 27' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2628' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HOYLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Ranch Sec 27' ,`TaxAmount` = '4691' ,`TaxRate` = '2.8804' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664444710' WHERE `Matrix_Unique_ID` = '212714918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-29T03:43:47.463' ,`MLSNumber` = '23931170' ,`ListAgentFullName` = 'Bonnie Porter' ,`ListOfficeName` = 'Dynamic Home Pros, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.307189' ,`Longitude` = '-94.778767' ,`PhotoCount` = '35' ,`PostalCode` = '77550' ,`RoomCount` = '9' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Church' ,`StreetNumber` = '1013' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your gorgeous Coastal Oasis! Beautiful hardwood floors, open concept, huge kitchen island with gorgeous quartz countertops. 4 Large bedrooms and an additional bunk room. This amazing historical Victorian beauty boast a spacious primary bedroom with a luxurious primary bath retreat and private balcony for those morning cups of coffee or evening sips of wine with a good book. Primary bath includes and free standing soaker tub, rainfall shower and large vanity. Private gated backyard with a large deck to entertain and enjoy the sea breeze. Automatic gate with ally access and private off street parking. Schedule your private tour today!' ,`Acres` = '0.0885' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR E 1/2 OF LOT 4 & W 10-8.5 FT OF LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3855' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '5388' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664444711' WHERE `Matrix_Unique_ID` = '212852176' --> 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','213051990','1664444711','213051990','2022-09-29T03:48:25.640','66331975','Stephanie Sykes','RE/MAX Cinco Ranch','','','30.132638','-95.456113','21','77380','8','395000.00','Active','Many Oak','25510','Drive','Spring','2','0','4','2252','Single-Family','Welcome to this charming one story, ranch-style beauty located in the heart of Spring. Unlike many one stories, this home impresses with four bedrooms, making it a possibility to have a designated home office. The kitchen and breakfast room both open up to the generously sized living room with views of the back patio and sparkling pool all around. Step outside to your backyard oasis complete with a covered patio w/ outdoor fan, TV mount, and gas hookups making it a perfect place to entertain family and friends year round. Cool off and take a dip in the gorgeous pool and spa or let the family play in the multiple turfed areas- great for a low maintenance mindset! Schedule your private showing today, this gem won\'t last long!','0.2109','15','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','1','Spring Northeast','Central Gas,Zoned','1','VICKSBURG, BLOCK 3, LOT 25','Subdivision Lot','9186','Survey','','400','0','','2','Gas Oven','1','Heated,In Ground','','Gas Range','','Composition','11 - Conroe','LAMAR ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch,Traditional','Vicksburg','4960','2.0087','Water District','1974','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','213084773','1664444711','213084773','2022-09-29T02:07:43.910','32129164','Jeri Maito','C. Morton Properties, LLC','','','30.159517','-95.494294','40','77381','7','475000.00','Active','Prism Cove','19','Place','Spring','2','0','2','2404','Single-Family','Beautiful patio home that\'s been well cared for! Agent\'s this one won\'t last long!! Please leave business card, provide feedback, turn off all lights, and lock deadbolt back. Do not lock the handle lock. The lockbox is lockbox is located on the grill near the kitchen door, which is past the entry door. It is hard to turn you will have to jiggle the door to get it to lock back. Refrigerator is an option. Not all window coverings will stay, but blinds and shutters will.','0.1551','15','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','The Woodlands','Central Gas','0','WDLNDS VIL PANTHER CR 34, BLOCK 1, LOT 31','Cul-De-Sac,In Golf Course Community','6758','Appraisal District','','','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','SALLY RIDE ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Right Side','Appraisal District','1','Traditional','Wdlnds Village Panther','6842','2.0501','Water District','1996','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','213085695','1664444711','213085695','2022-09-29T02:59:56.880','29686874','Rhonda Trevino','Come Home Realty','','','30.058137','-95.621361','50','77377','7','575000.00','Active','La Fouche','26010','Drive','Tomball','2','1','4','2558','Single-Family','DID YOU HEAR THAT??? IT\'S THE SOUND OF OPPORTUNITY KNOCKING!!-Luxury hooked up with Country resulting in this Captivating Elegant Beauty that you could call HOME. Be prepared to be wowed by the home\'s stunning Dome ceiling in the Living Rm. upon entry, also featuring a cast stone fireplace and open view of the Kitchen. Front Formal dining or Office space to the left of entry; All tile flooring in social areas/ wood flooring in bedrooms; Cast Stone fireplace; Enormous Island in Kitchen; Outdoor kitchen; expanded back porch with a custom cedar bar; Kitchen open to the Living area; EXTRA parking in the extended driveway; Covered RV Storage in back; All this with 3/4 ACRE LOT! Come experience Tranquil Restful Living in the Country yet still Close enough to all the comforts. Set up your private showing today!','0.75','35','','','Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gas Connections','1','Tomball Southwest','Propane','1','LT 74 BOUDREAUX ESTATES SEC 3 U/R ABST 722 A SENECHAL','Subdivision Lot,Wooded','32670','Appraisal District','','115','0','','2','Gas Oven','0','','','Gas Range','','Composition','53 - Tomball','ROSEHILL ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Ranch,Traditional','Boudreaux Estates','8895','2.0872','Aerobic,Public Water,Septic Tank','2007','Appraisal District'); --> New record created successfully