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-05T07:54:40.130' ,`MLSNumber` = '14644690' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679054' ,`Longitude` = '-95.900151' ,`PhotoCount` = '7' ,`PostalCode` = '77441' ,`RoomCount` = '12' ,`ListPrice` = '769890.00' ,`Status` = 'Active' ,`StreetName` = 'Creekbend' ,`StreetNumber` = '4807' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 14644690 - Built by Drees Custom Homes - December completion! ~ The Brookdale II is a well-designed home full of natural light and open spaces. When entering the foyer, you are greeted by the spacious study perfect for a home office. The open two-story staircase and formal dining room lay just beyond the foyer and flow seamlessly into the family room and kitchen. The owner\'s suite features tray ceilings and a luxurious spa bath with premium finishes. A first floor guest suite along with two second level bedrooms ,game room & media room ensure there is plenty of space for everyone!!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 / Bloock 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8571' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook On Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016442' WHERE `Matrix_Unique_ID` = '207400371' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:31:00.093' ,`MLSNumber` = '18109568' ,`ListAgentFullName` = 'Rocio Guajardo' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.079816' ,`Longitude` = '-95.031144' ,`PhotoCount` = '30' ,`PostalCode` = '77535' ,`RoomCount` = '5' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 6242' ,`StreetNumber` = '265' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream new built Home sitting on 1 ACRE!\r\nCustom Kitchen cabinets, massive custom built kitchen island with beautiful granite, huge master bathroom with separate shower and tub, large size closets, luxury vinyl floors, brick on all 4 sides of the house, rain gutters... just to mention a few of the many great features this lovely Home has to offer.\r\nYou don\'t want to miss this one out. Call today to schedule a viewing and make this house your new Home!' ,`Acres` = '1' ,`Area` = '52' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000764 A G PENN #1006, TRACT 40, ACRES 3.46' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'A G Penn' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016442' WHERE `Matrix_Unique_ID` = '207593330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:00:12.107' ,`MLSNumber` = '27653781' ,`ListAgentFullName` = 'Thressa Skidmore' ,`ListOfficeName` = 'CENTUM OAK REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953999' ,`Longitude` = '-97.433636' ,`PhotoCount` = '44' ,`PostalCode` = '78662' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Anderson' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Lane' ,`City` = 'Red Rock' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home nestled in Red Rock, TX, but close to Austin, Bastrop, Lockhart or San Marcos; Lots of Wildlife roaming around on this property; Stock Tank; Three Homesites all ready for your Family; Home has water well big enough to furnish water to 4 different places; Utility Poles are set. 14+ Acres completely fenced for your horses, cattle, goats, chickens or other livestock. When you enter this Home, you will never know you are in a Manufactured home, the customized interior gives you a feel that you are in a Site Built home. Lots of Windows to see all of the Wildlife as they go to the pond in the evenings. The Laundry Room is huge with Sink and Cabinets, room for all of your freezers and extra refrigerator. Tractor is also for sale $12,000. This is a Gem in the Country. You must see this home and property to actually understand the Beauty of it.' ,`Acres` = '14.4' ,`Area` = '83' ,`BuilderName` = 'Schultz' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A347 WILKERSON, F.,14.4 ACRES MH 30X74' ,`LotDesciption` = 'Cleared' ,`LotSize` = '627264' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '210 - Bastrop' ,`SchoolElementary` = 'RED ROCK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CEDAR CREEK H S' ,`SchoolMiddle` = 'CEDAR CREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilkerson, F' ,`TaxAmount` = '7833' ,`TaxRate` = '1.895' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665016442' WHERE `Matrix_Unique_ID` = '208237240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:09:42.920' ,`MLSNumber` = '26561368' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.293680' ,`Longitude` = '-94.804073' ,`PhotoCount` = '35' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue M' ,`StreetNumber` = '3411' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1661' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just blocks from the beach, this revitalized Bungalow with just the right mix of character and upgrades is an absolute treasure. The home features 3 Bedrooms, 2 Baths, a large bonus room that can be used as a 4th bedroom, front and back decks with a huge private back yard. The layout is perfect for entertaining but also to use as an income property. The Kitchen features SS Appliances, Quartz counter-tops, new Cabinets along with a walk in pantry. The Owner\'s Retreat is that of a resort with a double vanity, large Walk-In Shower and closet. Stunningly high and refurbished original ceilings will mesmerize you. Keep cool with the brand new HVAC system and Energy Efficient Windows. The home is also equipped with new plumbing and electrical including a tankless water heater. Location is just minutes away from both the Galveston Sea Wall and The Strand. Perfect getaway to enjoy your time on the Island. Don\'t miss out on this Gem!!' ,`Acres` = '0.1179' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 5 NW BLK 12 GALVESTON OUTLOTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '2296' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016442' WHERE `Matrix_Unique_ID` = '208572507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:51:55.427' ,`MLSNumber` = '97523635' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135914' ,`Longitude` = '-95.316709' ,`PhotoCount` = '50' ,`PostalCode` = '77365' ,`RoomCount` = '6' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Jordan Pond' ,`StreetNumber` = '21500' ,`StreetSuffix` = 'Ridge' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2399' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 97523635 - Built by Highland Homes - January completion! ~ Located on an oversized reserve lot with no rear neighbors, this is an incredible 2-story home w/open concept living that provides togetherness and a feeling of spaciousness from the soaring family room ceiling to the oversized windows allowing for abundant natural light. This home boasts an oversized kitchen with tons of cabinet & countertop space. The wrap around kitchen features an island & breakfast bar allowing for plenty of additional seating for guests. The primary suite with bay window is the perfect spot to unwind!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582903 - The Highlands 03, BLOCK 4, Lot 48' ,`LotDesciption` = 'In Golf Course Community,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.38' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016442' WHERE `Matrix_Unique_ID` = '209267920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:28:02.720' ,`MLSNumber` = '86693325' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838029' ,`Longitude` = '-95.693304' ,`PhotoCount` = '13' ,`PostalCode` = '77084' ,`RoomCount` = '14' ,`ListPrice` = '476000.00' ,`Status` = 'Active' ,`StreetName` = 'Windy Knoll' ,`StreetNumber` = '18306' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is under construction. Escape the city to this incredible Lakewood Home in Grand Oaks. This 4-sided brick home boasts open ceilings, tile flooring, full gutters, a sprinkler system, wrought iron spindles, faux wood blinds, and an extended covered patio. Try a new recipe in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Community amenities include an Olympic-size swimming pool with water slides, walking trails, and a playground. Situated near I-10, Hwy 6, and the Grand Parkway, residents enjoy easy access to the Energy Corridor and plenty of dining and shopping options. Zoned to the highly-acclaimed Cypress-Fairbanks ISD. Call today to book your private showing!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lakewood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '710' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks' ,`TaxAmount` = '' ,`TaxRate` = '2.81' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016442' WHERE `Matrix_Unique_ID` = '209380847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:58:55.603' ,`MLSNumber` = '2211880' ,`ListAgentFullName` = 'Amy Larner' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.143022' ,`Longitude` = '-95.052348' ,`PhotoCount` = '40' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '949000.00' ,`Status` = 'Active' ,`StreetName` = 'Frio' ,`StreetNumber` = '22032' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 4/3.5 bath in the the highly sought after neighborhood of Sea Isle. As you enter the main living area you are greeted with cathedral shiplap ceilings, and amazing natural light. On the main floor you will find an open concept living area, primary bedroom, and an updated kitchen. with a walk in pantry, and utility room. There are As you head to the second floor there are two additional bedrooms, a full bath, and game room. The outdoor area is designed with entertainment in mind. The newer concrete bulkhead and decking were installed in 2019, along with a cargo lift. You are located just a short golf cart ride to the beach, and minutes to the bay. Your island dream home comes furnished with a few exclusions. If you are looking for the perfect full time residence, weekend getaway, or investment property, look no further. Sea Isle amenities include a fishing pier, pool, tennis court, a private boat launch, and the famous West End Marina. All that is missing is you!' ,`Acres` = '0.1396' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 15 LOT 1838 SEA ISLE 13TH EXTENSION' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single 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,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Ext 13' ,`TaxAmount` = '9369' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665016442' WHERE `Matrix_Unique_ID` = '209721044' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:43:36.717' ,`MLSNumber` = '37265123' ,`ListAgentFullName` = 'Myrna Lopez' ,`ListOfficeName` = 'Beyond Real Estate' ,`SellingAgentFullName` = 'Stacy Newton' ,`SellingOfficeName` = 'Weichert,REALTORS-Murray Group' ,`Latitude` = '30.062724' ,`Longitude` = '-95.918322' ,`PhotoCount` = '20' ,`PostalCode` = '77484' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ironwood' ,`StreetNumber` = '31822' ,`StreetSuffix` = 'Drive' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 4 bedroom, 2 bath home is located in the quiet community of Waller! Single story, two car garage on a lot that backs up to a wooded area and no back neighbors! Tile floors in all the main living areas of the house, kitchen and bathrooms. Fresh paint and carpet has been replaced in two of the bedrooms. Large open living space opens to the dining and kitchen area. Primary Bath has an over sized walk-in shower, large vanity & spacious walk-in closet. Back yard features an extended patio area and is fully fenced. Easy, quick access to HWY 290!' ,`Acres` = '0.194' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 8 BRIARTREE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = '' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briartree Sec 01' ,`TaxAmount` = '3832' ,`TaxRate` = '2.5948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016443' WHERE `Matrix_Unique_ID` = '209973505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:49:44.730' ,`MLSNumber` = '28308699' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.359415' ,`Longitude` = '-95.195211' ,`PhotoCount` = '37' ,`PostalCode` = '77328' ,`RoomCount` = '5' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'Hulon Hall' ,`StreetNumber` = '91' ,`StreetSuffix` = 'Court' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single family home built in the country in 2008 3 bedroom 2 bath house on 1.7 acres home is in good condition only needing cosmetic stuff done. has had new tile through out the house, new painting both inside and out, trim replace, a/c was just recently serviced.' ,`Acres` = '1.609' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRAILS END #2, BLOCK 7, LOT 30, ACRES 1.609' ,`LotDesciption` = 'Cleared' ,`LotSize` = '70088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Trails End #2' ,`TaxAmount` = '1580' ,`TaxRate` = '1.9249' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016443' WHERE `Matrix_Unique_ID` = '210178464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:06:24.297' ,`MLSNumber` = '80813235' ,`ListAgentFullName` = 'Valentina Marquez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796920' ,`Longitude` = '-95.306348' ,`PhotoCount` = '19' ,`PostalCode` = '77026' ,`RoomCount` = '5' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Crane' ,`StreetNumber` = '6302' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1288' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home, recently remodel kitchen offers granite countertops and new cabinets. Home has new laminate floors, and water proof vinyl floors in the kitchen and bathroom. detach garage with door opener. Short commute to downtown, hospital and parks nearby.' ,`Acres` = '0.124' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 188 BLK 10 LIBERTY GARDENS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ISAACS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Gardens Sec 01' ,`TaxAmount` = '1836' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016443' WHERE `Matrix_Unique_ID` = '210189554' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:49:50.690' ,`MLSNumber` = '68897782' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704080' ,`Longitude` = '-95.888968' ,`PhotoCount` = '28' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '599818.00' ,`Status` = 'Active' ,`StreetName` = 'Gentle Blossom' ,`StreetNumber` = '5915' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 68897782 - Built by Highland Homes - December completion! ~ Located in Cross Creek Ranch, a master planned community! Just inside this home your eye is drawn to the dramatic high ceilings and arched entry. Secondary bedrooms are tucked away off of the entry, which leads the way to the open formal dining room. The study is closed off by glass French doors, providing a quiet escape to work from home. The extended family room & breakfast feature bright picture windows, offering peaceful views of the outdoors. Open concept kitchen, family, breakfast. Chef\'s kitchen has quartz counter tops, custom shaker style cabinets & eat-in island. Built-in planning desk provides great work space & additional storage. Escape to the secluded over-sized master suite with a sitting area. En-suite master bath includes a vanity space, dual sinks, separate tub & shower with stunning tile upgrades. Huge master closet! Wood floors throughout common living areas. Large covered patio.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot Block' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6700' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016443' WHERE `Matrix_Unique_ID` = '210356862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:51:44.430' ,`MLSNumber` = '18904572' ,`ListAgentFullName` = 'Winnie Stearns' ,`ListOfficeName` = 'Stearns Property Company, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786281' ,`Longitude` = '-95.189132' ,`PhotoCount` = '16' ,`PostalCode` = '77015' ,`RoomCount` = '5' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Halifax' ,`StreetNumber` = '13343' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '991' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never Flooded! Security gated! Remodeled! Hurry! Great 2 or 3-1-1. Don\'t worry about your roof in storms. Seller put on Metal roof. New granite countertop, new HVAC system. Stainless DW, gas range. New laminate flooring in 2 bedrooms. Beautiful hardwood floors in living room. Great area close to shopping. Galina Park Schools. Large totally fenced lot with double gates to driveway. You can lock your cars behind gates! Another 12.5X6.5 room that could be 3rd bedroom or den. Wonderful large fenced back yard!' ,`Acres` = '0.186' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Home Protection Plan,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 804 BLK 28 HOME OWNED ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'GREEN VALLEY ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home Owned Estates Sec 02' ,`TaxAmount` = '2668' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016443' WHERE `Matrix_Unique_ID` = '210373687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:29:16.443' ,`MLSNumber` = '87978735' ,`ListAgentFullName` = 'Jennifer Greene' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.972323' ,`Longitude` = '-95.500570' ,`PhotoCount` = '37' ,`PostalCode` = '77066' ,`RoomCount` = '7' ,`ListPrice` = '559900.00' ,`Status` = 'Active' ,`StreetName` = 'Spanish Oak' ,`StreetNumber` = '5303' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '7' ,`SqFtTotal` = '5152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect combination of charm and modern convenience! Over 5,000 sqft home with custom touches, tons of upgrades, PLUS 2 bedroom garage inlaw suite or flex area, pool, chef’s kitchen, circular driveway, on large corner lot! Home has 2 master bedrooms, flex space for a gym or studio. Kitchen is a chef’s dream featuring waterfall granite countertops, under cabinet lighting, three convection ovens, one gas oven and two electric ovens, and Viking stove. Lots of storage, rolling shelves and pull out mixer stand. Laundry room has cabinets, sink, folding counter top and large pantry. 3 A/C units to keep cool. Upgrades include A/C, new fireplace, new carpet, new wood stairs, and fresh neutral paint and remodeled master bath (2017). INLAW SUITE: Approx 1400 sqft renovated with two bedrooms, has own driveway and entrance. Convenient to hospitals, shopping and entertainment - 5 mins to 249, I45, Beltway 8. Never flooded, not in flood plain.' ,`Acres` = '0.2471' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 53 017*G6652900-008-053-001 GREENWOOD FOREST SEC 8' ,`LotDesciption` = 'Corner' ,`LotSize` = '10764' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'GREENWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenwood Forest Sec 08' ,`TaxAmount` = '8021' ,`TaxRate` = '2.3715' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016443' WHERE `Matrix_Unique_ID` = '210385797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:22:51.490' ,`MLSNumber` = '88174826' ,`ListAgentFullName` = 'Lynda Troutman' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = 'Colby Amerine' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.329002' ,`Longitude` = '-95.425006' ,`PhotoCount` = '24' ,`PostalCode` = '77301' ,`RoomCount` = '8' ,`ListPrice` = '305000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Oak Circle' ,`StreetNumber` = '2238' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come beat the Texas heat in your own pool! Great 4 bedroom home that boasts an open concept flow between the living room, dining room and kitchen. There is a large game room and 3 bedrooms upstairs. The outdoor covered patio has a mounted TV and speakers, ready for entertaining. Washer/Dryer and Refrigerator are included. The garage has a bump out allowing for extra storage. Conveniently located close to shopping, schools, and restaurants and easy access to I-45. Come make this your new home!' ,`Acres` = '0.1151' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S337700 - CEDAR WOODS, BLOCK 2, LOT 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5013' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '484' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Woods' ,`TaxAmount` = '6163' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016444' WHERE `Matrix_Unique_ID` = '210858160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:51:36.210' ,`MLSNumber` = '50142193' ,`ListAgentFullName` = 'Samanta Slentz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.120578' ,`Longitude` = '-95.246497' ,`PhotoCount` = '17' ,`PostalCode` = '77365' ,`RoomCount` = '9' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Stillwater Valley' ,`StreetNumber` = '22546' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Beautiful DR Horton Home, Great Open Concept Floor Plan, Kitchen that features Stainless Steel appliances, Breakfast Room & Formal Dining Room. Upstairs has 3 bedrooms with a full Bathroom and Game room. Great Size Backyard for kids and pets to play with No Back Neighbors. NEVER FLOODED!' ,`Acres` = '0.1629' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S941206 - VALLEY RANCH 06, BLOCK 3, LOT 17' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7096' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Valley Ranch 06' ,`TaxAmount` = '7562' ,`TaxRate` = '3.2331' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016444' WHERE `Matrix_Unique_ID` = '210873202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:56:28.080' ,`MLSNumber` = '96564138' ,`ListAgentFullName` = 'Max Burns' ,`ListOfficeName` = 'Max Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750900' ,`Longitude` = '-95.390852' ,`PhotoCount` = '32' ,`PostalCode` = '77006' ,`RoomCount` = '7' ,`ListPrice` = '1049900.00' ,`Status` = 'Active' ,`StreetName` = 'Willard' ,`StreetNumber` = '906' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2951' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly unique one of a kind contemporary home! High ceilings! Open with lots of natural light! Slate floors down stairs. Living, dining room, main bedroom open to landscaped courtyard! Incredible kitchen with upgraded appliances opens to living room and dining room. Upstairs has 2 bedrooms each with full baths and flexible open space. Covered 2nd floor veranda in between bedrooms and study. Main bedroom downstairs with an incredible en suite bath! Features: Refrigerator, Washer/Dryer, Roof 1 year old, recent industrial windows and doors with lifetime warranty, rain gutter guards with lifetime warranty, recent interior paint. This house is a MUST SEE!' ,`Acres` = '0.0895' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 7 CAVE E W' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cave E W' ,`TaxAmount` = '18056' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016444' WHERE `Matrix_Unique_ID` = '211020429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:04:05.853' ,`MLSNumber` = '24546957' ,`ListAgentFullName` = 'Ashly Singletary' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Josefina Duran' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '29.851479' ,`Longitude` = '-95.406099' ,`PhotoCount` = '15' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '249000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ishmeal' ,`StreetNumber` = '363' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1359' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is perfect for an investment property or a personal home. The kitchen, dining and living room are very open and has large window in front for natural light. Kitchen has a new electric range. Home has a large back yard for grilling and lots of room for playing. Please verify all room dimensions.' ,`Acres` = '0.198' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 5 WILDROSE GARDENS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WESLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wildrose Gardens Sec 04' ,`TaxAmount` = '3202' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016444' WHERE `Matrix_Unique_ID` = '211073218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:43:14.500' ,`MLSNumber` = '73965794' ,`ListAgentFullName` = 'Melissa Wilson' ,`ListOfficeName` = 'MMW Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.791341' ,`Longitude` = '-95.386786' ,`PhotoCount` = '27' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Key' ,`StreetNumber` = '1118' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop your car right now and come check out this completely renovated beauty! This home was recently converted from a duplex to single family home. Why not experience the greatness of this historical with a modern look inside?This home features 3 bedroom 2 bathrooms and located conveniently from great restaurants and coffee shops. You also are minutes away from the nightlife and enjoyment the heights have to offer. If you can\'t make it to the home? Well check out my virtual tour! Book an appt with us today!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 132 NORTH NORHILL' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'North Norhill' ,`TaxAmount` = '8008' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665016444' WHERE `Matrix_Unique_ID` = '211160978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:40:23.747' ,`MLSNumber` = '18622281' ,`ListAgentFullName` = 'Candice Harris' ,`ListOfficeName` = 'CA Modern Realty, LLC' ,`SellingAgentFullName` = 'Kimberly Hughston' ,`SellingOfficeName` = 'Real Broker, LLC' ,`Latitude` = '30.137090' ,`Longitude` = '-95.439457' ,`PhotoCount` = '32' ,`PostalCode` = '77386' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Gamewood' ,`StreetNumber` = '331' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this freshly remodeled property tucked away in a mature neighborhood of Oak Ridge North! This property includes many upgrades which are; new roof, new AC, new electrical box, new flooring, new paint, new appliances, quartz counter tops, new kitchen cabinets, remodeled bathrooms, and many more! Schedule a showing to view before it\'s gone, guaranteed to sell!' ,`Acres` = '0.2672' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK RIDGE NORTH A BK 1 LT 43, & S 5.3\' OF LT 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11639' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge North A' ,`TaxAmount` = '3684' ,`TaxRate` = '2.0087' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016444' WHERE `Matrix_Unique_ID` = '211165611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:49:31.987' ,`MLSNumber` = '10588128' ,`ListAgentFullName` = 'Philip Tack Sr.' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.207821' ,`Longitude` = '-95.584782' ,`PhotoCount` = '18' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '394600.00' ,`Status` = 'Active' ,`StreetName` = 'Miller' ,`StreetNumber` = '8631' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a Great house with a 29000 square foot property great quiet location close to everything, Just minutes from 1488 and the Woodlands. House has totally been redone, A/C replaced including all duct work, brought natural gas to the house so new heating unit is gas, and stove. All new appliances, complete remodel opened all the kitchen, living and dining together. New closet and Primary beautiful shower, all new luxury vinyl flooring.\r\nREADY to move in Awesome property!!!!' ,`Acres` = '0.668' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S949502 - WESTWOOD 02, BLOCK 2, LOT 3' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '29100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '208' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood 02' ,`TaxAmount` = '4043' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016445' WHERE `Matrix_Unique_ID` = '211167447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:51:34.367' ,`MLSNumber` = '87300892' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.401881' ,`Longitude` = '-95.070731' ,`PhotoCount` = '30' ,`PostalCode` = '77568' ,`RoomCount` = '17' ,`ListPrice` = '499437.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sabine Lake' ,`StreetNumber` = '13714' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Alden, Elevation AL) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. First floor study. Spacious island kitchen open to family room and informal dining room. Primary suite with large walk-in closet. Upstairs game room and media room. Covered patio and attached 2 car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016445' WHERE `Matrix_Unique_ID` = '211324374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:20:40.110' ,`MLSNumber` = '77275407' ,`ListAgentFullName` = 'Grant Threatt' ,`ListOfficeName` = 'Beebe Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692320' ,`Longitude` = '-95.292185' ,`PhotoCount` = '28' ,`PostalCode` = '77087' ,`RoomCount` = '3' ,`ListPrice` = '179999.00' ,`Status` = 'Active' ,`StreetName` = 'Thurow' ,`StreetNumber` = '7535' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Original owner home offered for sale in established, Greenway subdivision. Close to city districts, airports, hospitals, shopping, and more. Situated just outside the 610 Loop, this home is minutes from the Gulfgate Center and the Astrodome. The property has tremendous potential for a new owner and includes a 12x20 workshop with power, water, and sewer. Property boasts a beautiful lawn, thoughtful paths, deck, and landscaping. It is ready for your touches to make this gem uniquely yours. All dimensions should be verified.' ,`Acres` = '0.1599' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 14 GREENWAY SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6966' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GOLFCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenway' ,`TaxAmount` = '2371' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016445' WHERE `Matrix_Unique_ID` = '211379686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:26:41.930' ,`MLSNumber` = '42038421' ,`ListAgentFullName` = 'Myrna Lopez' ,`ListOfficeName` = 'Beyond Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.906465' ,`Longitude` = '-97.369509' ,`PhotoCount` = '40' ,`PostalCode` = '76131' ,`RoomCount` = '9' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Braewick' ,`StreetNumber` = '525' ,`StreetSuffix` = 'Drive' ,`City` = 'Fort Worth' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this GORGEOUS modern farmhouse that could be straight from a magazine cover! Amenities abound including inviting wood shiplap, modern lighting, beautiful chandeliers, archways and raised ceilings. Split bedroom floor plan with three bedrooms, two bathrooms, plus an OFFICE or FOURTH BEDROOM and a separate SITTING AREA perfect for a play or game room, media room, or workout equipment! Entertaining is a delight in the open kitchen with large island, eating bar, stainless appliances, black-lace granite counters, walk-in pantry, breakfast eating nook, plus separate formal dining room. Stunning white brick fireplace in the living room. The primary bathroom features a double sink vanity, walk in shower, separate soaking tub, and large walk in closet. Space and storage abound. Enjoy the outdoors on the covered patio. New HVAC and roof in 2021 and freshly painted exterior. This warm and inviting home is ready for you!' ,`Acres` = '0.1377' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FOSSIL PARK ESTATES BLOCK 11 LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '364' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '486 - Eagle Mountain-Saginaw' ,`SchoolElementary` = 'COMANCHE SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAGINAW HIGH SCHOOL' ,`SchoolMiddle` = 'PRAIRIE VISTA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fossil Park Estates' ,`TaxAmount` = '6838' ,`TaxRate` = '2.8023' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016445' WHERE `Matrix_Unique_ID` = '211418717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:56:28.830' ,`MLSNumber` = '62760277' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.436714' ,`Longitude` = '-95.420799' ,`PhotoCount` = '7' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '719137.00' ,`Status` = 'Active' ,`StreetName` = 'Brush Way' ,`StreetNumber` = '10102' ,`StreetSuffix` = '' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3403' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 62760277 - Built by Drees Custom Homes - December completion! ~ The Brendan offers convenience and comfort! An open study and dining room lie just off the kitchen which comes with an ample serving island, custom cabinetry, and built-in home office. An inviting corner fireplace grounds and centers the family room with its vaulted ceiling and openness to the kitchen. . Two spacious bedroom suites lie on the first-floor, both with generous walk-in closets. The owner\'s suite comes with a spa-like bath including a garden tub and glass walk-in shower room. The upstairs opens into a common area leading into the media and gameroom with two comfortable bedrooms located on the other side' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot - 8 / Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8659' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016445' WHERE `Matrix_Unique_ID` = '211433379' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:13:40.690' ,`MLSNumber` = '26267097' ,`ListAgentFullName` = 'Amanda Walsh' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Jonathan Davis' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.798220' ,`Longitude` = '-95.576099' ,`PhotoCount` = '27' ,`PostalCode` = '77043' ,`RoomCount` = '9' ,`ListPrice` = '515000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wrenwood' ,`StreetNumber` = '10938' ,`StreetSuffix` = 'Green' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2798' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMPRESSIVE & SOPHISTICATED FREESTANDING townhome in the beautiful, gated Upland Park community. You will marvel over the countless upgrades & how well-appointed this gorgeous French-inspired beauty really is! Stunning wood flooring throughout paired with fabulous kitchen cabinetry upgraded to offer additional upper storage space & charming glass fronts for display (rare find)! You will greatly appreciate the FIRST-FLOOR living/kitchen area with soaring ceiling height, elegant gaslog fireplace, quality craftmanship, double-paned windows, magnificent Primary Suite, HUGE walk-in closets, & superb finishes! Third floor flex-room features a private bath & closet, which could function as a 4th bedrm/gameroom/media. Escape to one of the multiple outdoor living areas - 1st-floor back patio complete with artificial grass for low-maintenance or the enormous 3rd-floor rooftop deck complete with waterproof decking material. Community offers walking trails, community pool and lush landscaping!' ,`Acres` = '0.05' ,`Area` = '24' ,`BuilderName` = 'InTown Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 UPLAND PARK 3RD PAR R/P & R/P AMEND' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2178' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'French,Traditional' ,`Subdivision` = 'Upland Park' ,`TaxAmount` = '9817' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016446' WHERE `Matrix_Unique_ID` = '211436261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:55:56.150' ,`MLSNumber` = '14899874' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.442911' ,`Longitude` = '-95.401351' ,`PhotoCount` = '7' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '899621.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Park' ,`StreetNumber` = '4510' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4639' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 14899874 - Built by Drees Custom Homes - December completion! ~ The Briargate is a stylish home designed for your lifestyle. The open living triangle features a cozy fireplace, large kitchen island and dining room with access to the covered porch. The kitchen connects to the garage through the convenient family ready room, the ideal space to keep a busy family organized. The main level also includes a media room for family movie night or the big game.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot - 14 / Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14767' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016446' WHERE `Matrix_Unique_ID` = '211437888' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:55:06.613' ,`MLSNumber` = '61118467' ,`ListAgentFullName` = 'Melissa Seureau' ,`ListOfficeName` = 'RE/MAX Preferred Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.128935' ,`Longitude` = '-95.819442' ,`PhotoCount` = '24' ,`PostalCode` = '77447' ,`RoomCount` = '9' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Creek Bend' ,`StreetNumber` = '24445' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEE Home!! 1 story ranch style home with 36x36 metal building on an acre in Waller County, Texas. Exterior of home is brick and vinyl, home has sweet porch and large back covered patio. Lots of Mature Oak Trees! Large detached garage is 20x20 with a carport. Home has a very large formal living and dining room that could be used as a massive game room. Den is good size too. Primary bedroom has double closets, the en-suite bath has double sinks and an adorable corner shower with tub. 2nd bedroom has a 1/2 bath. 3rd bedroom is on the opposite side of home has easy access to the 3rd bathroom with a shower. Kitchen has eat-in breakfast and TWO pantries and an extra large sink. Windows replaced by Anderson. 2 AC systems with dehumidifiers. Tuff Shed is 11x9. Metal Building has 5 roll-up doors and man door.' ,`Acres` = '1' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S433500 CLEAR CREEK FOREST 5 LOT 12 ACRES 1.0' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '85' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '8' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Clear Creek Forest' ,`TaxAmount` = '5693' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665016446' WHERE `Matrix_Unique_ID` = '211506474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:09:50.390' ,`MLSNumber` = '10941756' ,`ListAgentFullName` = 'Herbert Oliver' ,`ListOfficeName` = 'Oliver Real Estate Group LLC' ,`SellingAgentFullName` = 'Awilda Gonzalez' ,`SellingOfficeName` = 'Prime Realty' ,`Latitude` = '29.595825' ,`Longitude` = '-95.752116' ,`PhotoCount` = '24' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '289900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Garden Stream' ,`StreetNumber` = '2823' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1954' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous One Story Located in Rivers Edge on a large corner lot! The home features an Open Floorplan with the kitchen (Granite Countertops and Stainless Appliances) opening to the Living room, and Breakfast area. This makes for a great space to get together with the family or entertain friends. In addition, the home also has High Ceilings, a Large Primary bedroom, Large walk in Shower with Seamless Shower Door and Soaker Tub, Double Sinks and a Large walk in closet. This home is move in ready and won\'t last long so set you appointment today!' ,`Acres` = '0.1655' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERS EDGE SEC 6, BLOCK 2, LOT 47' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7209' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '695' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Rivers Edge Sec 6' ,`TaxAmount` = '5607' ,`TaxRate` = '2.8948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016446' WHERE `Matrix_Unique_ID` = '211894972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:18:01.740' ,`MLSNumber` = '98144127' ,`ListAgentFullName` = 'Keven Card' ,`ListOfficeName` = 'Doxes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.077768' ,`Longitude` = '-95.262955' ,`PhotoCount` = '34' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Fitzwilliam' ,`StreetNumber` = '20536' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautifully spacious home in Porter. This home sits on a corner lot just minutes from Hwy 59. It features an open floor plan throughout with an oversized family room, open kitchen and a space for breakfast bar, nook dining and a formal dining space. This beauty has a primary bedroom large enough to add sofas on each side of the room with a King-sized bed. As well as a primary walk-in closet that’s nearly large enough to be its own bedroom. Two of the secondary bedrooms also have walk-in closets. The media room is nestled between the bedrooms. It also features a large understairs storage space and coat closet. This home also has a sprinkler system throughout the yard to keep it looking green and fresh all summer long. You don’t want to miss out on seeing this one, but see it soon or you might not get the chance. The Washer, Dryer and Refrigerator are included with the right offer.' ,`Acres` = '0.1944' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S273106 - BROOKWOOD FOREST 06, BLOCK 2, LOT 11' ,`LotDesciption` = 'Corner' ,`LotSize` = '8469' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '740' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brookwood Forest 06' ,`TaxAmount` = '9721' ,`TaxRate` = '3.6131' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665016446' WHERE `Matrix_Unique_ID` = '211956538' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:15:54.507' ,`MLSNumber` = '92972857' ,`ListAgentFullName` = 'Jana Bruce' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782471' ,`Longitude` = '-95.500449' ,`PhotoCount` = '33' ,`PostalCode` = '77024' ,`RoomCount` = '13' ,`ListPrice` = '2995000.00' ,`Status` = 'Active' ,`StreetName` = 'Voss Park' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '8059' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gracious Hunters Creek estate in the Voss Park enclave designed by renowned architect Lucian Hood. Recently renovated, the home represents a perfect blend of timeless architecture and modern design. Interior highlights include a formal entry with sweeping staircase, hardwoods, high ceilings, 3 fireplaces, paneled library, formal dining and living. Grand family room features 20-foot ceilings with windows overlooking the backyard salt water pool. The kitchen, reimagined by local design firm Weidner Hasou, is complete with marble counters, soft close cabinets, a 16-foot island with counter seating and Thermador stainless appliances. Serene downstairs primary suite features a coffered ceiling, and a bathroom with dual sinks, marble counters, a glass shower, free-standing tub, private water closet and two cedar walk-in closets. Upstairs are four bedroom suites with updated bathrooms and walk-in closets, and two flex rooms. Circular drive leads to the gated motor court and three car garage.' ,`Acres` = '0.5165' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 VOSS PARK' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '22498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Voss Park' ,`TaxAmount` = '23222' ,`TaxRate` = '2.1111' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016446' WHERE `Matrix_Unique_ID` = '211976780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:06:46.887' ,`MLSNumber` = '48229254' ,`ListAgentFullName` = 'Nancy Rollings' ,`ListOfficeName` = 'Red Dirt Realty Group' ,`SellingAgentFullName` = 'Randi Worsham' ,`SellingOfficeName` = 'BHHS Worldwide, REALTORS' ,`Latitude` = '30.170594' ,`Longitude` = '-95.828816' ,`PhotoCount` = '14' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '317000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Rolling Forest' ,`StreetNumber` = '26023' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1532' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 1 acre lot is farther back into the neighborhood, which provides a peaceful nature filled setting! The front yard has a lot of potential to make it your own. The home has a split floorpan with large living room area in the center of the home, primary bedroom on one side of the house and two bedrooms on the other side. From the back patio your backyard view includes a large fenced in yard with thick wooded trees along the back fence' ,`Acres` = '1' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S441106 COUNTRY LANE ESTATES 6 BLK 2 LOT 29 ACRES 1.0' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Lane Estates 6' ,`TaxAmount` = '4205' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016447' WHERE `Matrix_Unique_ID` = '212131608' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:24:14.107' ,`MLSNumber` = '34168760' ,`ListAgentFullName` = 'Archie McCoy III' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.407539' ,`Longitude` = '-95.046980' ,`PhotoCount` = '49' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Topsail' ,`StreetNumber` = '2706' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2231' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE one-story, 4 bedroom, 2 bath home in the popular Lago Mar community located just off 45. Enjoy the many amenities of this resort-style community and this well-kept home in walking distance to the park. Community pool plus relaxing lagoon, workout facility, soccer field and playground. Split floor plan with a wide-open family room and high ceilings. Primary suite is tucked on opposite side of house from guest bedrooms and has extra large closet. Island kitchen includes granite counters, stainless appliances and tall cabinets. Peaceful waterfront view from the spacious backyard and covered patio. Quiet community and no back neighbors. Just the place you want to come home to!' ,`Acres` = '0.1895' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAGO MAR POD 11 SEC 6 (2017) ABST 11, BLOCK 2, LOT 34, ACRES' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8255' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar Pod 11 Sec 6' ,`TaxAmount` = '11610' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016447' WHERE `Matrix_Unique_ID` = '212166472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:04:54.167' ,`MLSNumber` = '19444100' ,`ListAgentFullName` = 'Angelia Risher' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Melessa Waterwall' ,`SellingOfficeName` = 'Worth Clark Realty' ,`Latitude` = '30.045674' ,`Longitude` = '-95.605958' ,`PhotoCount` = '30' ,`PostalCode` = '77375' ,`RoomCount` = '8' ,`ListPrice` = '239900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Evening Glen' ,`StreetNumber` = '19303' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedrooms, 2.5 baths, split level designed home in cul-de-sac. (2 beds/1.5 bath up & 2 beds/1 bath down) UPDATES INCLUDE: New paint thru out interior and exterior of home, new Luxury Vinyl Tile (hard floors thru out), installed new toilets in all bathrooms, refinished vanity areas, new ceramic tile at showers/tub w/designer trim. Kitchen updated w/new stainless steel gas oven/range, dishwasher and refinished countertops. New window blinds thru out. X-large fenced private back yard. Beautiful mature trees anchor landscaping front & back w/new sod. Conveniently located close to HWY 249 and 99 (Grand Parkway), easy access for your commute. Your family future home awaits you.' ,`Acres` = '0.1893' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 4 017*T3151700-001-004-054 THREE LAKES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '8245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KOHRVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Three Lakes' ,`TaxAmount` = '3924' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016447' WHERE `Matrix_Unique_ID` = '212167079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:50:33.430' ,`MLSNumber` = '46931430' ,`ListAgentFullName` = 'Otilia Robles' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.603734' ,`Longitude` = '-95.192572' ,`PhotoCount` = '17' ,`PostalCode` = '77034' ,`RoomCount` = '7' ,`ListPrice` = '312950.00' ,`Status` = 'Active' ,`StreetName` = 'High Banks Ln' ,`StreetNumber` = '13442' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story home on a corner lot with 4 bedroom 2 1/2 bath. Open floor plan. All bedrooms offer spacious walk-in closet space. A gorgeous backyard is great for entertaining with a “Texas” sized covered patio. Near NASA, Ellington Field, shopping, schools, hospitals, and entertainment. Never flood it. We look forward to hearing from you!' ,`Acres` = '' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 5 CLEARVIEW VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'TEAGUE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clearview Village Sec 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016447' WHERE `Matrix_Unique_ID` = '212208582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:55:29.253' ,`MLSNumber` = '29676333' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680569' ,`Longitude` = '-95.901316' ,`PhotoCount` = '8' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '729176.00' ,`Status` = 'Active' ,`StreetName` = 'South Creek' ,`StreetNumber` = '30522' ,`StreetSuffix` = 'Way' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 29676333 - Built by Drees Custom Homes - January completion! ~ A media & study greet you upon entering the foyer of the Deerfield II. The family living area flows nicely together accented by a bountiful kitchen island, custom cabinetry, walk-in pantry, and a cozy fireplace in the two-story family room. A covered porch awaits off the breakfast room for trendy outdoor living. The luxurious owner\'s suite will be your private retreat with a resort-like bath. Upstairs are two comfortable bedrooms and a generous gameroom.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot - 3 / Block - 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8550' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook On Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016447' WHERE `Matrix_Unique_ID` = '212228996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:58:53.877' ,`MLSNumber` = '53836128' ,`ListAgentFullName` = 'Lindsey Crockom' ,`ListOfficeName` = 'Yellow Keys Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405163' ,`Longitude` = '-95.046299' ,`PhotoCount` = '44' ,`PostalCode` = '77568' ,`RoomCount` = '4' ,`ListPrice` = '284500.00' ,`Status` = 'Active' ,`StreetName` = 'Murano' ,`StreetNumber` = '12306' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This darling home sits on a premium lake lot with water views nestled in the gated section of Lago Mar. Featuring 3 bedrooms, 2 bathrooms plus an office nook with built in cabinets. This stunning home will take your breath away from the moment you step inside. From the abundance of natural light, plethora of cabinet space and fresh colors schemes- every detail has been thought of. The open kitchen with water views is perfect for entertaining, offering stainless steel appliances and includes the refrigerator. Relax and rewind outside under the covered patio and admire your views. Home also features a full sprinkler system so you can work less and relax more. Add a golf cart and cruise over to the community amenities such as the resort style pools, fitness centers, playgrounds, soccer field, splashpad, beach access at the famous 12 acre lagoon and dine in at the community restaurant opening soon! Schedule a showing today!' ,`Acres` = '0.1525' ,`Area` = '33' ,`BuilderName` = 'Gehan' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 21 BLK 2 LAGO MAR POD 11 SEC 7A (2018) ABST 11' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6641' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar Pod 11 Sec 7a' ,`TaxAmount` = '8022' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016447' WHERE `Matrix_Unique_ID` = '212255372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:55:30.847' ,`MLSNumber` = '7982956' ,`ListAgentFullName` = 'Yvonne Bonner-Holley' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Callee Maglothin' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.831252' ,`Longitude` = '-95.431602' ,`PhotoCount` = '38' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '1150000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Curtin' ,`StreetNumber` = '1239' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the highly sought after Oak Forest neighborhood . This beautiful four bedroom home boasts high ceilings , ample natural light , and large living spaces . The kitchen flows easily into the primary living space allowing for conversation and entertaining to go smoothly . This home not only has beautiful indoor spaces it has the outdoor space to match ! The sellers recently added a fabulous outdoor kitchen and covered patio , the ultimate at home oasis. \r\nNot only is the home breathtaking you are walking distance from Oak Forest Elementary school and two beautiful parks . \r\nDo not miss out on this amazing opportunity to make this house and Oak Forest your home .' ,`Acres` = '0.1667' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 28 OAK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 03' ,`TaxAmount` = '20575' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016448' WHERE `Matrix_Unique_ID` = '212259455' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:42:40.710' ,`MLSNumber` = '9151267' ,`ListAgentFullName` = 'Nima Davari' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684811' ,`Longitude` = '-95.369247' ,`PhotoCount` = '28' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Noah St' ,`StreetNumber` = '3710' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2003' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, contemporary and elegant new construction homes in South Medical Center area. 4 bedrooms and 3 full bathrooms, gaming/study loft area with ample natural light. Open concept kitchen, living, & dining area. Contemporary soft-close shaker cabinets with shine-speckled quartz countertops. 1 bedroom & full bath on 1st floor to perfectly accommodate your guests. Master bedroom on 2nd floor with tray ceiling, his/her closets and a marvelous master bathroom with oversized shower & luxury free standing soaking tub. 2 other bedrooms upstairs with huge closets & 6ft oversized windows, and a separate full bath accommodating both. Contemporary design with 10ft ceilings, recessed lighting all over, grand entry door and a beautiful outdoor paver access path to the tiled entryway. Don\'t miss this thoughtfully designed modern yet cozy gem of a piece minutes away from Medical Center, University of Houston, NRG Stadium, & Downtown Houston' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Noah Realnest' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2 Block 1' ,`LotDesciption` = 'Other' ,`LotSize` = '2500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHIDBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Noah Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016448' WHERE `Matrix_Unique_ID` = '212270602' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:53:58.213' ,`MLSNumber` = '26546362' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656969' ,`Longitude` = '-95.352484' ,`PhotoCount` = '14' ,`PostalCode` = '77033' ,`RoomCount` = '8' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Coffee' ,`StreetNumber` = '9307' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Almost new 3 year built hard to find 4 bedroom 2 bathroom house in the medical center area district for under 200k! The adjacent lot is also included in the sale which is already fenced in making the total lot size included in the sale over 4000 sq ft! Amazing location minutes to all houston stadiums,schools hop and skip to restaurants and public transportation. All major highways 610,sm houston and 45 all nearby. The house is highly insulated solid concrete construction and not in a flood zone! Hurry this will see a contract in hours! Hurry and show!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric,Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 SNOWY DAY AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '2147' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016448' WHERE `Matrix_Unique_ID` = '212293685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:55:50.190' ,`MLSNumber` = '90485726' ,`ListAgentFullName` = 'Steven Franco' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.866274' ,`Longitude` = '-95.700622' ,`PhotoCount` = '38' ,`PostalCode` = '77449' ,`RoomCount` = '12' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Glory' ,`StreetNumber` = '6310' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story home with a pool. It features formal dining, living room with a cozy fireplace. Kitchen has Quartz countertops, New stainless steel appliances. New Luxury Vinyl plank flooring and carpet throughout. Elegant staircase and high ceiling foyer. Game room upstairs. Large primary bedroom, primary bathroom with double sinks, separate tub and custom shower with frameless glass, and walking closet. Spacious bedrooms. Large sparkling blue water swimming pool ideal to entertain your family during the hot summer days with new plaster, waterline tile and pump. Come and enjoy relaxing evenings in the hot spa. Large back yard with plenty of space for pool parties and BBQ\'s. Good established neighborhood. Great location, Katy ISD schools, and easy access to major roads and freeways. Call today for a private showing!! See attached seller upgrade sheet.' ,`Acres` = '0.172' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 BEAR CREEK PLANTATON SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7491' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Plantaton Sec 03' ,`TaxAmount` = '5512' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016448' WHERE `Matrix_Unique_ID` = '212314974' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:44:58.487' ,`MLSNumber` = '86243990' ,`ListAgentFullName` = 'Yolanda Whitlock' ,`ListOfficeName` = 'SOS Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.574474' ,`Longitude` = '-95.269739' ,`PhotoCount` = '50' ,`PostalCode` = '77581' ,`RoomCount` = '9' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Lantana Spring' ,`StreetNumber` = '1903' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2185' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront views you won\'t want to miss. Rays upon rays of natural lighting coming into illuminate this home. Located in a very desirable neighborhood in Pearland. With a great view and tranquil sound of the water fountain you are sure to feel relaxed. Looking for an open floorplan with a spacious island kitchen and breakfast bar? This home has it too. The kitchen is centrally located easy for entertaining family and guest. Family room is certainly cozy with the gas fireplace for the cool TX nights. Enjoy your time in your master bedroom nestled away from the secondary bedrooms and also a great view of the water. The formal living can easily be used for a home office or flex space. Secondary bedrooms and hallway have new carpet. Located near 45 South and Beltway 8, for ease to downtown Houston & Gulf Coast (Galveston)! The neighborhood is also near an abundance of dining and retail options, such as stores in The Center at Pearland Parkway.' ,`Acres` = '0.166' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE LAKES AT HIGHLAND GLEN SEC 10 (A0076)(PEARLAND) BLK 1 LO' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '7231' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '795' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'BARBARA COCKRELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes At Highland Glen Sec' ,`TaxAmount` = '7710' ,`TaxRate` = '2.9952' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016448' WHERE `Matrix_Unique_ID` = '212337055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:54:01.053' ,`MLSNumber` = '74758778' ,`ListAgentFullName` = 'Emily McCollum' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = 'Theresa Scopel' ,`SellingOfficeName` = 'Reyes Realty Group, LLC' ,`Latitude` = '29.413876' ,`Longitude` = '-95.239156' ,`PhotoCount` = '37' ,`PostalCode` = '77511' ,`RoomCount` = '3' ,`ListPrice` = '210000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Southbend' ,`StreetNumber` = '503' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming three bedroom, two bath home with a study! This home is centrally located in town, has a fenced in back yard, mature trees and a covered back patio. As you enter, you will see the study to the right and new luxury vinyl flooring that run throughout the main areas of the home. The living space is open and flows nicely into the kitchen that includes white cabinets, a high top bar, and a little breakfast area. You will love having the large glass sliding door that looks out to the patio and brings in plenty of natural lighting. In all the bedrooms there is new carpet and the bathrooms have granite countertops. The primary bath has a newly renovated shower with subway tile walls and a fun tile flooring. The backyard has plenty of space for your dog or kids to play and the patio is the perfect spot to enjoy your morning coffee or a crisp fall evening. This one is move in ready and just waiting for you to call it your home!' ,`Acres` = '0.1663' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTH BEND (ALVIN) LOT 33' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HASSE ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Bend Alvin' ,`TaxAmount` = '4174' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016448' WHERE `Matrix_Unique_ID` = '212348624' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:55:52.670' ,`MLSNumber` = '38500174' ,`ListAgentFullName` = 'Max Burns' ,`ListOfficeName` = 'Max Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750903' ,`Longitude` = '-95.390727' ,`PhotoCount` = '10' ,`PostalCode` = '77006' ,`RoomCount` = '5' ,`ListPrice` = '474900.00' ,`Status` = 'Active' ,`StreetName` = 'Willard' ,`StreetNumber` = '904' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two bedroom Bungalow in the Montrose area with some updates. Kitchen, bath had been updated, hardwood floors thru out, house does need some TLC, good for investors, good lot value for the location. Refrigerator and full size washer & dryer included. Walking distance to several restaurants & shopping centers' ,`Acres` = '0.0895' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 7 CAVE E W' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cave E W' ,`TaxAmount` = '10234' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1915' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016449' WHERE `Matrix_Unique_ID` = '212389504' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:23:21.600' ,`MLSNumber` = '89020446' ,`ListAgentFullName` = 'David Johnson' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = 'Patricia Neely' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.867309' ,`Longitude` = '-95.313865' ,`PhotoCount` = '29' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '255000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Shoreline' ,`StreetNumber` = '300' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is your 1.19 Acres waterfront dream get away or permanent living 48x24 Metal building with 1152 SQFT loft apartment.\r\nProperty feature 170 feet warfront, newly built loft apartment with all new appliances, 1152 SQFT of work shop, storge with RV hookups and great views from the living room and balcony.' ,`Acres` = '1.189' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKESIDE VILLAGE #2, LOT 333, 334, & E 1/2 OF 335,' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '51836' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '92' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Lakeside Village #2' ,`TaxAmount` = '920' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016449' WHERE `Matrix_Unique_ID` = '212453894' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:28:14.433' ,`MLSNumber` = '60226797' ,`ListAgentFullName` = 'Autumn Brown Ewald' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772312' ,`Longitude` = '-96.012818' ,`PhotoCount` = '41' ,`PostalCode` = '77423' ,`RoomCount` = '11' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Melba' ,`StreetNumber` = '715' ,`StreetSuffix` = 'Lane' ,`City` = 'Brookshire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2917' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful country home sitting on picturesque 5.5 acres. Located only a few minutes off I-10 and 10 minutes west of Katy. You can have the best of both with shopping and restaurants close to home, but the quietness that comes with country living. This house is full of large rooms and is great for entertaining. Downstairs has hardwood floors and plantation shutters. The kitchen is perfect for hosting with room for two refrigerators, double oven, plenty of counter space and a double dishwasher. Kitchen also has tons of cabinet space, under cabinet lighting and granite counters. Upstairs has a massive game room and a wet bar. House has a newly installed whole home generator. (‘21) Also recently installed new aerobic septic system. No mud tax’s or HOA! Water comes from a private well and goes thru a whole house water softener. Horses, goats, and chickens are welcome! There is a large garden area with a gazebo. House hasn’t flooded. Come check this house out, you won’t want to miss it!' ,`Acres` = '5.57' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'S663000 PEACH RIDGE ESTATES BLK 5 LOT 0 ACRES 5.57' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Wooded' ,`LotSize` = '242629' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Peach Ridge Estates' ,`TaxAmount` = '8917' ,`TaxRate` = '2.0226' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016449' WHERE `Matrix_Unique_ID` = '212468567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:35:19.830' ,`MLSNumber` = '92008689' ,`ListAgentFullName` = 'Laura LoGiudice' ,`ListOfficeName` = 'Re/Max Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023911' ,`Longitude` = '-95.576877' ,`PhotoCount` = '36' ,`PostalCode` = '77375' ,`RoomCount` = '11' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Memorial Way' ,`StreetNumber` = '10007' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Offer Received...waiting on checks* GREAT CORNER LOT and close to Klein Cain HS. Owners have taken great care of this fantastic home. HCAD has incorrect square footage and number of beds/baths per the seller. NEW Tile flooring 2022, NEW wood flooring throughout home 2019, Tankless Water Heater 2021, Roof replaced 2016, NEW AC w/NEW pan 2021, sprinkler system front and back, NEW microwave 2022. Kitchen has great Granite countertops with tons of cabinet storage and opens up to the large, two-story family room. Huge primary bedroom with ensuite bath, Upstairs find a large game room, and good size secondary bedrooms, with two full baths. The covered patio provides great outdoor entertaining, and the concrete has just been painted. The home boasts beautiful natural light, an easy and spacious floor plan, and is ready for you to tour today!' ,`Acres` = '0.2214' ,`Area` = '14' ,`BuilderName` = 'Gehan' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 MEMORIAL SPRINGS SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9646' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Springs' ,`TaxAmount` = '6300' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016449' WHERE `Matrix_Unique_ID` = '212481560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:39:25.850' ,`MLSNumber` = '26132545' ,`ListAgentFullName` = 'Tiffani Reynolds' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.017560' ,`Longitude` = '-95.301660' ,`PhotoCount` = '28' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Chancewood' ,`StreetNumber` = '8135' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1800+ Square feet of room and a recently remodeled interior! This MOVE-IN ready home has granite countertops in the kitchen and bathrooms, and new and modern laminate flooring. This home features 3 bedrooms, 2 and a half bathrooms, a large kitchen pantry, and a covered back patio. Plenty of room for fun and entertainment in this home. With the half bathroom downstairs, your guests will never have to go upstairs. There is room in the driveway for parking 2 cars. You won\'t find a larger backyard for this price! This one is ready to be your next home or investment property. Schedule your showing today!' ,`Acres` = '0.0964' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 2 KENSWICK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Forest' ,`TaxAmount` = '4225' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016449' WHERE `Matrix_Unique_ID` = '212572007' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:02:55.590' ,`MLSNumber` = '35389007' ,`ListAgentFullName` = 'Faylene Defrancis' ,`ListOfficeName` = 'Century Properties Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.674978' ,`Longitude` = '-95.142514' ,`PhotoCount` = '29' ,`PostalCode` = '77503' ,`RoomCount` = '5' ,`ListPrice` = '234900.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsdale' ,`StreetNumber` = '4419' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautifully remodeled 3/2/1 home in quiet, established neighborhood! *new kitchen cabinetry with granite countertops & subway backsplash * new laminate flooring throughout * remodeled existing bathroom w/new vanity, shower, & subway backsplash * added additional full bath w/shower in primary bedroom * nicely sized secondary bedrooms w/one having french doors leading to covered patio/deck area (great for entertaining or just relaxing!) * freshly painted * completely redone patio/deck area w/LED lighting * water heater-2022 * Hardie plank siding-2008 * double paned windows-2008 * Roof-2006 * large fenced backyard * 1-car attached garage w/A/C vent if you\'d like to convert to extra room & newly poured concrete floor * Deer Park ISD * fresh landscaping in front * convenient access to Beltway 8 & shopping * A MUST SEE!!!' ,`Acres` = '0.1653' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 4 SOUTH PASADENA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEEPWATER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEEPWATER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Pasadena' ,`TaxAmount` = '2350' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016450' WHERE `Matrix_Unique_ID` = '212572261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:46:14.880' ,`MLSNumber` = '90895217' ,`ListAgentFullName` = 'Dustan Gawthorp' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788973' ,`Longitude` = '-95.580858' ,`PhotoCount` = '18' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Sherwood Forest Glen' ,`StreetNumber` = '1215' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This three-story home rivals new construction at a fraction of the cost. Welcome home to Sherwood Forest Glen, an exclusive gated community in West Houston zoned to award winning Spring Branch ISD. Step into the entry with Terrazzo flooring that flows into an expansive first floor living and entertainment space with hardwood floors, floor to ceiling windows, and abundant natural light. Walk outside to your private backyard garden with serenity and calmness, also perfect for that social BBQ gathering. Three generously sized bedrooms and two bathrooms are found on the second floor living space for your retreat. The third-floor space offers an additional flex room with full bath for your overnight guests, an office, or possibly a media room for a relaxing evening. The location has convenient access to all major freeways, shopping and dining experiences around the energy corridor and Memorial areas. Call today to schedule your private viewing of this impressive home before its gone.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '2451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'SHERWOOD FOREST GLEN' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016450' WHERE `Matrix_Unique_ID` = '212682425' --> 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','212690431','1665016450','212690431','2022-10-05T07:11:35.940','61700461','Milly Kammerdiener','Newhomeprograms.com LLC','','','29.812136','-95.693465','38','77084','7','315000.00','Active','Intrepid Elm','2954','Street','Houston','2','0','4','2346','Single-Family','Beautiful freshly painted one story 4 bedroom 2 bath home on an oversized lot in the Oak Ridge Place Community. Katy school District. Energy efficient home with window solar screens that will help with your energy usage. No carpet. Tile and wood. This area did not flood during Harvey. The home has never flooded. Racks in the utility room and Primary Bedroom closet from the container store. Ceiling fan remote controls in each bedroom and living area. Island in the kitchen and 42 inch cabinets and walk-in pantry. Gas fire place in the open living area. Extra storage outside in the shed tucked in away in extra side space in the backyard. New AC at end of 2021 and new dishwasher.','0.2023','25','','','','','Mud,Sellers Disclosure','1','Gas Connections','1','Katy - North','Central Gas','1','LT 7 BLK 4 OAK RIDGE PLACE SEC 6','Subdivision Lot','8814','Appraisal District','','540','0','','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','30 - Katy','MAYDE CREEK ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','MAYDE CREEK JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Oak Ridge Place Sec 06','','','Water District','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:38:37.917' ,`MLSNumber` = '15391027' ,`ListAgentFullName` = 'Sharon Powell' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = 'Verna Koleosho-Johnson' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '29.912174' ,`Longitude` = '-95.710425' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '490000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Holloway Cliff' ,`StreetNumber` = '9214' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3085' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop the car! Do not let this Perry home located in the beautiful community of Miramesa in Cypress, pass you by! This beauty is 3085 sq. ft. of quality and relaxation with 4 bedrooms and 3 full-baths, office, media room, formal dining room, large kitchen and living room area, heated pool with outside lighting, shades on the patio and outdoor kitchen! What else do you need? Schedule your private showing today.' ,`Acres` = '0.1762' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 3 MIRABELLA SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7676' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Mirabella Sec 5' ,`TaxAmount` = '9657' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016450' WHERE `Matrix_Unique_ID` = '212738982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:20:24.723' ,`MLSNumber` = '95485313' ,`ListAgentFullName` = 'Kathleen Ruby' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157207' ,`Longitude` = '-95.473879' ,`PhotoCount` = '49' ,`PostalCode` = '77380' ,`RoomCount` = '11' ,`ListPrice` = '1049000.00' ,`Status` = 'Active' ,`StreetName` = 'Colonial Row' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spectacular Brownstone, in the highly desireable neighborhood of The Woodlands East Shore has the look and feel of modern luxury in Manhattan\'s Upper East Side. This corner lot provides privacy and natural light throughout the day. Completely renovated by architect David Baker of AD Top 100 McAlpine House and Kevin Spearman Design, featured in Veranda Magazine.Poggenpohl kitchen with Miele and Sub Zero appliances,elevator, french oak custom flooring, high end plumbing and lighting, custom millwork and much more. Nothing was compromised. The upstairs gameroom on the 4th floor has it\'s own balcony and wet bar. Walking distance to Town Center. Market Street, Cynthia Woods Pavillion, Hughes Landing and The Woodlands Mall. Gated access to garages.' ,`Acres` = '0.0644' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S774100 - PARK PLACE BROWNSTONES, BLOCK 2, LOT 13' ,`LotDesciption` = 'Corner' ,`LotSize` = '2806' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2344' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Park Place Brownstones' ,`TaxAmount` = '11568' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016450' WHERE `Matrix_Unique_ID` = '212747387' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:55:40.487' ,`MLSNumber` = '14276831' ,`ListAgentFullName` = 'Brandi Burke' ,`ListOfficeName` = 'Strong Real Estate Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.423216' ,`Longitude` = '-95.618846' ,`PhotoCount` = '33' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Brookgreen' ,`StreetNumber` = '51' ,`StreetSuffix` = 'Circle' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate and meticulously maintained golf course home in Bentwater Estates on Weiskopf #11, also close proximity to Lake Conroe. Spacious, open floor plan with golf course views from nearly every room! Generously sized kitchen, and the primary bath is a room in itself! Abundant storage throughout, walk-in closets. Currently used as 3 bedroom with study and game room, but options to use study as additional bedroom if needed and flex space. Great home for multi-generational living! Recently replaced roof, new paint throughout, vinyl flooring, upstairs flex space and full bath, plus many more updates. Nothing to do but unpack your boxes and begin enjoying the Bentwater lifestyle of golfing, boating, dining at the Country Club, day spa, swimming pool and much more!' ,`Acres` = '0.2447' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 26, BLOCK 1, LOT 7' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '10657' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '6651' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016450' WHERE `Matrix_Unique_ID` = '212789174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:34:59.190' ,`MLSNumber` = '77322925' ,`ListAgentFullName` = 'Cassandra Jester' ,`ListOfficeName` = 'LaRae Whorley Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.134102' ,`Longitude` = '-95.777576' ,`PhotoCount` = '50' ,`PostalCode` = '77355' ,`RoomCount` = '11' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Desert Willow' ,`StreetNumber` = '22807' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Multi generational home on 1/2 an acre in highly desirable Clear Creek Forest in Magnolia ISD. Open floorplan w/ wood burning rock fireplace, floating shelves & built in stay w/ home. Roof, A/C & water heater replaced in 2019 when 700 sq ft living quarters were added. Home has laminate floors, tile in bathroom, new kitchen cabinet doors w/ pull out drawers on bottom & pull out drawers in pantry. Kitchen counter had granite replaced in 2020, stove w/ double oven replaced in 2020 along w/ new light fixtures, island stays. Primary bath & guest bath were updated in 2020 w/ custom cabinets in both, primary shower was updated during remodel w/ brick all around. Primary closet was extended 4\' w/ custom built ins & an additional closet in primary. Living quarters offer a kitchenette w/ custom built cabinets, w/ granite & space for a refrigerator, separate entrance off the new deck. Quarters bath has ADA support bars & built in bench & custom built cabinets. Large bedroom w/ large closet.' ,`Acres` = '0.5' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CLEAR CREEK FOREST 12, BLOCK 8, LOT 9, ACRES 0.500' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21781' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '212' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'J.L. LYON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Creek Forest 12' ,`TaxAmount` = '5645' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016450' WHERE `Matrix_Unique_ID` = '212857936' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:59:20.397' ,`MLSNumber` = '13199976' ,`ListAgentFullName` = 'Leeanne Dyment' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = 'Wanda Taylor' ,`SellingOfficeName` = 'Taylor Real Estate Group, Inc.' ,`Latitude` = '29.757330' ,`Longitude` = '-95.615630' ,`PhotoCount` = '20' ,`PostalCode` = '77077' ,`RoomCount` = '7' ,`ListPrice` = '284900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Briar Forest' ,`StreetNumber` = '12800' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1534' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This move in ready beautiful Briar Forest home has been tastefully renovated with neutral design selections. Top to bottom, inside and out, not one surface has been left untouched. It\'s ready for you to move in and make it your own. NEW ROOF 2020, NEW WATER HEATER 2021, NEW FURNACE 2021, NEW A/C 2021! The outside siding and fascia have been updated to hardie plank and freshly painted. This home is low maintenance and ready to go! DID NOT FLOOD during Harvey! Don\'t let this one pass by.' ,`Acres` = '0.1102' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TR 75 BLK 2 STONEHENGE' ,`LotDesciption` = 'Cul-De-Sac,Patio Lot,Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '942' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Contemporary/Modern,Other Style,Ranch,Traditional' ,`Subdivision` = 'Stonehenge' ,`TaxAmount` = '5486' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016451' WHERE `Matrix_Unique_ID` = '212867409' --> 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','212920593','1665016451','212920593','2022-10-05T07:16:27.657','78861728','Maria Navejas','Realty ONE Group, Experience','','','30.387791','-95.492226','44','77304','12','360000.00','Active','Hanover','4','Lane','Panorama Village','2','1','3','2088','Single-Family','1-story New Construction home in the Panorama Village Golf Course Community features a welcoming front porch with a tongue and groove ceiling plus an entryway open to the dining room. Flooring upgrades include wood look vinyl plank throughout the home, with tile in the bathrooms, Bonus NO Carpet. The kitchen is central to the home and open to the flex room and family room. It features a, stainless steel appliances, a large island, pot filler, a walk in pantry and gray cabinets that are soft close with undermount lighting. The family room features a fireplace with built ins around it, and plenty of windows. Master bath includes a soaker tub, separate shower, and His and Hers vanities, plus let\'s not forget to mention the oversized Walk in closet with built ins. The 21x5 covered back patio is also accented with a tongue and groove ceiling.','0.3543','39','BT Grace Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gaslog Fireplace,Wood Burning Fireplace','1','Lake Conroe Area','Central Gas','0','S772502 - PANORAMA-HIWON 02, LOT 4','Cleared,In Golf Course Community,Subdivision Lot','15432','Appraisal District','','','1','Never Lived In','2','Single Oven','0','','','Gas Range','','Composition','56 - Willis','LAGWAY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Builder','1','Traditional','Panorama-Hiwon 02','','2.4982','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:33:39.180' ,`MLSNumber` = '64049230' ,`ListAgentFullName` = 'Georgian Landau' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = 'Brooke Anop' ,`SellingOfficeName` = 'Texastar Properties' ,`Latitude` = '29.969741' ,`Longitude` = '-95.660224' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '559900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ashton Hills' ,`StreetNumber` = '13511' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous renovated home is amazing! The moment you enter, you will notice the high ceilings and a bright airy floor plan, and all chic finishing touches! Renovations include new roof, new HVAC and ducts, new insulation, new water heaters, new appliances, new toiles, sinks, and faucets, new light fixtures & celling fans, new quartz counter tops, new porcelain tile in all wet areas, new wide-format baseboards, all new flooring, fresh paint, new frameless shower door, new gutters in front and garage, new cedar fence, new electrical receptacles. You will love the chic style of the satin gold and matte black hardware throughout, along with the upgraded stainless sink with gliding tray, and high-end Kitchen Aid induction stove. The home has a full sprinkler system, a 3-car tandem garage, and has a huge backyard with covered flagstone patio, and a wood playset for the kiddos. It is situated on a cul-de-sac street and walking distance to community trails and parks. NEVER FLOODED' ,`Acres` = '0.2474' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 1 COLES CROSSING SEC 9' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding 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,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'COLES CROSSING' ,`TaxAmount` = '8634' ,`TaxRate` = '2.531' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016451' WHERE `Matrix_Unique_ID` = '212926770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:21:18.497' ,`MLSNumber` = '37728759' ,`ListAgentFullName` = 'Tisha Matticks' ,`ListOfficeName` = 'Matticks Real Estate &' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.493155' ,`Longitude` = '-95.025040' ,`PhotoCount` = '45' ,`PostalCode` = '77371' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Creek' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Drive' ,`City` = 'Shepherd' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy this quite Brick Single Family Home located in the serenity of Sam Houston Forest located not faraway. Three bedroom, two baths, dining area with living with a wood burning fireplace and mantel. Kitchen with lots of cabinets and U-shape counter space. Fridge (dated fridge, good as a secondary fridge) will remain with property. Master Bedroom consist of a Window AC for those that like rooms extra cold without freezing the guest bedrooms.\r\nDouble vehicle garage, with a double vehicle carport. Small workshop in the rear of the garage. Lots of back yard, large enough to add a swimming pool. Back & Front Porch. Garden area around the side and front for all you Garden Growing Farmers. The owner put extra money into his driveway so it will last for many years out. This home is none restricted and easy access to Hwy 150 or FM 2025. All furniture is For Sale as well.' ,`Acres` = '0.3874' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COZY FOREST, BLOCK A, LOT 10 & 11, the N 25\'' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '130 - Shepherd' ,`SchoolElementary` = 'SHEPHERD PRIMARY SCHOOL' ,`SchoolHigh` = 'SHEPHERD HIGH SCHOOL' ,`SchoolMiddle` = 'SHEPHERD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cozy Forest' ,`TaxAmount` = '2528' ,`TaxRate` = '1.8509' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665016451' WHERE `Matrix_Unique_ID` = '213022055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:59:42.220' ,`MLSNumber` = '12690440' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771674' ,`Longitude` = '-95.428909' ,`PhotoCount` = '34' ,`PostalCode` = '77007' ,`RoomCount` = '6' ,`ListPrice` = '1595000.00' ,`Status` = 'Active' ,`StreetName` = 'Haskell' ,`StreetNumber` = '6508' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3927' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This custom-built modern oasis is superbly situated on one of only two streets that border Memorial Park. The open concept first floor living features a custom designed kitchen, tuxedo style cabinets by Madeval, Calcutta Gold quartz countertops/backsplash, Sub-Zero/Wolf appliances & 140 bottle dual-zone wine fridge. Living area features bi-folding glass doors that fully open to a private courtyard enveloped in greenery. The second level Master Retreat features White Oak floors, expansive master bath with freestanding tub & spacious walk-in shower complete with Hansgrohe rain/shower heads and large walk-in closet. The third floor is home to a game/media room and covered veranda with expansive Memorial Park views. There are 2 additional guest suites in total plus a bonus wellness room complete with infrared sauna and hot/cold plunge tub. Monitored home security system, neighborhood mobile patrol security. Full home automation and audio by Control4. Pool is possible. A must see!' ,`Acres` = '0.0603' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Park' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 ONPOINT PARK VIEWS' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2625' ,`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` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Camp Logan' ,`TaxAmount` = '23516' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016451' WHERE `Matrix_Unique_ID` = '213023411' --> 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','213065489','1665016451','213065489','2022-10-05T07:30:12.687','48688446','Daniel DiPetta','Bayou City Realty, LLC','','','29.817604','-95.041477','31','77562','7','239999.00','Active','Julie','511','Lane','Highlands','2','0','3','1548','Single-Family','Come take a look at this freshly remodeled property tucked away in a mature neighborhood of Highlands! This property includes many upgrades which are; new AC, new flooring, new paint, new appliances, granite counter tops, remodeled bathrooms, and many more! Schedule a showing to view before it\'s gone, guaranteed to sell!','0.2448','2','','','','','Mud,Sellers Disclosure','','','1','Baytown/Harris County','Central Gas','0','LT 5 FRANKS COUNTRY MANOR','Subdivision Lot','10665','Appraisal District','','','0','','2','','1','Gunite','','','','Composition','23 - Goose Creek Consolidated','HOPPER/HIGHLANDS ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Franks Country Manor','4390','2.575','Water District','1984','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:04:47.740' ,`MLSNumber` = '11446095' ,`ListAgentFullName` = 'Charity Stokes' ,`ListOfficeName` = 'BCS Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874047' ,`Longitude` = '-95.675657' ,`PhotoCount` = '25' ,`PostalCode` = '77084' ,`RoomCount` = '3' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Fieldglen' ,`StreetNumber` = '17515' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '1420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story 3 bedroom 2 bath home on a curl-de-sac in Northglen. This home features newly redone floors, updated bathrooms, granite countertops, large all brick fireplace and built-ins. Primary bedroom has large walk in closet and private bath. Spacious living room that is open to the kitchen and cozy dining area. The home is on a beautiful lot with mature trees, fully fenced backyard, covered patio and no backyard neighbors!' ,`Acres` = '0.1515' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 LESS W 2 FT BLK 13 NORTHGLEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '242' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'METCALF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northglen Sec 01' ,`TaxAmount` = '4275' ,`TaxRate` = '2.706' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016451' WHERE `Matrix_Unique_ID` = '213067066' --> 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','213118845','1665016452','213118845','2022-10-05T07:07:33.877','72089061','Penny Salter','Penny Salter Properties','','','29.325733','-94.934328','40','77563','7','314900.00','Active','Redfish','997','Street','Bayou Vista','2','0','2','1464','Single-Family','Waterfront living! 2-1 up with open kitchen area to the living room, tons of cabinets, ss refrigerator to stay, bathroom has garden tub w/tile surround, updated vanity and fixture, both bedrooms nice size. AC & heat approx 2 yrs. Gameroom/bedroom down with full bath and utility room, gameroom & utility w/epoxy painted flooring, custom bar, perfect for those fun filled party times, 60 ft wide lot, canal front, recent vinyl bulkhead, new pilings in place for the future boathouse of your dreams, upper deck and covered lower deck for entertaining. Outer stairs recently replaced, some siding cement board. Carport with 3 bays. Fishing, crabbing time to enjoy the life living on the water.','0.1255','33','','','Washer Connections','','Mud,Sellers Disclosure','1','','','Bayou Vista','Central Gas','0','ABST 7 S C BUNDICK SUR LOT 997 NEW BAYOU VISTA ADDN 8','Subdivision Lot,Waterfront','5467','Appraisal District','','','0','','1','Freestanding Oven','0','','','Gas Range','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','New Bayou Vista 8','6116','2.635','Public Sewer,Public Water,Water District','1974','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213202049','1665016452','213202049','2022-10-05T07:48:35.967','6321269','Gregory Stenger','Texas Southwest Real Estate','','','29.699491','-95.817889','11','77494','5','420000.00','Active','Herons Grove','9503','Lane','Katy','2','0','4','2169','Single-Family','Great location! Great Katy Schools! Close to everything! Single story - 4 bedroom - 2 bath home with 2169 square feet. Large Backyard for a pool or just fun located on a large corner lot. New paint, new carpet and a new garage door completed. New light fixtures, and garage door opener installed. With low inventory in the market, see this one before it\'s gone.','0.2351','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','CINCO RANCH SOUTHWEST SEC 6, BLOCK 2, LOT 15','Corner','10239','Appraisal District','','1150','0','','2','','0','','','Gas Range','','Composition','30 - Katy','STANLEY ELEMENTARY SCHOOL','SEVEN LAKES HIGH SCHOOL','SEVEN LAKES JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Cinco Ranch Southwest Sec 6','7684','2.7845','Water District','2008','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:31:28.080' ,`MLSNumber` = '12299352' ,`ListAgentFullName` = 'Rocio Guajardo' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080339' ,`Longitude` = '-95.031132' ,`PhotoCount` = '31' ,`PostalCode` = '77535' ,`RoomCount` = '8' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 6242' ,`StreetNumber` = '303' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream new built Home sitting on 1 ACRE!\r\nCustom Kitchen cabinets, massive custom built kitchen island with beautiful granite, huge master bathroom with separate shower and tub, large size closets, luxury vinyl floors, brick on all 4 sides of the house, rain gutters... just to mention a few of the many great features this lovely Home has to offer.\r\nYou don\'t want to miss this one out. Call today to schedule a viewing and make this house your new Home!' ,`Acres` = '1' ,`Area` = '52' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000764 A G PENN #1006, TRACT 40, ACRES 3.46 (1 Acre)' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'A G Penn' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016452' WHERE `Matrix_Unique_ID` = '213206928' --> 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','213233503','1665016452','213233503','2022-10-05T07:27:14.113','51816202','Andrew Gordon','Compass RE Texas, LLC','','','30.225423','-95.556369','39','77354','8','329900.00','Active','Weisinger','5815','Drive','Magnolia','2','0','4','1889','Single-Family','','0.4591','15','Precision Homes','','','','Sellers Disclosure','1','Freestanding,Gas Connections','1','Magnolia/1488 East','Central Gas','1','WESTWOOD 03, BLOCK 12, LOT 40','Cleared,Subdivision Lot','20000','Appraisal District','','225','0','','2','','0','','','','','Composition','36 - Magnolia','TOM R. ELLISOR ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Leave Business Card,Supra Keybox','Appraisal','1','Ranch,Traditional','Westwood 03','5389','1.8587','Public Water,Septic Tank','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213254110','1665016452','213254110','2022-10-05T07:30:57.330','79400205','Neil Silverman','Bernstein Realty, Inc.','','','29.683388','-95.490770','43','77096','10','485000.00','Active','Jason','5727','Street','Houston','2','1','4','2515','Single-Family','Spacious 4 bedroom, 2.5 bath home in Meyerland, zoned to Bellaire Highschool. Home has formal dining and\r\nliving room as well as spacious family room. Good size kitchen with plenty of cabinets, ample counter space,\r\nas well as a breakfast room area. All bedrooms are good size. Great backyard, spacious enough for\r\nentertaining and adding a pool. FANTASTIC Location, zoned to Bellaire HS, short drive to Medical Center, Galleria, and Downtown. Room dimensions are approximate, please verify as well as school(s)\r\nenrollment availability that property is zoned for.(*Roof replaced March of 2016, *Never Flooded. *Per Seller)','0.2197','20','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Meyerland Area','Central Electric','1','LT 8 BLK 10 MEYERLAND SEC 10','Subdivision Lot','9569','Appraisal District','','480','0','','1','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','HEROD ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','FONDREN MIDDLE SCHOOL','Appointment Required,Lockbox Back,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Ranch,Traditional','Meyerland Sec 10','9117','2.3307','Public Sewer,Public Water','1967','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T06:12:47.727' ,`MLSNumber` = '3075805' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838029' ,`Longitude` = '-95.693304' ,`PhotoCount` = '10' ,`PostalCode` = '77084' ,`RoomCount` = '15' ,`ListPrice` = '493445.00' ,`Status` = 'Active' ,`StreetName` = 'Gardens End' ,`StreetNumber` = '18127' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is under construction.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lakewood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '710' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks' ,`TaxAmount` = '' ,`TaxRate` = '2.85' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665016452' WHERE `Matrix_Unique_ID` = '213255601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:41:26.083' ,`MLSNumber` = '95511473' ,`ListAgentFullName` = 'Mike Schroeder' ,`ListOfficeName` = 'RE/MAX Preferred Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.866056' ,`Longitude` = '-95.726316' ,`PhotoCount` = '13' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Young Meadows' ,`StreetNumber` = '20915' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Now is your opportunity to live in the popular Lakeville community. This beautiful one-story home offers 3 bedrooms and 2 baths. The family room is generous in space and can be used to fit your needs. The lovely open kitchen includes granite counter tops, a large island and all appliances including the refrigerator. Washer and Dryer are also included. If you have pets or kids or both, you love the private fenced backyard!' ,`Acres` = '0.0943' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 5 LAKEVILLE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4107' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeville Sec 01' ,`TaxAmount` = '4731' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016452' WHERE `Matrix_Unique_ID` = '213262378' --> 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','213280448','1665016452','213280448','2022-10-05T07:44:11.940','81686301','Mike Schroeder','RE/MAX Preferred Homes','','','30.011820','-95.748248','0','77433','10','433000.00','Active','Golden Sycamore','20827','Trail','Cypress','2','1','4','3249','Single-Family','Welcome home to this fabulous 2-story traditional home located in the heart of masterplanned community Fairfield. Attached 2 car garage. Welcome in to light and bright entry with formal dining and large living room. Kitchen opens to living with lots of counter space and walk in pantry. Primary bedroom down with primary bathroom having double sinks, soaking tub, and stand up shower. Also has study/home office downstairs. Three bedrooms with gameroom upstairs. Secondary bath includes double sinks. Step outside the backyard to covered patio with sparkling pool/spa and waterfall. Conveniently located near shopping and dining. Roof 2022','0.205','35','','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Gas Connections','1','Cypress North','Central Gas','1','LT 2 BLK 4 FAIRFIELD VILLAGE WEST SEC 14','Subdivision Lot','8930','Appraisal District','','1100','0','','2','Double Oven,Gas Oven','1','In Ground','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','KEITH ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Fairfield Village West Sec 14','8383','2.616','Public Sewer,Public Water','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-05T07:43:53.220' ,`MLSNumber` = '83387864' ,`ListAgentFullName` = 'Mario Mendoza' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.641266' ,`Longitude` = '-95.294865' ,`PhotoCount` = '1' ,`PostalCode` = '77061' ,`RoomCount` = '3' ,`ListPrice` = '158900.00' ,`Status` = 'Active' ,`StreetName` = 'Koala' ,`StreetNumber` = '8710' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '965' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please no not disturb occupants. NO HOA AND LOW PROPERTY TAXES. Note, the Sq. Ft. is not accurate as the garage was converted. \r\n The house is livable and ready to move in. This house has so much potential. Investors, put in your offers. This house is priced to sell quick! Selling As-Is. No Repairs will be made. Location, a few steps from Hobby Airport, minutes to the medical center and all stadiums. Call for your private tour.' ,`Acres` = '0.2149' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 111 ALLEN FARMS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DEANDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Allen Farms Sec 02' ,`TaxAmount` = '1314' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665016452' WHERE `Matrix_Unique_ID` = '213305447' --> 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','213313310','1665016452','213313310','2022-10-05T06:43:02.347','40371443','Mack Neff','eXp Realty, LLC','','','30.158196','-95.674751','30','77362','11','559900.00','Active','Short Leaf Pine','34303','Court','Pinehurst','3','1','4','3511','Single-Family','Beautiful Ashton Woods home with tons of upgrades! Built to entertain family and friends! Rare single story floor plan in Woodtrace with a media room & separate game room, high ceilings and gorgeous wood floors. Upgraded finishes throughout the entire home- this home has it all! Beautifully maintained kitchen with Quartz countertops, upgraded appliances, & huge center island that sits 8! Upgraded light fixtures, central vacuum system and kick plate dust pans, each room is wired for sound. Great media room just off the kitchen, and all the furniture and equipment is included! The corner lot affords spacious privacy. Just minutes from walking and biking trails, parks and playgrounds and mixed-use shopping and dining areas. See Documents section for Upgrades List on all the home features, along with a complete floor plan. Come see all this home has to offer today!','0.2821','15','','','Electric Dryer Connections,Gas Dryer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Tomball','Central Gas','1','WOODTRACE 02, BLOCK 3, LOT 34','Corner','12287','Appraisal District','','1200','0','','3','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','53 - Tomball','DECKER PRAIRIE ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Woodtrace 02','13735','3.2015','Water District','2014','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213313711','1665016452','213313711','2022-10-05T07:05:39.577','84155231','David Pokorny','Thrive Property Group','','','29.465947','-95.059371','9','77539','3','185000.00','Active','Ave G','3226','','Dickinson','1','0','3','1111','Single-Family','Home is an 1,111 SF home built in 1972 on a 5,500 SF lot. Home has been remodeled with new tile and flooring throughout.','','33','','','','','Other Disclosures','','','','Dickinson','Central Electric','0','ABST 19 PERRY & AUSTIN SUR LOT 17 FALCO SUB','Subdivision Lot','5500','Appraisal District','','','0','','1','','0','','','','','Composition','17 - Dickinson','CALDER ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Central Park - Dickinson','','','Public Sewer,Public Water','1972','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213313834','1665016453','213313834','2022-10-05T06:50:23.617','53611711','Kathy Matt','Elite Texas Properties','','','29.982973','-95.705249','50','77429','11','369900.00','Active','Auburn Woods','18426','Drive','Cypress','2','0','3','2395','Single-Family','Totally Updated 4/2/2 One-Story in Cypress Mill features open floor plan, lots of closet space and the Kitchen/Breakfast/Family Room are all open to each other. There is a Living Room/Dining Room Combo near the Entry and the 4th bedroom is currently accessed thru double French doors. It has a closet and is now being used as a Home Office. This home has Recent flooring, updated Kitchen and Bathrooms and fresh interior paint. The Large Backyard has a deck and pergola. Located jut minutes from Hwy. 290, the Beltway, the Grand Parkway and to restaurants, shopping and medical offices. This home is Move-In Ready and is situated in the Highly Acclaimed Cy Fair School District.','0.1531','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','1','Cypress North','Central Gas','1','LT 7 BLK 1 CYPRESS MILL SEC 1','Subdivision Lot','6670','Appraisal District','','640','0','','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','13 - Cypress-Fairbanks','A ROBISON ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Cypress Mill','6776','2.761','Public Sewer,Public Water,Water District','1996','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213314282','1665016453','213314282','2022-10-05T07:47:41.120','23626211','Lyssa Lechuga','New Home Star Texas, LLC','','','29.376370','-94.980173','22','77568','4','224579.00','Active','Kansas','1905','Street','La Marque','2','1','4','1770','Single-Family','No HOA! Ready for move-in!\r\nThis 2 story plan with 4 bedrooms, 2 and a half baths, is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. All bedrooms are upstairs with lush carpeting in the bedrooms. 3 of the rooms have walk-in closets. Beautiful loft area at the top of the stairs. Perfect for reading or homework. Black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\n—Follow link to the builder website to see floorplan—\r\nFantastic Builder \'1-2-10\' Warranty','0.1579','33','Censeo','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','La Marque','Central Electric','0','ABST 150 J MOORE SUR LOT 27 BLK 10 MENTOR & BELL SUB','Other','6878','Appraisal District','','','1','To Be Built/Under Construction','1','Electric Oven','0','','','Electric Cooktop','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','Wharton A jackson','9620','','Public Sewer,Public Water','2022','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213314758','1665016453','213314758','2022-10-05T07:58:54.080','74143788','Lyssa Lechuga','New Home Star Texas, LLC','','','29.732148','-94.965178','22','77520','4','234999.00','Active','E DeFee','209','Avenue','Baytown','2','1','4','1770','Single-Family','No HOA! Under construction. Set to be complete Winter of 2022-23. Ready for tour NOW.\r\nThis 2 story plan with 4 bedrooms, 2 and a half baths, is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. All bedrooms are upstairs with lush carpeting in the bedrooms. 3 of the rooms have walk-in closets. Beautiful loft area at the top of the stairs. Perfect for reading or homework. Black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\n—Follow link to the builder website to see floorplan—\r\nFantastic Builder \'1-2-10\' Warranty','','2','Censeo','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Baytown/Harris County','Central Electric','0','LT 4 BLK 12 GOOSE CREEK TOWNSITE','Other','','Appraisal District','','','1','To Be Built/Under Construction','1','Electric Oven','0','','','Electric Cooktop','','Composition','23 - Goose Creek Consolidated','ASHBEL SMITH ELEMENTARY SCHOOL','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','Wharton A jackson','','','Public Sewer,Public Water','2022','Appraisal District'); --> New record created successfully