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-18T07:13:01.773' ,`MLSNumber` = '53165271' ,`ListAgentFullName` = 'Trinika Chachere' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.317268' ,`Longitude` = '-95.457249' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeland' ,`StreetNumber` = '939' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Custom New Construction on 1 Acre Lot! Located in The Oaks at Suncreek Estates, country feel with the convenient to 288 and Hwy 6. Put an Offer in Now and select from paint colors to countertops, and flooring from builder\'s selection. This Gorgeous Custom Built Home with 4 bedrooms, 3.5 bathrooms with a Grand Open Concept Kitchen and Family Room Area. Amazing fixtures and finishes. High ceiling and Grand Entrance. Oversized Master Bedroom and Bathroom made to wow with 2 primary closets. Natural light shines throughout the home with views of the acreage lot. Built with a Large Outdoor Kitchen with Grill and Sink. This home is built for entertaining, built as your 1st or last home. Come and Drive by Your Dream Home!' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = 'Baker\'s Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'THE OAKS AT SUNCREEK ESTATES (A0067 & A0068 & A0069) BLK 3 L' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Oaks At Suncreek Estates' ,`TaxAmount` = '755' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663712029' WHERE `Matrix_Unique_ID` = '205202295' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T06:43:00.960' ,`MLSNumber` = '28435524' ,`ListAgentFullName` = 'Jay Thomas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042237' ,`Longitude` = '-95.368969' ,`PhotoCount` = '31' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '222900.00' ,`Status` = 'Active' ,`StreetName` = 'Algernon' ,`StreetNumber` = '4106' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION- LOCATION- LOCATION! Situated in the quiet community of Sandpiper, this 3-bedroom, 2-bathroom property features high ceilings, a brick fireplace in the living room, dining room, and a breakfast bar in the kitchen. New roof, new electrical panel box, newly remodel master bathroom, new flooring, new appliances, new exterior fencing, new interior and exterior paint. The spacious backyard is great for gatherings or just relaxing. Located near the Hardy Toll Road, residents enjoy easy access to Downtown and The Woodlands. Spend a quiet day exploring all that Spring has to offer, including the Mercer Botanic Gardens, Cypress Creek Trail, Cypresswood Golf Club, and Old Town Spring. Schools are zoned to Spring ISD. Don’t miss this home – call today!' ,`Acres` = '0.1515' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 1 SANDPIPER SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sandpiper Sec 01' ,`TaxAmount` = '4157' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712029' WHERE `Matrix_Unique_ID` = '207695862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T07:15:12.610' ,`MLSNumber` = '70540008' ,`ListAgentFullName` = 'Kassi Foster' ,`ListOfficeName` = 'C 4 Realty LLC.' ,`SellingAgentFullName` = 'Fernando Miquilarena' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '30.166270' ,`Longitude` = '-95.433401' ,`PhotoCount` = '50' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '499899.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Chateau Woods Parkway Dr' ,`StreetNumber` = '424' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2103' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Roof being replaced by owner!!! FABULOUS HOME IN LAKE CHATEAU WOODS! Close to shopping, restaurants, and the Grand Parkway. This home is light, bright and beautifully updated with neutral colors. The primary bedroom has a wonderful walk in shower. \r\nThe garage on the main home was converted to a home office or it would make a great game room, another family room, etc. You will love the kitchen with the granite countertops and cabinets galore. The garage apartment has a kitchen, family room, two bedrooms and a private bath upstairs. The downstairs can be another family room, game room or office as well as another bathroom. Then the backyard is perfect for entertaining with a sparkling pool, huge covered back porch and an outdoor kitchen. You will also have more parking than you can imagine with a corner lot as a plus. Come and enjoy the beautiful home!' ,`Acres` = '0.5888' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE CHATEAU WOODS 02, BLOCK 4, LOT 7-A, 7-B' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '25650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Chateau Woods 02' ,`TaxAmount` = '10240' ,`TaxRate` = '2.1802' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663712029' WHERE `Matrix_Unique_ID` = '209523349' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T07:43:09.247' ,`MLSNumber` = '8646391' ,`ListAgentFullName` = 'Drue DaSilva' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.931816' ,`Longitude` = '-95.262490' ,`PhotoCount` = '50' ,`PostalCode` = '77396' ,`RoomCount` = '12' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Bough' ,`StreetNumber` = '14726' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 1.5-STORY home on an OVER-SIZED LOT on a shaded CUL-DE-SAC street in fabulous Fall Creek. ALL BEDROOMS and 3 of the 4 FULL BATHS are DOWNSTAIRS. The MASSIVE GAME ROOM UP with a 4TH FULL BATH is perfect for a 5TH BEDROOM. The home features a formal dining and study flanking the entry and an open floor plan with a spacious family room and kitchen. Standout details include the high ceilings, bay windows, French doors, large tile, crown molding and built-in desk by the kitchen. The primary bath features dual sinks, jetted tub, separate shower and spacious walk-in closet. The very private and well-manicured backyard has lovely landscaping, a covered porch with stamped-concrete patio extension and plenty of yard space. The 3-car attached tandem garage with storage has epoxy floors. Fall Creek is a master-planned community near IAH, downtown, 59 and Bltwy8 and has wonderful amenities such as lakes, parks & trails, water park & lap pool, golf, tennis, sports complex & Farmers Market.' ,`Acres` = '0.287' ,`Area` = '1' ,`BuilderName` = 'Emerald Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 3 FALL CREEK SEC 3' ,`LotDesciption` = 'Cleared,Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '12501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FALL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Creek' ,`TaxAmount` = '10424' ,`TaxRate` = '3.0832' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712029' WHERE `Matrix_Unique_ID` = '209826658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T06:18:42.670' ,`MLSNumber` = '7033140' ,`ListAgentFullName` = 'Marisol Villa' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = 'Faraad Mohamed' ,`SellingOfficeName` = 'Texas Signature Realty' ,`Latitude` = '29.768021' ,`Longitude` = '-95.769708' ,`PhotoCount` = '27' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '335000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cascade Creek' ,`StreetNumber` = '1130' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2388' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this gorgeous updated Cimarron house offering 4 bedrooms, 2.5 bathrooms & attached two car garage.Fresh paint throughout, beautiful wood-look tiled floors downstairs. Plantation shutters throughout. Kitchen has been updated with granite countertops. Master bath & guest bath are renovated with quarts granite counter tops and under-mounted sinks. Family room has fireplace with shelving on either side. Large sized backyard. Close access to the Grand Parkway and I-10 and Cinco Ranch Golf Course. Enjoy all the community amenities - pool, tennis court and playground. Zoned to highly rated KISD schools, close to shopping/dining.' ,`Acres` = '0.1604' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 28 CIMARRON SEC 9 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '462' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimmaron Sec' ,`TaxAmount` = '5313' ,`TaxRate` = '2.3833' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663712030' WHERE `Matrix_Unique_ID` = '210409585' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T07:21:48.563' ,`MLSNumber` = '26422565' ,`ListAgentFullName` = 'Kellie Olson' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = 'Debbie Miali' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.543562' ,`Longitude` = '-95.681167' ,`PhotoCount` = '26' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '345000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cherry Brook' ,`StreetNumber` = '7502' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2361' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Great Wood Subdivision. This spacious 1-story with open floor plan offers high ceilings, formal living, and dining, a gourmet kitchen with an island, breakfast bar, and breakfast area opens to the oversized den with a gas fireplace and an abundance of windows for plenty of natural light Office/flex room with french doors. The primary suite offers high ceilings, a sitting area, two closets, separate sinks, a vanity, jetted tub, separate shower. Covered back patio, large trees, and No back neighbors.' ,`Acres` = '0.1611' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD CROSSING SEC 2, BLOCK 4, LOT 5' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '7017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'DICKINSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Crossing' ,`TaxAmount` = '6212' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712030' WHERE `Matrix_Unique_ID` = '210422628' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T07:59:03.863' ,`MLSNumber` = '73987477' ,`ListAgentFullName` = 'David Young' ,`ListOfficeName` = 'Blue Dahlia Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744877' ,`Longitude` = '-95.403955' ,`PhotoCount` = '47' ,`PostalCode` = '77019' ,`RoomCount` = '8' ,`ListPrice` = '1095000.00' ,`Status` = 'Active' ,`StreetName` = 'Elmen' ,`StreetNumber` = '2322' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What you\'ve been waiting for... this exemplary Montrose home is now available. This corner lot, 3 bedroom, 3 full bath house was taken down to the studs in 2014 and rebuilt to maintain it\'s original character and charm. Many of the original design elements were kept including custom milled window, door and baseboard moulding. Original freshly refinished hardwood floors throughout! No carpet, the remodeled kitchen and bathrooms have designer tile to reflect the home\'s charm. The pier and beams were reinforced with structural steel, the first floor has a moisture barrier, superior insulation throughout the house, the attic too with 6-8 inches of spray foam... and, the house has never flooded. New electrical wiring, new plumbing, new LowE windows, ecofriendly countertops, and Solatubes upstairs for natural light. Bright flex space at the top of the stairs. For the car enthusiast, a stand alone 700 sq. ft. garage with car lift. Please see attached list of all property upgrades on Docs tab.' ,`Acres` = '0.1148' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 10 PLAINVIEW SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plainview Sec 01' ,`TaxAmount` = '16585' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712030' WHERE `Matrix_Unique_ID` = '211161173' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T07:47:18.033' ,`MLSNumber` = '16107846' ,`ListAgentFullName` = 'Shary Luthe' ,`ListOfficeName` = 'Home Sweet Home Realty, LLC' ,`SellingAgentFullName` = 'Erica Post' ,`SellingOfficeName` = 'CENTURY 21 Western Realty' ,`Latitude` = '29.793421' ,`Longitude` = '-95.383346' ,`PhotoCount` = '30' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '475000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pizer' ,`StreetNumber` = '916' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1090' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated On A Picturesque Lot In The Historic Heights In East Norhill, This 1920\'s Bungalow Has Historic Charm And Is Ready To Be Brought Up To Its Full Glory. This Is A Rare Opportunity That The Historic Heights Rarely Sees. This 2 Bedroom/ 1 Bath Home Features A 2 Car Garage Which Is A Rare Find. Right Off The Primary Bedroom, There Is A Small Study/Office To Give Extra Space. The Original Hardwood Floors Are Ready To Be Reclaimed. Walking Distance To Lights In The Heights, White Linen, Houston Farmer\'s Market, Restaurants, Coffee Shops And Local Pubs. No HOA! This Is Your Opportunity To Get Into One Of Houston\'s Most Desirable Areas!' ,`Acres` = '0.1194' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 212 EAST NORHILL' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'East Norhill' ,`TaxAmount` = '8668' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1926' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712030' WHERE `Matrix_Unique_ID` = '211239628' --> 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','211430841','1663712030','211430841','2022-09-18T07:59:23.083','81479197','Marie Davis','Century 21 Realty Partners','','','30.131714','-95.522752','50','77389','9','644900.00','Active','Carrick Bend','25211','Drive','Spring','3','1','4','4111','Single-Family','If you love to entertain, this home is for you! This fantastic open floorplan is filled with natural light for a space that\'s easy to host in and you will love to show off! Gather with family in the impressive two-story family room that overlooks the kitchen. This kitchen is perfect for hosting guests with dual ovens, a huge granite island, under cabinet lighting, and more! A flex space tucked away off the breakfast nook offers so many possibilities...a study, hobby room, play area, and more! Relax and unwind in the luxurious primary suite with a spacious sitting area, spa-like bath, and walk-in closet. Upstairs, the kids will have their own space to play in the oversized game room with a homework desk and French Doors that close for sound control. Check out this amazing backyard! The extended patio offers loads of room for outdoor entertaining with grassy space left where the kids and pets can play. Sprinkler system. Close to Auburn Lakes Rec Center w a pool, splash-zone, and park!','0.2646','14','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Spring/Klein','Central Gas,Zoned','1','LT 11 BLK 1 AUBURN LAKES RETREAT SEC 1','Cul-De-Sac,In Golf Course Community,Subdivision Lot','11524','Appraisal District','','680','0','','2','Double Oven,Electric Oven','0','','','Gas Cooktop,Gas Range','','Composition','32 - Klein','FRENCH ELEMENTARY SCHOOL (KLEIN)','KLEIN OAK HIGH SCHOOL','HOFIUS INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Auburn Lakes Retreat Sec 1','13431','2.914','Public Sewer,Public Water,Water District','2006','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','212211990','1663712030','212211990','2022-09-18T06:35:21.390','18141254','Pamela Ricks','eXp Realty, LLC','MaryAnne McFall','CB&A, Realtors','30.140173','-95.689503','35','77355','8','590000.00','Option Pending','Timbergreen','14319','Drive','Magnolia','3','0','4','3344','Single-Family','Absolutely gorgeous Ranch Style property located on a 1.43 +/- acre lot in the Timbergreen subdivision. As you drive up to the inviting property, you see a stunning stone & wood home with a port-cochere and long circle driveway. House features cathedral ceilings with eye-catching wood beams. Study has a built-in desk with lots of shelves & cabinets. The galley kitchen has granite countertops and stainless appliances. Family rm has a floor-to-ceiling limestone fireplace. The oversized Primary bedroom has great views of the wooded backyard, a walk-in shower and, a jacuzzi jetted bathtub. The custom-built staircase leads up to a sitting area with an abundance of built-in desks and shelves. Game room has a pool table and flatscreen TV that transfers to buyers. This home is welcoming & inviting. Come enjoy a little country near the city. The amenities of this wonderful community include an area pool and tennis courts. Great Location with easy access to TX 249 & SH 99. Tomball ISD','1.4344','15','','','Electric Dryer Connections,Gas Dryer Connections','','Owner/Agent,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Tomball','Central Gas','1','TIMBERGREEN, BLOCK 3, LOT 13','Cleared,Subdivision Lot,Wooded','62482','Appraisal District','','400','0','','3','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','53 - Tomball','DECKER PRAIRIE ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal','2','Ranch','Timbergreen 01','7281','1.9215','Septic Tank,Water District','1996','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','212242105','1663712030','212242105','2022-09-18T06:44:44.603','87631094','Jay Thomas','eXp Realty, LLC','','','29.481751','-95.199973','49','77546','9','723300.00','Active','Lakeway','2216','Drive','Friendswood','3','1','4','3487','Single-Family','Stunning custom home with a decorator\'s touch, inside a gated community in the desired Friendswood ISD! This amazing home has 2 masters, a study, game room-flex/media room. Fabulous kitchen w/ lots of storage/countertop space, 6-burner gas cooktop, stainless appliances, a central sound system. Generac generator, sprinkler system and salt water softener. Split floor plan offers a private master suite w/ a remodeled master bath. Private bath in the secondary bedroom & Hollywood bath connects two bedrooms off living area. Relax by the gorgeous saltwater pool/spa surrounded by lush landscaping in the oversized tropical oasis backyard (with no back neighbors). You have to see the craftsmanship throughout the interior of this home, it has it all. Oversized 3 car garage. Great space for storage and not your cookie cutter home w/ lots of little things that make this home one of a kind. Rare single story in this desirable gated community w/ a private lake. DID NOT FLOOD.','0.3583','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Friendswood','Central Gas','1','THE LAKES AT SAN JOAQUIN SEC 1 (2003) ABST 622, BLOCK 3, LOT','Subdivision Lot','15608','Appraisal District','','975','0','','3','Double Oven,Electric Oven','1','Heated,Salt Water','','Gas Cooktop','','Composition','20 - Friendswood','CLINE ELEMENTARY SCHOOL','FRIENDSWOOD HIGH SCHOOL','FRIENDSWOOD JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','The Lakes At San Joaquin','11891','2.2832','Public Sewer,Public Water','2002','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','212255762','1663712030','212255762','2022-09-18T07:39:23.503','19168881','Susan Cahill','BHGRE Gary Greene','','','29.138516','-95.046360','45','77554','2','499000.00','Active','Grayson','4227','Drive','Galveston','2','0','2','960','Single-Family','1/3 OF AN ACRE OF LAND IN SOUGHT AFTER SEA ISLE with beautiful BEACH VIEWS from the row of rocking chairs on the large front porch!!! This Charming Casita has been completely updated with all new PLUMBING AND ELECTRIC, LUXURY VINYL PLANK FLOORING, QUARTZ COUNTERTOPS, ALL NEW APPLIANCES, INTERIOR AND EXTERIOR PAINT. Brand new furnishings all included,King Bed, 2 Full Beds, Queen Sleeper Sofa, Twin Sleeper Sofa. Located on 2 large lots with over 14,000 sq ft of land, there is ample room to expand, build a new home, or add a sparkling pool. Beautiful new Texas Sable Palm Trees and decorative Boulders enhance the beauty of this property. This home would make a fabulous INCOME-PRODUCING RENTAL. Sea Isle offers so many great amenities including a NEIGHBORHOOD POOL/TENNIS COURTS, a Marina with Bait Shop/Small grocery and gift shop, and The Sandbar, an Island Favorite Restaurant and Bar located right on the water overlooking the Marina and Canals leading out to Galveston\'s West Bay.','0.326','33','','','Electric Dryer Connections','','Sellers Disclosure','1','','','West End','Central Electric','1','ABST 121 PAGE 19 LOT 351 SEA ISLE 5TH EXTENSION','Cleared,Corner,Subdivision Lot,Water View','14185','Appraisal District','','237','0','','0','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Lockbox Right Side','Appraisal District','1','Traditional','Sea Isle Ext 5','7958','2.0324','Public Sewer,Public Water','1975','Appraisal District'); --> New record created successfully