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-09-04T16:32:27.907' ,`MLSNumber` = '64053568' ,`ListAgentFullName` = 'Shivani Bhatia' ,`ListOfficeName` = 'Soluna Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813517' ,`Longitude` = '-95.426821' ,`PhotoCount` = '32' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Ansbury' ,`StreetNumber` = '1411' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this this beautiful home in an established neighborhood close to Downtown and Galleria. Easy assess to I-610 and US-290. The house boasts a gorgeous entrance that soothes the eye. All rooms are placed methodically making it a very flowing and functional floor plan. House gets ample sunlight through well placed windows. The backyard is huge, fit to relax and entertain. Your perfect dwelling place with endless possibilities. Schedule a showing today!' ,`Acres` = '0.2617' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 300 BLK 16 SHEPHERD FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shepherd Forest' ,`TaxAmount` = '7139' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706766' WHERE `Matrix_Unique_ID` = '205940491' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T16:33:03.007' ,`MLSNumber` = '95231147' ,`ListAgentFullName` = 'Shivani Bhatia' ,`ListOfficeName` = 'Soluna Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887575' ,`Longitude` = '-95.294808' ,`PhotoCount` = '23' ,`PostalCode` = '77016' ,`RoomCount` = '5' ,`ListPrice` = '155000.00' ,`Status` = 'Active' ,`StreetName` = 'Gaston' ,`StreetNumber` = '6322' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! Conveniently located home close to shopping and dining, with easy access to HWY 59 and a quick commute to Central and North Houston.' ,`Acres` = '0.197' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 6 NORTHWOOD MANOR SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Manor Sec 02' ,`TaxAmount` = '2948' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706766' WHERE `Matrix_Unique_ID` = '205941530' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T16:22:59.403' ,`MLSNumber` = '4907907' ,`ListAgentFullName` = 'Jarred DeMore' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467185' ,`Longitude` = '-94.612061' ,`PhotoCount` = '32' ,`PostalCode` = '77650' ,`RoomCount` = '1' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Hwy 87' ,`StreetNumber` = '2570' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mixing business with pleasure... With endless potential! Want a PRIME commercial or residential location in the rapidly developing Crystal Beach area? It is a great Building to either renovate into a home again or keep it retail and get started with your dream! Currently set up as an eclectic beach decor retail store. Schedule your showing today. \r\n*Inventory that are in the photos is not included in the sale.' ,`Acres` = '0.1745' ,`Area` = '33' ,`BuilderName` = 'Homes By the Sea' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT A-13 HOLIDAY BEACH' ,`LotDesciption` = 'Other' ,`LotSize` = '7600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = 'Traditional' ,`Subdivision` = 'Holiday Beach' ,`TaxAmount` = '2405' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706766' WHERE `Matrix_Unique_ID` = '208569950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T16:36:43.917' ,`MLSNumber` = '17173890' ,`ListAgentFullName` = 'Mary Ellen Smith' ,`ListOfficeName` = 'Mary Ellen Smith Realty INC' ,`SellingAgentFullName` = 'Annamaria Wise' ,`SellingOfficeName` = 'Wise Choice Realty Group' ,`Latitude` = '29.443276' ,`Longitude` = '-94.655180' ,`PhotoCount` = '31' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '550000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Townsend' ,`StreetNumber` = '882' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION PRICE REDUCTION....VIEW TODAY...This beautiful Traditional Craftsmen Home is ready to enjoy and PRICE Reduced. Just a note, the pictures do not do justice to the beautiful tile. You need to come see that for yourself. Enjoy the remaining summer months and wonderful autumn months and then the years to come. This new home has beautiful wood-like vinyl floors, upgraded granite countertops and custom tile shower in the master bath. The guest bath has tub/shower with tiled surround. As you enter the house notice that the stairs are covered protecting you on rainy days and leading you to the large covered and uncovered deck. For easy maintenance and 360 views, the deck wraps around the house. The large louvered garage is perfect for your car and your beach toys. The home also has a louvered outdoor shower. Call your Realtor today to view so that you can move in and enjoy for wonderful autumn weather..' ,`Acres` = '0.1263' ,`Area` = '33' ,`BuilderName` = 'Traditional Craftsmn' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 438 EMERALD BEACH' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Emerald Beach' ,`TaxAmount` = '443' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706766' WHERE `Matrix_Unique_ID` = '209229346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T16:10:05.870' ,`MLSNumber` = '67315826' ,`ListAgentFullName` = 'Timothy Hutto' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796864' ,`Longitude` = '-94.927091' ,`PhotoCount` = '46' ,`PostalCode` = '77521' ,`RoomCount` = '11' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Nowlin' ,`StreetNumber` = '6211' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3279' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! The main house is 2,223 sq ft and has 4 bedrooms with 2.5 baths sitting on almost .4 acres. A big bonus is the guest house that could serve as a mother-in-law suite, man-cave/game room, or could be rented out for additional income. The guest house is 1,056 sq ft with a full kitchen, full bathroom and laundry room. New roof in 2020 and new floor through-out both houses in 2018. Hot tub stays with house! Schedule your showing today!' ,`Acres` = '0.373' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 2 CEDAR BAYOU PARK EAST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cedar Bayou Park East' ,`TaxAmount` = '6738' ,`TaxRate` = '2.3712' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706766' WHERE `Matrix_Unique_ID` = '210131066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T16:21:40.547' ,`MLSNumber` = '21724959' ,`ListAgentFullName` = 'Jarred DeMore' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.375434' ,`Longitude` = '-94.773702' ,`PhotoCount` = '22' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '184900.00' ,`Status` = 'Active' ,`StreetName` = 'Overton' ,`StreetNumber` = '524' ,`StreetSuffix` = 'Avenue' ,`City` = 'Port Bolivar' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor /rehab home. Everyone knows the Peninsula needs affordable and long-term housing for locals and employment force. This house needs rehab and is being sold (AS IS). it is spacious and has lots of potential. Call and schedule your showing today. House is a block away from ICWW, and a very short distance to the Ferry. Property sits on three lots. Property has a two-car garage as well as an attached one car garage. Check this one out.' ,`Acres` = '0.241' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 162 S PARR ALL OF LOTS 13-14-15 BL 140 PT BOLIVAR ACS .' ,`LotDesciption` = 'Corner,Other' ,`LotSize` = '10497' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Port Bolivar Townsite' ,`TaxAmount` = '3134' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706766' WHERE `Matrix_Unique_ID` = '210227203' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T17:16:13.967' ,`MLSNumber` = '49145095' ,`ListAgentFullName` = 'Tasha Royal' ,`ListOfficeName` = 'The Royal Agency' ,`SellingAgentFullName` = 'David Dancel' ,`SellingOfficeName` = 'NICOLE FREER GROUP' ,`Latitude` = '29.573548' ,`Longitude` = '-95.430765' ,`PhotoCount` = '22' ,`PostalCode` = '77584' ,`RoomCount` = '4' ,`ListPrice` = '430000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mooring Pointe' ,`StreetNumber` = '13603' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located in the prestigious Shadow Creek Ranch, this 2 story home features 4 bedrooms, 3 full bathrooms. 1 half bath, stunning kitchen with dark chocolate color cabinets, granite counters, expansive ceilings, cozy fire place, carpet and tile flooring, grand staircase with wrought iron spindles, large window that offers tons of natural sunlight, open concept, spacious primary suite, en suite with double vanities, freestanding soaker tub, separate shower, spacious secondary bedrooms, family/tv room on the second floor, and a ton of other fine finishes. All dimensions are approx., Buyer to verify room sizes & schools.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Shadow Creek Ranch SF-45A, BLOCK 4, Lot 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'shadow Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706766' WHERE `Matrix_Unique_ID` = '210881999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T17:27:09.050' ,`MLSNumber` = '74681185' ,`ListAgentFullName` = 'Shane Mylius' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Batool Naqvi' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`Latitude` = '30.079284' ,`Longitude` = '-95.495402' ,`PhotoCount` = '25' ,`PostalCode` = '77388' ,`RoomCount` = '7' ,`ListPrice` = '255000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Amorgas Isle' ,`StreetNumber` = '5014' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous three bedroom home with a two and a half bath is perfect for any family. Located in a convenient subdivision near the Grand Parkway, FM 2920, and I-45. Newly updated with new flooring, new backsplash in the kitchen, new paint and the list goes on! The family room is open to the breakfast area and kitchen, making entertaining a breeze. Large and spacious kitchen, with tile flooring throughout the first floor and fresh carpet on the second floor is clean, fresh and provides a cozy place for the kids to play or for guests to stay. The master bathroom has a separate shower and large tub, perfect for relaxing after a long day. This home also features very spacious rooms and walk-in closets, providing plenty of storage space. Don\'t miss your chance to own this amazing home! This home is a must see and a great price!' ,`Acres` = '0.1188' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 RHODES LANDING' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FOX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rhodes Landing' ,`TaxAmount` = '5692' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706767' WHERE `Matrix_Unique_ID` = '211312407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T16:18:52.597' ,`MLSNumber` = '17336192' ,`ListAgentFullName` = 'Jarred DeMore' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.457752' ,`Longitude` = '-94.623697' ,`PhotoCount` = '50' ,`PostalCode` = '77650' ,`RoomCount` = '11' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Vista' ,`StreetNumber` = '2134' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '1948' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller.\r\nJust steps from the Gulf... Out By The Sea was specifically designed and built as a B and B. There are three rooms located within the main house and three additional rooms on the property. Each of the rooms has its own private bath, plush amenities, satellite TV and privacy window shutters. The rooms are warm, inviting and designed with their own unique charm. \r\nThis property generates great revenue all year long per seller. Come see this unique and one of the only B and B\'s on the Peninsula. The 1948 Sqft is multiple structures. This home comes fully furnished and includes a 2016 gas Club Car six-seater golf cart and an 8000 watt Gentron generator. Pack your bags and come see this gem!' ,`Acres` = '0.3128' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 8 ALBERDIE ADDN NO 2***DEFERRAL***' ,`LotDesciption` = 'Other' ,`LotSize` = '13624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = 'Traditional' ,`Subdivision` = 'Alberdie Add 2 95' ,`TaxAmount` = '5783' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706767' WHERE `Matrix_Unique_ID` = '211591255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T16:18:13.707' ,`MLSNumber` = '81706516' ,`ListAgentFullName` = 'Jarred DeMore' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.459267' ,`Longitude` = '-94.622043' ,`PhotoCount` = '20' ,`PostalCode` = '77650' ,`RoomCount` = '1' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Meynig' ,`StreetNumber` = '910' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wanting your little piece of paradise without the huge expense? This precious bungalow is beach side of Hwy 87, just steps from the beach! This is perfect for a quick getaway or short-term rental! You\'ll enjoy the beautiful sunrise/sunset views from the deck! This is in the heart of Crystal Beach so close to restaurants, shopping, grocery store, etc! There are so many memories to be made here! One bedroom, one bath and open kitchen/living. 512 square feet of fun! The perfect canvas for you to throw in your special beach touch to make it your own. Just minutes to the ferry! The walls of windows offer so much natural light! Start making memories in this dollhouse! Quality construction with 2 x 6 studs!' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 3 LOT 75 MEYNIG ADDN' ,`LotDesciption` = 'Water View' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = 'Traditional' ,`Subdivision` = 'Meynig' ,`TaxAmount` = '1439' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706767' WHERE `Matrix_Unique_ID` = '211751621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T16:17:29.153' ,`MLSNumber` = '40259605' ,`ListAgentFullName` = 'Jarred DeMore' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.465591' ,`Longitude` = '-94.611604' ,`PhotoCount` = '45' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Surfside' ,`StreetNumber` = '946' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beach home dream come true! Whether you are wanting to have a rental investment or simply enjoy your weekends with family and friends, this house hits the mark. Nestled in a gated community (Surfside) on a very large lot this home has a lot of entertainment space to enjoy! This 3/2 gem is just a couple of minutes from the beach. Did someone say entertainment? Yes, enjoy your BBQ cooking and shrimp boils downstairs in the TIKI bar area or sit up top on the spacious deck with a Jacuzzi and enjoy views of the gulf. This home comes fully furnished and is a must see! Huge living room area, good size bedrooms and bunk beds for the kiddo\'s. Features granite countertops throughout, with stainless-steal appliance kitchen Pkg and so much more... This home is ready to go so schedule your appointment today! \r\n\r\n\r\n\r\n\r\nRecent updated include new water heater on 2020, new A/C unit in 2021 and fresh paint in the fall of 2021.' ,`Acres` = '0.5' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE ESTATES (2007) ABST 65, LOT 28, ACRES 0.5' ,`LotDesciption` = 'Other' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = 'Traditional' ,`Subdivision` = 'Surfside Ests' ,`TaxAmount` = '5298' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706767' WHERE `Matrix_Unique_ID` = '211751898' --> 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','212164764','1663706767','212164764','2022-09-04T17:27:50.140','87069605','Jon Skeele','Bayway Homes','Kathryn Klimczak','Coldwell Banker Realty','29.580494','-95.022003','6','77586','7','560000.00','Pending Continue to Show','Lake Mija','1512','Circle','Seabrook','3','0','4','3181','Single-Family','','0.4182','7','Bayway Homes, Inc.','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent','1','','','Clear Lake Area','Central Electric,Central Gas','1','LT 18 BLK 1 LAKE MIJA VILLAGE SEC 2','Subdivision Lot,Wooded','18215','Appraisal District','','600','1','To Be Built/Under Construction','2','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','9 - Clear Creek','BAY ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Appointment Required','Builder','2','Traditional','Lake Mija Vlg Sec 2','','2.2905','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212164921','1663706767','212164921','2022-09-04T17:28:13.620','82051451','Jon Skeele','Bayway Homes','Jon Skeele','Bayway Homes','29.579533','-95.019414','7','77586','7','465000.00','Pending Continue to Show','Lake Mija','1402','Court','Seabrook','3','1','4','2973','Single-Family','','0.2373','7','Bayway Homes, Inc.','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent','1','Gaslog Fireplace','1','Clear Lake Area','Central Electric,Central Gas','1','LT 3 BLK 2 LAKE MIJA VILLAGE','Corner,Wooded','10338','Appraisal District','','600','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','9 - Clear Creek','BAY ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Appointment Required','Builder','2','Traditional','Lake Mija Village','','2.2905','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212170027','1663706767','212170027','2022-09-04T17:49:39.480','50831909','Jonathan McNabb','Nest Ahead','','','29.864316','-95.282227','5','77016','4','244990.00','Active','Red Orchid','10022','Drive','Houston','2','0','3','1401','Single-Family','Brand new built BEAUTIFUL home! This home has a lot of extra space! The kitchen features granite countertops, brand-new stainless-steel appliances, and a spacious pantry. The home has a huge backyard great for entertaining. Come and schedule your tour!','','2','Starlight Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Northeast Houston','Central Electric','1','Wayside Village Section 6 Block 2 Lot 41','Subdivision Lot','','','','450','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Builder','1','Traditional','Wayside Village','','3.13','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','212179715','1663706767','212179715','2022-09-04T16:03:46.763','79060897','Priscilla Williams','Texcom Realty, Inc.','','','30.118813','-95.286625','44','77365','8','650000.00','Active','Cumbre','22860','Drive','Porter','2','1','4','2653','Single-Family','2 Acres! Four bedrooms, two and a half baths with a large screened rear patio make this a beautiful place to call home. There are several possibilities for a flex room in lieu of a fourth bedroom if desired. Beautiful landscaping and corner location are just a few things that set this home apart from most: three car garage and three carports attached to a covered breezeway into the screened patio.','2.02','40','Tilson','','Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Porter/New Caney West','Central Electric','1','RIVERWALK 02, BLOCK 3, LOT 13,14','Cleared,Corner,Wooded','87991','Appraisal District','','750','0','','3','Single Oven','0','','','Gas Range','','Composition','39 - New Caney','SORTERS MILL ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WHITE OAK MIDDLE SCHOOL (NEW CANEY)','Appointment Required','Appraisal District','1','Traditional','Riverwalk 02','8251','2.1331','Aerobic,Septic Tank','2000','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','212181041','1663706767','212181041','2022-09-04T17:50:03.473','38108528','Jonathan McNabb','Nest Ahead','','','29.864305','-95.282215','5','77016','4','249990.00','Active','Red Orchid','10018','Drive','Houston','2','0','3','1412','Single-Family','Brand new built BEAUTIFUL home! This home has a lot of extra space! The kitchen features granite countertops, brand-new stainless-steel appliances, and a spacious pantry. The home has a huge backyard great for entertaining. Come and schedule your tour!','','2','Starlight Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Northeast Houston','Central Electric','1','Wayside Village Section 6 Block 2 Lot 42','Subdivision Lot','','','','450','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Builder','1','Traditional','Wayside Village','','3.13','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','212181097','1663706767','212181097','2022-09-04T17:58:16.680','90817600','Jonathan McNabb','Nest Ahead','','','29.864305','-95.282215','5','77016','4','256990.00','Active','Red Orchid','10014','Drive','Houston','2','1','3','1605','Single-Family','Brand new built BEAUTIFUL home! This home has a lot of extra space! You will enjoy a loft space on the second floor. The kitchen features granite countertops, brand-new stainless-steel appliances, and a spacious pantry. The home has a huge backyard great for entertaining. Come and schedule your tour!','','2','Starlight Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Northeast Houston','Central Electric','1','Wayside Village Section 6 Block 2 Lot 43','Subdivision Lot','','','','450','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Builder','2','Traditional','Wayside Village','','3.13','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','212181119','1663706767','212181119','2022-09-04T17:57:59.037','2639236','Jonathan McNabb','Nest Ahead','','','29.864305','-95.282215','7','77016','4','266990.00','Active','Red Orchid','10010','Drive','Houston','2','1','3','1826','Single-Family','Brand new built BEAUTIFUL home! This home has a lot of extra space! You will enjoy a loft space on the second floor. The kitchen features granite countertops, brand-new stainless-steel appliances, and a spacious pantry. The home has a huge backyard great for entertaining. Come and schedule your tour!','','2','Starlight Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Northeast Houston','Central Electric','1','Wayside Village Section 6 Block 2 Lot 44','Subdivision Lot','','','','450','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Builder','2','Traditional','Wayside Village','','3.13','Water District','2022','Builder'); --> New record created successfully