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-16T14:12:10.330' ,`MLSNumber` = '16218761' ,`ListAgentFullName` = 'Roscoe Ford' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.533219' ,`Longitude` = '-95.755451' ,`PhotoCount` = '48' ,`PostalCode` = '77469' ,`RoomCount` = '12' ,`ListPrice` = '479900.00' ,`Status` = 'Active' ,`StreetName` = 'Euclid' ,`StreetNumber` = '5826' ,`StreetSuffix` = 'Loop' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Presenting the Webster Plan by D.R. Horton! This amazing, open, one story ranch style floor plan is outstanding. The spacious 5 bed, 3.5 bath home includes a family room that flows into a gourmet kitchen with stainless steel appliances and a huge island, a formal dining area, an oversized pantry, and a large laundry room with drying space. The primary suite has a luxurious bath-2 private sink vanity, deep soaker tub, and a semi-frame-less glass shower. The finer details of the home features wood looking tile floors throughout, a stunning foyer, beautiful granite counters, tile back-splash, tall cabinets w/ under lighting, an epoxy garage floor, a covered patio, exterior recess lights, gutters, stamped design concrete in front and backyard, a sprinkler system, and french drains on the sides of the home. The amazing energy features with a tank-less water heater, smart home automation, thermostat, wireless security, electronic deadbolt, and smart lighting! The home has never flooded.' ,`Acres` = '0.1653' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER PARK SEC 2, BLOCK 1, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Park Sec 2' ,`TaxAmount` = '8319' ,`TaxRate` = '2.8448' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091775' WHERE `Matrix_Unique_ID` = '210059235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T14:39:35.177' ,`MLSNumber` = '11998590' ,`ListAgentFullName` = 'Carlito Rivera' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797267' ,`Longitude` = '-95.173358' ,`PhotoCount` = '21' ,`PostalCode` = '77015' ,`RoomCount` = '5' ,`ListPrice` = '234900.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkaldy' ,`StreetNumber` = '238' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this newly remodeled 3 bedroom, 2 full bath home. Newly installed vinyl flooring through out common areas and new carpet in the bedrooms give this home a cozy feeling fresh paint interior and exterior, new appliances, cabinets, quartz counter-tops and many more. The 2 car garage and fenced in large backyard provides plenty of room for a pool or simply entertaining and activities. Located just minutes away from major shopping, schools and a college.' ,`Acres` = '0.2019' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 47 WOODFOREST SEC 17 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'HAVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 17 & Rp' ,`TaxAmount` = '4105' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091775' WHERE `Matrix_Unique_ID` = '210252726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T13:03:23.243' ,`MLSNumber` = '62340899' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140212' ,`Longitude` = '-94.411024' ,`PhotoCount` = '16' ,`PostalCode` = '77659' ,`RoomCount` = '8' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Haidlyns' ,`StreetNumber` = '1530' ,`StreetSuffix` = 'Way' ,`City` = 'Sour Lake' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Holly Trails! The Lakeway is a beautiful and spacious one-story home! The home has a modern open floorplan design. The family room overlooks the covered patio. The kitchen has a large island, pantry, and is open to the breakfast area. The bedroom suite has a large walk-in closet. It also has three more bedrooms, 2 full baths, study, utility room, and a two-car garage. Modern finishes include 3 cm granite and stainless gas appliances. Smart home features are also included for added convenience and security .Book your appointment for a tour today!' ,`Acres` = '0.2798' ,`Area` = '49' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 20 BLK 2 HOLLY TRAILS PHASE 1 AS PER PLAT 4-209 P# HT-1-' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12188' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holly Trails Ph 1' ,`TaxAmount` = '759' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091776' WHERE `Matrix_Unique_ID` = '210629502' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T13:07:46.767' ,`MLSNumber` = '1087479' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.244907' ,`Longitude` = '-95.088630' ,`PhotoCount` = '8' ,`PostalCode` = '77327' ,`RoomCount` = '1' ,`ListPrice` = '89999.00' ,`Status` = 'Active' ,`StreetName` = 'Road 7000' ,`StreetNumber` = '159' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Handy-man special! Great opportunity for you to finish building a home to call your own made just how you would like it! Almost half an acre of land with easy access to Plum Grove Rd which leads to downtown Cleveland! Give us a call today for more information! As Is.' ,`Acres` = '0.49' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'VILLA NUEVA, BLOCK 2, LOT 10, ACRES .49' ,`LotDesciption` = 'Cleared' ,`LotSize` = '21344' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Villa Nueva' ,`TaxAmount` = '1429' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091776' WHERE `Matrix_Unique_ID` = '211744626' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T14:12:57.207' ,`MLSNumber` = '22506588' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820737' ,`Longitude` = '-95.390528' ,`PhotoCount` = '46' ,`PostalCode` = '77022' ,`RoomCount` = '7' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = '38th' ,`StreetNumber` = '724' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 726 E. 38th in the ever popular area of Independence Heights in Houston! Located 7 minutes from from the Greater Heights area, you are surrounded by the most popular dining, shopping and recreation spots in Houston. The Executive Series by Pannu Homes will not disappoint. Boasting 3 Bedrooms, 2.5 Baths, luxurious finishes and covered Patio off the back, this home is perfect for anyone on the go or one that loves to entertain! Pannu Homes designs every home with top tier technology, making your life so much easier! Equipped with Google/NEST Smart Accessories, pre-wired with 2 EV Charges and a 24/7 Disaster Ready Power Backup Panel. Partnered with Houston Native, Vivaldi Lifestyles, your home will be sure to stand out amongst the rest. Enjoy Luxury Vinyl Plank flooring throughout, large Bronze windows, Quartz countertops and lavish tile flooring in Bathrooms. Escape to your Primary Suite situated on the 2nd Floor with stunning Soaker Tub and large Walk In shower!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Pannu Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 10 & 11 BLK 64 INDEPENDENCE HEIGHTS PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2533' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Independence Heights Park' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091776' WHERE `Matrix_Unique_ID` = '212436523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T14:20:20.543' ,`MLSNumber` = '75520161' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.397995' ,`Longitude` = '-94.732927' ,`PhotoCount` = '42' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '564900.00' ,`Status` = 'Active' ,`StreetName` = 'Calypso' ,`StreetNumber` = '1989' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1376' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous home just minutes to the beach! This home has 3 bedrooms, 2 baths, garage and fantastic outdoor entertaining space! Amazing weekend getaway but also an amazing investment property. Home being sold fully furnished! Huge lower level carport with space for your vehicle or better yet, entertaining space to enjoy rain or sunshine. There is a fish cleaning sink, picnic table, and large outdoor shower for rinsing off after a day at the beach. Upper wrap around deck with gorgeous outdoor furniture to enjoy dining, your morning coffee or an evening beverage. Entry to the home features a gourmet kitchen with stunning quartz counters, custom cabinetry and stainless appliances. Large dining area open to a wonderful family room area. Wonderful floor plan for those who love to entertain. Large primary bedroom with en suite bathroom and double closets and dresser. The 2 additional bedrooms also very spacious for your guests. Imagine owning a home minutes away from the beach. Hurry to See!' ,`Acres` = '0.217' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAS AT CRYSTAL BEACH (2015) ABST 179, LOT 5 & PT OF PRVT' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '9453' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Villas At Crystal Beach 2015' ,`TaxAmount` = '5714' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091776' WHERE `Matrix_Unique_ID` = '212560428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T14:12:15.650' ,`MLSNumber` = '74095126' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820737' ,`Longitude` = '-95.390528' ,`PhotoCount` = '46' ,`PostalCode` = '77022' ,`RoomCount` = '7' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = '38th' ,`StreetNumber` = '724' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 724 E. 38th in the ever popular area of Independence Heights in Houston! Located 7 minutes from from the Greater Heights area, you are surrounded by the most popular dining, shopping and recreation spots in Houston. The Executive Series by Pannu Homes will not disappoint. Boasting 3 Bedrooms, 2.5 Baths, luxurious finishes and covered Patio off the back, this home is perfect for anyone on the go or one that loves to entertain! Pannu Homes designs every home with top tier technology, making your life so much easier! Equipped with Google/NEST Smart Accessories, pre-wired with 2 EV Charges and a 24/7 Disaster Ready Power Backup Panel. Partnered with Houston Native, Vivaldi Lifestyles, your home will be sure to stand out amongst the rest. Enjoy Luxury Vinyl Plank flooring throughout, large Bronze windows, Quartz countertops and lavish tile flooring in Bathrooms. Escape to your Primary Suite situated on the 2nd Floor with stunning Soaker Tub and large Walk In shower!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Pannu Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 10 & 11 BLK 64 INDEPENDENCE HEIGHTS PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2533' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Independence Heights Park' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091776' WHERE `Matrix_Unique_ID` = '212603947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T14:12:36.300' ,`MLSNumber` = '41597699' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820737' ,`Longitude` = '-95.390528' ,`PhotoCount` = '46' ,`PostalCode` = '77022' ,`RoomCount` = '7' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = '38th' ,`StreetNumber` = '724' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 725 E. 38th in the ever popular area of Independence Heights in Houston! Located 7 minutes from from the Greater Heights area, you are surrounded by the most popular dining, shopping and recreation spots in Houston. The Executive Series by Pannu Homes will not disappoint. Boasting 3 Bedrooms, 2.5 Baths, luxurious finishes and covered Patio off the back, this home is perfect for anyone on the go or one that loves to entertain! Pannu Homes designs every home with top tier technology, making your life so much easier! Equipped with Google/NEST Smart Accessories, pre-wired with 2 EV Charges and a 24/7 Disaster Ready Power Backup Panel. Partnered with Houston Native, Vivaldi Lifestyles, your home will be sure to stand out amongst the rest. Enjoy Luxury Vinyl Plank flooring throughout, large Bronze windows, Quartz countertops and lavish tile flooring in Bathrooms. Escape to your Primary Suite situated on the 2nd Floor with stunning Soaker Tub and large Walk In shower!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Pannu Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 10 & 11 BLK 64 INDEPENDENCE HEIGHTS PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2533' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Independence Heights Park' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091777' WHERE `Matrix_Unique_ID` = '212604116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T14:11:38.223' ,`MLSNumber` = '58056742' ,`ListAgentFullName` = 'Roscoe Ford' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.250388' ,`Longitude` = '-95.893223' ,`PhotoCount` = '48' ,`PostalCode` = '77420' ,`RoomCount` = '11' ,`ListPrice` = '599990.00' ,`Status` = 'Active' ,`StreetName` = 'Boling Dome' ,`StreetNumber` = '2077' ,`StreetSuffix` = 'Drive' ,`City` = 'Boling' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING CUSTOM BUILT 5 BEDROOM, 4 BATHS, 2 HALF BATHS, WITH A POOL, SPA AND OUTDOOR KITCHEN. ALL SITUATED ON A LARGE CORNER LOT WITH MATURE TREES AND LUSCIOUS LANDSCAPING. 10 Ft CEILINGS WITH 12 FT. INSETS! KITCHEN FEATURES CUSTOM CABINETS, GRANITE COUNTERS WITH TILE BACKSPLASH & WALK-IN PANTRY, DOUBLE OVENS, UNDER COUNTER LIGHTING, OPEN TO THE LIVING ROOM AND MUCH MORE! FORMAL DINING ROOM, BREAKFAST AREA AND BUILT IN VACUM SYSTEM. SPACIOUS MASTER WITH ENSUITE BATH INCLUDING HIS AND HERS SINKS, SOAKER TUB AND HUGE WALK IN SHOWER AND OVERSIZED CLOSETS. COVERED BACK PATIOS GREAT FOR ENTERTAINING, OVER LOOKING THE POOL AND FULLY FENCED BACKYARD. LASATA COMMUNITY IN NEW GULF KNOWN FOR GORGEOUS MATURE TREES. IN ADDITION, IT IS HOME TO NEW GULF ELEMENTARY! \r\n\r\n\r\nCALL FOR YOUR PRIVATE SHOWING TODAY!' ,`Acres` = '0.504' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LASATA AT NEWGULF BLOCK 3 LOT 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '21954' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '140 - Boling' ,`SchoolElementary` = 'NEWGULF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOLING HIGH SCHOOL' ,`SchoolMiddle` = 'IAGO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Lasata At Newgulf' ,`TaxAmount` = '8727' ,`TaxRate` = '1.5691' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091777' WHERE `Matrix_Unique_ID` = '214207165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T13:40:32.410' ,`MLSNumber` = '18806714' ,`ListAgentFullName` = 'John Harcrow' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.555369' ,`Longitude` = '-95.621613' ,`PhotoCount` = '31' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '209990.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Lane' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make Sam Houston Forest Estates, a Lake Conroe Community, MOVE IN READY new home by High Road Homes. *ENJOY LOW PROPERTY TAXES* Features 3/2.5/1 cul-de-sac lot w/ large backyard & many extras at this unbelievable price point! Spacious 2-story; 3 sizeable bedrooms, large living & dining room w/ an open concept kitchen, mudroom, & desirable pocket office. Notable features incl. Double Panel Insulated Low E Windows, 16 SEER HVAC System w/ Media Filter, Luxury Vinyl Wood Plank Flooring (common areas) & Mohawk Plush Carpet (bedrooms), 2\" Faux Wood Blinds, Delta Plumbing Fixtures, Sherwin Williams Paint, GE Stainless Steel Appliances, 30\" Maple Cabinetry, Structurally Engineered, Engineered Post Tension Foundation, Cemplank by James Hardie Masonry Siding, TAMKO Elite Glass-Seal Shingles, Seamless Aluminum Gutters (front of home), PEX Piping, Automatic Sprinkler System Front/Back, Garage Door Opener. Additional Home Features attached! Photos are a sample of a completed home.' ,`Acres` = '0.116' ,`Area` = '43' ,`BuilderName` = 'High Road Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SAM HOUSTON FOREST ESTATES - SEC 2, LOT 69' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5052' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '132' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam Houston Forest Estates Sec 2' ,`TaxAmount` = '210' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091777' WHERE `Matrix_Unique_ID` = '214494920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T13:56:49.923' ,`MLSNumber` = '30070388' ,`ListAgentFullName` = 'John Harcrow' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.556225' ,`Longitude` = '-95.621298' ,`PhotoCount` = '31' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '209990.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Avenue' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make Sam Houston Forest Estates, a Lake Conroe Community, MOVE IN READY new Home by High Road Homes. *ENJOY LOW PROPERTY TAXES* Features 3/2.5/1 cul-de-sac lot w/ large backyard & many extras at this unbelievable price point! Spacious 2-story; 3 sizeable bedrooms, large living & dining room w/ an open concept kitchen, mudroom, & desirable pocket office. Notable features incl. Double Panel Insulated Low E Windows, 16 SEER HVAC System w/ Media Filter, Luxury Vinyl Wood Plank Flooring (common areas) & Mohawk Plush Carpet (bedrooms), 2\" Faux Wood Blinds, Delta Plumbing Fixtures, Sherwin Williams Paint, GE Stainless Steel Appliances, 30\" Maple Cabinetry, Structurally Engineered, Engineered Post Tension Foundation, Cemplank by James Hardie Masonry Siding, TAMKO Elite Glass-Seal Shingles, Seamless Aluminum Gutters (front of home), PEX Piping, Automatic Sprinkler System Front/Back, Garage Door Opener. Additional Home Features attached! Photos are a sample of a completed home.' ,`Acres` = '0.1788' ,`Area` = '43' ,`BuilderName` = 'High Road Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SAM HOUSTON FOREST ESTATES - SEC 2, LOT 53' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7788' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '132' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam Houston Forest Estates Sec 2' ,`TaxAmount` = '210' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091777' WHERE `Matrix_Unique_ID` = '214495499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T13:08:26.077' ,`MLSNumber` = '97801593' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140212' ,`Longitude` = '-94.411024' ,`PhotoCount` = '18' ,`PostalCode` = '77659' ,`RoomCount` = '10' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Haidlyns' ,`StreetNumber` = '1655' ,`StreetSuffix` = 'Way' ,`City` = 'Sour Lake' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Holly Trails! The Lakeway is a beautiful and spacious one-story home! The home has an open floorplan design. The family room overlooks the covered patio. The kitchen has a large island, pantry, and is open to the breakfast area. The primary bedroom suite has a large walk-in closet. It also has three more bedrooms, 2 full baths, study, utility room, and a two-car garage. Modern finishes include 3 cm granite and stainless gas appliances. Smart home features are also included for added convenience and security.' ,`Acres` = '0.2859' ,`Area` = '49' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 55 BLK 1 HOLLY TRAILS SUB PHASE II P# HT-II-1-55' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12454' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holly Trails' ,`TaxAmount` = '705' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091778' WHERE `Matrix_Unique_ID` = '214801913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T13:05:54.907' ,`MLSNumber` = '89819751' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140212' ,`Longitude` = '-94.411024' ,`PhotoCount` = '18' ,`PostalCode` = '77659' ,`RoomCount` = '10' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Haidlyns' ,`StreetNumber` = '1505' ,`StreetSuffix` = 'Way' ,`City` = 'Sour Lake' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Holly Trails! The Lakeway Elevation is a beautiful and spacious one-story home! The home has an open floorplan design. The family room overlooks the covered patio. The kitchen has a large island, pantry, and is open to the breakfast area. The primary bedroom suite has a large walk-in closet. It also has three more bedrooms, 2 full baths, study, utility room, and a two-car garage. Modern finishes include 3 cm granite and stainless gas appliances. Smart home features are also included for added convenience and security.' ,`Acres` = '0.2862' ,`Area` = '49' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 70 BLK 1 HOLLY TRAILS PHASE 1 AS PER PLAT 4-209 P# HT-1-' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12467' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holly Trails Ph 1' ,`TaxAmount` = '777' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091778' WHERE `Matrix_Unique_ID` = '214890513' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T13:49:04.637' ,`MLSNumber` = '78635062' ,`ListAgentFullName` = 'Luis Mata' ,`ListOfficeName` = 'David Hulsey, REALTORS ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827004' ,`Longitude` = '-95.375472' ,`PhotoCount` = '22' ,`PostalCode` = '77022' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Weisenberger' ,`StreetNumber` = '110' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious home very close to I 45 and Northline Mall/Walmart/Train within walking distance. Completely remodeled with all city inspections passed. The spacious fenced back yard is great for entertaining and home is ready to move into and enjoy.' ,`Acres` = '0.1894' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 2 WEISENBERGER\'S SHADYLAND' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HERRERA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Weisenberger S Shadyland' ,`TaxAmount` = '3931' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091778' WHERE `Matrix_Unique_ID` = '215015015' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T14:37:40.210' ,`MLSNumber` = '63827630' ,`ListAgentFullName` = 'Heather Lange' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = 'Laura Bruce' ,`SellingOfficeName` = '2011 AMERICAN REAL ESTATE CO.' ,`Latitude` = '30.019435' ,`Longitude` = '-93.842589' ,`PhotoCount` = '43' ,`PostalCode` = '77611' ,`RoomCount` = '5' ,`ListPrice` = '280000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Gilmer' ,`StreetNumber` = '215' ,`StreetSuffix` = 'Road' ,`City` = 'Bridge City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1790' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beauty in Bridge City is a rare find sitting on 1.47 acres + a 900 sq ft 2/1 apartment (perfect for a college student or possible rental potential) & 4 car garage! Open-concept den/kitchen. The den has a wood-burning fireplace and tray ceiling. The kitchen offers custom cabinetry with abundant storage & is a breakfast combo. Spacious bedrooms with wood floors. Master has an en-suite bathroom with double sinks, large shower with dual shower heads and walk-in closet. Outdoors you can enjoy the the day on the expansive covered patio. You don’t want to miss making this your new place to call home.' ,`Acres` = '1.47' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot E 135\' of 10 BLK 1 Edgewood' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Edgewood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091778' WHERE `Matrix_Unique_ID` = '215037016' --> 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','215125767','1675091779','215125767','2022-12-16T14:31:32.247','95853851','Jared Turner','Turner Mangum,LLC','','','30.205594','-95.734833','6','77354','6','257325.00','Active','Bellewood Manor','134','Drive','Magnolia','2','0','3','1612','Single-Family','The Carlisle looks a lot like our model, with tall ceilings in the living and primary bedroom. Open look yet a bit delineated with nice breakfast flush bar making a very functional kitchen space. Plan has a flex/study area as well. Durable, waterproof 100% waterproof LVP wood look floors throughout except in bedrooms. You get a lot of home for the dollars with this design.','','15','Rausch Coleman Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Magnolia/1488 West','Central Gas','1','52-1','Subdivision Lot','6000','Other','','300','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Range','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Magnolia Ridge','','3.3','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215348484','1675091779','215348484','2022-12-16T13:01:27.613','16513180','Wesley Bryant','Partners in Building LP','','','30.166349','-95.543380','14','77389','15','1975550.00','Active','Squire Creek','14','Way','Spring','5','1','5','5001','Single-Family','NEW CUSTOM HOME BY PARTNERS IN BUILDING located on a golf course lot. Welcoming covered entry & two-story foyer flow past the dining room into the two-story family room with views to the covered porch beyond. The well-designed gourmet kitchen overlooks a bright breakfast area, equipped with a large center island, ample counter & cabinet space, huge walk-in pantry, wine room & butler’s pantry. The secluded primary bedroom suite features a tray ceiling, spacious walk-in closet, dual vanities, large soaking tub & shower. Upstairs you will find an enormous loft, three secondary bedrooms with walk-in closets/private baths. Additional features include a 2nd floor balcony, study, upstairs media room & first floor game room. Exceptional resort-style amenities, beautiful scenery, and highly rated Montgomery County Public & Private Schools. Spend an afternoon playing a round of golf on the Tom Fazio Championship Golf Course or enjoy dinner at the club on the patio overlooking the green.','','14','Partners In Building','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','Gas Connections,Gaslog Fireplace','1','The Woodlands','Central Gas','1','Lot 1 Block 1 Section 15','In Golf Course Community,On Golf Course,Subdivision Lot','13665','Appraisal District','','4750','1','To Be Built/Under Construction','3','Double Oven','0','','','Gas Cooktop','','Tile','53 - Tomball','TIMBER CREEK ELEMENTARY SCHOOL (Tomball)','TOMBALL HIGH SCHOOL','CREEKSIDE PARK JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access','Builder','2','Contemporary/Modern,Mediterranean','Carlton Woods Village of Creekside Park','','2.6895','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215394541','1675091779','215394541','2022-12-16T13:00:19.210','89998661','Susan Kinder','MV Realty Of Texas LLC','','','30.405643','-95.510784','15','77318','8','424900.00','Active','Soapberry Tree','410','Court','Conroe','2','1','4','2497','Single-Family','Gorgeous 2 story 4 bedroom 2.5 bath with study/home office. Enjoy Soaring high ceilings. Primary bedroom downstairs with a view of covered patio, create your own view in the backyard. The primary bathroom has a large shower, relaxing tub and, walk-in closet. Enjoy cooking in your kitchen, the heart of the home, open to the living room, breakfast area, and second-story bridge over the entryway. Granite countertops, Island bar seating in two locations is great for your guest when entertaining. The spindled staircase leads you to the Gallery walkover on the second floor. Open to the first floor allowing clear communication among family members. The Gameroom is up with large windows allowing a lot of light throughout. The Secondary bedrooms are large enough for a desk area. The Main Bathroom upstairs has a tub/shower combo.','0.1583','39','Chesmar','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Lake Conroe Area','Central Gas,Zoned','1','S927114 - THE WOODLANDS HILLS 14, BLOCK 3, LOT 18','Subdivision Lot','6896','Appraisal District','','965','0','','2','Convection Oven,Gas Oven','0','','','Gas Range','','Composition','56 - Willis','W. LLOYD MEADOR ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','The Woodland Hills','12181','3.2823','Water District','2021','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','215449024','1675091779','215449024','2022-12-16T13:19:25.880','7264180','Juan Francisco Munoz','Walzel Properties','','','29.771887','-95.231947','6','77029','3','280000.00','Active','Verano','11209','Street','Houston','2','0','3','1571','Single-Family','','0.1834','2','','','','','Mud,Sellers Disclosure','','','','Northeast Houston','Central Gas','0','LT 143 BLK 13 MARKET STREET GARDENS EXTN 2','Cleared,Subdivision Lot','7989','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','WHITTIER ELEMENTARY SCHOOL (HOUSTON)','FURR HIGH SCHOOL','HOLLAND MIDDLE SCHOOL (HOUSTON)','Accompany','Appraisal District','1','Contemporary/Modern','Market Street Gardens Ext 02','4895','2.5534','Public Water','2000','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215559979','1675091779','215559979','2022-12-16T13:06:25.277','86859815','Lou Rosas','RE/MAX Real Estate Assoc.','','','29.365055','-95.081483','36','77510','7','339000.00','Active','FM 646','5525','Road','Santa Fe','2','0','3','1503','Single-Family','3 bedroom, 2 bath, recently remodeled','0.2221','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','0','','','Santa Fe','Central Gas','0','ABST 149 E MITCHELL SUR PT OF LOTS 14 & 15 (14-2) BLK 39 ALT','Cleared,Subdivision Lot','9675','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','45 - Santa Fe','WILLIAM F BARNETT ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Alta Loma Townsite','5870','2.5361','Public Sewer,Public Water','1999','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','215655977','1675091779','215655977','2022-12-16T14:56:49.053','6537624','Brad Countryman','Keller Williams Realty -SW','','','29.538664','-95.673303','31','77469','12','574999.00','Active','Chestnut Cove','702','Lane','Richmond','4','0','6','3838','Single-Family','Amazing, large home in a quiet neighborhood. No side or back neighbors while still tucked in a cul-de-sac. Incredibly flexible home for the large single family, multi-generational family, and great investment. Granite countertops, whole home vacuum, whole home water filtration, game room, media room, epoxied 3 car garage, oversized driveway, wired for sound throughout and media hub, second floor patio and so much more! Located close to Hwy 59 and Hwy 99. Wonderful school zoning. Minutes from shopping and grocery stores. Luxurious, spacious, and peaceful.','0.243','30','Princeton Classic','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Fort Bend Southeast','Central Gas','1','GREATWOOD LAKE SEC 2A, BLOCK 1, LOT 46','Cul-De-Sac','10587','Appraisal District','','775','0','','3','Convection Oven,Gas Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','VELASQUEZ ELEMENTARY SCHOOL','GEORGE RANCH HIGH SCHOOL','RYON/READING JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Contemporary/Modern','Greatwood Lake','16026','3.1948','Public Sewer,Public Water,Water District','2019','Appraisal District'); --> New record created successfully