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-18T07:54:32.010' ,`MLSNumber` = '89475382' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998753' ,`Longitude` = '-95.465817' ,`PhotoCount` = '26' ,`PostalCode` = '77014' ,`RoomCount` = '6' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Bammel Oaks' ,`StreetNumber` = '15467' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two story home with fantastic open layout. Neutral colors and wood look floors will allow you to make this home your own. All three bedrooms are conveniently located upstairs. Spend time outdoors in this spacious and welcoming backyard. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.0765' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 5 BAMMEL VILLAGE SEC 02 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '3334' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MAJOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bammel Village Sec 02 Rep 01' ,`TaxAmount` = '5033' ,`TaxRate` = '2.8192' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202681' WHERE `Matrix_Unique_ID` = '207188922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:08:00.407' ,`MLSNumber` = '28758937' ,`ListAgentFullName` = 'Ericka Spencer' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045104' ,`Longitude` = '-95.107935' ,`PhotoCount` = '23' ,`PostalCode` = '77336' ,`RoomCount` = '9' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Springwater' ,`StreetNumber` = '512' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Move-in ready by Fall 2022! Gorgeous new construction by Jjames\r\nConstruction Company LLC. This stunning two-story floor plan with private driveway and remote\r\nsecurity gate, offers an open concept living & kitchen area on the first floor that extends to a\r\nspacious fenced backyard. Primary suite and 2 secondary bedrooms on the second floor.\r\nUpgraded finishes throughout including smart home system, Quartz counter tops, stainless-\r\nsteel appliances & upgraded cabinets with soft close drawers & doors. Primary bedroom offers\r\na large walk-in closet and BEAUTIFUL en-suite bathroom w/free standing tub and separate\r\nwalk-in shower. Nestled in the Water Wonderland Community which has nature trails, two\r\nprivate gated parks with lake access, boat ramps, and picnic pavilions. Nearby shopping is\r\nlocated in Atascocita/Kingwood. Photos are from a previous home with the same floor plan by the builder. Finishes may vary' ,`Acres` = '0.1263' ,`Area` = '1' ,`BuilderName` = 'Jjames Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'E 1/2 OF LT 99 WATER WONDERLAND U/R' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Craftsman,Other Style' ,`Subdivision` = 'Water Wonderland U/R' ,`TaxAmount` = '529' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666202682' WHERE `Matrix_Unique_ID` = '208003400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:32:41.143' ,`MLSNumber` = '23126581' ,`ListAgentFullName` = 'Kathryn Robinson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Amy Dunlap' ,`SellingOfficeName` = 'Abundant Living Real Estate' ,`Latitude` = '29.647226' ,`Longitude` = '-95.747221' ,`PhotoCount` = '48' ,`PostalCode` = '77406' ,`RoomCount` = '11' ,`ListPrice` = '640000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Upland Manor' ,`StreetNumber` = '21107' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3713' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning One Story with Courtyard and Casita! The home built by Highland Homes is one of the most desired floor plans. The oversized Courtyard is perfectly designed for outdoor living with both covered and open areas for relaxation. Just off to the left is the private entrance to the Casita, which features a mini kitchenette, large bedroom, and luxurious ensuite bath which will make any guests feel right at home! The foyer shows off the homes\' high vaulted ceilings, ample natural lighting, and welcomes you into the Great Room featuring a custom floor to ceiling stone fireplace. The kitchen is what chef\'s dream area made of, with plenty of custom cabinetry, granite countertops, double oven, gas cooktop, an oversized entertaining island, and built-in desk area. The entire home, including the owner\'s escape features tons of upgrades. This is one home you do not want to miss out on!' ,`Acres` = '0.2957' ,`Area` = '37' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LONG MEADOW FARMS SEC 33, BLOCK 1, LOT 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Long Meadow Farms Sec 33' ,`TaxAmount` = '11825' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202682' WHERE `Matrix_Unique_ID` = '208098111' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:06:36.917' ,`MLSNumber` = '89499507' ,`ListAgentFullName` = 'Ericka Spencer' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043437' ,`Longitude` = '-95.112656' ,`PhotoCount` = '21' ,`PostalCode` = '77336' ,`RoomCount` = '9' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Beaver Run Drive' ,`StreetNumber` = '25707' ,`StreetSuffix` = '' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! Move-in ready by Fall 2022! Gorgeous Modern Farmhouse by 5K Building and Investments, LLC. This stunning floor plan with private driveway and remote security gate, high ceilings, and \r\ngourmet kitchen with quartz kitchen countertops & stainless-steel appliances. Primary bedroom offers a large \r\nwalk-in closet and BEAUTIFUL en-suite bathroom w/free standing tub and separate walk-in shower. Other \r\namenities include patio w/50in Bluetooth T.V & speakers, large mudroom off the garage, & MORE! Nestled in \r\nthe Water Wonderland Community which has nature trails, two private gated parks with lake access, boat \r\nramps, and picnic pavilions. Nearby shopping is in Atascocita/Kingwood Expansion of FM 2100 will allow easy \r\ndrive to Houston to enjoy more great activities and events. Photos are renderings of the floor plan finishes may vary.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '5K Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 241 Water Wonderland U/R' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9638' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Craftsman' ,`Subdivision` = 'Water Wonderland' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666202682' WHERE `Matrix_Unique_ID` = '208126769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:00:06.763' ,`MLSNumber` = '70429800' ,`ListAgentFullName` = 'Tammy Locke' ,`ListOfficeName` = 'Texas Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892505' ,`Longitude` = '-94.795138' ,`PhotoCount` = '16' ,`PostalCode` = '77535' ,`RoomCount` = '9' ,`ListPrice` = '164900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 4013' ,`StreetNumber` = '252' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two Story Country Charmer with covered porch offers 4 bedrooms with possible 5th bedroom. Large family room and formal dining offer great spaces for entertaining. Property is a little over an acre with public water and septic. 20x30 Workshop available as well. Bring your vision and make this your dream home.' ,`Acres` = '1.12' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OAK MEADOWS, LOT 12, SEC 3, ACRES 1.12' ,`LotDesciption` = 'Cleared' ,`LotSize` = '48787' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Meadows' ,`TaxAmount` = '2945' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202682' WHERE `Matrix_Unique_ID` = '209200066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:10:30.057' ,`MLSNumber` = '10307762' ,`ListAgentFullName` = 'William Norfolk' ,`ListOfficeName` = 'Centerline Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.551559' ,`Longitude` = '-95.057235' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '1350000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Water Way' ,`StreetNumber` = '219' ,`StreetSuffix` = '' ,`City` = 'League City' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3964' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 219 Blue Water Way. This absolutely stunning custom home was built in 2021 in a gated community with canal access to Clear lake. The home features 5 bedrooms, 4 full baths, and a 1/2 bath inside plus a 1/2 bath outside for pool access. As you enter the home you will notice the attention to details. High ceilings with an open floor plan, great for entertaining. A beautiful view outdoors to enjoy your covered kitchen and pool. Truly resort living at its best! The gourmet kitchen inside includes all stainless appliances and a quartz waterfall island with extra seating. The kitchen is open to the family room that shares a sitting area with a wet bar. The primary bedroom has canal views and plantation shutters. Primary bathroom is spacious with a walk-in closet and built ins. There is a second downstairs bedroom with a full bath. Upstairs features 3 bedrooms and an additional area with built-in bunk beds. Seller has an elevation certificate. ck out the video tour.' ,`Acres` = '0.1791' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CASA MARINA DEL SOL (2006) ABST 18, BLOCK 1, LOT 5, ACRES 0.' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Casa Marina Del Sol 2006' ,`TaxAmount` = '3310' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202682' WHERE `Matrix_Unique_ID` = '209273426' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:53:52.887' ,`MLSNumber` = '91185488' ,`ListAgentFullName` = 'Christopher Seitz' ,`ListOfficeName` = 'The Discovery Group, Inc.' ,`SellingAgentFullName` = 'Rebecca Schuler' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.940799' ,`Longitude` = '-95.270464' ,`PhotoCount` = '41' ,`PostalCode` = '75862' ,`RoomCount` = '6' ,`ListPrice` = '149000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Post Oak' ,`StreetNumber` = '390' ,`StreetSuffix` = 'Lane' ,`City` = 'Trinity' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1037' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful house on the top of Lake Livingston in a quiet subdivision. This home has endless opportunities and sits on 3 lots in Glen Haven Estates. Access to private boat launch, fishing pier and swimming area and a 8 acre park along sandy creek. Glen Haven subdivision is nestled in beautiful East Texas, and in reasonable driving distance to larger cities, such as Hunstville, Livingston, Conroe, The Woodlands, Spring and Houston. The perfect place for weekend lake house or full time residence. This home is located within minutes of Whispering Pines Golf Club. Spectacular views await you.' ,`Acres` = '0.2066' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GLEN HAVEN ESTATES SECTION 2, BLOCK 14 LOTS 03,30,31' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (TRINITY)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Haven Estates Sec 2' ,`TaxAmount` = '1713' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202682' WHERE `Matrix_Unique_ID` = '209466909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:40:03.367' ,`MLSNumber` = '1022449' ,`ListAgentFullName` = 'Mary Wise' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = 'Charles Maley' ,`SellingOfficeName` = 'Lifestyles Realty, Inc.' ,`Latitude` = '29.151779' ,`Longitude` = '-95.026579' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '15' ,`ListPrice` = '1690000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bluewing Teal' ,`StreetNumber` = '4114' ,`StreetSuffix` = 'Court' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3027' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coastal living at its finest in the gated Sunset Cove community on Galveston\'s west end! This nearly new custom design with beautiful landscaping boasts 5 bedrooms, 4 full & 2 half baths, & an exquisite open concept with wood look tile floors, recessed lighting, & custom window shades throughout. The oversized island kitchen showcases white quartz counters, custom ceiling height cabinetry with lighting, & top-notch Viking appliances. Additionally, on this level, you\'ll find a bedroom with ensuite bath, an oversized utility room, & convenient half bath. Upstairs, find 3 additional bedrooms with ensuite baths, a built-in bunk room, & a game room. Enjoy the sunrise or sunset off your bi-level east & west-facing decks with endless views of the beach, bay, & canal. Entertain outdoors with numerous covered sitting areas, an outdoor kitchen, bath, & shower, a 2-level composite decked boathouse with a 23\'x10\' slip, boat lift, & green lights, & a fully fenced backyard with sprinkler system.' ,`Acres` = '0.2141' ,`Area` = '33' ,`BuilderName` = 'Bay Point Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNSET COVE (2005), ABST 121, BLOCK F, LOT 3, ACRES 0.214' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Waterfront' ,`LotSize` = '9327' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Cove 2005' ,`TaxAmount` = '29714' ,`TaxRate` = '2.2124' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202683' WHERE `Matrix_Unique_ID` = '209924920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:45:10.137' ,`MLSNumber` = '60568698' ,`ListAgentFullName` = 'Michael Ramirez' ,`ListOfficeName` = 'MJR Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743609' ,`Longitude` = '-95.297839' ,`PhotoCount` = '8' ,`PostalCode` = '77011' ,`RoomCount` = '1' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Navigation' ,`StreetNumber` = '7023' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0574' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Probate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 15 BLK M MAGNOLIA PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FRANKLIN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Park Sec 02' ,`TaxAmount` = '1577' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202683' WHERE `Matrix_Unique_ID` = '210316547' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:44:47.220' ,`MLSNumber` = '57510180' ,`ListAgentFullName` = 'Michael Ramirez' ,`ListOfficeName` = 'MJR Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808755' ,`Longitude` = '-95.147832' ,`PhotoCount` = '36' ,`PostalCode` = '77049' ,`RoomCount` = '9' ,`ListPrice` = '287000.00' ,`Status` = 'Active' ,`StreetName` = 'Sonoma Park' ,`StreetNumber` = '15922' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2341' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*2006 BUILD WITH 2341 SQ FT* * 4 SPACIOUS BEDROOMS WITH *GAMEROOM* 2 BATHROOMS AND 1/2* \r\n30 YEAR RIDGE VENT ROOF REPLACED A FEW YEARS AGO* CENTRAL AC HAS DUAL THERMOSTAT FEATURE \" INSPECTED AND OPERATING AS INTENDED\" ** WOOD LAMINATE FLOORS 2022 \"NO CARPET\" * PORCELAIN TILE 2022* INTERIOR PAINT 2022* SPACIOUS ISLAND KITCHEN WITH LOTS OF CABINETS AND COUNTER SPACE* QUARTZ COUNTER TOPS 2022* NEW GAS STOVE 2022* NEW DISHWASHER 2022* NEW CEILING FANS AND LOTS OF RECESSES LIGHTNING* GARAGE DOOR OPENER *' ,`Acres` = '0.1332' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 SONOMA RANCH SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sonoma Ranch Sec 06' ,`TaxAmount` = '5390' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202683' WHERE `Matrix_Unique_ID` = '210476545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:45:42.087' ,`MLSNumber` = '91581581' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.646451' ,`Longitude` = '-95.483711' ,`PhotoCount` = '17' ,`PostalCode` = '77035' ,`RoomCount` = '6' ,`ListPrice` = '339999.00' ,`Status` = 'Active' ,`StreetName` = 'Effingham' ,`StreetNumber` = '5506' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must Sell! ! Gorgeous remodeled mid-century home with a touch of modern charm concepts located in the heart of Westbury, never flooded! This beautiful 3 bedroom 2 bathroom single story home with spacious flex room, attached garage perfect to entertain guests. Conveniently located just minutes away to 90, Ft Bend Pkwy Toll, and Sam Houston Toll. Hagar Park near by! Includes endless upgrades; New roof, new custom doors, new vinyl plank floors, new carpet in bedrooms, new custom designed high ceiling cabinetry with soft close features, custom peninsula kitchen w/ quartz countertops, modern hardware, dual shower in master room, new stainless steel appliances (new gas stove top with water pot filler above stove, new single oven, new microwave, new dishwasher, new wall mount range hood with LED and carbon filters) New LED electrical lighting (breaker box included) and external LED soft lighting. Don\'t miss this delightful home.' ,`Acres` = '0.1983' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 113 WESTBURY SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westbury' ,`TaxAmount` = '4635' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202683' WHERE `Matrix_Unique_ID` = '210728455' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:53:17.210' ,`MLSNumber` = '21158207' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015178' ,`Longitude` = '-95.787702' ,`PhotoCount` = '22' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '365990.00' ,`Status` = 'Active' ,`StreetName` = 'Bainham Forest' ,`StreetNumber` = '17019' ,`StreetSuffix` = 'Trail' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to 17019 Bainham Forest Trail located in the community of Dellrose and zoned to Waller ISD. The Cheyenne floorplan features 3 bedrooms, 2 full baths, 1 half baths and an attached 2 car garage. The floorplan includes a formal dining room, kitchen that is open to the breakfast area and a large family room. You don\'t want to miss all this gorgeous home has to offer! Estimated completion is September 2022. Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Dellrose Section 11, Block 3, Lot 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6204' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Dellrose' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666202683' WHERE `Matrix_Unique_ID` = '211107192' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:51:22.210' ,`MLSNumber` = '42430291' ,`ListAgentFullName` = 'Jennifer Atkins' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.185634' ,`Longitude` = '-95.426872' ,`PhotoCount` = '30' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Noreda' ,`StreetNumber` = '704' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this 3 bedroom, 2 bath home that boasts over 1,500 sq ft. The moment you walk in you will notice the decadent floor to ceiling brick fireplace. This newly remodeled home features timeless white cabinetry throughout the kitchen complimenting the granite countertops and thoughtfully placed backsplash that ties it all in for a picture perfect kitchen. Once you step out the backdoor under the covered and enclosed screened patio you can enjoy the view of the considerable sized backyard that also includes a storage shed. \r\nFAST FACTS: 3 year old roof. Foundation repair with transferable warranty. New AC.' ,`Acres` = '0.168' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION NORTH (ANGLETON), BLOCK 2, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'PLANTATION NORTH' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202684' WHERE `Matrix_Unique_ID` = '211564658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:19:38.060' ,`MLSNumber` = '61242097' ,`ListAgentFullName` = 'LaChaunta Vanterpool' ,`ListOfficeName` = '1st Class RE Luxury Living,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973237' ,`Longitude` = '-95.206045' ,`PhotoCount` = '25' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '324999.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Shadows' ,`StreetNumber` = '16706' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully remodeled home is great for families and those who love to entertain. Upgrades include a steel wrought iron entry door, upgraded chandeliers, fresh paint neutral color w/ 4in baseboards, vinyl plank floors & tile throughout home. The kitchen has custom solid wood cabinets w/ brushed nickel hardware and stainless steel appliances. New carpet on the 2nd floor. Upgraded toilets & faucets on 1st floor. Luxurious spa tub w/ jets, stainless ceiling fan in the family room. 2 inch faux wood blinds coverings. Primary bedroom walk in closet has extra built-in shelving. The roof replaced in 2019 w/50 year warranty. Attic above garage w/floor build out for extra storage. Extended patio. ADT Security pads w/ cell tower & window sensors throughout 2nd floor. Security system cameras (Night owl -8 cameras wired, w/ DVR & 23in Display monitor included). Doorbell camera (Nightowl app must be used), & Dust to Dawn motion flood lights.Room sizes are approximate, measure for accuracy.' ,`Acres` = '0.1475' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 4 ATASCOCITA FOREST SEC 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WHISPERING PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Forest Sec 21' ,`TaxAmount` = '7256' ,`TaxRate` = '2.773' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202684' WHERE `Matrix_Unique_ID` = '211701354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:23:30.983' ,`MLSNumber` = '11610743' ,`ListAgentFullName` = 'Stephen Wilhite' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.127161' ,`Longitude` = '-95.066861' ,`PhotoCount` = '46' ,`PostalCode` = '77554' ,`RoomCount` = '11' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = '1st' ,`StreetNumber` = '4022' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Only about a 5 minute walk or 1 minute car ride to the beach, this coastal gem positioned on a 20,000 square foot lot makes the perfect vacation home or rental property. The home is essentially split into 2 independent units w/ both upstairs & downstairs boasting a kitchen, dining room & living room. The home comes fully furnished & sleeps 11. Upstairs has 2 bedrooms & a full bathroom. Downstairs has 1 bedroom, a bathroom, & a laundry room. Sit on the covered deck & enjoy peek-a-boo views of the beach & bay, hear the crashing waves & spot sea birds from the nearby bird sanctuary. The property boasts multiple storage units to house your beach toys & an outdoor shower w/ hot water & sink. The home is fully stocked & ready to go. EVERYTHING IS INCLUDED. The alarm system is wired to arm the whole house or each unit separately. The HOA provides a boat ramp & pavilion. Enjoy volleyball, ping pong, pool, or head to the beach at this chateau by the sea!' ,`Acres` = '0.4591' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR N 1/2 OF LOT 15 (15-1) BAY HARBOR' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Harbor' ,`TaxAmount` = '3211' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202684' WHERE `Matrix_Unique_ID` = '211749195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T06:56:29.490' ,`MLSNumber` = '76729462' ,`ListAgentFullName` = 'Christine Cummings' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = 'Sarah Herbek' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.775058' ,`Longitude` = '-95.372597' ,`PhotoCount` = '33' ,`PostalCode` = '77007' ,`RoomCount` = '4' ,`ListPrice` = '490000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Spring' ,`StreetNumber` = '1505' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2299' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Chic, contemporary freestanding home located in the historic First Ward Art district. This 3 bedroom, 3.5 bathroom home sits on a corner lot of a friendly, gated community. The first floor has a guest suite that can also be used as a home office or gym. Spacious open concept living space on the second level with a huge quartz island kitchen, balcony and a guest powder room. Large windows throughout with custom fit, wooden designer blinds. The primary suite is located on the third floor including two walk in closets, dual vanities, garden tub and oversized shower. A second guest suite is also located on the third floor. The entire fourth floor is a private rooftop deck with gorgeous downtown views and plenty of space to entertain. This home is surrounded by a vibrant community of local business, breweries, and restaurants. Situated on the Heights Hike and Bike trail, you have immediate access to the Heights, downtown and EaDo as well as the POST Modern Mall and Eatery.' ,`Acres` = '0.0394' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 SPRING STREET TERRACE' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '1715' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Street Terrace' ,`TaxAmount` = '9464' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202684' WHERE `Matrix_Unique_ID` = '211790365' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T06:53:33.210' ,`MLSNumber` = '3746772' ,`ListAgentFullName` = 'Cathy Nguyen' ,`ListOfficeName` = 'The Nguyens & Associates' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.074862' ,`Longitude` = '-95.209084' ,`PhotoCount` = '22' ,`PostalCode` = '77339' ,`RoomCount` = '3' ,`ListPrice` = '245000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sherwood Hollow' ,`StreetNumber` = '2238' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming well maintained brick home in the Sherwood Trails neighborhood. Laminate flooring and tile throughout home and in wet areas for updated look and low maintenance care. Spacious open living, dining, and kitchen area make entertaining a dream. Vaulted ceiling in family room and fireplace make the family room the heart of the home. Master bedroom has en-suite bathroom and walk-n closet. Fully fenced backyard adds additional out door living space to this beautiful home. Conveniently located with easy accessibility to freeways makes this a home that can\'t be missed. Come view this charming home today.' ,`Acres` = '0.1433' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 817 BLK 5 SHERWOOD TRAILS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WOODLAND HILLS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sherwood Trails Sec 04' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202684' WHERE `Matrix_Unique_ID` = '211945788' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:53:38.723' ,`MLSNumber` = '58941954' ,`ListAgentFullName` = 'Andrew Pikoff' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542286' ,`Longitude` = '-95.358682' ,`PhotoCount` = '43' ,`PostalCode` = '77584' ,`RoomCount` = '17' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Hanberry' ,`StreetNumber` = '3919' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 5 Bedroom Home with POOL. Large primary bedroom oversees lush outdoor landscaping, pool/hot tub & covered patio. Primary bathroom has an extra-large shower w/ hot/cold fan for added comfort, double vanity w/ Quartz countertops & two walk-in closets! Expansive kitchen w/ tons of space, stainless steel appliances, new quartz countertops, new hardware & new two-tone paint on cabinets. Breakfast area w/ natural light. Office/study w/ built-in cabinets & crown molding. Formal dining room w/ custom paneling & crown molding. Family Room w/ gas log fireplace, built in shelving & bar area. Upstairs boasts a massive game room, 4 large bedrooms, each with their own walk-in closet, 2 jack & Jill bathrooms and a built-in, double desk area. Extra-large pool for entertaining or just relaxing on a hot day. Entire pool, or just the hot tub, can be heated and an outdoor music system makes for great entertainment! Oversized detached garage w/ enclosed walls & epoxy floors.' ,`Acres` = '0.2054' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEPOINTE SEC 1 AT SILVERLAKE (A0548 HT&BRR) BLK 2 LOT 17' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8947' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakepointe Sec 1 At Silverlake' ,`TaxAmount` = '9673' ,`TaxRate` = '2.3537' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202685' WHERE `Matrix_Unique_ID` = '212199733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:51:11.587' ,`MLSNumber` = '26546362' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656969' ,`Longitude` = '-95.352484' ,`PhotoCount` = '14' ,`PostalCode` = '77033' ,`RoomCount` = '8' ,`ListPrice` = '173900.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 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`='1666202685' WHERE `Matrix_Unique_ID` = '212293685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:08:05.600' ,`MLSNumber` = '81065452' ,`ListAgentFullName` = 'Cory McDonald' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016963' ,`Longitude` = '-95.155647' ,`PhotoCount` = '46' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '434000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunny Shores' ,`StreetNumber` = '20503' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located in Atascocita! This property backs up to the 9th tee box and has a great view of the sunset from the backyard or inside the air conditioned sunroom. Come see this beautiful property today!' ,`Acres` = '0.2925' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 8 PINEHURST OF ATASCOCITA SEC 2' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '12740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinehurst Atascocita Sec 02' ,`TaxAmount` = '7097' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202685' WHERE `Matrix_Unique_ID` = '212679933' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T06:41:37.880' ,`MLSNumber` = '68525329' ,`ListAgentFullName` = 'Wayne Powell' ,`ListOfficeName` = 'Century 21 Parisher Prop.' ,`SellingAgentFullName` = 'Wayne Powell' ,`SellingOfficeName` = 'Century 21 Parisher Prop.' ,`Latitude` = '29.972612' ,`Longitude` = '-95.455172' ,`PhotoCount` = '22' ,`PostalCode` = '77014' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Laurel Birch' ,`StreetNumber` = '2226' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1711' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 Bedroom 2 Bath with center Island in the Kitchen, High ceilings, Fire place in a very large Living room. Home has tilled floors through out. Primary Bedroom has en-suite Bathroom with separate shower and dual Vanities. Home has a fairly new roof. This home provides easy access to I-45, the Beltway ( Sam Houston Tollway) and State HWY 249.' ,`Acres` = '0.1929' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 1 LAUREL OAKS SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '530' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'DELORAS E THOMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Laurel Oaks Sec 07' ,`TaxAmount` = '4986' ,`TaxRate` = '3.0467' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202685' WHERE `Matrix_Unique_ID` = '212688967' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:55:39.433' ,`MLSNumber` = '73411920' ,`ListAgentFullName` = 'Yuridia Gomez' ,`ListOfficeName` = 'Chrisie Jackson Property, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.452544' ,`Longitude` = '-95.900858' ,`PhotoCount` = '12' ,`PostalCode` = '77471' ,`RoomCount` = '3' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 360' ,`StreetNumber` = '3223' ,`StreetSuffix` = 'Road' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one acre lot with large mobile home.\r\nThe home is well maintained and a perfect opportunity to live now and build later,\r\nuse as an investment property or build your dream home now on this gorgeous lot.\r\nSurrounding areas such as Rosenberg, Fulshear and Sugar Land.\r\nEnjoy your own peaceful slice of the country while being within an hour of downtown Houston!\r\nRoom for RV will keep your life simple and the proximity to town gives you the best of both worlds, \r\nit is like a little country oasis with all the convenience of the city living!\r\nNO HOA! Brand new septic system, Ready to move in.' ,`Acres` = '1' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0539 S H WINSTON, MH SERIAL # C3980A & C3980B, ACRES .841, (' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'S H Winston' ,`TaxAmount` = '1140' ,`TaxRate` = '1.9957' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666202685' WHERE `Matrix_Unique_ID` = '212703452' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:47:16.213' ,`MLSNumber` = '63574620' ,`ListAgentFullName` = 'Michael Ramirez' ,`ListOfficeName` = 'MJR Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.387054' ,`Longitude` = '-94.938843' ,`PhotoCount` = '30' ,`PostalCode` = '77590' ,`RoomCount` = '7' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = '3rd' ,`StreetNumber` = '2937' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1531' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRICK HOME 1977 BUILD * ON A BIG LOT 9091 SQ FT ** 3 BEDROOMS WITH 2 FULL BATHS* 2 CAR GARAGE*** $$-NEW 30 YEAR RIDGE VENT ROOF-$$-ALL NEW CENTRAL AIR AND HEAT SYSTEM-$$- NEW KITCHEN CABINETS* NEW QUARTZ COUNTER TOPS* NEW FAUCET* JUST TEXTURED AND PAINTED ALL INTERIOR * NEW WOOD LAMINATE FLOORS* NEW PORCELAIN TILE IN KITCHEN AND BATHROOMS* ALL NEW LIGHT FIXTURES AND CEILING FANS* BOTH BATHROOMS ARE ALL UPDATED WITH NEW VANITIES, NEW TILE, NEW FAUCETS ECT. *EXTERIOR JUST PAINTED * BACK PORCH* FOUNDATION REPAIRED WITH TRANSFERABLE LIFETIME WARRANTY* GOOD LOOKING HOME*' ,`Acres` = '0.2087' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 142 R LOGAN SUR LOT 11 & W 1 FT OF LOT 12 TARIN ADDN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9091' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tarin' ,`TaxAmount` = '2776' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202686' WHERE `Matrix_Unique_ID` = '212855821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:51:53.830' ,`MLSNumber` = '88148608' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717936' ,`Longitude` = '-95.868587' ,`PhotoCount` = '20' ,`PostalCode` = '77441' ,`RoomCount` = '13' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Eden Creek' ,`StreetNumber` = '28710' ,`StreetSuffix` = 'Trail' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GRAND OPENING! OPEN HOUSE SATURDAY OCTOBER 8TH & SUNDAY OCTOBER 9TH FROM 12:00PM-4:00PM! Welcome home to 28710 Eden Creek Trail located Cross Creek Ranch and zoned to Katy ISD. This David Weekley home features 4 bedrooms and 3 full baths. Work from the privacy of your own home in the study. Entertain your guests and family in the formal dining area. The gourmet kitchen features white stained cabinetry with quart countertops and an oversized island. The family room includes a fireplace and large windows allowing the natural light to shine through. End your days in the spacious primary suite. The primary bath includes a large walk-in shower, double sinks and walk-in closet. This floorplan also includes a downstairs guest bedroom. Come upstairs where you will find a game room and 2 secondary bedrooms. Don\'t forget to step out back for a view of the covered patio and backyard. You don\'t want to miss all this home has to offer! Check out the 3D tour and schedule your showing today!' ,`Acres` = '0.2478' ,`Area` = '36' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK COVE AT CROSS CREEK RANCH SEC 13, BLOCK 1, LOT 54, AME' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '1098' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202686' WHERE `Matrix_Unique_ID` = '212890276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:56:00.447' ,`MLSNumber` = '92682043' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.433938' ,`Longitude` = '-95.438677' ,`PhotoCount` = '21' ,`PostalCode` = '77583' ,`RoomCount` = '15' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Muir Peak' ,`StreetNumber` = '10306' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GRAND OPENING! OPEN HOUSE SATURDAY OCTOBER 8TH & SUNDAY OCTOBER 9TH FROM 12:00PM-4:00PM!\r\nWelcome home to 10306 Muir Peak Drive located in the community of Sierra Vista and zoned to Alvin ISD! This stunning Westin home features 4 bedrooms, 3 full baths, 1 half bath and an attached 3 car garage. As you open the front door you are welcomed by the formal dining The gourmet kitchen features white stained cabinetry with quartz countertops and a large island with room for bar seating. The family room includes a fireplace, tile flooring, and large windows allowing the natural light to shine through. End your days in the spacious primary suite. The primary bath includes a large walk-in shower, separate garden tub and walk-in closet. Come upstairs where you will find 3 secondary bedrooms, game room and media room. Don\'t forget to step out back for a view of the covered patio and backyard. You don\'t want to miss all this home has to offer! Check out the 3D tour and schedule your showing today!' ,`Acres` = '0.192' ,`Area` = '5' ,`BuilderName` = 'Westin' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 2 (A0288 HT&BRR) BLK 6 LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8364' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas 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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '14529' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202686' WHERE `Matrix_Unique_ID` = '212890328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:36:48.837' ,`MLSNumber` = '86305112' ,`ListAgentFullName` = 'Mary Wise' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = 'Meagan Fiorello' ,`SellingOfficeName` = 'Redfin Corporation' ,`Latitude` = '29.537773' ,`Longitude` = '-95.253894' ,`PhotoCount` = '20' ,`PostalCode` = '77581' ,`RoomCount` = '10' ,`ListPrice` = '314000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wild Oak' ,`StreetNumber` = '3617' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1933' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful single-story 3 bedroom home in Pearland ISD\'s Oakbrook Estates community! This split floor plan design features an inviting foyer with trayed ceilings, crown molding, and a gently arched doorway that spills into the open concept dining room, family room with wood-look laminate floors and a gas fireplace, and island kitchen with breakfast bar seating, stainless appliances including a gas cooktop, and a roomy pantry. In the secluded primary suite, find custom paint, a trayed ceiling, a large walk-in closet, and an en suite bath with a seated dual basin vanity, a jetted tub, and a glass-enclosed shower with a decorative tile surround. Don\'t miss the indoor utility room and covered back patio with a decked extension into the fenced yard with mature shade trees. Conveniently located near Pearland Parkway and Dixie Farm Road with quick access to restaurants, schools, and shopping centers. Call to schedule your showing today!' ,`Acres` = '0.1702' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OAKBROOK ESTATES SEC 5 (A0070 WDC HALL)(PEARLAND) BLK 2 LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7414' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'RUSTIC OAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakbrook Estates Sec 5' ,`TaxAmount` = '7490' ,`TaxRate` = '2.8851' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202686' WHERE `Matrix_Unique_ID` = '213015058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:29:14.913' ,`MLSNumber` = '79786262' ,`ListAgentFullName` = 'Cody Scurlock' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406080' ,`Longitude` = '-95.061469' ,`PhotoCount` = '50' ,`PostalCode` = '77568' ,`RoomCount` = '10' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Egret' ,`StreetNumber` = '13404' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning Tricoast home is FULLY LOADED with many upgrades that add value from the interior and exterior, located in the sought–after master planned community of Lago Mar, ranked number 36th in the country! This home is truly one of a kind, with a coastal feel, private lot, and cozy 1 story with attention to every detail! Make your way into the home to see the spacious living area that is open to the beautiful kitchen that offers white cabinets, white quartz countertops, an enormous kitchen island with a breakfast bar, stainless steel appliances, and a dining area. Take a peek at the roomy bedrooms and Primary Bedroom or Extra Living/TV area. In the backyard, you\'ll find a wonderful, enclosed, extended covered patio with an industrial ceiling fan, custom landscaping, and irrigation! The community offers vast amenities and events. 2 community pools, 2 clubhouses, 2 gyms, a splash pad, and all the Lago Mar living!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = 'Tricoast Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6 BLK 2 LAGO MAR POD 3 SEC 2 (2022) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202686' WHERE `Matrix_Unique_ID` = '213015847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:01:55.637' ,`MLSNumber` = '61778937' ,`ListAgentFullName` = 'Adrianna Trevino' ,`ListOfficeName` = 'NetWorth Realty Houston North' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.983011' ,`Longitude` = '-95.692291' ,`PhotoCount` = '37' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Thornbluff' ,`StreetNumber` = '14619' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegance meets comfort! This exquisite two story home is located in the prestigious community of Cypress Mill Park. This house has it all high ceilings, new roof, new AC and a new water heater. The game room is perfect for working from home or using as a second living space. The primary bathroom features an extra large shower, bathtub, and a large closet! The spacious backyard is perfect for family gatherings and enjoying being outside. The community amenities include a pool and a recreation center. This house is located next to shopping, restaurants, and so much more.' ,`Acres` = '0.1292' ,`Area` = '35' ,`BuilderName` = 'New Ryland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 3 CYPRESS MILL PARK SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'A ROBISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Mill Park' ,`TaxAmount` = '6797' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202687' WHERE `Matrix_Unique_ID` = '213072737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:17:43.217' ,`MLSNumber` = '24488560' ,`ListAgentFullName` = 'Debbie Richardson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Andre Guillory' ,`SellingOfficeName` = 'Opendoor Brokerage, LLC' ,`Latitude` = '29.538574' ,`Longitude` = '-95.353252' ,`PhotoCount` = '36' ,`PostalCode` = '77584' ,`RoomCount` = '12' ,`ListPrice` = '379900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sorenson' ,`StreetNumber` = '4127' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE Sunday, Oct 16 1pm-3pm. Beautifully remodeled home has engineered wood flooring thru downstairs foyer, office, dining room, family room and primary bedroom. The recently renovated kitchen features upgraded white shaker cabinets, upgraded gray marble swirl granite, upgraded stainless appls, satin hardware, 5 burner stove, farmhouse sink, drawer pull out shelves. Primary bathroom is recently updated with custom vanity, frameless shower, upgraded fixtures. Guest bedrooms & gameroom have laminate flooring, large closets, updated lighting. High ceilings, bright windows and lush landscaping are amazing. Recently replaced roof, HVAC, water heater, plantation shutters & 2\" blinds, and neutral selections make this family friendly home a winner! Close to neighborhood pool & park! Lower taxes and HOA fee!' ,`Acres` = '0.1612' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHWYCK SEC 8 PHASE 2 (HUNTINGTON PARK)(A0548 HT&BRR) , BL' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7022' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MASSEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwyck, Silverlake' ,`TaxAmount` = '7208' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202687' WHERE `Matrix_Unique_ID` = '213092601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:55:05.583' ,`MLSNumber` = '28425717' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.640731' ,`Longitude` = '-95.378592' ,`PhotoCount` = '14' ,`PostalCode` = '77051' ,`RoomCount` = '9' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Friar Point' ,`StreetNumber` = '3031' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 3031 Friar Point Road located in the community of Sugar Valley and zoned to Houston ISD. This lovely home features 4 bedrooms and 2 full baths. As you open the front door you are welcomed by the open concept floorplan will make entertaining a breeze. The kitchen features white stained cabinetry and granite countertops. The family room includes tile flooring and large windows allowing the natural light to shine through. Don\'t forget to step out back for a view of the covered patio and backyard. You don\'t want to miss all this home has to offer! Check out the 3D tour and schedule your showing today!' ,`Acres` = '0.1389' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 35 BLK 13 SUGAR VALLEY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Valley' ,`TaxAmount` = '2331' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202687' WHERE `Matrix_Unique_ID` = '213273583' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:54:13.930' ,`MLSNumber` = '6458947' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953109' ,`Longitude` = '-95.202137' ,`PhotoCount` = '15' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Tullich Run' ,`StreetNumber` = '12426' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GRAND OPENING! OPEN HOUSE SATURDAY OCTOBER 8TH & SUNDAY OCTOBER 9TH FROM 12:00PM-4:00PM!\r\nWelcome home to 12426 Tullich Run Drive located in the master planned community of Balmoral and zoned to Humble ISD! This lovely Shea Home features 3 bedrooms, 2 full baths, and an attached 3 car garage. Work from home in the private office. Make memories with friends and family in the formal dining area. The chef\'s kitchen features white stained cabinetry with quartz countertops, SS appliances and an oversized island. The family room includes wood-like tile flooring large windows allowing the natural light to shine through. End your days in the spacious primary suite. The primary bath includes a large walk-in shower and walk-in closet. Don\'t forget to step out back for a view of the covered patio and backyard. You don\'t want to miss all this gorgeous home has to offer! Check out the 3D tour and schedule your showing today!' ,`Acres` = '0.1722' ,`Area` = '1' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 BALMORAL SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '10492' ,`TaxRate` = '3.5573' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202687' WHERE `Matrix_Unique_ID` = '213273658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T06:38:23.820' ,`MLSNumber` = '81686301' ,`ListAgentFullName` = 'Mike Schroeder' ,`ListOfficeName` = 'RE/MAX Preferred Homes' ,`SellingAgentFullName` = 'Laney Moore' ,`SellingOfficeName` = 'Living Texas Real Estate' ,`Latitude` = '30.011820' ,`Longitude` = '-95.748248' ,`PhotoCount` = '34' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '433000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Golden Sycamore' ,`StreetNumber` = '20827' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3249' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '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' ,`Acres` = '0.205' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 FAIRFIELD VILLAGE WEST SEC 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KEITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Village West Sec 14' ,`TaxAmount` = '8383' ,`TaxRate` = '2.616' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202687' WHERE `Matrix_Unique_ID` = '213280448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:31:22.427' ,`MLSNumber` = '96515245' ,`ListAgentFullName` = 'Eloisa Turrubiartes' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.660255' ,`Longitude` = '-95.055376' ,`PhotoCount` = '27' ,`PostalCode` = '77571' ,`RoomCount` = '6' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'Vanessa Cay' ,`StreetNumber` = '2269' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2854' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely Beazer home is move in ready for you to come and enjoy all the upgrades the it has! This home was built on a premium lot, kitchen with large island and large widows in the living room that provides lots of natural light. Home also has a fire place, an upgraded utility room, office space and a total of four bedrooms. Primary bedroom located downstairs with an additional room on the first floor. A game room and two additional bedrooms are located upstairs. \r\nThe back yard patio is gorgeous and a must see! It includes a huge cover patio with a beautiful outdoor kitchen, surround sound system, pergola and a fire pit. This makes the outdoor space the perfect place for get togethers with friends and family, with room left to build a pool in the future!' ,`Acres` = '0.2174' ,`Area` = '7' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 MORGANS LANDING SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9472' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Lndg Sec 9' ,`TaxAmount` = '2366' ,`TaxRate` = '3.5108' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666202688' WHERE `Matrix_Unique_ID` = '213474763' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:37:42.937' ,`MLSNumber` = '64783077' ,`ListAgentFullName` = 'Sandy Brabham' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = 'Kendall Mire' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.984061' ,`Longitude` = '-95.173246' ,`PhotoCount` = '44' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '399999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Timber Edge' ,`StreetNumber` = '7002' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Perry Home situated on an oversized cul-de-sac lot. Conveniently located just a few minutes away from IAH Airport and a short commute to Downtown Houston. Surrounded by shopping, dining and family entertainment. Home features stunning engineered wood floors, high ceilings and plenty of space for a large group. The kitchen has been updated with stainless appliances and gorgeous granite counter tops. Work from home in your private office. Enjoy a large primary bedroom with huge windows for natural light. Primary bathroom has double sinks, a vanity area, jetted tub, seamless glass shower and large walk in closet with built- ins. Good size formal dining room for family dinners or holiday parties. Upstairs you will find a game room and 3 additional bedrooms; one has it\'s own private bathroom; the other two share a Jack & Jill bathroom. The pool size backyard offers plenty of room for children and pets to play.' ,`Acres` = '0.3158' ,`Area` = '1' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 4 ATASCA WOODS SEC 4 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13755' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atasca Woods' ,`TaxAmount` = '7408' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202688' WHERE `Matrix_Unique_ID` = '213519603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T06:37:24.307' ,`MLSNumber` = '38151974' ,`ListAgentFullName` = 'Jaime Saenz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Tiffany Bean' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.081645' ,`Longitude` = '-95.386453' ,`PhotoCount` = '28' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '289999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mist Green' ,`StreetNumber` = '3503' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifull Cozy Home on a Large almost 14,000 sqft Lot. This 3 Bed 2 Bath home Features Wood Faux Tile flooring throughout , All New Windows Installed in 2018 , Roof Replaced in 2017. Walking into the entry you are greeted with Formal Dining and a Home Office/ Optional 4th Bedroom. Large Open Kitchen with large granite island Lots of Cabinet Storage & additional pantry space. Large Primary Suite with a huge Double Shower. So many possibility\'s with this oversized Lot ! Don\'t miss out , Schedule a Private Showing !' ,`Acres` = '0.3183' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 LEXINGTON WOODS SEC 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13866' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods Sec 08' ,`TaxAmount` = '4732' ,`TaxRate` = '2.2769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202688' WHERE `Matrix_Unique_ID` = '213532238' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:13:51.137' ,`MLSNumber` = '92258857' ,`ListAgentFullName` = 'Somer Padilla' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.420885' ,`Longitude` = '-95.545119' ,`PhotoCount` = '46' ,`PostalCode` = '77318' ,`RoomCount` = '12' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'Cude Cemetery' ,`StreetNumber` = '12325' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We are so excited to bring you this beautiful 6 acre property in a superb location with private gated access and close to everything. This darling one story has been updated with a gorgeous kitchen with two enormous islands that open to your picture perfect shiplapped living room with views of your completely refinished and updated pool and serene acreage. Bring your horses and livestock and enjoy country living with a perfect blend of city life. Owner\'s Suite features french doors to your covered patio, two large walk-in closets, shower, double sinks, and a stunning claw foot tub with ranch views. Property includes two barns with electricity; one is a wood 4 stall with open air stalls, and the other is a Barnmaster 3 stall shed row style with tack room. Also features a 24x36 three bay shop or garage, screened in garden beds, water well with great water pressure, new pool equipment, 4 year old roof, large round pen for horses, high speed internet, and so much more. This is a gem!!' ,`Acres` = '6' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A0012 - CUDE TIMOTHY, TRACT 13-E, ACRES 6' ,`LotDesciption` = 'Wooded' ,`LotSize` = '261360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Georgian' ,`Subdivision` = 'Timothy Cude Surv Abs #12' ,`TaxAmount` = '6296' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202688' WHERE `Matrix_Unique_ID` = '213543852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:11:32.033' ,`MLSNumber` = '91530556' ,`ListAgentFullName` = 'Nathan Marks' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = 'Tiffany Romero' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '30.317256' ,`Longitude` = '-95.291916' ,`PhotoCount` = '44' ,`PostalCode` = '77328' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Weir' ,`StreetNumber` = '4900' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HARD TO FIND: OVER 7 ACRES OF UNRESTRICTED PROPERTY JUST EAST OF CONROE!! Property features a 3 bedroom, 2 bathroom manufactured home along with a 2 car garage, a huge barn, chicken coop, well house, and a workshop! All of this, plus a pond in the back of the property. So bring your horses and/or other farm animals and start living off the land. This peaceful piece of property is waiting for you!' ,`Acres` = '7.205' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0414 - PEEBLES RICHARD, TRACT 30 LOT 10, SERIAL TXFL2AD5184' ,`LotDesciption` = 'Wooded' ,`LotSize` = '313832' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'PEEBLES RICHARD' ,`TaxAmount` = '3795' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202688' WHERE `Matrix_Unique_ID` = '213596934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:19:56.907' ,`MLSNumber` = '93561964' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.126829' ,`Longitude` = '-95.556740' ,`PhotoCount` = '26' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Sweet Pasture' ,`StreetNumber` = '8615' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1919' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come home to this meticulously maintained, beautiful, 4 bedroom 2 bath home in the highly sought after subdivision of Saddlebrook Ranch. Very convenient location close to shopping, excellent schools, restaurants, entertainment and much more! Energy Star Home! Large open kitchen with breakfast area, pantry, stainless steel appliances and granite countertops. Double glass/wood doors lead to formal dining room with wood flooring - can also be used as study/home office. Private and large primary bedroom suite with high vaulted ceiling. Primary bathroom features double sinks, separate shower, garden tub and walk-in closet. Lots of attic storage with decking. Enjoy the outdoors year round on your covered patio, fully fenced backyard. The storage shed stays. Full irrigation system in the front and back! Storage shed stays. Saddlebrook amenities include sidewalks, park and splash pad nearby. Call today to schedule a private showing!' ,`Acres` = '0.1543' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 5 SADDLEBROOK RANCH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Saddlebrook Ranch Sec 01' ,`TaxAmount` = '7087' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666202689' WHERE `Matrix_Unique_ID` = '213700611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T07:18:29.627' ,`MLSNumber` = '38540564' ,`ListAgentFullName` = 'Sophie Zhang' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728719' ,`Longitude` = '-95.848112' ,`PhotoCount` = '22' ,`PostalCode` = '77441' ,`RoomCount` = '8' ,`ListPrice` = '518000.00' ,`Status` = 'Active' ,`StreetName` = 'Huggins Crest' ,`StreetNumber` = '27606' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Former BEAZER MODEL HOME in Master Planned Community in the Capri Floor plan. This 1.5 story home features 4 bedrooms, 3 baths, a study, Game room, and loft. There are 3 bedrooms downstairs! Upgrades galore with Stainless steel apliances, granite counter tops, iron spindles,and 2 master closets! There are tile and wood flooring throughout most of the home. Don\'t miss the great covered patio out back and it\'s on a CUL-DE-SAC street across from the pool! Hurry to see this gorgeous home today!' ,`Acres` = '0.1609' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CHURCHILL FARMS SEC 1, BLOCK 1, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7009' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '630' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Churchill Farms Sec 1' ,`TaxAmount` = '8511' ,`TaxRate` = '2.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666202689' WHERE `Matrix_Unique_ID` = '213744258' --> 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','213751448','1666202689','213751448','2022-10-18T07:52:51.597','71829051','Stephen Warrell','Martha Turner Sotheby\'s International Realty','','','29.735537','-95.481854','26','77057','10','799900.00','Active','Winsome','5824','Lane','Houston','4','1','4','2938','Single-Family','This incredible new construction home offers unrivaled finishes and quality craftmanship in abundance. Enter through the driveway gate into this exclusive enclave of homes that feature roof top terraces and a thoughtful layout that optimizes the functionality of the home. The first floor provides a study or bedroom with views out onto the private front yard. The second floor is expansive and well appointed with a flow that is ideal for cozy nights Infront of the fireplace or hosting friends and family for your favorite event. In either case the space works for every buyers needs. The third floor enjoys a generously appointed primary suite that includes a large soaking tub and separate shower as well as ample closet space. Additionally there is the a secondary bedroom suite with private bathroom. The 4th floor provides a gameroom with dry bar, 4th bedroom and access to the roof top terrace which has amazing views of the surrounding area. There is an elevator shaft servicing all 4 floors','0.0601','22','Carnegie Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Mock Fireplace','1','Galleria','Central Gas','1','LT 3 BLK 1 WESTHEIMER GARDENS EXTN 4TH PAR R/P','Patio Lot,Subdivision Lot','2619','Appraisal District','','125','1','To Be Built/Under Construction','2','Single Oven','0','','','Gas Range','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Builder','4','Traditional','Westheimer Gardens','1189','2.3307','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213753457','1666202689','213753457','2022-10-18T07:48:46.070','75547936','Stephen Warrell','Martha Turner Sotheby\'s International Realty','','','29.735541','-95.481749','32','77057','9','669900.00','Active','Winsome','5822','Lane','Houston','3','1','3','2279','Single-Family','This incredible new construction home offers unrivaled finishes and quality craftmanship in abundance. Enter through the driveway gate into this exclusive enclave of homes that feature roof top terraces and a thoughtful layout that optimizes the functionality of the home. The first floor provides a study or bedroom with views out onto the private front yard. The second floor is expansive and well appointed with a flow that is ideal for cozy nights Infront of the fireplace or hosting friends and family for your favorite event. In either case the space works for every buyers needs. The third floor enjoys a generously appointed primary suite that includes a large soaking tub and separate shower as well as ample closet space. Additionally there is the a secondary bedroom suite with private bathroom. The 4th floor provides access to the roof top terrace which has amazing views of the surrounding area. There is an elevator shaft servicing all 4 floors.','0.0371','22','Carnegie Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Mock Fireplace','1','Galleria','Central Gas','1','LT 11 BLK 1 WESTHEIMER GARDENS EXTN 4TH PAR R/P','Patio Lot,Subdivision Lot','1618','Appraisal District','','125','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Builder','3','Traditional','Westheimer Gardens','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213775673','1666202689','213775673','2022-10-18T07:05:53.783','55690712','Donn Clark','R. Alexa Group LLC','','','30.326582','-95.297591','8','77306','3','174900.00','Active','Old Highway 105 E','17642','','Conroe','2','0','3','1456','Single-Family','Great 3/2 on large lot located in Ponderosa Pines. Home has been totally refurbished including new appliances. New carpet and faux wood flooring.','','40','','','','','No Disclosures','','','','Cleveland Area','Central Electric','1','S810300 - PONDEROSA PINES 01, BLOCK 4, LOT 7, SERIAL BL20019','Subdivision Lot','','','','380','0','','0','','0','','','','','Composition','11 - Conroe','CREIGHTON ELEMENTARY SCHOOL','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Leave Business Card,Lockbox Front,No Appointment Required','Appraisal District','1','Contemporary/Modern','Ponderosa Pines 01','1282','1.8488','Public Sewer,Public Water','2017','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','213779507','1666202689','213779507','2022-10-18T07:46:58.540','58746436','Ginger Mashburn','RE/MAX Eastside','','','29.769023','-94.681818','42','77514','7','190000.00','Active','Stowell','500','Street','Anahuac','2','0','2','1750','Single-Family','This picture perfect, adorable home is located on a corner lot in Anahuac. It features 2 living areas and spacious bedrooms. There is a third room that could be an office or a bedroom. The kitchen features beautiful wood cabinets with plenty of storage space. There is also a large, separate storage closet. The yard has mature trees and nice landscaping and the backyard is completely fenced. You won\'t need to worry about power outages with the Generac generator that has been installed. The roof was replaced this year. If you\'ve dreamed of living in a small town this is the perfect place to call home.','0.157','53','','','','','Sellers Disclosure','','','','Chambers County East','Central Electric','0','W PT 2 BK 22 WILLCOX ADDN','Other','6840','Appraisal District','','','0','','0','','0','','','','','Composition','4 - Anahuac','ANAHUAC ELEMENTARY SCHOOL','ANAHUAC HIGH SCHOOL','ANAHUAC MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Seller','1','Traditional','Willcox Add','3712','2.9736','Public Sewer,Public Water','1978','Seller'); --> 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','213779559','1666202689','213779559','2022-10-18T07:59:10.937','35286075','Roscoe Ford','RE/MAX Fine Properties','','','29.915429','-95.676033','45','77095','10','374990.00','Active','Beckwood Post','9614','Drive','Houston','2','1','4','2766','Single-Family','Welcome to Canyon Lakes at Stonegate in northwest Houston/Cypress featuring a \"Links\" golf courses at Houston National GC, community pools, tennis courts, basketball courts and parks. This 2004 two story home has been well maintained and features appx 2,766 sqft (per HCAD), 4 bedrooms. A Large living room with fireplace, spacious kitchen with granite countertops, upgraded stainless steel appliances tiled backsplash, dining room plus a breakfast room, spa like primary bath large tub and separate shower. Don\'t forget about the large closets including a Huge walk-in primary closet. Ethernet connections throughout the home. Beautiful Landscaping with mature trees. 2 car garage! Easy access to Energy Corridor or Galleria areas. Dining options near by at Towne Lake and along Hwy 290.','0.137','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','Gaslog Fireplace','1','Copperfield Area','Central Electric','1','LT 43 BLK 1 CANYON LAKES AT STONEGATE SEC 5','Cul-De-Sac','5969','Appraisal District','','940','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','POSTMA ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ARAGON MIDDLE SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Canyon Lakes At Stonegate 05','6366','2.561','Water District','2004','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','213785535','1666202689','213785535','2022-10-18T07:00:09.463','84575849','Michael Parker','Phyllis Foster Real Estate Ser','','','29.695499','-95.110332','41','77536','4','398000.00','Active','Shoshoni','1810','Drive','Deer Park','2','0','4','2195','Single-Family','GREAT PROPERTY LOCATED IN THE HEART OF DEER PARK. NO BACK NEIGHBORS. GREAT OPEN CONCEPT FLOOR PLAN WITH 4 BEDROOMS AND 2 FULL BATH. THE KITCHEN OPENS TO THE FAMILY ROOM WITH WOOD FLOORING. GRANITE COUNTER TOPS WITH AMPLE COUNTER TOP AND STORAGE SPACE. SPACIOUS SECONDARY BEDROOMS WITH LARGE WALK IN CLOSETS. OVER SIZED POOL WITH COVERED PATION AND DECK. RECENT IMPROVEMENTS INCLUDE A/C AND ROOF. DO NOT MISS THIS GREAT OPPURTUNITY BOOK TODAY.','0.2682','6','','','Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Deer Park','Central Gas','1','LT 3 BLK 2 RUNNINGBROOK SEC 1','Subdivision Lot','11682','Appraisal District','','475','0','','2','Freestanding Oven,Single Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','16 - Deer Park','SAN JACINTO ELEMENTARY SCHOOL (DEER PARK)','DEER PARK HIGH SCHOOL','DEER PARK JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Runningbrook Sec 01','7933','2.8239','Public Sewer,Public Water','1989','Appraisal District'); --> New record created successfully