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-11-26T08:56:30.923' ,`MLSNumber` = '45143274' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427205' ,`Longitude` = '-95.452401' ,`PhotoCount` = '29' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '412990.00' ,`Status` = 'Active' ,`StreetName` = 'Sequoia Run' ,`StreetNumber` = '1646' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Every square foot is maximized with our Frost plan. This 3-bedroom home offers space, flexibility, and comfort. The open-concept family room is adjoined by the large kitchen and dining area. The kitchen accommodates sleek granite countertops, flat-panel birch cabinets! A covered patio resides just off the family room. The master suite offers cultured marble countertops with dual vanities, a separate garden tub and shower enclosure, and an expansive walk-in closet!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17, Block 3, Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642788' WHERE `Matrix_Unique_ID` = '202870026' --> 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','208528677','1669642788','208528677','2022-11-26T07:57:49.590','90217578','Jimmy Franklin','Pulte Homes','','','30.132495','-95.659494','11','77355','7','322990.00','Active','Decker Farms','26540','Lane','Magnolia','3','0','4','2606','Single-Family','','','15','Centex','','','','Other Disclosures','1','','','Tomball','Central Gas','1','Lot 16, Block 9, Section 1','Corner,Subdivision Lot','','','','650','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','53 - Tomball','DECKER PRAIRIE ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Decker Farms','','3.42','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:35:54.173' ,`MLSNumber` = '2705395' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = 'Ariana Lopez' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.071734' ,`Longitude` = '-95.720248' ,`PhotoCount` = '20' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '429000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Blossoming Buttercup' ,`StreetNumber` = '19014' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern design with traditional elements, this gorgeous 2-story home offers 5 bedrooms, 3 and a half baths, a spacious open kitchen, and excellent curb appeal. The curved dining area adds a touch of elegance to this innovative design. Enjoy chef-style dinners inside your amazing kitchen that opens right into the family room. This home is perfect for entertaining guests or enjoying a cozy game night in your upstairs game room.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Block 2, Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosehill Reserve' ,`TaxAmount` = '' ,`TaxRate` = '3.5645' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642788' WHERE `Matrix_Unique_ID` = '209242565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:47:55.250' ,`MLSNumber` = '28278816' ,`ListAgentFullName` = 'Sherry Williams' ,`ListOfficeName` = 'Bay City Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.982689' ,`Longitude` = '-95.973835' ,`PhotoCount` = '20' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = '7th' ,`StreetNumber` = '1320' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely historic home converted to commercial office space. All new plumbing, electrical, HVAC and roof in 2016. 33 solar panels on roof. New insulated vinyl siding and all new windows within the past 3 years. Huge lot with loads of parking. Bathrooms both upstairs and downstairs. Beautiful hardwood floors throughout all the main rooms.' ,`Acres` = '0.4304' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAY CITY ORIGINAL TOWNSITE, BLOCK 35, LOT 7-8 & E/2 LOT 9' ,`LotDesciption` = 'Corner' ,`LotSize` = '18750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Bay City Original Townsite' ,`TaxAmount` = '5202' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1928' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642788' WHERE `Matrix_Unique_ID` = '211237201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T07:49:20.530' ,`MLSNumber` = '10911383' ,`ListAgentFullName` = 'Ted Simon' ,`ListOfficeName` = 'Ted Simon Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.487553' ,`Longitude` = '-94.916581' ,`PhotoCount` = '16' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '90000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadway' ,`StreetNumber` = '418' ,`StreetSuffix` = '' ,`City` = 'San Leon' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super home for the person who want to take a two to three-block walk to the Gulf Coast shoreline. Tiny home which has just had repairs completed and repainted. No flooding of record. Close to popular restaurants, public boat ramps and parks. Come see the sunny San Leon area. Ameneties nearby include the seaside Sunset Bar with nearby fishing including a lengthy fishing pier. Close by restaurants with a variety of tasty seafood include Pier 6, Gilhooleys and Top Water Grill.' ,`Acres` = '0.0775' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOT 2 BLK 102 SAN LEON' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '3375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '1378' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642789' WHERE `Matrix_Unique_ID` = '211765820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:56:24.340' ,`MLSNumber` = '18680200' ,`ListAgentFullName` = 'Sonali Mansukhani' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045598' ,`Longitude` = '-95.463720' ,`PhotoCount` = '24' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '482000.00' ,`Status` = 'Active' ,`StreetName` = 'Lena Trail' ,`StreetNumber` = '18631' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3186' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the quiet community of Mirror Lake, this pristine, meticulously cared for home awaits! Impressive built consists of 4 bedrooms/3 full baths. Inviting entry with high ceilings and tile floors throughout the main areas. Open concept family room w/wall of windows, stone gas log fireplace flows into kitchen & morning area. Island Kitchen w/bar height counter seating, upgraded s/s appliances, walk-in pantry, and granite counters. Spacious owner suite w/garden tub, separate shower, dual sinks, huge closet. Secondary bedrooms have walk in closets and ceiling fans. Two additional full baths offer furniture style cabinets with granite counter tops. Over sized covered back patio. Did not lose power or have any burst pipes during the big freeze! Never Flooded! Highly rated KISD!! Schedule your showing today!' ,`Acres` = '0.1445' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 52 BLK 1 CAMP MIRROR LAKE SEC 1 R/P & EXTN' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6293' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camp Mirror Lake Sub Sec 1 Rep 1' ,`TaxAmount` = '8689' ,`TaxRate` = '2.569' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642789' WHERE `Matrix_Unique_ID` = '211951014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:45:10.050' ,`MLSNumber` = '989323' ,`ListAgentFullName` = 'Julie Dubros' ,`ListOfficeName` = 'Martin Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.182110' ,`Longitude` = '-95.193681' ,`PhotoCount` = '25' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'Elm' ,`StreetNumber` = '374' ,`StreetSuffix` = 'Street' ,`City` = 'Woodbranch' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous energy efficient brick home on .50218 acres, saltwater pool with handicaps ramp, multiple upgrades throughout; three bedroom, two bath; large family room with a wood burning fireplace, granite counters in Kitchen & bathrooms, stainless steel appliances, island with barstool seating, master bath offers a Jetta walk-in tub, gas cooktop, never loose power, home equipped with a generic generator, 2-500 gallon propane tanks, low electric bills, home has solar panels & a nest thermostat, ring doorbell, Covered RV parking, separate storage and 1 bedroom studio apartment behind home, additional room on the side of home to park a flat bed trailer, quiet community, perfect place to raise a family quick access to Hwy 59 North, 10 minute drive to the Grand parkway.' ,`Acres` = '0.5' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric,Propane,Solar Assisted' ,`HOAMandatory` = '0' ,`Legal` = 'S961006 - WOODBRANCH 06, LOT 374, 50.000000% UDI' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '21875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodbranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642789' WHERE `Matrix_Unique_ID` = '212681852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T07:37:03.747' ,`MLSNumber` = '93589341' ,`ListAgentFullName` = 'Barett Engelhardt' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.078269' ,`Longitude` = '-95.396281' ,`PhotoCount` = '19' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage Hill' ,`StreetNumber` = '25510' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1929' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully-updated in Lexington Woods! This charming community welcomes you home; enjoy the mature trees, peaceful feel, and gated community pool. Your one-story 4/2 has lots of updates to enjoy. Great open floorplan connects the modernized kitchen with the family room. Large living room boasts soaring ceilings and lots of natural light. New paint inside and out, new lighting, new luxury vinyl plank and carpet, and NO HISTORY OF FLOODING! Superb access to I-45 N Corridor and Hardy Toll Road! Make an appointment today!\r\n\r\nSeller to include One year Home Warranty.' ,`Acres` = '0.1928' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 15 LEXINGTON WOODS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods Sec 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642789' WHERE `Matrix_Unique_ID` = '212814911' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:52:51.187' ,`MLSNumber` = '28927159' ,`ListAgentFullName` = 'Lucy Aguirre Moore' ,`ListOfficeName` = 'Kino Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226821' ,`Longitude` = '-95.565356' ,`PhotoCount` = '32' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Weisinger' ,`StreetNumber` = '414' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nicely remodeled one-story home in half acre in Westwood features 3 bedrooms/2 baths/2 extra large garage and is ready for immediate move-in. Some of the upgrades include the following: new quartz countertops in kitchen, light fixtures and ceiling fans, new interior and exterior paint, new exterior doors, hardware, new appliances, bathroom tile, toilets, vinyl plank, carpet. Come check it out and fall in love.' ,`Acres` = '0.4591' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD 03, BLOCK 2, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood 03' ,`TaxAmount` = '4646' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642790' WHERE `Matrix_Unique_ID` = '212821277' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:10:02.957' ,`MLSNumber` = '67402719' ,`ListAgentFullName` = 'Deborah Fontenette' ,`ListOfficeName` = 'Realty Austin, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051940' ,`Longitude` = '-95.383587' ,`PhotoCount` = '35' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '172500.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Bird' ,`StreetNumber` = '23415' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled inside and out 2 Bedroom 1 bath home with one car attached garage. Designer kitchen and bathroom that you will fall in love with. High ceilings combined with fresh paint, ceiling fans, updated fixtures and lovely covered side patio area will creates an inviting home that leaves you feeling warm and welcomed. Truly have to see this beautiful home for yourself. Roof was replaces in July 2022. Come see this beautiful one story home in the heart of Spring. A great location with easy access to everything Spring has to offer Close to area shopping, dining, schools, 45 and Hardy toll road. Schedule your showing today!' ,`Acres` = '0.1313' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 42A BLK 10 CYPRESS TRAILS OF TIMBERLANE 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trails Timberlane 01' ,`TaxAmount` = '3304' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642790' WHERE `Matrix_Unique_ID` = '212993273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:26:09.177' ,`MLSNumber` = '11649126' ,`ListAgentFullName` = 'Lindsay Sterling' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.994235' ,`Longitude` = '-95.143533' ,`PhotoCount` = '47' ,`PostalCode` = '77346' ,`RoomCount` = '11' ,`ListPrice` = '396900.00' ,`Status` = 'Active' ,`StreetName` = 'Mile Run' ,`StreetNumber` = '8624' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3897' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With almost 4,000 square feet of living space ($101.85/sq ft), this well-kept one owner home will not disappoint! They don\'t build them like this anymore. With TONS of STORAGE, oversized bedrooms and large walk-in closets, the layout is equally spacious and functional. There are linen closets in each bathroom and storage closets throughout. The fully enclosed cedar patio with ceiling fans and strung lights is the highlight of this home, along with the pavered extended patio complete with custom landscaping and lighting for enchanted evenings under the stars. Inside, the kitchen has been upgraded with custom, solid wood cabinetry, pull out drawers and a mobile island any chef will appreciate. All bathrooms have been remodeled. This home is incredibly ENERGY EFFICIENT. See attached sheet for extensive list of upgrades including NEW ROOF 2018, NEW IONIC HVAC SYSTEM 2020, ALL NEW RENEWAL by ANDERSON WINDOWS 2018. NEVER FLOODED! Schedule your tour today!' ,`Acres` = '0.1928' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 17 OLYMPIC VILLAGE WALDEN ON LAKE HOUSTON PH 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston Ph 02' ,`TaxAmount` = '7808' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642790' WHERE `Matrix_Unique_ID` = '212993715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:04:42.040' ,`MLSNumber` = '46360616' ,`ListAgentFullName` = 'Gretchen Barrilleaux' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Taiwo Oyeduntan' ,`SellingOfficeName` = 'Lone Star Realty' ,`Latitude` = '29.668591' ,`Longitude` = '-95.684791' ,`PhotoCount` = '38' ,`PostalCode` = '77407' ,`RoomCount` = '9' ,`ListPrice` = '430000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Audrey Arbor Way' ,`StreetNumber` = '17147' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2781' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this FANTASTIC, well-maintained 4 bedroom/3.5 bath home with study and game room! A cozy front porch greets you home as soaring ceilings and great natural light sweeps you in! Upgraded brick and stone exterior. The family room boasts a wall of windows and is open to the island kitchen which features gas cooking, walk-in pantry, SS appliances, 42\" cabinets and more! Home is neutral throughout and has great storage! Relax in the private owner\'s retreat with dual sinks, soaking tub, separate shower and spacious walk-in closet. All bathrooms have granite! Nice secondary bedrooms! Mud space! Enjoy the private backyard with extended covered patio. Sprinkler system! Nice neighborhood amenities! Close to lots of shopping and restaurants!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Camellia Section 1, Block 1, Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HOLLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camellia' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642790' WHERE `Matrix_Unique_ID` = '213020206' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T07:44:12.300' ,`MLSNumber` = '55121666' ,`ListAgentFullName` = 'Patricia Grijalva' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Alejandra De La Campa' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.178072' ,`Longitude` = '-95.583561' ,`PhotoCount` = '49' ,`PostalCode` = '77382' ,`RoomCount` = '12' ,`ListPrice` = '689000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Caulfield' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss the opportunity to tour this beautiful house, located in the Village of Sterling Ridge in The Woodlands, features 5 spacious bedrooms, a game room, 3.5 baths and WOOW!! Two studies/offices on the first floor with French doors, or one study and a flex room that could be used as a second study, formal living or 6th bedroom. Open floor plan, full of light, nice views from every window, no back neighbors, travertine flooring, wood floors, this house has it all!! Freshly painted with a neutral color, brand new carpet, oversized garage,next to a peaceful pond park with a nice fountain, and a few steps from the Spindle Tree Jogging Trail reserve. New roof and new gutters 2021, upgraded security system, including window sensors in all windows, glass break detectors and cameras front and back of the house. Huge attic with finished flooring to store EVERYTHING you need.\r\nExemplary schools zone. Close to parks, trails, tennis courts, shopping centers, and restaurants. Don’t miss it' ,`Acres` = '0.2351' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S969940 - WDLNDS VIL STERLING RIDGE 40, BLOCK 1, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10242' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Sterling Ridge 40' ,`TaxAmount` = '10406' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642791' WHERE `Matrix_Unique_ID` = '213572258' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:15:23.153' ,`MLSNumber` = '21827438' ,`ListAgentFullName` = 'Sandra Sawyer' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.645732' ,`Longitude` = '-95.225982' ,`PhotoCount` = '17' ,`PostalCode` = '77034' ,`RoomCount` = '8' ,`ListPrice` = '219999.00' ,`Status` = 'Active' ,`StreetName` = 'Edgebrook' ,`StreetNumber` = '531' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You’ve got to come see all the updates in this recently remodeled home! Windows, central A/C, furnace, bathrooms, stainless appliances including double-oven, water heater, cabinets, lighting, flooring, all recently replaced. Second bathroom straight down the hall so convenient for your guests, giving you a private bathroom! Vacant and ready to move in! Conveniently located to I-45 & Beltway 8 (Sam Houston tollway), you can zip to downtown, or all around Houston, minutes from Hobby Airport, or down to the beach! And no HOA for added freedoms with ownership!' ,`Acres` = '0.1655' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 56 FREEWAY MANOR SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7209' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FREEMAN ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Freeway Manor' ,`TaxAmount` = '3777' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642791' WHERE `Matrix_Unique_ID` = '213817683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:35:57.920' ,`MLSNumber` = '23774159' ,`ListAgentFullName` = 'Valerie Gil' ,`ListOfficeName` = 'Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.330192' ,`Longitude` = '-94.941473' ,`PhotoCount` = '43' ,`PostalCode` = '77563' ,`RoomCount` = '8' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Vista Drive' ,`StreetNumber` = '77' ,`StreetSuffix` = 'Drive' ,`City` = 'Bayou Vista' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live the dream in paradise! Enjoy fishing from your backyard and breathtaking sunsets. 4 /5 Bedrooms + Study. Step inside to find an open floor plan with fresh paint, new luxury vinyl flooring & brick fireplace. living area, study, sitting area next to dining, 2 living areas, 2 kitchens, complete w/ stainless steel appliances, quartz counters, modern black fixtures & breakfast bars with seating for a crowd. 3 baths feature custom-tiled showers with niches & glass doors. The master suite offers a dual-sink vanity & 2 walk-in closets. There’s even more room to spread out in the huge lower level, which offers a rec room, bedroom & half bath. Recently updated low e-Windows. Spectacular outdoor living, 3 covered patios w/massive deck overlooking the canal. Covered boat slip & lift! Enjoy endless summer fun year round. Lots of extra space under the house for all your outdoor gear. Located minutes from shopping + dining in Galveston. Community Park & Pool! Don\'t let this one get away!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Abst 7 S C Bundick Sur Lot 77 & NE 30ft of Lot 78 Bayou Vist' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '9539' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Bayou Vista' ,`TaxAmount` = '5833' ,`TaxRate` = '2.29' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642791' WHERE `Matrix_Unique_ID` = '213943798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:56:52.917' ,`MLSNumber` = '35244152' ,`ListAgentFullName` = 'Sonali Mansukhani' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.866517' ,`Longitude` = '-95.072996' ,`PhotoCount` = '18' ,`PostalCode` = '77532' ,`RoomCount` = '3' ,`ListPrice` = '159000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '718' ,`StreetSuffix` = 'Avenue' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '989' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 3 bed 2 bath home located in Crosby. It has been completely remodeled. New flooring and new paint throughout the house. Big backyard to entertain family. Easy access to highway 90. Schedule your showing today!' ,`Acres` = '0.2176' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 1 ARCADIAN GARDENS SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arcadian Gardens Sec 06' ,`TaxAmount` = '1838' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642791' WHERE `Matrix_Unique_ID` = '214229869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:41:46.443' ,`MLSNumber` = '39543730' ,`ListAgentFullName` = 'Donna Bolding' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821722' ,`Longitude` = '-94.976746' ,`PhotoCount` = '21' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Annatto' ,`StreetNumber` = '5603' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2923' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do You need a big, beautiful brick home? You have to come see this one! Wow! it\'s very well taken care of and loved. You feel the peace and joy as soon as you walk in. All the bedrooms are down stairs. There is a large game room and man cave upstairs. Back yard retreat with pond and storage. Call your realtor or call me I will show it to you.' ,`Acres` = '0.1905' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 SPRINGFIELD ESTATES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8299' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Springfield Estates Sub Sec 5' ,`TaxAmount` = '8073' ,`TaxRate` = '3.095' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642791' WHERE `Matrix_Unique_ID` = '214463645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:19:45.117' ,`MLSNumber` = '8649485' ,`ListAgentFullName` = 'Yasir Zulfiqar' ,`ListOfficeName` = 'Texas Tier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.490353' ,`Longitude` = '-95.210843' ,`PhotoCount` = '35' ,`PostalCode` = '77546' ,`RoomCount` = '11' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Plantation' ,`StreetNumber` = '2002' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful large home in serene Friendswood perfect for big families or growing families! The home features primary bedroom downstairs with Two Primary Baths with huge walk-in closet. Second Primary Bedroom upstairs. Great size Formal Living and Dining with lots of natural light. Large Family room downstairs with overlooking the pool perfect for large gatherings. Huge Game room upstairs for kids and entertainment. The home offers a stunning back yard oasis with a pool and hot tub with plenty of indoor room for outdoor entertainment. Entire home is nicely updated and spacious living spaces and bedrooms offered in this home for guests and families! It is a must see, great location and easy access to FM 528, minutes from 45 and Hwy 6. Sat. Nov. 26 Open House Cancelled due to weather. ' ,`Acres` = '0.2684' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 645 PAGE 1 LOT 6 BLK 1 SOMERSET PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11691' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Somerset Place 92' ,`TaxAmount` = '8564' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642792' WHERE `Matrix_Unique_ID` = '214503732' --> 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','214565704','1669642792','214565704','2022-11-26T07:45:32.403','89636932','Jessica Moreno','eXp Realty, LLC','','','30.182432','-95.156564','48','77357','7','350000.00','Active','Colosseum','2679','Court','New Caney','2','0','3','2037','Single-Family','Welcome to 2679 N Colosseum Ct, a home built to high standards of QUALITY w/ brick & accent stone all around! Notice the brick design detail around the front window & custom designed wood entry way! With over 1,855 SF of living space on almost 1/2 acre of land, this spacious one story 3 bed, 2 bath home has a large open living area feat. elegant large tile flooring, custom tray ceiling w/ recessed lighting, beautiful stone gas log fireplace w/detailed mantel & custom arched built-ins w/ enough shelving for family photos & storage cabinets! Two tall windows allow for plenty of light too! Kitchen opens up to living area & is well laid out w/ TONS of storage in these custom built cabinets & drawers, granite countertops, well combined backsplash, & upgraded SS appliances! Custom arched doorways throughout, primary bedroom features TWO walk in closets, tray ceiling & jetted jacuzzi! Addt\'l features: extended covered back patio, outdoor kitchen area, 30 amp RV Hook up, added 16 FT driveway.','0.4543','40','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Porter/New Caney East','Central Electric','0','S839702 - ROMAN FOREST 02, BLOCK 3, LOT 45','Cleared','19789','Appraisal District','','','0','','2','Electric Oven','0','','','Gas Range','','Composition','39 - New Caney','DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Roman Forest 02','7657','2.9064','Public Sewer,Public Water,Water District','2015','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T07:36:10.180' ,`MLSNumber` = '6819047' ,`ListAgentFullName` = 'Tasha Armstead-Bey' ,`ListOfficeName` = 'CR Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984473' ,`Longitude` = '-95.518940' ,`PhotoCount` = '16' ,`PostalCode` = '77069' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Wanakah' ,`StreetNumber` = '5703' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome HOME! This beautiful 4-bedroom home is located in the highly desirable Champions community on a corner lot and is equipped with 2.5 baths. It has a formal living room, dining room, and a family room which is open to breakfast and kitchen areas. The family room has clear views of the oversized backyard of your dreams! Detached 2-car garage. The primary bedroom is located on the first floor. The primary ensuite has double sinks and tons of room and opportunity. Three bedrooms upstairs with access to a full bathroom with double sinks. This house is a must-see and will not last long!! This is just the Home you and your family want for the Holidays!!' ,`Acres` = '0.2686' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 131 BLK 8 CHAMPIONS EAST U/R & PAR R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champion East Unr Pt & Rp' ,`TaxAmount` = '5673' ,`TaxRate` = '2.4906' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642792' WHERE `Matrix_Unique_ID` = '214607291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:44:43.873' ,`MLSNumber` = '92625165' ,`ListAgentFullName` = 'Rick Raymor' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864433' ,`Longitude` = '-95.631699' ,`PhotoCount` = '30' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Arcadian Shores' ,`StreetNumber` = '6214' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful property offers a functional & practical floorplan with close walk to park. Oversized garage with additional space for storage or workshop!! Recent updates and improvements include: Plumbing 2016 approx $14,000, HVAC in 2015 approx $8,000, Ductwork in 2015 approx $3,000, Flooring and interior paint 2021 approx $38,000, water heater 2021 approx $1400, Roof 2016 approx $7000, Garage door and Opener $1200, North fence and gate 2022 $1600. Floorplan features large kitchen w/28 cabinets & drawers, HUGE family room with vaulted ceilings, Split bedroom plan with grand sized primary bedroom, Primary bedroom with big walk in shower and closet. Covered patio!' ,`Acres` = '0.1916' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 JAMESTOWN COLONY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8346' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jamestown Colony' ,`TaxAmount` = '4486' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642792' WHERE `Matrix_Unique_ID` = '214631734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T08:41:40.140' ,`MLSNumber` = '23786650' ,`ListAgentFullName` = 'Alan Herrera' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.929135' ,`Longitude` = '-95.569664' ,`PhotoCount` = '17' ,`PostalCode` = '77064' ,`RoomCount` = '11' ,`ListPrice` = '284000.00' ,`Status` = 'Active' ,`StreetName` = 'Rippling Fields' ,`StreetNumber` = '9910' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculately maintained! New low E windows throughout. Kitchen features lots of cabinetry. The breakfast room flows effortlessly into the living room which features a floor to ceiling brick fireplace. Main room retreat features & in-suite bathroom with updated amenities, granite tops and large glass surround walk in shower with custom tile work and shower seat. Mature trees that bring character to your backyard as you enjoy a beautiful screened room!! the perfect place to appreciate your new home.' ,`Acres` = '0.1716' ,`Area` = '10' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 9 HARVEST BEND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRANCONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Bend Sec 01' ,`TaxAmount` = '5239' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642792' WHERE `Matrix_Unique_ID` = '214795189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T07:37:19.847' ,`MLSNumber` = '97695259' ,`ListAgentFullName` = 'Derald Jackson' ,`ListOfficeName` = 'Core One Real Estate, L.L.C' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654762' ,`Longitude` = '-95.580427' ,`PhotoCount` = '31' ,`PostalCode` = '77099' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Ensbrook' ,`StreetNumber` = '11519' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely updated one-story home in the well-established Park Glen subdivision. The home features updated quartz kitchen counters, stainless steel sink, dishwasher, faucet, disposal! Updated roof, HVAC system, windows, water heater, and freshly painted interior. The home features wood burning fire place in living room with vaulted ceiling. Primary bedroom has separate vanity with large walk-in closet. Kitchen can be accessed off dining room. Property location is conveniently located close to 59, BW8, 90, Fort Bend toll freeways. Set an appointment to see this one today before it is gone!' ,`Acres` = '0.1398' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 21 PARKGLEN SEC 4 - ALIEF' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6090' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CUMMINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkglen Sec 04 Alief' ,`TaxAmount` = '4342' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642793' WHERE `Matrix_Unique_ID` = '214801633' --> 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','214994466','1669642793','214994466','2022-11-26T08:40:04.547','36075054','Joyce Adamiak','eXp Realty, LLC','','','29.558931','-95.021567','50','77586','11','485000.00','Active','Staples','1003','Avenue','Seabrook','2','1','3','2145','Single-Family','SEABROOK NEW CONSTRUCTION READY FOR NEW HOMEOWNER~ 3 BEDROOMS ~ 2 BATHS ~ GOURMET ISLAND KITCHEN OPEN TO BEAUTIFUL FIRE PLACED FAMILY ROOM ~ FRONT AND BACK COVERED PORCHES ~ GREAT NEIGHBORHOOD WITHIN WALKING DISTANCE TO THE BAY AND A SHORT DRIVE TO KEMAH BOARDWALK ~ YOU WON’T BE DISAPPOINTED.','','7','Bayou Banks Classic','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Clear Lake Area','Zoned','0','Lot 7 Blk 43 Seabrook','Cleared','','','','','1','To Be Built/Under Construction','','Freestanding Oven','0','','','Freestanding Range','','Composition','9 - Clear Creek','BAY ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Appointment Required','Builder','2','Other Style','Seabrook','','','Public Sewer,Public Water','','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','215047783','1669642793','215047783','2022-11-26T08:33:47.740','19805600','Maura Tinoco','Prompt Realty & Mortgage, Inc','','','29.858532','-95.302135','23','77016','8','224800.00','Active','Royal Oaks Dr','10118','Drive','Houston','2','0','3','1250','Single-Family','Beautifully remodeled home with a large backyard! Home has been completely updated. Updates include new HVAC, new roof, Carrara Quartz counter tops throughout, new floors, new doors, new stainless steel appliances, updated bathrooms and kitchen! Schedule your showing today!','0.1511','2','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Northside','Central Electric','0','LT 739 BLK 27 FONTAINE PLACE SEC 5','Subdivision Lot','6584','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Fontaine Place Sec 05','3367','2.3307','Public Sewer,Public Water','1960','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','215078112','1669642793','215078112','2022-11-26T08:59:42.483','83489028','Patricia Perez','Vive Realty LLC','','','29.676915','-95.216140','15','77502','7','240000.00','Active','Arion','712','Lane','Pasadena','2','0','3','1677','Single-Family','Be in your new home by the new year! Right in the heart of Pasadena Texas! Three bedrooms, two bathrooms. This home has spacious rooms throughout. Home is sold as is. This home has a lot of potential. Bring your own personal touch to make it your dream house. Hurry and make an appointment before its gone!','0.1768','6','','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','','','','Pasadena','Central Electric','0','W 30 FT OF LT 373 & E 40 FT OF 374 VINCE HEIGHTS SEC 4','Subdivision Lot','7700','Appraisal District','','','0','','2','','0','','','Gas Range','','Composition','41 - Pasadena','SOUTH SHAVER ELEMENTARY SCHOOL','PASADENA HIGH SCHOOL','SOUTHMORE INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Vince Heights Sec 04','4776','2.6514','Public Sewer,Public Water','1953','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','215091672','1669642793','215091672','2022-11-26T08:08:01.093','2984775','Sarah Nezhad','RE/MAX Grand','','','29.815505','-95.743831','25','77449','6','289900.00','Active','Roaring Oaks','2810','Lane','Katy','2','0','3','2178','Single-Family','Well kept one story home with 3/4 bedrooms & 2 baths in highly sought after Morton Ranch, Katy, Tx. Kitchen with granite counter tops and back splash, Kitchen is open to living room that contains natural gas fireplace. Primary bedroom with cathedral style ceilings, and walk in closet leads to an added room that can be used as a bedroom or study. Primary bath with double sinks and upgraded shower. Garage is converted to a room with closet, lights, A/C and carpet flooring.(can be converted back to garage) Recent updates - 2019 LG microwave and stove/oven, 2021 new water heater, 2022 garbage disposal and 2019 new roof. Walking distance to beautiful community lake, walking trails, pool and schools. Zoned to katy isd highly accredited schools.','0.1288','25','','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','0','Gas Connections','1','Katy - North','Central Gas','1','LT 27 BLK 2 MORTON RANCH SEC 5','Subdivision Lot','5610','Appraisal District','','575','0','','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','MORTON RANCH ELEMENTARY SCHOOL','MORTON RANCH HIGH SCHOOL','MORTON RANCH JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Morton Ranch Sec 5','5417','3.1233','Public Sewer,Public Water,Water District','2009','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','215096302','1669642793','215096302','2022-11-26T08:18:04.233','33772027','Diana Dawson','TADA Homes, LLC','','','29.502270','-94.985551','9','77518','3','113550.00','Active','11th','4731','Street','Bacliff','1','0','1','492','Single-Family','This cozy home has such a well designed space. As you enter, you\'ll find the living area with plenty of space to relax. The kitchen has everything you need to cook up your favorite meals, including space for a dining table. Then, you\'ll find the bedroom and bathroom with a tub/shower and a walk-in closet! Oversized one car garage with an extension. This tiny home is perfect for anyone looking for a compact, yet comfortable place to call home! New siding, appliances, cabinets, countertops, mini split AC unit, water heater, exterior doors, interior lighting, flooring, windows, all installed in 2022. Come check it out - won\'t last long!','0.154','33','','','Washer Connections','','Mud,Sellers Disclosure','0','','0','Bacliff/San Leon','Wall Heater','0','ABST 164 E PAYNE SUR LOTS 30 THRU 35 CLIFTON BY THE SEA REPL','Subdivision Lot','6250','Survey','','','0','','1','Electric Oven','0','','','Electric Range','','Aluminum','17 - Dickinson','KENNETH E. LITTLE ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Clifton By The Sea','1468','2.2342','Public Sewer,Public Water','1960','Appraisal District'); --> New record created successfully