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-22T12:53:47.710' ,`MLSNumber` = '14242820' ,`ListAgentFullName` = 'Vicky Turnbow' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676170' ,`Longitude` = '-95.200007' ,`PhotoCount` = '9' ,`PostalCode` = '77502' ,`RoomCount` = '6' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Juliet' ,`StreetNumber` = '2401' ,`StreetSuffix` = '' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2089' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '** Under Construction**Estimated completion date is end of October 2022. Unique, unique unique floorpan. This is a 4 bedroom 2.5 bath new build with a loft. This home will also feature amazing back covered patio. Contact us today for more information on this floorpan. Picture is of rendering.' ,`Acres` = '' ,`Area` = '6' ,`BuilderName` = 'Perfection Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 1 Williams T E Partial Replat' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Williams T E Replat 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701725' WHERE `Matrix_Unique_ID` = '201242987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:45:51.970' ,`MLSNumber` = '27915147' ,`ListAgentFullName` = 'Zuri Perez-Majul' ,`ListOfficeName` = 'Zuri Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662580' ,`Longitude` = '-95.315214' ,`PhotoCount` = '28' ,`PostalCode` = '77087' ,`RoomCount` = '8' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Beldart' ,`StreetNumber` = '6218' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 4 bedroom 2 bathroom home in the subdivision Overbrook. This home was recently remodeled just 4 yrs ago and offers tiled floors throughout. Large family room open to the spacious dining room. Formal dining room featuring an elegant chandelier, chair rail and crown molding. Beautiful kitchen offering granite countertops, maple cabinets and pantry. Primary suite is very large and features his and hers closets and an en-suite bathroom. Primary bathroom boasts dual sinks, granite countertops and a shower/tub combo. Spacious bedrooms are all spacious! PEX Plumbing, Big backyard. Close to Med Center, downtown, Hobby Airport; with easy and quick access to 610 and I45.' ,`Acres` = '0.1465' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 6 OVERBROOK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6382' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN VILLAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Overbrook' ,`TaxAmount` = '4562' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701725' WHERE `Matrix_Unique_ID` = '205260717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:33:29.527' ,`MLSNumber` = '29314953' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518559' ,`Longitude` = '-95.784051' ,`PhotoCount` = '7' ,`PostalCode` = '77471' ,`RoomCount` = '10' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Richmont' ,`StreetNumber` = '3609' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Pine Valley\" Plan with Brick/Stone Elevation \"G\" in Sendero! This two-story home features a circular flowing layout with an open-concept kitchen that leads to a large nook and family room. The first-floor owner’s suite boasts two walk-in closets, while the second floor hosts three bedrooms, a shared bathroom and versatile game room. *HOME ESTIMATED TO BE COMPLETE, July, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0003 BLK 001 LOT 012' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701725' WHERE `Matrix_Unique_ID` = '206454090' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:27:58.473' ,`MLSNumber` = '25587152' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.327339' ,`Longitude` = '-95.510151' ,`PhotoCount` = '14' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '714900.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Oaks' ,`StreetNumber` = '10370' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Two-story rotunda entry features curved staircase. Formal dining room and home office with French doors frame entry. Two-story family room with wall of windows and a wood mantel fireplace opens to kitchen and morning area. Kitchen features large walk-in pantry, Butler\'s pantry, double wall oven, 5-burner gas cooktop and island with built-in seating space. First-floor primary suite includes bedroom with wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. A second bedroom is downstairs. Upstairs highlights a game room, media room and guest suite with private bath. Extended covered backyard patio. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572726 - Harper\'s Preserve 26, BLOCK 3, Lot 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7578' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1172' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701725' WHERE `Matrix_Unique_ID` = '206457538' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:27:02.907' ,`MLSNumber` = '38681477' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.268789' ,`Longitude` = '-95.470765' ,`PhotoCount` = '17' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '509900.00' ,`Status` = 'Active' ,`StreetName` = 'Fall Rock Branch' ,`StreetNumber` = '804' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry with 12-foot coffered ceiling. Open kitchen features generous counter space, corner walk-in pantry and island with built-in seating space. Dining area flows into open family room with wall of windows. Primary suite includes bedroom with wall of windows. Dual vanities, corner garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. A guest suite with private bath adds to this four-bedroom design. Extended covered backyard patio. Mud room off two-car garage.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Grand Central Park Lot 11, Blk 1, Section 23' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6225' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1073' ,`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` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701726' WHERE `Matrix_Unique_ID` = '207033223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:26:14.063' ,`MLSNumber` = '76877103' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.268921' ,`Longitude` = '-95.470141' ,`PhotoCount` = '17' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Cortez Creek' ,`StreetNumber` = '985' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry with 12-foot ceiling. Extended entry leads to open kitchen, dining area and family room. Kitchen features corner walk-in pantry, generous counter space and island with built-in seating space. Dining area flows into family room with wall of windows. Family room has a corner fireplace with wood mantel. Primary suite includes double-door entry to primary bath with dual vanities, garden tub, separate glass-enclosed shower and two large walk-in closets. A guest suite with private bath adds to this spacious one-story home. Extended covered backyard patio. Mud room off two-car garage.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Grand Central Park Lot 6, Blk 1, Section 23' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6357' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1073' ,`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` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701726' WHERE `Matrix_Unique_ID` = '207049903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:30:52.783' ,`MLSNumber` = '52503023' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851238' ,`Longitude` = '-95.438581' ,`PhotoCount` = '31' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Sky' ,`StreetNumber` = '5831' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSES AT THE SALES OFFICE - 5406 TUSKEGEE ST. Saturdays & Sundays 1-5pm.\r\nUNDER CONSTRUCTION! Move-in ready by Fall 2022! Gorgeous new construction by Disama Building Group. Nestled in gated community on a quiet street, this stunning two-story floor plan with private driveway offers an open concept living & kitchen area on the first floor that extends to a spacious fenced backyard. Primary suit and 2 secondary bedrooms on the second floor. Upgraded finishes throughout including smart home system, Quartz counter tops, stainless-steel appliances, primary bathroom - free standing bathtub & upgraded cabinets with soft close drawers. Enjoy this 30-home gated community located minutes away from Downtown Houston. Easy access to I45 and 610.\r\nPhotos and Matterport from another community by the same builder. Finishes and layout WILL VARY!\r\nFor GPS please use 1837 Mansfield St. Houston TX 77091' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mansfield Square' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701726' WHERE `Matrix_Unique_ID` = '207494776' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:33:46.937' ,`MLSNumber` = '61541464' ,`ListAgentFullName` = 'Ricardo Gonzalez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.128079' ,`Longitude` = '-95.286710' ,`PhotoCount` = '26' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '892000.00' ,`Status` = 'Active' ,`StreetName` = 'Sonora' ,`StreetNumber` = '22713' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mi casa, su casa! Imagine being greeted, every day, by this tastefully appointed yet opulent porte cochere. This polished and sophisticated home is truly made for both entertaining and everyday living, with plenty of space and custom design elements. Enjoy an open floor plan, high tray ceilings and a chef grade kitchen with stainless steel appliances, plenty of cabinets and a roomy pantry. A secret second floor movie room is perfect for those “Netflix & Chill” nights. The heart of this home, the kitchen- with adjoining dining and family rooms- makes it ideal for gatherings. Walk outside to your backyard oasis paradise with stretched patio and captivation relaxation ambiance. This property Is immaculate, well-cared for, and ready for new owner. Welcome Home!' ,`Acres` = '1' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S834905 - RIVERWALK 05, BLOCK 2, LOT 9, A0438 ROBINSON THOMA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwalk 05' ,`TaxAmount` = '12268' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701726' WHERE `Matrix_Unique_ID` = '209090170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:07:05.677' ,`MLSNumber` = '79835687' ,`ListAgentFullName` = 'Allen Hebert' ,`ListOfficeName` = 'Register Real Estate Advisors' ,`SellingAgentFullName` = 'Brookes Cunningham' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.184673' ,`Longitude` = '-95.165496' ,`PhotoCount` = '7' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '399990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Brutus' ,`StreetNumber` = '000' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UC - Located in popular Roman Forest Large 4 bedrooms or 3 bedrooms with study. 2 full Baths. Craftsman style front door.White Brick on 3 sides w/white mortar and dark brown trim on Exterior. Vinyl plank throughout main areas, halls, and second bathroom. Carpet in bedrooms and closets. -Tile in master bath floor and shower surround. Double pane Vinyl windows. Kitchen and bathrooms solid surface top (Silestone),Kitchen backsplash 3x12 tile on broken joint, Job built custom cabinets to the ceiling, SS Appliances. Gas heater, stove, Furness, fireplace & dryer. High efficiency 16 seer AC, Batt Walls R13, Slope ceiling R19, and Attic blown R38., Moen Faucets (chrome). Interior paint light grey with white trim, Baseboard 1x4 with 1x4 Casing, 8’ Interior doors with 6” base and 3 1/2 casing. . Gas Fireplace. Garage door Opener, Kitchen features Breakfast bar. Covered front porch. Enjoy the 12\'x11\' covered back patio. Front of home gutters Fantastic location,30 Year\r\nArchitectural shingles' ,`Acres` = '0.4591' ,`Area` = '40' ,`BuilderName` = 'M. Taylor Custom Hom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 02, BLOCK 10, LOT 7' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Roman Forest 02' ,`TaxAmount` = '581' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701726' WHERE `Matrix_Unique_ID` = '209332353' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:55:59.590' ,`MLSNumber` = '58820565' ,`ListAgentFullName` = 'Blake Vincent' ,`ListOfficeName` = 'DUX Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743188' ,`Longitude` = '-95.366740' ,`PhotoCount` = '44' ,`PostalCode` = '77004' ,`RoomCount` = '11' ,`ListPrice` = '679900.00' ,`Status` = 'Active' ,`StreetName` = 'JACKSON' ,`StreetNumber` = '2307' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2514' ,`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. You no longer have to compromise your location to buy somewhere or something else, that you just don’t really want. This home features an extremely versatile and functional floor plan. The floor plan has 3 bedrooms, 2.5 bathrooms , primary suite with a generous walk-in closet, first floor living, flex room, & a private driveway. Retail, restaurants, gym, groceries, you name it, it\'s walking distance away. Major freeways, downtown, medical center, parks, theater, art & museum districts are all within minutes. Ask about REMAINING customization options during construction ONLY! * NOTE: PHOTOS IN LISTING ARE OF A MODEL HOME W/A SIMILAR FLOOR PLAN &/OR UPGRADE/ FINISHES. PLANS & SELECTIONS ARE SUBJECT TO CHANGE W/OUT NOTIFICATION *' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'MAZZTAO HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Houston' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 JACKSON STREET VIEWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3125' ,`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` = '27 - Houston' ,`SchoolElementary` = 'GREGORY-LINCOLN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'JACKSON STREET VIEWS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701726' WHERE `Matrix_Unique_ID` = '209598232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:05:57.940' ,`MLSNumber` = '7384232' ,`ListAgentFullName` = 'Jessica Winski' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.334080' ,`Longitude` = '-95.552843' ,`PhotoCount` = '15' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '144000.00' ,`Status` = 'Active' ,`StreetName` = 'Broken Ridge' ,`StreetNumber` = '12605' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Affordable home in a great location! 1344sf • 3 Bedroom 2 bath in the friendly community of Lake Conroe West. Great Location! 13,330sf lot with privacy fenced backyard. This home features a great 23x10\' covered front porch, upgraded metal roof, split floor plan with vaulted ceilings, carpet, large rooms, island kitchen, large oak trees for shade, big back yard for the kids. Storage shed. Easy access to Hwy 105, 10 minutes to I-45, 4 minutes to Lake Conroe. Conroe ISD. Quiet country neighborhood.' ,`Acres` = '0.306' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S660500 - LAKE CONROE WEST-WEST CRK, LOT 75, SERIAL # TXFLT6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13330' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe West-West Crk' ,`TaxAmount` = '600' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701726' WHERE `Matrix_Unique_ID` = '209623501' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:51:45.660' ,`MLSNumber` = '25303831' ,`ListAgentFullName` = 'Destiny Todd' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.119022' ,`Longitude` = '-94.015854' ,`PhotoCount` = '33' ,`PostalCode` = '77662' ,`RoomCount` = '6' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Hebert' ,`StreetNumber` = '275' ,`StreetSuffix` = 'Street' ,`City` = 'Vidor' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '275 Hebert St. is quite a showstopper! With high end upgrades and a spacious corner lot, this 3 bedroom 2.5 bath beauty is new from top top bottom! Includes: new granite, cabinets, stainless steel appliances, tile flooring and carpet, new paint for the interior and exterior, brand new windows, custom tile in bathrooms and a newly added covered back patio as well! Open concept kitchen and living, with an extra den area make this home very appealing! Bring your family and friends to see this one!' ,`Acres` = '0.361' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST. 118 I & GN #17 (LOT 10 RICHARDS PARK)' ,`LotDesciption` = 'Corner' ,`LotSize` = '15725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1005 - Vidor' ,`SchoolElementary` = 'VIDOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VIDOR HIGH SCHOOL' ,`SchoolMiddle` = 'VIDOR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Richards Park' ,`TaxAmount` = '3652' ,`TaxRate` = '2.9308' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701727' WHERE `Matrix_Unique_ID` = '209944987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:07:56.403' ,`MLSNumber` = '95827438' ,`ListAgentFullName` = 'Blake Vincent' ,`ListOfficeName` = 'DUX Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730902' ,`Longitude` = '-95.378920' ,`PhotoCount` = '39' ,`PostalCode` = '77004' ,`RoomCount` = '11' ,`ListPrice` = '679900.00' ,`Status` = 'Active' ,`StreetName` = 'RUTH' ,`StreetNumber` = '1505' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mazzarino Construction & Development\'s new division is here in Houston\'s well established inner loop neighborhoods. This MAZZTAO HOME located in the Museum District/Medical Center 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, 2 primary closets, flex room, a modest 589 S.F. backyard, and a private driveway. Rice/Museum District is minutes to The Medical Center, The Zoo, Downtown, the newly renovated Memorial Park Conservatory, White Oak & Buffalo Bayou Greenway Parks & Trails, and plenty of Restaurants and Retail. Minutes to Downtown Houston, Galleria, and easy assess to I-69/US-59, 288, I-10, 610, and 45. Inquire today to learn more about customization options during construction only!' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'MAZZTAO HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 RUTH STREET VILLAS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3125' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MACGREGOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'RUTH STREET VILLAS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701727' WHERE `Matrix_Unique_ID` = '210378856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:47:12.043' ,`MLSNumber` = '26026799' ,`ListAgentFullName` = 'Bobby McMahon' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = 'Bobby McMahon' ,`SellingOfficeName` = 'Southern Star Realty' ,`Latitude` = '30.923550' ,`Longitude` = '-95.255770' ,`PhotoCount` = '29' ,`PostalCode` = '75862' ,`RoomCount` = '4' ,`ListPrice` = '130000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lake Shore Dr' ,`StreetNumber` = 'TBD' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1348' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Wonderful opportunity to own 3 lots 2 of which are Lake view and a double wide mobile home in gated neighborhood. Enjoy sitting on the sun porch looking out at the lake having your morning coffee. Plenty of room down below the house to add a man cave or put in RV hook ups for your guest. This subdivision offers a boat ramp to Lake Livingston along with boat stalls, swimming pool for members, club house, playgrounds, piers for fishing, and half-court basketball. Could be great for full time living or a weekend retreat. Home could use a little TLC.' ,`Acres` = '' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 131,132,145' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '26' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Leave Business Card,Lockbox Back,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbor Point' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663701727' WHERE `Matrix_Unique_ID` = '210469874' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:43:08.300' ,`MLSNumber` = '32309393' ,`ListAgentFullName` = 'Traci Garner' ,`ListOfficeName` = 'RE/MAX Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704647' ,`Longitude` = '-95.525093' ,`PhotoCount` = '34' ,`PostalCode` = '77036' ,`RoomCount` = '4' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Osage' ,`StreetNumber` = '6907' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a beautifully renovated 4/2/2, all large bedrooms, granite countertops,SS Appliances. Cozy and Formal areas throughout. Super large Master Bedroom with cozy fireplace. This home is a must see....' ,`Acres` = '0.1882' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 4 SHARPSTOWN COUNTRY CLUB TERRACE' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '8196' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '245' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'NEFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sharpstown Country Club Terrac' ,`TaxAmount` = '5147' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701727' WHERE `Matrix_Unique_ID` = '210483345' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:45:27.447' ,`MLSNumber` = '25594381' ,`ListAgentFullName` = 'Ryan Birdsong' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.059928' ,`Longitude` = '-95.461378' ,`PhotoCount` = '50' ,`PostalCode` = '77566' ,`RoomCount` = '11' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Timbercreek' ,`StreetNumber` = '303' ,`StreetSuffix` = 'Drive' ,`City` = 'Lake Jackson' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4470' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS BEAUTIFUL HOME HAS IT ALL WITH MANY UPDATES! IT OFFERS 5 BEDROOMS, 4 1/2 BATHS, 2 LIVING AREAS, FORMAL DINING ,SEPARATE BREAKFAST AREA, BUTLERS PANTRY, INDOOR UTILITY, STUDY & SUNROOM. THE FORMAL ENTRY HAS A BEAUTIFUL STAIRCASE W/IRON BALASTERS. THE STUDY HAS CEILING TO FLOOR BUILT IN BOOKCASES W/ LIGHTS & DESK. BOTH LIVING AREAS HAVE A COZY FIREPLACE. THE DOWNSTAIRS PRIMARY EN SUITE HAS DOUBLE VANITIES W/SINKS, OVERSIZED WALK IN SHOWER W/BENCH & CAST IRON TUB. THE 2ND DOWNSTAIRS BEDROOM COULD BE USED AS A 2ND PRIMARY. THE KITCHEN HAS TOP OF THE LINE APPLIANCES, ISLAND & WALK IN PANTRY. UPSTAIRS THERE ARE 3 BEDROOMS, 2 OF THEM SHARE A JACK-JILL BATHROOM & THE OTHER HAS ITS OWN PRIVATE BATHROOM. LOTS OF STORAGE THROUGHOUT. THE OVERSIZED GARAGE ALSO HAS AN AIR CONDITIONED SHOP W/SHOWER. THE BACKYARD HAS AN AMAZING COVERED OUTDOOR KITCHEN & REG SHORT COURSE HEATED LAP POOL! OTHER UPDATES INCLUDE A 35 KW BACKUP GENERATOR, HARDI PLANK & STONE UPDATES AND ROOF(21). CALL US TO SEE TODAY!' ,`Acres` = '0.5949' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TIMBERCREEK SEC 2 REPLAT (LAKE JACKSON), BLOCK 10, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timbercreek Sec 1-2 Rep La' ,`TaxAmount` = '11878' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701727' WHERE `Matrix_Unique_ID` = '210497006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:06:37.377' ,`MLSNumber` = '8265843' ,`ListAgentFullName` = 'Jagdish Kothari' ,`ListOfficeName` = 'Pro 1 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919206' ,`Longitude` = '-95.598464' ,`PhotoCount` = '28' ,`PostalCode` = '77065' ,`RoomCount` = '11' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'QUIET WATER COURT' ,`StreetNumber` = '12002' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3145' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAKE FRONT HOME ON CUL-DE-SAC. ENJOY FOUNTAIN VIEWS FROM YOUR PRIVATE DECK - DECORATED LIKE A \r\n MODEL WITH MASTER BATH WITH WHIRPOOL TUB, CUSTOM WINDOW COVERNING, STAINLESS STEEL BUILT-IN APPLIANCES, OPEN KITCHEN WITH BEAUTIFUL BACKSPLASH - ENTIRE FIRST FLOOR AND STAIRS HAVE HANDSOME LAMINATE WOOD FLOOR, SCENIC BACKYARD PATIO, LARGE GAME ROOM UP, AND SPECIOUS WALK-IN ATTIC.' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = 'DAVID WEEKLY' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 3 WINDERMERE LAKESSEC 3' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '8346' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMMOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'WINDERMERE LAKES sec 3' ,`TaxAmount` = '' ,`TaxRate` = '2.241' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701727' WHERE `Matrix_Unique_ID` = '210717658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:37:27.077' ,`MLSNumber` = '8221083' ,`ListAgentFullName` = 'Jared English' ,`ListOfficeName` = 'Congress Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843444' ,`Longitude` = '-95.267876' ,`PhotoCount` = '13' ,`PostalCode` = '77028' ,`RoomCount` = '4' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Talton' ,`StreetNumber` = '8528' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION!!! September 2022 completion date. Located in the heart of Houston is this inviting 4 bedroom, 2 bath, 2 car garage oasis that awaits you. This is an energy efficient home with durable countertops, luxury laminate flooring, ceramic tiling, contemporary carpet and a spacious kitchen. The area is quiet and gives the feel of out of the city living but it is close to everything. This home is 10 minutes from downtown Houston, Minute Maid Park and BBVA Compass Stadium. No HOA and Low taxes!! The pictures are from a previously built home and is for illustration purposes only (colors and upgrades may be different).' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Silver Circle Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1 BLOCK 1 SILVER CIRCLE PLAZA HOUSTON TEXAS 77028' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5287' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silver Circle Plaza' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701727' WHERE `Matrix_Unique_ID` = '210896876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:46:38.567' ,`MLSNumber` = '97042778' ,`ListAgentFullName` = 'Milia Do' ,`ListOfficeName` = 'Home Realty, LLC' ,`SellingAgentFullName` = 'Christy Buck' ,`SellingOfficeName` = 'Infinity Real Estate Group' ,`Latitude` = '29.549498' ,`Longitude` = '-95.437777' ,`PhotoCount` = '31' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '368000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'bailey springs' ,`StreetNumber` = '3405' ,`StreetSuffix` = '' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'beautiful 3 bed 2 lake view home.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW GROVE SEC 4 FINAL PLAT, BLOCK 1, LOT 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '7809' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '922' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'shadow grove' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701728' WHERE `Matrix_Unique_ID` = '210952302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:53:56.430' ,`MLSNumber` = '93161700' ,`ListAgentFullName` = 'Kitee Valentz' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545934' ,`Longitude` = '-95.603459' ,`PhotoCount` = '48' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '1550000.00' ,`Status` = 'Active' ,`StreetName` = 'Flyers Cove' ,`StreetNumber` = '5519' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 5 bed/5.5 bath home located on .5+ acre wooded cul-de-sac lot in the prestigious gated section of Avalon at Riverstone. Open concept floor plan perfect for entertaining. Elegant formal living and dining rooms. Impressive kitchen with a huge island and breakfast room open to the spacious two story family room. Double staircases lead to an oversized game room, large media room with 4k projector & screen, card room, and 3 secondary bedrooms. The backyard paradise includes a lushly landscaped yard, covered patio, stunning pool with spa and water features. The extraordinary backyard also features a fire pit, zip line, and plenty of additional greenspace. Home has 38 solar panels for optimal energy efficiency. Zoned to exemplary Fort Bend ISD schools. Don’t miss out on this amazing home that offers everything you are looking for and more!' ,`Acres` = '0.5114' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT RIVERSTONE SEC 22, BLOCK 1, LOT 32' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '22276' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1780' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Avalon At Riverstone' ,`TaxAmount` = '21317' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701728' WHERE `Matrix_Unique_ID` = '211230227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:02:04.620' ,`MLSNumber` = '83552267' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226283' ,`Longitude` = '-95.703767' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '430152.00' ,`Status` = 'Active' ,`StreetName` = 'Heron Heights' ,`StreetNumber` = '15134' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story, The Sandown Floor Plan with 4 Bedrooms, 3 ½ Baths, with a 2 CAR GARAGE. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining Room, Half Bath, and the Master Bedroom & Bath downstairs. Upstairs you will find a Game Room, 3 Bedrooms, and 2 Full Bath. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, SS appliances, and even a USB outlet. Window blinds throughout. SPRINKLER SYSTEM and fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road. Magnolia ISD.' ,`Acres` = '0.1783' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221203 - AUDUBON CREEKSIDE NORTH 03A, BLOCK 1, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7765' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '539' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701728' WHERE `Matrix_Unique_ID` = '211230495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:25:39.310' ,`MLSNumber` = '87300892' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401881' ,`Longitude` = '-95.070731' ,`PhotoCount` = '30' ,`PostalCode` = '77568' ,`RoomCount` = '17' ,`ListPrice` = '499437.00' ,`Status` = 'Active' ,`StreetName` = 'Sabine Lake' ,`StreetNumber` = '13714' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Alden, Elevation AL) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. First floor study. Spacious island kitchen open to family room and informal dining room. Primary suite with large walk-in closet. Upstairs game room and media room. Covered patio and attached 2 car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701728' WHERE `Matrix_Unique_ID` = '211324374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:16:49.500' ,`MLSNumber` = '87900681' ,`ListAgentFullName` = 'Jade Rangel' ,`ListOfficeName` = 'Homevets Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.465370' ,`Longitude` = '-95.475038' ,`PhotoCount` = '29' ,`PostalCode` = '77378' ,`RoomCount` = '7' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Big Bow' ,`StreetNumber` = '15517' ,`StreetSuffix` = 'Bend' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED 15K- Looking for a home that will impress you when you walk in the front door, look no further. When entering the home you will be greeted by beautiful wrought iron stairs and high ceilings. Accompanied by an open concept living/kitchen making entertaining guests a delight. Upstair features a game room and laundry room so no need to go up and down to get laundry done. House is fully loaded to include the washer and dryer, bringing your buyers to view this beautiful home.' ,`Acres` = '0.1863' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ARROWHEAD LAKES 02, BLOCK 10, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8117' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Arrowhead Lakes 02' ,`TaxAmount` = '3584' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701728' WHERE `Matrix_Unique_ID` = '211370683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:08:21.317' ,`MLSNumber` = '91068338' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.652563' ,`Longitude` = '-95.121739' ,`PhotoCount` = '17' ,`PostalCode` = '77505' ,`RoomCount` = '10' ,`ListPrice` = '446786.00' ,`Status` = 'Active' ,`StreetName` = 'Firethorne Ridge' ,`StreetNumber` = '5818' ,`StreetSuffix` = 'Way' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one-story Juniper II home with 3 bedrooms, 2 baths and 3 car attached garage. Beautiful maple cabinets, under cabinet lighting, quartz countertops and farmhouse sink in kitchen. Convenient home office located across from great room. Double sinks, separate tub and shower in owner\'s bath. Enjoy your evening relaxing on your cover patio. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '5/2/5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701728' WHERE `Matrix_Unique_ID` = '211441807' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:21:45.037' ,`MLSNumber` = '7808478' ,`ListAgentFullName` = 'Mimi Kwan' ,`ListOfficeName` = 'Mimi Kwan, REALTORS ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560362' ,`Longitude` = '-95.534174' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '679000.00' ,`Status` = 'Active' ,`StreetName` = 'Island' ,`StreetNumber` = '71' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3095' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful chic on ravine waterfront home in a gated community in Jade Island! It\'s private & quiet! There are birds and deers here! Home has high ceiling with high doors! Lovely back balcony and back porch overseeing the quiet setting! Have coffee and enjoy quiet moments in Breakfast Room! Elegant Dining with impressive chandelier! Spacious Living Room with high ceiling and oversees the open backyard! Big open kitchen: quartz counters, ss appliances, GE refrigerator, modern sink! Lots of cabinets & storage! Two primary bedrooms (one up one down) both oversees the private backyard! Home has lots of windows! light & bright! Lovely ceiling fans & light fixtures! Beautifully designed! The Marina Club is next to the subdivision entrance! See the beautiful lake with boat dock, fishing piers, children\'s playground and a big pavillion! Great location close to Hwy 6, Fort Bend Tollway and Beltway 8. NOT in special flood hazard area! It\'s a great place to call home, tranquil and peaceful!' ,`Acres` = '0.1309' ,`Area` = '38' ,`BuilderName` = 'Super Tech Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'JADE ISLAND @ LAKE OLYMPIA SEC 1, BLOCK 1, LOT 66, A/P, SLID' ,`LotDesciption` = 'Ravine,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '5702' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '846' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Jade Island Lake Olympia' ,`TaxAmount` = '' ,`TaxRate` = '2.79' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701728' WHERE `Matrix_Unique_ID` = '211615473' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T13:43:39.670' ,`MLSNumber` = '48517536' ,`ListAgentFullName` = 'Kimberly Price' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029673' ,`Longitude` = '-94.101615' ,`PhotoCount` = '20' ,`PostalCode` = '77705' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Chambless' ,`StreetNumber` = '1710' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2324' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 5 years young custom built by Price Homes sits on an acre inside the city limits. You will fall in love with the meticulous attention to detail and countless designer finishes in this beautiful home. Soaring ceilings, wall of windows, gorgeous flooring & a designer kitchen welcomes you with a custom bench for eating. Stainless steel appliances, granite countertops & so much more. The home also offers smart light, fan & garage control. Privately nestled on an acre you\'ll enjoy the peace & quiet. Call now to experience this gem. It won\'t last long! Home completed in 2018.' ,`Acres` = '0.9986' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'J A VEATCH B-20 BLK 136 L7 1 AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'BLANCHETTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oil & Gas Mfg Co' ,`TaxAmount` = '868' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701729' WHERE `Matrix_Unique_ID` = '211684220' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T12:22:31.757' ,`MLSNumber` = '18710919' ,`ListAgentFullName` = 'Jack Lipar' ,`ListOfficeName` = 'LGI Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349432' ,`Longitude` = '-95.530597' ,`PhotoCount` = '15' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Wedgewood Hills' ,`StreetNumber` = '6262' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully designed, new construction one-story home is located on a quiet street in the rolling hills of the beautiful community of Wedgewood Forest in Conroe. This charming home offers a true retreat for the whole family with a picturesque beautiful, wooded lot just out back. This spacious home includes a chef-ready kitchen with polished granite countertops, white wood cabinetry and stainless-steel Whirlpool brand appliance, including a fridge with an ice maker and water dispenser. The primary suite showcases two large windows, a huge walk-in shower with tiled walls, and a spacious walk-in closet. In addition to well-crafted homes, Wedgewood Forest offers residents incredible on-site amenities, including a fishing pier and cabin, a park with a playground, and a covered ramada with benches.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'WDG L1, BL2, Sec 4 of Wedgewood Forest' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wedgewood Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701729' WHERE `Matrix_Unique_ID` = '211687886' --> Updated record success