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` = '2023-01-31T13:09:43.613' ,`MLSNumber` = '71350718' ,`ListAgentFullName` = 'Shahin Naghavi' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745820' ,`Longitude` = '-95.352407' ,`PhotoCount` = '7' ,`PostalCode` = '77003' ,`RoomCount` = '10' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Nagle' ,`StreetNumber` = '1312' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3286' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***NEW CONSTRUCTION GEM*** Located in the heart of EaDo, this home has every convenience and luxury at hand. FEATURES INCLUDE: Living room with bookmatched marble fireplace surround, double doors leading out onto the HUGE backyard (18-feet x 25-feet). kitchen has 36\" cooktop, double oven, under-counter microwave drawer, apron front farm sink with brushed gold pull-down faucet. Sumptuous primary suite has a navy blue accent wall & matching barn doors opening into the lavish primary bath. The eye is immediately drawn to the freestanding bathtub, which is highlighted by the dual shower heads behind a wall of glass. Dual closets, one of which features a center island! All three guest bedroom have private baths. Oversized gameroom includes wet bar with undercounter refrigerator and microwave. Double doors open out onto the balcony. All within walking distance to BBVA Compass Stadium & Minute Maid Park! Also, Discovery Green, Toyota Center and the best dining & shopping Houston has on offer!' ,`Acres` = '0.0574' ,`Area` = '4' ,`BuilderName` = 'Soraya Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 MILLIE MODERN T/H' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'EaDo' ,`TaxAmount` = '1893' ,`TaxRate` = '2.5244' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266789' WHERE `Matrix_Unique_ID` = '201521320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:03:15.887' ,`MLSNumber` = '53435501' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.375829' ,`Longitude` = '-95.648472' ,`PhotoCount` = '11' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '266965.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Point' ,`StreetNumber` = '18512' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1405' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! Unwind after a long day in the Glacier’s relaxing primary suite, complete with a spa-like primary bathroom. Purpose the flex space located just off the foyer into a useful office or convenient third bedroom. Located in Conroe off SH-105, Pine Lake Cove is just minutes from Lake Conroe with future access to a residents-only boat ramp. The community is zoned in the sought-after Montgomery ISD and is near parks and entertainment. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0175 Plan N304A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pine Lake Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266789' WHERE `Matrix_Unique_ID` = '202930834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:03:37.380' ,`MLSNumber` = '63336977' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.366297' ,`Longitude` = '-95.639383' ,`PhotoCount` = '31' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '336230.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor Forest' ,`StreetNumber` = '315' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2012' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready NOW! Breathe easy in this unique single story. No stress allowed in the airy family room. The island kitchen helps you conquer meals with zeal. Pine Lake Cove is just minutes from Lake Conroe and future access to a residents-only boat ramp. The community is zoned in the sought-after Montgomery ISD and is near parks and entertainment. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0176 Plan 841B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Lake Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266790' WHERE `Matrix_Unique_ID` = '203683370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:04:26.520' ,`MLSNumber` = '8891903' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.365906' ,`Longitude` = '-95.638228' ,`PhotoCount` = '7' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '375990.00' ,`Status` = 'Active' ,`StreetName` = 'Cresta Cove' ,`StreetNumber` = '216' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready NOW! Skip your commute and work from home in the quiet main level flex space. The upstairs game room makes a great media or play space. Downstairs, a large walk-in closet and bath complement the private primary suite. Located in Conroe off SH-105, Pine Lake Cove is just minutes from Lake Conroe and future access to a residents-only boat ramp. The community is zoned in the sought-after Montgomery ISD and is near parks and entertainment. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0141 Plan 880C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pine Lake Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266790' WHERE `Matrix_Unique_ID` = '203740694' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:04:15.897' ,`MLSNumber` = '42515975' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.365029' ,`Longitude` = '-95.639246' ,`PhotoCount` = '36' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '367590.00' ,`Status` = 'Active' ,`StreetName` = 'Hanson Ridge' ,`StreetNumber` = '17773' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready NOW! Enjoy this spectacular home with plenty of space for entertaining. The foyer reveals a formal dining room that can be converted to fit your needs. Upstairs you’ll find the game room and secondary bedrooms. Located in Conroe off SH-105, Pine Lake Cove is just minutes from Lake Conroe and future access to a residents-only boat ramp. The community is zoned in the sought-after Montgomery ISD and is near parks and entertainment. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0132 Plan 3L16C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Lake Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266791' WHERE `Matrix_Unique_ID` = '203741577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:04:04.277' ,`MLSNumber` = '85974588' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.377763' ,`Longitude` = '-95.649850' ,`PhotoCount` = '5' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '363090.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Maple' ,`StreetNumber` = '18500' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2265' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready August 2022! Grill with friends on the Gateway’s covered back patio. Inside, the main floor primary suite features dual sinks and a spacious walk-in closet. Upstairs, the open concept loft and game room make a perfect media space or home office. Located in Conroe off SH-105, Pine Lake Cove is just minutes from Lake Conroe and future access to a residents-only boat ramp. The community is zoned in the sought-after Montgomery ISD and is near parks and entertainment. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0144 Plan 390B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pine Lake Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266791' WHERE `Matrix_Unique_ID` = '204108783' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:03:26.680' ,`MLSNumber` = '46486933' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.377705' ,`Longitude` = '-95.649940' ,`PhotoCount` = '5' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '299315.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Maple' ,`StreetNumber` = '18496' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready August 2022! Turn the kids loose in the Olympic’s second-story loft space while hosting downstairs in the open concept living area. The private main level primary suite features dual sinks and walk-in closet for ample storage. Located in Conroe off SH-105, Pine Lake Cove is just minutes from Lake Conroe and future access to a residents-only boat ramp. The community is zoned in the sought-after Montgomery ISD and is near parks and entertainment. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0145 Plan 380B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pine Lake Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266792' WHERE `Matrix_Unique_ID` = '204108828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:03:52.480' ,`MLSNumber` = '51419116' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.377657' ,`Longitude` = '-95.650255' ,`PhotoCount` = '5' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '347590.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Maple' ,`StreetNumber` = '18503' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! Fresh Design package. Turn the kids loose in the Olympic’s second-story loft space while\r\nhosting downstairs in the open concept living area. The private main level primary suite features dual sinks and walk-in closet\r\nfor ample storage. Pine Lake Cove is just minutes from Lake Conroe with future access to a residents-only boat ramp. The\r\ncommunity is zoned in the sought-after Montgomery ISD and is near parks and entertainment. Known for their energy-efficient\r\nfeatures, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0155 Plan 380A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pine Lake Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266792' WHERE `Matrix_Unique_ID` = '204298773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:07:46.993' ,`MLSNumber` = '75082031' ,`ListAgentFullName` = 'Laura Sweeney' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733796' ,`Longitude` = '-95.452078' ,`PhotoCount` = '45' ,`PostalCode` = '77027' ,`RoomCount` = '12' ,`ListPrice` = '3650000.00' ,`Status` = 'Active' ,`StreetName` = 'Staunton' ,`StreetNumber` = '4511' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '7524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Old World European elegance meets distinctive modern design in this remarkable residence timelessly crafted by Southampton Homes in a chic central Afton Oaks location. A distinguished Robert Dame design offers impeccable scale and resort-style amenities enhanced by stylish selections with reclaimed materials sourced from around the world. Sumptuous Primary Suite up with private terrace, luxurious bath, and designated dressing rooms. Third Level Game Room and Bedroom #5 share access to a sizable wrap-around terrace surrounded by majestic oaks offering treetop views of the sublime setting. Loggia with outdoor fireplace, summer kitchen, and cabana bath overlooks a serene swimming pool/spa with retractable cover. Elevator capable. Three-car attached Garage.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Southampton Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Royden Oaks/Afton Oaks' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 & TR 45A BLK 4 AFTON OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,French,Other Style' ,`Subdivision` = 'Afton Oaks' ,`TaxAmount` = '71055' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266792' WHERE `Matrix_Unique_ID` = '205780275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:06:09.290' ,`MLSNumber` = '78894180' ,`ListAgentFullName` = 'Lyonna Veazea' ,`ListOfficeName` = 'Compass Realty & Associates LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722106' ,`Longitude` = '-95.600824' ,`PhotoCount` = '23' ,`PostalCode` = '77082' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadowvista' ,`StreetNumber` = '12431' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2753' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 12431 Shadowvista Drive located in the gated community of Shadowlake. This home features 4 Bedroom 2 and half bath and has a POOL. The open Concept floorplan will make entertaining a breeze. The family room includes a fireplace and large window for natural light to shine through. The Spacious Master suite includes a large walk in shower and separate tub and walk in closet. Schedule a Tour today.' ,`Acres` = '0.1515' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 1 SHADOWLAKE SEC 6 AMENDED' ,`LotDesciption` = 'Corner' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1010' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadowlake Sec 06 Amd' ,`TaxAmount` = '7673' ,`TaxRate` = '2.5611' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266793' WHERE `Matrix_Unique_ID` = '205996202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:10:45.717' ,`MLSNumber` = '39342796' ,`ListAgentFullName` = 'Donna Mazzola' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.354382' ,`Longitude` = '-94.990717' ,`PhotoCount` = '12' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Lower Borondo' ,`StreetNumber` = '141' ,`StreetSuffix` = '' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand New Construction. This 2038 Sq Ft home lives larger than it looks from outside! High ceilings in main rooms. Open concept. Features a Beautiful Granite Island Kitchen equipped w/ all Samsung appliances, soft close cabinets & drawers and large walk-in pantry. Very Spacious Living/Dining rooms. The Primary Suite boasts a beautiful over-sized 6\' X 4\' custom tile walk-in shower & double sinks. Plenty of closet space for Two. 2 more bedrooms are also good sized. All rooms have ceiling fans w/lights. The guest bath has custom tile around tub w/ shower. All Flooring is 50 yr wnty, water resistant Rubber Laminate w/wood look. Full size utility/laundry room. Gas stove, water heater, furnace & dryer connection-money saver! 4 Ton 16 Seer Goodman HVAC. Covered Patio in back 10\' X 16\' & a nice 5\' X 20\' porch on front entrance w/ extra wide driveway on the side leading to a 2 car garage. Roofing is 30Yr Architectural. Durable Hardie Siding. Built entirely with Treated Lumber' ,`Acres` = '0.1936' ,`Area` = '33' ,`BuilderName` = 'CompleteConstruction' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 2 S F AUSTIN SUR LOT 9 BLK 1 BORONDO PINES SUB (2002)' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8434' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '319' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'WESTLAWN ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Craftsman,Ranch,Traditional' ,`Subdivision` = 'Borondo Pines 2002' ,`TaxAmount` = '451' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266793' WHERE `Matrix_Unique_ID` = '206620594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:45:27.257' ,`MLSNumber` = '20697014' ,`ListAgentFullName` = 'Darian Candler' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855072' ,`Longitude` = '-95.713917' ,`PhotoCount` = '28' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Aventine Plantation' ,`StreetNumber` = '19647' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 4 bedroom 3 bathroom home! This home also offers a covered front porch, and a two car garage.' ,`Acres` = '0.1282' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 1 PLANTATION LAKES SEC 9' ,`LotDesciption` = 'Other' ,`LotSize` = '5586' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCFEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Lakes Sec 9' ,`TaxAmount` = '6661' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266794' WHERE `Matrix_Unique_ID` = '206976407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:41:25.290' ,`MLSNumber` = '81889151' ,`ListAgentFullName` = 'Chester Tucker' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981291' ,`Longitude` = '-95.206715' ,`PhotoCount` = '28' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Stillwater Place' ,`StreetNumber` = '18106' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Instantly appealing with its treed lot and arched windows, this charming one story home is sure to please. You will never miss out on the action from the spacious kitchen overlooking the living rooms. The chef in the house will adore the abundant cabinet and counter space complete with center island. Spend time outdoors in this spacious and welcoming backyard with more than six beautiful mature trees. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.213' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 PARK AT ATASCOCITA FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9278' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '390' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WHISPERING PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park At Atascocita Forest 03' ,`TaxAmount` = '6146' ,`TaxRate` = '2.773' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266794' WHERE `Matrix_Unique_ID` = '207117382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:04:38.860' ,`MLSNumber` = '1013973' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194793' ,`Longitude` = '-95.441313' ,`PhotoCount` = '13' ,`PostalCode` = '77385' ,`RoomCount` = '3' ,`ListPrice` = '377280.00' ,`Status` = 'Active' ,`StreetName` = 'Pearly Everlasting' ,`StreetNumber` = '9814' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! A private flex space in the Oleander makes a perfect home office or play room. Clear sight lines from the kitchen through the family room bring everyone together, while twin secondary bedrooms are tucked away in their own hall. Located a half hour north of downtown Houston off Hwy 242, Harper’s Preserve is a stunning gated master-planned community that features an on site local elementary school and grocery store, as well as nearby restaurants and shopping. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0162 Plan C401E' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harpers Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266794' WHERE `Matrix_Unique_ID` = '208062242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:04:53.430' ,`MLSNumber` = '53185480' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362359' ,`Longitude` = '-95.502244' ,`PhotoCount` = '7' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '394110.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Live Oak' ,`StreetNumber` = '1944' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready April 2023! Unwind in the private main floor primary suite, complete with a sizeable walk-in closet. The study makes the perfect home office or craft room. Upstairs, the kids will love the spacious game room. Easy access to I-45 makes it simple to get to work or play quickly. Located in the fast-growing City of Conroe, these affordable homes are located in the desirable Willis ISD. Nearby shopping, dining, and entertainment mean you don’t need to venture far for a night out. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0129 Plan C460D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.1' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266794' WHERE `Matrix_Unique_ID` = '208220074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:45:59.317' ,`MLSNumber` = '59039339' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825177' ,`Longitude` = '-94.990329' ,`PhotoCount` = '13' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '347186.00' ,`Status` = 'Active' ,`StreetName` = 'Goldeneye' ,`StreetNumber` = '4610' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The attractive Greeley plan presents three bedrooms with large walk-in closets & two full bathrooms!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 6, Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7798' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266795' WHERE `Matrix_Unique_ID` = '208701800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:10:03.927' ,`MLSNumber` = '68177224' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842583' ,`Longitude` = '-94.828097' ,`PhotoCount` = '17' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakewood' ,`StreetNumber` = '15219' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! **LENNAR IS IN LAKES OF CHAMPIONS!!! The inviting single story Travertine II with Brick/Stone Elevation \"F\" floor plan from the Brookstone Collection by Lennar features a welcoming covered front porch and entry foyer, a formal dining room, kitchen with a walk-in pantry, an open breakfast room and family room that offers access to a covered rear patio, a game room, and a walk-in utility room. The master bedroom features and en suite master bathroom with dual sinks, separate shower and tub, and dual master closets. *HOME ESTIMATED TO BE COMPLETE, December, 2022*' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0004 BLK 004 LOT 005' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '518' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Champions Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266795' WHERE `Matrix_Unique_ID` = '208971553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:02:18.057' ,`MLSNumber` = '92534403' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Denise Hernandez' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.833170' ,`Longitude` = '-95.856687' ,`PhotoCount` = '33' ,`PostalCode` = '77493' ,`RoomCount` = '15' ,`ListPrice` = '549506.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '827' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in Ready! Westin Homes NEW Construction (Ellicott, Elevation A) Two story. 4 bedrooms, 3.5 baths. Primary suite with large walk-in closet. Second bedroom on first floor with private bath. First floor study and informal dining adjacent to the island kitchen. Upstairs additional 2 bedrooms, bathroom, game room and media room. Covered patio and attached 2 car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 15 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6926' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266795' WHERE `Matrix_Unique_ID` = '209026109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:09:43.240' ,`MLSNumber` = '22413603' ,`ListAgentFullName` = 'Donna Mazzola' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.354856' ,`Longitude` = '-94.990156' ,`PhotoCount` = '18' ,`PostalCode` = '77568' ,`RoomCount` = '10' ,`ListPrice` = '313758.00' ,`Status` = 'Active' ,`StreetName` = 'Borondo Reach' ,`StreetNumber` = '129' ,`StreetSuffix` = '' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the last homes built in Borondo Pines. Brand New Construction. This 1962 Sq Ft home lives larger than it looks from outside! High ceilings in main rooms. Open concept. Features a Beautiful Granite Island Kitchen equipped with appliances, soft close cabinets & drawers. Large walk-in pantry. Very Spacious Living/Dining rooms. The Primary Suite boasts a beautiful over-sized custom tile walk-in shower, private toilet & double sinks. Plenty of closet space for Two. 2 more bedrooms are also good sized. All rooms have ceiling fans w/lights. The guest bath has custom tile around tub w/ shower. All Flooring is 50 yr wnty, water resistant Rubber Laminate wood look. Full size utility/laundry room. GAS stove, water heater, furnace & dryer -money saver! 4 Ton 16 Seer Goodman HVAC. Covered Patio in back 10\'X20\' & 6\'X44\' porch on front entrance w/ extra wide driveway on the side leading to a 2 car garage. Roof is Composition Architectural Shingles Life Time Warranty. Durable Hardie Siding.' ,`Acres` = '0.1975' ,`Area` = '33' ,`BuilderName` = 'CompleteConstruction' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 2 S F AUSTIN SUR LOT 12 BLK 1 BORONDO PINES SUB (2002)' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8603' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '319' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'WESTLAWN ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Borondo Pines 2002' ,`TaxAmount` = '458' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266796' WHERE `Matrix_Unique_ID` = '209067222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:58:25.923' ,`MLSNumber` = '57813933' ,`ListAgentFullName` = 'Daniel Signorelli' ,`ListOfficeName` = 'The Signorelli Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.169808' ,`Longitude` = '-95.247103' ,`PhotoCount` = '12' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '317780.00' ,`Status` = 'Active' ,`StreetName` = 'Christine Elizabeth' ,`StreetNumber` = '18359' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 94 Block 01 Section 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'NEW CANEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266796' WHERE `Matrix_Unique_ID` = '209309657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:52:50.627' ,`MLSNumber` = '55568484' ,`ListAgentFullName` = 'Thomas Stallings' ,`ListOfficeName` = 'McCallum Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688715' ,`Longitude` = '-95.340976' ,`PhotoCount` = '10' ,`PostalCode` = '77021' ,`RoomCount` = '6' ,`ListPrice` = '204900.00' ,`Status` = 'Active' ,`StreetName` = 'Yellowstone' ,`StreetNumber` = '5143' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful fully remodeled home in the heart of Houston. This 3 BEDROOM 2 FULL BATHS home has amazing updates throughout including recent HVAC, beautiful porcelain tile and granite countertops in kitchen and both full baths, custom cabinets, stainless steel appliances, energy efficient tankless hot water heater, low-e double pane windows, ceiling fans, recent carpet in all 3 bedrooms, wood floors in dining and living area, and W/D connections in utility room. Recent central a/c and heat, tankless hot water heater, and so much more. Huge backyard, and easy access to all the major freeways.\r\n\r\nSome foundations issue to be addressed by next Buyer ( we have a quote ). Property is being offered \"As Is\"' ,`Acres` = '0.1601' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Other Disclosures,Sellers Disclosure,Short Sale' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 164 BLK 6 MACGREGOR TERRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6974' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARTSFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macgregor Terrace Sec 01' ,`TaxAmount` = '2800' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266797' WHERE `Matrix_Unique_ID` = '209895660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:45:57.143' ,`MLSNumber` = '23947180' ,`ListAgentFullName` = 'Donna Mazzola' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469610' ,`Longitude` = '-95.057953' ,`PhotoCount` = '23' ,`PostalCode` = '77539' ,`RoomCount` = '9' ,`ListPrice` = '264900.00' ,`Status` = 'Active' ,`StreetName` = 'Deats' ,`StreetNumber` = '2807' ,`StreetSuffix` = 'Road' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great house for start up or a. Add your own touches. \r\nThe kitchen and dining room are situated together. The large living room features a beautifully crafted trey ceiling.\r\nThe Primary bedroom is a suite with shower/tub combo and double sinks, a private toilet, deep closet and a linen closet. Each of the additional 3 Bedrooms are also spacious.\r\nThe back yard has plenty of space for the little ones or a backyard Bar-B-Que.\r\nLocated close to everything you need. Just a few minutes from Houston and Galveston. \r\n10 Minutes from shopping and Doctors on 1-45 at Victory Lakes Town Center.' ,`Acres` = '0.1492' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 19 PERRY & AUSTIN NE 1/2 OF LOT 1 & NE 1/2 OF LOT 2 BLK' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SILBERNAGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Moores Add' ,`TaxAmount` = '4428' ,`TaxRate` = '2.1168' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266797' WHERE `Matrix_Unique_ID` = '209954332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:19:41.593' ,`MLSNumber` = '55337590' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.166932' ,`Longitude` = '-95.637929' ,`PhotoCount` = '20' ,`PostalCode` = '77486' ,`RoomCount` = '9' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '553' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'READY NOW! MLS# 55337590 No Back Neighbors! Rio Grande (A-Elevation) 2-Story 4 BD 2.5 BA 3 Car Garage 2,507 sq ft! Lot Size 9,374 sq ft. High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets! Quartz Counters! Stainless finish appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low Tax Rate 2.186! Offers a golf course family-friendly gated community, Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Sweeny, Bay City, Angleton & Lake Jackson! Enjoy the beach just 30 mins away! CastleRock offers BRAND NEW HOMES! Spacious 1 & 2 Story plans! Quick Move-In Homes Available! Explore the natural splendor and enjoy laid-back living in Columbia Lakes where neighbors gather and beautiful memories are made. Come take a look! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 101, Block 31, Section 3' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9372' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186289' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266797' WHERE `Matrix_Unique_ID` = '210077924' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:40:44.517' ,`MLSNumber` = '91746559' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.034736' ,`Longitude` = '-95.412123' ,`PhotoCount` = '16' ,`PostalCode` = '77531' ,`RoomCount` = '8' ,`ListPrice` = '315990.00' ,`Status` = 'Active' ,`StreetName` = 'Flycatcher' ,`StreetNumber` = '408' ,`StreetSuffix` = 'Court' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Zeus plan consists of three bedrooms, two-and a half bathrooms, and an upstairs gameroom!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13, Block 5, Section 5' ,`LotDesciption` = 'Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodshore' ,`TaxAmount` = '' ,`TaxRate` = '2.81' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266798' WHERE `Matrix_Unique_ID` = '210276131' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:40:24.593' ,`MLSNumber` = '41576702' ,`ListAgentFullName` = 'Alexandra Berry' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.464333' ,`Longitude` = '-95.469465' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Tartan' ,`StreetNumber` = '8214' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 3 bedroom, 2 bathroom two story home! All bedrooms are upstairs, and there is also a 2 car garage.' ,`Acres` = '0.1157' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN COLONY SEC 1, BLOCK 4, LOT 38' ,`LotDesciption` = 'Other' ,`LotSize` = '5040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Colony Sec 1' ,`TaxAmount` = '5310' ,`TaxRate` = '3.1329' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266798' WHERE `Matrix_Unique_ID` = '210393190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:57:02.767' ,`MLSNumber` = '42885193' ,`ListAgentFullName` = 'Cynthia Corder' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.170006' ,`Longitude` = '-94.999151' ,`PhotoCount` = '45' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Warrior' ,`StreetNumber` = '18607' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gulf VIEW! This newer construction, 5 star rated vacation rental would make a nice addition to your investment portfolio or a wonderful 2nd home. Beautifully maintained 3 bed, 2 bath home in desirable Indian Beach Subdivision. Situated only a block from the beach on a large estate size lot (26,948 sq ft). Enjoy the gulf breeze and sunrise off your large south facing deck. In the evening enjoy the sunset from the large north facing deck off of the primary suite. Bright open floor plan with open concept living and gorgeous kitchen design with an abundance of cabinets and plenty of seating at the island. Beautiful baths with tile showers. Washer & electric dryer included. Don\'t forget the pets- the fenced yard is perfect for your four legged friends. The downastairs makes a perfect place to entertain, enjoy family & more with the built in bar. This home is selling furnished and is an active vacation rental. Schedule your appointment today to inquire about vacation rental income.' ,`Acres` = '0.6186' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 18 BLK 5 INDIAN BEACH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '26948' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '338' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`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,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Indian Beach 1' ,`TaxAmount` = '7448' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266799' WHERE `Matrix_Unique_ID` = '210643240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:01:50.887' ,`MLSNumber` = '56454835' ,`ListAgentFullName` = 'Christen English' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.948940' ,`Longitude` = '-95.356800' ,`PhotoCount` = '14' ,`PostalCode` = '77541' ,`RoomCount` = '2' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '727' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two separate dwellings with identical layouts. Each one has a bedroom, bathroom, living area and kitchen at 480 sq ft each for a total of 960 sq ft. These are currently tenant occupied and after a full remodel in 2020 they make an ideal income producing property.' ,`Acres` = '0.1607' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'FREEPORT BLK 92 LOT 2' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Freeport' ,`TaxAmount` = '1769' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266799' WHERE `Matrix_Unique_ID` = '210727316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:39:36.733' ,`MLSNumber` = '59647341' ,`ListAgentFullName` = 'Michael Furman' ,`ListOfficeName` = 'Re/Max Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.320839' ,`Longitude` = '-95.844512' ,`PhotoCount` = '33' ,`PostalCode` = '77363' ,`RoomCount` = '3' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1774' ,`StreetNumber` = '17369' ,`StreetSuffix` = '' ,`City` = 'Plantersville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living at its finest! Completely remodeled 3 bedroom, 2 bathroom home with oversized garage and additional storage building. Well taken care of pet and smoke free home. Neutral color palette and large kitchen island are a buyers dream! Kitchen Appliances convey! House is on city water. Large back yard is separated by a fence. Keep your lawn looking green this summer, as the sprinkler system is connected to water well! Updates include carpet (2020) and replaced roof (2021) \r\nBonus: Horses Allowed, No Restrictions!!' ,`Acres` = '1' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0043 WM MONTGOMERY, TRACT 62-3, ACRES 1.00' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dyer Mill-401' ,`TaxAmount` = '2868' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266800' WHERE `Matrix_Unique_ID` = '210751377' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:35:10.810' ,`MLSNumber` = '73983021' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678288' ,`Longitude` = '-95.900035' ,`PhotoCount` = '8' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '759452.00' ,`Status` = 'Active' ,`StreetName` = 'Creekbend Drive' ,`StreetNumber` = '4814' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4395' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 73983021 - Built by Drees Custom Homes - February completion! ~ Grand Design, Total of five bedrooms.\r\nWhether your dream home is classic or contemporary the Somerville will meet your needs. From the stylish two-story foyer to the open family room, dining, and kitchen areas this home shines with attention to detail and functional design. Enjoy serving guests on the large oversized island and keeping preparations neat with the working pantry. The owner\'s suite\'s luxurious details include an exquisite bathroom, and large walk-in closet. Upstairs hosts three additional bedrooms each with their own bath and a gameroom. Total of five bedrooms.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot - 17 / Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8629' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook On Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266800' WHERE `Matrix_Unique_ID` = '210905457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:15:12.563' ,`MLSNumber` = '82905434' ,`ListAgentFullName` = 'Nancy Almodovar' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.208763' ,`Longitude` = '-95.334556' ,`PhotoCount` = '18' ,`PostalCode` = '77302' ,`RoomCount` = '11' ,`ListPrice` = '709990.00' ,`Status` = 'Active' ,`StreetName` = 'Orchid Falls' ,`StreetNumber` = '17409' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy resort-style living in the master planned community of ARTAVIA. Enjoy the trails winding their way through the trees and along the boardwalk. Launch your kayak into the five-acre community lake. The popular Rio Grande plan by J. Patrick Homes features a traditional brick and stone exterior, 4 bedrooms, 3.5 bathrooms and a 3-car garage. Chef’s kitchen has Quartz countertops and upgraded appliances. It is the perfect home for entertaining with an open-concept floor plan and sliding glass doors at the breakfast room that lead to the extended covered patio with outdoor kitchen. Primary suite has a spa-like bath with dual sinks, freestanding bathtub and award-winning walk-through shower. Designer farmhouse fresh selections and upgrades throughout the home. Smart home features included with white glove service after closing. Visit the J. Patrick model home at 15314 Viviente Dr to learn more.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'J. Patrick Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 02 Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10177' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.1988' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266800' WHERE `Matrix_Unique_ID` = '211066493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T13:36:33.020' ,`MLSNumber` = '71880342' ,`ListAgentFullName` = 'Mary McKinney' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511116' ,`Longitude` = '-95.051124' ,`PhotoCount` = '39' ,`PostalCode` = '77573' ,`RoomCount` = '12' ,`ListPrice` = '629000.00' ,`Status` = 'Active' ,`StreetName` = 'Broad Bay' ,`StreetNumber` = '1018' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3758' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMAGINE COMING HOME TO THIS OASIS! Designed as a retreat from the energy of the city, this South Shore Lake Lot with pool will LIGHTEN, BRIGHTEN and ELEVATE your mood! 4/3.5/2 Large Den with Picture Windows looks out on Pool/Spa/Waterfalls in backyard with Greenbelt access. Primary Down w/Lake View, Separate Closets. Eat-In Kitchen, Formal Dining, Formal Living/Office Area. Media & Game Rooms up with Catwalk to 3 Bedrooms. Custom Light Fixtures throughout. Lots of Closet space and Attic Decked for Storage. Roof replaced 2021, A/C replaced 2019. Carpet replaced with paint updates 9/2022. Pool Coping/Stones reset 8/2022. Refrigerator/Washer/Dryer remain. Must-see to experience the true beauty of this home! (Backyard Pool & Waterfalls Video in links) NASA, Boardwalk and Marina in close proximity.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTH SHORE HARBOUR' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Waterfront' ,`LotSize` = '9332' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '907' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour' ,`TaxAmount` = '12382' ,`TaxRate` = '2.452' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266801' WHERE `Matrix_Unique_ID` = '211180147' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:08:44.383' ,`MLSNumber` = '13961018' ,`ListAgentFullName` = 'Donna Mazzola' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.355046' ,`Longitude` = '-94.990149' ,`PhotoCount` = '11' ,`PostalCode` = '77568' ,`RoomCount` = '10' ,`ListPrice` = '312990.00' ,`Status` = 'Active' ,`StreetName` = 'Borondo Reach' ,`StreetNumber` = '125' ,`StreetSuffix` = '' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Last Brand New Construction home to be built in Borondo Pines. This 1958 Sq Ft home lives larger than it looks from outside! High ceilings & Open concept. Features a Beautiful Granite Island Kitchen equipped with appliances, soft close cabinets & drawers. Large walk-in pantry. Very Spacious Living/Dining rooms. The Primary Suite boasts a beautiful over-sized custom tile walk-in shower, double sinks. Plenty of closet space for Two. 2 more bedrooms are also good sized. All rooms have ceiling fans w/lights. The guest bath has custom tile around Steel tub w/ shower. All Flooring is 50 yr wnty, water resistant rubber laminate wood look. Full size utility/laundry room. GAS stove, water heater, furnace & dryer -money savers! 4 Ton 16 Seer Goodman HVAC. Covered Patio in back 20\'X10\' & 27\'X6\' porch on front entrance w/ extra wide driveway on the side leading to a 2 car garage. Roof is Composition Architectural Shingles Life Time Warranty. Durable Hardie Siding.' ,`Acres` = '0.1958' ,`Area` = '33' ,`BuilderName` = 'CompleteConstruction' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 2 S F AUSTIN SUR LOT 13 BLK 1 BORONDO PINES SUB (2002)' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8529' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '319' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Borondo Pines 2002' ,`TaxAmount` = '457' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266801' WHERE `Matrix_Unique_ID` = '211270104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:53:35.713' ,`MLSNumber` = '79638306' ,`ListAgentFullName` = 'Evan Compean' ,`ListOfficeName` = 'Compean Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740052' ,`Longitude` = '-95.343005' ,`PhotoCount` = '38' ,`PostalCode` = '77003' ,`RoomCount` = '6' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Milby' ,`StreetNumber` = '1410' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1949' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction in EaDo and just a couple blocks from the MetroRail, with bike lanes 1 block away! NEARING COMPLETION BY END OF JAN 2023! These 4 new homes are located in a gated enclave, with an elegant Modern Farmhouse Design, black fixtures & hardware, 8\' doors, 11\' ceilings, wood floors throughout the common areas on the 2nd floor. The kitchen is open to the dining room (with a wine bar) & living rooms, plus has an island, farmhouse sink, gas range & quartz counters. You will love the primary suite with hardwood floors, large walk-in closet & luxurious bath featuring a frameless shower, freestanding tub & dual sinks. Minutes from the theater district, Minute Maid Park, University of Houston, PNC Soccer Stadium, East River District, and many amazing restaurants, coffee shops & bars. UNIT D at the front will be smaller(lower price) w/ 2 bed & 2.5 baths,+ gated yard. The interior 3 homes will have a fenced dog run.' ,`Acres` = '0.0368' ,`Area` = '4' ,`BuilderName` = 'Zoe Properties, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 EAST END VILLAGE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1604' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'EAST END VILLAGE' ,`TaxAmount` = '2040' ,`TaxRate` = '2.4557' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266801' WHERE `Matrix_Unique_ID` = '211490682' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:21:33.550' ,`MLSNumber` = '22027547' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066083' ,`Longitude` = '-95.493078' ,`PhotoCount` = '35' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Ingleside' ,`StreetNumber` = '4826' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2306' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming home now on the market! The stylish kitchen features sleek countertops, ample cabinetry and a beautiful backsplash. Entertaining is a breeze with this great floor plan complete with a cozy fireplace. The main bedroom and bathroom give you the perfect space for everyday living. The backyard patio and fence-in outside make this home perfect for hosting the next BBQ. Don\'t miss this incredible opportunity! This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1446' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 5 BRIDGESTONE SEC 4 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '328' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ROTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgestone Sec 04 R/P' ,`TaxAmount` = '5225' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675266801' WHERE `Matrix_Unique_ID` = '211812455' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T14:58:02.403' ,`MLSNumber` = '30475930' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843121' ,`Longitude` = '-94.829276' ,`PhotoCount` = '41' ,`PostalCode` = '77523' ,`RoomCount` = '14' ,`ListPrice` = '486309.00' ,`Status` = 'Active' ,`StreetName` = 'Medford' ,`StreetNumber` = '14710' ,`StreetSuffix` = '