Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T12:57:56.207' ,`MLSNumber` = '65084081' ,`ListAgentFullName` = 'Rodney Craddock' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.372145' ,`Longitude` = '-95.619388' ,`PhotoCount` = '29' ,`PostalCode` = '77356' ,`RoomCount` = '12' ,`ListPrice` = '563825.00' ,`Status` = 'Active' ,`StreetName` = 'April Waters' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom built home by Montgomery Smith Mastercraft Builders on Golf course w three bedrooms and Home/Study that can be fourth bedroom. Foyer opens to High Ceilings, Formal Living and Dining Rooms. Formal Living enjoys built-ins, fireplace w gas logs, mantel and ceiling fan. Formal Dining has beautiful chandelier and custom wall treatment. Island Kitchen w Breakfast Room, abundant cabinetry, tile inset flooring. Den w built-ins opens to Kitchen and screened-in Sun Porch overlooks golf course. All bedrooms are on main level. Primary Suite has large walk-in closet, corner jetted tub and separate shower w separate vanities. Carpet in primary areas recently replaced. Utility Room is large. April Sound is waterfront community on Lake Conroe with a Manned Gated Entry. Golfcart friendly, with access to Lake Conroe, Golf, Swimming, Tennis, Fitness Center, Boat Launch, Area Pool and more. Montgomery ISD, Close to Shopping, Restaurants, Medical Facilities and more.' ,`Acres` = '0.241' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 08, BLOCK 3, LOT 2' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '10496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '249' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Photos/No Videos,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound' ,`TaxAmount` = '7145' ,`TaxRate` = '2.2625' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097948' WHERE `Matrix_Unique_ID` = '208484362' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T11:44:35.230' ,`MLSNumber` = '13545585' ,`ListAgentFullName` = 'Eric Thomson' ,`ListOfficeName` = 'Crossvine Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.462253' ,`Longitude` = '-94.647883' ,`PhotoCount` = '20' ,`PostalCode` = '77650' ,`RoomCount` = '2' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Monkhouse' ,`StreetNumber` = '1208' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1203' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 2 bedroom home sits on two lots with lots of space. Canal behind home is perfect for crabbing! Luxury vinyl plank flooring throughout, beautiful quartz countertops, RV electrical hookup, and loads of charm. Experience the best of both worlds with views of the Intercoastal Canal, but also a short drive to the beach (Monkhouse Dr has beach access). Home comes fully furnished, ready to be rented out, for weekend getaways, or permanent change of scenery. Large enclosed storage area below to house all your beach toys or tools.' ,`Acres` = '0.2806' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOTS 112 & 114 (114-0) INTRACOASTAL CANA' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '12225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Intercoastal Canal Add' ,`TaxAmount` = '1817' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097948' WHERE `Matrix_Unique_ID` = '210286438' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T12:23:52.993' ,`MLSNumber` = '84626640' ,`ListAgentFullName` = 'Fernando Rodriguez' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.032369' ,`Longitude` = '-95.537090' ,`PhotoCount` = '45' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '345900.00' ,`Status` = 'Active' ,`StreetName` = 'Echobend' ,`StreetNumber` = '17822' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2726' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Temporary no showings due to repairs.\r\n\r\nMake your appointment to come view this gorgeous Victorian Home located in Klein. Kitchen Offers subway backsplash with granite counters & an Island with a Jenn Air down draft stovetop. Slate floors in kitchen, wood laminate throughout the home. SS Kitchen appliance. Have you seen a two-sided Fireplace? well this one is located on the first floor with one side entertain the Living room with the other Complimenting the Formal dining. But wait there is one more fireplace in the Gameroom with 1 Balcony facing the front street and the other looking out to the backyard. Master Bedroom Offers enough space with a fireplace place view. There is also a Garage apartment/Flex Room right around the corner above the 2.5 sized garage space, don\'t miss it! This home is ready to be customized to your personal touch.' ,`Acres` = '0.2709' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 017*S2915536-001-001-021 SHANNON FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Shannon Forest Sec 01' ,`TaxAmount` = '6271' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097948' WHERE `Matrix_Unique_ID` = '210550601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T11:15:47.940' ,`MLSNumber` = '93031335' ,`ListAgentFullName` = 'Stephen Reed' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.245463' ,`Longitude` = '-95.432670' ,`PhotoCount` = '44' ,`PostalCode` = '77302' ,`RoomCount` = '10' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'River Plantation' ,`StreetNumber` = '733' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pictures coming soon! Wonderful location convenient to shopping, dining and medical in The Woodlands and Lake Conroe! This Gorgeous Brick home features 3 or 4 Bedrooms, 2.5 Bath, a Charming Formal Living & Dining room and Oversize 2 Car garage. The open concept Kitchen has granite countertops, breakfast area and exceptional storage. Enjoy the Family Room with a gas log fireplace overlooking secluded patio. Laundry area offers extra cabinetry. Primary Suite is spacious and bright with large walk-in shower. The secondary bedrooms have large closets and new carpet. The private backyard is beautifully landscaped, with large patio and sprinklers front & back. This fantastic home has lots of upgrades and has been meticulously maintained from top to bottom. Extra storage available in shed. The River Plantation golf courses, pool, parks, walking trails and sports amenities provide pleasure for all homeowners with easy access to I-45.' ,`Acres` = '0.2369' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER PLANTATION 05, LOT 26' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'River Plantation 05' ,`TaxAmount` = '4350' ,`TaxRate` = '2.1648' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097948' WHERE `Matrix_Unique_ID` = '211764113' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T11:42:00.827' ,`MLSNumber` = '79835301' ,`ListAgentFullName` = 'Becky Nigrelle' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.366199' ,`Longitude` = '-94.969549' ,`PhotoCount` = '14' ,`PostalCode` = '77568' ,`RoomCount` = '3' ,`ListPrice` = '144900.00' ,`Status` = 'Active' ,`StreetName` = 'Foreman' ,`StreetNumber` = '1420' ,`StreetSuffix` = 'Street' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently redone on the interior, this is a rental property and it is rented. We will need to make appointment to show. \r\nRental lease is until April 2023.' ,`Acres` = '0.185' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR LOT 3 BLK 2 A FORMANS SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8058' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forman Sub' ,`TaxAmount` = '2299' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097949' WHERE `Matrix_Unique_ID` = '212163472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T12:29:21.350' ,`MLSNumber` = '87820162' ,`ListAgentFullName` = 'Teresa Martinez' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099006' ,`Longitude` = '-95.282201' ,`PhotoCount` = '32' ,`PostalCode` = '77365' ,`RoomCount` = '9' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Hills' ,`StreetNumber` = '18594' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Porter' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '5401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING HOME IN SUMMER HILLS COMMUNITY!! DON\'T MISS TO SEE THIS LARGE 6 BEDROOM 5 BATH WITH TONS OF UPDATES. LOCATED NORTH OF HOUSTON 7 MINS FROM STATE HWY59 IN PORTER, TX. THIS BEAUTY\'S UPDATES INCLUDE RECENT HVAC 2 UNITS, INTERIOR PAINT, EXTERIOR BRICK LIME STONE, NICE DESIGNED TILE FLOORS, MODERN LAMINATE FLOORS UPSTAIRS, SPACIOUS LIVING ROOM & DEN, ARCH ENTRYWAYS, HIGH CEILINGS, ROD IRON STAIRWELL, CIRCLE DRIVEWAY, PORTE-COCHERE, OPEN KITCHEN/DINNING, ALL 4 BATHROOMS ARE UPDATED, 2 PRIMARY BEDROOMS ONE DOWN AND ANOTHER UP, 5 FULL BEDROOMS UPSTAIRS, A LIVING ROOM & HUGE MEDIA ROOM 21X20 WITH DRY BAR INCLUDED, COVERED PORCH AND AN OVERSIZED LOT OF 18,000 SQFT. LOW TAXES 2.1% RATE & LOW HOA. NEW COMMUNITIES NEARBY. \r\nMUST SEE TO LOVE THIS HOME & APPRECIATE THE SPACE.' ,`Acres` = '0.4132' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER HILLS 01, LOT 254' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Summer Hills 01' ,`TaxAmount` = '8886' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097949' WHERE `Matrix_Unique_ID` = '212339469' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T12:14:03.360' ,`MLSNumber` = '18829648' ,`ListAgentFullName` = 'Celeste Hengeveld' ,`ListOfficeName` = 'MOVE HOUSTON REAL ESTATE' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005780' ,`Longitude` = '-95.145625' ,`PhotoCount` = '33' ,`PostalCode` = '77346' ,`RoomCount` = '2' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Summit Pines' ,`StreetNumber` = '8707' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1435' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fully-updated patio home tucked in Pines of Atascocita is a must-see gem. From the fresh tile, to the well-maintained patio and yard, this home is in immaculate condition. The new roof, new A/C and new furnace is just a start when looking at the updates. The kitchen has granite countertops, with recessed lighting. The living space has vaulted ceilings and a gas fireplace. The home has beautiful, light colored tiles throughout the entire home. The spacious primary bedroom has French doors that lead to the extra space used as an office. Both bathrooms are fully updated, and both rooms have walk-in closets. Schedule your showing today!' ,`Acres` = '0.1641' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 6 PINES OF ATASCOCITA SEC 2' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pines Atascocita Sec 02' ,`TaxAmount` = '3582' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097949' WHERE `Matrix_Unique_ID` = '212962610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T11:34:16.833' ,`MLSNumber` = '90487576' ,`ListAgentFullName` = 'Michael Jefferson' ,`ListOfficeName` = 'Allsource Property Management' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672594' ,`Longitude` = '-95.372113' ,`PhotoCount` = '10' ,`PostalCode` = '77051' ,`RoomCount` = '5' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Livingston' ,`StreetNumber` = '8210' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1124' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1148' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 11 SUNNYSIDE PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Place' ,`TaxAmount` = '2920' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097949' WHERE `Matrix_Unique_ID` = '213097831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T12:50:18.563' ,`MLSNumber` = '85951587' ,`ListAgentFullName` = 'Rachel Lopez' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868991' ,`Longitude` = '-95.726177' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Settlers Lake' ,`StreetNumber` = '20826' ,`StreetSuffix` = 'Circle' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to Move In 4 bd-2.5 bth two-story home is locatedĀ in the beautiful community of Lakeville!! This gorgeous remodeled home features fresh paint with bright neutral walls throughout.New Flooring & New Carpet 2022! New Roof, New stove, New water heater all in 2022! The spacious 1st-floor owner\'s retreat features large ensuite bath w/ granite counters, vanity area, soaking tub,separate shower & a walk-in closet.The large family room opensĀ up to dining room w/ lots of natural light from the wall of windows!The updated kitchen hosts a breakfast bar center island, gorgeous granite counters, custom backsplash, updated cabinetry with pots/pans drawers for extra storage. 3 generously sized secondary bedrooms, a full bath, utility room, & a massive game room w/ surround sound and lighting complete the 2nd floor. This home gives you awesome views of the lake & pillars! Low-maintenance backyard plus a detached two-car garage. Close to shopping, dining, Grand Pkwy & Hwy 290! Cy-Fair ISD!' ,`Acres` = '0.0893' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 BLK 2 LAKEVILLE SEC 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '3891' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeville Sec 03' ,`TaxAmount` = '5598' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097950' WHERE `Matrix_Unique_ID` = '214840521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T11:27:33.927' ,`MLSNumber` = '63784033' ,`ListAgentFullName` = 'Deborah Jamail' ,`ListOfficeName` = 'Neptune Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.332590' ,`Longitude` = '-94.970234' ,`PhotoCount` = '35' ,`PostalCode` = '77563' ,`RoomCount` = '5' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Western' ,`StreetNumber` = '4802' ,`StreetSuffix` = 'Drive' ,`City` = 'Hitchcock' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1378' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable home...perfect starter home or weekender. As you know good things come in small packages and this is especially true here! Open living with 2 large bedrooms. Plantation shutters on windows. Views out to the lake from living room, dining room and one of the bedrooms. Home will accommodate handicapped with large doorways and elevator. Extra large bath with walk-in shower. Double pane, low E windows. Large covered porch with views of the lake. Outdoor living space under the home. Small storage room down. Double carport with electronic gate. Whole house water filter system. Price improvement...So come take a look. Peace & quiet here with lots of privacy. Close to Galveston beaches, shopping & entertainment. Great fishing (even in the lake)' ,`Acres` = '0.1017' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 175 J SPILLMAN SUR E 1/2 OF LOT 63 (62-1) WITTJEN SUB #' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '4432' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wittjen 6' ,`TaxAmount` = '2034' ,`TaxRate` = '2.2084' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097950' WHERE `Matrix_Unique_ID` = '215076163' --> 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','215419240','1675097950','215419240','2022-12-31T12:43:55.190','48276360','Mohamed Abdelbaky','HomeSmart','','','30.177130','-95.585799','27','77382','10','565000.00','Active','Spindle Tree','19','Circle','The Woodlands','3','1','5','3044','Single-Family','THE WOODLANDS! Located on a beautiful corner lot this 5 Bedrooms, 3.5 Baths offers Conroe ISD schools includes The Woodlands High School. You do not want to miss this opportunity! Walking distance to wonderful parks, splash pad, tennis courts, pavilions, and fishing ponds! Walk or take a short bike ride to lots of shopping and restaurants too. Kitchen boasts massive island overlooking the family room is perfect for family living so no one feels left out of the fun. First floor master suite. The house is also available for rent for $3,200/months.','0.2317','15','Plantation','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','The Woodlands','Central Gas','0','S969986 - WDLNDS VIL STERLING RIDGE 86, BLOCK 2, LOT 7','Corner','10093','Appraisal District','','','0','','3','','0','','','Gas Range','','Composition','11 - Conroe','DERETCHIN ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Wdlnds Village Sterling Ridge 86','9690','2.1816','Public Sewer,Public Water','2007','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','215556748','1675097950','215556748','2022-12-31T11:00:39.250','12810888','Carla Wade','RE/MAX Space Center-Clear Lake','','','29.350943','-95.024216','50','77563','9','549000.00','Active','Highway 6','8336','','Hitchcock','3','2','3','5580','Single-Family','This property is zoned Commercial/Residentlal so it is a perfect property for the entrepreneur that wants to live in a beautiful home on the same grounds with their business. This unique property features a beautifully appointed 4500 sq foot one story 3 bedroom, 3.5 bath home with a huge office/craft room, huge walk in pantry and utility room built out inside the Barndominium. Each bedroom has it\'s own en-suite bath. The Barndo features an oversized 3 plus car garage with tons of attic storage. There is also a 450 sq ft he/she shed with a half bath and kitchenette that could be used as a business or quarters, a 350 sq ft covered and screened in palapa that is the perfect outdoor game room, a pool overlooking the bayou, an additional storage shed and lots of land for boat or RV parking. The property is completely fenced with a private electronic gate. No HOA! Enjoy fishing and life on the bayou, feeling like you are in the country, while being close to all of the city conveniences.','1.14','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Hitchcock','Central Electric','0','ABST 13 W H JACK SUR TRACT 47, 1.14 ACRES','Waterfront','49658','Appraisal District','','','0','','3','Electric Oven','1','Gunite,In Ground','','Gas Cooktop,Gas Range','','Other','26 - Hitchcock','HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL','HITCHCOCK HIGH SCHOOL','CROSBY MIDDLE SCHOOL (HITCHCOCK)','Appointment Required','Appraisal District','1','Barndominium','Wh Jack','4976','2.3482','Public Sewer,Public Water','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','215890323','1675097950','215890323','2022-12-31T12:11:34.090','57755475','Mireya Martinez','People\'s Group, Inc.','','','29.399427','-95.848267','21','77461','3','340000.00','Active','Beasley','3616','Avenue','Needville','2','0','3','1770','Single-Family','Gorgeous recent construction home in the heart of Needville!!! Easy access from 1-69 and Grand Parkway 99; close to shopping and retail centers. This home offers an open floor plan with high ceilings; granite countertops, porcelain backsplash; doble pane windows; stainless steel appliances; Huge back yard space; sprinkler system and much more. Washer, dryer\' Tv\'s and all furniture will stay with the house. Must see to appreciate!!!!','0.326','30','','','','','Sellers Disclosure','','','','','Central Electric','0','SKRABANEK MEADOWS SEC 2, BLOCK 9, LOT 6, ACRES 0.326, R/P','Subdivision Lot','14201','Appraisal District','','','0','','2','','0','','','','','Composition','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Appointment Required','Seller','1','Traditional','Skrabanek Meadows Sec 2','8498','2.2544','Public Sewer,Public Water','2021','Appraisal District'); --> New record created successfully