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-04T19:03:25.823' ,`MLSNumber` = '50688969' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = 'Patrick Kelley' ,`SellingOfficeName` = 'Shaw Real Estate' ,`Latitude` = '29.818950' ,`Longitude` = '-94.819975' ,`PhotoCount` = '19' ,`PostalCode` = '77523' ,`RoomCount` = '7' ,`ListPrice` = '319990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14915' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Forest Plan, with their NEWEST Modern design offers 4 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" upgraded gray cabinets, stainless steel oven, dishwasher and microwave and a large breakfast bar. As you walk into the Primary Bathroom, you will see dual sinks, separate shower, garden tub and a large walk-in closet! Step outside to enjoy a large Covered Patio with family and friends! (All information provided by builder). Located in Baytown\'s newest DR Horton Community known as Raintree this gorgeous development located off FM 565 and zoned to the highly-acclaimed Barbers Hill schools! And check out that TAX RATE! Schedule your appointment today!!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot 25 Section 3 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706797' WHERE `Matrix_Unique_ID` = '209545623' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T18:56:28.547' ,`MLSNumber` = '2312161' ,`ListAgentFullName` = 'Lola Duhon' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.380949' ,`Longitude` = '-94.768064' ,`PhotoCount` = '24' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '109900.00' ,`Status` = 'Active' ,`StreetName` = 'Overton' ,`StreetNumber` = '1223' ,`StreetSuffix` = 'Avenue' ,`City` = 'Port Bolivar' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quaint 2 bedroom 1 bath property on a corner lot with water view to Galveston ship channel. Near boat launch and Bolivar Ferry. This would be a great fishing camp no restrictions and attached one car garage and one car port at the back of property. This is your chance to be on Bolivar Peninsula at an affordable price.' ,`Acres` = '0.1446' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 162 S PARR LOT 12 & NE 15 FT OF LOT 11 BL 316 PORT BOLI' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Port Bolivar Townsite' ,`TaxAmount` = '384' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706797' WHERE `Matrix_Unique_ID` = '210562743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T19:52:59.403' ,`MLSNumber` = '21318098' ,`ListAgentFullName` = 'Angela Chaney' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857315' ,`Longitude` = '-95.680876' ,`PhotoCount` = '20' ,`PostalCode` = '77084' ,`RoomCount` = '3' ,`ListPrice` = '283000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Cedars' ,`StreetNumber` = '18183' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One-Story All Brick Home zoned to the highly acclaimed Cy-Fair School District! This home has an open & flexible floorplan, w/ lots of windows, no carpet & a dbl sided fireplace in the living area. The kitchen has granite counters w/ tile backsplash, an island & lots of cabinet space. The primary suite features it’s very own private room that can be used as an office, workout room, nursery, or lounge area. The primary bath has granite countertops, a separate shower & jacuzzi tub, vessel sinks & a large walk in closet. A/C was replaced 2021, water heater replaced 2019, & roof replaced 2010. All this AND the home is located in the Windsong subdivision that offers a clubhouse that residents can use for events, a massive pool that offers swim lessons, aerobic classes & weekly practices for the Windsong Wavebreakers swim team, a volleyball court, tennis courts, & an open field for large outdoor festivities. The home has a low tax rate & is just mins from TX-6, TX-99, I-10, & FM-529!' ,`Acres` = '0.1446' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 15 WINDSONG SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windsong Sec 03' ,`TaxAmount` = '4807' ,`TaxRate` = '2.5618' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706797' WHERE `Matrix_Unique_ID` = '211564695' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T18:40:16.380' ,`MLSNumber` = '27021453' ,`ListAgentFullName` = 'Tanya Warner' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928034' ,`Longitude` = '-95.283174' ,`PhotoCount` = '23' ,`PostalCode` = '77396' ,`RoomCount` = '9' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Dewberry Shores' ,`StreetNumber` = '7007' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom, 2 full and 1/2 bath home in prestigious Fall Creek! This beautiful home sits on oversized corner lot with plenty of space to create memories. As you enter your home, gorgeous engineered floors greet you! There is a spacious dining room which flows into the open family room with vaulted ceilings, custom fireplace mantel and gas fireplace. Your chefs kitchen is equipped with a gas stove, expansive island, new porcelain mosaic tile backsplash and exquisite cabinetry! The second story invites family time with a generous gameroom/media area, three bedrooms and bathroom. Ceiling fans in every bedroom! Enjoy your private fenced backyard complete with a covered patio! NEW roof 2021 with warranty, NEW sprinkler heads & controller 2022.' ,`Acres` = '0.1689' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 FALL CREEK SEC 34' ,`LotDesciption` = 'Corner' ,`LotSize` = '7357' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FALL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Creek' ,`TaxAmount` = '8438' ,`TaxRate` = '2.9973' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706797' WHERE `Matrix_Unique_ID` = '211878395' --> 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','212083855','1663706798','212083855','2022-09-04T19:20:43.883','92320547','Jennifer Duhe','Bailes Real Estate','','','28.990728','-95.582721','14','77422','3','215000.00','Active','County Road 510j','3032','','Brazoria','1','0','3','1248','Single-Family','Welcome to country living close to the amenities of a small town. This home is situated on a large lot ready for a new family. This home is perfect for first time home buyers with three bedrooms and one updated bathroom this home is sure to please any new buyer. sellers have Recently replaced the water heater and electrical panel. Don\'t wait call for your private showing today.','0.4867','5','','','','','Sellers Disclosure','','','','West of the Brazos','Central Electric','0','HOLIDAY SHORES (A0092 JNO MCNELL), BLOCK 24, LOT 22-23-24 SE','Cleared','21201','Appraisal District','','','0','','2','','0','','','','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Holiday Shores','2382','1.6567','Other Water/Sewer','1978','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','212103539','1663706798','212103539','2022-09-04T19:33:03.347','44798591','Ana De Los Reyes','Realty ONE Group, Experience','','','30.185769','-95.544074','50','77382','3','1399000.00','Active','Angelique','75','Way','The Woodlands','3','1','3','2951','Single-Family','Beautiful Hard to find 1 story Partners in Building custom home in the prestigious, gated Carlton Woods (Nicklaus). an open floor plan, and light decor are just some of the highlights of this 3 bedroom/3.5 bath house. chefs kitchen includes high-end stainless appliances, a large island a breakfast area and french doors to a private study/ office that leads into a one of the three car garage , and can also easily be converted into a gym, shop,yoga room or even a media room!\r\n Spacious family room with a gas log fireplace The private backyard has a covered patio\r\nlarge primary room with a beautiful bathroom and a very spacious walking closet.\r\nsecondary and third room each with its own bathroom.','0.1921','15','Partners in Building','','Electric Dryer Connections,Gas Dryer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','The Woodlands','Central Electric','1','WDLNDS VIL OF CARLTON WOODS 06, BLOCK 1, LOT 19','Cul-De-Sac','8367','Other','','3950','1','Never Lived In','3','Gas Oven','0','','','Electric Cooktop,Electric Range','','Other','11 - Conroe','TOUGH ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Lockbox Front','Builder','1','Contemporary/Modern','The Woodlands Carlton Woods','2464','2.1816','Water District','2022','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','212169946','1663706798','212169946','2022-09-04T18:07:31.580','8793250','Jonathan McNabb','Nest Ahead','','','29.864305','-95.282215','6','77016','4','239990.00','Active','Red Orchid','10026','Drive','Houston','2','0','3','1200','Single-Family','Brand new built BEAUTIFUL home! This home has a lot of extra space! The kitchen features granite countertops, brand-new stainless-steel appliances, and a spacious pantry. The home has a huge backyard great for entertaining. Come and schedule your tour!','','2','Starlight Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Northeast Houston','Central Electric','1','Wayside Village Section 6 Block 2 Lot 40','Subdivision Lot','','','','450','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Builder','1','Traditional','Wayside Village','','3.13','Water District','2022','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','212171553','1663706798','212171553','2022-09-04T19:41:19.747','45516015','Susan Heflin','eXp Realty, LLC','','','29.423129','-95.116714','15','77517','12','700000.00','Active','Cemetery','1020','Road','Santa Fe','3','0','4','2472','Single-Family','Country living at its finest, not to far out but far enough to feel the country breeze on these hot summer nights! You must see this tree lined drive, that leads to a stunning 4 bedroom 3 bath home that sits on 5.264 acres with a 1920 sq ft barn and a sparkling pool for family entertaining. Beautiful updates with modern colors and teakwood accent areas throughout the home. Want to relax after a long day at the office? This home features a beautiful white claw tub with tons of natural lighting in the master suite that is calling your name. A great book, on a cold winters night, in front of the fireplace in the master suite? Just say YES! Your little piece of heaven on earth is waiting for you!','5.264','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','2','Santa Fe','Central Electric','0','ABST 16 PAGE 1 PT OF LOT 23 (23-1) C W L\'HOMMEDIEU SURVEY SU','Cleared','229300','Appraisal District','','','0','','2','Electric Oven','1','Gunite,In Ground','','Electric Range','','Composition','45 - Santa Fe','ROY J. WOLLAM ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Lhommedieu Sub','7631','2.0881','Septic Tank,Well','1988','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','212179894','1663706798','212179894','2022-09-04T18:18:00.970','48328493','Pierre Guitard','Haussmann International Realty','','','29.729266','-95.470315','22','77056','6','474900.00','Active','Schumacher','5336','Lane','Houston','2','0','3','1432','Single-Family','Never flooded per seller. Brand new roof. new stone siding. New kitchen countertop to be installed. new front yard grass. Opportunity to build dream home or remodel in the heart of the Galleria.\r\nNo back neighbor, very high new back wooden fence...good privacy!\r\nCall Pierre to schedule a private showing.','0.1492','22','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','Gaslog Fireplace','1','Galleria','Central Gas','0','LT 10 BLK 5 LARCHMONT SEC 1','Subdivision Lot','6500','Appraisal District','','70','0','','2','Electric Oven','0','','','','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Appraisal District','1','Ranch,Traditional','Larchmont Sec 01','7774','2.3307','Public Sewer,Public Water','1954','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','212181151','1663706798','212181151','2022-09-04T18:01:17.900','48846190','Jonathan McNabb','Nest Ahead','','','29.864305','-95.282215','7','77016','5','274990.00','Active','Red Orchid','10002','Drive','Houston','2','1','4','2121','Single-Family','Brand new built BEAUTIFUL home! This home has a lot of extra space! You will enjoy a loft space on the second floor. The kitchen features granite countertops, brand-new stainless-steel appliances, and a spacious pantry. The home has a huge backyard great for entertaining. Come and schedule your tour!','','2','Starlight Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Northeast Houston','Central Electric','1','Wayside Village Section 6 Block 2 Lot 45','Subdivision Lot','','','','450','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Builder','2','Traditional','Wayside Village','','3.13','Water District','2022','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','212181283','1663706798','212181283','2022-09-04T18:04:18.533','56637720','Jonathan McNabb','Nest Ahead','','','29.864305','-95.282215','6','77016','5','286990.00','Active','Red Orchid','10006','Drive','Houston','3','0','4','2260','Single-Family','Brand new built BEAUTIFUL home! This home has a lot of extra space! You will enjoy a loft space on the second floor. The kitchen features granite countertops, brand-new stainless-steel appliances, and a spacious pantry. The home has a huge backyard great for entertaining. Come and schedule your tour!','','2','Starlight Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Northeast Houston','Central Electric','1','Wayside Village Section 6 Block 2 Lot 46','Subdivision Lot','','','','450','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Builder','2','Traditional','Wayside Village','','3.13','Water District','2022','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','212181919','1663706798','212181919','2022-09-04T19:25:08.037','3585184','Brooke Daniel','Realty Austin, LLC','','','31.059012','-97.379534','35','76502','3','315000.00','Active','Ponderosa','4505','Lane','Temple','2','1','3','1958','Single-Family','Spacious two-story home on a corner lot with beautiful shade trees! Walk past the covered front porch sitting area, and enter the home to see the huge family room with a fireplace and open to the dining area. The kitchen has been updated with beautiful granite countertops and under mounted stainless steel sink. All living areas have large windows which provide great natural light. The primary suite bathroom and closet have been recently updated. Floor-to-ceiling built-in bookshelves have been added to the living room. There is also a covered back patio, accessible through the family room. The back courtyard has a wooden deck, privacy fencing, and storage shed. This lovely home is located in a quiet neighborhood on a cul-de-sac. The home also has garage access via a back alleyway.','0.1922','83','','','','','Sellers Disclosure','','','1','','Central Electric','0','CANYON CREEK PHASE II, BLOCK 007, LOT 0056, (78.7 \'X 111.245','Corner','8371','Appraisal District','','','0','','2','','0','','','','','Composition','965 - Temple','THORNTON ELEMENTARY SCHOOL (TEMPLE)','TEMPLE HIGH SCHOOL','BONHAM MIDDLE SCHOOL (TEMPLE)','Lockbox Front,Supra Keybox,Vacant/Unoccupied','Seller','2','Ranch','Canyon Creek Ph II','6479','2.5132','Public Sewer,Public Water','1983','Appraisal District'); --> New record created successfully