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-01T08:36:05.990' ,`MLSNumber` = '14103040' ,`ListAgentFullName` = 'Sandra Dial' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444113' ,`Longitude` = '-94.654709' ,`PhotoCount` = '16' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Gulfview' ,`StreetNumber` = '878' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO BOLIVAR: Outstanding features of this Beach House: Located Beach Side of Bolivar, NOT crowded by neighboring house, Extra-large Deck on front and the seaward side of House. Large Living Room with Fireplace, Open concept to Kitchen, Large utility room connected to kitchen. Brand New Refrigerator, Dishwasher & Microwave. Ground level Concrete with lots of room to entertain. The neighborhood offers direct Drive-onto Beach access, Close to a Restaurant, Gas Station, Convenience Store. This beach House is waiting for YOU to Make it YOUR Beach Escape. Call Today for Your Showing Appointment.' ,`Acres` = '0.3789' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOTS 354 & 355 (354-0) EMERALD BEACH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Emerald Beach' ,`TaxAmount` = '5602' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086030' WHERE `Matrix_Unique_ID` = '208120750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T07:39:47.207' ,`MLSNumber` = '17816271' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.197231' ,`Longitude` = '-96.022577' ,`PhotoCount` = '25' ,`PostalCode` = '77445' ,`RoomCount` = '3' ,`ListPrice` = '279680.00' ,`Status` = 'Active' ,`StreetName` = 'Quail' ,`StreetNumber` = '38154' ,`StreetSuffix` = 'Drive' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW, one story, 3 bedroom, 2 bath, 1,750 square foot home on A QUARTER ACRE LOT! This home features an open floor plan in the kitchen/living room/dining. High ceilings, granite countertops, stainless steel appliances, spacious primary bed/bath, garden tub, glass encased shower, his/her vanities. Large windows for abundant natural light throughout. Deerwood amenities include Lakes, HUGE Park, Pool & clubhouse. Hempstead has fine schools, parks, and a low cost of living/family friendly area with country style living.' ,`Acres` = '0.2755' ,`Area` = '26' ,`BuilderName` = 'Freedom Star' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S455200 DEERWOOD LAKES 2 LOT 246' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '12001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Deerwood Lakes 2' ,`TaxAmount` = '352' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086030' WHERE `Matrix_Unique_ID` = '214204042' --> 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','214561176','1675086030','214561176','2022-12-01T08:04:09.087','78652042','Tracie Dillon','Realty Associates','','','29.925574','-95.567030','32','77064','5','250000.00','Active','Strawgrass','9606','Drive','Houston','2','0','3','1613','Single-Family','Welcome home! Adorable single-story residence with a 2-car side garage and a grassy front yard. Enjoy your morning coffee in the spacious courtyard! The beautiful interior greets you with a large living room boasting a fireplace perfect for receiving guests and a formal dining room for making a feast. Cook delicious recipes in the galley kitchen, including built-in appliances, wood cabinets, a pantry, and plenty of counter space. The roomy primary bedroom can fit all your furniture and offers two closets w/mirrored sliding doors and a private ensuite w/dual sinks. Other great features are vaulted ceilings, wood-look & tile floorings, neutral palette, and gorgeous light fixtures. After a busy day, relax in the grassy backyard with a covered patio and lovely pavers. Must see to appreciate!','0.1495','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Willowbrook South','Central Gas','1','LT 26 BLK 1 HARVEST BEND THE MEADOW 1 R/P','Subdivision Lot','6513','Appraisal District','','475','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','WILLBERN ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Harvest Bend Meadow 01 R/P','4477','2.5587','Water District','1984','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T08:09:18.363' ,`MLSNumber` = '62574492' ,`ListAgentFullName` = 'Susanne Mullen-Spencer' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '21.203864' ,`Longitude` = '-86.714073' ,`PhotoCount` = '44' ,`PostalCode` = '77409' ,`RoomCount` = '8' ,`ListPrice` = '3825000.00' ,`Status` = 'Active' ,`StreetName` = 'FRACC MAR TURQUESA GARRAFON' ,`StreetNumber` = '0' ,`StreetSuffix` = '' ,`City` = 'Isla Mujeres' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Relax in ultimate luxury in this magnificent modern-contemporary 5 bed/5 bath ocean front private residence and separate guest casita. A uniquely positioned, architectural delight boasts elegantly designed interiors located in Punta Sur on idyllic Isla Mujeres. Situated on most Eastern point Mexico surrounded by 360 degrees turquoise waters. The home & stunning roof top deck provides unparalleled tranquility and breathtaking vistas. Floor/ceiling windows bring an abundance of natural light. Luxury outdoor living area, dining al fresco, sparkling infinity pool & spacious sundeck defines outdoor opulence. American gourmet kitchen with open plan concept complete turnkey property. A custom CanAm Commander with sale. An exclusive property guaranteed to satisfy the most discerning buyer offers an impressive investment portfolio of strong vacation rentals. Management company in place. Recently fully renovated in 2021/22 this exclusive property boasts the best views the Caribbean has to offer.' ,`Acres` = '' ,`Area` = '' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 GARRAFON FRACC. MAR TURQUESA ISLA MUJERES, Q.R. C.P.' ,`LotDesciption` = 'Cleared,Other,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'MAR TURQUESA SM9 M35' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675086030' WHERE `Matrix_Unique_ID` = '214930958' --> 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','215179462','1675086031','215179462','2022-12-01T08:45:10.010','29229946','Sherry Bruno','Lake Area Homes, Bruno Realty, LLC','','','30.738755','-95.210464','31','77364','6','225000.00','Active','Governor Wood','360','Drive','Point Blank','2','0','3','2189','Single-Family','Pretty Austin Stone home that has been recently updated. This 3/2 ranch style home has a gameroom/workshop, & large covered area. Huge Livingroom/Dining area. Open concept with Livingroon /Kitchen open to dining. Kitchen has tons of cabinets, with beautiful built in. Septic recently replaced, small A/c replaced, roof @5-6 yrs old. Three big bedrooms, w/large closets. Septic system replaced, @ 5-6 yr roof, & one A/C replaced . Beautiful 4 lots in nice subdivision w/many trees. Subdivision has pool, park, boat ramp, & trailer storage area. Don\'t Miss!!!','0.6773','64','','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','0','Lake Livingston Area','Central Electric','1','GOVERNORS POINT #1, BLOCK 1, LOT 26 - 29, ACRES .6773','Subdivision Lot','29503','Appraisal District','','225','0','','2','Electric Oven','0','','','Electric Range','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Governors Point #1','2871','1.5516','Aerobic,Public Water','1970','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215226506','1675086031','215226506','2022-12-01T07:09:55.253','65734778','Cyndi Kornegay','Gatehouse Properties','','','29.950201','-95.780228','6','77433','8','628736.00','Active','Cosmopolitan','11351','Drive','Cypress','4','0','4','2650','Single-Family','This stunning 1-story home has it all! Boasting 14-foot ceilings in the family room and kitchen, the open-concept design is ideal for hosting family and friends. Throughout the home flows, beautiful wood floors flow to the main areas of the home. The gourmet kitchen is a chef’s dream and is equipped with an oversized island, built-in stainless-steel appliances, and a vent hood. Gorgeous sliding glass doors in the family room allow for abundant natural light. Relax outdoors on the back-covered patio featuring a spacious backyard with no back neighbors. Take entertaining to the large game room for game or movie nights. Complete with a 3-car garage, you do not want to miss out on this home!','','25','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','1','Cypress South','Central Gas','1','Lot 13 Block 1','Greenbelt','8422','Survey','','1200','1','To Be Built/Under Construction','3','Single Oven','0','','','Gas Cooktop','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Contemporary/Modern,Traditional','Bridgeland','','3.52','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully