Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T18:42:32.313' ,`MLSNumber` = '11515738' ,`ListAgentFullName` = 'Melisa Vickers' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.939606' ,`Longitude` = '-94.838661' ,`PhotoCount` = '42' ,`PostalCode` = '77535' ,`RoomCount` = '8' ,`ListPrice` = '509900.00' ,`Status` = 'Active' ,`StreetName` = 'FM 1409' ,`StreetNumber` = '9193' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Acreage!! Great Spanish style home located on 5.33 acres. Home has new roof and new A/C 2022. Home is located approximately 8 miles from Hwy 90 and 6 miles from FM 565. FM 1409 now goes all the way to I-10 making the drive to the freeway much quicker. Approximately 1.5 acres is manicured and fenced with beautiful trees, with the remaining acreage being very wooded. There is a gate to the back acreage. Sellers have seen multiple deer, hogs, raccoons and various other species of wildlife. Home features formal dining, large primary bedroom with primary bath boasting double sinks and 2 walk in closets. Recent flooring and paint in several rooms. Home is equipped with an aerobic septic system and a well. Well tank is housed in recently built well house. South of the property is heavily wooded. Neither the home nor the property has ever flooded. Storage building located behind the home. There is a steel carport attached to garage and the home. Owner is agent.' ,`Acres` = '5.33' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000119 J A WILLIAMS, TRACT 59, ACRES 5.33' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '232175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Spanish' ,`Subdivision` = 'J A Williams' ,`TaxAmount` = '6702' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091084' WHERE `Matrix_Unique_ID` = '213450323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T18:19:22.067' ,`MLSNumber` = '46635356' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.328385' ,`Longitude` = '-94.944107' ,`PhotoCount` = '23' ,`PostalCode` = '77563' ,`RoomCount` = '5' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Vista' ,`StreetNumber` = '96' ,`StreetSuffix` = 'Drive' ,`City` = 'Hitchcock' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price reduced!! This is not an ordinary Gulf Coast waterfront home....it has been renovated throughout then repainted using an appealing architectural color palette. The concrete drive, side walkways, and rear patio have been resurfaced; the three decks, railings and exterior trim have been refinished. All hardwood floors have been re-stained and sealed. This home has two rear wood decks so that there are actually three levels to the decking providing wonderful views of the waterways and sunsets. On the lowest level, there is a patio space and a boat dock with electric lift allowing direct access to the canal for sports fishing and crabbing, as well as to Jones Bay and other larger waterways. Also on this level is a large bedroom/game room and full bath, plus a single garage. The second level contains two bedrooms, the master bath and the large kitchen/dining/living area. Both resident levels can be accessed by both interior and exterior means.' ,`Acres` = '0.1323' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Electric,Space Heater' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 96 (95-0) BAYOU VISTA ADDN 3' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '5762' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bayou Vista Sec 3' ,`TaxAmount` = '6835' ,`TaxRate` = '2.2525' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091084' WHERE `Matrix_Unique_ID` = '214015963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T18:08:29.740' ,`MLSNumber` = '50482387' ,`ListAgentFullName` = 'Cindi Rickman' ,`ListOfficeName` = 'ROCK REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385168' ,`Longitude` = '-94.921099' ,`PhotoCount` = '10' ,`PostalCode` = '77590' ,`RoomCount` = '6' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Wayside' ,`StreetNumber` = '1726' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lots of potential here! Spacious living room and 2 primary bedrooms. Fireplace with gas lighter. Great family home! INVESTOR SPECIAL. SOLD AS IS. REDUCED $35K!' ,`Acres` = '0.1584' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 PAGE 3 LOT 9 BLK 17 WAYSIDE PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'KOHFELDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Place 2' ,`TaxAmount` = '4312' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675091084' WHERE `Matrix_Unique_ID` = '214959191' --> 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','215168215','1675091084','215168215','2022-12-14T17:20:21.577','55997730','Madelene Rogers','Martindale Real EstateInvestments','','','30.529818','-94.447274','33','77663','8','215000.00','Active','ROWANTREE LOOP','112','','Village Mills','2','0','3','1699','Single-Family','DON\'T MISS OUT ON THIS ONE! 3/2/2 BRICK HOME ON 2 LOTS, LOCATED ON VERY QUITE STREET. HOME HAS BEEN UPDATED INSIDE. FIRE PLACE, LARGE LIVING AND DINING AREA, LARGE FRONT PORCH, MUD ROOM, INSIDE UTILITY ROOM. BACK YARD IS FENCED, EXTRA PARKING. WILDWOOD HAS EXCELLENT 18 HOLE GOLF COURSE, TENNIS, VOLLEYBALL, BASKETBALL COURTS, 365 ACRE LAKE, BEACHES, 24/7 SECURITY, AND MUCH MORE.','','48','','','Electric Dryer Connections,Washer Connections','','HOA First Right of Refusal,Sellers Disclosure','1','Gaslog Fireplace,Wood Burning Fireplace','1','Tyler County','Central Gas','1','LOTS 8, 9 BLOCK 649','In Golf Course Community,Subdivision Lot','','','','150','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','1012 - Warren','WARREN ELEMENTARY SCHOOL','WARREN HIGH SCHOOL (WARREN)','WARREN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','WILDWOOD','','','Aerobic,Public Water','1997','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','215499873','1675091084','215499873','2022-12-14T18:04:14.017','38612223','Robin Geiler','UTR TEXAS, REALTORS','','','29.413945','-95.005805','26','77591','7','310000.00','Active','Explorer','3321','Drive','Texas City','2','0','3','2032','Single-Family','WELCOME HOME TO 3321 EXPLORER DR. IN BEAUTIFUL MARLOW LAKE COMMUNITY! Ready for quick move-in, this spacious Colina 1 story has much to offer! Brick and stone elevation with excellent curb appeal! Oversized 3 bedroom, 2 bath with additional multi use/flex room. Open concept floor plan with generous space and covered patio! Large island kitchen offers granite counters, stainless appliances, 42\" cabinets and breakfast bar. Large family room with cozy gas log fireplace for those chilly Texas nights! Split floor plan, primary bedroom with en-suite bath, garden tub, separate shower and walk in closet. Built in Taexx Pest Control System, PEX Plumbing, tankless water heater, recessed lighting, insulated/low-E windows and additional energy star features! Why wait months for new construction, this 2020 built is ready to go! Excellent location! Minutes to I-45, Galveston, UTMB and some of the best fishing along the Texas Gulf Coast! Call today for appointment!','0.1377','33','Colina','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Texas City','Central Gas','1','LOT 20 MARLOW LAKE SEC 2 (2020) ABST 180','Subdivision Lot','6000','Appraisal District','','600','0','','2','Freestanding Oven','0','','','Gas Range','','Composition','17 - Dickinson','HUGHES ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Final Plat/Marlow Lake Sec 2','9343','3.2937','Public Sewer,Public Water,Water District','2020','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','215532585','1675091084','215532585','2022-12-14T17:11:12.973','10607151','Deborah Bly','eXp Realty, LLC','','','29.916496','-95.100044','47','77532','11','365000.00','Active','Bollard','16007','Drive','Crosby','2','1','4','2697','Single-Family','SELLERS CURRENT RATE IS ASSUMABLE! AND IT\'S AMAZING. ASK FOR MORE DETAILS! You will fall in love with this almost-new home! Seller added upgrades including wood-like tile flooring throughout the main level, chef\'s dream kitchen with tile backsplash, cabinet hardware, high-end faucet and updated stacked-stone cozy wood burning fireplace. Plenty of space for the kids to hang out upstairs in the Gameroom along with 3 good-sized bedrooms. The primary bedroom with an ensuite bathroom is on the first floor. Located on a cul-de-sac, the oversized yard is perfect for a pool and backs up to a golf course! The neighborhood is family oriented with amenities such as private access to San Jacinto River with a manmade beach, also access to Lake Houston, and walking trails! Close proximity to the community pool and tennis court, splash pad, park, and gym…the list goes on! You will not be disappointed! Schedule your showing before it’s gone!','0.321','1','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','1','Crosby Area','Central Electric','1','LT 10 BLK 4 NEWPORT SEC 2','Subdivision Lot','13984','Appraisal District','','50','0','','2','Electric Oven','0','','','Electric Range','','Composition','12 - Crosby','CROSBY ELEMENTARY SCHOOL (CROSBY)','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Newport Sec 02','6977','2.7105','Public Sewer,Public Water,Water District','2017','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','215541407','1675091084','215541407','2022-12-14T17:11:53.827','90001144','Christa Renna','Realty ONE Group, Experience','','','30.258573','-95.522793','50','77384','8','368000.00','Active','Redwood Forest','14161','Trail','Conroe','3','0','4','2303','Single-Family','Lightly lived in 4 bedroom 3 bath home on HUGE lot with greenbelt behind! Primary suite, second bedroom (would also make a great office space) and second full bath on first floor. Game room, two more bedrooms and third full bath upstairs. Expansive island kitchen open to family and breakfast rooms. Durable vinyl plank flooring in main living areas. Abundant storage throughout with spacious pantry, bedrooms with walk-in closets plus hidden closet under the stairs. Washer, dryer, refrigerator included. Beautiful neighborhood with sidewalks, community center, playground, and pool. Zoned to acclaimed The Woodlands schools and convenient to shopping and restaurants.','0.3437','15','DR HORTON','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Conroe Southwest','Central Gas','1','S516414 - FOSTERS RIDGE 14, BLOCK 3, LOT 19','Greenbelt,Subdivision Lot','14973','Appraisal District','','850','0','','2','Freestanding Oven,Gas Oven,Single Oven','0','','','Gas Range','','Composition','11 - Conroe','BUSH ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Fosters Ridge','10513','3.1488','Water District','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','215550531','1675091084','215550531','2022-12-14T18:59:10.717','2541406','Jocelyn Good','BHGRE Gary Greene','Jocelyn Good','BHGRE Gary Greene','29.775045','-95.579391','16','77079','9','750000.00','Pending Continue to Show','Perthshire','13514','Road','Houston','3','1','4','2877','Single-Family','13514 Perthshire has been lovingly cared for by the original homeowner. This home sits on an oversized corner lot in highly sought after Wilchester. This home features the beautiful original wood flooring in a herringbone pattern in the living room. There are two primary suites, one on the first floor and one on the second floor. The second floor has two additonal bedrooms that share a hall bathroom. There is a fireplace in the dining room, living room, and sunroom. This home has so much potential! You can move in now then renovate or build later. This home is an estate. Will is in probate so sellers require a 3 month closing.','0.28','23','','','','','Estate,No Disclosures','','','3','Memorial West','Central Gas','1','LT 14 BLK 4 WILCHESTER SEC 2','Corner,Subdivision Lot','12197','Appraisal District','','732','0','','2','','0','','','','','Composition','49 - Spring Branch','WILCHESTER ELEMENTARY SCHOOL','STRATFORD HIGH SCHOOL (SPRING BRANCH)','MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)','Accompany,Appointment Required','Appraisal District','2','Traditional','Wilchester','19206','2.4415','Public Sewer,Public Water','1963','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','215572677','1675091084','215572677','2022-12-14T17:11:06.233','17563340','Lela Jackson','Hardee & Company Real Estate','','','29.680010','-95.436611','18','77025','3','425000.00','Active','Woodvalley','3703','Drive','Houston','2','0','3','2173','Single-Family','NEVER BEEN FLOODED IN HIGHLY SOUGHT-AFTER SUBDIVISION OF WOODSIDE!!! This traditional 3 Bedroom, 2 bathroom home offers spacious living spaces including formal living, formal dining and a extra room. The home still has its unique classic décor. This is a great opportunity to make this home your own with your personal touches and designer looks or buy as an investment!!! Minutes from Texas Med Center, Museum District, Herman Park, Downtown & U of H. See it today!','0.2089','17','','','','','Sellers Disclosure','','','','Knollwood/Woodside Area','Central Gas','0','LT 10 BLK 24 WOODSIDE SEC 3','Subdivision Lot','9100','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Woodside Sec 03','9919','2.3307','Public Sewer,Public Water','1957','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','215602371','1675091084','215602371','2022-12-14T17:32:39.077','20584336','Michael King','eXp Realty, LLC','','','30.029843','-95.494801','24','77379','4','279999.00','Active','Woodville','5403','Lane','Spring','2','1','4','2812','Single-Family','This property has has been well maintained. This home has 4 bedrooms, 2 and a half bathrooms and sits on nice sized lot with a pool! Looking for someone who want to call this home or an investor whose looking for a great property.','0.3237','13','','','','','Mud,Sellers Disclosure','','','1','Champions Area','Central Gas','1','LT 110 BLK 4 TERRANOVA WEST SEC 1','Subdivision Lot','14100','Appraisal District','','603','0','','1','','1','In Ground','','','','Composition','32 - Klein','BENFER ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','STRACK INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Terranova West Sec 01','6867','2.7066','Public Sewer,Water District','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','215607390','1675091085','215607390','2022-12-14T17:22:44.127','56036813','Barbara Gordon','JPAR - The Sears Group','','','29.804626','-94.892329','17','77523','9','315000.00','Active','Levant','2210','Lane','Baytown','2','1','4','2304','Single-Family','Welcome to this gorgeous, one of a kind home! Walking in you are greeted by a bright office/study directly to your right. Moving forward you enter the large open floor plan with the perfect view into the family room. The wall from the kitchen down provides ample opportunity for bold decorating blending well into the perfectly balanced kitchen. . Enjoy preparing your favorite meals on quartz countertops & stainless steal appliances overlooking a large island. The master suite is downstairs offering a double sink, walk in closet and your choice of a relaxing shower or deep tub for soaking. Walking upstairs you enter the game room offering access to three additional rooms and a extra full bath. The large backyard with covered patio adds for the perfect chance to host gatherings and enjoy outdoor activities. This home falls in chambers county and offers quick access to HWY 146, I10, and 99! The community offers walking trails, a playground, community pool and a future elementary.','0.1492','53','Beazer','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Baytown/Chambers County','Central Electric,Central Gas','1','BLK 4 LOT 9 SOUTHWINDS SEC 1','Subdivision Lot','6501','Appraisal District','','475','0','','2','Electric Oven','0','','','','','Composition','23 - Goose Creek Consolidated','CLARK ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','GENTRY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment','Appraisal District','2','Traditional','Southwinds Sec 1','7577','2.8882','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully