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` = '2023-01-21T22:18:11.817' ,`MLSNumber` = '40116613' ,`ListAgentFullName` = 'Robert Findley' ,`ListOfficeName` = 'Realty Insight' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.324300' ,`Longitude` = '-94.955391' ,`PhotoCount` = '22' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2251' ,`StreetNumber` = '334' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this Beautiful 3/2 manufactured home in the sought-after Tarkington ISD on a lovely cleared 1.25 acres tract of land. This area is growing fast and is now even closer to Houston with the newest section of the Grand Parkway completed from Hwy 59 in New Caney to IH 10 in Mont Belvieu. Items to be constructed include Energy star / Eco Bee thermostat/ kitchen backsplash, recessed lighting, custom deck, landscaping rocks, and plants around home.' ,`Acres` = '1.25' ,`Area` = '52' ,`BuilderName` = 'CMH Homes, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000089 THOMAS NEWMAN, TRACT 211, ACRES 1.25' ,`LotDesciption` = 'Cleared' ,`LotSize` = '54450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Thomas Newman' ,`TaxAmount` = '785' ,`TaxRate` = '1.5226' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217286' WHERE `Matrix_Unique_ID` = '213463811' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T21:15:05.803' ,`MLSNumber` = '41966730' ,`ListAgentFullName` = 'Deb Stirling' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.431657' ,`Longitude` = '-95.638016' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '11' ,`ListPrice` = '644000.00' ,`Status` = 'Active' ,`StreetName` = 'Camden Hills' ,`StreetNumber` = '293' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION. This stunning Custom English inspired home sits on one of the most breathtaking lots in the highly sought after gated community of Bentwater. The bright and open living space features a true chefs kitchen designed around the professional grade Bertazzoni appliances and gorgeous modern cabinetry and countertops. You will have amazing views of the park and pond from so many rooms with high ceilings and huge windows throughout. Floor plan is super functional with private study, game room and Media room. This immaculate home is move in ready with almost $60,000 in recent updates including Roof, wood floors and water heater this year alone. Bentwater is Houstons premier waterfront golf community with 54-holes of championship golf, a 10,000 square foot Fitness Center, Day Spa, Racquet Club, Guest Villas, Yacht Club, Marina and the highly acclaimed, ultra private Grand Pines Golf Club. Schedule a showing today, you will not be disappointed.' ,`Acres` = '0.1742' ,`Area` = '39' ,`BuilderName` = 'Royal Texan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 33, BLOCK 2, LOT 11' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '7589' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Bentwater 33' ,`TaxAmount` = '9312' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217286' WHERE `Matrix_Unique_ID` = '213628609' --> 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','215165020','1675217286','215165020','2023-01-21T22:52:15.400','87535264','Beverly Bradley','Weekley Homes','','','29.476540','-95.506271','38','77459','6','420406.00','Active','Pleasant View','10702','Drive','Missouri City','2','0','3','1876','Single-Family','Brilliant comforts and timeless beauty combine to create the dynamic Brenton lifestyle home plan. Your spacious Owner’s Retreat awaits your personal design flair. Pamper yourself and explore your wardrobe potential in the luxurious Owner’s Bath and walk-in closet. Each spare bedroom presents a uniquely appealing place to thrive and personalize. Your open floor plan provides a stylish variety of dining, home office, and living spaces. The eat-in kitchen includes ample room devoted to meal prep, dining, storage, and presentation. Covered porches are located in the front and back yards, offering plenty of outdoor relaxation opportunities. This exquisite new home plan is built around our LifeDesign? principles, making it easy for you to get the most out of each day.','','38','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections','','Mud','1','','','Sienna Area','Central Electric,Central Gas','1','Lot 21 Block 2','Subdivision Lot','5000','Appraisal District','','1254','1','To Be Built/Under Construction','2','Convection Oven,Electric Oven,Gas Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','LEONETTI ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Sienna','','3.19','Water District','','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','215403092','1675217286','215403092','2023-01-21T21:39:24.737','87601698','Benjamin Chacon','Realty Associates','','','29.166431','-95.628663','36','77486','11','324900.00','Active','Canterbury','253','Drive','West Columbia','3','0','4','1982','Single-Family','Welcome to this NEW CONSTRUCTION! This beautiful 4 bedroom 3 full bath home with vaulted ceilings is located in the beautiful Columbia Lakes subdivision. As you enter the home you will see the 9 ft ceiling along with vaulted ceiling in the living room area and kitchen. The formal dining on the right side with open concept to kitchen area. The floors are tile and counter tops are quartz. Stainless steel appliances. As you enter the primary bedroom you will see the bathroom with double sink and separate garden tub with shower. As you exit the house you will see over extended patio area with enough yard for family gathering. Welcome home!','0.2152','5','SC General Contracto','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','1','','','West of the Brazos','Central Gas','1','COLUMBIA LAKES SEC 4 (A0133 M VARNER) BLK 43 LOT 31','Subdivision Lot','9374','Appraisal District','','20','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Builder','1','Contemporary/Modern','Columbia Lakes Sec 1-2-3-4-5','774','2.0633','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','215569330','1675217286','215569330','2023-01-21T21:25:44.013','31469145','Gina Arriondo','Keller Williams Realty - Memor','','','30.211357','-95.345406','14','77302','6','448000.00','Active','Bright Berry','14952','Drive','Conroe','2','0','3','2189','Single-Family','Gorgeous 1-story, oversize lot, Perry Home in Artavia(Conroe), adjacent to The Woodlands. 1st purchased in September 2022! 3 BR, 2 BTH. Large Home office with French doors and 12-foot tray ceiling. Bistro style, Open kitchen featuring huge center island, smart oven, remote hood vent, and corner walk-in pantry! Dining area open to family room with wall of windows. Large primary suite includes bedroom with wall of windows (blinds installed after photos). Double doors lead to primary bath with dual vanities, garden tub, separate glass-enclosed shower and two walk in closets. Secondary bedrooms feature walk in closets. Extended covered patio with gas hookup, outside tv connection & plug. Mud room off kitchen leads to the two-car garage. Homes features a Nest Thermostat and Nest Doorbell with video & audio capabilities. This is a Smart Home with garage, home lights, and Front door remote capability via apps! Within minutes of major thoroughfares, shopping and entertainment.','0.234','19','','','','','Sellers Disclosure','1','','0','Spring Northeast','Central Electric,Zoned','1','S216907 - ARTAVIA 07, BLOCK 4, LOT 4','Subdivision Lot','10191','Other','','995','0','','2','Electric Oven','0','','','','','Composition','11 - Conroe','SAN JACINTO ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Builder','1','Traditional','Artavia 07','1607','3.1988','Other Water/Sewer','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','215639007','1675217287','215639007','2023-01-21T21:50:23.210','84193440','Vivian Jones','JLA Realty','','','29.939850','-95.201694','19','77346','5','345000.00','Active','Misty Summer','15122','Lane','Humble','2','1','4','2429','Single-Family','Please come out and view this gorgeous four bedroom two and a half bath two car garage home. This home is located conveniently near Beltway 8, I10, and I59/I69. The home has so much character with custom walls and fresh new paint throughout the home you will also find granite countertops in the kitchen and bathrooms. Once you view the inside you must see the large backyard especially if you have outside pets. Don\'t miss out on this beautiful home. Schedule your tour today.','0.1382','1','','','','','Mud,Sellers Disclosure','','','','Summerwood/Lakeshore','Central Gas','1','LT 76 BLK 1 SUNSET RIDGE SEC 8','Subdivision Lot','6020','Appraisal District','','500','0','','2','','0','','','','','Composition','29 - Humble','RIDGE CREEK ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Contemporary/Modern','Sunset Rdg Sec 8','9652','3.0673','Public Sewer,Public Water','2019','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','216443861','1675217287','216443861','2023-01-21T21:19:51.387','31764275','Guillermo Parra','Realty Associates','','','30.047411','-95.435830','38','77388','10','349900.00','Active','Enchanted Oaks','19314','Drive','Spring','3','0','4','2654','Single-Family','','0.27','13','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Spring/Klein','Central Gas','1','LT 12 BLK 7 ENCHANTED OAKS SEC 2','Subdivision Lot','11760','Appraisal District','','250','0','','2','Double Oven','1','Fiberglass','','Electric Cooktop','','Composition','32 - Klein','LEMM ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','STRACK INTERMEDIATE SCHOOL','Appointment Required,Lockbox Back,Temporarily No Showings,Vacant/Unoccupied','Appraisal District','2','Traditional','Enchanted Oaks Sec 02','5763','2.484','Water District','1969','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','216607236','1675217287','216607236','2023-01-21T22:21:45.390','89667126','Jennie Green-Prats','1st Choice Realty','','','28.957984','-95.289056','13','77541','4','365000.00','Active','Shark','314','Lane','Surfside Beach','2','0','2','2080','Single-Family','Canal side home with 2 upper decks on the home. Open concept inside with a bedroom and bathroom on each side of the open living area. Home is located in a beach front family friendly community. The canal in front of the home has access to the Gulf Of Mexico via the Intercoastal Waterway. The downstairs has 2 rental units, both 1/1. One unit rents for $800 and the other rents for $1400/month.','0.1263','5','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','Surfside','Central Electric','0','SURFSIDE SHORES (A0051 F J CALVIT DIV 2 (B C I C))(SURFSIDE)','Subdivision Lot,Waterfront','5502','Appraisal District','','','0','','0','Convection Oven,Gas Oven','0','','','Gas Range','','Composition','7 - Brazosport','FLEMING ELEMENTARY SCHOOL (BRAZOSPORT)','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card','Appraisal District','2','Other Style','SURFSIDE SHORES','7499','2.2043','Public Sewer,Public Water','1999','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','216635589','1675217287','216635589','2023-01-21T22:28:05.690','29844884','Jesus Lopez','Keller Williams Signature','','','29.619801','-95.343464','21','77048','8','289000.00','Active','Lincolnshire','4623','Road','Houston','2','0','3','1467','Single-Family','Welcome to this move-in fully remodeled house!! Easy access to the Beltway 8, 45, 288, Downtown, and the Medical Center! Excellent Location! This single-story home with 3 beds and 2 baths features an open concept with a large living room. New roof. Recently installed AC, and water heater. In the kitchen, you will find custom cabinets, granite countertop, glass backsplash, stainless steel sink. The house has gate access to huge backyard. Outback you will find a huge covered patio. NO HOA. You don\'t want to miss this one!! Schedule an appointment today!!','0.4591','3','','','','','Sellers Disclosure','','','','Medical Center South','Central Gas','0','LT 43 BLK 4 ALMEDA GENOA PLACE','Cleared','20000','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','FROST ELEMENTARY SCHOOL (HOUSTON)','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Almeda Genoa Place','2605','2.2019','Public Sewer','1993','Appraisal District'); --> New record created successfully