Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T05:29:29.897' ,`MLSNumber` = '35222719' ,`ListAgentFullName` = 'Jennifer Flud' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.565390' ,`Longitude` = '-95.114670' ,`PhotoCount` = '19' ,`PostalCode` = '77062' ,`RoomCount` = '6' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Bonanza' ,`StreetNumber` = '1715' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO MORE SHOWINGS. AN OFFER HAS BEEN ACCEPTED. WE ARE WAITING ON RELO TO SIGN PAPERWORK. Located in the quiet, beautiful neighborhood of Clear Lake City, this one-story home offers wood tile floors in the living room, kitchen and dining area. The remodeled kitchen has ample cabinet and counter space with a breakfast bar. The dining room is open to the spacious living area with a great view of the backyard. The large primary bedroom has 3 closets, a sitting area and also offers bench seating. The jumpers at each outlet have been replaced. The backyard has a covered patio with plenty of space for the kids to play. No flooding!' ,`Acres` = '0.1928' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 85 BLK 16 CLEAR LAKE CITY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '68' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Clear Lake City Sec 02' ,`TaxAmount` = '5130' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789538' WHERE `Matrix_Unique_ID` = '208094469'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T05:42:37.610' ,`MLSNumber` = '32831310' ,`ListAgentFullName` = 'Mary Frances DuMay' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736908' ,`Longitude` = '-95.409754' ,`PhotoCount` = '20' ,`PostalCode` = '77098' ,`RoomCount` = '13' ,`ListPrice` = '899900.00' ,`Status` = 'Active' ,`StreetName` = 'Branard' ,`StreetNumber` = '2044' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE THIS SATURDAY OCTOBER 29th 3:30PM-5pm. AMAZING NEW PRICE UNDER $900K!!! Remarkably renovated Montrose residence steps to Upper Kirby\'s shopping and dining District, Trader Joe\'s, Target and grocery stores. Traditional floor plan flows seamlessly in a circular direction downstairs. This is a comfortable home for simple living and ease of entertaining. Great-looking red oak hardwood floors all three levels [except for the sunroom & full bathrooms] Need a full bath downstairs? The laundry room can easily be reconfigured to include a shower [estimate available - under $30K total]. Timeless finishes in quartz and marble complement this light-filled residence featuring floor-to-ceiling double pane windows* The primary suite has tree top views plus a ginormous-sized closet. Third floor includes the 4th bedroom plus a bonus room with a glimpse of downtown Houston! Lush backyard and huge deck. Plenty of room for a new pool! Also available for lease [minimum six months]. *Per Seller' ,`Acres` = '0.1435' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 2 DEARBORN PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Controlled Access,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dearborn Place' ,`TaxAmount` = '19271' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789538' WHERE `Matrix_Unique_ID` = '213693544'  --> Updated record success<br />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','213737488','1666789539','213737488','2022-10-26T05:47:50.433','31502495','Jared Turner','Turner Mangum,LLC','','','29.700218','-95.873959','44','77441','12','1300000.00','Active','Walton Water Way','123','Lane','Fulshear','3','2','4','5185','Single-Family','Gorgeous custom Kickerello home situated within the gated section of Cross Creek Ranch. Upon entering you will be captivated by the soaring ceilings, an open luxurious living room, and floor-to-ceiling windows across the back of the home. The gourmet kitchen has beautiful wood cabinetry, granite countertops, SS Wolf appliances, and an oversized center island. The adjacent family room is perfect for relaxing or entertaining while taking in that spectacular view. Prepare to fall in love with the Owner\'s Suite featuring tall tray ceilings, floor-to-ceiling windows (there\'s that view again), and an en-suite bath with dual sinks, soaking tub, and 2 spacious closets. Upstairs you will find 3 bedrooms, 2 baths, and a Gameroom with access to an expansive balcony and sitting area. Following the stairs down from your balcony, you enter your very own private backyard paradise complete with jaw-dropping views of the majestic lake and fountain, pool, spa, half bath, shower, and outdoor kitchen.','0.2879','30','Kickerillo','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','2','Katy - Southwest','Central Gas,Zoned','1','LAKES OF CROSS CREEK RANCH SEC 2, BLOCK 2, LOT 11','Subdivision Lot,Water View,Waterfront','12539','Appraisal District','','2250','0','','3','Convection Oven,Double Oven','1','Gunite,In Ground','','Gas Cooktop','','Tile','33 - Lamar Consolidated','HUGGINS ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal','2','Mediterranean,Traditional','Lakes Of Cross Creek Ranch Sec 2','25529','3.3362','Public Sewer,Public Water,Water District','2010','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T05:57:36.410' ,`MLSNumber` = '64907477' ,`ListAgentFullName` = 'Heather Chavez' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292397' ,`Longitude` = '-95.554776' ,`PhotoCount` = '41' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Lochvale Peak' ,`StreetNumber` = '308' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely stunning Alabaster II plan by Lennar home located on oversized lot in a cul-de-sac. This 2 story 4 bedroom, 3.5 bath, 2 car garage features the primary bedroom and 2nd bedroom downstairs! 2 bedrooms with game room upstairs. Island kitchen with 36\" designer cabinets, granite countertops and stainless steel appliances. Primary suite with luxurious bathroom. Extensive 6\"x\"24 floor tile, 2\" faux wood blinds, ceiling fans, Energy efficient 16 seer HVAC systema & Honeywell Smart thermostat, radiant barrier roof. Backyard is ready for entertaining with its covered patio and ample room for pool. Zoned to Conroe ISD! The Woodforest community has all the amenities!! Parks & trails, Forest Island Pools, Stamped Sportsplex, Woodforest Golf Club and Pine Market!!' ,`Acres` = '0.2683' ,`Area` = '39' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965276 - WOODFOREST 76, BLOCK 1, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11687' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 76' ,`TaxAmount` = '11020' ,`TaxRate` = '2.8388' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789539' WHERE `Matrix_Unique_ID` = '213754395'  --> Updated record success<br />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','213980410','1666789539','213980410','2022-10-26T04:32:25.840','53014013','Jannett Flores','JLA Realty','','','29.172246','-94.994103','34','77554','7','725000.00','Active','Shaman','18115','Drive','Galveston','2','0','4','2010','Single-Family','Great opportunity in Galveston!  Whether you’re looking for an investment opportunity, great weekend getaway or quiet place to live, this fully furnished 4/2 beach house in Indian Beach Subdivision is the place for you. It’s open concept kitchen/dining/living room & breakfast bar with seating for 6 is great for entertaining.  It has high vaulted ceilings, crown molding, engineered wood flooring, granite counters & stainless-steel appliances. Home sits on almost 1/2 an acre with lush tropical landscaping, fully fenced yard, palapa, Jacuzzi tub & great views of the beach & bay from private covered porch off the master bedroom.  It sleeps 14 & is a short walk/golf cart ride to the beach, community pool, tennis court & fishing pier.  Currently in Ryson Vacation Rental program as \"Beach Retreat\"; 2020 Gross Rental Income=$49,034, 2021 GRI=$58,775 and as of 10/19/22 GRI has been $44,900. Home is ready for you to enjoy island life to the fullest and ready to entertain! All furniture included','0.483','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','West End','Central Electric','1','ABST 121 HALL & JONES SUR LOT 16 BLK 3 INDIAN BEACH SEC 3','Subdivision Lot,Water View','21039','Appraisal District','','338','0','','0','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Lockbox Front,Request Online Appointment','Builder','1.5','Traditional','Indian Beach 3','8841','2.0324','Public Water,Septic Tank','2006','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T04:06:53.500' ,`MLSNumber` = '66263669' ,`ListAgentFullName` = 'Sergio De La Llata Jr.' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563715' ,`Longitude` = '-95.559769' ,`PhotoCount` = '8' ,`PostalCode` = '77459' ,`RoomCount` = '4' ,`ListPrice` = '100000.00' ,`Status` = 'Active' ,`StreetName` = 'Summit' ,`StreetNumber` = '3514' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2265' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Multiple Offers** Come take a look at this fully remodeled home with 2,265 sq ft of living space including 4 bedrooms, 2 full baths, an extraordinary living room, and enchanting kitchen. You cannot go wrong with the backyard; this one has a pool! Amazing for any family gatherings in the summer that call for cooling off. Easy access to Highway 6 and I-69. You do not want to miss out on this one, schedule your private tour now!' ,`Acres` = '0.2263' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL VALLEY THUNDERBIRD W SEC 1, BLOCK 8, LOT 24' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9857' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '439' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'QUAIL VALLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Quail Vly Sub Thunderbird West' ,`TaxAmount` = '5435' ,`TaxRate` = '2.34' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789539' WHERE `Matrix_Unique_ID` = '213999903'  --> Updated record success<br />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','214033330','1666789539','214033330','2022-10-26T05:32:49.027','37835241','Phillip Collins','eXp Realty, LLC','','','30.287135','-94.810452','30','77327','1','135000.00','Active','Cypress Lakes','4484','Circle','Cleveland','1','0','1','363','Single-Family','Nowhere else can you find 2,000 acres of natural environment featuring 5 fishing lakes, over a mile of sandy beaches, an equestrian center, miles of hiking & biking trails and recreational activities for all ages. All enhanced by a sunny, warm Texas climate that lets you enjoy the outdoors all year long. Large outdoor pavilion & meeting area Pet friendly with on-site dog park.  BBQ stations, picnic area & fire pits. Swimming pools. Private gated entrance. 2,000 acres of resort property, Children’s putt-putt course and Splash pad. Five fishing lakes. 1.2 miles of white sandy beach. Natural Bayous, lakes & wildlife. Walking, hiking & biking trails. Over two miles of riverfront property Get away from it all, without being TOO far. Just an hour from Houston or Beaumont. This site includes 2016 40ft PUMA RV with all the extras. Stackable washer and dryer, full size fridge and stove, and fire place. There is a fully covered screened porch.  Come to your perfect get a way home','0.3635','52','','','','','Sellers Disclosure','','','','Liberty County East','Central Electric,Central Gas','1','CYPRESS LAKES, BLOCK 8 UNIT 2, LOT 471, MH LABEL# TRAVEL TRA','Subdivision Lot,Water View,Waterfront','15832','Appraisal District','','1500','0','','0','','0','','','','','Aluminum','102 - Tarkington','TARKINGTON PRIMARY SCHOOL','TARKINGTON HIGH SCHOOL','TARKINGTON MIDDLE SCHOOL','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Other Style','Cypress Lakes','608','1.5309','Septic Tank','2011','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T05:53:45.203' ,`MLSNumber` = '28408671' ,`ListAgentFullName` = 'Heather Chavez' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.601559' ,`Longitude` = '-95.559110' ,`PhotoCount` = '50' ,`PostalCode` = '77340' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Remington' ,`StreetNumber` = '162' ,`StreetSuffix` = 'Road' ,`City` = 'Huntsville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2870' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The country is calling! Beautiful single-story home located on a prime 2+ acre lot in the highly desirable community of Texas Grand Ranch. Features 3 spacious bedrooms, study, 3 1/2 bathrooms, split 3 car garage. The entry opens up to expansive living area w/ tall ceilings, wood beam details, kitchen is upgraded with stainless steel appliances, Bosch double ovens, 5 burner gas range and dishwasher. Granite countertops with breakfast bar, under cabinet light and composite granite sink! Don\'t miss all that storage on the island! Massive laundry room with storage cabinetry & extra-large pantry. Cat crawl space leads to living area. Study w/French doors. Levitan smart switches, tile wood floors throughout living, kitchen, study, 1/2 bath & breakfast area. Large, covered patio, gas stub out, hot tub. and check out that view, so many trees! 1 bay garage is a shop & the 2 car bay has built-in storage. Whole house generator! NO MUD, NO Flooding, LOW taxes, Surrounded by National & State Forest' ,`Acres` = '2.296' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'I TEXAS GRAND RANCH PHASE 2, BLOCK 6, LOT 78, ACRES 2.296' ,`LotDesciption` = 'Wooded' ,`LotSize` = '100014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'I Texas Grand Ranch Ph 2' ,`TaxAmount` = '11207' ,`TaxRate` = '1.6942' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789539' WHERE `Matrix_Unique_ID` = '214045515'  --> Updated record success<br />