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-12-10T01:22:29.523' ,`MLSNumber` = '23999580' ,`ListAgentFullName` = 'Steve Guillen' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819412' ,`Longitude` = '-95.437276' ,`PhotoCount` = '27' ,`PostalCode` = '77018' ,`RoomCount` = '0' ,`ListPrice` = '424999.00' ,`Status` = 'Active' ,`StreetName` = 'Oatfield' ,`StreetNumber` = '2116' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your palace awaits! Newly constructed. The perfect blend of City and Suburban living right in the heart of the beloved community of Oak Forest. This elegant home includes 3 bedrooms, 3.5 baths, 3 story living, a 2-car garage, and an open floor plan with ample natural lighting. Inside this one-of-a-kind home you will find huge walk-in closets, High ceilings, a Gourmet kitchen with an abundance of solid wood Cabinets, Calacatta Quartz countertops and over-sized island, Bamboo and Porcelain flooring, sleek and modern fixtures and features, and covered balconies. Location! Only a few minutes away from freeway access which places you less than 10 mi. from popular areas like the Medical Center, Heights, the Galleria, Energy Corridor, and Downtown Houston. Both Airports are less than 20 mi. away and there are also plenty of local restaurants, bars and attractions within walking distance. Video Tour: https://youtu.be/1WI8i386J6M / “HOLIDAY SPECIAL for a limited time only”' ,`Acres` = '0.0359' ,`Area` = '9' ,`BuilderName` = 'Fisher Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 FISHER ESTATES AT OAK FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Fisher Ests/Oak Forest' ,`TaxAmount` = '4263' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089326' WHERE `Matrix_Unique_ID` = '207102911' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T01:22:29.523' ,`MLSNumber` = '92914618' ,`ListAgentFullName` = 'Jacob Fitzgerald' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.179747' ,`Longitude` = '-95.421992' ,`PhotoCount` = '26' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Southampton' ,`StreetNumber` = '921' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This completely remodeled home in the heart of Angleton is sure to win you over! Original wood floors sanded and stained sealed to its natural color , new paint with a completely remodeled master bath and kitchen . This home has 2 living rooms 4 bedrooms in the MAIN HOUSE and in the brand NEW Mother -n- law suite has its own full kitchen and full Bath. Keep it a mother in law suite or an income producing unit!' ,`Acres` = '0.1848' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CHEVY CHASE #3 (ANGLETON) BLK 1 LOT 23' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chevy Chase #3 Angleton' ,`TaxAmount` = '2921' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089327' WHERE `Matrix_Unique_ID` = '213278184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T01:22:29.523' ,`MLSNumber` = '40075717' ,`ListAgentFullName` = 'Felita Fontenot' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664552' ,`Longitude` = '-95.498376' ,`PhotoCount` = '31' ,`PostalCode` = '77096' ,`RoomCount` = '12' ,`ListPrice` = '419995.00' ,`Status` = 'Active' ,`StreetName` = 'Hummingbird' ,`StreetNumber` = '6103' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3285' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCTION!!! NEWLY RENOVATED GORGEOUS & ELEGANT HOME JUST 5 MINUTES FROM LOOP 610 and a short drive to The Galleria, Rice Village, the Medical Center, NRG Stadium & Downtown Houston! This Entertainment-friendly, Corner-Lot home features a completely RENOVATED Kitchen, UPDATED Bathrooms, Fixtures & Ceiling/Light Fixtures AND plenty of space to host family and friends with Formal Living/Office, Family Room, Formal Dining, Breakfast Room AND an Additional 1st Floor Entertainment Room to make your own… Game Room, Media Room, or even a Playroom for the little ones in the family. This space exits to a Enormous Patio. Upstairs is the Primary Bedroom featuring a Huge Walk-In Closet and Updated EnSuite Bath, along with (3) large secondary bedrooms with Walk-in Closets and another Full Bath. NEVER FLOODED! Call me for a Private Showing, you won\'t be disappointed!' ,`Acres` = '0.1997' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 5 FONDREN SW NORTHBROOK 1 RP EXT' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '470' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HALPIN/TINSLEY' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Fondren Sw Northbrook 01 Rp Ext' ,`TaxAmount` = '5824' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089327' WHERE `Matrix_Unique_ID` = '213509272' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T01:22:29.523' ,`MLSNumber` = '68126795' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848448' ,`Longitude` = '-95.429572' ,`PhotoCount` = '19' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Paul Quinn' ,`StreetNumber` = '1106' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1763' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Urban Space! Ideally located in a gated community just North of Oak Forest and\r\nwith easy access to 610, I-45, and I-10, this is city living at its best. Interior features and\r\nfinishes include Quartz countertops, stainless steel appliance packages and much more! All\r\nhomes are freestanding, three story houses with their own private back yards and zoned to\r\nHouston ISD. Live in a brand new construction home while being just minutes away from The\r\nHeights, restaurants, coffee shops, shopping and more.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'New Era' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'URBAN SPACE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089327' WHERE `Matrix_Unique_ID` = '213539584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T01:22:29.523' ,`MLSNumber` = '6300339' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848448' ,`Longitude` = '-95.429572' ,`PhotoCount` = '19' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Paul Quinn' ,`StreetNumber` = '1106' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1763' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Urban Space! Ideally located in a gated community just North of Oak Forest and\r\nwith easy access to 610, I-45, and I-10, this is city living at its best. Interior features and\r\nfinishes include Quartz countertops, stainless steel appliance packages and much more! All\r\nhomes are freestanding, three story houses with their own private back yards and zoned to\r\nHouston ISD. Live in a brand new construction home while being just minutes away from The\r\nHeights, restaurants, coffee shops, shopping and more.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'New Era' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Urban Space' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089327' WHERE `Matrix_Unique_ID` = '213540195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T01:22:29.523' ,`MLSNumber` = '65592916' ,`ListAgentFullName` = 'Sara Alexander' ,`ListOfficeName` = 'Melder Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293677' ,`Longitude` = '-95.554242' ,`PhotoCount` = '27' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Overlook Peak' ,`StreetNumber` = '331' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2388' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRACTICALLY BRAND NEW home in the highly desirable Woodforest community. Awesome 1 Story w/ 4 bedrooms 3 baths 2 car garage plus Study features a generous open floor plan with a lovely Island Kitchen w/ Designer Cabinets and Granite Countertops. Primary Suite with Luxurious Master Bath! Extensive 6\" x 24\" Tile Floors; Energy Efficient w/ 16 SEER HVAC System with Smart Thermostat, Radiant Barrier Roof Decking. Cozy Covered Patio overlooks a spacious backyard. This gorgeous home offers a slice of privacy as it sits on a corner lot with no neighbors to one side. This prime location is minutes away from amenities such as shopping, dining and so much more.' ,`Acres` = '0.1744' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965277 - WOODFOREST 77, BLOCK 2, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7597' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 77' ,`TaxAmount` = '2788' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089328' WHERE `Matrix_Unique_ID` = '213642076' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T01:22:29.523' ,`MLSNumber` = '98415166' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.720394' ,`Longitude` = '-95.568246' ,`PhotoCount` = '25' ,`PostalCode` = '77320' ,`RoomCount` = '3' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '901' ,`StreetSuffix` = 'Street' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in the heart of Huntsville, 3/1.5 1-story home, approx. .287 acres corner lot, won\'t last long! Interior features include an open concept family room that transitions into the oversized kitchen + adjacent formal dining area, and 3 generously sized bedrooms. Schedule a private tour today!' ,`Acres` = '0.2877' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WHITE ADDITION, BLOCK 4, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '12532' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'White Add' ,`TaxAmount` = '2724' ,`TaxRate` = '1.8868' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089328' WHERE `Matrix_Unique_ID` = '213880160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T01:22:29.523' ,`MLSNumber` = '63232409' ,`ListAgentFullName` = 'Thai Klam' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.630838' ,`Longitude` = '-95.441608' ,`PhotoCount` = '26' ,`PostalCode` = '77045' ,`RoomCount` = '5' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Beran' ,`StreetNumber` = '4214' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1146' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Remodeled 3 bed, 1 bath home in the Pamela Heights subdivision conveniently located close to US-90/610/288 & Bltwy 8. You have to see this gorgeous all white brick exterior home featuring all new appliances, open design kitchen/dining combo, brand new custom cabinetry and laminate floors throughout w/carpet in bedrooms, covered front porch and big back yard! This freshly painted home boasts plenty of natural lighting paired with elegant lighting fixtures and dining room chandelier.' ,`Acres` = '0.1569' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 9 PAMELA HEIGHTS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6834' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HOBBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pamela Heights Sec 01' ,`TaxAmount` = '2714' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089328' WHERE `Matrix_Unique_ID` = '214100618' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T01:22:29.523' ,`MLSNumber` = '95124587' ,`ListAgentFullName` = 'Rhonda Williford' ,`ListOfficeName` = 'RE/MAX Compass' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.756662' ,`Longitude` = '-95.890938' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '7' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Blazing Star' ,`StreetNumber` = '2442' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Dreams do come true & this one just might be yours! Featuring 3 bedrooms,2 baths,2,149 Sq. Ft.! This lovely home sits nestled in the highly desired community of Jordan Ranch. This home features: extended back patio, no back neighbors, fully fenced backyard for optimal privacy & neutral color palate. Well maintained, bright & airy & with all this home comes with there is not much more to wish for. Inside features: upgraded cabinets,hard surface flooring throughout, built in back pack area at mud room, ceiling fans in all bedrooms & family, open concept, spacious dining and study, upgraded tile in bath/shower area, kitchen open to family room w/ massive kitchen island (sink in island), & beautiful tile backsplash. The community is host to amenities galore: playgrounds, resort-style pool, fitness center, tennis courts, lazy river, sports fields & the Sunset Farm (planted, fresh, local) that sells fresh produce. Come check out this timeless home today. A must see!' ,`Acres` = '0.1395' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'JORDAN RANCH SEC 19, BLOCK 1, LOT 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '4049' ,`TaxRate` = '3.1948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089328' WHERE `Matrix_Unique_ID` = '214269216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T01:22:29.523' ,`MLSNumber` = '19560275' ,`ListAgentFullName` = 'Karen Benson' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764596' ,`Longitude` = '-95.558103' ,`PhotoCount` = '34' ,`PostalCode` = '77024' ,`RoomCount` = '4' ,`ListPrice` = '2199000.00' ,`Status` = 'Active' ,`StreetName` = 'Faust' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This unique home is zoned to the highly desirable Memorial Bend Subdivision with the best top tier schools in the greater Houston area, Rummel Creek Elementary, Memorial Middle and High School. This smart home features interior and exterior LED lighting for energy conservation, smart fans, stunning master suite with ceiling cedar beams, luxurious master bath with Lazuli High polished porcelain, his and hers spacious closets. Office and dining room ceiling cedar beams with large windows for natural light radiating throughout. Rococo brushed engineered Harwood floors. Spectacular kitchen with Quartz countertops with mitered edge design, stainless steel appliances, 6 gas burner grill cooktops, trash compactor and wine room. All stucco exterior, Outdoor kitchen with close to half an ACRE backyard for outdoor entertainment. Close to major retail, restaurants, City Centre, Memorial Mall, and seconds away from Terry