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-08-17T17:34:03.007' ,`MLSNumber` = '71800787' ,`ListAgentFullName` = 'Jolunda Tompkins' ,`ListOfficeName` = 'Realty Right' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.116829' ,`Longitude` = '-96.106310' ,`PhotoCount` = '50' ,`PostalCode` = '77454' ,`RoomCount` = '11' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Birdie' ,`StreetNumber` = '145' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2647' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Construction home inside gated renowned Legendary Oaks subdivision. 4 bedroom 2.5 baths is a spacious open floor plan with includes a study and a flex room. Use it as a media room for family fun. Covered back patio and plenty of space to create the perfect backyard oasis. Visit the in community golf course Legendary Oaks course.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Private' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 62 Legendary Oaks' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Legendary Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699894' WHERE `Matrix_Unique_ID` = '204066803' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T16:09:37.070' ,`MLSNumber` = '34037235' ,`ListAgentFullName` = 'Cary Stephens' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843174' ,`Longitude` = '-94.867374' ,`PhotoCount` = '50' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '1850000.00' ,`Status` = 'Active' ,`StreetName` = 'Trinity' ,`StreetNumber` = '3203' ,`StreetSuffix` = 'Street' ,`City` = 'Mont Belvieu' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Location! 4 BR 4 bath home located in the Heart of Mont Belvieu! Buy all & develop! Will sell house & all 17..35 acres for $1,850,000 (Tax ID\'s #35234, #36836 #39264 & #39265) or will divide! Will sell house on 3.208 acres for $795,000 (Tax ID\'s #35234 & #36836! Extra +/- 3.5 acres available for an additional $350,000 (Part of #39264)! Plus extra 10.64 acres for $850,000 (Part of #39264) Great Property for someone to develop a small custom acreage subdivision or a compound for your entire family! Do your own due diligence! 40x40 Building w/ full bath! Hay Barn! Storage Building! Custom Pool w/ Waterfall & Covered Patio! 4th bedroom upstairs could be a game room or study! Country living in the city! Seller prefers to sell all property together or the 10.64 acres of land first! Will sell house & 3.2 acres or house & 6.7 acres first ! Won\'t sell 3.5 acres first! Access easement through 3.5acres must be granted along south edge of property to back acreage if divided!' ,`Acres` = '3.208' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PT LT 10 BK 1 K B RANCH' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '139740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'K B Ranch' ,`TaxAmount` = '7298' ,`TaxRate` = '2.1487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699894' WHERE `Matrix_Unique_ID` = '204077526' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:15:20.833' ,`MLSNumber` = '24240023' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583933' ,`Longitude` = '-95.745558' ,`PhotoCount` = '9' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '379320.00' ,`Status` = 'Active' ,`StreetName` = 'Muscadine Hollow' ,`StreetNumber` = '1210' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready November 2022! Live.Now Collection: Elemental. A private flex space in the Oleander makes a perfect home office or play room. Clear sight lines from the kitchen through the family room bring everyone together, while twin secondary bedrooms are tucked away in their own hall. Make long commutes a thing of the past thanks to major road improvements on US-90 and FM 359. The kids will love attending school in the sought-after Lamar Consolidated ISD and the area offers an affordably low tax rate. Downtown Richmond is home to many new boutiques, restaurants, and longstanding businesses. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0245 Plan L401E' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mandola Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.41' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699894' WHERE `Matrix_Unique_ID` = '207380234' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:38:32.060' ,`MLSNumber` = '70274479' ,`ListAgentFullName` = 'Suzette Peoples' ,`ListOfficeName` = 'Peoples Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.574361' ,`Longitude` = '-95.620745' ,`PhotoCount` = '34' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '700000.00' ,`Status` = 'Active' ,`StreetName` = 'Foxhall Crescent' ,`StreetNumber` = '24' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home remodeled and updated beautifully! Rare find with master down and 3rd car garage can be converted to another bedroom with access to 4th bath. Formal living/study downstairs. 2 story living area opens to gourmet island kitchen can seats 6 chairs. Kitchen remodeled with granite counters, Stainless Steel appliances, fixtures and painted cabinets. Fresh painted interior, updated fixtures, Engineered floors & tile (no carpet) Ceiling fans all bedrooms, kitchen and bath. Master bath updated huge over-sized shower, Quartz counters, fixtures and closet organizer. Double pain windows and custom shutters and blinds. Sparkling pool/spa with replastered pool and decking all re-done. Free home warranty at closing. Washer & Dyer can stay. Don\'t miss this one, will go fast. Great location in gated community. Master Planned Community with parks, trails & shopping nearby.' ,`Acres` = '0.1274' ,`Area` = '29' ,`BuilderName` = 'Murray-Millis Custom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'CRESCENTS ON THE GREEN, BLOCK 3, LOT 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5549' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2157' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crescents On The Green' ,`TaxAmount` = '10814' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699894' WHERE `Matrix_Unique_ID` = '209855412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:24:20.873' ,`MLSNumber` = '34226285' ,`ListAgentFullName` = 'Blake Vincent' ,`ListOfficeName` = 'DUX Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796518' ,`Longitude` = '-95.480220' ,`PhotoCount` = '41' ,`PostalCode` = '77055' ,`RoomCount` = '11' ,`ListPrice` = '659900.00' ,`Status` = 'Active' ,`StreetName` = 'SHADYVILLA' ,`StreetNumber` = '7518' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mazzarino Construction & Development\'s new division is here in Houston\'s well established inner loop neighborhoods. MAZZTAO Homes features a new, stylish, well priced, quality home, but with an entirely different price point. This home features an extremely versatile and functional floor plan. This floor plan features 3 bedrooms, 2.5 bath rooms, 1st floor living, primary w/ sitting area, flex room, a private driveway, & approximately 2500s.f. backyard.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'MAZZTAO HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 SHADYVILLA VIEWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4812' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'SHADYVILLA VIEWS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699894' WHERE `Matrix_Unique_ID` = '210010492' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:51:53.267' ,`MLSNumber` = '55084557' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841742' ,`Longitude` = '-94.989159' ,`PhotoCount` = '7' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '271990.00' ,`Status` = 'Active' ,`StreetName` = 'Kingston Liberty' ,`StreetNumber` = '9807' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW LENNAR Community - STERLING POINT!!! New Lennar Wildflower II Collection Homes in Sterling Point! The Lantana II, Brick Elevation \"A\" provides an excellent layout for families. This single-level home has an airy design that’s shared by the kitchen, nook and family room. A covered patio invites outdoor living, while a formal dining room and two secondary bedrooms add flexibility. The owner’s suite enjoys privacy, nestled in a back corner location.\r\n**Estimated Completion Date, November 2022**' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 004 LOT 008' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Point' ,`TaxAmount` = '' ,`TaxRate` = '3.735' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699894' WHERE `Matrix_Unique_ID` = '210324130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:39:24.353' ,`MLSNumber` = '88598514' ,`ListAgentFullName` = 'Saul Gonzalez' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.686925' ,`Longitude` = '-95.171789' ,`PhotoCount` = '9' ,`PostalCode` = '77503' ,`RoomCount` = '3' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Rose' ,`StreetNumber` = '2808' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1153' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOME UNDER RENOVATIONS - NO SHOWINGS UNTIL FURTHER NOTICE' ,`Acres` = '0.1832' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 5 R/S 2 HOUSTON SUBURBAN ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SANJACINTO INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Suburban Estate Resub Lt' ,`TaxAmount` = '1986' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699894' WHERE `Matrix_Unique_ID` = '210354507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:27:03.797' ,`MLSNumber` = '2458907' ,`ListAgentFullName` = 'Kapil Mittal' ,`ListOfficeName` = 'Candid Realties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.288436' ,`Longitude` = '-94.806170' ,`PhotoCount` = '21' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue O 1/2' ,`StreetNumber` = '3715' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow! 1 story Beautifully home with 3 bedroom and 2 and half bath home. The entire home has been renovated, with new plumbing, electrical, hardwood floors, new light fixtures, new ceiling fans new stove, new microwave oven new kitchen cabinets, new sink, new ceiling fans new garbage disposal, new Tub, new toilets, new walk-in showers in both bathrooms new cabinets, Insulaitons in the walls, fully insulated attic, new side patio, new paint inside and out 5 new windows, new sheet rock exaust vents, new ductwork. Stone throwing distance from the beach. The home is centrally located placing you close to all of the island’s amenities, A must see home. The house has the elevation Certificate and buyer can have the access to the current flood policy' ,`Acres` = '0.1179' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 4 SE BLK 60 GALVESTON OUTLOTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '4968' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699895' WHERE `Matrix_Unique_ID` = '210367758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T16:55:57.080' ,`MLSNumber` = '19340798' ,`ListAgentFullName` = 'Emily Green' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.036507' ,`Longitude` = '-94.873681' ,`PhotoCount` = '18' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '379990.00' ,`Status` = 'Active' ,`StreetName` = 'Jessica' ,`StreetNumber` = '90' ,`StreetSuffix` = 'Drive' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful 2 story home on a large corner lot! This home offers 4 actual bedrooms with an office/study and media room that could be used as another bedroom, 3 FULL bathrooms, new floors upstairs, and a pool to cool off in during the HOT Texas summers! Fordland Estates, located in Dayton, does NOT have HOA! AND it has NEVER flooded!' ,`Acres` = '0.292' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FORDLAND ESTATES, SEC 5, LOT 52, ACRES .292' ,`LotDesciption` = 'Corner' ,`LotSize` = '12720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas 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 Left Side,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fordland Estates, Sec 5' ,`TaxAmount` = '7759' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699895' WHERE `Matrix_Unique_ID` = '210984464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T16:11:03.833' ,`MLSNumber` = '42258576' ,`ListAgentFullName` = 'Ayesha Shelton' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740494' ,`Longitude` = '-95.364186' ,`PhotoCount` = '23' ,`PostalCode` = '77004' ,`RoomCount` = '5' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Emanuel' ,`StreetNumber` = '2516' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2511' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Park Street Homes presents St. Emanuel View! This collective of 2 luxury single-family residences is where intelligent design and grand living meet. The living and entertaining spaces have been designed and positioned perfectly in the residences for maximum views and entertainment. With expansive dimensions, soaring ceiling heights, walls of windows, and gracious bedrooms. Each home is 3 bedrooms and 2.5 bathrooms with a bonus room with a private rooftop balcony. Each home features a full view of the Downtown Houston skyline from every floor from the 1st floor-covered patio to the 3rd story rooftop balcony. Make one of these homes yours today! Ask about selection options! Don\'t miss one of the best homes being built in Downtown/3rd Ward in all of 2022! Homes expected to break ground OCT 2022!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Park Street Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 1 Block 1 Saint Emanuel View Homes' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Saint Emanuel View Homes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699895' WHERE `Matrix_Unique_ID` = '211001666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T16:12:36.853' ,`MLSNumber` = '32967116' ,`ListAgentFullName` = 'Ayesha Shelton' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740479' ,`Longitude` = '-95.364198' ,`PhotoCount` = '23' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Emanuel' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2511' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Park Street Homes presents St. Emanuel View! This collective of 2 luxury single-family residences is where intelligent design and grand living meet. The living and entertaining spaces have been designed and positioned perfectly in the residences for maximum views and entertainment. With expansive dimensions, soaring ceiling heights, walls of windows, and gracious bedrooms. Each home is 3 bedrooms and 2.5 bathrooms with a bonus room with a private rooftop balcony. Each home features a full view of the Downtown Houston skyline from every floor from the 1st floor-covered patio to the 3rd story rooftop balcony. Make one of these homes yours today! Ask about selection options! Don\'t miss one of the best homes being built in Downtown/3rd Ward in all of 2022! Homes expected to break ground OCT 2022!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Park Street Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2 Block 1 Saint Emanuel View Homes' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Saint Emanuel View Homes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699895' WHERE `Matrix_Unique_ID` = '211010179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:21:07.143' ,`MLSNumber` = '70012691' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395273' ,`Longitude` = '-95.688456' ,`PhotoCount` = '6' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Abner' ,`StreetNumber` = '167' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New home with 3 car garage and on large lot! Ready for move in October 2022. 4 bedrooms, game room, & study.' ,`Acres` = '0.28' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456900 - ESTATES OF LAKE CREEK VILLAGE, BLOCK 1, LOT 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Lake Creek Village' ,`TaxAmount` = '1146' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699895' WHERE `Matrix_Unique_ID` = '211048353' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:08:43.610' ,`MLSNumber` = '7714666' ,`ListAgentFullName` = 'Krissi Taylor' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777676' ,`Longitude` = '-95.155119' ,`PhotoCount` = '17' ,`PostalCode` = '77530' ,`RoomCount` = '5' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Arundel' ,`StreetNumber` = '14915' ,`StreetSuffix` = '' ,`City` = 'Channelview' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '994' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great starter home or investment property. 2 bedroom and one bath with a nice living room with a woodburning fireplace. Covered patio out back, and a mature pecan tree in the back yard. This home will not last long. Schedule your showing today.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'E 44.70 FT OF LT 4 & W 15.80 ft Lt 5 Blk 5 Channelwood Sc 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6534' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'SCHOCHLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'JOHNSON JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Channel Wood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699895' WHERE `Matrix_Unique_ID` = '211507438' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:10:18.670' ,`MLSNumber` = '72305256' ,`ListAgentFullName` = 'Crystal Lucas' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.359056' ,`Longitude` = '-95.617666' ,`PhotoCount` = '13' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '124900.00' ,`Status` = 'Active' ,`StreetName` = 'Queenswood' ,`StreetNumber` = '926' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0489' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE VILLAGE, BLOCK 25, LOT 48' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '2128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '384' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699895' WHERE `Matrix_Unique_ID` = '211510621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:11:36.543' ,`MLSNumber` = '33575998' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Fruge Properties' ,`SellingAgentFullName` = 'Patrick Dewlen' ,`SellingOfficeName` = 'RE/MAX Cinco Ranch' ,`Latitude` = '29.903498' ,`Longitude` = '-95.734235' ,`PhotoCount` = '5' ,`PostalCode` = '77433' ,`RoomCount` = '19' ,`ListPrice` = '649984.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Regal Terrace' ,`StreetNumber` = '21131' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'one-third acre home site in a quiet cul-de-sac \r\nMarvida is Cypress, Texas’ newest community where residents can have it all. As a sister community to Miramesa, Canyon Lakes West and Stone Gate, residents have access to their incredible amenities including Marvida’s own amenity village with a lazy river pool. Marvida’s premier location will have you to major roadways quickly and is part of award-winning Cypress-Fairbanks ISD. Schedule your appointment today to learn more about Marvida!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Hamilton Thomas Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22, Block 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13915' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699896' WHERE `Matrix_Unique_ID` = '211521681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T17:42:12.880' ,`MLSNumber` = '34075444' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655464' ,`Longitude` = '-95.052792' ,`PhotoCount` = '32' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '377700.00' ,`Status` = 'Active' ,`StreetName` = 'Vanessa Cay' ,`StreetNumber` = '2348' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1775' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#34075444 REPRESENTATIVE PHOTOS ADDED Built by Taylor Morrison, January 2023 Completion! The Juneberry in Morgan’s Landing is a home designed for entertaining! The center of the home functions as one large integrated space for cooking, dining, and socializing with the center kitchen island as a beautiful focal point and gathering area. Tucked away is the cozy owner\'s suite where a trio of windows bathes the bedroom in natural light. Enter the owner\'s bath through charming French doors and enjoy the dual sinks and vanity, a private commode, and a large walk-in closet. The study with storage closet will make a productive space for working from home. Structural options include: slide in tub at owner’s bath, 8’ doors, covered outdoor living, raised ceiling at foyer, and 12” pop-up ceiling at gathering room.' ,`Acres` = '0.139' ,`Area` = '7' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 1 of Morgan\'s Landing Section 14' ,`LotDesciption` = 'Other' ,`LotSize` = '6071' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing 45\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699896' WHERE `Matrix_Unique_ID` = '211524784' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T16:23:18.963' ,`MLSNumber` = '9338781' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059700' ,`Longitude` = '-95.360036' ,`PhotoCount` = '13' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '258990.00' ,`Status` = 'Active' ,`StreetName` = 'Kentwood Springs' ,`StreetNumber` = '24015' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful brand NEW Express Home in Breckenridge Forest! Tons of privacy! No Back Neighbors!! Fantastic location! Charming curb appeal! Perfect floor plan with open living spaces and modern finishes! Lovely island kitchen with espresso cabinetry! Great Primary suite with large closet and oversized shower! Great outdoor space with covered back patio and landscape package! Breckenridge Forest has a nice community pool and fun parks! Hurry and call today!!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Express Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Bkl 1, Section 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699896' WHERE `Matrix_Unique_ID` = '211531552' --> Updated record success