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-30T10:16:38.377' ,`MLSNumber` = '7721004' ,`ListAgentFullName` = 'Katherine Clark' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.093520' ,`Longitude` = '-95.767472' ,`PhotoCount` = '41' ,`PostalCode` = '77447' ,`RoomCount` = '3' ,`ListPrice` = '1600000.00' ,`Status` = 'Active' ,`StreetName` = 'Roberts Cemetery Road' ,`StreetNumber` = '22111' ,`StreetSuffix` = '' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this custom built country estate nestled in the woods on 30+ acres. Gated entry. Easy access to 290/99. All the conveniences without being in the city. Property has gorgeous mature landscaping along with some cleared acreage. Creek access at back of property. Barn/shop that also features living quarters and a room for your treasures. Well and electrical protected by a pump house. High ceilings and hardwood floors. Custom carpentry thought-out. Large island in kitchen allows for gatherings. This property has 2 Tax ID\'s which equal up to 30+ acres.' ,`Acres` = '30.5939' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0032 - ROBERTS ABRAHAM, TRACT 36, ACRES 26.0677' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'J.L. LYON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Roberts Abraham' ,`TaxAmount` = '' ,`TaxRate` = '2.0237' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704784' WHERE `Matrix_Unique_ID` = '203559858' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:57:16.053' ,`MLSNumber` = '75085977' ,`ListAgentFullName` = 'Timothy Williams' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.105589' ,`Longitude` = '-93.791000' ,`PhotoCount` = '31' ,`PostalCode` = '77630' ,`RoomCount` = '10' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Poe' ,`StreetNumber` = '4615' ,`StreetSuffix` = 'Road' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large Home with 4 Bedrooms and 2.5 Bathrooms nestled on 3/4 of an Acre is ready for You to Customize to Your Style! The Entry features a Wooden Door with Iron Scroll work and Double Lights. The Triple Windows in the Livingroom let is Lots of Natural Light. The Kitchen includes loads of cabinet space, Solid Surface Countertops with Ceramic Tile Backspalsh, Electric Cooktop, Double Built-In Ovens, Dishwasher, Breakfast Nook with Window Seat, and Ceramic Tile Flooring. The Spacious Den includes a Wood-Burning Fireplace, Built-In Bookshelf, and Double Doors Leading to the Covered Back Porch. The Master Bedroom includes a Master Bathroom En Suite with Vanity Area and Walk-In Shower. This Home also includes a Powder Room for Guest Convenience, 3 More Bedrooms, a Shared Bathroom with Double Sinks & Tub/Shower Combo and a Very Large Utility Room. Exterior Features include a Large Covered Front Porch and Fully Fenced Massive Backyard.' ,`Acres` = '0.753' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 49 LINDENWOOD' ,`LotDesciption` = 'Cleared' ,`LotSize` = '32801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '270 - West Orange-Cove Consolidated' ,`SchoolElementary` = 'WEST ORANGE-STARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST ORANGE-STARK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST ORANGE-STARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lindenwood' ,`TaxAmount` = '4835' ,`TaxRate` = '2.779' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704784' WHERE `Matrix_Unique_ID` = '205816664' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:55:09.570' ,`MLSNumber` = '467212' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.501633' ,`Longitude` = '-95.387558' ,`PhotoCount` = '8' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '519547.00' ,`Status` = 'Active' ,`StreetName` = 'Vintage Oaks' ,`StreetNumber` = '5602' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 4049Plan. Beautiful 2-story French Country brick exterior, 3-car garage, with 5 bedrooms, 4 baths. Luxury vinyl plank flooring throughout, with plush carpet only in bedrooms and tile in the laundry room and bathrooms. The kitchen boasts double ovens, a 5-burner gas cooktop and an oversized island with beautiful quartz countertops. Master suite has a bay window with a fabulous view to the large back yar, a generous walk-in closet, double sinks, separate glass framed shower and a drop-in garden tub. And, no pass thru traffic on this street. Come live the difference!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41 Blk 1 Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13762' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.73944' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704784' WHERE `Matrix_Unique_ID` = '207566494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:57:08.987' ,`MLSNumber` = '63104424' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495231' ,`Longitude` = '-95.386665' ,`PhotoCount` = '6' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '459990.00' ,`Status` = 'Active' ,`StreetName` = 'Vintage Oaks' ,`StreetNumber` = '5626' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 4039 Plan. Beautiful 1-story stucco, with 4 bedrooms, 3 baths. Luxury vinyl plank flooring throughout, with plush carpet only in bedrooms and tile in the laundry room and bathrooms. The kitchen boasts a 5-burner gas cooktop and nice island with beautiful quartz countertops. Master suite has a bay window, a generous walk-in closet, double sinks, separate glass framed shower and a drop-in garden tub. Come live the difference!' ,`Acres` = '0.1435' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 35, Block 1, Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.739441' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704784' WHERE `Matrix_Unique_ID` = '208244754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:05:41.400' ,`MLSNumber` = '24974578' ,`ListAgentFullName` = 'Candice Garner' ,`ListOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950597' ,`Longitude` = '-96.273615' ,`PhotoCount` = '11' ,`PostalCode` = '77418' ,`RoomCount` = '5' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Phlox' ,`StreetNumber` = '128' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1495' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quaint Bellville home in town with a country feel. This home sits on roughly a 1/4 acre lot with a picturesque view.\r\n\r\n3 bedroom, 2 bath home with a covered patio is situated in the Meadows area of Bellville. Tall living room ceilings. Fresh landscaping & paint in 2020, updated kitchen, gorgeous view with a spacious backyard. 2 car attached garage.\r\n\r\nSchedule an appointment to see this beautiful home today!' ,`Acres` = '0.2972' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTH FORTY SUB SEC 2 LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12946' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Forty Sub' ,`TaxAmount` = '3857' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704784' WHERE `Matrix_Unique_ID` = '208384644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:06:58.667' ,`MLSNumber` = '30618987' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.538428' ,`Longitude` = '-95.092132' ,`PhotoCount` = '25' ,`PostalCode` = '77058' ,`RoomCount` = '7' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Carriage' ,`StreetNumber` = '18602' ,`StreetSuffix` = 'Court' ,`City` = 'Nassau Bay' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story, 4 bedroom (or 3 bedroom + home office), 2 1/2 bath, 2 car garage home in highly desirable Nassau Bay. Corner oversized lot on 0.29 acres with large trees and a spacious park-like backyard for relaxation. Close to neighborhood parks, restaurants, shopping, marina, post office, hospital, watersports, and recreation. 2,826 sqft, fireplace, open floor plan, formal living and dining rooms, upstairs bonus/game room. Central Heat & A/C, electric appliances, wood flooring in living area, carpeted bedrooms Built in 1966, never flooded!! Elementary school: Robinson Elementary School (Clear Creek) Middle School: Space Center Intermediate School High School: Clear Creek High School' ,`Acres` = '0.2893' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 21 NASSAU BAY SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '12600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '126' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nassau Bay Sec 04' ,`TaxAmount` = '7839' ,`TaxRate` = '2.4882' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704784' WHERE `Matrix_Unique_ID` = '208412837' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:23:19.113' ,`MLSNumber` = '42864176' ,`ListAgentFullName` = 'Norman Edmonson' ,`ListOfficeName` = 'Edmonson & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.298273' ,`Longitude` = '-94.780901' ,`PhotoCount` = '20' ,`PostalCode` = '77550' ,`RoomCount` = '4' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue N' ,`StreetNumber` = '1420' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic 2 bedroom 1 bath home located about 1.5 blocks from the beach. Beautifully updated in 2016 including plumbing, electrical, roof, impact windows quartz counters to name a few. High ceilings and a lot of natural light adds to the spacious feel of this home. Over 700 square feet under home for storage. Fenced back and front yard. Cute picnic table built around huge oak tree. Home is furnished (some exclusions). Perfect Island home to make your dreams come true.' ,`Acres` = '0.059' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR W 1/2 OF LOT 12 (2012-2) SW BLK 22 G' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2568' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '4456' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704784' WHERE `Matrix_Unique_ID` = '208592819' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:55:59.257' ,`MLSNumber` = '94641711' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.494364' ,`Longitude` = '-95.389260' ,`PhotoCount` = '5' ,`PostalCode` = '77578' ,`RoomCount` = '11' ,`ListPrice` = '489990.00' ,`Status` = 'Active' ,`StreetName` = 'Whitney Crest' ,`StreetNumber` = '4338' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 4059 Plan. Beautiful 2-story brick, with 4 bedrooms, 3 baths. High ceilings at the entry and Great Room. Luxury vinyl plank flooring throughout first floor, with plush carpet only in bedrooms, game room and tile in the laundry room and bathrooms. The kitchen boasts a 5-burner gas cooktop and nice island with beautiful quartz countertops in the kitchen, granite in the primary bath. Primary suite has a bay window, a generous walk-in closet, double sinks, separate glass framed shower and a drop-in garden tub. Come live the difference!' ,`Acres` = '0.1959' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6253' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.73944' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704784' WHERE `Matrix_Unique_ID` = '208730479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:14:44.077' ,`MLSNumber` = '56351943' ,`ListAgentFullName` = 'Kenneth Willis' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = 'Fatma Pecen' ,`SellingOfficeName` = 'US Realty Group Inc.' ,`Latitude` = '29.647101' ,`Longitude` = '-95.743847' ,`PhotoCount` = '35' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '785000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Purdy Crescent' ,`StreetNumber` = '8930' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4197' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4/4.5/4 home that is loaded with over 100K in builder upgrades. The backyard oasis (150K plus) comes with large private pool, hot tub, covered patio, pergola and an outdoor kitchen. This home has a fourth car garage with AC for multipurpose use. This home features a large open floorplan with vaulted ceiling, and large windows filling home with natural light. The gourmet kitchen with top notch cabinetry, upgraded stainless steel appliances, and large island opening to the living room. The downstairs features two primary bedrooms with large closets. The downstairs is complete with a formal dining room, large study and a wine grotto perfect for entertaining. The upstairs, has two spacious bedrooms, large media room, and oversize game room with large walk out balcony overlooking your beautiful travertine surrounded pool. This is a must see no expenses was spared!! Buyer fell through.' ,`Acres` = '0.2426' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LONG MEADOW FARMS SEC 36, BLOCK 2, LOT 8' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10569' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '835' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PECAN GROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Long Meadow Farms Sec 36' ,`TaxAmount` = '12956' ,`TaxRate` = '2.4929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704785' WHERE `Matrix_Unique_ID` = '208764759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:56:51.453' ,`MLSNumber` = '75797636' ,`ListAgentFullName` = 'Larry Durham' ,`ListOfficeName` = 'Durmoye Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '27.300880' ,`Longitude` = '-98.675179' ,`PhotoCount` = '7' ,`PostalCode` = '78361' ,`RoomCount` = '3' ,`ListPrice` = '74097.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar' ,`StreetNumber` = '702' ,`StreetSuffix` = 'Street' ,`City` = 'Hebbronville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional one story corner lot home. Excellent opportunity for the right investor, or owner occupant. This home is a corporate REO being sold ‘As is’, and currently Occupied. Please DO NOT Disturb occupants, as this home is being sold by Seller, and the purchaser will have to initiate the current occupant’s departure. Currently there are NO interior photos, and no verifiable measurements, excepting from the appraisal districts.' ,`Acres` = '0.3214' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '7,8 9 HILLCREST' ,`LotDesciption` = 'Corner' ,`LotSize` = '14000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '628 - Jim Hogg County' ,`SchoolElementary` = 'HEBBRONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEBBRONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'HEBBRONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Revised Hillcrest Add' ,`TaxAmount` = '2844' ,`TaxRate` = '2.7205' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704785' WHERE `Matrix_Unique_ID` = '208824994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:52:38.693' ,`MLSNumber` = '21634169' ,`ListAgentFullName` = 'Karen Rice' ,`ListOfficeName` = 'The Michael Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.320361' ,`Longitude` = '-95.444060' ,`PhotoCount` = '28' ,`PostalCode` = '75835' ,`RoomCount` = '7' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Grace' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Street' ,`City` = 'Crockett' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'English Tudor brick home with cottage feel. Fireplace and French doors compliment the Living area, original beautiful wood floors. 2 bedrooms with primary bath in between. Formal Dining room with quaint kitchen. Den furnishes extra room for tv or hobbies. Located on popular S. Grace Street in Crockett Texas, close to downtown with plenty of shopping and restaurants. Front porch has enough room for rocking chairs to watch the local traffic. Backyard is partially fenced for your pets. Remainer of backyard is also fenced and has large trees with plenty of shade also enough room for a pool or spa. Converted garage is a great workshop. Great place or your starter home, a must see.' ,`Acres` = '0.3' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SMITH ADD PT LOT 19 BLK 2' ,`LotDesciption` = 'Wooded' ,`LotSize` = '13068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Smith Add' ,`TaxAmount` = '2717' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1937' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704785' WHERE `Matrix_Unique_ID` = '208855217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:57:37.673' ,`MLSNumber` = '81588963' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492608' ,`Longitude` = '-95.386226' ,`PhotoCount` = '5' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '619990.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Creek' ,`StreetNumber` = '5618' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3715' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 5069 Plan. Beautiful 2-story stucco exterior, 3-car garage, with 5 bedrooms, 4-1/2 baths! 2 Bedrooms down. Luxury vinyl plank flooring throughout, with plush carpet only in bedrooms and tile in the laundry room and bathrooms. The kitchen boasts a built-in oven and microwave tower, a 5-burner gas cooktop and an oversized island with beautiful granite countertops. Primary suite has a bay window, a super-sized walk-in closet, double sinks, separate glass framed shower and a deep garden tub. A stacking sliding door opens up your Casual Dining to the oversized outdoor living space. The Great Room and Foyer have 19\' ceiling. Upstairs includes a game room and media room pre-wired with 7.1 surround sound. Study cove tucked away upstairs. Come live the difference!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 1, Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8475' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`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` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.73944' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704785' WHERE `Matrix_Unique_ID` = '208899448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:21:55.170' ,`MLSNumber` = '31521287' ,`ListAgentFullName` = 'Jenifer Duguay' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542106' ,`Longitude` = '-95.074455' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '1650000.00' ,`Status` = 'Active' ,`StreetName` = 'Pegasus' ,`StreetNumber` = '729' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Vacation all year round in this custom waterfront home located in the highly desirable gated community of Constellation Pointe.Beautiful 4 bed/4.5 bath home w/4,241 sq.ft. offers a one-of-a-kind floor plan.Impressive features include:wood clad garage door,double metal door w/glass inserts & wrought iron scroll.Large 2 story entry allows for great natural light.Travertine & wood style tile throughout 1st floor.Large formal dining rm leads to the butler\'s pantry.This gorgeous gourmet kitchen will bring out the inner chef.Tons of counter & storage space. Custom cabinets w/lighting.Viking stainless appliances include double door refrigerator/freezer, 6 burner gas range w/griddle, double oven & dishwasher. Beautiful copper style sink. The family rm showcases high ceilings, gas fireplace w/cast stone surround & serene views of the canal. Upstairs gameroom media & 3 bdrms.Grand primary suite w/office loft & large custom closet.Fabulous pool/spa/fire pit,outdoor kitchen & boat dock w/lift.' ,`Acres` = '0.1598' ,`Area` = '33' ,`BuilderName` = 'Edgewood Ventures' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'CONSTELLATION POINTE SEC 2 (2005) ABST 18, BLOCK 1, LOT 19,' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '6960' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Constellation Pointe' ,`TaxAmount` = '14220' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704785' WHERE `Matrix_Unique_ID` = '209071108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:57:47.330' ,`MLSNumber` = '25868003' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342672' ,`Longitude` = '-95.590496' ,`PhotoCount` = '9' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '291250.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury' ,`StreetNumber` = '910' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Camden floorplan - A beautiful brick and stone combination on the front elevation of this gorgeous home will wow you as you walk in. Then you are greeted by the giant island in White Napoli, with 42\" White Cabinets featuring heave brushed nickel T-Bar pulls. The stainless stove, dishwasher and microwave finish out the modern design, topped off by 3x6 backsplash in a beautiful white matte finish. The primary bathroom suite features quartz countertops, and separate tub and shower. Luxury vinyl planking is throughout the home in a beautiful shade of mushroom. This lake community would be perfect for primary residence or for a week end home located less than a mile from Lake Conroe.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5601' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapel Run' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704785' WHERE `Matrix_Unique_ID` = '209109956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:28:33.133' ,`MLSNumber` = '10571039' ,`ListAgentFullName` = 'Dana Olejniczak' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = 'Jamie McMartin' ,`SellingOfficeName` = 'Compass RE Texas, LLCKaty' ,`Latitude` = '30.024705' ,`Longitude` = '-95.161891' ,`PhotoCount` = '49' ,`PostalCode` = '77346' ,`RoomCount` = '12' ,`ListPrice` = '1679999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kings River' ,`StreetNumber` = '7402' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '7204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for a lake front property? Here it is. A gorgeous estate nestled in the heart of a cul-de-sac, tucked away behind a gated driveway. Located in the exclusive manned gated community of Kings River Estates, this home has it all. Refreshing pool, outdoor kitchen, expansive covered deck along the back to enjoy the sunset, large Guest suite downstairs, additional Primary bedroom upstairs and an elevator. The Chef\'s kitchen is the heart of the home with sweeping countertops, Viking oven with 6 burners and a grill, 2 dishwashers all open to the family room and beautiful picture windows to make sure there is a view from every room. The exquisite Primary bedroom is tucked away for privacy with a spa like expansive bath complete with his/ her custom closets, walk through double shower and relaxing tub with waterfall fixture. Upstairs is a wonderful family area with a balcony to step out and enjoy the view, refreshment area, and a hidden room.' ,`Acres` = '1.1971' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10, BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '52144' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Kings River Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704785' WHERE `Matrix_Unique_ID` = '209176478' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:33:25.420' ,`MLSNumber` = '73846516' ,`ListAgentFullName` = 'Richard Tanner' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.461571' ,`Longitude` = '-95.026307' ,`PhotoCount` = '7' ,`PostalCode` = '77539' ,`RoomCount` = '5' ,`ListPrice` = '310400.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Maison' ,`StreetNumber` = '4405' ,`StreetSuffix` = 'Circle' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this private gated waterfront community!! This charming home is near the bayou with a greenbelt behind it. The 1820 open floor plan offers three bedrooms and an office. Formal dining opens into living and kitchen making entertaining easy! All Adams homes offer granite counter-tops, stainless steel appliances, brush nickel finishes, fully sodded front and back yards and much more. Bayou Maison is conveniently located between I-45 and 146. This community will have a marina and park area on Dickson Bayou!!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 2 Block 1 sec 3 Bayou Maison' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Maison' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704786' WHERE `Matrix_Unique_ID` = '209307693' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:48:14.093' ,`MLSNumber` = '3715159' ,`ListAgentFullName` = 'Andrea Curran' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.130981' ,`Longitude` = '-95.703743' ,`PhotoCount` = '38' ,`PostalCode` = '77355' ,`RoomCount` = '8' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'Alton Wright' ,`StreetNumber` = '33114' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully renovated custom home nestled on 4.28 partially wooded acres in the Magnolia community Walnut Creek on a tranquil street. High ceilings and plantation shutters featured throughout. Open kitchen with new granite countertops, recently painted cabinets, subway tile backsplash, stainless steel appliances, gas cooktop and an oversized island with breakfast bar. Private first floor owners retreat with crown molding, dual granite topped vanity, soaking tub, separate shower enclosure and a walk-in closet. Open family room with dual fireplace and soaring ceiling. Spacious second floor game room with custom wood accent wall. Backyard oasis featuring a pool with rock waterfall and an extended rear patio for outdoor entertaining. Just beyond on the fence are multiple out buildings and two full barns.Zoned to top rated Tomball ISD.' ,`Acres` = '4.248' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT CREEK FOREST 02, LOT 17,18, ACRES 4.248' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '185043' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Creek Forest' ,`TaxAmount` = '9112' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704786' WHERE `Matrix_Unique_ID` = '209340773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:56:54.637' ,`MLSNumber` = '97860347' ,`ListAgentFullName` = 'Tenzesta Smith' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435385' ,`Longitude` = '-95.398025' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Napier' ,`StreetNumber` = '10135' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meridiana! At first sight, this single story 2021 Perry Home boasts a beautiful Brick and Stone elevation! Upon entry, you are greeted with a grand foyer with 12ft ceilings! A game room with glass French doors and an open concept kitchen and family room displaying a wall of windows with ample natural lighting. A bright modern kitchen featuring a generous size granite island w/ built-in seating space, a classy tile backsplash, and plenty of cabinetry. A private owner\'s suite with 12ft ceilings and an ensuite oasis with dual vanities, a centered soaker tub, a glass-enclosed dual-entry walk-in shower, and 2 large walk-in closets and separate water closet. 3 secondary bedrooms and 2 full baths and a guest bath. Relaxing 12ft outdoor covered patio with a premium Lake view and most importantly NO BACK NEIGHBORS!! This 4-bedroom 3.5-bath lake view! Schedule a showing today! Yes- This exquisite Perry Homes is covered under Builders Home Warranty' ,`Acres` = '0.1865' ,`Area` = '5' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 59 (A0287 HT&BRR) (IOWA COLONY) BLK 1 LOT 43' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Water View' ,`LotSize` = '8124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana Sec 59' ,`TaxAmount` = '5399' ,`TaxRate` = '3.6249' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704786' WHERE `Matrix_Unique_ID` = '209531139' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:53:21.203' ,`MLSNumber` = '29284391' ,`ListAgentFullName` = 'Christine Hale' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726774' ,`Longitude` = '-95.299031' ,`PhotoCount` = '43' ,`PostalCode` = '77023' ,`RoomCount` = '6' ,`ListPrice` = '349999.00' ,`Status` = 'Active' ,`StreetName` = 'Pasadena' ,`StreetNumber` = '1728' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'True pride in ownership shows in this cozy cottage home! This home offers 2 bedrooms, 1 bath in the main house, and an entire garage apartment that can be used as income-producing or home office. This home is conveniently located close to the city, yet still captures a sought-after quiet and peaceful atmosphere. All within a short walk to Gus Wortham Golf Course, Mason Park, Bayou Hiking, and Bike trails. Transportation is made easy with this home located just minutes from Metro Rail, Downtown, Medical Center, University of Houston, Botanic Gardens and Hobby Airport. You don’t want to miss this unique home in heart of the East End!' ,`Acres` = '0.2234' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 267 FOREST HILL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9731' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRISCOE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Hill' ,`TaxAmount` = '4529' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704786' WHERE `Matrix_Unique_ID` = '209558389' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:46:36.923' ,`MLSNumber` = '46556428' ,`ListAgentFullName` = 'Juanita Christie' ,`ListOfficeName` = 'Alford Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.044089' ,`Longitude` = '-95.695333' ,`PhotoCount` = '39' ,`PostalCode` = '77480' ,`RoomCount` = '3' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Brockman' ,`StreetNumber` = '706' ,`StreetSuffix` = 'Street' ,`City` = 'Sweeny' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2078' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SPACIOUS 3 BED, 2 BATH FAMILY HOME WITH ADORABLE CURB APPEAL IN THE HEART OF SWEENY. TWO LIVING AREAS, LARGE DINING, EFFICIENT KITCHEN, DEDICATED LAUNDRY ROOM. ENTER THE BEAUTIFUL BACKYARD FROM A FAMILY AND FRIENDS SIZE COVERED PATIO. TAKE IN THE SHADE FROM A MASSIVE LIVE OAK WHILE ENJOYING THE BBQ AND OUTDOOR DINING THAT STAYS. BACKYARD ALSO HAS A 240 SQFT SHOP LARGE ENOUGH FOR ALL YOUR YARD EQUIPMENT AND WORK AREA. DRIVE YOUR MOWER RIGHT IN. 2 CAR CARPORT. JUST MINUTES FROM HWY 35, PHILLIPS66, BAY CITY, ANGLETON, AND THE PORT. LESS THAN AN HOUR FROM HOUSTON PROPER. CENTRALLY LOCATED CLOSE TO SISD SCHOOLS, PARKS, SHOPPING, AND THE HOSPITAL. SMALL TOWN LIVING WITH ALL THE AMENITIES!' ,`Acres` = '0.322' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MACDONALD (SWEENY TR 53-57-58) LOT 29-29A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14026' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macdonald Sweeny Tr 53-57-58' ,`TaxAmount` = '4719' ,`TaxRate` = '2.8427' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704786' WHERE `Matrix_Unique_ID` = '209626374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:07:44.170' ,`MLSNumber` = '14953580' ,`ListAgentFullName` = 'Eduardo Rangel' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970893' ,`Longitude` = '-95.611362' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '670000.00' ,`Status` = 'Active' ,`StreetName` = 'Lismore Lake' ,`StreetNumber` = '11943' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**IMMACULATE AND PRIVATE** \r\n\r\n* RESORT/EXCLUSIVE GATED COMMUNITY!! \r\n\r\n*AWESOME WATERFRONT DREAM!! * HEATED POOL WITH SPA!!\r\n\r\n* Beautiful house with Amazing 2-story entry.\r\n \r\n* Study with French Doors and wood floors downstairs.\r\n\r\n* Kitchen with island, walk-in pantry, granite countertops and Stainless Steel appliances.\r\n\r\n* Wonderful view from the Den to the lake and the AMAZING backyard with Heated Pool and Spa!!\r\n\r\n* Wonderful balcony with view of the lake and fountains. Direct access to the lake with Boat Slip and Wooded Deck.\r\n\r\n * Game Room upstairs with 4 Bedrooms and 2 baths upstairs. note: Common Areas upstairs an first floor master bedroom.\r\n\r\n* NOTE: NEW WOOD FLOORS, AN NEW BATHROOM IN THE MASTER BEDROOM, FRESH NEW PAINT, A FEW UPDATES IN THE ENTIRE HOUSE, COME AN SEE INSIDE.' ,`Acres` = '0.1723' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 1 LISMORE LAKE ESTATES' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '7507' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lismore Lake Estates' ,`TaxAmount` = '10819' ,`TaxRate` = '2.7587' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704786' WHERE `Matrix_Unique_ID` = '209645748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:58:30.273' ,`MLSNumber` = '37857793' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492608' ,`Longitude` = '-95.386226' ,`PhotoCount` = '8' ,`PostalCode` = '77578' ,`RoomCount` = '11' ,`ListPrice` = '799990.00' ,`Status` = 'Active' ,`StreetName` = 'Limestone Terrace' ,`StreetNumber` = '4134' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 5051 plan with stucco exterior. Beautiful 2-story, one of Shea\'s most popular homes! 3-car garage w/5\' storage, 5 bedrooms, 4 full & 2 half baths. Downstairs secondary bedroom ensuite. Walk-in closets in all upstairs bedrooms. Luxury vinyl plank flooring throughout downstairs, with plush carpet only in bedrooms & tile in the laundry room and bathrooms. Kitchen boasts built-in double ovens, a 5-burner gas cooktop & 2 islands with granite countertops. Primary suite has a bay window, a huge walk-in closet, double sinks with quartz countertops, & our signature spa bath with a free-standing tub within the glass framed shower. Study enclosed with french doors, a 16\'stacking sliding door opens up your dining and great room to the oversized outdoor living area! Also, home comes equipped with an entertainment bar with a bi-fold window! Upstairs has a game room & media room pre-wired with 7.1 surround sound. Great yard for pool with lake views! Come Live the Difference in a Shea Home!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 1, Section 6' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '10930' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.73944' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704786' WHERE `Matrix_Unique_ID` = '209889339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:47:02.680' ,`MLSNumber` = '74705703' ,`ListAgentFullName` = 'Ashley Podraza' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.139747' ,`Longitude` = '-95.667412' ,`PhotoCount` = '50' ,`PostalCode` = '77355' ,`RoomCount` = '7' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Wright' ,`StreetNumber` = '33080' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRESTRICTED 3 story, 4 bed/4 bath stone & stucco barndominium built in 2015 on a corner lot. Elevated living with panoramic views from 2nd and 3rd floor balconies allowing natural sunlight to illuminate the space. Kitchen boasts custom hickory cabinetry with LED under and over lighting, 14’ turquoise quartzite island with above pendant lighting, and leathered granite wraparound. Also including Thermador Professional Appliances; double convection oven, under counter drawer microwave, built-in refrigerator and freezer, 6 burner and griddle gas rangetop and commercial vent hood. Primary bath has a double entry walk-in shower with dual rain shower and wand, Airtub Jacuzzi bathtub, and chrome fixtures. 2.5 car garage + workshop. 30’x40’ RV/boat storage with copper metal roofing and 15’ceiling. 1st floor pre-plumbing, gas, and electrical for build out for a full working kitchen, bar, and 5th bathroom by future owner. Elevator capability. Don’t miss this truly unique home in Tomball ISD' ,`Acres` = '1' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0361 - MOORE JOHN, TRACT 10-D, ACRES 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Barndominium,Ranch' ,`Subdivision` = 'Unrestricted' ,`TaxAmount` = '9031' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704787' WHERE `Matrix_Unique_ID` = '210078793' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:59:48.337' ,`MLSNumber` = '85515150' ,`ListAgentFullName` = 'Francisco Ortiz' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669346' ,`Longitude` = '-95.571314' ,`PhotoCount` = '41' ,`PostalCode` = '77099' ,`RoomCount` = '5' ,`ListPrice` = '685000.00' ,`Status` = 'Active' ,`StreetName` = 'Kinney Road' ,`StreetNumber` = '10024' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home ready for move in. Oversized 3 car detached garage. Covered back porch.' ,`Acres` = '' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 Richmond Rd Est Par R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'OLLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Richmond Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704787' WHERE `Matrix_Unique_ID` = '210216053' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:25:43.130' ,`MLSNumber` = '52147333' ,`ListAgentFullName` = 'Luke Moses' ,`ListOfficeName` = 'Loft Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.890206' ,`Longitude` = '-94.034682' ,`PhotoCount` = '23' ,`PostalCode` = '77640' ,`RoomCount` = '3' ,`ListPrice` = '117500.00' ,`Status` = 'Active' ,`StreetName` = 'Manning' ,`StreetNumber` = '2853' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Handyman special! Every man\'s dream! 900+ square foot garage on its own driveway with a bathroom. The home sits on two lots and has a lot of potential. Come and make it yours!' ,`Acres` = '0.3701' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 & LT 18 BLK 3 MANNING' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'PORT ACRES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Manning To Port Acres 1' ,`TaxAmount` = '2915' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704787' WHERE `Matrix_Unique_ID` = '210490056' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:14:40.913' ,`MLSNumber` = '20810378' ,`ListAgentFullName` = 'Michael Mullis' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Leslie Boudreaux' ,`SellingOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`Latitude` = '29.153150' ,`Longitude` = '-95.421695' ,`PhotoCount` = '16' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '189000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Southside' ,`StreetNumber` = '725' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 725 Southside! This Gorgeous 3 Bedroom home on a Large 14,000 square foot Lot with Pool. Breakfast Room and Formal Dining Room with enough space for your furniture, Family and Guest. Updated Kitchen with Granite Countertops with Tile Back-Splash with enough space to cook and store your cookware. Large size bedrooms with walk-in closets and plenty of natural lighting. Two Linen Closets in Hallway and plenty of Storage throughout. Updated Bathroom with Walk-in Bathtub/Shower. Large Utility Room with Washer and Dryer hookups and enough room to separate and fold clothes. Covered Back Porch overlooking Swimming Pool with area for Grilling and Entertaining. Home has Landscaping all around with Flower Beds in the Front and Back Yard and Privacy Shrubs lining the front of the Property. Walking or Bike Riding is a quick trip to Southside Elementary School. Minutes from Downtown Angleton with plenty of shopping and dining and conveniently located close to 35 and 288.' ,`Acres` = '0.3198' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PECAN PARK TERRACE (ANGLETON) BLK 4 LOT 13' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Park Terrace Angleton' ,`TaxAmount` = '3191' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704787' WHERE `Matrix_Unique_ID` = '210565219' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:57:13.310' ,`MLSNumber` = '10390001' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Hiba Tawil' ,`SellingOfficeName` = 'Royalty Realty' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '276990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ternberry Forest Lane' ,`StreetNumber` = '5118' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING NEW D. R. HORTON BUILT 1 STORY 3 BEDROOM! Desirable Split Plan Layout with Private Primary Suite! Gourmet Island Kitchen with Lots of Cabinetry - Opens to Spacious Dining Area & Living Room! Large Primary Suite with Spacious Walk-In Closet & Pretty Bath! Nicely Sized Secondary Bedrooms! Generously Sized Indoor Utility Room with Direct Garage Access! Hard Surface Flooring in Living Area! Covered Back Patio! Estimated Completion - October 2022.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 35 - Block 2 - Section 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5864' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704787' WHERE `Matrix_Unique_ID` = '210765697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:42:41.013' ,`MLSNumber` = '74291639' ,`ListAgentFullName` = 'Ana Remperas' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.591821' ,`Longitude` = '-95.748558' ,`PhotoCount` = '34' ,`PostalCode` = '77406' ,`RoomCount` = '11' ,`ListPrice` = '418000.00' ,`Status` = 'Active' ,`StreetName` = 'Fountain Bend' ,`StreetNumber` = '48' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2,754 one story home with 4 bedrooms, 3 full bathrooms, a study, formal dining and breakfast area built by David Weekley Homes in River\'s Edge . NO BACK NEIGHBORS and very low maintenance backyard. 10 (Ten) foot ceilings throughout the home. Tile and wood in all areas. 3(Three) Car Tandem Garage. Experience living at its finest in the impeccable style and refined comfort of the Essence floor plan. Open concept family and breakfast area offer a great ideal living space. The chef\'s specialty kitchen features a corner pantry and presentation island. Spacious study presents a versatile home office or craft room or media room. Relaxing and family gatherings under the covered patio with no back neighbors backyard will be a great added feature of this awesome home.' ,`Acres` = '0.1804' ,`Area` = '37' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERS EDGE SEC 17, BLOCK 4, LOT 17' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7859' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rivers Edge Sec 17' ,`TaxAmount` = '7479' ,`TaxRate` = '2.8948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704787' WHERE `Matrix_Unique_ID` = '211069833' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:58:05.330' ,`MLSNumber` = '95677503' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492608' ,`Longitude` = '-95.386226' ,`PhotoCount` = '12' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '741125.00' ,`Status` = 'Active' ,`StreetName` = 'Dancing Oaks' ,`StreetNumber` = '5815' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes Plan 6025. Est. Completion 1/2023. This inviting and spacious single story home offers 4 bedrooms, 3.5 baths, and a 3 car tandem garage. As you walk through the gorgeous rotunda in the entry, you will find hallways that lead to the secondary bedrooms. A separate hallway leads to the Study with French doors and a very spacious Media Room, perfect for movie nights at home! The Great Room awaits at the end of the hall with a 12\' ceiling and stacked slider doors that fill the space with natural light. An oversized Casual Dining Room leads out to your extended covered patio and oversized outdoor oasis with complete privacy! Back inside, the gourmet Kitchen includes cabinets galore, double ovens, a 5 burner gas cooktop, large kitchen island and a dream oversized walk-in pantry! The private primary suite is the perfect place to relax featuring a bay window and spa like bathroom with dual vanities, free-standing tub and separate shower. Come and Live the Difference in a Shea Home!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 1, Section 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14469' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.73944' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704787' WHERE `Matrix_Unique_ID` = '211093321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:11:24.110' ,`MLSNumber` = '57453269' ,`ListAgentFullName` = 'Valerie Diaz' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.650184' ,`Longitude` = '-95.737714' ,`PhotoCount` = '24' ,`PostalCode` = '77406' ,`RoomCount` = '11' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Carters Lake' ,`StreetNumber` = '3938' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful two story home, 5 bedroom, 3 1/2 baths and a large size Gameroom. Includes both formals, beautiful backyard with a five year old swimming pool, perfect for entertainment. The floor plan in amazing with an open concept kitchen, Dorian counter tops, gas range, separate tub and shower in the primary bathroom and double sinks. High ceilings in the living room and lots of natural light. Property located on a cul-de-sac in the Waterside Estates community. This property will not last long, so don\'t wait. This amazing home is perfect to raise a large size family and it is zone to good schools. The Diaz Team!' ,`Acres` = '0.2253' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE ESTATES SEC 11, BLOCK 1, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9815' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Estates Sec 11' ,`TaxAmount` = '7593' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704788' WHERE `Matrix_Unique_ID` = '211224445' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:57:05.397' ,`MLSNumber` = '20066533' ,`ListAgentFullName` = 'Stacie Hoyt' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.316780' ,`Longitude` = '-96.086871' ,`PhotoCount` = '9' ,`PostalCode` = '77488' ,`RoomCount` = '2' ,`ListPrice` = '129900.00' ,`Status` = 'Active' ,`StreetName` = 'Alabama' ,`StreetNumber` = '1107' ,`StreetSuffix` = 'Road' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! This one room, one bathroom is the perfect place for your next idea. Drive through window for easy convivence for your clients and great driveway access. Call today to schedule an appointment.' ,`Acres` = '0.2326' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'MAYFAIR BLOCK 3 LOT 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10132' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Mayfair' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704788' WHERE `Matrix_Unique_ID` = '211236896' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:02:24.677' ,`MLSNumber` = '50470133' ,`ListAgentFullName` = 'Mary Brawner' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.720596' ,`Longitude` = '-95.068754' ,`PhotoCount` = '10' ,`PostalCode` = '77351' ,`RoomCount` = '1' ,`ListPrice` = '49900.00' ,`Status` = 'Active' ,`StreetName` = 'Oakridge' ,`StreetNumber` = '365' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute unfinished cabin with a ton of potential. Located on two large lots, totalling one quarter of an acre, this cabin has a rustic front porch and a nice size living area, quaint kitchen and full bath downstairs with toilet and shower. Up the staircase is the only bedroom. Lots of large windows for tons of natural light. Cabin is unfinished and needs some final touches to make it a full-time home or a wonderful weekend retreat. Close to Lake Livingston, this subdivision offers lake access and has a swimming pool and clubhouse for property owners. Come check it out today.' ,`Acres` = '0.25' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE SECTION 13 LOT 563' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10702' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Lake Livingston Village' ,`TaxAmount` = '313' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704788' WHERE `Matrix_Unique_ID` = '211389587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:17:28.157' ,`MLSNumber` = '39783502' ,`ListAgentFullName` = 'Dawn Faust' ,`ListOfficeName` = 'Flat Fee Discount Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.237962' ,`Longitude` = '-95.137989' ,`PhotoCount` = '10' ,`PostalCode` = '77372' ,`RoomCount` = '9' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Diamond T' ,`StreetNumber` = '27364' ,`StreetSuffix` = '' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1921' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRESTRICTED! Beautiful freshly remodeled 3 Bedroom 2 Full Bath home located in the highly south after Splendora ISD. Corner lot\r\nthat is almost half an acre and is partially fenced. Large covered front porch, Back deck, Extra-Large detached garage/workshop. Easy\r\naccess to Hwy 59, Valley Rach Shopping Center, Highway 99, Restaurants and More. This property could be used to run a business or\r\nmake a great home with a big yard and a large workshop/garage. Call to make an appointment to see this home today before it is gone! Realtors, please see Agent Remarks in the MLS for showing instructions.' ,`Acres` = '0.4419' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S585001 - HOLIDAY OAKS 01, BLOCK 8, LOT 31, ACRES 0.43' ,`LotDesciption` = 'Cleared' ,`LotSize` = '19250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holiday Oaks 01' ,`TaxAmount` = '4931' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704788' WHERE `Matrix_Unique_ID` = '211395284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:02:18.263' ,`MLSNumber` = '69825191' ,`ListAgentFullName` = 'Julian Moreno' ,`ListOfficeName` = 'Acres Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.439997' ,`Longitude` = '-95.575779' ,`PhotoCount` = '43' ,`PostalCode` = '77318' ,`RoomCount` = '3' ,`ListPrice` = '674000.00' ,`Status` = 'Active' ,`StreetName` = 'Jbk Memorial' ,`StreetNumber` = '13546' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the incredibly rare 3.5-acre property in the well-renowned Bridgepoint subdivision. Featuring a private boat dock located in the subdivision, close proximity to I45, many shopping centers, and other entertainment. \r\n\r\nThe property boasts all of the following features; a new roof, appliances, energy-efficient windows, siding/hardy plank, and sits on 26 bell bottom piers. This home was built by the family of the current owner with love and care. \r\n\r\nThe property has a large three-car garage and an apartment above the garage with a full kitchenette and its own bathroom. The property features a 1/2 acre pond stocked with blue catfish. \r\n\r\nIf you appreciate beautiful trees, the property has large beautiful trees; from pecan to peach, to black walnut, to magnolia, oak, and cedar.\r\n\r\nThis property is one of a kind and ready for a new family.' ,`Acres` = '3.5' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BRIDGEPOINT UNRECORDED, LOT 43, 44-A, ACRES 3.500' ,`LotDesciption` = 'Other' ,`LotSize` = '152460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '90' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Bridgepoint Unrec' ,`TaxAmount` = '6975' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704788' WHERE `Matrix_Unique_ID` = '211434307' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:00:46.163' ,`MLSNumber` = '65153378' ,`ListAgentFullName` = 'Thomas Saunders' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = 'Brian Brady' ,`SellingOfficeName` = 'Doug Erdy Group' ,`Latitude` = '30.057535' ,`Longitude` = '-95.219417' ,`PhotoCount` = '28' ,`PostalCode` = '77339' ,`RoomCount` = '5' ,`ListPrice` = '310000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Shadow Rock' ,`StreetNumber` = '2063' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1916' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Original Owner. Superior Condition Single Story Home in the sought after South Woodland Hills neighborhood. Formal dining room off of entry. Living room with high ceiling and backyard view is open to breakfast room. Insulated windows! Plantation Shutters! Kitchen is open to breakfast room and features ample cabinet & counter space with beautiful granite countertops. Spacious master suite with enough space for a sitting area. Sparkling pool and Huge covered patio/outdoor living area with ceiling fans and stained concrete floors. 30 Year roof. Recently replaced concrete driveway and walkway. Zoned to exemplary Humble ISD Schools, and near the front of Kingwood! The neighborhood pool and park are just down the street. Close to shopping and dining, as well as easy access to Highway 59 and 99. This is a rare find! Come see this home today.' ,`Acres` = '0.2222' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 33 WOODLAND HILLS VLG SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WOODLAND HILLS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Hills Village Sec 01' ,`TaxAmount` = '4633' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704788' WHERE `Matrix_Unique_ID` = '211505656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:55:38.137' ,`MLSNumber` = '66019790' ,`ListAgentFullName` = 'Craig Flannery' ,`ListOfficeName` = 'Ppmg of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775082' ,`Longitude` = '-95.008629' ,`PhotoCount` = '10' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Gayla' ,`StreetNumber` = '5323' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1122' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Affordable and ready for move in immediately! Come check out this clean 1 story home in great neighborhood with no HOA dues! Home has been remodeled, updates and upgrades include: fresh paint, countertops, electrical repairs with fans and fixtures, some new flooring, gutters, new heat and air, added some insulation, brand new roof, plumbing updates with new water heater, and so much more!' ,`Acres` = '0.1364' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 3 DECKER TERRACE R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '5940' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Decker Terrace R/P' ,`TaxAmount` = '3237' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704788' WHERE `Matrix_Unique_ID` = '211519393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:42:36.550' ,`MLSNumber` = '23710963' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.102084' ,`Longitude` = '-95.394741' ,`PhotoCount` = '40' ,`PostalCode` = '77515' ,`RoomCount` = '9' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Amberjack' ,`StreetNumber` = '32102' ,`StreetSuffix` = 'Drive' ,`City` = 'Richwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the desired Oakwood Shores in Richwood! This is a stunning, custom build on 3 acres with 4 bedrooms, 3.5 bathrooms and a 2 car attached garage. The primary room is located on the first floor with a custom bathroom. The master bathroom has a jacuzzi tub and an open double shower with double sinks and walk in closets. The kitchen opens up to the living room with a 5 burner gas range, double ovens, and granite counter tops. The walk in panty is very spacious with plenty of shelving. There are 3 bedrooms upstairs and a game room. In the backyard, there is a storage building with a concrete pad. You won\'t want to miss out of this home, call today for your private showing!' ,`Acres` = '3' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Richwood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OAKWOOD SHORES (A0030-A0333) (RICHWOOD) BLK 3 LOT 107 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '130680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakwood Shores' ,`TaxAmount` = '13052' ,`TaxRate` = '2.6504' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704789' WHERE `Matrix_Unique_ID` = '211520829' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:01:34.617' ,`MLSNumber` = '7878666' ,`ListAgentFullName` = 'Kimberly Williams' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.067028' ,`Longitude` = '-95.416418' ,`PhotoCount` = '22' ,`PostalCode` = '77531' ,`RoomCount` = '7' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Four Oaks' ,`StreetNumber` = '327' ,`StreetSuffix` = 'Street' ,`City` = 'Richwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This awesome brick home sits on a huge corner lot and has been completely remodeled..It features 4/2/2 car detached garage with workshop. 2 living areas, Beautiful new kitchen with marble tile counter tops, stainless appliances, all new custom cabinets, walk-in pantry and an office/flex area. Family room with gas FP and a large den .Bedrooms are large in size. Huge fenced yard w/storage building. Indoor utility room..' ,`Acres` = '0.7042' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Richwood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'GLENWOOD BAYOU (A0066 J E GROCE)(RICHWOOD), BLOCK 18, LOT 10' ,`LotDesciption` = 'Cleared' ,`LotSize` = '30675' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenwood Bayou' ,`TaxAmount` = '4073' ,`TaxRate` = '2.6504' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704789' WHERE `Matrix_Unique_ID` = '211574100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:27:32.217' ,`MLSNumber` = '27515196' ,`ListAgentFullName` = 'Jennifer Parker' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.110886' ,`Longitude` = '-94.641827' ,`PhotoCount` = '14' ,`PostalCode` = '77575' ,`RoomCount` = '8' ,`ListPrice` = '84000.00' ,`Status` = 'Active' ,`StreetName` = 'Ash' ,`StreetNumber` = '208' ,`StreetSuffix` = 'Street' ,`City` = 'Daisetta' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This three bedroom, two bathroom home is situated on 0.2296 acres on a quiet street in Daisetta. The home features an open concept with a breakfast bar. The yard is partially fenced. Outside, you will find a nice size back yard. The parking is on concrete in front of a shop with walk through door on the side as well as a roll up door in the front.' ,`Acres` = '0.2296' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PARTLOW LEWIS-DAIS, BLOCK 1, LOT 7 8, ACRES .2296' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '108 - Hull-Daisetta' ,`SchoolElementary` = 'HULL-DAISETTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HULL-DAISETTA HIGH SCHOOL' ,`SchoolMiddle` = 'HULL-DAISETTA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Partlow Lewis-Dais' ,`TaxAmount` = '109' ,`TaxRate` = '2.2738' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704789' WHERE `Matrix_Unique_ID` = '211616070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:52:59.160' ,`MLSNumber` = '2967120' ,`ListAgentFullName` = 'Tammy Petterson' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.499196' ,`Longitude` = '-94.934137' ,`PhotoCount` = '48' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Starboard' ,`StreetNumber` = '135' ,`StreetSuffix` = 'Drive' ,`City` = 'San Leon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Everything is better close to the water! Welcome to 135 Starboard Drive in Mariner\'s Cove! This 2.5 story beauty sits behind the gates of this quaint canal community. Enjoy the Texas sunset from one of 3 balconies, or below on the ground-floor covered patio. Covered deck off the Primary for a true private retreat! The home boasts rich woods down, and lush new carpet (2022) in the bedrooms upstairs. Gorgeous chef\'s kitchen with rich maple cabinets, granite counters, stainless steel appliances, and, of course, a gas range. Sit-up bar seating overlooking the Family Room. Gas-log fireplace, crown molding, high ceilings! The second floor features the primary bedroom, ensuite and walk-in closet, and one of the secondary bedrooms with its\' own full ensuite, and laundry. The third floor has a landing area perfect for a work-from-home quiet space, and another deck for some Vitamin D3. The third bedroom is on this floor, and affords 100% privacy with its\' own ensuite. Come and see!' ,`Acres` = '0.109' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 10 A EDWARDS SUR MARINER\'S COVE SEC 2 (98), LOT 1, ACRE' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '4748' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2.5' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Mariners Cove Sec 2 98' ,`TaxAmount` = '6861' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704789' WHERE `Matrix_Unique_ID` = '211634879' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:33:45.167' ,`MLSNumber` = '94798822' ,`ListAgentFullName` = 'Inocencio Moncada' ,`ListOfficeName` = 'Las Lomas Realty Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.214018' ,`Longitude` = '-95.145844' ,`PhotoCount` = '29' ,`PostalCode` = '77372' ,`RoomCount` = '3' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Creek' ,`StreetNumber` = '26954' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'No Restrictions, Warehouse, Horse Stables. Welcome home to this little ranch in Splendora Tx sitting on 2 acres of cleared land. It has 4 bedrooms 2 bathroom. The laundry room is inside. It has a spacious living room, dining room and kitchen. There is no carpet in the rooms only title floors and wood floors. It has a large work/storage shed with electricity. There are also a few light posts in the yard. There is also a large covered deck in the back of the home. There is an eight-stall barn that also has a loft area.' ,`Acres` = '2.0353' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S748201 - OAK CREEK ESTATES 01, BLOCK 2, LOT 23,24, SERIAL #' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '88656' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Creek Estates 01' ,`TaxAmount` = '734' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704789' WHERE `Matrix_Unique_ID` = '211648217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:09:15.363' ,`MLSNumber` = '28843461' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832921' ,`Longitude` = '-95.857725' ,`PhotoCount` = '22' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '421790.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Gables' ,`StreetNumber` = '1549' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! 3 CAR GARAGE - AND OVERSIZED HOMESITE ON CUL-DE-SAC STREET! So Many Fabulous Features: Stainless Steel Appliances with Gas Cooktop, Grey Quartz Countertops, 42\" White Kitchen Cabinetry with Under Cabinet Lighting, Primary Bath with Separate Tub & Shower, Solid Surface Flooring, Tankless Water Heater, Oversized Covered Back Patio, & Full Sprinkler System! Wonderful Open Concept Design with Island Kitchen Open to Dining & Living Areas! Privately Located Primary Suite with Huge Walk-In Closet! Convenient Indoor Utility Room! Zoned to Katy ISD Schools! Easy Access to the Grand Parkway! Neighborhood Amenities Include GORGEOUS Crystal Lagoon & Amenity Village with Pool, Clubhouse, Lakes, Parks, PLUS MORE! WOW! Estimated Completion - February 2023.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNTERRA 15 BLK 1 LOT 13' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10206' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.629' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704789' WHERE `Matrix_Unique_ID` = '211727494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:13:31.353' ,`MLSNumber` = '48694503' ,`ListAgentFullName` = 'Jessica Githens' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.659180' ,`Longitude` = '-95.534168' ,`PhotoCount` = '41' ,`PostalCode` = '77340' ,`RoomCount` = '4' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Wimbledon' ,`StreetNumber` = '1600' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WATERFRONT HOME! Get away and relax in this custom, Mediterranean, two-story home, nestled along the quiet shores of Elkins Lake. You will fall in love with the views from this uniquely styled 3-bed home. The 2-story deck is where you\'ll enjoy watching the sun rise over the big lake. Grill and entertain on the upper deck or relax below on the Zen-like screened-in patio. Retreat to a spacious primary ensuite with a spa-like bath located on the 2nd floor along with two other bedrooms. The details in this home include coffered ceilings throughout, porcelain flooring, granite countertops, copper sink, custom kitchen cabinetry, and all SS appliances. Enjoy easy access to IH45, shopping, and Sam Houston State University. Spray foam ins & energy efficient windows here! Upgrades include: tankless water heater (22), exterior paint (22), dishwasher (20), porcelain tile, engineered wood floors (19), roof (16), and a Generac generator. A greenbelt protects the views from ever being obstructed.' ,`Acres` = '0.1033' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WEST LAKE SHORES - SEC 1, BLOCK 7, LOT 1A CONSISITING OF LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '198' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'ELKINS LAKE' ,`TaxAmount` = '5890' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704789' WHERE `Matrix_Unique_ID` = '211730629' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:07:59.660' ,`MLSNumber` = '19022539' ,`ListAgentFullName` = 'Jason Wyche' ,`ListOfficeName` = 'Traditions Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483561' ,`Longitude` = '-95.524372' ,`PhotoCount` = '34' ,`PostalCode` = '77459' ,`RoomCount` = '7' ,`ListPrice` = '659990.00' ,`Status` = 'Active' ,`StreetName` = 'Lazy Vine' ,`StreetNumber` = '2619' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Seller will contribute up to $14,500 to buy the interest rate down (reduced interest rate could drop the monthly payment significantly.)** Spectacular 4/4/3 - 2 story Shea Home in Sienna. 4 bedrooms, 3 bathrooms and study down, media room (with wet bar & wine refrigerator) game room, & full bathroom up. Wood floors throughout first floor except bathrooms. Home sits on a 10,000 sq ft lot with no neighbors behind and on one side of the home. Gourmet kitchen with huge island able to seat 5 comfortably, custom cabinets, double ovens, 5 burner gas cooktop. Kitchen opens to family room with a fireplace, cathedral ceilings and wood beams. Gorgeous primary suite with walk-in rain shower and garden tub inside, large walk-in closet, his and her sinks with vanity sitting area. Very spacious secondary bedrooms. 3 car tandem garage. Spacious covered patio & front/back sprinkler system. Family room, patio, & kitchen are wired for surround sound, Gas connection ready for future outdoor kitchen.' ,`Acres` = '0.248' ,`Area` = '38' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF DESTREHAN SEC 5, BLOCK 1, LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Destrehan' ,`TaxAmount` = '13759' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704790' WHERE `Matrix_Unique_ID` = '211757004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:32:35.940' ,`MLSNumber` = '53991611' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034745' ,`Longitude` = '-95.793306' ,`PhotoCount` = '7' ,`PostalCode` = '77447' ,`RoomCount` = '5' ,`ListPrice` = '280300.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Nut' ,`StreetNumber` = '17802' ,`StreetSuffix` = '' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OCTOBER COMPLETION. Spacious one story on large corner lot with open concept living in mind. Island kitchen has upgraded 42\" cabinets with stain nickel cabinet hardware, stainless steel appliances with 5 burner gas range, granite countertops and deep undermount stainless sink. Luxury vinyl plank flooring throughout, carpet in the bedrooms only. The owner\'s suite has dual sinks, a deep soaking garden tub & separate shower.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 43 Section 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '880' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windrow' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704790' WHERE `Matrix_Unique_ID` = '211775039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:29:45.030' ,`MLSNumber` = '82909681' ,`ListAgentFullName` = 'Moon Kim' ,`ListOfficeName` = 'Lifestyles Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667604' ,`Longitude` = '-95.009579' ,`PhotoCount` = '13' ,`PostalCode` = '77571' ,`RoomCount` = '4' ,`ListPrice` = '198800.00' ,`Status` = 'Active' ,`StreetName` = 'Holmes' ,`StreetNumber` = '233' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 2 bathroom home on a large lot features lots of updates. The kitchen is updated with stainless fixtures and appliances. Both restrooms have an updated tile surrounds. Roof, foundation, and water heater replaced in 2017. HVAC 2014. Spacious living areas and bedrooms. Walking distance to Sylvan Beach. Easy access to Baytown, Pasadena, and Clear Lake. This one is a MUST SEE!!!' ,`Acres` = '0.287' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 13 14 15 & 16 BLK 73 BAY FRONT TO LA PORTE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Front Add' ,`TaxAmount` = '4721' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704790' WHERE `Matrix_Unique_ID` = '211791458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:49:53.477' ,`MLSNumber` = '87099787' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.989840' ,`Longitude` = '-95.438183' ,`PhotoCount` = '28' ,`PostalCode` = '77090' ,`RoomCount` = '6' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Sun Prairie' ,`StreetNumber` = '874' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0828' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 DARBYDALE CROSSING SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '3606' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Darbydale Xing Sec 1' ,`TaxAmount` = '4912' ,`TaxRate` = '2.5867' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704790' WHERE `Matrix_Unique_ID` = '211800308' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:42:15.133' ,`MLSNumber` = '46179243' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.935627' ,`Longitude` = '-95.078764' ,`PhotoCount` = '28' ,`PostalCode` = '77532' ,`RoomCount` = '5' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Port O Call' ,`StreetNumber` = '17511' ,`StreetSuffix` = 'Street' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1791' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 NEWPORT SEC 5' ,`LotDesciption` = 'Other' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 05' ,`TaxAmount` = '4176' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704790' WHERE `Matrix_Unique_ID` = '211800984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:47:52.660' ,`MLSNumber` = '20565118' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Xin Zhao' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '30.261369' ,`Longitude` = '-95.526211' ,`PhotoCount` = '23' ,`PostalCode` = '77384' ,`RoomCount` = '5' ,`ListPrice` = '521640.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Valley Creek' ,`StreetNumber` = '14035' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New MODERN SERIES DR Horton home! Beautiful two story home with a 4 car garage. This new construction home features gorgeous brick exterior and includes 4 bed/3.5 bath/gameroom and media room!! Features include SS Appliances a 5 burner built-in gas burner cooktop, Quartz Countertops and 42\" flat cabinets in Kitchen, Separate Shower, Built-In Home Automation, Solid Surface Flooring throughout, Tankless Water Heater, Covered Patio, and Full Sprinkler System. Fosters Ridge offers beautiful community center, playground, and pool. Zoned to The Woodlands Schools! DR Horton is America\'s #1 Homebuilder! Come out to Fosters Ridge and make this new home yours today!' ,`Acres` = '0.1907' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516422 - FOSTERS RIDGE 22, BLOCK 1, LOT 45' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8308' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fosters Ridge 22' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704790' WHERE `Matrix_Unique_ID` = '211802626' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:55:56.060' ,`MLSNumber` = '6545780' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Veronica Mendoza' ,`SellingOfficeName` = 'Veronica Mendoza Realty, LLC.' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '276990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cherry Tallow Trail' ,`StreetNumber` = '5162' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW DR Horton One Story Property!! Charming curb appeal!! Great location!! Fantastic kitchen featuring beautiful cabinetry and modern finishes! Also open to the breakfast and family rooms! Spacious primary bedroom suite downstairs with a great closet and oversized shower!! Hard surface flooring in all living areas. Easy access from the garage to a generous sized utility room. Hurry and call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 - Block 4 - Section 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704790' WHERE `Matrix_Unique_ID` = '211803397' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:19:49.753' ,`MLSNumber` = '86376695' ,`ListAgentFullName` = 'Michael O\'Neal' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812199' ,`Longitude` = '-94.997070' ,`PhotoCount` = '17' ,`PostalCode` = '77521' ,`RoomCount` = '3' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Arapajo' ,`StreetNumber` = '4134' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Three bedroom with two baths and a great layout. Located in a quite street and neighborhood. Conveniently near I-10 for easy commute.. Great size backyard. Perfect family home.' ,`Acres` = '0.1567' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 106 BLK 4 MEADOW LAKE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Lake Sec 02' ,`TaxAmount` = '4284' ,`TaxRate` = '2.755' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704791' WHERE `Matrix_Unique_ID` = '211815106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:13:50.340' ,`MLSNumber` = '31815845' ,`ListAgentFullName` = 'Michael O\'Neal' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080627' ,`Longitude` = '-95.189468' ,`PhotoCount` = '27' ,`PostalCode` = '77345' ,`RoomCount` = '5' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Heathervale' ,`StreetNumber` = '5215' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful Mills Branch home offers 4 bedrooms, one down with the rest upstairs and 2.5 bathrooms. Convenient commuting between West Lake Houston Parkway and Northpark drive to local amenities including ShowBiz Cinemas, great food and shopping!' ,`Acres` = '0.2145' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 5 MILLS BRANCH VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9343' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HIDDEN HOLLOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mills Branch Village Sec 04' ,`TaxAmount` = '5099' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704791' WHERE `Matrix_Unique_ID` = '211847106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:53:44.620' ,`MLSNumber` = '35286307' ,`ListAgentFullName` = 'Tamarah Curtis' ,`ListOfficeName` = 'Creighton Realty Partners, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.217340' ,`Longitude` = '-95.540582' ,`PhotoCount` = '21' ,`PostalCode` = '77382' ,`RoomCount` = '6' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'Nokota' ,`StreetNumber` = '512' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1738' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new, built in 2021 and only lived in for a week (Seller had a change of plans and is not moving to the area)! The Abbeyville floorplan will knock your socks off + a full houses BRAND NEW generator! 2 full bedrooms with a study or three bedrooms if you added a wardrobe, 2 full baths, great storage and over-sized covered back patio. Highlights: gutter on the whole house, Tuscan brown color pallet, subway tile gloss backsplash, granite and quartz countertops throughout, 42\" upper kitchen cabinets, Moen faucets, Schlage door hardware, upgraded brand new carpets and pad, 18x18 tile upgrade with an offset design, 2\" faux wood blinds throughout, ceiling fans and so much more!' ,`Acres` = '0.139' ,`Area` = '15' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Del Webb The Woodlands8 Partial Replat No 1, BLOCK 2, Lot2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6037' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'DEL WEBB The Woodlands' ,`TaxAmount` = '' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704791' WHERE `Matrix_Unique_ID` = '211849208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:09:05.587' ,`MLSNumber` = '39571103' ,`ListAgentFullName` = 'Brandi Avila' ,`ListOfficeName` = 'Berkshire Hathaway HomeService' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.258125' ,`Longitude` = '-95.448714' ,`PhotoCount` = '7' ,`PostalCode` = '77302' ,`RoomCount` = '3' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Mississippi Park' ,`StreetNumber` = '501' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1682' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE! THIS WILL NOT LAST LONG! This beautiful home is expected to be completed in the middle of October and just in time for the holidays! Walk in to beautiful 10\' ceilings in your kitchen and living room. This open concept home has a spacious kitchen comes with 42\" upper cabinets, a large island, and granite counter tops. Bedrooms all have huge walk-in closets. Kitchen appliances are Samsung Stainless Steel including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits. NOT IN A FLOOD PLAIN.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Starter Homes of Tex' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER PLANTATION 01, LOT 112' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'River Plantation' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704791' WHERE `Matrix_Unique_ID` = '211849672' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:06:59.323' ,`MLSNumber` = '38301840' ,`ListAgentFullName` = 'Michael O\'Neal' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.011411' ,`Longitude` = '-95.192607' ,`PhotoCount` = '16' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Dove Forest' ,`StreetNumber` = '5431' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home ready for move in with fresh flooring and paint. Very well maintained home with plenty of space and storage.' ,`Acres` = '0.1205' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 3 ATASCOCITA NORTH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita North Sec 01' ,`TaxAmount` = '3255' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704791' WHERE `Matrix_Unique_ID` = '211850993' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T11:54:06.270' ,`MLSNumber` = '32466168' ,`ListAgentFullName` = 'Diana Rodriguez' ,`ListOfficeName` = 'Ruth Longoria, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.619685' ,`Longitude` = '-95.274841' ,`PhotoCount` = '10' ,`PostalCode` = '77075' ,`RoomCount` = '7' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Swiftwater' ,`StreetNumber` = '8130' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Diosdado' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 1 Block 1 Houston Skyscraper Shadow Partial Replat No. 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DEANDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Skyscrpaer Shadow' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704791' WHERE `Matrix_Unique_ID` = '211858990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:14:20.383' ,`MLSNumber` = '91736383' ,`ListAgentFullName` = 'James Green' ,`ListOfficeName` = 'Green & Associates Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.366556' ,`Longitude` = '-95.669815' ,`PhotoCount` = '23' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandstone Hills' ,`StreetNumber` = '1266' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well taken care of house in Fairwater, close to Lake Creek High School in Montgomery! Nice flooring in all living areas and with carpet in the bedrooms. The kitchen has granite counter tops with a nice sized island with a breakfast bar. Open to the breakfast/dining area and living room, you can make sure the biscuits are not burning while watching morning cartoons. Spacious master bedroom, master bath has double sinks, walk in shower and separate tub, and a large walk-in closet. The spare bedrooms are nice and have a shared bath between the rooms, there is a 1/2 bath located by the laundry room, leading to the garage. Nice, fenced back yard with no back neighbors. This neighborhood offers a splash pad and other recreational activities for the family.' ,`Acres` = '0.1559' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S503203 - FAIRWATER 03, BLOCK 4, LOT 8' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairwater 03' ,`TaxAmount` = '3210' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704792' WHERE `Matrix_Unique_ID` = '211948812' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:25:40.163' ,`MLSNumber` = '43351959' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Marty Gene Mills' ,`SellingOfficeName` = 'Mills Family Realty' ,`Latitude` = '29.599706' ,`Longitude` = '-95.806250' ,`PhotoCount` = '14' ,`PostalCode` = '77471' ,`RoomCount` = '16' ,`ListPrice` = '571248.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wayne' ,`StreetNumber` = '6018' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning two-story Arthur home design features 4 bedrooms, 3.5 baths and 3 car attached garage on a corner lot. Convenient home office and laundry room with sink option located off foyer. Elegant dining room with easy access to gourmet kitchen. Beautiful maple cabinets, granite countertops and farmhouse sink in gourmet kitchen. Charming dining room with access to covered back patio. Cozy cast stone fireplace in two-story great room. Dual vanity sinks, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a versatile loft space, media room and all secondary bedrooms. Walk-in closets in all bedrooms. Double sinks in hall bath 2. \r\nEnjoy the convenience of the community\'s Recreation Center, Lakes and Parks. Kingdom Heights in Rosenberg is conveniently located between Sugar Land and Katy/Fulshear with easy access to the major Highway 99 (Grand Pkwy). Offered by: K. Hovnanian of Houston II, L.L.C' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '13/6/6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8160' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingdom Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.7948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704792' WHERE `Matrix_Unique_ID` = '211968736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T10:34:42.530' ,`MLSNumber` = '94517085' ,`ListAgentFullName` = 'Ellisa Carswell' ,`ListOfficeName` = 'Carswell Real Estate Co. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.959125' ,`Longitude` = '-95.633442' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '2500000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Creek' ,`StreetNumber` = '14210' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '3791' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2002 Custom home w/3791 sq. ft . on 14.93 +/- unrestricted acres. Stunning 500 square-ft front porch w/ columns & balusters. 12 ft ceilings in foyer entry. All rooms & hallways 10 ft ceilings w/crown molding, six panel solid 8 ft doors throughout home. Coffered ceilings in game room w/rope lighting,GE stainless refrigerator & ice maker w/granite counters, backsplash, stainless sink.Kitchen w/granite countertops, GE stainless steel appls, Built-in 48\" GE monogram refrigerator w/wood panels. Built-in GE Advantium oven/microwave & warming drawer.Custom built office w/two solid Oak 8 foot entry doors,oak block paneling,built in oak credenza & shelves.Lrg primary bdr w/sitting room & coffered ceiling’s w/rope lighting.Primary bath w/marble floors, marble shower w/ bench & two shower heads, Jetted tub, his & her walk-in closet.Spare bdrs have full bath & walk-in closets.Large 3 car garage, double insulated doors w/AC/Heat if needed with flip of a switch. 3 car carport.Store room off garage.' ,`Acres` = '14.939' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Propane,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13,14,15,16,17,18 BLK 1, RES A BLK 2, Cypress Creek Plaza' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Creek Plaza' ,`TaxAmount` = '7662' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704792' WHERE `Matrix_Unique_ID` = '211969065' --> Updated record success