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-12T19:42:15.567' ,`MLSNumber` = '11222420' ,`ListAgentFullName` = 'Khanh Tran' ,`ListOfficeName` = 'Loft Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.024963' ,`Longitude` = '-95.441955' ,`PhotoCount` = '22' ,`PostalCode` = '77566' ,`RoomCount` = '4' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Chinquapin' ,`StreetNumber` = '51' ,`StreetSuffix` = 'Court' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located in Lake Jackson city. The upgrade includes: Granite in kitchen and bathrooms, fresh paint and many MORE. The property featured 4 spacious bedrooms and 2 1/2 baths with a beautiful back yard. This home will go quickly. Schedule your showing today.' ,`Acres` = '0.2032' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FLAGRIDGE SEC II (LAKE JACKSON), BLOCK 3, LOT 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8851' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Flagridge Sec I-Ii-Iii Lake J' ,`TaxAmount` = '4746' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675131928' WHERE `Matrix_Unique_ID` = '212252454' --> 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','215187428','1675131928','215187428','2023-01-12T19:00:44.083','3703118','Joy Upanavage','BHGRE Gary Greene','Labatiste Kennedy','Sunshine Realty','29.849464','-94.998334','47','77532','3','235000.00','Pending Continue to Show','Glenwood','10423','Drive','Crosby','2','0','3','1620','Single-Family','Nicely updated mobile/modular home on a corner lot located on 0874 acres and no HOA in Crosby TX. Detached 20x40 garage workshop plenty of room for cars, boats and storage. Lot of updates: recently fully fenced, gate-system and decks, triple tab 30yr roof, hot-water heater, double-pane double-hung windows, new flooring, light fixtures and ceiling fans, extra one-car detached garage and upgraded appliances. Great Location!!','0.8448','2','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','','1','Crosby Area','Propane','0','LT 22 BLK 1 FAIRACRES SEC 2 U/R','Cleared,Corner','36800','Appraisal District','','','0','','1','Electric Oven','0','','','Gas Range','','Composition','12 - Crosby','DREW ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required,Supra Keybox','Appraisal District','1','Ranch','Fairacres Sec 02 U/R','1916','2.0766','Aerobic,Public Water','2010','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','215226579','1675131928','215226579','2023-01-12T19:47:38.570','87541202','Evan Howell','Evan S. Howell, Inc.','','','29.752168','-95.388779','32','77006','10','799000.00','Active','Stanford','1707','Street','Houston','2','0','4','2564','Single-Family','Remarkable Montrose area home with hardwood floors in living areas/bedrooms and tile in kitchens/bathrooms on oversized lot with plenty of charm. Stair access in front and back with rear 2nd level porch. Electric entry drive gate leading to 21x20 carport. Original windows replaced with Milgard SunCoatMAX double paned windows in 2015. Verizon 5G broadband internet is available at this address and is used by homeowner for daily video conferencing and other remote work needs. Home is in walking distance to parks, schools, restaurants, and other desirable Montrose establishments. City bike path recently installed blocks away and connects to miles of trails via Allen Parkway parks. Designed as a duplex with full kitchen up and down, it is currently used as home office downstairs but could also be a guest suite or a 6-bedroom home. Can convey with upstairs washer/dryer, 2 refrigerators negotiable other nice furnishings on non-realty items addenda. Platted unrestricted Reserve.','0.161','16','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','2','Montrose','Central Gas','0','RES A BLK 1 KOSKA VILLAS AT STANFORD','Subdivision Lot','7013','Appraisal District','','','0','','0','Freestanding Oven,Gas Oven,Single Oven','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','27 - Houston','WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY','LAMAR HIGH SCHOOL (HOUSTON)','GREGORY-LINCOLN MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','KOSKA VILLAS','13245','2.3307','Public Sewer,Public Water','1929','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','215492274','1675131928','215492274','2023-01-12T20:22:23.437','57666089','Jaymes McKenzie','Offerpad Brokerage, LLC','','','30.110602','-95.398484','37','77386','4','289000.00','Active','Waltham','29114','Street','Spring','2','0','4','1762','Single-Family','Completely updated home with a private, sparkling pool and hot tub. Come view this single-story gem; 4 bed, 2 bath home with an open floor plan featuring high vaulted ceilings and plenty of natural light. Tile and granite throughout (no carpet) with stainless steel appliances; ready to move-in!! Amazing location with a short drive to the nearby schools, grocery stores, fine shopping, excellent restaurants, and a quick commute to IAH, Exxon Mobil, The Woodlands, Hardy Toll Road, Hwy 99, and I-45.','0.1446','15','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Spring Northeast','Central Gas','1','S517404 - FOX RUN 04, BLOCK 23, LOT 30','Subdivision Lot','6300','Appraisal District','','320','0','','2','Gas Oven','1','In Ground','','Gas Cooktop','','Composition','11 - Conroe','FORD ELEMENTARY SCHOOL (CONROE)','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Accompany,Supra Keybox','Appraisal District','1','Contemporary/Modern,Traditional','Fox Run 04','7623','2.8187','Public Sewer,Water District','1993','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','215853330','1675131928','215853330','2023-01-12T19:35:00.260','28600602','Maritza Renderos','HomeSmart','','','29.885051','-95.469500','21','77088','6','218000.00','Active','Hickory Forest','5503','Drive','Houston','2','0','3','1871','Single-Family','Come see this beautiful 1 story home! No Harvey issues here. Spacious floor plan, 3/2/2 is centrally located close to everything you need. Schools are just a few minutes away. Features a raised ceiling in the living room/dining room combo, fireplace, and tile flooring convenient in high traffic areas. Excellent for a family or investor. Call and make an appointment to view this home today!','0.1768','11','','','','','Mud,Sellers Disclosure','0','','1','Northwest Houston','Central Electric','1','LT 28 BLK 1 017*I5645955-004-001-028 INWOOD NORTH SEC 4','Subdivision Lot','7700','Appraisal District','','350','0','','2','','0','','','','','Composition','32 - Klein','NITSCH ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','KLEIN INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Inwood North Sec','5909','2.6485','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','215976199','1675131928','215976199','2023-01-12T19:24:10.913','52534204','Martha White','BHGRE Gary Greene','Diane Perry','Diane Perry','29.740490','-95.597758','42','77077','12','485000.00','Pending Continue to Show','Burgoyne','12211','Drive','Houston','3','1','5','3465','Single-Family','Gorgeous and impressive home in acclaimed Shadowbriar subdivision. Tons of natural light and soaring ceilings. Wonderful open flowing floorplan. Immense Family Room w/ stunning brick fireplace, builtins, windows. Gourmet Kitchen is breathtaking: immense granite island w/seating area, display area, updated SS appliances/cabintery,backsplash,pendant lighting,etc. Huge Primary suite w/ sitting area, 3 closets, updated spa bath. Secondary BR/office down. Gameroom up. Three additional BR\'s up w/ensuite & Hollywood baths. Bonus room /home office up. Great backyard and gated driveway. Ample parking and partying/play areas. This home has it all! Location, updates, size, bedrooms, stunning baths, a Gourmet Kitchen, open floorplan, and abundant natural light! Steps from the Community Center w/ sparkiling pool and Tennis courts. STUNNING!','0.1795','31','','','Electric Dryer Connections,Washer Connections','','Corporate Listing,Sellers Disclosure','1','Gas Connections','1','Energy Corridor','Central Gas,Zoned','1','LT 3 BLK 9 SHADOWBRIAR SEC 2','Subdivision Lot','7820','Appraisal District','','595','0','','2','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Contemporary/Modern,Traditional','Shadowbriar Sec 02','10001','2.3307','Public Sewer,Public Water','1983','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','216157730','1675131928','216157730','2023-01-12T19:12:18.467','36482495','Shannon Armstrong','Full Circle Texas, LLC','','','30.276224','-95.608038','23','77316','10','630000.00','Active','Connie','15644','Lane','Montgomery','3','1','4','3547','Single-Family','When you walk into the luxurious home you quickly notice all of the custom details that make it a desirable home. This property has extra amenities any homeowner would love to have. From the central vac to help keep it nice and clean. There\'s also 2 Carrier PGAP Germicidal Air Purifiers, excellent for anyone with allergies. \r\nYou just can\'t miss all the beautiful brick and lovely dark wood accents throughout. \r\nDon\'t miss your opportunity to come and check out this amazing home priced to sell quickly.','1.5','39','','','','','Sellers Disclosure','1','','1','Conroe Southwest','Central Gas','1','S539006 - GRAND LAKE ESTATES 06, BLOCK 3, LOT 17','In Golf Course Community','65340','Appraisal District','','845','0','','3','','0','','','','','Composition','37 - Montgomery','KEENAN ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Grand Lake Estates 06','7044','1.825','Aerobic,Public Water','2013','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','216226695','1675131928','216226695','2023-01-12T20:00:32.420','74924788','Alexis Walls Guillory','JLA Realty','','','30.134243','-95.316656','50','77365','7','459999.00','Active','Cascade Pass Court','21602','Court','Porter','2','0','3','2026','Single-Family','Perry Home in cul-de-sac! Barely lived in and move-in ready! Home is nestled right along the walking trail. Entry leads to an open family room with a wall of windows. The kitchen features an upgraded kitchen package. walk-in pantry and a generous island with built-in cabinet space. The dining area is set just across from the kitchen. The primary suite includes a wall of windows. Primary bath with dual vanities, garden tub, separate shower, and full custom walk-in closet with a built-in shoe shelf, 5 large drawers, and laundry hamper. Home office with French doors set at the back entrance. Secondary bedrooms feature walk-in closets. Laundry room with shelves. Double doors lead to an extended covered backyard patio with spray deck coating. Two-car garage, gutters in front only, sprinkler system, This home is located in The Highlands which will soon feature state-of-the-art amenities such as a golf course, water park, walking trails, parks + so much more!','0.1573','40','Perry Homes','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Porter/New Caney West','Central Electric','1','S582903 - THE HIGHLANDS 03, BLOCK 4, LOT 20','Cul-De-Sac,Greenbelt,In Golf Course Community,Subdivision Lot','6854','Appraisal District','','1420','0','','2','','0','','','Gas Cooktop','','Composition','39 - New Caney','ROBERT CRIPPEN ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WHITE OAK MIDDLE SCHOOL (NEW CANEY)','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','The Highlands','4060','','Water District','2022','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','216241113','1675131928','216241113','2023-01-12T19:54:11.837','54656638','Jose Lopez','HomeSmart','','','29.804255','-95.367651','9','77009','6','500000.00','Active','Moody','305','Street','Houston','1','0','3','1228','Single-Family','GREAT LOCATION !!! This property is located just a few minutes driving distance from downtown Houston; walking distance to The Heights\' neighborhood and walking distance to Metro Rail Station and bus transportation. It features 3 bedrooms and one bathroom with tile floors. The house is being offered \"AS IS\" with a extreme need for TLC, so bring all your house design ideas to explore alternatives.','0.1226','9','','','','','Sellers Disclosure,Special Addendum','0','','','Northside','Other Heating','0','LT 22 BLK 27 LINDALE PARK SEC 5','Other,Subdivision Lot','5340','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','JEFFERSON ELEMENTARY SCHOOL (HOUSTON)','NORTHSIDE HIGH SCHOOL','MARSHALL MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Ranch','Lindale Park Sec 05','5413','2.3307','Water District','1930','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','216334647','1675131928','216334647','2023-01-12T19:04:25.833','64837731','Michael Silva','Happen Houston','','','29.784380','-95.314517','15','77020','3','275000.00','Active','Sam Wilson','2421','Street','Houston','2','0','3','1468','Single-Family','Well-maintained single-family home featuring a studio apartment sitting on a 5000-square-foot lot! This property is an ideal rental property or opportunity to house hack by renting out the studio apartment. Both units are currently tenant-occupied. Rent rolls are available upon request.','','2','','','Washer Connections','','Sellers Disclosure','0','','','Denver Harbor','Central Gas','0','LT 1 BLK 15 CHEW F F','Subdivision Lot','5000','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','ATHERTON ELEMENTARY SCHOOL (HOUSTON)','WHEATLEY HIGH SCHOOL','MCREYNOLDS MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Chew F F','3487','2.3307','Public Sewer','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','216349622','1675131928','216349622','2023-01-12T20:49:52.380','19809117','Sunitha Repala','5th Stream Realty','','','29.683598','-95.619644','40','77083','4','349900.00','Active','Inglebrook','8803','Lane','Houston','2','1','4','2600','Single-Family','Here is a 4-bedroom home in a gated section and on a culdesac with no back neighbors. Great area with plenty of room for the kids to play and lots of parking space. It has been painted from top to bottom and looks like new. New kitchen backsplash, new carpet, new wood floors downstairs, new waterproof flooring in the bathrooms and laundry, new toilets, fans, lights, kitchen sink, mirrors, all faucets are new, door knobs, and much more. Has nice size rooms and a game room upstairs for the family to enjoy. There no other homes for sale in this section and people love living here and rarely homes become available. Show this home today and make it yours for years to come. Quick access to most areas from this great location. This home has too many great things to mention so bring your buyer and make an offer today.','0.1531','28','','','','','Sellers Disclosure','','','1','Alief','Central Gas','1','LT 19 BLK 2 CEDAR SPRINGS','Other','6670','Appraisal District','','50','0','','2','','0','','','','','Composition','2 - Alief','ALEXANDER ELEMENTARY SCHOOL (ALIEF)','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Other Style','Cedar Spgs','7037','2.593','Public Sewer,Public Water','2009','Appraisal District'); --> New record created successfully