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-01T16:56:29.310' ,`MLSNumber` = '94367569' ,`ListAgentFullName` = 'Charles Miller' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.924648' ,`Longitude` = '-95.246466' ,`PhotoCount` = '25' ,`PostalCode` = '75862' ,`RoomCount` = '9' ,`ListPrice` = '197500.00' ,`Status` = 'Active' ,`StreetName` = 'Pinewood' ,`StreetNumber` = '627' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW 1568 BRICK AND HARDI BLANK HOME JUST COMPETED IN A WATERFRONT GATED SUBDIVISION . FEATURES 3 BEDROOMS, 2 BATHROOMS. OPEN CONCEPT HOMES AND TILE AND CARPET THRU-OUT, DOUBLE PANE WINDOWS WITH THE PULL OUT FOR EASY CLEANING, KITCHEN HAS GRANITE COUNTER TOPS, CUSTOM CABINETS, DOUBLE DROP DOWN STAINLESS SINK, NEW RANGE , MICRO-HOOD AND DISHWASHER TO BE INSTALLED, LIVING ROOM/COMBO, SPACIOUS MASTER BEDROOM, MASTER BATHROOM, GRANITE COUNTER TOPS WITH DROP DOWN SINK, TILE TUB AND SHOWER, LARGE WALK IN CLOSET, 2 COMFORTABLE BEDROOMS, UTILITY ROOM IN HOME, 2 COVER PORCHES, 1 CAR GARAGE, FENCE IN BACK YARD TO BE INSTALLED. SUBDIVISION BOAT RAMP AND FISHING AREA, POOL AND PLAY AREA, RELAX AND WATCH THE DEER AND WILDLIFE ALL ROUND YOU. CLOSE TO SHOPPING , RESTAURANTS AND MORE. THIS HOME WOULD MAKE A GREAT FULL TIME HOME OR A WEEKEND GETAWAY, BRING THE WATER TOYS AND HAVE FUN ON THE LAKE.' ,`Acres` = '0.0777' ,`Area` = '42' ,`BuilderName` = 'HOMES BY VICTOR' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HARBOR POINT SECTION I, LOT 052' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3384' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '402' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbor Point Sec' ,`TaxAmount` = '' ,`TaxRate` = '1.6756' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086157' WHERE `Matrix_Unique_ID` = '199243623' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T16:37:29.110' ,`MLSNumber` = '47534440' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726764' ,`Longitude` = '-95.373380' ,`PhotoCount` = '50' ,`PostalCode` = '77004' ,`RoomCount` = '5' ,`ListPrice` = '777999.00' ,`Status` = 'Active' ,`StreetName` = 'Ruth' ,`StreetNumber` = '2201' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 5 bed 4+ bath corner home full of large windows that provide great views of downtown at every turn. This home features exquisite quartzite and copper accents that give it a perfect touch of class while also keeping a modern vibe. It also features an open-concept gourmet kitchen and TWO master suites, including one on the first level. A huge auto gate opens to a spacious three-car garage with plenty of parking for those weekend cookouts. On top of all the beauty this home has to offer, it is also within a prime location that is less than 2 miles from the museum district and less than 3 miles from Downtown Houston. Fine dining, museums, nightlife, music venues, parks, and all that Houston has to offer will all be within minutes! This one won\'t last long, come see what all the fuss is about! It really is a true gem!' ,`Acres` = '0.1263' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK B ALMEDA PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Almeda Place' ,`TaxAmount` = '18545' ,`TaxRate` = '2.5144' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086157' WHERE `Matrix_Unique_ID` = '199773090' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T16:41:28.470' ,`MLSNumber` = '10905020' ,`ListAgentFullName` = 'Booker Terrell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Christian Luis' ,`SellingOfficeName` = 'Krueger Real Estate' ,`Latitude` = '29.814806' ,`Longitude` = '-95.322704' ,`PhotoCount` = '22' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '230000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wipprecht' ,`StreetNumber` = '6103' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two properties for the price of one. Looking for home ownership with an opportunity to generate passive income? Just inside 610 loop, minutes from downtown Houston. Home is being sold as is, along with an adjoining vacant lot. Go to MLS # 79149425 for details about the lot! That\'s right, two properties for one price. The home is liveable and could be updated at leisure. Roof is 5 years old. AC unit is being serviced. Homes boasts over 1835 square feet, large kitchen, family and den. The vacant lot once had a garage/apartment which has now been demolished, creating the opportunity to build a new home. \r\n\r\n\r\nNo HOA Dues, No Mud Taxes. Opportunity and options are present for home ownership or investment opportunity. This community is up and coming whereby gentrification is underway. Many homes have been rennovated and there are more than several new builds. Book your showing, bring your offers and make your investment in this opportunity go to work for you.' ,`Acres` = '0.2066' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1411A BLK 58 KASHMERE GARDENS EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Kashmere Gardens' ,`TaxAmount` = '4178' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086157' WHERE `Matrix_Unique_ID` = '209521851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T16:24:07.403' ,`MLSNumber` = '27231597' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Zulfikhar Alikhan' ,`SellingOfficeName` = 'Apex Brokerage, LLC' ,`Latitude` = '29.702043' ,`Longitude` = '-95.706274' ,`PhotoCount` = '25' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '324990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '6923' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New One story Ranch Style home- by D.R. Horton! Completed!! Beautiful Vinyl Wood Large Plank Flooring throughout the high traffic areas, Tile in all Wet Areas & Luxurious Carpeting in Bedrooms! The Casual Dining Room & Family Room flows gracefully into the Gourmet Kitchen! Gourmet Kitchen is a Chef\'s dream with Upgraded Quartz Counters, Tile Back-splash, Large Eat-in Working Island with Under-mount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Tall Shaker Cabinets & more! Primary Private Suite with Luxurious Bathroom/Spa featuring Double Sink Vanity, Massive Shower with Seamless Glass Door, Walk-in Closet! 3 Guest Bedrooms & 1 Full Bath! Covered Patio! LOW Utility Cost with the outstanding Energy Features including: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home Automation\" Control your home from anywhere w/Echo & Dot! NO FLOODING! Amenities include: Pool, & Splash Pad! Just 20 minutes to The Galleria! Soon Updated Photos' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 27/Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086157' WHERE `Matrix_Unique_ID` = '210399110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T16:44:44.167' ,`MLSNumber` = '28972657' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220047' ,`Longitude` = '-95.349920' ,`PhotoCount` = '8' ,`PostalCode` = '77302' ,`RoomCount` = '7' ,`ListPrice` = '439180.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Shadow' ,`StreetNumber` = '14348' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available April 2023!! Pulte welcomes you to the Woodland The kitchen has a single basin sink, white cabinetry, quartz countertops, upgraded 36” Cooktop with huge stainless steel vent hood. The Huge Loft overlooks the gathering room. A Jack-and-Jill Bath separated 2 of the 3 oversized bedrooms on the second floor. Your downstairs Owners suite includes an ensuite bathroom, separate tub and shower, and bay window!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '16202' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086157' WHERE `Matrix_Unique_ID` = '212065459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T16:40:23.327' ,`MLSNumber` = '96684652' ,`ListAgentFullName` = 'Arica Pitts' ,`ListOfficeName` = 'Texas Triangle Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.079401' ,`Longitude` = '-95.470263' ,`PhotoCount` = '22' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowlark' ,`StreetNumber` = '3406' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is situated in the well-sought-out Spring/Klien area! The home has been updated with new flooring in bedrooms, fresh paint, new lighting all throughout the house, and all new windows. The kitchen was updated with new granite as well as painted cabinets. Located in Dove Meadows with a great school district and with several amenities in the area! A very quiet and friendly neighborhood. Just minutes from 99 and I45 for an easy commute to the Woodlands or Houston. Ready to move in and enjoy! More photos will be up tomorrow evening!' ,`Acres` = '0.1446' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 DOVE MEADOWS SEC 5 PAR R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KREINHOP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dove Meadows Sec 05 Prcl R/P' ,`TaxAmount` = '5548' ,`TaxRate` = '2.804' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086158' WHERE `Matrix_Unique_ID` = '213169756' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T16:23:50.820' ,`MLSNumber` = '42904564' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Matthew Rolf' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '30.251110' ,`Longitude` = '-95.205858' ,`PhotoCount` = '15' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '257990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Fern Meadows' ,`StreetNumber` = '14232' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT 4 BEDROOM! Charming Elevation with Front Porch! Great Open Concept Interior Layout - Island Kitchen with Corner Pantry is Open to Spacious Dining Area & Living Room! Privately Located First Floor Primary Suite with Big Walk-In Closet & Lovely Bath with Oversized Shower! Versatile Gameroom/Media Room! Big Secondary Bedrooms - One with Walk-In Closet! Convenient Indoor Utility Room with Direct Access to Garage! Covered Patio & Landscape Package Enhance Backyard Setting! Great New Community with Easy Access to Highway 59 - Plus Just Minutes to Elementary & High Schools! Estimated Completion - January 2023.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 46 Block 1 Presswoods Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PINEY WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Presswoods' ,`TaxAmount` = '' ,`TaxRate` = '3.4283' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086158' WHERE `Matrix_Unique_ID` = '214770209' --> 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','215232939','1675086158','215232939','2022-12-01T15:05:17.340','94944352','Chad Meadows','eXp Realty, LLC','','','28.956177','-95.280952','16','77541','1','275000.00','Active','Coral','223','Court','Surfside Beach','1','0','1','624','Single-Family','This beautiful beach home sits just steps from the beach! Enjoy the spectacular sunrise from the balcony with the sounds of the waves crashing in! The Plumeria Cottage is currently a very popular vacation rental with bookings into the new year. Lots of natural light and views of the ocean fill the home! The beach is just a quick walk from the home! This home has character for days! Words simply do not do it justice! Come and enjoy the simpler life at the beach! Home is being sold furnished. Here is your chance to own a turnkey business!','0.13','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Surfside','Central Electric','0','S/D TR 48 (A0051 F J CALVIT DIV 2 (B C I C)) LOT 18 (SURFSID','Water View','5663','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Accompany,Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','1','Other Style','S/D Tr 48','5989','2.333','Septic Tank','1955','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','215249211','1675086158','215249211','2022-12-01T16:44:02.750','34344078','Christopher Watters','Watters International Realty','','','29.943825','-97.038120','50','78963','4','330000.00','Active','Point','117','Loop','West Point','2','1','3','1702','Single-Family','Step into the charm of this quaint 3 bedroom, 2 story home on 1.67 acres. This home offers a quiet, country atmosphere with plenty of room to entertain. The expanded front porch is the perfect place to unwind with a glass of your favorite beverage at the end of the day. Inside you\'ll find an open floor plan with living area, sitting room plus a formal dining area. A spacious country style kitchen features butcher block counter tops, stainless appliances and a breakfast area with bay window. The laundry room and a half bath complete the first level. Upstairs offers a large master with full bath plus two spacious secondary bedrooms share a full bath. The property also has a two car carport with storage, RV hookups that could be income producing if desired and a large storage building. Centrally located between Houston, Austin and San Antonio and halfway between Smithville and LaGrange this is rural country living at its finest!','1.677','69','','','','','Other Disclosures,Sellers Disclosure','1','','','','Central Electric','0','WEST POINT (535) 1.677 HSE, STG','Cleared','73050','Appraisal District','','','0','','0','Freestanding Oven,Gas Oven','0','','','Gas Cooktop','','Composition','205 - La Grange','HERMES ELEMENTARY SCHOOL','LA GRANGE HIGH SCHOOL','LA GRANGE MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Victorian','West Point 535','2482','1.4677','Public Water,Septic Tank','2007','Appraisal District'); --> New record created successfully