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-30T01:21:40.493' ,`MLSNumber` = '6764703' ,`ListAgentFullName` = 'Michelle Goswick' ,`ListOfficeName` = 'G2 RE Resource' ,`SellingAgentFullName` = 'Donna Hovis' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '29.525122' ,`Longitude` = '-95.218146' ,`PhotoCount` = '33' ,`PostalCode` = '77546' ,`RoomCount` = '8' ,`ListPrice` = '1700000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rustic' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Phenomenal 2.59-acre estate home with approximately 4972 s/f of living space. The property is gated and includes 4 bedrooms, 3 full baths & 1 half bath, media room, large game room, pool house/guest quarters, barn, storage building, circular drive, fully fenced and backyard cross-fenced, and a Generac whole-house generator. The large family room boasts a floor-to-ceiling river rock fireplace, cathedral ceiling, and stained concrete floors. The garage is equipped with a Nema 14/50 230 volt plug for your Tesla charging. The property contains fig, avocado, plum, peach, and olive trees.' ,`Acres` = '2.592' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 20 PAGE 3 LOT 7 RUSTIC ACRES SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '112908' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Rustic Acres 89' ,`TaxAmount` = '16103' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266150' WHERE `Matrix_Unique_ID` = '211608625' --> 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','215031638','1675266150','215031638','2023-01-30T01:22:32.003','23392809','Jesse Glatz','TBT Real Estate','','','29.022991','-95.445464','26','77566','8','265000.00','Active','Corkwood','246','Street','Lake Jackson','2','0','3','2030','Single-Family','Well maintained jewel with inviting curb appeal, traditional character and charm is waiting for YOU! Expansive living space clocking in at over 2,000 square feet is a blank slate for you to add all of your custom touches and make it your own! This oversized gem in a very desirable neighborhood offers updates such as laminate flooring, electric fireplace insert, granite countertops in kitchen and master bath bath, marble in second bath, enclosed and screened in back patio, stainless appliances, large shower and dual master closets in master bath and glass shower doors in second bath, light fixtures, dual sliding patio doors and more! Within the last 5 years this home has had new AC & Heat, exterior paint, water heater, breaker box and lawn sprinkler system. Large back room can be used for 4th bedroom with its large walk-in closet or turn it into a spacious gameroom, craft room, guest room, or anything else your heart desires! Hurry and be the next one to put your name on the mailbox!','0.1928','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Mock Fireplace','1','Lake Jackson','Central Electric','0','FLAGRIDGE SEC I (LAKE JACKSON), BLOCK 1, LOT 23','Subdivision Lot','8398','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','7 - Brazosport','ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)','BRAZOSWOOD HIGH SCHOOL','LAKE JACKSON INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Flagridge Sec I-Ii-Iii Lake J','5596','2.3371','Public Sewer,Public Water','1980','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','215597478','1675266150','215597478','2023-01-30T01:22:32.003','20959220','Lawrence Krim','City Choice Realty','','','29.734213','-95.368082','11','77004','12','484900.00','Active','Francis','2120','Street','Houston','3','1','3','2104','Single-Family','Move-in ready, 2119 Francis Street features a freestanding 3-level residence w a private driveway by coveted building firm City Choice Homes. The home showcases a timeless aesthetic with three bedrooms, 3.5 baths & oversized covered balcony on the second level. Enter the foyer open to all three levels leading to a en-suite guest room. Ascend to the 2nd level boasting a sunlit Great Room with a wine bar spanning over 30’ opening to the balcony & an island kitchen outfitted w top tier appliances, shaker style cabinetry & quartz countertops. 3rd level: Owner’s suite, en-suite guest room & utility room. The Owners wing features coffered 10’ ceilings & massive walk-in closet w built-ins. The owner’s bath consists of a freestanding soaking tub, dual vanities trimmed with high-end plumbing fixtures & a substantial glass-enclosed shower & private water closet. Swiss flooring throughout the home, all en-suite bedrooms, private driveway with covered Porte-cache. Completion: October 22\'','0.0321','4','City Choice Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','University Area','Central Gas','0','LT 1 BLK 1 CHATEAUS AT HUTCHINS STREET','Subdivision Lot','1400','Appraisal District','','','1','Never Lived In','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox','Appraisal District','3','Contemporary/Modern','Chateaus/Hutchins Street','1107','2.3307','Public Sewer,Public Water','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','215869619','1675266150','215869619','2023-01-30T01:46:02.640','93006648','Michael Emmanuel','Move Texas Realty','','','29.734382','-94.940016','17','77520','5','229000.00','Active','Greenwood','1307','Drive','Baytown','2','0','3','1558','Single-Family','Well cared for and updated 3/4 bedroom located in this quiet neighborhood featuring brick exterior, solar panels, custom cabinetry, granite countertops, tile flooring, Recess lights, crown molding and storage shed in the backyard. The 4th room could be used as an office. there is a 5th sized room which could be additional bedroom. The possibilities are endless. If you are home shopping, this home will sell itself. Schedule a tour today before its gone.','0.1641','2','','','','','Exclusions,Sellers Disclosure','','','','Baytown/Harris County','Central Electric','0','LT 6 BLK 3 PLUMWOOD SEC 5','Subdivision Lot','7150','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','23 - Goose Creek Consolidated','LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','CEDAR BAYOU J H','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Plumwood Sec 05','4918','2.97','Public Sewer,Public Water','1970','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','216008294','1675266150','216008294','2023-01-30T01:22:32.003','70441007','Tammie Bell','TBT Real Estate','','','29.060862','-95.460207','45','77566','9','600000.00','Active','Timbercreek','311','Drive','Lake Jackson','3','1','4','3554','Single-Family','Welcome to Timbercreek! Enjoy life more in double living areas in the oh-so-spacious 4 bedroom home. Walk in the entry way into the living room with built-in bookcases, marble tile, and custom trim molding. Game room and 3 bedrooms upstairs with the primary room with 2 walk in closets downstairs. Plenty of elbow room in the kitchen with a large island and a built-in desk. Imagine coming home to the backyard, decked out with a screened in and inviting pool with a water feature and fountain with hot tub on a private lake. There is also gas connectivity on the patio! The yard has fruit trees including fig and loquat. Come out and see this home for yourself!','0.8977','5','','','Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Lake Jackson','Central Electric,Central Gas','0','TIMBERCREEK SEC 2 REPLAT (LAKE JACKSON), BLOCK 10, LOT 13','Subdivision Lot,Water View,Waterfront','39104','Appraisal District','','','0','','3','Electric Oven','1','In Ground','','Electric Cooktop','','Composition','7 - Brazosport','BRANNEN ELEMENTARY SCHOOL','BRAZOSWOOD HIGH SCHOOL','LAKE JACKSON INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Back,Vacant/Unoccupied','Appraisal District','2','Traditional','Timbercreek','9698','2.1926','Public Sewer,Public Water','1990','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','216274695','1675266150','216274695','2023-01-30T01:22:32.003','97741692','Tongela Clark','United Real Estate','','','29.730803','-95.370144','8','77004','3','249998.00','Active','Truxillo','2202','Street','Houston','1','0','3','1806','Single-Family','5,775 corner lot in sought after 3rd ward community with many possibilities','0.1326','4','','','','','Sellers Disclosure','','','1','University Area','Other Heating','0','LT 1 BLK 5 WASHINGTON TERRACE','Corner,Subdivision Lot','5775','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','LOCKHART ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Accompany,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Washington Terrace','4372','2.3307','Public Sewer,Public Water','1940','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','216527942','1675266150','216527942','2023-01-30T01:09:22.887','72821514','Jennifer Yoingco','Walzel Properties','','','29.892219','-95.222195','26','77044','5','130000.00','Active','Greensbrook Forest','11939','Drive','Houston','2','0','3','1080','Single-Family','This is an amazing opportunity to acquire this UNPOLISHED GEM! Unleash your creativity as this home needs TLC. Excellent potential at this price! Its long list of comforts includes 3 beds, 2 baths, and a 1 car attached garage. It has an open floor plan that seamlessly connects the living room, kitchen, and dining room combo — perfect for entertaining & family gatherings. The kitchen has granite countertops, white kitchen appliances, & a large island. Another feature that makes this home stand out is the custom barnyard doors. All bedrooms are airy and filled with sunlight, perfect for decorating with the installed beautiful light fixtures. This home is located near shopping, dining, & entertainment hot spots. Don\'t miss the opportunity to make this your dream home!','0.101','2','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure,Short Sale','1','','','Northeast Houston','Central Electric','0','LT 70 BLK 8 GREENSBROOK SEC 1 R/P','Subdivision Lot','4400','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Cooktop','','Composition','46 - Sheldon','GARRETT ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','MICHAEL R. NULL MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Greensbrook Sec 01 R/P','4032','3.1593','Water District','2003','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','216657831','1675266150','216657831','2023-01-30T01:22:32.003','89524271','Matthew Guzman','RE/MAX Universal','','','30.041309','-95.340823','24','77373','7','229990.00','Active','Walnutgate','5802','Drive','Spring','2','0','3','1564','Single-Family','NEW CARPET AND FRESH PAINT! This home is move in ready!!! Welcome home to this spacious 1 Story, 3 Bedroom, 2 Bath, with 2 Car Garage. You will love the semi enclosed COURTYARD as you approach the front door. Entering the home you will have the Formal Dining Area connected to the Huge Family Room with wood burning fireplace. Off the Dining Room you have your Kitchen/Breakfast Rooms that has a opening Peek-Through to the Family Room. You will love the spacious Master Bedroom with a huge Master Bath. There are 2 other bedrooms and a 2nd Bath. Do not miss the big fenced backyard with patio for entertaining family and friends. Convenient to I45, Hardy Toll Road, and FM 1960. Also close to Bush IAH, Mercer Botanic Gardens, Jesse H Jones Park, and shopping & entertainment from Deerbrook to the Woodlands.','0.1515','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Spring East','Central Electric','1','LT 8 BLK 12 GREENGATE PLACE SEC 2','Cleared,Subdivision Lot','6600','Appraisal District','','374','0','','2','Electric Oven','0','','','Electric Range','','Composition','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Appointment Required,Leave Business Card','Appraisal District','1','Ranch','Greengate Place','4276','2.5311','Public Sewer,Public Water','1976','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','216794731','1675266150','216794731','2023-01-30T02:10:34.270','54384772','Lindsey Latham','JLA Realty','','','30.356512','-95.275506','9','77328','5','250000.00','Active','Greenwood','5480','Drive','Cleveland','2','0','3','1248','Single-Family','Make an appointment today to see this 3 bedroom 2 bathroom home that is situated on 2 acres of a corner lot. Property still features a lot of trees on this corner lot which offers plenty of shade. Home features open concept from the living area to the kitchen. Primary room features its own bathroom with a soaking tub and separate shower. Primary room has large walk in closet. Home utilizes a water well which is kept protected in a shed building. There is also an unfinished storage building structure on the property that has protentional for extra storage, bonus room, mancave, etc. Seller is motivated!','2','19','Clayton Colonial','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Conroe Northeast','Central Electric','0','A0584 - VOTAW ELIJAH, TRACT 2 LOT 13A-1, ACRES 2','Cleared,Corner','87120','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','11 - Conroe','AUSTIN ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Builder','1','Traditional','Abstract Area','1849','1.8488','Well','2013','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','216862648','1675266150','216862648','2023-01-30T02:12:39.583','46863357','Angela Wells','Stanfield Properties','','','29.809550','-95.136127','15','77049','10','275000.00','Active','Mandate','16515','Drive','Houston','2','1','3','1869','Single-Family','Move-in ready 3/2.5/2 two-story home located in the recently developed Rancho Verde community in Channelview ISD. Upon entering this 2013-built Centex home, you’ll find a two-story ceiling with sunlight peeking in through large windows in the foyer and casting natural sunlight into the open floor-plan living space with neutral paint, ceramic tile floors, and lots of room for entertaining family and friends. The spacious kitchen offers a raised breakfast bar, shaker-style walnut cabinetry, a gas range, a roomy pantry, and space to add an island, if you wish! Upstairs, find a second living space for an office or game room, a convenient laundry room, three bedrooms, and two baths. The master bedroom features custom paint, and an en-suite bath with a separate shower and a garden tub, along with a huge closet! Neighborhood amenities include a swimming pool and parks to enjoy. Easy access to the Beltway, shopping, and restaurants! Make your appointment today!','0.101','2','Centex Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','North Channel','Central Gas','1','LT 43 BLK 1 RANCHO VERDE SEC 5','Subdivision Lot','4400','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Range','','Composition','8 - Channelview','Brown Elementary School (Channelview)','CHANNELVIEW HIGH SCHOOL','AGUIRRE JUNIOR HIGH','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Rancho Verde Sec 5','5896','2.618','Public Sewer,Public Water','2013','Appraisal District'); --> New record created successfully