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-13T00:28:39.750' ,`MLSNumber` = '3815558' ,`ListAgentFullName` = 'Kourtney Walker' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015055' ,`Longitude` = '-95.745200' ,`PhotoCount` = '32' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '352500.00' ,`Status` = 'Active' ,`StreetName` = 'Fiesta Rose' ,`StreetNumber` = '16603' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one-story home settled on a double cul-de-sac street. 4-bedroom 2-and-a-half-bathroom split plan home with no carpet. A very well-maintained home on a corner lot with many amazing features. As you enter the home, you are welcomed by a formal dining area. The open floor plan features a kitchen that opens to the living area. There is an abundance of windows and gas fireplace. The primary bedroom is privately located off the living area. The primary bathroom has a tub and separate shower. The three secondary bedrooms are spacious. There is a Jack and Jill bathroom to accommodate the secondary bedrooms. The backyard is fully fenced and features a covered patio. Fairfield is a master planned community located conveniently off the Grand Parkway. The amenities include: parks, pools, athletic fields, basketball courts, pavilions and more. Welcome Home.' ,`Acres` = '0.2027' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 2 FAIRFIELD VILLAGE NORTH SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1015' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Fairfield Village North' ,`TaxAmount` = '' ,`TaxRate` = '2.611' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675131991' WHERE `Matrix_Unique_ID` = '212196872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-12T23:00:04.000' ,`MLSNumber` = '10948277' ,`ListAgentFullName` = 'Anne Bielstein' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.192423' ,`Longitude` = '-95.539456' ,`PhotoCount` = '50' ,`PostalCode` = '77382' ,`RoomCount` = '16' ,`ListPrice` = '2180000.00' ,`Status` = 'Active' ,`StreetName` = 'Winslow' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Way' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5157' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding custom home on a peaceful wooded 3/4+ acre cul-de-sac lot in the heart of guard-gated Carlton Woods. Lives like a one story!!! Superbly renovated and updated with the utmost attention to details. Grand floor plan with high ceilings - great flow for living and entertaining - formal LR and DR, home office/library, spacious den with custom millwork entertainment wall. Private primary suite with fireplace – serene ensuite bath and dual closets. Plus a private 2nd bedroom/guest suite down. Gourmet kitchen + butler’s pantry is a show-stopper - beautifully redone with custom millwork and architectural accents + fresh color palette and Quartzite countertops and backsplash. Stepping outside from multiple doorways you’ll find terraces surrounding a heated pool and separate spa, plus a covered terrace with fireplace and outdoor kitchen. Upstairs is a spacious home theatre room with wet bar and custom millwork entertainment wall and two bedrooms with ensuite baths. Impeccable!' ,`Acres` = '0.774' ,`Area` = '15' ,`BuilderName` = 'Robin Rueby' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18, BLOCK 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Wooded' ,`LotSize` = '33715' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Village Of Carlton Woods' ,`TaxAmount` = '34496' ,`TaxRate` = '2.18' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675131991' WHERE `Matrix_Unique_ID` = '213238092' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-12T23:00:45.540' ,`MLSNumber` = '24410729' ,`ListAgentFullName` = 'Jan Jackson' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733333' ,`Longitude` = '-94.942493' ,`PhotoCount` = '31' ,`PostalCode` = '77520' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Colby' ,`StreetNumber` = '2104' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful curb appeal on this one owner three bedroom home. Very well maintained. Home features: a large open living area, formal dining, and breakfast area. Spacious master bedroom and large walk in closets in all bedrooms.' ,`Acres` = '0.2603' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 8 PLUMWOOD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plumwood' ,`TaxAmount` = '6046' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675131991' WHERE `Matrix_Unique_ID` = '215005274' --> 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','215224303','1675131991','215224303','2023-01-12T23:16:25.413','69016767','Patrick McGrath','Meritage Homes Realty','','','29.515212','-95.320552','17','77584','5','501340.00','Active','Spanish Moss','6431','Drive','Pearland','4','0','5','2991','Single-Family','Brand NEW energy-efficient home ready May 2023! Skip the theater and enjoy movie night at home from the comfort of the Kessler’s second-story game room. Downstairs, the primary suite boasts dual sinks and a large walk-in closet. A useful kitchen island overlooks the open living and dining rooms. Escape the bustle of the city without adding to your commute. Located in popular Pearland, Massey Oaks combines outdoor amenities like lakes, parks, and trails with everyday conveniences like access to shopping, dining, and entertainment. The neighborhood is zoned in the desirable Alvin ISD. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.','','5','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Heat Pump','1','SF 0112 Plan L454F','Subdivision Lot','','','','600','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','G W HARBY J H','Appointment Required','Builder','2','Traditional','Massey Oaks','','3.67','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','215395136','1675131991','215395136','2023-01-12T23:19:32.327','78475744','Darian Candler','Entera Realty LLC','','','29.858934','-95.199670','23','77044','8','235000.00','Active','Chapelstone','9503','Court','Houston','2','0','3','1736','Single-Family','Three bedroom, two bath, two-car garage single-story home. Home is open concept living with family room, formal dining room, kitchen and breakfast all being open to each other. Primary bedroom has vaulted ceilings.','0.1763','2','','','','','Mud,Other Disclosures,Sellers Disclosure,Special Addendum','','','','North Channel','Central Gas','1','LT 1 BK 1 STONEFIELD MANOR SEC 5','Corner,Subdivision Lot','7678','Appraisal District','','309','0','','2','','0','','','','','Composition','46 - Sheldon','MONAHAN ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Stonefield Manor Sec 5','6820','2.9993','Public Sewer,Public Water','2005','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','216223133','1675131991','216223133','2023-01-12T23:14:25.080','73405570','Cassie Bradford','HomeSmart','','','29.734774','-95.350021','6','77004','3','475000.00','Active','Mcilhenny','3421','Street','Houston','2','0','3','1534','Single-Family','Downtown Medical Center Area. New Construction From The Hearthstone Homes Collection This home detail 3 bedrooms 2 baths 2 car garage with outdoor kitchen on back patio. This home is currently under construction the final detail can be custom to the new home owners desire. The home will compliment entertainment the open floor plan includes kitchen overlooking the living room. The amazing breakfast bar with sleek farm house stainless steel sink, quartz counter tops 56in cabinets w/ top and bottom lighting. Built in surround sound living and media combo with 12 ft tray ceilings great for that 10 ft Christmas tree. Beautiful gas log fireplace great for a winter night or just a romantic evening. Security system and Generac generator will be installed. The bathrooms includes jetted tub and shower combo.','0.0918','4','HEARTHSTONE HOMES','','Electric Dryer Connections','','No Disclosures','','Freestanding','','University Area','Central Electric','0','LT 17 BLK 6 PRAIRIE HOME','Cleared','4000','Survey','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required','Builder','1','Other Style','Prairie Home','2573','2.3307','Public Sewer,Public Water','2023','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','216273097','1675131991','216273097','2023-01-12T23:59:44.940','18178001','Jeffrey Whitespeare','eXp Realty, LLC','','','29.855314','-95.272454','9','77078','5','170000.00','Active','Sterlingshire','8334','Street','Houston','2','0','3','1522','Single-Family','Large 3 bedroom 2 bath home with 2 car attached garage. Located in the quiet neighborhood of Glenwood Forest. Investor Special! Home needs some TLC... Would make a great flip home. Home features livingroom/Den with a gas log fireplace, kitchen/breakfast combo. Oversized closet in Primary Bedroom. Patio and Fenced back yard. Close to Hwy 59, Beltway 8 and 610.','0.1641','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Northeast Houston','Central Electric','0','LT 11 BLK 16 GLENWOOD FOREST SEC 4','Subdivision Lot','7150','Appraisal District','','','0','','2','Electric Oven','0','','','Freestanding Range','','Composition','27 - Houston','HILLIARD ELEMENTARY SCHOOL','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Glenwood Forest Sec 04','3750','2.3307','Public Sewer,Public Water','1973','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','216311560','1675131991','216311560','2023-01-12T23:09:43.960','64674763','Darin Young','RE/MAX Universal','','','29.839773','-95.274399','28','77028','9','229000.00','Active','VISTA OAKS MANOR','8503','','Houston','2','0','4','1450','Single-Family','Come See this beautiful one story home. In a cul-de-sac with no neighbor on left side and plenty of privacy. Additional room added on back for a game room or office/study. In great shape with plenty of room for family. Low tax rate.','0.154','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','','Northeast Houston','Central Electric','1','LOT 14 BLOCK 3 HARREL PARK','Cul-De-Sac,Subdivision Lot','6693','Appraisal District','','480','0','','2','','0','','','','','Composition','27 - Houston','HILLIARD ELEMENTARY SCHOOL','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Ranch,Traditional','HARREL PARK','2387','2.3307','Public Sewer,Public Water','2013','Appraisal District'); --> New record created successfully