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-14T22:33:53.123' ,`MLSNumber` = '64409483' ,`ListAgentFullName` = 'Laura Guillory' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Patrick Lee' ,`SellingOfficeName` = 'Dreams Come True Realty' ,`Latitude` = '29.765393' ,`Longitude` = '-95.545653' ,`PhotoCount` = '38' ,`PostalCode` = '77024' ,`RoomCount` = '9' ,`ListPrice` = '855000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tealwood North' ,`StreetNumber` = '12322' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic value! This well-maintained, spacious 5 bedroom patio home with en-suite baths is located in a private cul-de-sac enclave walking distance to highly regarded Frostwood Elementary and popular Memorial Green shopping/dining. Each bedroom (four up, one down) is very large and contains plentiful walk-in closets. The downstairs rooms with 9\' ceilings are generously sized as well, affording plentiful space for entertaining. AC units replaced 2019. Water heater replaced in 2022. Pella double-paned windows throughout and whole house power save module. 3-car garage. Enjoy a lock-and-leave lifestyle with only a front yard and patio to maintain, located minutes from Memorial City Mall and hospital, City Centre, Memorial Forest Community Club and more. Join this unique, quiet 17 home community in the heart of Memorial. All info per Seller.' ,`Acres` = '0.1626' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 TEALWOOD NORTH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7085' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Tealwood North' ,`TaxAmount` = '20142' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527642' WHERE `Matrix_Unique_ID` = '208888276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:19:00.767' ,`MLSNumber` = '50767965' ,`ListAgentFullName` = 'Sonya Garmon' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.578260' ,`Longitude` = '-95.546339' ,`PhotoCount` = '49' ,`PostalCode` = '77358' ,`RoomCount` = '10' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 1374' ,`StreetNumber` = '5933' ,`StreetSuffix` = 'Road' ,`City` = 'New Waverly' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3195' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '7.64' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'New Waverly Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'INGERSOLL J W (A-27), TRACT 34, ACRES 7.64' ,`LotDesciption` = 'Cleared' ,`LotSize` = '332798' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rural' ,`TaxAmount` = '8811' ,`TaxRate` = '1.8438' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668527643' WHERE `Matrix_Unique_ID` = '209782750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:34:24.103' ,`MLSNumber` = '97211626' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.126690' ,`Longitude` = '-94.377023' ,`PhotoCount` = '29' ,`PostalCode` = '77659' ,`RoomCount` = '8' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '1545' ,`StreetSuffix` = 'Trail' ,`City` = 'Sour Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Kingston plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The entry opens to the guest bedrooms, bath with linen closet. Center kitchen includes oversized breakfast bar with beautiful counter tops and stainless steel appliances. Open concept floorplan boasts large combined family room and dining area. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room.' ,`Acres` = '0.2798' ,`Area` = '49' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BLK 2 HOLLY TRAILS PHASE 1 AS PER PLAT 4-209 P# HT-1-2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12188' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holly Trails Ph 1' ,`TaxAmount` = '759' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527643' WHERE `Matrix_Unique_ID` = '209811281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:29:01.863' ,`MLSNumber` = '59045990' ,`ListAgentFullName` = 'Faye Ausmus' ,`ListOfficeName` = 'Ausmus Premier Properties, LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.420578' ,`Longitude` = '-97.984718' ,`PhotoCount` = '15' ,`PostalCode` = '78155' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Old Colony' ,`StreetNumber` = '436' ,`StreetSuffix` = 'Road' ,`City` = 'Seguin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Private, Quiet, Unrestricted 11 Acre Haven Awaits! Paved Road Frontage. Make this 1,120sqft, 3 Bedroom, 2 bath your home sweet home. Plenty of room to roam or add additional buildings. Bring your livestock, the sky is the limit here. The land is level and cleared in the front and mature oak trees throughout the back. The property is mostly fenced, with a pond, gated entrance, barn, and 2 RV hookups. The 1,728sqft barn has 4 12x12 stalls with windows and 2 storage/tack rooms and water and electric. The front of the home sits way back off the road giving plenty of room for the kids to roam. An additional 5 acres is available for purchase adjacent to property. 8 minutes to the brand new Dollar General, 18 minutes to the HEB plus in Seguin, 22 minutes to Blakes Cafe, 30 minutes to Lake McQueeney, and 30 minutes to New Braunfels. Don\'t wait, this little piece of Texas won\'t last long!' ,`Acres` = '11.15' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS: 59 SUR: J O BLAIR 11.1500AC MH=PFS0878301/302' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '157 - Seguin' ,`SchoolElementary` = 'VOGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEGUIN HIGH SCHOOL (SEGUIN)' ,`SchoolMiddle` = 'A.J. BRIESEMEISTER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jakes Colony Sub' ,`TaxAmount` = '4837' ,`TaxRate` = '1.6645' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527643' WHERE `Matrix_Unique_ID` = '209884175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:00:15.867' ,`MLSNumber` = '2960164' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.910460' ,`Longitude` = '-95.752342' ,`PhotoCount` = '49' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '572763.00' ,`Status` = 'Active' ,`StreetName` = 'Cecil Garden' ,`StreetNumber` = '8814' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2937' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#2960164 REPRESENTATIVE PHOTOS ADDED! December Completion - The Camelia plan offers a unique open concept living ideal for any type of entertaining! The kitchen includes an island perfect for quick meals or appetizers and is connected to the casual dining area. The owner\'s retreat has dual vanity sinks, impressive walk-in shower, and a large walk-in closet. A designated study is located off the foyer offering privacy when needed. Upstairs there are three bedrooms and a full bathroom along with a game and media room. Lounge with friends outside on the covered patio in privacy! Structural options added to 8814 Cecil Garden Lane include: study, media room, 8 foot door throughout, open railing.' ,`Acres` = '0.145' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29, Block 3 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6351' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Avalon at Cypress 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527643' WHERE `Matrix_Unique_ID` = '210470576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:51:17.420' ,`MLSNumber` = '94373096' ,`ListAgentFullName` = 'Elaine Strahan' ,`ListOfficeName` = 'Strada' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648632' ,`Longitude` = '-95.782536' ,`PhotoCount` = '36' ,`PostalCode` = '77406' ,`RoomCount` = '12' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Tierra Amarilla' ,`StreetNumber` = '3611' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3469' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The one story home you\'ve been looking for and filled with amenities to amaze! On over 1/2 acre corner lot, home offers high tray ceilings w accent niches lining the way to your large master suite. Master bath presents spa experience w extended 3 head shower including one rain/waterfall effect, and jetted tub for soaking. Includes 2 vanities, walk in closet & TV fixture. Head to Media room for movie night w surround sound, windows, blackout curtains & closet. Large open kitchen w lots of cabinets, loads of counter space & double ovens overlooks the spacious yet cozy family room. Flexibility to place TV above fireplace or on flanking built-in cabinets w surround sound connection. Informal & formal dining rooms. Step out back to enjoy covered patio w gas grill, bar & fridge. Take mere steps to fire pit to enjoy conversations & evening sunsets. Home w 4 oversized bedrooms, 1 used currently as Office w french doors, window & closet, which can easily be reverted to a bedroom.' ,`Acres` = '0.5466' ,`Area` = '37' ,`BuilderName` = 'K HOVNANIAN' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF MISSION GROVE SEC 2, BLOCK 1, LOT 1, ACRES 0.5466' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '23810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lakes Of Mission Grove Sec 2' ,`TaxAmount` = '7210' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527644' WHERE `Matrix_Unique_ID` = '210482985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:25:00.523' ,`MLSNumber` = '42577143' ,`ListAgentFullName` = 'Norbert Rivera' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Rigoberto Villarreal' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.570873' ,`Longitude` = '-95.740288' ,`PhotoCount` = '43' ,`PostalCode` = '77469' ,`RoomCount` = '5' ,`ListPrice` = '419500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hays Ranch' ,`StreetNumber` = '2203' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'s miss your opportunity to tour this Incredibly Beautiful Styled David Weekley Home located on a nearly 60\' lot in the amazing Veranda subdivision. This home has all the upgrades such as a large spacious office, to a modern fireplace design, a designer master bathroom with a separate shower and bathtub and a large roomy master. The beautiful kitchen boasts a white quartz countertop with white and grey cabinets and stainless steel appliances. Cook all your meals in double ovens and on your own 36\" gas cooktop stove and enjoy your amazing meal in your beautifully styled dining room. This home boasts a incredible natural light throughout the entire house. Veranda is the ideal master plan community with easy access to Sugar Land, Houston, the Medical Center, Downtown, and much more!' ,`Acres` = '0.1645' ,`Area` = '30' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VERANDA SEC 22, BLOCK 2, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7166' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1095' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '3075' ,`TaxRate` = '3.1798' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668527644' WHERE `Matrix_Unique_ID` = '210536222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:13:34.610' ,`MLSNumber` = '73405132' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658445' ,`Longitude` = '-95.049192' ,`PhotoCount` = '30' ,`PostalCode` = '77571' ,`RoomCount` = '12' ,`ListPrice` = '457724.00' ,`Status` = 'Active' ,`StreetName` = 'Clements Shore' ,`StreetNumber` = '2214' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS # 73405132 ~ REPRESENTATIVE PHOTOS ADDED! Ready December ~ The Bordeaux! An excellent choice for larger families needing additional space! Walkthrough the long foyer to an impressive 2-story floorplan open to the family room, kitchen with island, and casual dining area with views to the covered outdoor living. Perfect for entertaining guests! Guest bedroom and bath is off the foyer. The owner’s suite is nicely in the back for peace and quiet. Relax in the owner’s bath with soaking tub, separate shower, and large walk-in closet. Upstairs are three additional bedrooms each with walk-in closets. Family fun night can be every night in the large game room upstairs. Design upgrades feature pendant lighting, ceiling fan pre-wiring along with full gutters, and window blinds! No rear neighbors! Structural options include: bedroom 6 with bath, open rails, slide in tub at owner’s bath.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '090435' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527644' WHERE `Matrix_Unique_ID` = '210938401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:40:22.427' ,`MLSNumber` = '26604516' ,`ListAgentFullName` = 'Lekeithia Francis' ,`ListOfficeName` = '1st Class RE Luxury Living,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877954' ,`Longitude` = '-95.300095' ,`PhotoCount` = '14' ,`PostalCode` = '77016' ,`RoomCount` = '1' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Mohawk' ,`StreetNumber` = '5929' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '3434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Daycare and store for sale. Great area for development to build new construction or to continue work and complete daycare. store is on the corner at 11110 Homestead Rd. Owner is willing to sell separately or together. Lot of potential and in great area, new businesses across the street and in area. Zoned for commercial use. Store sq ft is 2,376. Land area for daycare 25,539 and store land area 8,916.' ,`Acres` = '0.5863' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 28A & 29A BLK 1 WOODLAND ACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '25539' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Woodland Acres' ,`TaxAmount` = '2144' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527644' WHERE `Matrix_Unique_ID` = '211018380' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:04:54.087' ,`MLSNumber` = '41453459' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.908579' ,`Longitude` = '-95.753734' ,`PhotoCount` = '30' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '605577.00' ,`Status` = 'Active' ,`StreetName` = 'Cecil Garden' ,`StreetNumber` = '8822' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#41453459 REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, December Completion! The Bordeaux is a beautiful 2-story painted brick home that is an excellent choice for larger households needing additional living space! This floor plan features 4 bedrooms, 3.5 bathrooms, a 3-car tandem garage, private study, with the game and media rooms upstairs. The beautiful kitchen is open to the large family room and dining room area perfect for entertaining your guests and family. The island includes ample space for sitting, chatting, and quick meals before getting the kids to school. The charming owner\'s suite is just right for relaxation and comfort! Structural options added to 8822 Cecil Garden include: fireplace, media room, extended owner’s suite, and study.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31, Block 3 of Avalon at Cypress Section 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7462' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon at Cypress 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527644' WHERE `Matrix_Unique_ID` = '211120868' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:21:53.157' ,`MLSNumber` = '35404237' ,`ListAgentFullName` = 'Faye Ausmus' ,`ListOfficeName` = 'Ausmus Premier Properties, LLC' ,`SellingAgentFullName` = 'Jesse Turner' ,`SellingOfficeName` = 'CB&A, Realtors-Katy' ,`Latitude` = '29.563493' ,`Longitude` = '-95.430640' ,`PhotoCount` = '24' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '409000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Briar Rose' ,`StreetNumber` = '2617' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 4-Sides Brick home on a Cul-de-sac Street. Built by Perry Homes. Enter into a Nice Wide entry with a Formal Dining and Study, then into the family room open to the kitchen and breakfast area. This great open space allows for gatherings of family and friends. Family room features a cast-stone Wood burning fireplace and ceramic tile flooring and high ceilings. Kitchen has 42\" J-Kraft cabinets, GE stainless appliances, granite counters and a Kitchen Island with seating area. Split Plan with a Large Primary Bedroom with high ceilings. Primary bath features a Garden Soaking Tub, double sinks a glass enclosed separate shower, and a Large walk in closet.16-SEER HVAC.' ,`Acres` = '0.1654' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-51B, BLOCK 1, LOT 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7203' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-51b' ,`TaxAmount` = '9542' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527645' WHERE `Matrix_Unique_ID` = '211294609' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:08:06.240' ,`MLSNumber` = '37534501' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.916566' ,`Longitude` = '-95.738929' ,`PhotoCount` = '42' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '669522.00' ,`Status` = 'Active' ,`StreetName` = 'Chelton Beach' ,`StreetNumber` = '21106' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3453' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#37534501 REPRESENTATIVE PHOTOS ADDED Built by Taylor Morrison, October Completion. The Topaz in Bridge Creek is the perfect 2 story home. As you step into the foyer, you get invited into a large family room with an open island kitchen and casual dining area with a view of the backyard. Transition to the owner\'s suite with a large walk-in closet and easy access to the laundry room. Media room, study and guest bedroom finish out the first floor. The second floor opens to below in the family room and foyer. Show off with a humongous game room for the kiddos and two generous-sized secondary bedrooms with two bathrooms. Structural options added include: Bench at owner’s entry, pop-up ceiling at game room, open railing, study, drop in tub at owner’s bath, 12 x 8 3 panel sliding door unit, 8’ interior doors on 1st floor, entry and rear, and fireplace.' ,`Acres` = '0.16' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 BRIDGE CREEK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7169' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridge Creek 60\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527645' WHERE `Matrix_Unique_ID` = '211602773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:02:46.030' ,`MLSNumber` = '48725589' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344697' ,`Longitude` = '-95.588558' ,`PhotoCount` = '6' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '264990.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury' ,`StreetNumber` = '661' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one-story 3 bedroom, 2 bath home is perfect for anyone looking to own. Enjoy conveniences like an updated kitchen with granite countertops, a large island, stainless steel appliances and upgraded cabinets. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 1 Lot 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527645' WHERE `Matrix_Unique_ID` = '211953639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:03:12.893' ,`MLSNumber` = '92664497' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344697' ,`Longitude` = '-95.588558' ,`PhotoCount` = '6' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '268990.00' ,`Status` = 'Active' ,`StreetName` = 'Calderon' ,`StreetNumber` = '14810' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Odyssey is a great place for anyone looking for a 3 bedroom, 2 bath home. The kitchen features brand new stainless steel appliances, granite countertops and a spacious island. There\'s room to spread out with a 2-car garage and a covered patio. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 1 Lot 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527645' WHERE `Matrix_Unique_ID` = '211954773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:04:54.663' ,`MLSNumber` = '91340487' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344697' ,`Longitude` = '-95.588558' ,`PhotoCount` = '8' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '304990.00' ,`Status` = 'Active' ,`StreetName` = 'Calderon' ,`StreetNumber` = '14802' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Get ready to walk into a new home that\'s made with you and your family in mind. The Discovery home plans include brand new stainless steel appliances, granite countertops and an upstairs loft. You can also invite friends and neighbors over for a cookout in your own private backyard. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 1 Lot 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527646' WHERE `Matrix_Unique_ID` = '211955189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:05:22.400' ,`MLSNumber` = '27654101' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344697' ,`Longitude` = '-95.588558' ,`PhotoCount` = '7' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '310990.00' ,`Status` = 'Active' ,`StreetName` = 'Calderon' ,`StreetNumber` = '14814' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two-story plan is ideal for a family looking for lots of space and a place to create new memories. Wake up to brand new stainless steel appliances, granite countertops and open living spaces that look out onto your own private patio. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 1 Lot 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527646' WHERE `Matrix_Unique_ID` = '211955322' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:05:45.130' ,`MLSNumber` = '44426773' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344697' ,`Longitude` = '-95.588558' ,`PhotoCount` = '8' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '327990.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury' ,`StreetNumber` = '669' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy living among new home details including granite countertops, stainless steel appliances and open living spaces. There\'s no shortage of space as homes have a back patio, bonus lofts and walk-in closets. The Apollo comes with roomy floor plans perfect for game nights, entertaining and cookouts with the whole family. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 1 Lot 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527646' WHERE `Matrix_Unique_ID` = '211955408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:04:28.003' ,`MLSNumber` = '39498789' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344697' ,`Longitude` = '-95.588558' ,`PhotoCount` = '8' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '292990.00' ,`Status` = 'Active' ,`StreetName` = 'Calderon' ,`StreetNumber` = '14806' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Create memories when you step inside your new home that includes modern finishes from top to bottom. Cook family meals in your open kitchen complete with stainless steel appliances, granite countertops and a large island. This two-story home also provides plenty of space with extra loft space and a patio that\'s perfect for entertaining guests. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 1 Lot 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527646' WHERE `Matrix_Unique_ID` = '211955647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:17:04.190' ,`MLSNumber` = '19785828' ,`ListAgentFullName` = 'Kiki Baker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747501' ,`Longitude` = '-95.785278' ,`PhotoCount` = '34' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Falcon Knoll' ,`StreetNumber` = '2523' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sept 2022 Yard of the Month! No back neighbors! Completely updated 5 bedroom home, the pride of Falcon Ranch. Master bed-bath suite plus half-bath downstairs, with 4 beds and 2 full baths up plus loft area. Private pool and hot tub with wireless solar LED lighting that brings the backyard to full-color life each evening! Quartz island kitchen with herringbone backsplash, and baths ALL recently remodeled; custom fireplace in living room. Upstairs full laundry room PLUS combo washer/dryer unit in downstairs master closet; all can stay. Water resistant laminate flooring throughout, except high grade carpet on stairs, and tile in baths and laundry. One AC unit just replaced 2022 with all duct work cleaned (other unit is 2018). Brand new water heater. Dryer vents just cleaned. Detached garage, backs to Willow Fork bayou trail. Walk or bike the trails a short distance, 6 mins, to junior or high school quickly and safely with no street traffic. Please note: Live Camera Surveillance.' ,`Acres` = '0.194' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FALCON RANCH SEC 4, BLOCK 5, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8449' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '594' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Falcon Ranch' ,`TaxAmount` = '9630' ,`TaxRate` = '2.9495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527646' WHERE `Matrix_Unique_ID` = '211973447' --> 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','212063704','1668527647','212063704','2022-11-14T22:56:57.507','6554050','Philip Lynn','HomeSmart','','','30.480442','-94.767812','44','77327','0','57333.00','Active','R 2723 Connie','257','Drive','Cleveland','2','0','4','2128','Single-Family','','1.2261','52','','','','','Sellers Disclosure','1','Wood Burning Fireplace','1','Liberty County East','Central Electric','0','BIG THICKET LAKE ESTATES, LOT 101-104, SEC 13, ACRES 1.2261,','Subdivision Lot,Wooded','53409','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Aluminum','107 - Hardin','HARDIN ELEMENTARY SCHOOL','HARDIN HIGH SCHOOL','','Temporarily No Showings','Appraisal District','1','Other Style','Big Thicket Lake Estates','734','1.7656','Public Water,Septic Tank','1994','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:17:35.483' ,`MLSNumber` = '94920428' ,`ListAgentFullName` = 'Kevin Johnson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Latisha Bradshaw' ,`SellingOfficeName` = 'Texas Diamond Realty' ,`Latitude` = '29.967988' ,`Longitude` = '-94.970256' ,`PhotoCount` = '26' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '152000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 48824' ,`StreetNumber` = '308' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very nice manufactured home sitting on over 1/2 an acre. This home has been lovingly cared for. Recent updates include new interior paint, expanded parking including full RV 50 amp hook ups with sewer and water in front of the home, and LOTS of material brought in to raise the elevation of the lot and create good drainage. The home features 3 bedrooms, 2 baths, and an open kitchen/dining/living room area. The finishes are very nice with hard surface flooring throughout and high end appliances in the kitchen. The primary bedroom suite is on one end with the other two bedrooms on the other. Primary suite is large and comfortable. The secondary bedrooms consist of one normal sized and one large room with a bathroom between them. The shed was used for puppies so the seller added an A/C. The property is sounded by large trees and has no immediate neighbor behind.' ,`Acres` = '0.689' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CEDAR CREEK, SEC 3, BLOCK 10, LOT 25, ACRES 0.689,' ,`LotDesciption` = 'Cleared' ,`LotSize` = '30013' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cedar Creek' ,`TaxAmount` = '2149' ,`TaxRate` = '1.9062' ,`WaterSewer` = 'Public Water,Septic Tank,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668527647' WHERE `Matrix_Unique_ID` = '212077131' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:21:14.657' ,`MLSNumber` = '71039556' ,`ListAgentFullName` = 'Roger Alvarez' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692576' ,`Longitude` = '-95.683724' ,`PhotoCount` = '30' ,`PostalCode` = '77083' ,`RoomCount` = '8' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Sorbete' ,`StreetNumber` = '7503' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home in a cul-de-sac. Seller has meticulously maintained this home and there are a lot of upgrades. **Home features 3 bedrooms, 2 bath, you will love the High ceiling in family room and kitchen. Granite countertops, upgraded kitchen cabinets, and added an extra room which can be used as a den, a game room or 2nd family room. The Back yard is a wonderful spot for gatherings and a great size to inspire the Gardner in you. There is a covered patio at back. You must see this home.' ,`Acres` = '0.1844' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION WEST SEC 2, BLOCK 4, LOT 55' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8032' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission West Sec 2' ,`TaxAmount` = '3905' ,`TaxRate` = '2.4297' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527647' WHERE `Matrix_Unique_ID` = '212094001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:06:49.740' ,`MLSNumber` = '74062577' ,`ListAgentFullName` = 'Lupe Quiroga' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Maria Mata' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.804139' ,`Longitude` = '-95.741203' ,`PhotoCount` = '44' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '245000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cocoplum' ,`StreetNumber` = '20611' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1388' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Nice 2 story corner lot with front porch. High ceilings tile flooring living and kitchen areas. Nice greenery shrubs and a lemon tree in back yard plenty of shade, has a covered back porch, and a detached garage apartment partially finished, could be a mother -in- law quarters. two year old roof. Must see to appreciate!\r\nCall your Realtor today!' ,`Acres` = '0.1313' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 7 RAINTREE VLG SEC 1 R/P & EXTN' ,`LotDesciption` = 'Corner' ,`LotSize` = '5720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '436' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree Village Sec 01 R/P &' ,`TaxAmount` = '4201' ,`TaxRate` = '2.5633' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527647' WHERE `Matrix_Unique_ID` = '212104582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:21:48.713' ,`MLSNumber` = '44679650' ,`ListAgentFullName` = 'Victorino Cortez' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = 'Vanessa Gonzalez' ,`SellingOfficeName` = 'Nextgen Real Estate Properties' ,`Latitude` = '29.982512' ,`Longitude` = '-95.194388' ,`PhotoCount` = '21' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '269900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'English Brook' ,`StreetNumber` = '12203' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1791' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1-story home completely remodeled. Kitchen features open floor plan with new stainless steel appliances, granite countertops with subway tile backsplash. New flooring throughout the entire home with fresh paint. The home is equipped with new roof, AC/Furnace, water heater, outdoor lighting and gutters. Has high ceilings throughout, refrigerator stays, zoned to highly acclaimed Humble ISD schools, and close to shopping, dining, and entertainment.' ,`Acres` = '0.1205' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 5 CLAYTONS CORNER SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Claytons Corner Sec 01' ,`TaxAmount` = '5275' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527647' WHERE `Matrix_Unique_ID` = '212134186' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:39:12.273' ,`MLSNumber` = '98554137' ,`ListAgentFullName` = 'Delois Johnson' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602781' ,`Longitude` = '-95.358060' ,`PhotoCount` = '24' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Portman Glen Lane' ,`StreetNumber` = '3907' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 2 story, 3 bedrooms, 2.5 bathrooms ready for move-in! Plenty of open space, up and downstairs good for entertaining guess. Light and bright kitchen with L-shape breaskfast bar, French doors leading out side to a large backyard, privated new fence and covered patio for cookout anytime. Upgrades, New A/C and toliets installed. Spacious living room, new vinyl wood floors and new ceiling fan, large windows for more natural lighting, master bedroom well sized and two secondary bedrooms. Flex room up can be converted into a game room for private movie nights. 4 security lights installed over garage for extra security at night. Great location convenient to Belt 8, 288 Downtown, Med-Center, NRG and Hobby Airport all easily accessible.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 2 Blk 1 Brunswick Lakes Sec 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '520' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brunswick Lakes' ,`TaxAmount` = '4548' ,`TaxRate` = '2.6498' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527648' WHERE `Matrix_Unique_ID` = '212509173' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:20:55.143' ,`MLSNumber` = '87932724' ,`ListAgentFullName` = 'Lisa Morales' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808755' ,`Longitude` = '-95.550325' ,`PhotoCount` = '26' ,`PostalCode` = '77043' ,`RoomCount` = '10' ,`ListPrice` = '389500.00' ,`Status` = 'Active' ,`StreetName` = 'Moorberry' ,`StreetNumber` = '10406' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'There is room for everyone in this spacious 1,744 SqFt. 4 bedroom/2 bath home nestled in the desirable community of Spring Branch. SBISD schools are easily accessable right behind the backyard fence. Among the many features included in this charming home is an updated, stylish kitchen with gas cooking, double corner sinks, butcher block countertops, and new wrap around cabinetry. A chef\'s dream come true. The primary bedroom boasts a wood-burning fireplace and the en suite bath has two separate vanities, a large soaking/jetted tub, and shower. The list of upgrades continues with a new AC unit and gas furnace (June 2020) 100 feet of sewer line replaced (July 2019) roof replaced (June 2018) and new water softener (February 2021). Fresh paint in the extended living room, kitchen, dining and primary bed and bath make this home light and bright! Conveniently located with quick access to I-10, Beltway 8, Memorial City Mall, dining, entertainment and City Centre. Never Flooded!!' ,`Acres` = '0.2185' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 50 BLK 3 SPRINGWOOD OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Springwood Oaks' ,`TaxAmount` = '7096' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527648' WHERE `Matrix_Unique_ID` = '212706725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:06:22.490' ,`MLSNumber` = '32454116' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344697' ,`Longitude` = '-95.588558' ,`PhotoCount` = '7' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '340990.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury' ,`StreetNumber` = '681' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious 2-story home is the perfect new addition in your life. Enjoy an open concept kitchen and family room throughout the home and spread out in the second-floor loft. The kitchen features upgrades such as granite countertops, stainless steel appliances and a large island. Entertain friends on your very own private patio.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 1 Lot 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527648' WHERE `Matrix_Unique_ID` = '212973070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:08:59.123' ,`MLSNumber` = '11644792' ,`ListAgentFullName` = 'Ajitha Tose' ,`ListOfficeName` = 'MIH REALTY, LLC' ,`SellingAgentFullName` = 'Kendall Mire' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.690255' ,`Longitude` = '-95.717177' ,`PhotoCount` = '36' ,`PostalCode` = '77407' ,`RoomCount` = '5' ,`ListPrice` = '299000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Thorncroft Manor' ,`StreetNumber` = '7934' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1901' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A great opportunity to own a well maintained beautiful single story in the community of GRAND MISSION, very close to the ELEMENTARY SCHOOL and THE HWAY 99 .Updated kitchen and bathrooms, custom light fixtures, no carpet in the house, stainless steel appliances and walk in pantry are some of the highlights of this lovely home . REFRIGERATOR & the outdoor barbecue grill are included. The house has never flooded . Make it yours :make it happen!' ,`Acres` = '0.1344' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 12, BLOCK 1, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5853' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission Sec 12' ,`TaxAmount` = '5183' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527648' WHERE `Matrix_Unique_ID` = '212993430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:39:17.670' ,`MLSNumber` = '61569753' ,`ListAgentFullName` = 'Chelsea Gunn' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = 'Yessica Martinez' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.533238' ,`Longitude` = '-95.224563' ,`PhotoCount` = '20' ,`PostalCode` = '77581' ,`RoomCount` = '13' ,`ListPrice` = '334900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Gulfton' ,`StreetNumber` = '1113' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story 4 bedroom home located in the highly sought-after Sunset Meadows community in East Pearland! This light & bright home boasts updates that include fresh texturing and paint, stylishly updated lighting, throughout the first-floor living space that includes a combined formal living and dining room with French doors, an inviting family room with a charming brick fireplace and a soaring ceiling, and a wide entrance to the sunlit breakfast room and kitchen with stainless appliances including double ovens and a gas cooktop. Also on the first floor, find the utility room with ample storage space & updated designer tile flooring, as well as the generous master suite with a soaking tub & a seamless glass shower. Upstairs, you’ll find\r\nthree bedrooms, one of which is large enough to easily convert to a game room or flex space as desired. Outside, enjoy the spacious yard with mature trees or take advantage of the community pool & playgrounds. Home has NEVER flooded!' ,`Acres` = '0.1446' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNSET MEADOWS-NASAWOOD (A0111 PERRY & AUSTIN) (PEARLAND) BL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6299' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '363' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'RUSTIC OAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Meadows-Nasawood' ,`TaxAmount` = '6597' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527648' WHERE `Matrix_Unique_ID` = '213054675' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:29:40.457' ,`MLSNumber` = '85156833' ,`ListAgentFullName` = 'Kevin Johnson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Mundi Wortham' ,`SellingOfficeName` = 'Worth Clark Realty' ,`Latitude` = '30.096855' ,`Longitude` = '-95.174776' ,`PhotoCount` = '25' ,`PostalCode` = '77365' ,`RoomCount` = '3' ,`ListPrice` = '120000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lakeview' ,`StreetNumber` = '9739' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bring your horse and your vision. Light restrictions on this 1 acre property. The home is close to anything and everything you could need but feels like the true country. Home has had water damage, but is ready to be put back together and new memories made. This home stood solid for over 40 years with no flooding until Harvey. The home has a great floor plan and good bones.' ,`Acres` = '1.0183' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 62 63 64 & 65 BLK 2 WALDEN WOODS U/R' ,`LotDesciption` = 'Other' ,`LotSize` = '44357' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Walden Woods U/R' ,`TaxAmount` = '2427' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527649' WHERE `Matrix_Unique_ID` = '213065931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:16:37.860' ,`MLSNumber` = '72574641' ,`ListAgentFullName` = 'Martine Nerrant' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = 'Devinder Dhariwal' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.743575' ,`Longitude` = '-95.582724' ,`PhotoCount` = '39' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Manor Green' ,`StreetNumber` = '2123' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Energy corridor 4BR house located in quiet cul de sac street. House has just been fully painted inside and outside. Updated home with all bedrooms upstairs, NO CARPET, tiles and wood flooring throughout. Enjoy gourmet kitchen with granite counters, stainless steel appliances. This home offers double pane windows and lots of natural light. Refrigerator, washer and dryer are included. There is a private study/ office downstairs. Enjoy the outdoor all year long with covered patio, screened in patio deck, private sparkling pool & spa. Spacious backyard allows for extra side yard, extended driveway with automatic gate. Close to Awty, British bus stop. Proximity to the Village School. Incredible location with convenient access to I-10, Beltway 8, and Westpark Tollway for those that commute. You are also just minutes from all of the great restaurants, shopping, grocery like Whole foods, Traders Joe. Enjoy the proximity of Terry Hershey Park trails.' ,`Acres` = '0.1832' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 4 APRIL VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASKEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'April Village Sec 01' ,`TaxAmount` = '6338' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527649' WHERE `Matrix_Unique_ID` = '213316398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:33:01.070' ,`MLSNumber` = '29472102' ,`ListAgentFullName` = 'Donyale Jones' ,`ListOfficeName` = 'TDRealty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.491923' ,`Longitude` = '-95.123516' ,`PhotoCount` = '17' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Newport' ,`StreetNumber` = '1305' ,`StreetSuffix` = 'Boulevard' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2157' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see This one-story property features 3 bedrooms and 2 full bathrooms in the desirable Newport subdivision. It is well maintained, cozy, and ready to move into. It comes complete with fireplace, ceiling fans, granite countertops, and an extra flex room near the nice sized backyard. It has pex plumbing, new HVAC system (2021). This home is fully upgraded ready for it new Owner.' ,`Acres` = '0.2238' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 3 PAGE 3 LOT 21 BLK 18 NEWPORT SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '49' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROSS ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport 6' ,`TaxAmount` = '5091' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527649' WHERE `Matrix_Unique_ID` = '213338165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:32:58.073' ,`MLSNumber` = '88244474' ,`ListAgentFullName` = 'Carlos Guerra' ,`ListOfficeName` = 'Exit Realty 360' ,`SellingAgentFullName` = 'Carlos Guerra' ,`SellingOfficeName` = 'Exit Realty 360' ,`Latitude` = '29.641026' ,`Longitude` = '-95.548000' ,`PhotoCount` = '22' ,`PostalCode` = '77031' ,`RoomCount` = '7' ,`ListPrice` = '257000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'AIRPORT' ,`StreetNumber` = '9579' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT LOCATION ONE OF THE HEART PART OF THE SOUTHWEST AREA BEAUTIFULL INSIDE LIGHT HOUSE EASY ACCESS,20 MINUTES TO DOWNTOWN TO FREEWAY 12 MINUTES TO GALLERIA AND EASY ACCESS TO SUGARLAND AND AREAS AROUND A LOT SPACE TO ENTERTEIMENT FAMILY AND FRIENDS HAS NICE BACK YRAD READY TO BUILD A POOL ,LARGE DRIVE WAY TO HOLD PEOPLE OVER AND HIGH CATEDRAL CEILING AT LIVING ROOM AND MASTER BEDROOM ,NEW PORCELAIN FLOORS,LAMINATE FLOORS,QUARTZ TOP COUNTER KITCHEN ,NEW A/C DUCTS BEEN REPLACED COME TO SEE!!!!' ,`Acres` = '0.2182' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 28 GLENSHIRE SEC 9' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '9504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '516' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Glenshire' ,`TaxAmount` = '3775' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527649' WHERE `Matrix_Unique_ID` = '213354234' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:11:39.207' ,`MLSNumber` = '60280779' ,`ListAgentFullName` = 'Sheryle Campbell' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708392' ,`Longitude` = '-95.406608' ,`PhotoCount` = '49' ,`PostalCode` = '77030' ,`RoomCount` = '10' ,`ListPrice` = '1997000.00' ,`Status` = 'Active' ,`StreetName` = 'McClendon' ,`StreetNumber` = '2031' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MODERN LUXURY at it\'s finest can be found in this Custom New Construction in the established Southgate community. Walking distance to the Medical Center and Rice University, this fabulous entertaining home offers over 5100 sf of living space with a bright OPEN FLOOR PLAN accented by 11 foot ceilings and MODERN FINISHES constructed with an impressive attention to detail. Quality construction starts with the PIER & BEAM foundation elevated 4 feet above ground & a gorgeous stone exterior with black framed double pane windows. The stunning exterior offers just a glimpse of the luxurious detailing found inside, including the wide plank wood floors that flow continuously throughout the downstairs & upstairs. A gourmet island kitchen boasts QUARTZ COUNTERS and top-of-the-line Dacor appliances, including a built-in refrigerator. This two-story home is elevator capable with 4 bedrooms and 5 ensuite bathrooms upstairs. An expansive covered patio with outdoor kitchen and room for pool.' ,`Acres` = '0.1446' ,`Area` = '17' ,`BuilderName` = 'NRR COnstruction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 3 BLK 6 SOUTHGATE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southgate' ,`TaxAmount` = '12628' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527650' WHERE `Matrix_Unique_ID` = '213378663' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:10:53.750' ,`MLSNumber` = '44420387' ,`ListAgentFullName` = 'Marvin Loyd' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.484703' ,`Longitude` = '-95.168481' ,`PhotoCount` = '34' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '444900.00' ,`Status` = 'Active' ,`StreetName` = 'Stockport' ,`StreetNumber` = '311' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2437' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A soaring entry ceiling greets you as you enter this fantastic 4 bedroom 3 bath home.\r\nThis bright open floor plan is loaded with upgrades including high ceilings and 8\' doors throughout! The family room has a cozy gas log fire place. The large island kitchen is open to the dining and family areas and features fabulous cabinets with under cabinet lighting, walk-in pantry and lots of counter space for entertaining. Granite counter tops throughout! An oversized primary bedroom offers space for a sitting area. The en suite bathroom has separate sinks and a corner soaking tub with separate oversized shower. and walk-in closet. The three additional bedrooms are of a good size and can easily double as office or work out space. The back patio features a ceiling fan and built-in gas connection, for grilling and chillin! Home has new hurricane shutters. Inground sprinklers too!\r\nA very attractive brick and stone home. Lots of curb appeal.\r\nThis home will go quickly. Schedule your Tour TODAY!' ,`Acres` = '0.1745' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SUB SEC 4 (2016) ABST 9, BLOCK 3, LOT 14, ACRES 0.1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7603' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westwood Sub' ,`TaxAmount` = '10805' ,`TaxRate` = '3.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527650' WHERE `Matrix_Unique_ID` = '213437487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:42:10.560' ,`MLSNumber` = '91215581' ,`ListAgentFullName` = 'Shantel Landry' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.856024' ,`Longitude` = '-95.206938' ,`PhotoCount` = '13' ,`PostalCode` = '75862' ,`RoomCount` = '10' ,`ListPrice` = '75000.00' ,`Status` = 'Active' ,`StreetName` = 'Channel' ,`StreetNumber` = '130' ,`StreetSuffix` = 'Street' ,`City` = 'Trinity' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Trinity, Country Living! If you like boating, fishing, and hunting you would absolutely love living here! Trinity is a small community with great enjoyment. Beautiful, wooded land conveniently located close to Westwood Shores-resort community, Lake Livingston and Onalaska. Metal roof. Central air and heat. Great for investors or anyone seeking to make this home their own. An affordable home site makes a perfect starter home, a nice place for comfortable and safe retirement, or could also be used as an investment property. Rediscover the Trinity River, all natural features. This is the perfect opportunity!' ,`Acres` = '0.355' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'POLLY RYAN, .355 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '15463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Camp Branch Polly Ryan' ,`TaxAmount` = '' ,`TaxRate` = '1.6' ,`WaterSewer` = 'Other Water/Sewer,Public Sewer' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527650' WHERE `Matrix_Unique_ID` = '213447166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:58:07.767' ,`MLSNumber` = '86744961' ,`ListAgentFullName` = 'Alan Herrera' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809833' ,`Longitude` = '-95.168877' ,`PhotoCount` = '21' ,`PostalCode` = '77049' ,`RoomCount` = '14' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Banter Trails' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '****NO Showings until November 14th.**** Great opportunity to own a home with too multiple updates. Freshly painted inside out, new carpet, appliances updated kitchen. One of a kind for sure.' ,`Acres` = '0.187' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 9 PLANTATION AT WOODFOREST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8145' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '485' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'DR SHIRLEY J WILLIAMSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation At Woodforest' ,`TaxAmount` = '8122' ,`TaxRate` = '2.9394' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527650' WHERE `Matrix_Unique_ID` = '213518154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:50:00.343' ,`MLSNumber` = '9596878' ,`ListAgentFullName` = 'Maria Hernandez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841787' ,`Longitude` = '-95.463468' ,`PhotoCount` = '15' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '284000.00' ,`Status` = 'Active' ,`StreetName` = 'Broom' ,`StreetNumber` = '4916' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIKE NEW IN \"ROSSLYN HEIGHTS\" Great opportunity to own this cozy and totally renovated 3 bedrooms and 2 full bathrooms. Everything is new here, except part of the frame and the water heater. Upgraded with high ceiling and master bedroom addition. LED Recessed lighting. Granite kitchen countertops, master vanities and shower seat. Quartz second bath vanity. Wood look water resistance laminate flooring throughout. New electrical, plumbing, HVAC Systems. Two sink in master and walk in closet. Stainless Steel appliances. Soft close cabinets including a lazy Susan in kitchen for your storage convenience. Within minutes to the Galleria, Houston Downtown, TC Jester Park and Kroger. Quiet neighborhood, low taxes, no HOA, no flood zone. Schedule your showing today!' ,`Acres` = '0.1' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 23 ROSSLYN HEIGHTS SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rosslyn Heights Sec 01' ,`TaxAmount` = '2742' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527650' WHERE `Matrix_Unique_ID` = '213606738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:32:06.033' ,`MLSNumber` = '26995687' ,`ListAgentFullName` = 'Martha Laird' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702571' ,`Longitude` = '-95.910988' ,`PhotoCount` = '27' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Arabian Moon Trail' ,`StreetNumber` = '7402' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome! This beautiful home, that offers 5 bedrooms and 4 FULL bathrooms. Perfectly situated in the highly desired community of Polo Ranch, on a cul-de-sac with a green belt in the back yard and no behind neighbors. Modern look wood ceramic tile floors and neutral carpet. The open concept kitchen area opens to a huge living area with a kitchen breakfast area as well. This home comes with two Primary bedrooms, each with full bathrooms. Two spacious bedrooms downstairs with their own bathroom, perfect for the extended modern family. One primary bed with full bath, two guest bedrooms with another full bath and a large entertainment area! Covered window blinds throughout. The home has a huge back yard and has a covered patio. Sprinkler system and tank-less water heater . Highly desired LAMAR CISD with Morgan Elementary, Roberts Junior high and Fulshear High School within a short distance. Community amenities include a gorgeous pool, splash pad, playgrounds, walking trails and much more.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Polo Ranch Sec 11, BLOCK 2, Lot 5' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Split Level,Traditional' ,`Subdivision` = 'POLO RANCH' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527651' WHERE `Matrix_Unique_ID` = '213641225' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:40:04.453' ,`MLSNumber` = '91097570' ,`ListAgentFullName` = 'Karen Shotwell' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152803' ,`Longitude` = '-95.165489' ,`PhotoCount` = '20' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Block Ada' ,`StreetNumber` = '20100' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated seller! NEW MOVE-IN READY. NO HOA, LOW TAXES, direct access to hwy 99, 3 bedrooms, 2 bathrooms. Open layout, recessed lighting, and vinly flooring throughout the entire house No carpet anywhere. Gourmet kitchen with adjoining breakfast nook, granite countertops, white cabinetry with plenty of storage overlooking the family room. Relax the evening away in the oversized backyard perfect for gathering. Call to schedule your private showing. *grass was edited on photos*' ,`Acres` = '0.3099' ,`Area` = '40' ,`BuilderName` = 'Independent' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S741003 - NEW CANEY HEIGHTS 03, BLOCK B, LOT 19' ,`LotDesciption` = 'Cleared' ,`LotSize` = '13500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric 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,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'New Caney Heights 03' ,`TaxAmount` = '95' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668527651' WHERE `Matrix_Unique_ID` = '213695912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:31:52.337' ,`MLSNumber` = '46823957' ,`ListAgentFullName` = 'Susan Cline' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Joshua DeShong' ,`SellingOfficeName` = 'Myers The Home Buyers' ,`Latitude` = '29.768494' ,`Longitude` = '-95.767605' ,`PhotoCount` = '22' ,`PostalCode` = '77450' ,`RoomCount` = '7' ,`ListPrice` = '290000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cascade Creek' ,`StreetNumber` = '1027' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ROOF replaced 2022. 4A/C replaced 2020, for a 2-stage, 4 ton unit. You\'re going to love the fully renovated kitchen with soft close drawers, Whirlpool gas cooktop and oven, Bosch microwave, granite counter tops...a must-see! Whole house water softener, screened porch, all located walking distance from Cimarron Elementary. Call for your private appointment today!' ,`Acres` = '0.1737' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 40 CIMARRON SEC 9 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7565' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cimarron Sec 09 R/P' ,`TaxAmount` = '4384' ,`TaxRate` = '2.3833' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527651' WHERE `Matrix_Unique_ID` = '213815622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:24:45.097' ,`MLSNumber` = '85063562' ,`ListAgentFullName` = 'Kan Chan' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = 'Karen Espinoza' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '29.866430' ,`Longitude` = '-95.198925' ,`PhotoCount` = '44' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mariposa Stream' ,`StreetNumber` = '10126' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice two story 4-bedroom 3 bathroom located in the 610 and I-10 East area. The home has a separate dining room and a large living room. The master bedroom has vaulted ceilings and the master bathroom has a garden sub with a separate walk-in shower. The home has a large back yard that is perfect for entertaining.' ,`Acres` = '0.1331' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 HIDDEN MEADOW SEC 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5797' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'CARROLL ELEMENTARY SCHOOL (SHELDON)' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'HIDDEN MWADOW' ,`TaxAmount` = '5903' ,`TaxRate` = '3.0293' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527651' WHERE `Matrix_Unique_ID` = '213820923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:11:39.957' ,`MLSNumber` = '15002526' ,`ListAgentFullName` = 'Gary Swafford' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834236' ,`Longitude` = '-95.778802' ,`PhotoCount` = '35' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Verona View' ,`StreetNumber` = '23214' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom 2 1/2 bath one story home in Ventana Lakes! This home includes private study, formal dining, large open Granite island kitchen with breakfast bar, butlers pantry, large living area, high ceilings, ceiling fans and more. Ceramic tile flooring in entry, kitchen and living area. Gas log fireplace, covered patio deck and large backyard. Landscape lighting. Cul de sac street! Community Amenities include clubhouse, swimming pool, outdoor covered picnic areas, play ground and trails. Zoned to Highly Acclaimed Katy ISD Schools!' ,`Acres` = '0.1913' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 VENTANA LAKES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8335' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527652' WHERE `Matrix_Unique_ID` = '213832204' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:36:56.170' ,`MLSNumber` = '50934119' ,`ListAgentFullName` = 'Robyn Scharlach' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.343744' ,`Longitude` = '-95.436115' ,`PhotoCount` = '32' ,`PostalCode` = '77303' ,`RoomCount` = '3' ,`ListPrice` = '274000.00' ,`Status` = 'Active' ,`StreetName` = 'Bedford' ,`StreetNumber` = '216' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW!!! Rare new construction in Robinwood with all the bells and whistles. Conveniently located in the heart of Conroe with quick access to I-45, medical care, restaurants, and shopping galore! Ready for immediate move in. Home expertly constructed with radiant barrier roof decking, termite and rot resistant sill plates, foam insulation, 2x4 studs on 16\" centers and 2x6 rafters/joists, high efficiency HVAC, insulated windows, Kohler plumbing fixtures and more. Also features granite countertops and stainless Frigidaire appliances. Builder Warranty. Make this new home your own today!' ,`Acres` = '0.1515' ,`Area` = '19' ,`BuilderName` = 'Tilson' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ROBINWOOD 01, BLOCK 8, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Robinwood' ,`TaxAmount` = '649' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668527652' WHERE `Matrix_Unique_ID` = '213840210' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:05:27.360' ,`MLSNumber` = '4369895' ,`ListAgentFullName` = 'Jean Jabbour' ,`ListOfficeName` = 'Jabbour Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526321' ,`Longitude` = '-95.731648' ,`PhotoCount` = '36' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Fuchsia' ,`StreetNumber` = '1006' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1915' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONBROOK PLANTATION SOUTH SEC 6, BLOCK 5, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8341' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonbrook Plantation South Sec 6' ,`TaxAmount` = '7710' ,`TaxRate` = '2.6948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527652' WHERE `Matrix_Unique_ID` = '213869798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:37:00.660' ,`MLSNumber` = '23968142' ,`ListAgentFullName` = 'Sabrina McKnight' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.442859' ,`Longitude` = '-95.447704' ,`PhotoCount` = '29' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Luminous Water' ,`StreetNumber` = '1843' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like-New 1-Story home ready for you to make your own featuring manicured landscaping and a view of the water from your location on a cul-de-sac. The functional floor plan includes a living room for the perfect home office and a dining room for family holiday dinners. Additionally, the secondary bathroom is a Jack-and-Jill with two separate sinks. The kitchen is open to the family room making cooking dinner a household affair. You\'ll also enjoy the view of the backyard from the kitchen, family room, and from the primary bedroom. The lovely backyard is ready for a play set, new landscaping, a pool, a patio - your imagination is the limit.' ,`Acres` = '0.1663' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 11(A0289H&B) BLK 2 LOT' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '7244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '10097' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527652' WHERE `Matrix_Unique_ID` = '213876796' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:01:56.127' ,`MLSNumber` = '47385139' ,`ListAgentFullName` = 'Holly Rodenberg' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.439203' ,`Longitude` = '-95.253100' ,`PhotoCount` = '40' ,`PostalCode` = '77511' ,`RoomCount` = '8' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Jennifer' ,`StreetNumber` = '966' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful 3 bed 2 bath home in Alvin located in the Forest Heights subdivision. Easy access to Highway 6 and 35. This home has a large primary bedroom with a nice bath and walk in closet. The open concept kitchen is open to the family room which is wonderful for entertaining. Kitchen has all stainless steel appliances and granite countertops. Hours of fun to be had in the backyard with a swing and playset. Come see this home! It won\'t be on the market for long!' ,`Acres` = '0.1263' ,`Area` = '5' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FOREST HEIGHTS SEC 2 (A0420 HOOPER & WADE) BLK 6 LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Heights' ,`TaxAmount` = '8094' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527652' WHERE `Matrix_Unique_ID` = '213911657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:13:07.843' ,`MLSNumber` = '18551964' ,`ListAgentFullName` = 'Tammy Hilgar' ,`ListOfficeName` = 'Origin Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.925685' ,`Longitude` = '-95.578923' ,`PhotoCount` = '30' ,`PostalCode` = '77064' ,`RoomCount` = '9' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Meadow' ,`StreetNumber` = '10630' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 10630 Autumn Meadow Lane. This floorplan features 4 bedrooms and 2 bathrooms, primary bedroom down with adjoining bathroom, 3 bedrooms and a bathroom upstairs, a bright and open living room, dining room with 2 story ceilings, kitchen with breakfast bar, and laundry room leading out to 2-car attached garage. There is an abundance of windows in this home that allow tons of natural light. French doors in the kitchen lead out to the large, fully fenced backyard with a covered patio, large shed, and no back neighbors. Great neighborhood close to shopping, dining, and freeways in award winning Cy-Fair ISD! Per seller, new A/C and exterior paint 2021. Home needs some TLC, but is very spacious with amazing potential! Seller will not make any repairs. No survey, buyer will need to purchase new one.' ,`Acres` = '0.1056' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 WHITE OAK BEND SEC 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMMOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'White Oak Bend' ,`TaxAmount` = '5456' ,`TaxRate` = '2.84' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527653' WHERE `Matrix_Unique_ID` = '213930780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:14:25.543' ,`MLSNumber` = '43744229' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691087' ,`Longitude` = '-95.705100' ,`PhotoCount` = '29' ,`PostalCode` = '77407' ,`RoomCount` = '9' ,`ListPrice` = '549967.00' ,`Status` = 'Active' ,`StreetName` = 'Albury' ,`StreetNumber` = '7827' ,`StreetSuffix` = 'Manor' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#43744229 Built by Taylor Morrison, Ready Now - The attractive Garnet at Grand Vista is a sprawling home with a welcoming entry hall that draws you into the heart of the home. The large, open gathering room connects the kitchen with a breakfast island and step-in pantry with storage space galore. The main level game room great for a playroom right off the kitchen! The luxurious owner\'s suite boasts a plush spa like bathroom with tub and walk-in shower and huge closet! This split plan includes a guest bedroom with hall bath at the entry. Two more bedrooms tucked away share a large bath and linen closet. The garage entry is near the spacious laundry room with room for extra storage. Structural options include: Corner fireplace, drop-in corner tub in owner\'s bath and gourmet kitchen.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND VISTA SEC 23, BLOCK 3, LOT 1' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '8596' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Vista' ,`TaxAmount` = '' ,`TaxRate` = '2.52' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527653' WHERE `Matrix_Unique_ID` = '213938463' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:18:51.783' ,`MLSNumber` = '83598829' ,`ListAgentFullName` = 'Tracie Golden' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = 'Bryan Lillis' ,`SellingOfficeName` = 'RE/MAX Grand' ,`Latitude` = '29.801555' ,`Longitude` = '-95.759388' ,`PhotoCount` = '34' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wetherburn' ,`StreetNumber` = '22334' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2012' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 22334 Weatherburn Lane in the highly sought after Williamsburg Settlement. Looking for a one story with a pool...this is IT! This beautiful 4/2 home boast an updated bathroom in the primary bedroom with private access to the backyard patio and salt water pool with a play pad. New carpet in the secondary bedrooms including an oversized bedroom that is perfect for a craft, flex or bonus room. Custom features include crown molding, wood paneling, wet bar and a vaulted ceiling in the family room. Easy flow between dining room, kitchen and breakfast room. Recent updates include new energy efficient windows, roof and HVAC. Williamsburg Settlement is an established neighborhood with mature trees, detached garages and amenities that include neighborhood pool, tennis and pickle ball courts, park, playground and a nearby walking trail. Easy access to I-10 and the Grand Parkway in the award winning Katy ISD.' ,`Acres` = '0.2238' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 11 WILLIAMSBURG SETTLEMENT SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WINBORN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williamsburg Settlement Sec 02' ,`TaxAmount` = '5844' ,`TaxRate` = '2.4833' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527653' WHERE `Matrix_Unique_ID` = '213970329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:08:07.363' ,`MLSNumber` = '98531994' ,`ListAgentFullName` = 'Lori Craft' ,`ListOfficeName` = 'The Craft Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.914721' ,`Longitude` = '-95.691060' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Buttonbrush' ,`StreetNumber` = '9402' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'More Photos Coming! GORGEOUS 2 story home in one of the most coveted gated sections of Towne Lake- quick walk to shopping, the boardwalk & the lake. Lake & green space access through private gate. Too many upgrades to list! You will love the sliding doors that allow for true indoor/outdoor entertaining & is ideal for those wonderful fall evenings with friends- wired for outdoor speakers & TV - perfect for game watching parties! The home itself is stunning with luxury appointments, beautiful flooring, crown molding & a neutral gray & white color palate. You will love the chef\'s kitchen open to the kitchen & dining - striking with its high end finishes & still warm enough for everyday meals. All bedrooms up offers true separation between entertaining & sleeping areas. The primary bedroom is an elegant retreat with a magnificent ensuite. Bonus! The extra wide driveway will accommodate those oversized vehicles and your gold cart - a rare feature in this section of Towne Lake. Welcome Home!' ,`Acres` = '0.0935' ,`Area` = '25' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 TOWNE LAKE SEC 44' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '4075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '11995' ,`TaxRate` = '3.091' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527653' WHERE `Matrix_Unique_ID` = '213996250' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:03:04.530' ,`MLSNumber` = '9272450' ,`ListAgentFullName` = 'Linda Salomon' ,`ListOfficeName` = 'R. Alexa Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '18' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'ROAD 5500' ,`StreetNumber` = '479' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 3 BEDROOM, 2 BATHROOM MANUFACTURE HOME ALMOST AS NEW, LOCATED IN Cleveland ISD.\r\nTHE AREA IS GROWING FAST AND IS MINUTES AWAY FROM SH-99. THE BREAKFAST BAR PROVIDES ROOM FOR ADDITIONAL SEATING AND JUST BEHIND IS SPACE FOR A DINNING TABLE, NEW BUILT DECK FRONT AND BACK.\r\nYOU\'LL LOVE THE PEACE AND QUIET IN THIS COUNTRY LOCATION, LARGE LOT. THIS HOME IS MOVE IN READY!' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 6, BLOCK 34, LOT 2081, ACRES 0.24' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'SANTA FE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668527654' WHERE `Matrix_Unique_ID` = '214071078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:33:37.757' ,`MLSNumber` = '97520491' ,`ListAgentFullName` = 'Joan Bremner' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Gordana Vickers' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.751727' ,`Longitude` = '-95.407074' ,`PhotoCount` = '18' ,`PostalCode` = '77019' ,`RoomCount` = '7' ,`ListPrice` = '838000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hazard' ,`StreetNumber` = '1513' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1765' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just a minute walk from River Oaks Shopping Center is this charming cottage with a cool, California vibe! Smell the rosemary plants as you enter the precious arched front door to this happy, sun-filled home. The backyard has a cocktail pool and beautiful landscaping. Perfect for entertaining! The updated kitchen has a breakfast room with a vaulted ceiling, updated quartz and stainless countertops, tile backsplash, a 2021 LG refrigerator*, a 2022 Whirlpool microwave*, a GE range, GE Profile wine refrigerator and dishwasher. The spacious primary suite also has a vaulted ceiling, an en suite bathroom with a large shower, jetted tub and two walk-in closets. Standouts also include a 2021 roof*, washer and dryer included, Nest thermostats, built-ins, hardwood floors. Furnace and a/c condenser replaced in the last year.* Such a beautiful street close to so many River Oaks restaurants and stores within walking distance! *As per seller.' ,`Acres` = '0.1148' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 70 HYDE PARK MAIN SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hyde Park Main Sec 06' ,`TaxAmount` = '15264' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527654' WHERE `Matrix_Unique_ID` = '214183225' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:00:23.997' ,`MLSNumber` = '25957365' ,`ListAgentFullName` = 'Ryan Hajdik' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726728' ,`Longitude` = '-95.928877' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '449999.00' ,`Status` = 'Active' ,`StreetName` = 'Hamilton Crest' ,`StreetNumber` = '32314' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STOP THE BUS! See this home TODAY! READY for immediate move in! Awesome neighborhood with a home that offers plenty of room for your family. 2 story living room with soaring ceilings and fireplace. Open floor plan with a gorgeous kitchen that features granite counter tops and a huge island with upgraded back splash. Fridge, washer and dryer stay. Relax in the back yard with a huge outdoor covered patio with outdoor kitchen that is a dream come true for the family BBQ. Home features energy saving features like double paned windows and radiant barrier. Large upstairs game room, 2 full bathrooms upstairs including a jack-and-jill bathroom, walk in closets, oversized 2 car garage. Home also features a sprinkler system. Zoned to great schools, come see this beauty today! NO BACK NEIGHBORS. Neighborhood also features a pool and playground.' ,`Acres` = '0.1641' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 1, BLOCK 1, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke Sec 1' ,`TaxAmount` = '11491' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527654' WHERE `Matrix_Unique_ID` = '214197187' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:40:48.943' ,`MLSNumber` = '83269197' ,`ListAgentFullName` = 'Ernesto Perez' ,`ListOfficeName` = 'My Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699257' ,`Longitude` = '-95.208755' ,`PhotoCount` = '27' ,`PostalCode` = '77506' ,`RoomCount` = '8' ,`ListPrice` = '278000.00' ,`Status` = 'Active' ,`StreetName` = 'Live Oak Sreet' ,`StreetNumber` = '310' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely beautiful inside and out!! Come take a look at this new 2022 home in an established neighborhood. Minutes away from shopping, schools, businesses and much more. This tastefully built home boasts in detail and craftsmanship. Spacious rooms, open living concept, modern kitchen, modern flooring and bathrooms. It\'s a site to see!! Don\'t miss out on this one!! call me for more information.' ,`Acres` = '' ,`Area` = '6' ,`BuilderName` = 'New Home Construct' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 245 INLAND HARBOR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MORALES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PASADENA HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Inland Harbor' ,`TaxAmount` = '1135' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668527654' WHERE `Matrix_Unique_ID` = '214216362' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:46:29.077' ,`MLSNumber` = '88352499' ,`ListAgentFullName` = 'Vanessa Claudio' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741061' ,`Longitude` = '-95.562942' ,`PhotoCount` = '26' ,`PostalCode` = '77042' ,`RoomCount` = '3' ,`ListPrice` = '599999.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Willow' ,`StreetNumber` = '2307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing property located in the highly sought after Walnut Bend. This spacious home features a beautifully restored and renovated interior with impressive refinements that combine luxury and casual living. Gorgeous kitchen is appointed with stainless steel appliances. The kitchen offers quartz countertops and plenty of cabinet and counter space. Home offers 3-4 bedrooms, office space, formal dinning, breakfast room, living room and almost half an acre. Bonus room can be 4th bedroom or an extra large space to use at your desire. NEW roof, NEW a/c, NEW underground plumbing, NEW energy efficient windows, NEW quartz countertops, NEW luxury laminate flooring, NEW carpet, NEW interior and exterior paint. The list goes on!' ,`Acres` = '0.432' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 & TR 3 BLK 5 WALNUT BEND SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '958' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Walnut Bend Sec 02' ,`TaxAmount` = '8099' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527655' WHERE `Matrix_Unique_ID` = '214269862' --> 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','214291907','1668527655','214291907','2022-11-14T22:56:28.147','87598753','Dwight Johnson','Keller Williams Hou Preferred','','','29.470941','-95.475857','44','77459','13','1100000.00','Active','Star Lake','246','Drive','Missouri City','3','1','4','3712','Single-Family','Country Estate Living in Houston’s Premier Acreage community. Seated on just under four wooded acres. The home is perfect for a young family with small children or retirees who love watching the grands run around. The property is a must see and is priced at a fraction of what you could buy land and built for. Too many features to name but here’s a few. Plantation shutters, five-inch hand scraped wood flooring, granite tops, stainless appliances, custom built bunk beds, frameless glass shower with four heads, storm safe room with cinder block walls/ceiling. Detached flex space can be an office, nanny quarters or anything else you choose. The insulated metal barn for RV storage also comes with a Ben Pak 10k LB lift to store more cars in case your four-car oversized garage isn\'t enough. 800 Sq Ft of covered area off barn for outdoor entertainment. Lastly, the home has a whole house generator. Seller will consider selling including some non-realty items with a strong offer.','3.97','38','Kurk Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Levee District,Sellers Disclosure','1','Gaslog Fireplace','1','Sienna Area','Propane','1','SIENNA POINT SEC 1, BLOCK 2, LOT 3 (NOT IN SIENNA PLANTATION','Other,Subdivision Lot,Wooded','170886','Appraisal District','','1090','0','','4','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Builder','1','Traditional','Sienna Point','11958','1.7629','Aerobic,Septic Tank,Well','2016','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:37:28.570' ,`MLSNumber` = '55949950' ,`ListAgentFullName` = 'Rosie Moran' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.913892' ,`Longitude` = '-95.575034' ,`PhotoCount` = '32' ,`PostalCode` = '77064' ,`RoomCount` = '11' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Sand Pass' ,`StreetNumber` = '10519' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home on quiet culdesac street in a well-established Winchester Country community of popular Jersey Village area. Home features high ceilings throughout with unique open floorplan, formal living, formal dining and large family room. NEW Roof, NEW fascia/siding, NEW AC Air Ducts, New Tile Flooring and Carpet throughout the house. New Granite Counters in Baths, New Bath fixtures, New exterior/interior Paint, New Stainless Steel appliances, New Granite Countertop and 42in Cabinets in Kitchen, New Garbage Disposal, New electric fixtures and outlets/switches, New landscaping and sod and much more. Great Community with swimming pool, tennis court and playground. Close to US 290 and Beltway that makes it convenient for the commuter. Schedule your appointment today!' ,`Acres` = '0.1598' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 2 WINCHESTER COUNTRY SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BANG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Winchester Country Sec 02' ,`TaxAmount` = '4703' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527655' WHERE `Matrix_Unique_ID` = '214307797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:59:48.180' ,`MLSNumber` = '12761800' ,`ListAgentFullName` = 'Courtney Okanlomo' ,`ListOfficeName` = 'Collective Realty Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739339' ,`Longitude` = '-95.405229' ,`PhotoCount` = '45' ,`PostalCode` = '77098' ,`RoomCount` = '12' ,`ListPrice` = '1994500.00' ,`Status` = 'Active' ,`StreetName` = 'Marshall' ,`StreetNumber` = '1815' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4678' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO ANOTHER HAMPTON LANE BUILDERS,100% COMPLETE,ELEVATOR CAPABLE,WINLOW RESIDENCE.LUXE FORMAL DINING RM & PRIVATE STUDY.CUSTOM STAINED HICKORY,HRDWD FLOORING,11FT CEILINGS,DESIGNER COLOR PALETTE,CUSTOM LIGHT FIXTURES & RECESSED LIGHTING ENVELOPE THE HOME.GOURMET KITCHEN W/WOLF & SUB-ZERO APPLIANCES,GRANITE COUNTERTOPS,2-TONE CABINETRY,EXPOSED FAUXWOOD BEAMS,DOUBLE OVEN,&GREAT RM W/FIREPLACE & BUILT-INS.THE DRY BAR OFFERS SLEEK STORAGE,45-BOTTLE WINE COOLER,& STEPS AWAY FROM THE OUTDOOR KITCHEN W/PAVER FLOORING,DEEP SINK & GAS GRILL.2ND FLR GAMEROOM & LOFT AREA.MASSIVE PRIMARY BDRM,COLOSSAL CUSTOM CLOSET W/PACKING ISLAND&MARBLE COUNTERTOPS;SPA-INSPIRED BTH W/DUAL VANITY,RAIN SHOWER & FREE-STANDING TUB.WALK-IN CLOSETS IN ALL BDRMS.LUSH LANDSCAPE W/SPRINKLER SYSTEM,FULL GUTTERS & CEDAR FENCE.4-ZONE HEATING & AIR;2 WATER HEATERS,2 FIREPLACES.PRE-WIRED FOR SURROUND SOUND.HIGHLY RATED SCHOOLS,MINUTES AWAY FROM RICE U., MUSEUM DISTRICT, MED CTR & DOWNTOWN; SCHEDULE YOUR PRIVATE TOUR!' ,`Acres` = '0.144' ,`Area` = '16' ,`BuilderName` = 'Hampton Lane Bldrs' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 13 WINLOW PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Winlow Place' ,`TaxAmount` = '12791' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527655' WHERE `Matrix_Unique_ID` = '214323425' --> 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','214344670','1668527655','214344670','2022-11-14T21:21:54.857','54654862','Norbert Rivera','Keller Williams Realty - Memorial','','','29.519696','-95.748734','35','77469','4','275000.00','Active','Colonial Rose','6603','Lane','Rosenberg','2','1','4','1819','Single-Family','Great 2 story home located in the highly desired subdivision of Walnut Creek. This 4 bedroom home is perfect for everyone! The living room flows easily through the first floor and leads into the kitchen. The kitchen opens up to the living room and is perfect entertaining. The master bedroom is located on the first floor and the remaining 3 are located on the second. Enjoy the game in the upstairs gameroom. Walnut Creek is home to Cora Thomas Elementary and has several play areas around including the community pool, soccer fields, and huge dog park. Walnut Creek is located only minutes from the Brazos Towncenter, a quick drive to Sugar Land, Houston, and much more!','0.1453','30','Lennar','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Fort Bend South/Richmond','Central Gas','1','ROSEHAVEN SEC 2, BLOCK 1, LOT 54','Subdivision Lot','6329','Appraisal District','','600','0','','2','Gas Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','THOMAS ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Seller','2','Traditional','Walnut Creek, Rosehaven','4328','2.5848','Water District','2008','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:13:33.647' ,`MLSNumber` = '69752711' ,`ListAgentFullName` = 'Oscar Huang' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000603' ,`Longitude` = '-95.258812' ,`PhotoCount` = '22' ,`PostalCode` = '77338' ,`RoomCount` = '3' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = '3rd' ,`StreetNumber` = '711' ,`StreetSuffix` = 'Street' ,`City` = 'Humble' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New 30 year roof, new water proof floor, new double sides windows, new drive way, new kitchen, new marble counter, new tile, new bathroom, all new ceiling fan, fixtures, many more new details.' ,`Acres` = '0.1263' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 19 BENDERS SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HUMBLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Benders Sec 02' ,`TaxAmount` = '3051' ,`TaxRate` = '2.2965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527655' WHERE `Matrix_Unique_ID` = '214359068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:41:18.397' ,`MLSNumber` = '3054393' ,`ListAgentFullName` = 'Swapna Patel' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = 'Priscila Andrade Da Silva' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.750167' ,`Longitude` = '-95.746402' ,`PhotoCount` = '45' ,`PostalCode` = '77450' ,`RoomCount` = '4' ,`ListPrice` = '398000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bluffton' ,`StreetNumber` = '2142' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2351' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This light and airy home on a corner lot in highly desirable Katy ISD will exceed your expectations. The open floorplan in this home will delight you. Full renovation includes: completely new kitchen: new appliances, sink and countertop; new interior/exterior doors; completely remodeled primary bathroom: new flooring, new shower w/ frameless shower door, new dual sinks, new lights; completely remodeled secondary bathroom; all new LED lights in the house; new SPC flooring, new interior paint, new Owen Corning lifetime roof, new hardy siding & paint around garage. This home is just a few homes away from the neighborhood pool, splash pad, and park. You can\'t ask for anything more in this price point.' ,`Acres` = '0.2232' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 3 OAK PARK TRAILS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9721' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'EXLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Oak Park Trails Sec 1' ,`TaxAmount` = '6817' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527656' WHERE `Matrix_Unique_ID` = '214367293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:43:51.660' ,`MLSNumber` = '57524183' ,`ListAgentFullName` = 'Zachary Khushf' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Cheryl McCleary' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`Latitude` = '29.777052' ,`Longitude` = '-95.612609' ,`PhotoCount` = '42' ,`PostalCode` = '77079' ,`RoomCount` = '8' ,`ListPrice` = '605000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Greenpark' ,`StreetNumber` = '823' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled home located in desirable Thornwood neighborhood in the Energy corridor. Easy commutes to Galleria and Memorial City. The home been repiped with new PEX piping. There are granite countertops in the kitchen and all bathrooms, new paint on all interior and exterior surfaces, brand new durable vinyl floors on first floor and new carpet upstairs. Home features plenty of natural lighting through all new energy efficient double pane vinyl windows. There are new cabinet doors with soft close hinges in the kitchen, living room and all bathrooms, recessed lighting with dimmable switches throughout the first floor and new ceiling fans throughout the home. Never flooded. You won\'t want to miss out on this one! *OPEN HOUSE SATURDAY NOV 3rd 12pm-3pm*' ,`Acres` = '0.2032' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 THORNWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'NOTTINGHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thornwood Sec 01' ,`TaxAmount` = '9071' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527656' WHERE `Matrix_Unique_ID` = '214372226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:56:41.127' ,`MLSNumber` = '65612354' ,`ListAgentFullName` = 'Alexander DiSaggio' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = 'Rachel Semien' ,`SellingOfficeName` = 'Keller Williams HoustonCentral' ,`Latitude` = '29.790236' ,`Longitude` = '-95.333029' ,`PhotoCount` = '19' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '210000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Grovey' ,`StreetNumber` = '3014' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1687' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to get a completely remodeled home at a very low price! Per seller: this home was completely remodeled in 2022, with the following details, among other features: Brand new soft close cabinets, built in microwave in island, new granite counters, new stainless appliances, hard wood floors - refinished 2022, new paint throughout, new furnace - 2022, new circuits for kitchen - 2022, epoxy floor in garage, new tile and fixtures in bathrooms, new recessed lighting throughout. ALL APPLIANCES INCLUDED! (refrigerator, washer, dryer, oven, microwave). Schedule your tour asap!' ,`Acres` = '0.1265' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 2 GROVEY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5512' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Grovey' ,`TaxAmount` = '2812' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527656' WHERE `Matrix_Unique_ID` = '214375330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:45:15.680' ,`MLSNumber` = '57569126' ,`ListAgentFullName` = 'Pauline Mejia' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.275578' ,`Longitude` = '-94.834346' ,`PhotoCount` = '32' ,`PostalCode` = '77551' ,`RoomCount` = '0' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Hollywood' ,`StreetNumber` = '2211' ,`StreetSuffix` = 'Avenue' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home on beautiful Galveston Island! This newly renovated home makes the perfect starter home, vacation home or a great investment property. This home was totally renovated in 2022 and offers many updates from new roof, new exterior, new interior, new windows, new LVP flooring through out, new plumbing, new electrical, new HVAC system, Kitchen features new cabinets, custom pantry, stainless steel appliances, versatile smart lighting, trendy backsplash, beautiful butcher block counter tops. Primary bathroom is equipped with a blue tooth speaker so you can enjoy listening to your favorite tunes while you are getting ready to start your day. Enjoy sitting on the front porch making memories with your family on those beautiful summer evenings. This beach style home is centrally located on the island so you can enjoy a short drive to the beach, shopping centers, moody gardens, schlitterbahn and the strand. Enjoy the Island life and schedule your appointment today!' ,`Acres` = '0.0723' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR E 1/2 OF LOT 5 (5-1) BLK 15 HOLLYW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hollywood Heights' ,`TaxAmount` = '2538' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527656' WHERE `Matrix_Unique_ID` = '214431607' --> 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','214446213','1668527656','214446213','2022-11-14T22:53:24.090','98953365','Ryan Kutter','Connect Realty','','','30.280490','-95.443062','48','77301','10','799000.00','Active','Prescott','1010','Drive','Conroe','3','1','4','4149','Single-Family','Located in the desirable Estates section of Stewarts Forest, the Home presents a brick & fieldstone facade, a covered porch, & French door entry, resting on a Premium Lot. An oversized 3-car garage has space in front for additional parking. A resort-style heated pool & spa with a waterfall takes center stage in the backyard. Inside, you will find a flowing floor plan & high-end fixtures. Formal Living Room & Den share a stone fireplace. Formal Dining Room can accommodate large furniture. The Island Kitchen offers granite counters, a walk-in pantry, a butler\'s pantry, & a custom beverage center. The downstairs Primary offers wood floors, Bay windows, & a tray ceiling. Primary Bath has two counters, & a jetted tub. Enter the AMAZING walk-in closet through the Primary Bath. Upstairs you will find a Gameroom & beautifully appointed secondaries. Home is wired for 5.1 surround sound & thermostats are WI-FI enabled. Amenities include a whole house water softening system and a generator.','0.5814','19','Stonebridge Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Conroe Southeast','Central Gas,Zoned','1','STEWARTS FOREST 01, BLOCK 1, LOT 7','Cul-De-Sac,Subdivision Lot,Wooded','25327','Appraisal District','','510','0','','3','Convection Oven,Electric Oven','1','Heated,In Ground','','Gas Cooktop','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Stewarts Forest 01','12914','2.7863','Public Sewer,Public Water,Water District','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:54:02.090' ,`MLSNumber` = '24800273' ,`ListAgentFullName` = 'Ana Remperas' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = 'Kristin Gyldenege' ,`SellingOfficeName` = 'Locke and Key Homes' ,`Latitude` = '29.870008' ,`Longitude` = '-95.499698' ,`PhotoCount` = '31' ,`PostalCode` = '77040' ,`RoomCount` = '9' ,`ListPrice` = '200000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Stonegate' ,`StreetNumber` = '7251' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this great one story with 3 bedroom, 2 bath home with a detached 2 car garage. The kitchen boasts generous counter space making cooking and entertaining a delight. Entertaining is a breeze with this great floor plan complete with a formal dining, breakfast room and family room with bar. The primary bedroom boasts a private en suite and sitting room. All rooms with wood laminate flooring and tiles in the common areas. Bedrooms has ceiling fans and sizable closets. HOME IS BEING SOLD AS WHERE IS. 2019 HVAC and 2019 Water Heater. Come and Check it out!' ,`Acres` = '0.1831' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 23B & 24A BLK 11 WOODLAND TRAILS SEC 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7975' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'DEAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Trails 3' ,`TaxAmount` = '3768' ,`TaxRate` = '2.5842' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527656' WHERE `Matrix_Unique_ID` = '214453806' --> 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','214457883','1668527657','214457883','2022-11-14T21:29:20.210','90391413','Maria Durham','Emerald Properties','','','29.487495','-95.507780','32','77459','6','345000.00','Active','Reindeer','2911','Run','Missouri City','2','1','4','2254','Single-Family','Fabulous property in the heart of Sienna. The large kitchen boasts granite counters and stainless appliances and is open to the dining area and family room. Lage primary bedroom suite with separate tub and shower. Three spacious bedrooms and gameroom upstairs. Relax after a long day in your private jacuzzi in the extended sun room. The back yard is huge with extended patio. Enjoy Sienna\'s wonderful recreation facilities, walks and lakes. Easy access to downtown and medical center. Walking distance to Ridge Point High School. Call today for private showing!','0.1225','38','','','Electric Dryer Connections,Gas Dryer Connections','','Levee District,Mud,Sellers Disclosure','1','Gas Connections','1','Sienna Area','Central Gas','1','SIENNA VILLAGE OF SHIPMANS LANDING SEC 13-C, BLOCK 1, LOT 3','Subdivision Lot','5334','Appraisal District','','1307','0','','2','Electric Oven','0','','','Gas Range','','Composition','19 - Fort Bend','LEONETTI ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Sienna Village Of Shipmans Landing','5679','2.6079','Water District','2006','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:10:16.060' ,`MLSNumber` = '93984130' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659484' ,`Longitude` = '-95.056080' ,`PhotoCount` = '41' ,`PostalCode` = '77571' ,`RoomCount` = '10' ,`ListPrice` = '413723.00' ,`Status` = 'Active' ,`StreetName` = 'Clements Shore' ,`StreetNumber` = '2205' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#93984130 REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, March 2023 Completion! The Merlot in Morgan’s Landing is the perfect home for entertaining friends and family, especially during the holiday season! This beautiful single-story design features an expansive open-concept kitchen and great room, providing plenty of extra space to offer guests a friendly invite for dinner. Take the party outside for al fresco dining on your spacious covered outdoor patio. The owner\'s suite is a peaceful retreat after a long day with the spa-like shower! Three secondary bedrooms, 2 baths, a private study, a game room, and convenient laundry room complete this homeowner’s dream. Design upgrades to highlight include: ceiling fans in gathering and owner’s suite, upgraded kitchen backsplash, full sod/ landscape, and more! Structural options include: tray ceiling in gathering room, full gutters, 8’ entry and rear doors, study, mud-set shower in owner’s bath, gas line at covered outdoor living.' ,`Acres` = '0.162' ,`Area` = '7' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 35, Block 3 of Morgan\'s Landing Section 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7087' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527657' WHERE `Matrix_Unique_ID` = '214488580' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:35:31.603' ,`MLSNumber` = '78617925' ,`ListAgentFullName` = 'Vanessa Hyman' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825772' ,`Longitude` = '-95.794374' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Varano' ,`StreetNumber` = '3603' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to another gem of Marcello Lakes, a beautiful modern home with amazing water views.\r\n\r\nThe home has it all ! \r\nStarting with the grand 2 story foyer, high ceilings, built- in character walls. Built in media system. Super bright natural light !\r\n \r\nThe home office/ study is spacious. \r\nChef\'s kitchen has a breakfast area , and an open family concept area.\r\nFireplace and covered outdoor area \r\nOut door, pre-wired for an outdoor chefs kitchen. \r\nMaster bedroom has high ceilings , bay windows , a california style closet, views of the lake \r\nLarge walk in closets throughout entire home \r\nMedia room\r\nGameroom\r\nUp Stairs covered patio, views\r\nSerene Awaits You !' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Princeton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 Marcello Lakes Sec 2' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marcello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527657' WHERE `Matrix_Unique_ID` = '214514940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:28:05.770' ,`MLSNumber` = '25580353' ,`ListAgentFullName` = 'Brett Sims' ,`ListOfficeName` = 'Sold-It Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.178450' ,`Longitude` = '-95.831613' ,`PhotoCount` = '28' ,`PostalCode` = '77355' ,`RoomCount` = '9' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Hills' ,`StreetNumber` = '105' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! If you\'re looking to escape City life and still be close to all the conveniences you need, this is the perfect home for you! Beautifully updated, well cared for home on close to 1 acre. If you\'re looking for space, privacy, and a home with a yard full of large, beautiful trees, you\'ve come to the right place! Wonderful open floor plan perfect for entertaining in your newly updated spacious kitchen! The living area off of the kitchen boast a beautiful fireplace perfect for cool Texas days! Carport with space for two vehicles is perfect on those warm Texas days to keep your car out of the hot sun. The entire home has been repainted with a neutral color ready for you to add your personal touch within! Oak Hollow has beautiful recreational activities from fishing, jogging, or spending a quiet day overlooking the scenic pond! Hurry and schedule your showing, this home will not last long!' ,`Acres` = '0.9' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S636000 OAK HOLLOW BLK 3 LOT 28 ACRES .9 S# 50405495TXA HUD#' ,`LotDesciption` = 'Cleared' ,`LotSize` = '39204' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Hollow' ,`TaxAmount` = '2174' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527657' WHERE `Matrix_Unique_ID` = '214517419' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:03:57.460' ,`MLSNumber` = '74473892' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344697' ,`Longitude` = '-95.588558' ,`PhotoCount` = '5' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '278990.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury' ,`StreetNumber` = '674' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1605' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two-story home is the ideal space for looking to create new memories. Enjoy cooking on granite countertops and using brand new stainless steel appliances. The Endeavor includes an open concept kitchen and a private backyard that\'s perfect for entertaining. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Chapel Run Section 2 Block 2 Lot 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527657' WHERE `Matrix_Unique_ID` = '214527282' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:47:55.437' ,`MLSNumber` = '75367206' ,`ListAgentFullName` = 'June Tyler' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767433' ,`Longitude` = '-95.005862' ,`PhotoCount` = '26' ,`PostalCode` = '77521' ,`RoomCount` = '12' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Inverness' ,`StreetNumber` = '5119' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bring on the holidays! If you are ready to host those endless holiday parties, then this is the perfect home for you! Situated on a large corner lot, this home has way too many upgrades to name including all new appliances, brand new quartz countertops, energy-efficient windows throughout and new showers. There is plenty of room for all of your out of town visitors, space to prepare those secret recipes and a variety of areas to play games, dance, talk quietly or enjoy the big meal. When you need to get away from it all, head outdoors, make s\'mores, stargaze or simply relax by the fire in the oversized backyard. The home is located in the very desirable Country Club Oaks subdivision right in the heart of Baytown, within close proximity to great shopping and dining while having easy access to Houston, Pasadena or Beaumont. Hurry...this one definitely won\'t last long, so call your favorite agent for a showing today!' ,`Acres` = '0.2755' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 15 COUNTRY CLUB OAKS SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Oaks Sec 05' ,`TaxAmount` = '5712' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527658' WHERE `Matrix_Unique_ID` = '214542797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:26:36.460' ,`MLSNumber` = '40283228' ,`ListAgentFullName` = 'Bethann Eaton' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986771' ,`Longitude` = '-95.595755' ,`PhotoCount` = '47' ,`PostalCode` = '77070' ,`RoomCount` = '12' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Primwood' ,`StreetNumber` = '11807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately brick 4 Bedroom home located in a quiet cul de sac in Lakewood Forest. Gorgeous landscaping front and back. Beautiful hard wood floors throughout the downstairs with carpet in the bedrooms and game room. The attention to detail is something the newer homes don\'t have. Custom crown molding in most rooms. Formal dining room, spacious family room with a stunning marble surround fireplace, great island kitchen, big breakfast room that opens to the backyard and pool, a large study with built-ins plus a smaller tucked away office close to the kitchen. The Primary bedroom is spacious and lovely with an ensuite primary bathroom with separate tub and shower and separate closets! Upstairs you will find 3 large bedrooms and 2 full baths plus a huge game room. The backyard is a garden paradise. Beautiful landscaping, pool, spa and water feature and plenty of deck space for entertaining. Ideally located in highly acclaimed Cy-Fair schools.' ,`Acres` = '0.3324' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 25 & 26 BLK 4 LAKEWOOD FOREST SEC 12' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest' ,`TaxAmount` = '9051' ,`TaxRate` = '2.3988' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527658' WHERE `Matrix_Unique_ID` = '214543547' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:51:22.690' ,`MLSNumber` = '56301733' ,`ListAgentFullName` = 'Heather Coggin' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671006' ,`Longitude` = '-94.651849' ,`PhotoCount` = '6' ,`PostalCode` = '77514' ,`RoomCount` = '4' ,`ListPrice` = '175500.00' ,`Status` = 'Active' ,`StreetName` = 'Rivers' ,`StreetNumber` = '410' ,`StreetSuffix` = 'Road' ,`City` = 'Anahuac' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Huge lot with fenced in backyard! Manufactured home with kitchen Island, breakfast bar & built in appliances, huge master suite w/ office, walk in closet, dual vanity, and garden tub and shower, 2 living areas, spacious utility, thermopane windows, & fireplace. Near by hunting, fishing, boating and tons of bird watching at Anahuac Wildlife Refuge.' ,`Acres` = '1' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '464 TR 4C-0-1 G A WILSON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'G A WILSON' ,`TaxAmount` = '1170' ,`TaxRate` = '2.6602' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527658' WHERE `Matrix_Unique_ID` = '214546310' --> 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','214554641','1668527658','214554641','2022-11-14T21:30:29.767','64716412','Karen Davis','KLD Premier Realty','','','29.723568','-95.862052','42','77441','10','879000.00','Active','Enchanted Shores','28315','Lane','Fulshear','4','1','4','4327','Single-Family','LOCATION, LOCATION, LOCATION! This stunning waterfront home in the award-winning subdivision of Cross Creek Ranch has breathtaking views and incredible sunsets. Inside features \"wood like\' tile floors, Plantation Shutters, upgraded Berber carpet, high ceilings and open floorplan. Huge Island Kitchen with granite, GE stainless steel appliance package, lots of cabinets, recessed and pendent lights. Family Room with wall of windows, sliding glass door, gas log Fireplace, beamed ceiling. Large Primary Suite with tray ceiling. Primary Bath with double sinks, groin ceiling, chandelier, standalone MAAX soaker tub and oversized walk-in closet. The second floor has a huge Game Room, Media Room, 2 secondary Bedrooms and 2 Full Baths. Close to private pocket park and walking distance to a Day Care and KISD Elementary, Junior High and High School. Convenient to grocery stores, restaurants, and retail stores. The subdivision also has a waterpark, pools, restaurant, dog park and workout facility.','0.2321','36','Trendmaker','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','CREEK COVE AT CROSS CREEK RANCH SEC 10, BLOCK 1, LOT 21','Water View,Waterfront','10109','Appraisal District','','1300','0','','3','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','30 - Katy','CAMPBELL ELEMENTARY SCHOOL (KATY)','JORDAN HIGH SCHOOL','ADAMS JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Cross Creek Ranch','18126','3.3425','Water District','2017','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:31:09.157' ,`MLSNumber` = '52350579' ,`ListAgentFullName` = 'Bethann Eaton' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.001488' ,`Longitude` = '-95.625121' ,`PhotoCount` = '48' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Post Oak Glen' ,`StreetNumber` = '13515' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3476' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lakewood Glen Trails is a mature subdivision with quiet tree lined streets. Great schools, parks, amenities and easy access to wherever you want to be. This lovely home has many updates. Most flooring is hard surface either luxury vinyl or hardwood. The kitchen is fabulous with quartz countertops and island, recent appliances including double ovens and a gas range. The family room is spacious but cozy with a corner fireplace, high ceiling and lots of windows. Primary bedroom is on the first floor with its own private bathroom. Great office/study with French doors and built-ins. On the second floor are 4 additional bedrooms and 2 full bathrooms. Huge backyard and covered patio are ready for lots of fun activities.' ,`Acres` = '0.2153' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 LAKEWOOD GLEN TRAILS SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9378' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Glen Trails' ,`TaxAmount` = '8805' ,`TaxRate` = '2.5217' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527658' WHERE `Matrix_Unique_ID` = '214586118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:23:50.263' ,`MLSNumber` = '10731018' ,`ListAgentFullName` = 'Landra Doughty' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.852766' ,`Longitude` = '-95.800387' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Pike' ,`StreetNumber` = '24526' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous designer two story home that shows like a model! Beautiful wood/tile floors throughout the first floor. Gorgeous kitchen with granite counters, subway tile backsplash, 42\" cabinets and stainless appliances. Study with French doors. All bedrooms upstairs along with a gameroom and laundry room. Master bathroom has a tub plus separate shower, double sinks and large walk in closet. Covered front porch. Large backyard with lovely custom back patio with no rear neighbors. Awesome neighborhood that offers many amenities including parks, playgrounds and a pool.' ,`Acres` = '0.126' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 KING CROSSING SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '880' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'King Xing Sec 7' ,`TaxAmount` = '8820' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527659' WHERE `Matrix_Unique_ID` = '214603807' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:17:57.090' ,`MLSNumber` = '62064732' ,`ListAgentFullName` = 'Waldina Galeano' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802844' ,`Longitude` = '-94.822354' ,`PhotoCount` = '32' ,`PostalCode` = '77523' ,`RoomCount` = '4' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Isle' ,`StreetNumber` = '6211' ,`StreetSuffix` = 'Lane' ,`City` = 'Cove' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Full remodeled 3bedrooms, office/study room, 2 bath, detached car garage. Located in Very Desirable neighborhood of Southern Plantation! includes an Amazing size lot with a spacious garage apartment.' ,`Acres` = '0.548' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 71 THE SOUTHERN PLANTATION SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '23871' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Plantation Sec 2' ,`TaxAmount` = '3345' ,`TaxRate` = '1.656' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527659' WHERE `Matrix_Unique_ID` = '214637576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T22:14:50.863' ,`MLSNumber` = '97124735' ,`ListAgentFullName` = 'Jay Clemente' ,`ListOfficeName` = 'Realty World Homes & Estates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164415' ,`Longitude` = '-95.810783' ,`PhotoCount` = '29' ,`PostalCode` = '77447' ,`RoomCount` = '3' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Joseph' ,`StreetNumber` = '25342' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '2.15' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S441103 COUNTRY LANE ESTATES 3 BLK 3 LOT 13 ACRES 2.15' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '93654' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '144' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Country Lane Estates 3' ,`TaxAmount` = '7445' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527659' WHERE `Matrix_Unique_ID` = '214665211' --> 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','214666522','1668527659','214666522','2022-11-14T22:02:21.633','44595560','Neil Mccallum','Hometown America Incorporated','','','30.014880','-95.512136','27','77379','5','310000.00','Active','Castletown Park','16114','Court','Sring','2','1','4','2532','Single-Family','Welcome to Castletown Park Court--a quiet cul-de-sac in the Wimbledon Subdivision with low taxes, a community pool, and a hike and bike trail. Perfect for any family, this home has 4-bedrooms--all upstairs off the large game room--2 full bathrooms, and 1 half bath (off the kitchen and living room downstairs). The kitchen has been updated with a custom pantry, white cabinets, subway tile backsplash, and granite countertops. Positioned at the front of the home, the office offers plenty of privacy and is a great workspace for studying or working from home. The backyard has ample space for entertaining or for watching your children or pets play. Don\'t delay in making 16114 Castletown Park Court yours today!','','13','','','','','Sellers Disclosure','','','1','Champions Area','Central Gas','1','LT 24 BLK 3 WIMBLEDON PARK','Cul-De-Sac,Other','','','','645','0','','2','Gas Oven','0','','','','','Composition','32 - Klein','MITTELSTADT ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Wimbledon Park','','','Public Sewer,Public Water','1989','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:43:17.670' ,`MLSNumber` = '86828371' ,`ListAgentFullName` = 'Amber Riley' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723796' ,`Longitude` = '-95.860980' ,`PhotoCount` = '36' ,`PostalCode` = '77441' ,`RoomCount` = '8' ,`ListPrice` = '939900.00' ,`Status` = 'Active' ,`StreetName` = 'Enchanted Shores' ,`StreetNumber` = '28227' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Master planned community Cross Creek Ranch LUXURY 4,446 sq ft 2 story Trendmaker built in 2018 features 4 large bedrooms - 2 DOWN, 4.5 baths, tandem garage, large back yard oasis with a POOL and on the LAKE! Located walking distance from a playground and to acclaimed Katy ISD Campbell Elementary, Adams Jr High & Jordan High! Featuring grand entrance to a 2 story entry w/hardwood flooring, open concept floor plan, study w/French doors, sliding doors across the family room & dining room with massive windows! Grand designer kitchen with oversized island, breakfast bar & counters, DOUBLE OVENS, SS appliances! Luxury primary suite with breathe taking bath spa w/garden tub & plenty of built-ins! Upstairs game room, media room & 2 large bedrooms each with private baths. Enjoy your new covered patio out back with surround sound, heated pool, side yard, lake view, and get ready for outdoor entertaining! Schedule your appointment today! Welcome HOME!' ,`Acres` = '0.2319' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK COVE AT CROSS CREEK RANCH SEC 10, BLOCK 1, LOT 16' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '10102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Creek Cove At Cross Creek Ranch Sec 10' ,`TaxAmount` = '18841' ,`TaxRate` = '3.3425' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527659' WHERE `Matrix_Unique_ID` = '214678989' --> 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','214681654','1668527660','214681654','2022-11-14T21:28:35.000','39108406','Salah Kaspo','RE/MAX Signature','','','29.713835','-95.650294','24','77082','4','319000.00','Active','Deer Chase','3907','Drive','Houston','2','1','4','2566','Single-Family','Beautiful 4 bedrooms home with a lot of upgrades very well maintained, Nice back yard with multiple fruit trees and nice patio for your BBQ time, New vinyl tile upstairs. All ready to move in','','37','','','Gas Dryer Connections','','Sellers Disclosure','1','Freestanding,Gaslog Fireplace','1','Mission Bend Area','Central Gas','1','LT 4 BLK 7 WEST BEND SEC 1','Cul-De-Sac','6696','Appraisal District','','400','0','','2','Convection Oven','0','','','Gas Range','','Composition','2 - Alief','HOLMQUIST ELEMENTARY SCHOOL','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Lockbox Right Side,Vacant/Unoccupied','Appraisal District','2','Traditional','WEST BEND 1','','','Public Sewer,Public Water','1992','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T21:38:04.667' ,`MLSNumber` = '90861977' ,`ListAgentFullName` = 'Crystal Mason' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860802' ,`Longitude` = '-95.422626' ,`PhotoCount` = '21' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Knox' ,`StreetNumber` = '6728' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom, 2-1/2 bathroom two story home with modern brushed nickel finishes throughout. Living and kitchen areas join to be able to provide an open layout. Sizable windows provide a nice touch of natural lighting and view of relaxing back porch and nice sized backyard. Configured to have first floor living and sleeping quarters on the secondary level. All bedrooms have walk in closets w/shelving… the primary bedroom has two spacious walk in closets! Conveniently located minutes from downtown Houston and has major highway access. Inquire about reserving your new home today!' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = 'Kensli Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 25 HIGHLAND HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WESLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Heights' ,`TaxAmount` = '1154' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527660' WHERE `Matrix_Unique_ID` = '214684787' --> 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','214692459','1668527660','214692459','2022-11-14T21:00:28.300','70901555','Yadira Ornelas','JLA Realty','','','29.864211','-95.190032','2','77044','4','265000.00','Active','Wyatt Oak','9522','Lane','Houston','2','0','3','1255','Single-Family','Welcome to a Cozy modern/traditional home. It is a 3 bedroom, 2 bath, 2 car garage! Relax in your primary suite with a walk-in closet included and space for a sitting area. Ceramic tile throughout the home, fresh interior paint, lots of natural light. new window treatments, light fixture, plumbing fixtures and much more. Located nearby shopping and dining. Easy access to Beltway 8, Hwy 59, I-10, and Hwy 90! Call me for your private tour or any questions. Tiene preguntas sobre estate casa llame hoy y le podemos dar una cita para ver y mostrar la casa.\r\n*Professional pictures coming soon','0.101','2','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','North Channel','Central Gas','1','LT 18 BLK 2 SUNRISE PINES SEC 1','Cleared','4400','Appraisal District','','363','0','','2','','0','','','Electric Range','','Composition','46 - Sheldon','SHELDON LAKEE ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Sunrise Pines Sec 01','4781','2.9993','Public Sewer,Public Water,Water District','2011','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','214753172','1668527660','214753172','2022-11-14T21:11:05.790','56302638','Jared Turner','LennarVillageBldr-JaredTurner','','','29.842583','-94.828097','8','77523','8','370000.00','Active','Lakewood','15215','Avenue','Mont Belvieu','2','1','3','2111','Single-Family','NEW! **LENNAR IS IN LAKES OF CHAMPIONS!!! The inviting single story Sandstone with Brick Elevation \"A\" floor plan from the Brookstone Collection by Lennar features a generous layout that makes smart use of the available space. A versatile study can be found beside the front door, while down the hall is the open concept living area with a covered patio in the back. Two bedrooms share a full bathroom in the hall at the front of the home, while the owner’s suite is tucked into a back corner with a private bathroom. \r\n*HOME ESTIMATED TO BE COMPLETE, December, 2022*','','53','Lennar Homes','','','','Mud,Other Disclosures','1','','','Chambers County West','Central Gas','1','SEC 0004 BLK 004 LOT 004','Subdivision Lot','','','','518','1','To Be Built/Under Construction','2','','0','','','','','Composition','6 - Barbers Hill','BARBERS HILL NORTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL NORTH MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Lakes of Champions Estates','','2.14','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','214754312','1668527660','214754312','2022-11-14T21:08:58.500','56047523','Jared Turner','LennarVillageBldr-JaredTurner','','','29.842583','-94.828097','8','77523','9','415000.00','Active','Lake Front','15334','Drive','Mont Belvieu','2','0','4','2047','Single-Family','NEW! **LENNAR IS IN LAKES OF CHAMPIONS!!! The inviting single story Travertine II with Brick/Stone Elevation \"G\" floor plan from the Brookstone Collection by Lennar features a welcoming covered front porch and entry foyer, a STUDY, kitchen with a walk-in pantry, an open breakfast room and family room that offers access to a covered rear patio, and a walk-in utility room. The master bedroom features an en suite master bathroom with dual sinks, separate shower and tub, and dual master closets. \r\n**3 CAR GARAGE!!!\r\n**Home Estimated to be Complete, January 2023**','','53','Lennar Homes','','','','Mud,Other Disclosures','1','','','Chambers County West','Central Gas','1','SEC 0004 BLK 005 LOT 008','Subdivision Lot','','','','518','1','To Be Built/Under Construction','3','','0','','','','','Composition','6 - Barbers Hill','BARBERS HILL NORTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL NORTH MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Lakes of Champions Estates','','2.14','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','214755361','1668527660','214755361','2022-11-14T21:06:20.100','83367371','Jared Turner','LennarVillageBldr-JaredTurner','','','29.952486','-95.191475','44','77346','7','340000.00','Active','Strongbow','15034','Lane','Humble','2','1','4','1833','Single-Family','BRAND NEW! Beautiful Village Builders Avante Collection, \"Everett\" Elevation D Plan in Balmoral! This single-story home has a layout that is perfect for growing families with a living area in the front and bedrooms in the back. The front door leads into the open concept living room, which flows seamlessly into the dining room and kitchen. In the back of the home are four bedrooms, including the owner’s suite which has a private bathroom and large walk-in closet.\r\n**Home Estimated to be Complete, April 2023**','','1','Village Builders','','','','Mud','','','','Summerwood/Lakeshore','Central Gas','1','SEC 0001 BLK 002 LOT 020','Subdivision Lot','','','','1130','1','To Be Built/Under Construction','2','','0','','','','','Composition','29 - Humble','CENTENNIAL ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Balmoral','','3.56','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','214757342','1668527660','214757342','2022-11-14T22:00:07.117','74274381','Zelda Abadom','The Kossev Group','','','29.526164','-95.731113','40','77469','3','380000.00','Active','Gladiolus','8702','Drive','Richmond','2','1','3','2370','Single-Family','Welcome to 8702 Gladiolus Dr.! You will love the open floor plan and high ceilings in this beautiful two story home in Bonbrook Plantation South. The first floor has an island kitchen, formal dining room and a spacious living room with vaulted ceilings. Master is located in a private corner on the first floor. You will enjoy the nice covered patio and large backyard. The gameroom and two bedrooms are located on the second floor. Schedule your showing today.','0.2101','30','','','','','Sellers Disclosure','','','','Fort Bend South/Richmond','Central Electric,Central Gas','1','BONBROOK PLANTATION SOUTH SEC 6, BLOCK 3, LOT 1','Subdivision Lot','9154','Appraisal District','','700','0','','2','','0','','','','','Composition','33 - Lamar Consolidated','CARTER ELEMENTARY SCHOOL','GEORGE RANCH HIGH SCHOOL','RYON/READING JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Bonbrook Plantation South','6783','2.6948','Water District','2018','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','214757842','1668527660','214757842','2022-11-14T22:25:04.207','85244029','Rhonda Jordan','Properties of Texas','','','29.781548','-95.731918','24','77450','8','399000.00','Active','Whitehurst','602','Court','Katy','2','1','4','3021','Single-Family','Gorgeous custom built home on quiet culdesac close to frwy & few blks from elem and high school. Only 2 owner home well maintained on .27 acre huge lot w/ mature trees. Home will need new carpet and some updating. Enter this elegant home with high ceilings & large windows. Huge living room w/ formal dining & library/office area. Lg master down w/separate shower & dbl sinks. 3 large bedrooms upstairs w/ a bonus room added on appx 10x6. Also lg attic room is finished on 3rd floor for addtl space. Beautiful marble floors down w/ exception of 2 rooms. Carpet needs replacing. Lg open kitchen area w/breakfast area and lg windows. Drive thru garage w/concrete for a boat or trailer. Double driveway w/plenty of parking area. Covered breezeway for rain protection from garage to home. Tiled patio out back. One of the last homes w/mailbox at residence! Sq ft is apprx. Buyer to purchase new survey.','0.2733','36','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','','1','Katy - Southeast','Central Electric','1','LT 24 BLK 3 NOTTINGHAM COUNTRY SEC 6','Cul-De-Sac,Subdivision Lot','11907','Appraisal District','','300','0','','1','Double Oven','0','','','Electric Cooktop','','Aluminum','30 - Katy','NOTTINGHAM COUNTRY ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','MEMORIAL PARKWAY JUNIOR HIGH SCHOOL','Appointment Required','Seller','2','Traditional','Nottingham Country Sec 06','6326','2.3693','Public Sewer,Public Water','1979','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','214757919','1668527660','214757919','2022-11-14T21:11:22.640','13330761','Teresa Hill','Coldwell Banker Realty','','','30.187774','-95.746686','36','77355','9','322000.00','Active','Limber Pines','30511','Drive','Magnolia','2','0','3','1986','Single-Family','ASSUMABLE NOTE at 4%. This charming 3/4 bedroom sits on an oversized, fenced in yard in the sought after community of Glen Oaks. High Ceilings, Granite Counter Tops, GE Stove with Griddle, and Cabinets Galore! This beauty has custom accents in the living room/kitchen area as well as what could be a fourth bedroom. Split floor plan with a deluxe master bathroom. Covered patio, 2\" wood blinds throughout and a study area with a view of the back porch/yard. Recreation center, pool, gym, basketball court, nature trails, dog park, all in your community and just minutes from the quaint little town center of Magnolia. Easy access to The Woodlands, Tomball, and surrounding areas. This home has been loved by one owner and is ready for it\'s new family. ***All dimensions should to be verified by buyer.***','0.2885','15','Castle Rock','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Magnolia/1488 West','Central Gas','1','S532204 - GLEN OAKS 04 REPLAT NO 1, BLOCK 2, LOT 2','Subdivision Lot','12567','Appraisal District','','300','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','36 - Magnolia','NICHOLS SAWMILL ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment','Appraisal District','1','Ranch','Glen Oaks 04 Rep 1','8705','2.8087','Public Sewer,Water District','2019','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','214760049','1668527660','214760049','2022-11-14T21:19:24.523','63377323','Jude Mustafa','SKW Realty','','','29.639509','-95.677465','47','77498','10','360999.00','Active','Dunbar Grove','16802','Court','Sugar Land','2','1','4','2652','Single-Family','Amazing home nestled in the quiet neighborhood of Summerfield. Located in the cul-de-sac with no back neighbors. Tons of room in this house! 4 large bedrooms, huge game room, both formals, breakfast, and charming family room. And tons of closet space! No carpet anywhere! Entire downstairs is tile and entire upstairs (including the stairs) is laminate wood flooring. Granite kitchen with stainless steel appliances and glass subway tile back splash. Not to mention the enormous backyard! Windows galore to let all the natural light in. Excellent location close to restaurants, shopping and entertainment! Fort Bend ISD.','0.2221','37','','','','','Sellers Disclosure','','','2','Sugar Land West','Central Gas','1','SUMMERFIELD SEC 4, BLOCK 3, LOT 8','Cul-De-Sac','9675','Appraisal District','','440','0','','2','','0','','','','','Composition','19 - Fort Bend','OYSTER CREEK ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (FORT BEND)','GARCIA MIDDLE SCHOOL (FORT BEND)','Appointment Required','Appraisal District','2','Traditional','Summerfield Sec 4','6554','2.6329','Water District','1998','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','214760587','1668527660','214760587','2022-11-14T21:11:17.180','16873998','Johnny Tran','Texas Ally Real Estate Group,','','','29.781797','-95.429107','2','77007','2','450000.00','Active','Kansas','5901','Street','Houston','1','0','2','1036','Single-Family','Selling for lot value. Lot has been subdivided into 3 tracts. Great corner lot perfect for a builder/developer to build 3 single family homes. Architectural floor plan completed. Lots of new construction homes in the surrounding area selling for $500K+. Survey attached','0.1228','9','','','','','No Disclosures','','','','Cottage Grove','Central Electric,Central Gas','0','LTS 687 & 688 COTTAGE GROVE SEC 4','Corner','5350','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','MEMORIAL ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Traditional','Cottage Grove Sec 04','5701','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully