Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T23:33:04.510' ,`MLSNumber` = '7378293' ,`ListAgentFullName` = 'Ryan Hajdik' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.974401' ,`Longitude` = '-95.515676' ,`PhotoCount` = '34' ,`PostalCode` = '77066' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Old Lodge' ,`StreetNumber` = '5923' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop the TRAIN! This property has it all! Updated Kitchen and bathrooms! Look at the floors in this home! Great schools and location! No a busy street and plenty of room in the back yard for BBQ-ing and relaxing. Detached Garage in the rear with an extra long drive way makes this a dream find! Master down! Back of garage has a garage door for pull through access to back yard! Sprinkler system!' ,`Acres` = '0.2158' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 017*G6652900-001-004-006 GREENWOOD FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'GREENWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenwood Forest Sec 01' ,`TaxAmount` = '4269' ,`TaxRate` = '2.3715' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709884' WHERE `Matrix_Unique_ID` = '208009575' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T23:07:08.800' ,`MLSNumber` = '31485758' ,`ListAgentFullName` = 'Nehal Farrag' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829795' ,`Longitude` = '-95.799234' ,`PhotoCount` = '21' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '409999.00' ,`Status` = 'Active' ,`StreetName` = 'Carlo Hue' ,`StreetNumber` = '24519' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2129' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy your own slice of paradise in this gorgeous home in Camillo Lakes built right on the lake! This home which was built in 2021 features 4 bedrooms and 2 1/2 baths. Open floor concept with amazing views of the lake from the kitchen and living room. The kitchen has plenty of storage, a large island and beautiful granite countertops. The primary bedroom which is on the first floor also has lake views and an ensuite bathroom with double sinks, shower and tub. Upstairs you will find 3 spacious bedrooms and a large game room. Enjoy your days and evenings under the covered patio and perfect views of the fully stocked lake and fountain. Refrigerator, washer and dryer are included. Contact me or your agent to check this house out today!' ,`Acres` = '0.096' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 4 CAMILLO LAKES SEC 4' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '4181' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes Sec 4' ,`TaxAmount` = '9030' ,`TaxRate` = '3.5333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709885' WHERE `Matrix_Unique_ID` = '208949837' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:43:19.963' ,`MLSNumber` = '76168642' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518729' ,`Longitude` = '-95.437303' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Penton Meadow' ,`StreetNumber` = '4910' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2111' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Brookstone Collection \'\'Sandstone\" Plan by Lennar Homes with Elevation \"A\" in Beautiful Lakes of Savannah! A spacious single story home design features a smart layout that is perfect for young families. Down the hall is an open concept living area, featuring a covered patio in the back. Next to the living area are three bedrooms, including the owner’s suite which features a private bathroom and a walk-in closet. *HOME ESTIMATED TO BE COMPLETE, NOVEMBER, 2022*' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0019 BLK 001 LOT 012' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah Brookstone' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709885' WHERE `Matrix_Unique_ID` = '209633216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:46:15.570' ,`MLSNumber` = '3253724' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.187223' ,`Longitude` = '-95.417369' ,`PhotoCount` = '18' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Bennett' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Loop' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1461' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Cottage Collection \"Chestnut\" Plan with Elevation \"B\" in Riverwood Ranch! This single-story home has a smart layout that makes good use of the available space. The front door leads into an open concept family room which flows into the dining room and kitchen for easy transitions during meals or parties. Two bedrooms share a bathroom at the front of the home, while the owner’s suite is tucked into the back corner for maximum privacy, along with a bathroom and walk-in closet. *HOME ESTIMATED TO BE COMPLETE, November, 2022*' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0002 BLK 001 LOT 002' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.744432' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709885' WHERE `Matrix_Unique_ID` = '209696265' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:11:30.373' ,`MLSNumber` = '47837323' ,`ListAgentFullName` = 'Leonor Anguiano' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.880265' ,`Longitude` = '-95.634443' ,`PhotoCount` = '50' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Halfpenny' ,`StreetNumber` = '7014' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Spacious home is in a rare find and sits off the golf course, which is central to the Heartstone Country Club Community. It has no history of flooding and enjoys convenient access to area amenities via Highway 529, Highway 6, Beltway 8, and 290. The 5 BR /3.5 BA home has a detached 2-car garage with a WORKSHOP and a side door for golf cart access and additional parking. Recent updates include lighting, flooring, paint, recent foundation repairs; NEW ROOF,, slate entry floor, upstairs air handler (installed 2022) new heat pump for downstairs (installed 2021) Upgraded electrical panel;, the whole house reverses osmosis water system; \"Low E\" windows; and PEX piping throughout. Primary suites are located on the First and Second floors, plus extensive storage throughout the home\'s interior decked attic and detached garage. Optional membership to the Hearthstone Country Club offers premium golf, tennis, swimming, dining, and exercise facilities. Primary on 1st and 2nd fl.' ,`Acres` = '0.2525' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 3 FAIRWAY WEST SEC 1 R/P' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '11000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'OWENS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone' ,`TaxAmount` = '7053' ,`TaxRate` = '2.501' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709885' WHERE `Matrix_Unique_ID` = '209809935' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:30:10.800' ,`MLSNumber` = '17925465' ,`ListAgentFullName` = 'Dee Banks' ,`ListOfficeName` = 'RE/MAX River Cities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.101886' ,`Longitude` = '-95.247267' ,`PhotoCount` = '26' ,`PostalCode` = '77365' ,`RoomCount` = '3' ,`ListPrice` = '264500.00' ,`Status` = 'Active' ,`StreetName` = 'Martin' ,`StreetNumber` = '23745' ,`StreetSuffix` = 'Circle' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2111' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely updated 3 bedrooms Plus office downstairs off entry , fireplace, primary bedroom down with en suite, 2 bedrooms and full bath plus game room upstairs, fenced back yard, awesome cul-de-sac location next to pond, easy access to US 59 4.3 miles from Kingwood and easy access to Conroe and I 45 via FM 1314. 2 car garage vacant and ready for immediate move in!' ,`Acres` = '0.1282' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S267700 - BRIAR TREE COURT, BLOCK 1, LOT 33' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt' ,`LotSize` = '5583' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Tree Court' ,`TaxAmount` = '5957' ,`TaxRate` = '2.5431' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709885' WHERE `Matrix_Unique_ID` = '210042223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:34:00.523' ,`MLSNumber` = '91399546' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518742' ,`Longitude` = '-95.437334' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Walworth Creek' ,`StreetNumber` = '14219' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Brookstone Collection \"Onyx II\" Plan with Elevation \"B\" in Lakes of Savannah! The beautiful single story Onyx II floor plan by Lennar features a lovely entrance foyer, a dining room, kitchen with breakfast area, a generous family room with access to a relaxing covered rear patio and a walk-in utility room. The master bedroom features an en suite bathroom with dual sinks, separate tub and shower, private toilet enclosure and a large walk-in master closet. *HOME ESTIMATED TO BE COMPLETE, DECEMBER, 2022*' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0019 BLK 002 LOT 014' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah Brookstone' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709885' WHERE `Matrix_Unique_ID` = '210241362' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:29:01.880' ,`MLSNumber` = '67618703' ,`ListAgentFullName` = 'Felisha Tubbs' ,`ListOfficeName` = 'Jammer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943972' ,`Longitude` = '-95.221672' ,`PhotoCount` = '15' ,`PostalCode` = '77396' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Hillside Creek' ,`StreetNumber` = '11038' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Presenting this Well-Maintained Home, Nestled in The Reserve at Park Lakes Community. This Gem was the Former LGI Model Home (The Savannah Plan), with many Upgrades to Include: Energy Efficiency Appliances, Chef-Ready Kitchen with Granite Countertops-Ample Counterspace & Upgraded Wood Cabinetry, Large Walk-in Pantry, Upgraded Tiled Shower Surrounding the tubs area, Sprinkler System, Surround Sound-Throughout the home, Spacious Family Room with Custom Wood-Style Shutters/Blinds, High Ceiling which Opens to the Inviting Formal Dining that Overlooks the covered backyard patio. Nice Spacious Master Bedroom with Retreat style Bathroom-Soaking Tub & Separate Step-In Shower, French Doors to Office/Bedroom, Light & Brightness of the home and the Solar Windows, Energy Efficient-Low Electric Bills. \"Shows Great\" The Seller has ONLY Lived in this Home for 10 months, shows great!' ,`Acres` = '0.122' ,`Area` = '1' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 (PURE ACCT*1389770010036) BALMORAL PARK LAKES EAS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5313' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Balmoral Sec 3' ,`TaxAmount` = '5666' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709885' WHERE `Matrix_Unique_ID` = '210257932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:20:23.340' ,`MLSNumber` = '11720387' ,`ListAgentFullName` = 'Nancy David' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = 'Kasta Carson' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.085475' ,`Longitude` = '-95.188936' ,`PhotoCount` = '39' ,`PostalCode` = '77365' ,`RoomCount` = '9' ,`ListPrice` = '465900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Willow Park Terrace' ,`StreetNumber` = '5731' ,`StreetSuffix` = 'Lane' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like new outstanding one story Perry home with no back neighbors. There are many upgrades throughout this very popular plan which features 4 bedrooms, home office, game/media room plus large utility room and mudroom. Beautiful tile flooring through all the main living areas & the interior is a neutral light, inviting color scheme. The large family room has a corner fireplace and is completely open to the gorgeous kitchen. Upgrades include extended covered patio, 5 burner cooktop and wall oven, raised panel cabinetry, granite in kitchen and baths, framed bath mirrors, & front and rear gutters, just to name a few. The is also a water softener system and a whole home surge protector. This floor plan has so much flexibility and offers something for everyone. Located in the highly acclaimed Humble ISD, Royal Brook is the newest village in the master planned community of Kingwood. It boasts naturally forested landscape with access to the best parks & golf courses in northeast Houston.' ,`Acres` = '0.1704' ,`Area` = '32' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 2 ROYAL BROOK AT KINGWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Brook at Kingwood Sec 1' ,`TaxAmount` = '9215' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709886' WHERE `Matrix_Unique_ID` = '210322233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:45:42.280' ,`MLSNumber` = '44035468' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.187223' ,`Longitude` = '-95.417369' ,`PhotoCount` = '18' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Bennett' ,`StreetNumber` = '205' ,`StreetSuffix` = 'Loop' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1683' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Cottage Collection \"Camellia\" Plan with Elevation \"B\" in Riverwood Ranch! This single-story home has a smart layout that is perfect in many ways. The front door leads to an open concept living area that is ideal for daily activities and entertaining guests with a modern kitchen, dining room and family room, all side by side. Three bedrooms share a hall bathroom at the front of the home, while the owner’s suite is tucked into the back with a private bathroom and large walk-in closet. *HOME ESTIMATED TO BE COMPLETE, November, 2022*' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0002 BLK 002 LOT 001' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.744432' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709886' WHERE `Matrix_Unique_ID` = '210417061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:47:24.023' ,`MLSNumber` = '16637761' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.187223' ,`Longitude` = '-95.417369' ,`PhotoCount` = '18' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Bennett' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Loop' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Cottage Collection \"Windhaven\" Plan with Elevation \"A\" in Riverwood Ranch! This single-story home has a simple layout that is perfect for families. There are three bedrooms in total, including the owner’s suite, which is at the back of the home with a walk-in closet and full bathroom. The front door leads to the open living area, which provides a place to relax and spend time together with a family room, dining area and kitchen. *HOME ESTIMATED TO BE COMPLETE, November, 2022*' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0002 BLK 001 LOT 001' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.744432' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709886' WHERE `Matrix_Unique_ID` = '210420677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:46:48.627' ,`MLSNumber` = '4939443' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.187294' ,`Longitude` = '-95.417321' ,`PhotoCount` = '19' ,`PostalCode` = '77515' ,`RoomCount` = '8' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Bennett' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Loop' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Cottage Collection \"Hawthorn\" Plan with Elevation \"A\" in Riverwood Ranch! This two-story home has a classic layout that is perfect for those who need privacy. The front door leads into the open concept family room which flows seamlessly into the kitchen and dining room at the back of the home. The owner’s suite is adjacent with a private bathroom and walk-in closet. Upstairs, three bedrooms and a laundry room connect to a versatile loft. *HOME ESTIMATED TO BE COMPLETE, DECEMBER, 2022*' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0002 BLK 002 LOT 003' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.744432' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709886' WHERE `Matrix_Unique_ID` = '210422109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:44:53.563' ,`MLSNumber` = '82484510' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510819' ,`Longitude` = '-95.444968' ,`PhotoCount` = '17' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Stratton' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2229' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Cottage Collection \"Linden\" Plan with Elevation \"A\" in Lakes of Savannah! This two-story home has a smart layout that offers space and versatility. The front door leads into the family room which connects with a dining area and kitchen around the corner in a flexible open layout. Upstairs are four bedrooms, including the owner’s suite, which features a private bathroom and walk-in closet. *HOME ESTIMATED TO BE COMPLETE, DECEMBER, 2022*' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0021 BLK 002 LOT 032' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '' ,`TaxRate` = '3.093' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709886' WHERE `Matrix_Unique_ID` = '210989899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:34:44.750' ,`MLSNumber` = '25531207' ,`ListAgentFullName` = 'Yolanda Williams' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = 'Bradley Stevens' ,`SellingOfficeName` = 'Stevens Vita Equity Realty Inc' ,`Latitude` = '29.596648' ,`Longitude` = '-95.506978' ,`PhotoCount` = '31' ,`PostalCode` = '77489' ,`RoomCount` = '0' ,`ListPrice` = '285500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lawn Crest' ,`StreetNumber` = '2202' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2209' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hello and Welcome Home! \r\n\r\nThis fantastic 3bed | 2.5 Baths well-maintained double-story home built in 2006 features a great curb appeal. This home also offers a huge office space and flex room that can be used as an additional 4th bedroom. \r\n\r\nYou will love the open living space and kitchen, island, large pantry, and gas range. It boasts of a large primary bedroom, the posh owner\'s suite has two large walk-in closets and a beautiful spa-like ensuite bath with dual sinks, a garden tub, and a separate walk-in shower. \r\n\r\nThis home is located in a quiet neighborhood just off the Fort Bend Parkway. Meadow Crest offers quick access to the Sam Houston Tollway and Highway 90. This convenient location is close to downtown Houston, Sugar Land, and the Texas Medical Center with quick access to the Sam Houston Tollway and Highway 90. \r\n\r\nNot to mention the added bonus: Brand new roof in 2020 and new furnace. \r\nCome see and make this beautiful home yours!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MEADOW CREST SEC 1, BLOCK 3, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '299' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HUNTERS GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Crest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709886' WHERE `Matrix_Unique_ID` = '211113322' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T23:06:38.193' ,`MLSNumber` = '96445287' ,`ListAgentFullName` = 'Jeffrey Tarver' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837827' ,`Longitude` = '-95.254031' ,`PhotoCount` = '38' ,`PostalCode` = '77078' ,`RoomCount` = '6' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Richland' ,`StreetNumber` = '9137' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'On almost a 1/3 acre corner lot, this 3 bedroom, 2 bath, 2 car garage home is fully bricked and nicely updated. The interior just received a complete paint job and new carpets. The exterior was painted about 1 year ago. The roof is about 10 years old. The large kitchen opens to the living room and dining room. Both bathrooms have granite countertops and large walk-in showers. The primary bedroom has two walk-in closets. Call today for an appointment.' ,`Acres` = '0.3441' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 894 BLK 36 CHATWOOD PLACE SEC 6' ,`LotDesciption` = 'Corner' ,`LotSize` = '14990' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chatwood Place' ,`TaxAmount` = '4262' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709886' WHERE `Matrix_Unique_ID` = '211347202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T22:23:56.437' ,`MLSNumber` = '58785352' ,`ListAgentFullName` = 'Jeffry Banks' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690358' ,`Longitude` = '-95.510216' ,`PhotoCount` = '25' ,`PostalCode` = '77074' ,`RoomCount` = '6' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Lugary' ,`StreetNumber` = '8119' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1964' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! Bring your vision to one of the larger homes in the neighborhood - 1,964 SF per HCAD This 3-4 bedroom home is walking distance to HBU, close to Memorial Hermann Southwest Hospital, and convenient for countless other things. Dining room has been converted into a 4th bedroom, \'breakfast room\' is dining room size. Come and see!' ,`Acres` = '0.1791' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 BLK 2 SHARPSTOWN SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MCNAMARA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown 3' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709887' WHERE `Matrix_Unique_ID` = '211364179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T23:03:24.753' ,`MLSNumber` = '49705169' ,`ListAgentFullName` = 'Maria Bonilla' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Stephanie Miller' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.827070' ,`Longitude` = '-95.316748' ,`PhotoCount` = '5' ,`PostalCode` = '77016' ,`RoomCount` = '6' ,`ListPrice` = '211289.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wileyvale' ,`StreetNumber` = '7417' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Contruction! Make new memories in this amazing One story 3-bedroom open concept, no carpet Home. This house is near shopping centers and freeways Minutes from Downtown. Amazing Price don’t miss out this great opportunity. Please verify room dimensions and schools.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Europa Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'lot 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6240' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trinity Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709887' WHERE `Matrix_Unique_ID` = '211379658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T23:19:44.347' ,`MLSNumber` = '11883809' ,`ListAgentFullName` = 'Yuri Ibarra' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.585048' ,`Longitude` = '-95.104638' ,`PhotoCount` = '46' ,`PostalCode` = '77059' ,`RoomCount` = '5' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Brook Forest' ,`StreetNumber` = '16514' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4502' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for privacy? Located on a cul-de-sac, no back neighbors and access to the bayou this home delivers! With plenty of updates which include sprinkler system, new driveway, renovated pool & lavish landscaping. Featuring 5 bedrooms, 5 baths, theater room & a glowing fireplace. 2 family rooms with a wall of windows that stretch from the floor to the soaring ceilings. The kitchen will inspire the inner chef in you with high end appliances, quartz island & windows allowing tranquil views of the back yard. Large on suite primary bedroom features huge walk-in closets, a lavish en-suite spa bath, a walk-in shower, his/her vanity. Bedrooms upstairs grant access to the oversized balcony that overlooks the heated outdoor pool. This property also includes a garage apartment with total living area of 1,670sqft which features 2-bedroom,1 bath w/walking closets. Conveniently located near an array of shopping, dining options, and zoned to the outstanding CCISD schools. Come see your new home!' ,`Acres` = '0.3857' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 90 BROOK FOREST SEC 1 R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '16800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brook Forest Sec 01 Corr Pla' ,`TaxAmount` = '18855' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709887' WHERE `Matrix_Unique_ID` = '211495387' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T23:53:32.310' ,`MLSNumber` = '25230852' ,`ListAgentFullName` = 'Mindy Buivantri' ,`ListOfficeName` = 'Hometown America Incorporated' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764111' ,`Longitude` = '-94.951092' ,`PhotoCount` = '28' ,`PostalCode` = '77521' ,`RoomCount` = '14' ,`ListPrice` = '314000.00' ,`Status` = 'Active' ,`StreetName` = 'Jeanie' ,`StreetNumber` = '1201' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly renovated home in a quiet cul-de-sac located in the Knight C A subdivision. Situated on 8,890 sq.ft., est. GLA w/dimension floor plan 2747 sq.ft. This home features 5 bdrm/2.1 bath, study room, fireplace, new (roof, appliances, flooring, back fence, renovated kitchen and bathrooms and more)' ,`Acres` = '0.2041' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 WRIGHT C A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wright C A' ,`TaxAmount` = '7234' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709887' WHERE `Matrix_Unique_ID` = '211888918' --> 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','211979361','1663709887','211979361','2022-09-12T22:36:11.470','76287174','Jared Turner','LennarVillageBldr-JaredTurner','','','29.518513','-95.437283','16','77583','8','412100.00','Active','Annandale','4415','Road','Rosharon','3','1','4','2548','Single-Family','NEW! Lennar Fairway Collection \"Cantaron\" Plan with Elevation \"E\" in Lakes of Savannah! The largest single-story home in the Fairway collection with extra garage storage space. The gourmet kitchen overlooks the living space and covered patio. There is plenty of flexibility for family living with three secondary bedrooms and a study, and the owner’s suite with an en-suite bathroom is tucked away for privacy. *HOME ESTIMATED TO BE COMPLETE, NOVEMBER, 2022*','','5','Lennar Homes','','','','Mud,Other Disclosures','1','','','Alvin North','Central Gas','1','SEC 0022 BLK 001 LOT 004','Subdivision Lot','','','','950','1','To Be Built/Under Construction','2','','0','','','','','Composition','3 - Alvin','SAVANNAH LAKES ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Lakes of Savannah','','3.54','Water District','2022','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','212449823','1663709887','212449823','2022-09-12T23:42:10.813','92171067','Usman Toor','REALM Real Estate Professional','','','29.735254','-95.367908','38','77004','5','550000.00','Active','Stuart','2107','Street','Houston','3','1','3','2033','Single-Family','Beautiful 3 story home located near to Downtown and the Museum District, also just block away from Emancipation park, open floor plan modern concept, homes is loaded with upgrades, don\'t miss the opportunity to see this beautiful home, call today for more details!!','0.0356','4','','','','','Sellers Disclosure','1','','','University Area','Central Gas','0','LT 3 BLK 1 MANORS ON STUART STREET','Subdivision Lot','1550','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal','3','Contemporary/Modern','Manors/Stuart Street','7551','2.3307','Public Sewer,Public Water','2016','Appraisal'); --> New record created successfully