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-10-31T07:01:03.840' ,`MLSNumber` = '51728024' ,`ListAgentFullName` = 'John Bailey' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.160043' ,`Longitude` = '-95.086702' ,`PhotoCount` = '13' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '262990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102C' ,`StreetNumber` = '46' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to \"The Ponderosa, 1401C\" By Casas Houston, a Beautiful Home that sits on (.16) of an acre.This 4 bedroom 2 bath home features 9\' ceilings with open concept kitchen, family and dinning area. The kitchen cabinets boast crown molding and granite counter tops with under cabinet lighting. \"The Ponderosa\" comes loaded with energy features such as a 16-SHEER HVAC system, Low-E windows, blown insulation and much more. Double wide driveway plus a two car garage makes it easy to store your weekend toys, bikes, motorcycles, wave runners and so much more. Take advantage of the low tax rate at 1.99 and low POA with brand new schools and a Splash Pad. Appliance package includes Refrigerator, dishwasher, microwave and stove black on stainless steel. Schedule your tour today!' ,`Acres` = '0.16' ,`Area` = '52' ,`BuilderName` = 'Casas Houston' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 3, BLOCK 50, LOT 5105, ACRES .37' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sante Fe' ,`TaxAmount` = '983' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667227331' WHERE `Matrix_Unique_ID` = '204247230' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:29:57.663' ,`MLSNumber` = '83488833' ,`ListAgentFullName` = 'Cynthia Wolff' ,`ListOfficeName` = 'Beth Wolff, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753994' ,`Longitude` = '-95.513007' ,`PhotoCount` = '7' ,`PostalCode` = '77024' ,`RoomCount` = '0' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Memorial' ,`StreetNumber` = '11320' ,`StreetSuffix` = 'Drive' ,`City` = 'Piney Point Village' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, wooded cul-de-sac is an amazing location for your new home! Even though this property has a Memorial Drive address, it faces Shadow Way. With this 26,000+ square foot lot, there is plenty of space for a luxurious home, garage, pool and outdoor kitchen. The home currently on the lot is not situated to take advantage of this beautiful property. This rare opportunity is zoned to Memorial Drive Elementary, Spring Branch Middle School, and Memorial High School. Close proximity to The Kinkaid School and St. Francis Episcopal School. Minutes from Whole Foods and Trader Joe\'s on Voss.' ,`Acres` = '0.6084' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2O SHADOWOOD U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '26500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadowood U/R' ,`TaxAmount` = '26046' ,`TaxRate` = '2.1721' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1667227331' WHERE `Matrix_Unique_ID` = '207272219' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:22:31.620' ,`MLSNumber` = '12960583' ,`ListAgentFullName` = 'Michael Gonzales' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.607711' ,`Longitude` = '-95.419385' ,`PhotoCount` = '6' ,`PostalCode` = '77047' ,`RoomCount` = '2' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Bridgeport' ,`StreetNumber` = '13713' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention builders...NO RESTRICTIONS...3/4 of an acre or 30,056 sq.ft lot ready to build multiple homes or you could build your custom home! With many mature trees around, no HOA, your options are endless on the style of home you could build with a workshop or even an \"in-law\" suite. Minutes from the Medical Center and even Downtown Houston. Current house on the property is not livable. Don\'t miss out on this opportunity.' ,`Acres` = '0.69' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S 100X300 FT OF LT 2 BLK M ALMEDA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30056' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Almeda' ,`TaxAmount` = '3846' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227332' WHERE `Matrix_Unique_ID` = '207693036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:12:59.297' ,`MLSNumber` = '2918921' ,`ListAgentFullName` = 'Amy Pieper' ,`ListOfficeName` = 'BHGRE Hometown' ,`SellingAgentFullName` = 'Savannah Gutierrez' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.892506' ,`Longitude` = '-96.490015' ,`PhotoCount` = '21' ,`PostalCode` = '78950' ,`RoomCount` = '4' ,`ListPrice` = '269000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'FM 109' ,`StreetNumber` = '1330' ,`StreetSuffix` = '' ,`City` = 'New Ulm' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW CONSTRUCTION on .258 ac lot in Downtown New Ulm. The front of the home is stone and the rest of the house is hardi board siding. Front and back porches. There are also many unique features that accent this newly built home. Stainless appliances in the kitchen, including side x side refrigerator; washer & dryer hookups in the laundry room. Large master suite with spacious walk in closet; his and her sinks; claw foot tub and walk in shower. There is even and entrance to the back patio from both the master suite and master bath. Back porch has an outside shower for those messy yard days to rinse off. \r\nMake your appointment to view this home today!' ,`Acres` = '0.258' ,`Area` = '57' ,`BuilderName` = 'Pilcik Enterprises' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NEW ULM TOWNSITE BLOCK 17 LOT 3-4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '11249' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'New Ulm Townsite' ,`TaxAmount` = '3086' ,`TaxRate` = '1.6049' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227332' WHERE `Matrix_Unique_ID` = '208407416' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:37:11.627' ,`MLSNumber` = '6953552' ,`ListAgentFullName` = 'Claire Liang' ,`ListOfficeName` = 'Houston Elite Properties LLC' ,`SellingAgentFullName` = 'Angela Shaw' ,`SellingOfficeName` = 'Douglas Elliman Real Estate' ,`Latitude` = '29.759054' ,`Longitude` = '-95.545953' ,`PhotoCount` = '29' ,`PostalCode` = '77024' ,`RoomCount` = '7' ,`ListPrice` = '730000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Vanderpool' ,`StreetNumber` = '214' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will love this cozy home located in Houston\'s most prestigious neighborhood in the Tealwood subdivision. This house has 4 bedrooms, 3.5-bathrooms, and 2 detached car garage. The beautiful home has an open floor plan good for easy conversation and engineered hardwood flooring goes through all the rooms. The inviting living room features a magnificent fireplace, ceiling fan, beam ceiling, and built-ins. The chef of the family will surely enjoy the granite kitchen that offers stainless steel appliances, a beautiful blue backsplash, a large island, and plenty of storage spaces. The bedrooms have walk-in bathrooms with fully tiled shower rooms. This 9,200 sq foot lot has a spacious lawn and backyard with fresh green grass and beautiful mature trees wrapped around the house that gives you a fresh and calming vibe. Come and visit this home in this great neighborhood. Schools are rated one of the best in Houston/memorial. Contact our agent now and visit this cozy home!' ,`Acres` = '0.2112' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 4 TEALWOOD SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tealwood' ,`TaxAmount` = '18128' ,`TaxRate` = '2.7165' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227332' WHERE `Matrix_Unique_ID` = '209526934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:56:29.060' ,`MLSNumber` = '11901612' ,`ListAgentFullName` = 'Jennifer Zweiacker' ,`ListOfficeName` = 'Zweiacker & Associates' ,`SellingAgentFullName` = 'Misti Moser' ,`SellingOfficeName` = 'Keller Williams Realty' ,`Latitude` = '30.556987' ,`Longitude` = '-96.374178' ,`PhotoCount` = '45' ,`PostalCode` = '77845' ,`RoomCount` = '14' ,`ListPrice` = '1130000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wild Horse' ,`StreetNumber` = '5903' ,`StreetSuffix` = 'Run' ,`City` = 'College Station' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Opulent 2-story home on 3+ idyllic acres. A lighted stone path leads to the rustic front entrance opening to a vaulted foyer & winding staircase to upstairs entertainment area. Beyond the foyer your eyes are drawn to the vaulted ceiling & natural lighting of the enormous great room w/ stone fireplace flanked by built-ins, picture windows w/ storage seats, & transomed doors leading to the covered patio. Seat 8-10 guests in the open formal dining area adjacent to the enormous European inspired kitchen w/ wood plank barrel ceiling, granite counters, limestone columns, eating bar, & immense island. The bright primary sanctuary has vaulted ceiling & patio access. Primary en suite bathroom w/ rotunda ceiling, Roman tub, walk-through shower, granite vanities, & windows galore. 3 oversized guest bedrooms share 2 full baths. This home\'s grandeur extends outside to many gathering areas and gorgeous landscaping.' ,`Acres` = '3.353' ,`Area` = '61' ,`BuilderName` = 'Quinn William Custom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Propane,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ESTATES AT RIVER RUN PH 2, BLOCK 4, LOT 16, ACRES 3.353' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '146056' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'RIVER BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates At River Run Ph 02' ,`TaxAmount` = '11962' ,`TaxRate` = '1.73437' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227332' WHERE `Matrix_Unique_ID` = '209735570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:40:59.923' ,`MLSNumber` = '33470674' ,`ListAgentFullName` = 'Gail Medina' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849295' ,`Longitude` = '-95.592839' ,`PhotoCount` = '18' ,`PostalCode` = '77041' ,`RoomCount` = '9' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Summerland Ridge' ,`StreetNumber` = '12210' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! NEVER flooded, not even during Harvey. Spacious 5 bedroom layout with beautiful pool in the back yard, custom removable pool-fence and a 3 car garage. Newly painted interior walls. Home comes with backyard patio furniture, kitchen refrigerator, washer, dryer and two mounted flat-screen TVs with their brackets. Professionally landscaped back and front yard. New tile back splash in the kitchen & brand new stainless steel appliances. Located in a gated community with lakes, swans and palm trees all through out. Primary en-suite bathroom with jetted garden tub, new tile and frameless glass shower. Second floor includes 2 full baths which includes fully tiled flooring, bathtub with sliding glass doors & Siltstone counters. LED lights throughout the home! Primary bedroom downstairs, all other bedrooms upstairs.' ,`Acres` = '0.218' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 LAKES ON ELDRIDGE SEC 19 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1690' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge' ,`TaxAmount` = '12020' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227332' WHERE `Matrix_Unique_ID` = '210243279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:03:42.740' ,`MLSNumber` = '29107363' ,`ListAgentFullName` = 'Jody Ricco' ,`ListOfficeName` = 'Ricco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.949753' ,`Longitude` = '-95.366548' ,`PhotoCount` = '23' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = '8th' ,`StreetNumber` = '1414' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '951' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This adorable home has been completely remodeled and is move-in ready. The updated kitchen has gorgeous white cabinets and granite counter tops. The large island offers additional storage and the extended granite counter is perfect for barstools. Subway tile backsplash has a clean and modern feel. Stainless appliances are new and haven\'t been used. The bathroom has gorgeous tile in the oversized shower. New vanity and sink. Tile floors in the kitchen and bath. The hardwood floors have been refinished and look amazing! The electrical and plumbing systems have been updated. Recent front and back doors, sheetrock and paint. Pendant lighting, recessed lighting throughout living and kitchen. Attached garage. Large front yard and alley in back yard for garage access. Extended driveway provides additional parking. Foundation repaired January 2022.' ,`Acres` = '0.1607' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FREEPORT, BLOCK 155, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeport' ,`TaxAmount` = '1872' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227333' WHERE `Matrix_Unique_ID` = '210418262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:31:10.643' ,`MLSNumber` = '66675303' ,`ListAgentFullName` = 'Chris DeLong' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'David Loughner' ,`SellingOfficeName` = 'RE/MAX Associates Northeast' ,`Latitude` = '30.164198' ,`Longitude` = '-95.203977' ,`PhotoCount` = '19' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '269900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Genova Bay' ,`StreetNumber` = '18809' ,`StreetSuffix` = 'Court' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Cul-de-sac home located in the sought after subdivision of Tavola. Home sits on a rare quarter acre lot with no rear neighbors. Very large open concept kitchen to family room, with 10\' cielings and plenty of room for entertaining and family time. Upgraded granite counter tops and stainless appliances. Primary room is very spacious with ensuite bathroom. Home is Alexa ready, has front & back sprinklers, and 2 French drains. Community features include: pool, park, clubhouse, and walkways. Easy access to elementary school and close to 59/69 & 99.' ,`Acres` = '0.2725' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S921120 - TAVOLA 20, BLOCK 1, LOT 12' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11868' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola 20' ,`TaxAmount` = '8966' ,`TaxRate` = '3.4331' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227333' WHERE `Matrix_Unique_ID` = '210977010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:36:55.307' ,`MLSNumber` = '76785392' ,`ListAgentFullName` = 'Melissa Perez-Mueller' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = 'Jennifer Green' ,`SellingOfficeName` = 'Encompass Real Estate Group' ,`Latitude` = '30.151511' ,`Longitude` = '-95.593770' ,`PhotoCount` = '49' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '419000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sanders' ,`StreetNumber` = '8726' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What you have been waiting for! Beautiful one story home located on 1.16 acres with a Casita, detached barn and a pool. This 4/5 bedroom, 3 bath retreat exudes luxury living with wood flooring laminate, ceramic tile, granite counter tops and grand cathedral ceiling in the living room. Primary bedroom is spacious with a bathroom oasis of stand up tile shower, sink and spacious walk in closet. Back yard features covered back patio to enjoy the outdoors overlooking the in ground pool, paved decked and detached barn space on its own septic and electricity with a bathroom. Never Flooded' ,`Acres` = '1.16' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0027 - MILLER JOSEPH, TRACT 29, 57-C, 57-D, ACRES 1.16' ,`LotDesciption` = 'Cleared' ,`LotSize` = '50530' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Abstract Area 9' ,`TaxAmount` = '4985' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227333' WHERE `Matrix_Unique_ID` = '211446932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:00:47.307' ,`MLSNumber` = '22751806' ,`ListAgentFullName` = 'Manu Dyse' ,`ListOfficeName` = 'Newhomeprograms.com LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.120733' ,`Longitude` = '-95.556559' ,`PhotoCount` = '32' ,`PostalCode` = '77375' ,`RoomCount` = '11' ,`ListPrice` = '398500.00' ,`Status` = 'Active' ,`StreetName` = 'Gilbough' ,`StreetNumber` = '24707' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Traditional Beauty! \r\nThe stunning home is ready to make your own! The property features all the space you need for entertainment. Vaulted ceilings and natural light are just a small part of this amazing home. The Detached garage and massive driveway are perfect for your toys and guests. Your gourmet kitchen comes equipped with loads of storage and an island perfect for gatherings. The offset game room upstairs allows for privacy and separation during those loud gamedays. Located in the Traditions Subdivision minutes away from the Grand Parkway, shopping, entertainment and more. Do not miss your chance to see this amazing home. Book your tour today!!' ,`Acres` = '0.2213' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 4 TRADITIONS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9639' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Traditions' ,`TaxAmount` = '7796' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227333' WHERE `Matrix_Unique_ID` = '212221433' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:57:11.760' ,`MLSNumber` = '86094302' ,`ListAgentFullName` = 'Luanne Marshall' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = 'Vicki Haislup' ,`SellingOfficeName` = 'Weichert,REALTORS-Murray Group' ,`Latitude` = '29.709856' ,`Longitude` = '-95.837645' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '750000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hutton Park' ,`StreetNumber` = '10119' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4330' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning Van Gogh model by Village Builders is a must see! The exquisite entry with grand stair case features 20ft soaring ceilings in both the foyer and living room. The expansive windows flood the living room with abundant natural light and provide spectacular views of the backyard pool and spa. The chef’s island kitchen is equipped w/granite counters, an expansive island w/bar seating, a breakfast nook w/glass enclosed cabinets, stainless appliances & is open to the breakfast & family room. The primary retreat includes an en-suite spa-like bath with dual vanities, a separate shower and oversized walk-in closet. Other features include an additional bedroom down w/en-suite bath, home office, an additional study nook, 3 bedrooms & 2 baths up, game room, media room, spacious utility room w/storage, a gas log fireplace, a salt water athletic pool w/spa and water features, an extended covered patio and a 3-car tandem garage.' ,`Acres` = '0.2229' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 47, BLOCK 1, LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SHAFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Southwest Sec 47' ,`TaxAmount` = '14486' ,`TaxRate` = '2.7695' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227333' WHERE `Matrix_Unique_ID` = '212233435' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:45:36.590' ,`MLSNumber` = '63570830' ,`ListAgentFullName` = 'Maria Acosta' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834905' ,`Longitude` = '-95.550173' ,`PhotoCount` = '44' ,`PostalCode` = '77041' ,`RoomCount` = '6' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'Terrace Manor' ,`StreetNumber` = '4427' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1239' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready patio home close to energy corridor. Home has new windows, new front door, new ceiling fans, new electrical panel, new pipes, many light fixtures replaced, freshly painted inside and out. Home is located close to \r\nI-10 and Beltway 8, in close proximity to HEB, City Center and all the shopping and entertaining offered in the I-10 corridor. Covered patio area with colorful landscaping. Subdivision has area pool. Nice find in great area.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT3 BLK7 COMMON AREA COURTYARD HOMES U/R WESTWAY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '47' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westway' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227334' WHERE `Matrix_Unique_ID` = '212281761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:13:05.440' ,`MLSNumber` = '56783893' ,`ListAgentFullName` = 'Angela Chaney' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049503' ,`Longitude` = '-95.385011' ,`PhotoCount` = '19' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '213500.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Pine' ,`StreetNumber` = '23303' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1354' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will fall in love with this charming home loaded with goodies and NO Back Neighbors! Have peace of mind knowing it\'s been updated with a New Roof in Oct 2018, New HVAC in 2020 and Hot Water Heater in 2019. You are sure to enjoy the recently added Kitchen Cabinets w/Lazy Susan and Granite Countertops. Home is light and bright with updated fixtures, paint and ceiling fans. Vinyl and Wood Floors throughout the entire home (No Carpet!) Relax and unwind on your front or back covered patios. Storage shed in back yard has plenty of room for a work shop. Fence is only a few years old as well. Come see this home today and you won\'t be disappointed.' ,`Acres` = '0.0895' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 47A BLK 2 CYPRESS TRAILS OF TIMBERLANE 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trails Timberlane 02' ,`TaxAmount` = '4183' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227334' WHERE `Matrix_Unique_ID` = '212439713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:43:27.160' ,`MLSNumber` = '58269698' ,`ListAgentFullName` = 'Desiree Harrod' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.253690' ,`Longitude` = '-95.518298' ,`PhotoCount` = '48' ,`PostalCode` = '77384' ,`RoomCount` = '5' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Wallowa Ridge' ,`StreetNumber` = '14208' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a newer home near The Woodlands this four-bedroom, three-full bath is situated in Fosters Ridge. A short walk to the park, pool, and neighborhood lodge. Upon entering the home you are welcomed into a formal entry, office/study, and hallway to two of the secondary bedrooms. Along your journey to the kitchen you will find a gorgeous wood accent wall located in the Living Area, with a freestanding mock fireplace(Negotiable). This kitchen does not lack storage for the chef in your family. Kitchen overlooks the living and dinning area making entertaining a breeze. Right off the Living Area is another secondary bedroom with an en-suite bath. The primary is located in the back of the home and has picturesque windows over looking your private back yard. Primary bath is equipped with double sinks, vanity, separate shower, soaking tub and oversized walk in primary closest. Zoned to the highly sought after Woodlands Schools. Schedule your private tour!' ,`Acres` = '0.194' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516406 - FOSTERS RIDGE 06, BLOCK 1, LOT 32, 50.000000% UDI' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge 06' ,`TaxAmount` = '4636' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667227334' WHERE `Matrix_Unique_ID` = '212708600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:58:30.543' ,`MLSNumber` = '71011222' ,`ListAgentFullName` = 'Luis Martinez' ,`ListOfficeName` = 'CA Modern Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.001079' ,`Longitude` = '-95.673216' ,`PhotoCount` = '38' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '304999.00' ,`Status` = 'Active' ,`StreetName` = 'Hyde' ,`StreetNumber` = '15414' ,`StreetSuffix` = 'Park' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great three bedroom two bath in a mature neighborhood ready to be called home. Spacious home in a good area not far from grocery stores and shopping. If you love a project or two this is the home for you with sturdy bones and mounds of potential. Home is being sold as is and won\'t last long !!!!!' ,`Acres` = '0.14' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 3 PARK CREEK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6100' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Creek' ,`TaxAmount` = '6260' ,`TaxRate` = '2.751' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227334' WHERE `Matrix_Unique_ID` = '212992053' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:31:15.400' ,`MLSNumber` = '57905545' ,`ListAgentFullName` = 'Jeanil Garcia' ,`ListOfficeName` = 'Central Metro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.172444' ,`Longitude` = '-96.394115' ,`PhotoCount` = '8' ,`PostalCode` = '77833' ,`RoomCount` = '3' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Ross' ,`StreetNumber` = '600' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully renovated 3 bedroom. 2 bath won’t last long in a nice and quiet neighborhood. This one story home has an open floor plan, new kitchen, new bathrooms, new floorings and BRAND NEW A/C unit and water heater. The roof is brand new, installed in 2022. The backyard is also very spacious and has the potential and space to make it your own oasis. Don’t miss out and schedule your showing today!' ,`Acres` = '0.1543' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WOODLAWN HEIGHTS , BLOCK C, LOT 1, (600 ROSS)' ,`LotDesciption` = 'Other' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlawn Heights' ,`TaxAmount` = '1283' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227334' WHERE `Matrix_Unique_ID` = '213012307' --> 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','213069850','1667227335','213069850','2022-10-31T06:59:55.530','52137430','Jaymes McKenzie','Offerpad Brokerage, LLC','','','29.642985','-95.249653','15','77075','2','99900.00','Active','Arledge','9327','Street','Houston','1','0','2','1036','Single-Family','Great location near I-45 South with No HOA. New roof 2022, AC unit about 3 years old, 1 car garage, with minor cosmetic updates needed for top value. Priced to sell \"as is\" and sell quickly.','0.1148','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Hobby Area','Central Gas','0','S 1/2 OF LT 4 BLK 26 EASTHAVEN','Subdivision Lot','5000','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Cooktop','','Composition','41 - Pasadena','JESSUP ELEMENTARY SCHOOL','SOUTH HOUSTON HIGH SCHOOL','SOUTHHOUSTON INTERMEDIATE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Easthaven','2737','2.6863','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:06:35.160' ,`MLSNumber` = '53664121' ,`ListAgentFullName` = 'Garie Muenchausen' ,`ListOfficeName` = 'Walter Jolley Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.139972' ,`Longitude` = '-95.403246' ,`PhotoCount` = '37' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsway Park' ,`StreetNumber` = '31006' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SELLER MOTIVATED!!!$10,000 PRICE REDUCTION!!! FRESH & READY FOR YOU!SPACIOUS 2 STORY W/MASTER DOWN, STUDY DOWN,GAMEROOM UP;FORMAL DINING ROOM,LARGE FAMILY ROOM W/FIREPLACE-SPACIOUS KITCHEN W/REFRIGERATOR, 42\" CABINETS & OPEN TO FAMILY ROOM WHICH BOASTS WALLS OF WINDOWS W/STREAMING LIGHT INTO THE HOME.THIS HOME IS LOCATED ON A CORNER LOT & THE YARD IS OVERSIZED & FULLY FENCED FEATURING A DECK FOR YOUR ENJOYMENT.JUST BRING YOUR TABLE, UMBRELLA & CHAIRS!!UPSTAIRS IS THE JACK & JILL BATH &, AN ADDITONAL BATH OFF ONE OF THE SECONDARY BEDROOMS. DON\'T OVER LOOK THE STUDY AREA IN THE GAMEROOM.SPACIOUS PARKING FOR YOUR CARS W/THIS 3 CAR DETATCHED GARAGE W/A SINGLE DRIVEWAY THAT OPENS TO A DOUBLE AREA FOR PARKING. A/C & HEAT REPLACED IN SUMMER, 2022. BE IN BEFORE THE HOLIDAYS TO ENJOY YOUR NEW HOME & NEIGHBORHOOD.' ,`Acres` = '0.2531' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS FOREST 01, BLOIMPERIAL OAKCK 3, LOT 6' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '11025' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Forest 01' ,`TaxAmount` = '8367' ,`TaxRate` = '2.7627' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227335' WHERE `Matrix_Unique_ID` = '213100167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:31:22.563' ,`MLSNumber` = '10428513' ,`ListAgentFullName` = 'Sara Hyder' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799408' ,`Longitude` = '-95.431161' ,`PhotoCount` = '21' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Tannehill' ,`StreetNumber` = '1719' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1729' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Three bedroom, one and a half bath home on a sizeable lot on a dead end street in Lazybrook. Walking distance to Sinclair Elementary and the restaurants and retail on 18th Street. Quick access to White Oak Bayou Trail. Schedule a showing today!' ,`Acres` = '0.1641' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 47 BLK 1 LAZYBROOK SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Lazybrook Sec 02' ,`TaxAmount` = '9176' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227335' WHERE `Matrix_Unique_ID` = '213176305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:49:32.097' ,`MLSNumber` = '51230283' ,`ListAgentFullName` = 'Ana Moreno' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = 'Monica Foster' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.790709' ,`Longitude` = '-95.171605' ,`PhotoCount` = '27' ,`PostalCode` = '77015' ,`RoomCount` = '4' ,`ListPrice` = '210000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Woodforest' ,`StreetNumber` = '14143' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1794' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'welcome to this charm this home is a great area and waiting for you to call it home!! With easy access to beltway- 8 and I-10 east freeway. This home features a wonderful open floor plan with 4-bethrooms 2- baths 2 car garage, freshly painted throughout. This property has never flooded. \r\nSOLD AS IS.' ,`Acres` = '0.1993' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 & TR 7 BLK 40 WOODFOREST SEC 6' ,`LotDesciption` = 'Other' ,`LotSize` = '8683' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORTH SHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wood Forest Sec 06' ,`TaxAmount` = '4293' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227335' WHERE `Matrix_Unique_ID` = '213237402' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:07:20.467' ,`MLSNumber` = '44738838' ,`ListAgentFullName` = 'Brenda Duane' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = 'Kashif Gaddi' ,`SellingOfficeName` = 'Texas Ally Real Estate Group,' ,`Latitude` = '29.606240' ,`Longitude` = '-95.622447' ,`PhotoCount` = '39' ,`PostalCode` = '77478' ,`RoomCount` = '9' ,`ListPrice` = '849500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'King' ,`StreetNumber` = '1202' ,`StreetSuffix` = 'Street' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Premier, waterfront location in the gated community of Lake Pointe Commons in the heart of Sugar Land. This freestanding 3-story home features open living spaces on the 1st floor, 4 bedrooms and 3.5 bathrooms with a game room. The open floorplan is perfect for entertaining family and friends. The kitchen boasts stainless steel appliances, double ovens, custom cabinets, under-counter lighting, an oversized wine refrigerator, a cappuccino machine, and a 5-burner gas stove with a pot filler. In the family room, you will find built-in bookcases on both sides of the gas fireplace, an 11-foot coffered ceiling, and beautiful wood floors. LED lighting and upgraded ceiling fans throughout. Electric window shades (light and darkening) with remotes. There is a large game room on the third floor with a wet bar, beverage fridge and ice maker. Brick patio with outstanding sunset views across the lake. Community pool and is within walking distance to restaurants and shopping.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = 'Pelican Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE POINTE URBAN HOMES, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '2241' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3212' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Pointe Urban Homes' ,`TaxAmount` = '16542' ,`TaxRate` = '2.3084' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667227335' WHERE `Matrix_Unique_ID` = '213245164' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:20:16.327' ,`MLSNumber` = '71121026' ,`ListAgentFullName` = 'Garrett Mohnke' ,`ListOfficeName` = 'Complete Property Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733013' ,`Longitude` = '-95.468460' ,`PhotoCount` = '25' ,`PostalCode` = '77056' ,`RoomCount` = '5' ,`ListPrice` = '855000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairdale' ,`StreetNumber` = '5302' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3610' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 or 4 bed, 3.5 bath home on a cul-de-sac lot with 24/7 patrolled security for the neighborhood. Minutes to all Galleria area shopping and dining as well as quick access to 59 and 610. Natural light fills this open floorplan with high ceilings, hardwood floors and ample storage throughout. Lush carpet up stairs, granite counters and stainless appliances in the kitchen round out some of added details to the property. Large primary suite with sitting area and spacious walk in closet. Ideal home for entertaining friend and family.' ,`Acres` = '0.1029' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 18A BLK 6 & .50 U/D INT IN TR 18B (COMMON AREA) LAMAR TER' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4482' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lamar Terrace' ,`TaxAmount` = '15205' ,`TaxRate` = '2.4457' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227336' WHERE `Matrix_Unique_ID` = '213328853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:34:05.083' ,`MLSNumber` = '12721869' ,`ListAgentFullName` = 'Kevin Johnson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146497' ,`Longitude` = '-95.213386' ,`PhotoCount` = '36' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Lodge' ,`StreetNumber` = '20747' ,`StreetSuffix` = 'Road' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2438' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own just over 3 acres to do what you want! Home needs some work, but this could be an incredible estate. Or, convert the home to an office and run your business. Very minor restrictions mean you can be as creative as you want. Property has the home, attached carport, RV carport, shop, storage building, and former smokehouse.' ,`Acres` = '3.1' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINE ACS-NEW CANEY 01, LOT 2, ACRES 3.100' ,`LotDesciption` = 'Wooded' ,`LotSize` = '135036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'OAKLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Acs-New Caney' ,`TaxAmount` = '3166' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227336' WHERE `Matrix_Unique_ID` = '213353863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:21:20.123' ,`MLSNumber` = '42158285' ,`ListAgentFullName` = 'Bryan Wood' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.826971' ,`Longitude` = '-95.108642' ,`PhotoCount` = '31' ,`PostalCode` = '77360' ,`RoomCount` = '9' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Long' ,`StreetNumber` = '166' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful new build home in Onalaska TX with low maintenance in mind. Although it has a decent size back yard the over yard size is smaller with less to mow. Cement board siding, tile floors throughout this home. Quartz countertops in the kitchen and bathrooms. For lower utility costs the home\'s environmental footprint was kept small. Yet everything you need is in this home. Open concept living-dining-kitchen. Good size primary bedroom with ensuite bath and walk in closet. Well appointed bathrooms. Kitchen features stainless steel appliances and quartz countertops. In-House Laundry. Nest thermostat. Well crafted painted cabinets. Home features a ultraviolet light on the AC return to kill unwanted germs in the air. 50 amp outside plug for a generator into the home. Garage Door has frosted windows to let in light into your finished garage. Yard will be full fenced with a privacy fence. Less than 5 minutes from all the Onalaska Schools.' ,`Acres` = '0.115' ,`Area` = '44' ,`BuilderName` = 'Hird Zavala Develop.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ONALASKA WOODS Replat Lot 45 A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Onalaska Woods' ,`TaxAmount` = '356' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667227336' WHERE `Matrix_Unique_ID` = '213402853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:23:27.700' ,`MLSNumber` = '11439750' ,`ListAgentFullName` = 'Bryan Wood' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.826995' ,`Longitude` = '-95.108559' ,`PhotoCount` = '29' ,`PostalCode` = '77360' ,`RoomCount` = '9' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Long' ,`StreetNumber` = '162' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful new build home in Onalaska TX with low maintenance in mind. Although it has a decent size back yard the over yard size is smaller with less to mow. Cement board siding, tile floors throughout this home. Quartz countertops in the kitchen and bathrooms. For lower utility costs the home\'s environmental footprint was kept small. Yet everything you need is in this home. Open concept living-dining-kitchen. Good size primary bedroom with ensuite bath and walk in closet. Well appointed bathrooms. Kitchen features stainless steel appliances and quartz countertops. In house Laundry. Nest Thermostat. Well crafted painted cabinets. Home features a ultraviolet light on the AC return for germ control. 50 amp generator Plug to home. Garage Door has frosted windows to let in light into your finished garage. Yard will be full fenced with a privacy fence. Less than 5 minutes from all the Onalaska Schools.' ,`Acres` = '0.115' ,`Area` = '44' ,`BuilderName` = 'Hird Zavala Develop.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ONALASKA WOODS Replat Lot 46 A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Onalaska Woods' ,`TaxAmount` = '356' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667227336' WHERE `Matrix_Unique_ID` = '213404589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:46:28.553' ,`MLSNumber` = '42514333' ,`ListAgentFullName` = 'Vicki Emerson' ,`ListOfficeName` = 'Hunter Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801084' ,`Longitude` = '-95.377123' ,`PhotoCount` = '27' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Tabor' ,`StreetNumber` = '1102' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully Updated 2 B/R 1 Bath Heights Bungalow on 5000 Sq. Ft. CORNER LOT Nestled among Trees. 1 Car Garage. Current owner is only the SECOND HOMEOWNER of the property and has lived in home since 1998. Property has been updated throughout including HVAC system, Tankless Water Heater, Replumbed Pipes, Rewired Electrical & Refinished Original Hard Wood floors. 2011 Roof, A/C installed & Sewer replaced in 2018. INSULATION in Attic & B/R Walls. Corian Countertops, Tile Backsplash, Soft Close Cabinets with Pull Out Drawers, Gas Stove & Double Porcelain Sink in Kitchen. Double Pane Low E Casement /Transom Windows in Bedrooms. Mirrored Closets with Built In Wardrobes in Secondary Bedroom. Ceiling Fans throughout. The property has NEVER flooded. Located 1 Block from Montie Beach Park. Easy Access to 45, 610, Rail, Downtown & Farmers Market on Airline. *All Information per Seller*' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 101 BROOKE SMITH' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`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` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Brooke Smith' ,`TaxAmount` = '6336' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227336' WHERE `Matrix_Unique_ID` = '213495107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:39:33.640' ,`MLSNumber` = '58611847' ,`ListAgentFullName` = 'Christina Conn' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Michelle Ngo' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.768104' ,`Longitude` = '-95.768557' ,`PhotoCount` = '42' ,`PostalCode` = '77450' ,`RoomCount` = '7' ,`ListPrice` = '300000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cascade Creek' ,`StreetNumber` = '1111' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2033' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS ONLY. BEING SOLD WITH ONE YEAR LEASE IN PLACE. Fabulous affordable 4 bedroom/ 2.5 bath rental in popular Cimarron subdivision in South Katy! Detached oversized garage and huge back yard with extended patio. Covered porch entryway and mature landscaping. \r\nNicely updated. Fresh paint and recent flooring. No carpet. Roomy primary suite with huge closet and 3 spacious guest rooms. Upgraded kitchen. Huge family room with fireplace. Formal dining room and breakfast nook. \r\nThis home has it all and a short walk to the award winning Cimarron Elementary. Highly ranked KISD. Community pool and tennis court. No flooding. \r\nClose to shopping and retail. Easy access to 1-10, 99 and 1093.' ,`Acres` = '0.169' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 40 CIMARRON SEC 9 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Cimarron Sec 09 Pt Rep' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227337' WHERE `Matrix_Unique_ID` = '213528576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:23:41.637' ,`MLSNumber` = '93707184' ,`ListAgentFullName` = 'Dwight Vincent' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.555545' ,`Longitude` = '-95.622903' ,`PhotoCount` = '9' ,`PostalCode` = '77340' ,`RoomCount` = '7' ,`ListPrice` = '324999.00' ,`Status` = 'Active' ,`StreetName` = 'Firewood' ,`StreetNumber` = '23' ,`StreetSuffix` = 'Road' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1934' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO WILDWOOD SHORES, THIS LAKEFRONT NEIGHBORHOOD IS A HIDDEN GEM ON THE NORTH SIDE OF LAKE CONROE- BRAND NEW CUSTOM HOME WITH 3 BEDS + A LARGE STYDY OR 4TH BEDROOM- AWESOME / OPEN FLOORPLAN- HUGE MASTER SUITE WITH DOUBLE SHOWER & VERY LARGE CLOSET-COVERED BACK PORCH- TONS OF CURB APPEAL- AND SO MUCH MORE- COME SEE EVERYTHING WE HAVE TO OFFER........flexible seller for the right buyer, contact your realtor or myself directly for additional information..... 3-2-1 BUYDOWN AVAILABLE' ,`Acres` = '0.1475' ,`Area` = '43' ,`BuilderName` = 'M TAYLOR HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WILDWOOD SHORES (SEC 12), BLOCK 1, LOT 52' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6426' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Wildwood Shores Sec 12' ,`TaxAmount` = '210' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667227337' WHERE `Matrix_Unique_ID` = '213551614' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:22:35.727' ,`MLSNumber` = '34677551' ,`ListAgentFullName` = 'Dwight Vincent' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.558176' ,`Longitude` = '-95.621135' ,`PhotoCount` = '9' ,`PostalCode` = '77340' ,`RoomCount` = '7' ,`ListPrice` = '324999.00' ,`Status` = 'Active' ,`StreetName` = 'Alta' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Vista' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO WILDWOOD SHORES, THIS GATED / LAKEFRONT NEIGHBORHOOD IS A HIDDEN GEM ON THE NORTH SIDE OF LAKE CONROE- THIS BRAND NEW CUSTOM HOME SITS ON A HUGE CORNER LOT IN A CULDSAC STREET- 3 BEDS + A LARGE STYDY OR 4TH BEDROOM- OPEN FLOORPLAN- COVERED BACK PORCH- TONS OF CURB APPEAL- AND SO MUCH MORE- COME SEE EVERYTHING WE HAVE TO OFFER..... flexible seller for the right buyer, contact your realtor or myself directly for additional information...... 3-2-1 BUYDOWN AVAILABLE' ,`Acres` = '0.2436' ,`Area` = '43' ,`BuilderName` = 'M TAYLOR HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WILDWOOD SHORES (SEC 2), BLOCK 1, LOT 1' ,`LotDesciption` = 'Cleared,Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10612' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Wildwood Shores Sec 2' ,`TaxAmount` = '351' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667227337' WHERE `Matrix_Unique_ID` = '213552042' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:13:56.267' ,`MLSNumber` = '33811486' ,`ListAgentFullName` = 'Anthony Meza' ,`ListOfficeName` = 'Cy-Fair Real Estate' ,`SellingAgentFullName` = 'Claire Warren' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.984016' ,`Longitude` = '-95.697513' ,`PhotoCount` = '27' ,`PostalCode` = '77429' ,`RoomCount` = '6' ,`ListPrice` = '318000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Windwood Park' ,`StreetNumber` = '14646' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1916' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this immaculately kept home in a corner lot of Cypress Mill Park. The home features a front covered porch with a new side fence recently installed. As you walk into the home, you will be greeted with new flooring throughout the home as well as paint. The home follows a split floorplan from the owner\'s bedroom to the secondary rooms and office space. Spacious open-concept kitchen and dining room combo with cabinets reaching the ceiling open to the large vaulted ceiling living room. The home has double-paned windows for efficiency, Pex piping, A/C coils replaced 3 years ago, a replaced roof 5 years ago, and you can feel the pride in homeownership as you walk through this very well-kept home. The community itself includes access to two pools, parks, walking trails, tennis courts, and a clubhouse exclusively for residents of the community. This home is zoned out to some of the best schools in the very recognized Cy-Fair ISD. With so many great features it is a must-see!' ,`Acres` = '0.1308' ,`Area` = '35' ,`BuilderName` = 'Ryland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 8 CYPRESS MILL PARK SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '5697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'A ROBISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Mill Park Sec 02' ,`TaxAmount` = '6111' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227337' WHERE `Matrix_Unique_ID` = '213603593' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:13:45.613' ,`MLSNumber` = '19455858' ,`ListAgentFullName` = 'Lorna Ramsay' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019800' ,`Longitude` = '-95.537167' ,`PhotoCount` = '46' ,`PostalCode` = '77379' ,`RoomCount` = '15' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'Vintage Creek' ,`StreetNumber` = '7923' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4213' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 7923 Vintage Creek Dr, wonderful 5 bed red brick home, 3/1 bath, 2 car attached garage with easy side access, on a huge lot with great curb appeal exceptional features inc large rooms, plantation shutters, hand scrapped Laminate Wood flooring, recently painted bedrooms, fabulous home for entertaining with large formal Dining Rooom & Living, designer tiles, 2 story den views overlooking the salt water pool. Large beautiful kitchen, features island cooking, granite counter tops. Study / Nursery with doors - ideal for working from home, large Primary Suite bedroom on 1st floor with access to huge back yard with salt water pool & outdoor retreat. Primary bath with corner jetted tub & separate shower. Upstairs to 4 spacious bedrooms, game room, solar shades, radiant barrier, tank less hot water heater. Recent Vivint Home Security, new Chandalier in Reception & Dining incl in the sale. Ride on mower is availble for sale. Zoned to Popular Klein ISD & awesome neighborhood amenities.' ,`Acres` = '0.4394' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 MEMORIAL NORTHWEST SEC 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19139' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '630' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest 21' ,`TaxAmount` = '9540' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227337' WHERE `Matrix_Unique_ID` = '213607099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:34:57.420' ,`MLSNumber` = '10251592' ,`ListAgentFullName` = 'Carmen Rodriguez' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.287705' ,`Longitude` = '-94.818079' ,`PhotoCount` = '14' ,`PostalCode` = '77551' ,`RoomCount` = '6' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue N 1/2' ,`StreetNumber` = '4706' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fixer upper with great potential in a popular area in Galveston, being sold as-is, featuring 2 bedrooms, 1-bathroom, original wood floor. Spacious fence backyard with a detached garage in the back. Five minutes from the Seawall and a short distance to other Galveston attractions. Call me for a private tour!' ,`Acres` = '0.118' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 15 & W 7-2 FT OF LOT 14 & E 10-8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`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` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Resurvey' ,`TaxAmount` = '2862' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1667227338' WHERE `Matrix_Unique_ID` = '213607978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:49:02.460' ,`MLSNumber` = '27263106' ,`ListAgentFullName` = 'Razelle Smith' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225024' ,`Longitude` = '-95.452515' ,`PhotoCount` = '41' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Misty Dawn' ,`StreetNumber` = '190' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Inviting front porch elevation welcomes you to this cozy 4 bedroom home in The Woodlands. Floor plan features a private study, game room, & large master suite. Island kitchen is updated cabinets, granite, & tumbled marble backsplash. Don\'t miss the bonus storage area. Fully fenced, large backyard w no rear neighbors. Great Woodlands schools. Easy access for commuters. Nearby shopping, parks, and entertainment options.' ,`Acres` = '0.1632' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS HARPER\'S LND COLLEGE PK 05, BLOCK 2, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7109' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Harpers Lnd College Park' ,`TaxAmount` = '5422' ,`TaxRate` = '2.2719' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227338' WHERE `Matrix_Unique_ID` = '213683826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:49:42.727' ,`MLSNumber` = '85215615' ,`ListAgentFullName` = 'Jade Mack' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404114' ,`Longitude` = '-95.631580' ,`PhotoCount` = '48' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '294000.00' ,`Status` = 'Active' ,`StreetName` = 'Breckenridge' ,`StreetNumber` = '3813' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come experience this house in the highly sought after beautiful Walden on Lake Conroe community. This exclusive gem has 4 bedrooms, 3 full baths and 3 car garage! Features include an open floor plan with the family room open to the dining and kitchen area, also offering lots of natural lighting. Recent updates are present with freshly painted interior walls and new flooring throughout the home. Tour and see the potential this house has to be your new home today!' ,`Acres` = '0.1559' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 17, BLOCK 75, LOT 195' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '996' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden' ,`TaxAmount` = '5246' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227338' WHERE `Matrix_Unique_ID` = '213695847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:33:38.637' ,`MLSNumber` = '52029978' ,`ListAgentFullName` = 'Hugo Alfaro' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022349' ,`Longitude` = '-95.309088' ,`PhotoCount` = '13' ,`PostalCode` = '77338' ,`RoomCount` = '3' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Rezanof' ,`StreetNumber` = '21239' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story 3/2/2 home, ready for a new family to enjoy! Neutral colors throughout, lovely updated kitchen. Owner has taken great care of this home. Open concept plan with Kitchen overlooking the Living Room. Come Relax on the backyard featuring a large 12X15 covered patio with fans. Great location, enjoy all the shopping and dining selections in Humble, and only 5 mins away from the airport. Home is price to sell fast, place an offer today!! Home never flooded, per owner.' ,`Acres` = '0.1125' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 KENSWICK MEADOWS AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4902' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Meadows Amd' ,`TaxAmount` = '4105' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227338' WHERE `Matrix_Unique_ID` = '213735404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:39:37.493' ,`MLSNumber` = '31741828' ,`ListAgentFullName` = 'Maribel Granados' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747303' ,`Longitude` = '-95.747033' ,`PhotoCount` = '19' ,`PostalCode` = '77450' ,`RoomCount` = '10' ,`ListPrice` = '382000.00' ,`Status` = 'Active' ,`StreetName` = 'Wittman' ,`StreetNumber` = '21615' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3089' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the beautifully kept 4 bedroom, 2 and 1/2 bath home that features a unique entrance to the office/study, with a spacious dining room. Kitchen boast new wood look vinyl plank flooring, new dishwasher, and new gas oven. Tall ceilings in living room with a cozy fireplace. Elegant wood floor staircase leads up to a spacious gameroom for plenty of fun activities for the family. Primary bedroom and bathroom display beautiful stained glass windows. NO CARPET! Big backyard with garden area ready for your touch. Great community amenities including community pool, splash pad for the little ones, and 2 tennis courts. And last but not certainly not least the home is zoned to highly sought after Katy ISD.' ,`Acres` = '0.1873' ,`Area` = '36' ,`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` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 OAK PARK TRAILS SEC 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`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` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Park Trails Sec 02' ,`TaxAmount` = '6680' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227339' WHERE `Matrix_Unique_ID` = '213766245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:51:00.563' ,`MLSNumber` = '93176436' ,`ListAgentFullName` = 'Razelle Smith' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.180820' ,`Longitude` = '-95.521803' ,`PhotoCount` = '50' ,`PostalCode` = '77381' ,`RoomCount` = '9' ,`ListPrice` = '502000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden View' ,`StreetNumber` = '37' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prime Location!!! in Cochrans Crossing is ready for your family with 4 bedrooms, 2 1/2 baths, and a 3-car oversized garage. Large lot big enough for a pool!! It has a covered front porch and a HUGE backyard with a fire pit. Large bedrooms Huge Primary and bath, predominately Tile/wood flooring. Gorgeous renovated kitchen with tall cabinets & Premium Acacia wood countertops (2022).Renovated Primary Bath (2021)Huge walk in shower/dressing area/tall counter tops One owner home, middle of The Woodlands. The community features parks, lakes, and playgrounds. A pond is just across the street, a short walk to fishing and canoeing. Welcome home!' ,`Acres` = '0.2504' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL COCHRANS CR 17, BLOCK 1, LOT 41' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10907' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 17' ,`TaxAmount` = '5455' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227339' WHERE `Matrix_Unique_ID` = '213771944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:36:05.650' ,`MLSNumber` = '82837145' ,`ListAgentFullName` = 'Dakota Fetterly' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Jessica Githens' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '30.273930' ,`Longitude` = '-95.447030' ,`PhotoCount` = '29' ,`PostalCode` = '77301' ,`RoomCount` = '7' ,`ListPrice` = '259900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Borthwick' ,`StreetNumber` = '2030' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1599' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and meticulously-maintained one story home with no back neighbors! Located in the desirable neighborhood of Stewarts Forest, with convenient access to I45, Grand Central Marketplace, The Woodlands, Lake Conroe and more! Walk through the front door and feel right at home with the open layout, which is perfect for entertaining. The spacious living room has luxury vinyl plank flooring, high ceilings, and looks out to the huge, private backyard with a stunning view of the forest! The kitchen features granite countertops, SS appliances, and is open to the living room. The dining area is located off the kitchen and has a great view of the backyard. A split floor plan, the primary bedroom is tucked away, creating a private suite oasis. The primary bedroom has double sinks, a separate shower, large soaking tub, and a large walk-in closet! Down the hallway are the two secondary bedrooms and the second full bathroom. Don\'t miss out on this adorable home-- schedule your showing today!' ,`Acres` = '0.1846' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S902405 - STEWARTS FOREST 05, BLOCK 4, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stewarts Forest 05' ,`TaxAmount` = '6060' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227339' WHERE `Matrix_Unique_ID` = '213812004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:31:39.660' ,`MLSNumber` = '21526461' ,`ListAgentFullName` = 'Suzanne Mason' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.328753' ,`Longitude` = '-95.400987' ,`PhotoCount` = '31' ,`PostalCode` = '77303' ,`RoomCount` = '19' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Pat George' ,`StreetNumber` = '11376' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Conroe' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PROFESSIONAL PHOTOS 10/27/22. Welcome to this fabulous 3 home compound located on 3/4 acre in Conroe, Texas! Upon entering the gated property you will be greeted with the recently updated main Rancher (3/2) and looking to the right of that will be a 1/1 guest quarters with large (17 x 17) storage room attached. Moving to the backyard you rest your eyes on the newer 3/2 Barndominium with sweeping porches! All with very nice finishes. \r\nThe yard is large and hosts several outdoor seating areas for all to enjoy! Another large outdoor storage shed is included to boot! This is a very unique property located within Conroe ISD and close to all amenities Conroe and surrounding has to offer. If you have a need for this sort of property, you must see this beauty, I promise the homes and grounds will not disappoint! See Exclusion list in MLS attachments.' ,`Acres` = '0.75' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CRYSTAL CREEK FOREST, LOT 68, ACRES 0.750' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '32670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crystal Creek Forest' ,`TaxAmount` = '4040' ,`TaxRate` = '1.7488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227339' WHERE `Matrix_Unique_ID` = '214005016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:54:18.703' ,`MLSNumber` = '61449205' ,`ListAgentFullName` = 'Jonathan Sexton' ,`ListOfficeName` = 'Sprout Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.557336' ,`Longitude` = '-95.303235' ,`PhotoCount` = '24' ,`PostalCode` = '77584' ,`RoomCount` = '6' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Carmona' ,`StreetNumber` = '5406' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom/2 bath, single level home with lovely open floor plan nestled in a much sought after location, just down the street from Centennial Park! This classic home interior has been beautifully upgraded and transformed into the an industrial farmhouse style, boasting with warmth and charm. Beautiful new wood floors and carpet throughout along with new recessed lighting and special light fixtures. Thoughtfully designed gourmet kitchen with stainless appliances, farmhouse sink, stunning granite countertops and drop down lighting. Huge enclosed sunroom flows off the living room and out into the oversized and open backyard with 2 stand alone sheds.' ,`Acres` = '0.2041' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CORRIGAN (PEARLAND), BLOCK 2, LOT 17' ,`LotDesciption` = 'Other' ,`LotSize` = '8891' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'H C CARLESTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Corrigan Pearland' ,`TaxAmount` = '6775' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227339' WHERE `Matrix_Unique_ID` = '214048253' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:40:12.317' ,`MLSNumber` = '87358597' ,`ListAgentFullName` = 'Tracey Sheldon' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.258499' ,`Longitude` = '-95.450424' ,`PhotoCount` = '38' ,`PostalCode` = '77302' ,`RoomCount` = '10' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Florida' ,`StreetNumber` = '586' ,`StreetSuffix` = 'Park' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! NOT LOCATED IN A FlOOD ZONE! Desirable location in a well-established golf course community, conveniently located minutes from N 45, shopping, and restaurants. Large mature trees surround this amazing home. Only 2 owners, the first owner was the builder! Excellent floorplan with 3 bedrooms, 3 full baths, a large bonus room, family room, large dining room, and a beautiful study. Very solid home with 24\" centers which is rare and a testament to the structural integrity. Lots of closet space and very spacious rooms. You will love the enclosed sunroom that leads out to a fabulous backyard. This home comes with a whole house Generac generator to weather any storm you may face. This home has NEVER flooded! Excellent home for entertaining! Schedule a showing today!' ,`Acres` = '0.3874' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER PLANTATION 01, LOT 40-B, 41' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '16875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'River Plantation 01' ,`TaxAmount` = '5333' ,`TaxRate` = '2.1648' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227340' WHERE `Matrix_Unique_ID` = '214049098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T06:57:41.247' ,`MLSNumber` = '82859416' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.198393' ,`Longitude` = '-94.946340' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '1400000.00' ,`Status` = 'Active' ,`StreetName` = 'Turks' ,`StreetNumber` = '4202' ,`StreetSuffix` = 'Point' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2742' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on a corner lot, in the FIRST block of prestigious Pirates Beach West. Enjoy amazing GULF views from multiple decks as well as every room in the home. The home consists of an open floor plan with vaulted ceilings and a wall of windows and doors. The kitchen features granite counter tops, breakfast bar, wet bar with mini fridge, & new dishwasher & refrigerator (Sept. 2022). A guest bedroom & bath, utility room & 1/2 bath are also found on the 1st floor. The 2nd floor invites you to a luxurious primary suite featuring a sitting/office/workout area, access to a deck, and large bathroom with double sink basins. 2 guest bedrooms with built-in dressers & desks and a guest bath can also be found upstairs. The Elevator travels to all levels, the exterior stairs and all but 1 deck are covered in composite decking. The home also boasts a mosquito system. The furniture is included with few exclusions.' ,`Acres` = '0.2388' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 20 BLK 1 PIRATES BEACH SEC 10' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Beach West' ,`TaxAmount` = '34386' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227340' WHERE `Matrix_Unique_ID` = '214063408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:46:00.070' ,`MLSNumber` = '20229919' ,`ListAgentFullName` = 'Yolanda Williams' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.631862' ,`Longitude` = '-95.535175' ,`PhotoCount` = '45' ,`PostalCode` = '77489' ,`RoomCount` = '7' ,`ListPrice` = '348500.00' ,`Status` = 'Active' ,`StreetName` = 'Leslie' ,`StreetNumber` = '16215' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE!! Newly fully remolded beautiful (2019) 4 bedroom 2.5 bath home with a gorgeous POOL! Located in the cul-de-sac of the established community of COLONY CROSSING VILLAGE. \r\n\r\nThe home features: \r\n \r\n-Large open family space w/ fireplace, large windows and natural light\r\n-Prefect size kitchen with an island and breakfast area that overlook the pool and large backyard \r\n- Office space\r\n- Large dining area for family dinners and holiday gatherings\r\n- Game room \r\n- Overly sized primary bedroom and full bathroom\r\n- Generous sized secondary bedrooms\r\n- Outdoor in-ground pool with great backyard space for entertaining and grilling\r\n\r\n\r\nThis beauty won\'t last long! Come see it for yourself at our Open House | Saturday | 10/29/2022 | 12-2pm' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY CROSSING VILLAGE OF TALBOTS MILL SEC 2, BLOCK 1, LOT' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '595' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'E A JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Colony Crossing Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227340' WHERE `Matrix_Unique_ID` = '214101314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:59:50.823' ,`MLSNumber` = '43530715' ,`ListAgentFullName` = 'Phyllis Fudge' ,`ListOfficeName` = 'Creekside Realty' ,`SellingAgentFullName` = 'Rebecca Drake' ,`SellingOfficeName` = 'RE/MAX The Woodlands & Spring' ,`Latitude` = '30.157918' ,`Longitude` = '-95.405388' ,`PhotoCount` = '43' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '370000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hidden Hollow' ,`StreetNumber` = '2727' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very well maintained 4 Bedroom 2 Bath home with lots of upgrades. Home has open concept that includes the kitchen, Breakfast Room and the Living Room. Island Kitchen with gas appliances, a water filter system under the kitchen cabinet and Living room has Premium 5.1 Sound System. Very generous sized Primary Bedroom and Primary Bath that has a separate tub and shower. Wood Tile Flooring in the foyer, halls, living room, 2nd bathroom and Kitchen. Outside has a well maintained yard with a patio. Garage has an Electric Vehicle Charger Plug with its own 240V Outlet. Home is close to Shopping, Hospitals and the 99 and Hardy Toll Roads for easy access.' ,`Acres` = '0.1367' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S716705 - MEADOWS AT IMPERIAL OAKS 05, BLOCK 3, LOT 8' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5955' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadows At Imperial Oaks 05' ,`TaxAmount` = '9135' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227340' WHERE `Matrix_Unique_ID` = '214102402' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:53:44.477' ,`MLSNumber` = '48196992' ,`ListAgentFullName` = 'Katherine Clark' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975711' ,`Longitude` = '-95.665225' ,`PhotoCount` = '37' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Halpren Falls' ,`StreetNumber` = '16226' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story home in sought after Coles Crossing neighborhood. Hardwood flooring, granite countertops and stainless steel appliances. Backyard oasis with inground pool & hot tub that opens up to the greenspace with running trail. Recently upgraded primary bath with LED vanity mirror, marble countertops with undermount sinks and new hardware. Study/desk perfect for working from home. Game room upstairs. Secondary bath upgrades include granite counter tops and undermount sinks with new hardware. Roof and AC approximately a year old. Neighborhood has excellent family amenities including 2 pools, tennis courts, running trails, and community center. Sampson Elementary from highly acclaimed Cypress Fairbanks ISD located within walking distance.' ,`Acres` = '0.167' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 COLES CROSSING SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7275' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SAMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coles Crossing Sec 05' ,`TaxAmount` = '8729' ,`TaxRate` = '2.541' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227340' WHERE `Matrix_Unique_ID` = '214140539' --> 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','214161761','1667227341','214161761','2022-10-31T07:22:23.010','70347865','Melinda Diamond','RE/MAX Compass','','','29.920596','-95.698601','26','77433','8','489000.00','Active','Highlands Bayou','19019','Drive','Cypress','3','0','3','2812','Single-Family','Welcome To This All Brick Home W/Inviting Front Porch. 1 Story, 3 Bedroom, 3 Bath + Study In The ACTIVE ADULT 55+ Community Of The Heritage At Towne Lake. No Carpet In All Living/Bedrooms/Bathrooms. Beautiful Entry Is Defined By A Round Tray Ceiling & Stunning Light Fixture. Walk In And Be Amazed With All The Upgrades. Open Floor Plan. Formal Dining. Chef\'s Kitchen Features; Espresso Cabinets, Granite Countertops, Large Island, Gas Cooktop & Stainless Steel Appliance Package. Large Breakfast Bar Open To Spacious Living Room. Gorgeous Mantel W/Gas Log Fireplace. 2\" Faux Blinds. Primary Bathroom Features: 2 Vanities, Whirlpool Garden Soaking Bathtub + Separate Shower W/Bench. Don\'t Miss Interior Door With Staircase Leading To Attic In Home For Amble Storage. 2 Gas Water Heaters. Covered Backyard Patio. Sprinkler System. Towne Lake Offers A 300 Acre Lake For Boats, Waterfront Dining/Shopping. State Of Art Fitness Center & Olympic Style Pool W/Lazy River & Water Slides. A Must See!','0.1698','25','Westin Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Cypress South','Central Gas','1','LT 15 BLK 1 TOWNE LAKE SEC 5','Cul-De-Sac','7397','Appraisal District','','240','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','RENNELL ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Towne Lake Sec 5','11841','3.091','Water District','2013','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:56:02.090' ,`MLSNumber` = '37857302' ,`ListAgentFullName` = 'Carla Smith' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.410413' ,`Longitude` = '-95.037240' ,`PhotoCount` = '36' ,`PostalCode` = '77591' ,`RoomCount` = '6' ,`ListPrice` = '307000.00' ,`Status` = 'Active' ,`StreetName` = '32nd' ,`StreetNumber` = '11425' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You must see this charming 4 bedroom, 2.5 bath move in ready home. It features an open concept plan. The living area is open to the dining area. The kitchen has a large walk-in pantry. Has an oversized backyard ready for you family cookouts. Come check out this move in ready home! Call to schedule your appointment!' ,`Acres` = '0.165' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 208 PAGE 5 LOT 3 BLK 3 PARK PLACE SOUTH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7188' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Place South 94' ,`TaxAmount` = '6139' ,`TaxRate` = '2.5428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667227341' WHERE `Matrix_Unique_ID` = '214210759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T07:53:23.527' ,`MLSNumber` = '62307217' ,`ListAgentFullName` = 'Erwin Nicholas' ,`ListOfficeName` = 'Mr. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.641883' ,`Longitude` = '-95.377403' ,`PhotoCount` = '15' ,`PostalCode` = '77051' ,`RoomCount` = '3' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunnydale' ,`StreetNumber` = '3126' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unfinished Remodel opportunity.' ,`Acres` = '0.1389' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 11 SUGAR VALLEY' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sugar Valley' ,`TaxAmount` = '3383' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227341' WHERE `Matrix_Unique_ID` = '214217906' --> 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','214227218','1667227341','214227218','2022-10-31T06:18:47.620','13414647','Gayla Gayden','REALM Real Estate Professional','','','29.701834','-95.706431','23','77407','11','329990.00','Active','Halifax Harvest','6906','Lane','Richmond','2','0','4','1771','Single-Family','One Story Home The Gaven Plan by D.R. Horton! Under Construction! Ultra Modern & Chic Elevation! Gorgeous Upgraded Vinyl Wood Plank Floors throughout! Plush Carpeting in all Bedrooms! This home is perfect for entertaining! Outstanding Open Floor Plan! Dramatic Gourmet Kitchen W/Stunning Quartz Countertops, Tile Back-splash, Large Eat-in Island W/Deep Under-mount Sink, Tall Shaker Cabinets, Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining Area & Amazing Family Area With Wall of Windows! The Private Owner\'s Suite features a Luxurious Bathroom built for 2 with Cultural Marble Counters, His & Her Undermount Sinks, Deep Soaker Tub, Shower W/Seamless Glass Door & Walk-in Closet! More! Energy Efficient Home: HERS Energy Rated! Tankless/On-Demand H2O Heater! \"Smart Home System, which allows you to control lights, locks, & thermostat! Covered Patio! NO FLOODING! Amenities include: Pool, Splash Pad & More! 20 minutes to The Galleria!','','37','D.R. Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Mission Bend Area','Central Gas','1','Lakeview Retreat Lot: 27 /Block: 3','Subdivision Lot','','','','850','1','Never Lived In','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','SEGUIN ELEMENTARY (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied','Builder','1','Contemporary/Modern,Ranch,Traditional','Lakeview Retreat','','','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully