Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:39:45.817' ,`MLSNumber` = '39851879' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600206' ,`Longitude` = '-95.445173' ,`PhotoCount` = '6' ,`PostalCode` = '77053' ,`RoomCount` = '10' ,`ListPrice` = '346990.00' ,`Status` = 'Active' ,`StreetName` = 'Bollardpoint' ,`StreetNumber` = '15542' ,`StreetSuffix` = 'Lane' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 4 Bedroom, 2 Bath, Pocket Office, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Ceramic Tile Floors in Dining/Kitchen Area, Family Room, and All Wet Areas, Granite Kitchen Counter-tops with Island, Mosaic Tile Back-splash, Under-mount Stainless Steel Sink with Pull Out Faucet, Stainless Steel Appliances, 36” Upper Kitchen Cabinets, Upgraded Trim Package with Crown Molding, Extended Covered Patio, Brick Sides and Back of Home, Full Front Gutters, Full Sod & Irrigation, No Back Neighbors, Tech Shield Roof, Environments for Living Home, plus more…AVAILABLE FEBRUARY/MARCH.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707745' WHERE `Matrix_Unique_ID` = '203957432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:55:29.573' ,`MLSNumber` = '93105814' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467127' ,`Longitude` = '-95.249809' ,`PhotoCount` = '11' ,`PostalCode` = '77511' ,`RoomCount` = '13' ,`ListPrice` = '361990.00' ,`Status` = 'Active' ,`StreetName` = 'Selah' ,`StreetNumber` = '352' ,`StreetSuffix` = 'Court' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2 1/2 Bath, Study, Formal Dining, Game Room Up, Primary Bedroom Up, Granite Topped Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Rigid Core Floors in Entry, Bathrooms, Dining Room, Kitchen, and Family Room, Granite Kitchen Countertops with Island, Tile Backsplash, 42\" Upper Kitchen Cabinets, Stainless Steel Appliances, Wrought Iron Stair Parts, Covered Back Patio, Cul de Sac Home Site, Irrigation System in Front and Side Yards, Garage Door Opener, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE MAY.' ,`Acres` = '0.1354' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 1 SEC 10' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5897' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MARK TWAIN ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kendall Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707746' WHERE `Matrix_Unique_ID` = '203980713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:52:26.993' ,`MLSNumber` = '14821879' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.466647' ,`Longitude` = '-95.247195' ,`PhotoCount` = '6' ,`PostalCode` = '77511' ,`RoomCount` = '9' ,`ListPrice` = '318990.00' ,`Status` = 'Active' ,`StreetName` = 'Latigo' ,`StreetNumber` = '5303' ,`StreetSuffix` = 'Court' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Rigid Core Floors in Kitchen, Family Room, Bathrooms, and Utility Room, Granite Kitchen Countertops with Island, Mosaic Tile Backsplash, 42” Upper Kitchen Cabinets, Upgraded Stainless Steel Appliances, Covered Patio, Stone Accents, Irrigation System in Front and Side Yards, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE JULY.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 82 BLK 1 SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5774' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MARK TWAIN ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kendall Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707746' WHERE `Matrix_Unique_ID` = '206259190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:54:23.587' ,`MLSNumber` = '61808885' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.466073' ,`Longitude` = '-95.248086' ,`PhotoCount` = '7' ,`PostalCode` = '77511' ,`RoomCount` = '12' ,`ListPrice` = '357990.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade' ,`StreetNumber` = '5302' ,`StreetSuffix` = 'Court' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 1/2 Story, 4 Bedroom, 2 Bath, Study, Bonus Room,, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Rigid Core Floors in Kitchen, Family Room, Bathrooms, and Utility Room, Granite Kitchen Countertops with Island, Mosaic Tile Backsplash, 42” Upper Kitchen Cabinets, Upgraded Stainless Steel Appliances, Wrought Iron Stair Parts Downstairs, Covered Patio, Stone Accents, Irrigation System in Front and Side Yards, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE AUGUST.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 37 BLK 1 SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MARK TWAIN ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Kendall Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707746' WHERE `Matrix_Unique_ID` = '206260972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:35:27.653' ,`MLSNumber` = '8532519' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225933' ,`Longitude` = '-95.702483' ,`PhotoCount` = '9' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Warbler' ,`StreetNumber` = '40327' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2181' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 3 Bedroom, 3 1/2 Bath, Open Concept Kitchen/Dining Combo, Primary Bedroom Up, Dual Vanities in Primary Bath, Luxury Vinyl Plank Floors in Entry, Dining/Kitchen Area, Family Room, Hallway and All Wet Areas, Granite Kitchen Counter-tops with Island, Mosaic Tile Back-splash, Under-mount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42\" Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, 2\" Window Blinds, Extended Covered Patio, Garage Door Opener, Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE JULY/AUGUST.' ,`Acres` = '0.105601' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 15 BLK 3 SEC 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707746' WHERE `Matrix_Unique_ID` = '206290482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:40:19.637' ,`MLSNumber` = '78636928' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599804' ,`Longitude` = '-95.443408' ,`PhotoCount` = '7' ,`PostalCode` = '77053' ,`RoomCount` = '13' ,`ListPrice` = '379990.00' ,`Status` = 'Active' ,`StreetName` = 'Bollardpoint' ,`StreetNumber` = '15502' ,`StreetSuffix` = 'Lane' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2430' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2½ Baths, Game Room Up, Media Room Up, Open Concept Kitchen/Dining Combo, Primary Bedroom Down, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Luxury Vinyl Plank Flooring in Dining Room, Kitchen, and Family Room, Granite Kitchen Counter-tops with Island, Tile Back-splash, Undermount Stainless Steel Sink, Stainless Steel Appliances, 42” Upper Kitchen Cabinets, Wrought Iron Spindles, Extended Covered Patio, Fireplace with Cast Stone Surround, Landscaping with Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more...AVAILABLE JULY.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 20 BLK 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '3.0075' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707746' WHERE `Matrix_Unique_ID` = '206493356' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:12:22.883' ,`MLSNumber` = '65592619' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.270133' ,`Longitude` = '-95.474834' ,`PhotoCount` = '43' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Bedias Creek' ,`StreetNumber` = '515' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy an abundance of everyday luxury in the glamorous Fontaine family home plan. The upstairs retreat and downstairs study provide sunny spaces to craft your ideal special-purpose rooms. Unique personalities and growing minds can flourish in the delightful spare bedrooms. Soaring ceilings and sleek spaces for living and dining make the open floor plan a beautiful place to play host. Share your cuisine creations on the presentation island in the modern kitchen. Withdraw to the elegant Owner’s Retreat, which includes the closet and bathroom features to pamper your wardrobe and yourself. The covered porches present remarkable opportunities for outdoor relaxation. Contact our Internet Advisor to learn about all the other great features of this new classic home plan.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 04 Block 05' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1073' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707746' WHERE `Matrix_Unique_ID` = '206975184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:11:58.250' ,`MLSNumber` = '52476784' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.276211' ,`Longitude` = '-95.476015' ,`PhotoCount` = '12' ,`PostalCode` = '77304' ,`RoomCount` = '9' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Liatris' ,`StreetNumber` = '119' ,`StreetSuffix` = 'Place' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sophisticated style and bold luxuries match the sincere comforts that make each day beautiful in The Ella new home plan. Craft your ideal gathering spaces and create cherished memories together in the beautiful upstairs retreat and bonus room. Each spare bedroom is situated to provide plenty of privacy, unique appeal, and a great place to grow. Rest and refresh at the end of each day in your downstairs Owner’s Retreat, which includes a spacious walk-in closet and a superb en suite bathroom. Your open floor plan offers a sunlit interior design space that easily adapts to your everyday life and special occasion needs. Family breakfasts, elegant dinners, and celebratory treats all begin in the streamlined light and bright kitchen at the heart of this home. The front study presents the versatility for a home office, library, or an inviting lounge.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 05' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7601' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1073' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707746' WHERE `Matrix_Unique_ID` = '206983442' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:11:14.947' ,`MLSNumber` = '54173750' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.447500' ,`Longitude` = '-95.396640' ,`PhotoCount` = '38' ,`PostalCode` = '77578' ,`RoomCount` = '5' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Morrison' ,`StreetNumber` = '5010' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW DAVID WEEKLEY HOME! Entertain in style and enjoy the everyday comforts of The Penmark family home plan. Begin and end each day in the perfect paradise of your Owner’s Retreat, which features a refined bathroom and a sprawling walk-in closet. Each spare bedroom provides a wonderful place for unique personalities to flourish. The chef’s specialty kitchen includes a full-function island and a walk in pantry. Your open floor plan offers an impeccable space to play host to picture-perfect memories and brilliant social gatherings. Get the most out of each day in this lovely EnergySaver™ new home plan.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 50 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707747' WHERE `Matrix_Unique_ID` = '207365910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:41:05.080' ,`MLSNumber` = '95336566' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600242' ,`Longitude` = '-95.445328' ,`PhotoCount` = '7' ,`PostalCode` = '77053' ,`RoomCount` = '12' ,`ListPrice` = '363990.00' ,`Status` = 'Active' ,`StreetName` = 'Bollardpoint' ,`StreetNumber` = '15526' ,`StreetSuffix` = 'Lane' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2½ Baths, Game Room Up, Open Concept Kitchen/Dining Combo, Primary Bedroom Down, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Luxury Vinyl Plank Flooring in Dining Room, Kitchen, and Family Room, Quartz Kitchen Countertops with Island, Herringbone Tile Backsplash, Undermount Stainless Steel Sink, Stainless Steel Appliances, 42” Upper Kitchen Cabinets, Wrought Iron Spindles, Covered Patio, Landscaping with Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE AUGUST.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLK 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '3.0075' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707747' WHERE `Matrix_Unique_ID` = '208040055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:40:49.430' ,`MLSNumber` = '33313793' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600557' ,`Longitude` = '-95.445285' ,`PhotoCount` = '7' ,`PostalCode` = '77053' ,`RoomCount` = '12' ,`ListPrice` = '371990.00' ,`Status` = 'Active' ,`StreetName` = 'Bollardpoint' ,`StreetNumber` = '15518' ,`StreetSuffix` = 'Lane' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2½ Baths, Game Room Up, Media Room Up, Open Concept Kitchen/Dining Combo, Primary Bedroom Down, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Tile Flooring in Dining Room, Kitchen, and Bathrooms, Granite Kitchen Countertops, Tile Backsplash, Undermount Stainless Steel Sink, Stainless Steel Appliances with Microwave, Wrought Iron Stair Parts, Covered Patio, Landscaping with Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE AUGUST.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK 1 SEC 1' ,`LotDesciption` = 'Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '3.0075' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707747' WHERE `Matrix_Unique_ID` = '208040684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:54:54.880' ,`MLSNumber` = '97682472' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.462558' ,`Longitude` = '-95.247803' ,`PhotoCount` = '7' ,`PostalCode` = '77511' ,`RoomCount` = '10' ,`ListPrice` = '358990.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Line' ,`StreetNumber` = '306' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1837' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, ON THE LAKE, Separate Garden Tub and Shower, Wood Look Tile in Kitchen, Family Room, Bathrooms, Dining, Utility Room and Hall, Silestone Kitchen Countertops with Island, Mosaic Tile Backsplash, 42” Upper Kitchen Cabinets, Upgraded Stainless Steel Appliances, Covered Patio, 4\' Garage extension, Garage Door Opener, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE JUNE.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 1 SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MARK TWAIN ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kendall Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707747' WHERE `Matrix_Unique_ID` = '208049826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:53:46.583' ,`MLSNumber` = '7355607' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.466326' ,`Longitude` = '-95.247384' ,`PhotoCount` = '7' ,`PostalCode` = '77511' ,`RoomCount` = '11' ,`ListPrice` = '334990.00' ,`Status` = 'Active' ,`StreetName` = 'Latigo' ,`StreetNumber` = '5306' ,`StreetSuffix` = 'Court' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 4 Bedroom, 2 Bath, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, LVP Floors in Kitchen, Family Room, Bathrooms, and Dining Room, Granite Kitchen Countertops with Island, Mosaic Tile Backsplash, 42” Upper Kitchen Cabinets, Upgraded Stainless Steel Appliances, Covered Patio, Stone Accents, Irrigation System in Front and Side Yards, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE OCTOBER.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 64 BLK 1 SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MARK TWAIN ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kendall Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707747' WHERE `Matrix_Unique_ID` = '208074743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:53:13.670' ,`MLSNumber` = '63756161' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.466421' ,`Longitude` = '-95.247902' ,`PhotoCount` = '6' ,`PostalCode` = '77511' ,`RoomCount` = '10' ,`ListPrice` = '328990.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade' ,`StreetNumber` = '5307' ,`StreetSuffix` = 'Court' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1837' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, LVP Floors in Kitchen, Family Room, Baths, Dining and Utility Room, Granite Kitchen Countertops with Island, Mosaic Tile Backsplash, 42” Upper Kitchen Cabinets, Upgraded Stainless Steel Appliances, Covered Patio, Stone Accents, Irrigation System in Front and Side Yards, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE SEPTEMBER.' ,`Acres` = '0.132' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 45 BLK 1 SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MARK TWAIN ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kendall Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707747' WHERE `Matrix_Unique_ID` = '208082182' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:55:23.677' ,`MLSNumber` = '52510054' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841604' ,`Longitude` = '-95.858595' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '411650.00' ,`Status` = 'Active' ,`StreetName` = 'Marisol Bay' ,`StreetNumber` = '896' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 52510054 - Built by HistoryMaker Homes - November completion! ~ Light, bright, open, spacious two-story with oversized primary suite upstairs combined with aPrimary closet to match! Three-car-tandem garage solves any parking problems and/or provides some extra storage/workout/shop space. Privacy with nice green-space behind the home. House faces South/East. This one is a must see!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 46 Block: 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5714' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707747' WHERE `Matrix_Unique_ID` = '208143816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:10:24.433' ,`MLSNumber` = '63149671' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.136182' ,`Longitude` = '-95.317446' ,`PhotoCount` = '9' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Jordan Pond' ,`StreetNumber` = '21524' ,`StreetSuffix` = 'Ridge' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Entertain in style and live in comfort with this impressive new construction home in The Highlands! Gather in the open-concept dining and living areas for tasteful meals and memorable evenings together. The Epicurean kitchen splits prep, cooking, and presentation zones for greater culinary delight. Relax into your leisurely evenings on the breezy covered patio overlooking one of The Highlands many nature trails. A refreshing en suite bathroom and sprawling walk-in closet contribute to the everyday vacation of your Owner’s Retreat. Additional bedrooms on both floors ensure that everyone has an amazing place to make their own. Design the ideal space for your family to play, learn, and grow together in the expansive upstairs retreat.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 54 Block 4' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '4867' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707747' WHERE `Matrix_Unique_ID` = '208169427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:48:44.603' ,`MLSNumber` = '13758028' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222290' ,`Longitude` = '-95.703056' ,`PhotoCount` = '7' ,`PostalCode` = '77354' ,`RoomCount` = '14' ,`ListPrice` = '375990.00' ,`Status` = 'Active' ,`StreetName` = 'Bell\'s Vireo' ,`StreetNumber` = '15419' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 3.5 Bath, Game Room, Study, Formal Dining Room, Fireplace, Granite Topped Dual Vanities in Primary Bath, Gas Tankless Water Heater, Wrought Iron Stair Rails, Separate Garden Tub and Shower, Vinyl Plank Floors in Entry, Study, Dining Room, Family Room, Ceramic Tile Floors All Baths, Granite Kitchen Countertops with Island, Mosaic Tile Backsplash, Stainless Steel Appliances, 42” Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, Covered Back Patio, Stone Accents, Fully Sodded Front & Back Yard, Home Backs up to Walking Path and Reserve, Treed Back Yard, Irrigation System, Tech Shield Radiant Barrier, Environments for Living Home, plus more... AVAILABLE AUGUST/SEPTEMBER.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 3 SEC 3B' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4692' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707748' WHERE `Matrix_Unique_ID` = '208675524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:48:16.070' ,`MLSNumber` = '90454297' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222370' ,`Longitude` = '-95.702966' ,`PhotoCount` = '9' ,`PostalCode` = '77354' ,`RoomCount` = '14' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Bell\'s Vireo' ,`StreetNumber` = '15415' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom (All Bedrooms Up), 2.5 Bath, Game Room, Study, Formal Dining Room, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Wood-Like Floors in Dining Room, Study, Kitchen and Family Room, Granite Kitchen Countertops with Island, Herringbone Tile Backsplash, Stainless Steel Appliances, 42” Upper Kitchen Cabinets, Wrought Iron Stair Rails, Upgraded Light and Trim Packages, Covered Back Patio, Stone Accents, Fully Sodded Front & Back Yard, Irrigation System, Tech Shield Radiant Barrier, Environments for Living Home, plus more... AVAILABLE AUGUST/SEPTEMBER.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 3 SEC 3B' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5059' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707748' WHERE `Matrix_Unique_ID` = '208675906' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:58:28.817' ,`MLSNumber` = '16043554' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.426771' ,`Longitude` = '-95.449137' ,`PhotoCount` = '10' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '339990.00' ,`Status` = 'Active' ,`StreetName` = 'Homewood Point' ,`StreetNumber` = '1623' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, 2.5 Car Garage, Study, Granite Dual Square Vanities in Owner’s Bath, Separate Garden Tub and Shower, Rigid Core Floors in Entry, Study, Dining, Utility, Kitchen, Breakfast, Family Room and All Baths, Quartz Kitchen Countertops with Island, Mosaic Tile Backsplash, Granite Countertops in Secondary Bath, Stainless Steel Appliances, Upgrade Interior Doors w/ Satin Nickel Hardware, 42” Upper Kitchen Cabinets, Full Gutters, Covered Patio, Full Sod, Irrigation, Stone Accents, Brick Back, Brick Front Porch, 2” Window Blinds, Tech Shield Roof, Environments for Living Home, plus more…AVAILABLE DECEMBER .' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 2 SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707748' WHERE `Matrix_Unique_ID` = '208771967' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:58:54.853' ,`MLSNumber` = '97623756' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.426771' ,`Longitude` = '-95.449137' ,`PhotoCount` = '10' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Homewood Point' ,`StreetNumber` = '1627' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1837' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, 3 Car Garage, Study, Formal Dining, Granite Dual Square Vanities in Owner’s Bath, Separate Garden Tub and Shower, Rigid Core Floors in Entry/Foyer, Study, Dining, Utility, Kitchen, Breakfast, Family Room and All Baths, Granite Kitchen Countertops with Island, Tile Backsplash, Granite Countertops in Secondary Bath, 42\" Upper Kitchen Cabinets, Stainless Steel Appliances, 2” Window Blinds, Upgrade Interior Doors w/ Satin Nickel Hardware, Stone Accents, Brick Back, Brick Front Porch, Covered Patio, Full Sod and Irrigation System, Full Gutters, Corner Home Site, Tech Shield Roof, Environments for Living Home, plus more…AVAILABLE DECEMBER.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 2 SEC 8' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707748' WHERE `Matrix_Unique_ID` = '208773515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:59:43.117' ,`MLSNumber` = '8465559' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.426771' ,`Longitude` = '-95.449137' ,`PhotoCount` = '10' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '398990.00' ,`Status` = 'Active' ,`StreetName` = 'Homewood Point' ,`StreetNumber` = '1607' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2 1/2 Bath, 3 Car Garage, Study, Formal Dining, Game Room & Owner’s Suite Up, Granite Dual Square Vanities in Owner’s Bath, Separate Garden Tub and Shower, Rigid Core Floors in Entry, Utility, Study, Dining, Kitchen/Breakfast, Family Room and all Baths, Quartz Kitchen Countertops with Island, Marble Backsplash, 42” Upper Kitchen Cabinets, Upgraded Stainless Steel Appliances, Wrought Iron Stair Parts, Extended Covered Patio, Full Sod and Irrigation System, Full Gutters, Brick Back, Brick Front Porch, Stone Accented Elevation, Tech Shield Roof, Environments for Living Home, plus more…AVAILABLE DECEMBER.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6 BLK 2 SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707748' WHERE `Matrix_Unique_ID` = '208776558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:38:06.850' ,`MLSNumber` = '82397962' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.270988' ,`Longitude` = '-95.467087' ,`PhotoCount` = '49' ,`PostalCode` = '77304' ,`RoomCount` = '4' ,`ListPrice` = '484318.00' ,`Status` = 'Active' ,`StreetName` = 'Sendero' ,`StreetNumber` = '831' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 82397962 - Built by Highland Homes - February completion! ~ A two-story entry and double stacked windows in the living area make the Everleigh inviting and bright from the start. The open concept kitchen and dining areas have a large island, window seat and great cabinet space. Beautiful bay windows in the primary suite provide a seating area. The primary suite and a 2nd bedroom are downstairs. There are 2 bedrooms, a full bath and game room upstairs. Includes a SMART HOME Package, tankless water heater, full sprinkler system and a 2 car garage.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'L09, B03' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5040' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1072' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707748' WHERE `Matrix_Unique_ID` = '208778465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:51:39.897' ,`MLSNumber` = '30431677' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225558' ,`Longitude` = '-95.701898' ,`PhotoCount` = '10' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '345990.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Warbler' ,`StreetNumber` = '40351' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2387' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2.5 Baths, Open Concept Kitchen/Dining Combo, Game Room Up, Separate Tub & Shower in Primary Bath, Dual Vanities in Primary Bath, Luxury Vinyl Plank Floors in Entry, Dining/Kitchen Area, Family Room, Hallway and All Wet Areas, Granite Kitchen Countertops with Island, 3x12 Herringbone Tile Backsplash, Single Bowl Undermount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, Extended Covered Patio, Stone Accents, Full Gutters, Landscaping with Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home... AVAILABLE NOVEMBER/DECEMBER.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 9 BLK 3 SEC 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707748' WHERE `Matrix_Unique_ID` = '208966420' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:49:31.510' ,`MLSNumber` = '49315526' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225668' ,`Longitude` = '-95.701877' ,`PhotoCount` = '9' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '282990.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Warbler' ,`StreetNumber` = '40347' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Pocket Office, Island Kitchen, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Vinyl Plank Floors in Pocket Office, Dining Room, Kitchen, Family Room and All Wet Areas, Granite Kitchen Countertops, Tile Backsplash, Undermount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, Grey 42” Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, Covered Patio, Landscaping with Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE SEPTEMBER/OCTOBER.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 3 SEC 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707749' WHERE `Matrix_Unique_ID` = '208967571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:56:15.220' ,`MLSNumber` = '55959672' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835460' ,`Longitude` = '-95.860906' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '349950.00' ,`Status` = 'Active' ,`StreetName` = 'Laguna' ,`StreetNumber` = '828' ,`StreetSuffix` = 'Green' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 55959672 - Built by HistoryMaker Homes - October completion! ~ Beautiful light, bright, open one-story. Live large in a small footprint! Spacious Primary, Covered Extended Patio. Window Nook @ Breakfast Area. Tray ceilings in Family area and Primary Suite. Neutral color scheme with granite, light gray cabinets and glossy white backsplash in kitchen.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 93; Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5530' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707749' WHERE `Matrix_Unique_ID` = '208969549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:51:04.783' ,`MLSNumber` = '72855849' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225647' ,`Longitude` = '-95.702010' ,`PhotoCount` = '9' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Warbler' ,`StreetNumber` = '40343' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 3 Bedroom, 2.5 Baths, Game Room & All Bedrooms Up, Zoned A/C (1 unit, 2 T-Stats), Open Concept Kitchen/Dining Combo, Dual Vanities in Owner’s Bath, Wrought Iron Stair Rails, Luxury Vinyl Plank Floors in Dining/Kitchen Area, Family Room, and All Wet Areas, Granite Kitchen Countertops, Tile Backsplash, Undermount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, Extended Covered Patio, Full Gutters, Full Sod and Irrigation, Stone Accented Elevation, Tech Shield Radiant Barrier, Environments for Living Home, plus more... AVAILABLE SEPTEMBER/OCTOBER.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 11 BLK 3 SEC 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707749' WHERE `Matrix_Unique_ID` = '208986307' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','209208780','1663707749','209208780','2022-09-07T06:14:15.093','76928850','Beverly Bradley','Weekley Homes','','','30.277886','-95.566003','34','77316','6','452886.00','Active','Bungalow','187','Drive','Montgomery','2','0','3','1900','Single-Family','Create the lifestyle of your dreams with the bold, effortless luxury of this new construction home in Woodforest. Begin and end each day in the spacious Owner\'s Retreat that features a pamper-ready bathroom and a sprawling walk-in closet. Enjoy a book and your favorite beverage from the comfort of your classic porch or covered back patio. Your open floor plan provides a beautiful expanse for you to fill with decorative flair and lifelong memories. The epicurean kitchen supports your culinary adventures and includes a corner pantry and a full-function island. The spare bedrooms each offer a unique space and endless personalization potential. Create an organized home office, family movie theater, or an inventive specialty room in the versatile study. Storage abounds in the oversized garage with room for a gym or workshop. Enjoy modern farmhouse living in The Parma!','','39','David Weekley Homes','','','','Home Protection Plan,Mud,No Disclosures','1','','','Conroe Southwest','Central Gas','1','Lot 4 Block 3','Subdivision Lot','','Survey','','1500','1','To Be Built/Under Construction','2','Convection Oven,Gas Oven','0','','','Gas Cooktop','','Composition','37 - Montgomery','LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Builder','1','Contemporary/Modern','Woodforest - Kingsley Square','','','Water District','',''); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:52:04.250' ,`MLSNumber` = '19357889' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838823' ,`Longitude` = '-95.858422' ,`PhotoCount` = '28' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '549504.00' ,`Status` = 'Active' ,`StreetName` = 'Bahia Bay' ,`StreetNumber` = '801' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 19357889 - Built by HistoryMaker Homes - October completion! ~ This home sits on a beautiful premium corner homesite. It is the 42nd ANNIVERSARY GHBA BENEFIT HOME. HEMLOCK H40276201 W 3160 sq ft. 4 BEDS, 3 BATHS, 2 GARAGE, 2STORY. 10\' Ceilings Throughout First Floor, Luxury Vinyl Plank Flooring in Entry, Utility, Kitchen, Nook & Family Room, 42 inch White Kitchen Cabinets with Crown Moulding and Kitchen Island. Quartz Countertops with Ceramic Tile Backsplash, Stainless Steel Whirlpool Kitchen Appliances including Microwave. Media Room, Gameroom & Storage Under the Stairs. Master Suite with Garden Tub, Separate Shower with Double Vanity & Second Sink. Full Yard Sod with Full Irrigation with Rotary Heads. Extended Covered Patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 116; Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9028' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = '' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707749' WHERE `Matrix_Unique_ID` = '209539514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:55:59.603' ,`MLSNumber` = '88456259' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.462402' ,`Longitude` = '-95.251709' ,`PhotoCount` = '7' ,`PostalCode` = '77511' ,`RoomCount` = '13' ,`ListPrice` = '377990.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Rim' ,`StreetNumber` = '4701' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2 1/2 Bath, Study, Game Room plus Bonus Room Up, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Rigid Core Floors in Kitchen, Family Room, Bathrooms, and Utility Room, Granite Kitchen Countertops with Island, Mosaic Tile Backsplash, 42” Upper Kitchen Cabinets, Upgraded Stainless Steel Appliances, Wrought Iron Spindles, Extended Covered Patio, Stone Accents, Irrigation System in Front and Side Yards, Tech Shield Radiant Barrier, Environments for Living Home, plus more... AVAILABLE AUGUST/SEPTEMBER.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 4 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6472' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MARK TWAIN ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kendall Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707749' WHERE `Matrix_Unique_ID` = '209545184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:00:55.727' ,`MLSNumber` = '33190253' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.405771' ,`Longitude` = '-95.508276' ,`PhotoCount` = '50' ,`PostalCode` = '77318' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Winged Elm' ,`StreetNumber` = '155' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Thornleigh combines easy elegance with the streamlined versatility to adapt to your family’s lifestyle changes through the years. Escape to the everyday vacation of your Owner’s Retreat, which includes a delightful bathroom and a deluxe walk-in closet. Your open-concept living space awaits your interior design style to create the ultimate atmosphere for special occasions and daily life. The streamlined kitchen is optimized to support solo chefs and family cooking adventures. Unique decorative flair and growing minds are equally at home in the lovely spare bedrooms. Craft the perfect specialty rooms for you and yours in the incredible downstairs sunlit study and the cheerful upstairs retreat. Experience the benefits of living in an award winning urban planned development of The Woodlands Hills with miles of hiking and biking trails. Resort style amenities include adult lap pool, full size gym, splash pad and lazy river. Home is situated on oversize corner cul-de-sac homesite.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 37 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707749' WHERE `Matrix_Unique_ID` = '209602766' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:07:14.037' ,`MLSNumber` = '4029084' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.450320' ,`Longitude` = '-95.397640' ,`PhotoCount` = '48' ,`PostalCode` = '77578' ,`RoomCount` = '5' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Bronte' ,`StreetNumber` = '9314' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Entertain in style and enjoy the everyday comforts of this new home in Meridiana! Begin and end each day in the perfect paradise of your Owner’s Retreat, which features a refined bathroom and a sprawling walk-in closet. Each spare bedroom provides a wonderful place for unique personalities to flourish. The chef’s specialty kitchen includes a full-function island and a walk in pantry. Your open floor plan offers an impeccable space to play host to picture-perfect memories and brilliant social gatherings.\r\n\r\n\r\n\r\nContact the David Weekley at Meridiana Team to schedule your tour of this sensational new construction home in Manvel, Texas!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707749' WHERE `Matrix_Unique_ID` = '209663940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:22:30.283' ,`MLSNumber` = '10530615' ,`ListAgentFullName` = 'Sergio De La Llata Jr.' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647654' ,`Longitude` = '-95.623456' ,`PhotoCount` = '23' ,`PostalCode` = '77498' ,`RoomCount` = '3' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenridge' ,`StreetNumber` = '13627' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1383' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 13627 Greenridge Dr, Sugar Land, TX 77498 this 3 bedrooms and 2 full baths home is located in a quiet neighborhood with no HOA in the Ford Bend County and just minutes away from Highway 6. Great bones and ready for a new family to call it home.' ,`Acres` = '0.1676' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'GREENBRIAR ADDN, BLOCK 5, LOT 9' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BARRINGTON PLACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Greenbriar Add' ,`TaxAmount` = '3209' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707749' WHERE `Matrix_Unique_ID` = '209671273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:10:01.457' ,`MLSNumber` = '71232898' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404928' ,`Longitude` = '-95.509030' ,`PhotoCount` = '22' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '393309.00' ,`Status` = 'Active' ,`StreetName` = 'Lincoln Rim' ,`StreetNumber` = '200' ,`StreetSuffix` = 'Pass' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2219' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Treat yourself to the captivating lifestyle experience of the four bedroom three bath Woodworth dream home plan. Play host and get the most out of everyday life in your welcoming and beautiful open-concept living spaces. The modern kitchen features a large pantry, plenty of prep space, and a full-function island. Each spare bedroom presents a wonderful place for individual styles to shine. Bedroom four is an elegant guest suite with it\'s own personal full bath and walk-in closet. Your bright and airy study is the perfect place for a productive home office, a music room, or a family movie theater. End each day and wake up refreshed in the luxurious Owner’s Retreat that includes a serene en suite bathroom with Super Shower and a spacious walk-in closet. Explore the LifeDesign? benefits that make every day a delight in this refined new home plan.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 06 Block 02' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707750' WHERE `Matrix_Unique_ID` = '209747762' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:50:02.243' ,`MLSNumber` = '35289977' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839442' ,`Longitude` = '-95.858025' ,`PhotoCount` = '21' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '429873.00' ,`Status` = 'Active' ,`StreetName` = 'Marisol Bay' ,`StreetNumber` = '872' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 35289977 - Built by HistoryMaker Homes - October completion! ~ WATER VIEW - Light, bright, and airy Holbrook-T floor plan, with primary suite down, 2625 sq ft. Extended covered patio, Game room, 4 bedrooms, 3 baths, window seat at breakfast nook, and tray ceiling are only a few of the upgrades included in this home. Neutral colors inside accent this spacious floor plan, come take in the view!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 40 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5713' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707750' WHERE `Matrix_Unique_ID` = '209783324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:16:56.817' ,`MLSNumber` = '87816047' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477689' ,`Longitude` = '-95.505676' ,`PhotoCount` = '38' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekside Breeze' ,`StreetNumber` = '2131' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Explore the combination of classic appeal and modern design of this wonderful new home in Sienna! Begin and end each day in the perfect paradise of your Owner’s Retreat, which features a spa-inspired bathroom and a luxury walk-in closet. The streamlined kitchen is optimized to support solo chefs and family cooking adventures. Your open-concept living space offers energy-efficient windows and boundless decorative potential. Take a breath of fresh air and enjoy a gentle breeze from your timeless covered porch. Each upstairs bedroom provides a great place to grow and its own walk in closet. Create the ultimate family fun and games zone in the lively and bright upstairs retreat.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707750' WHERE `Matrix_Unique_ID` = '209799449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:03:52.317' ,`MLSNumber` = '83880590' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.204460' ,`Longitude` = '-95.332260' ,`PhotoCount` = '33' ,`PostalCode` = '77302' ,`RoomCount` = '7' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Candy Apple' ,`StreetNumber` = '15611' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This entertainer\'s dream home has beautiful vinyl wood flooring throughout and an oversized back patio perfect for summer cookouts! Complete with a chef\'s kitchen featuring mounted oven and 36\" venthood, granite countertops, and a walk in Pantry. The owner\'s retreat has a huge closet and super shower with spa like rain head. Come see us today to make this dream home yours!\r\n\r\n\r\nContact the David Weekley at ARTAVIA Team to learn about the amazing community amenities you’ll enjoy after moving into this lovely new home in Conroe, Texas!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 05' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection 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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707750' WHERE `Matrix_Unique_ID` = '209830279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:09:37.947' ,`MLSNumber` = '22511593' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404003' ,`Longitude` = '-95.509940' ,`PhotoCount` = '19' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Lincoln Rim' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Pass' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2354' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Thornleigh home plan combines easy elegance with the streamlined versatility to adapt to your family’s lifestyle changes through the years. Escape to the everyday vacation of your Owner’s Retreat, which includes a delightful bathroom with Super Shower and a deluxe walk-in closet. Your open-concept living space awaits your interior design style to create the ultimate atmosphere for special occasions and daily life. The streamlined kitchen is optimized to support solo chefs and family cooking adventures. Unique decorative flair and growing minds are equally at home in the lovely spare bedrooms. Craft the perfect specialty rooms for you and yours in the incredible FlexSpace? of the sunlit study and the cheerful upstairs retreat. Build your future together in this fantastic new home plan.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 05 Block 02' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707750' WHERE `Matrix_Unique_ID` = '209833574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:06:17.160' ,`MLSNumber` = '76128637' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.476540' ,`Longitude` = '-95.506271' ,`PhotoCount` = '38' ,`PostalCode` = '77459' ,`RoomCount` = '6' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant View' ,`StreetNumber` = '10714' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Top-quality craftsmanship and remarkable luxuries combine to create The Bingham new home plan. Furnish the graceful living space to reflect your ideal décor and interior design style. The epicurean kitchen provides a full-function island and ample room for food storage and meal prep. Your covered patio adds classic relaxation space for calm evenings and fun-filled weekends. End each day and wake up refreshed in the glamorous Owner’s Retreat, which includes a deluxe bathroom and a wardrobe-expanding walk-in closet. The spare bedroom suite presents abundant personal space and a private bathroom. Design your ultimate home office or an innovative specialty room in the captivating front study. Bonus storage and convenience add a dash of splendor to this expertly-crafted EnergySaver™ family home plan.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707750' WHERE `Matrix_Unique_ID` = '209834826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:05:56.133' ,`MLSNumber` = '29769796' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.476540' ,`Longitude` = '-95.506271' ,`PhotoCount` = '43' ,`PostalCode` = '77459' ,`RoomCount` = '7' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant View' ,`StreetNumber` = '10715' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the combination of function and luxury that makes each day superb in The Thomasville luxury home plan. Your open-concept living spaces allows gentle sunlight to shine on your interior design style from energy-efficient windows. The dining space is distinguished by a ceiling that opens to the second floor. The kitchen island faces the dining space, making it an ideal staging area for gourmet dinners and relaxed family breakfasts. Each upstairs bedroom offers unique appeal and an abundance of closet space. The upstairs retreat makes a great game room or family movie theater. The glamourous Owner’s Retreat includes a deluxe en suite bathroom and walk-in closet. Start Creating Your Dream Home with this new floor plan from David Weekley Homes.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707750' WHERE `Matrix_Unique_ID` = '209837083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:13:11.600' ,`MLSNumber` = '13649855' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477689' ,`Longitude` = '-95.506234' ,`PhotoCount` = '41' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Bridgeport Path' ,`StreetNumber` = '2138' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Top-quality craftsmanship is matched with luxurious comforts to make The Devon a uniquely impressive family home plan. End each day and wake up refreshed in the delightful Owner’s Retreat, which includes a deluxe bathroom and walk-in closet. The chef’s specialty kitchen supports the full variety of cuisine exploration with a spacious pantry, extended countertops, and a full-function island. Your open floor plan offers soaring ceilings and a dynamic opportunity to design your ideal living space. Each spare bedroom provides a fantastic place for unique personalities to shine. Craft your perfect family lounge and movie theater in the cheerful upstairs retreat. How do you imagine your #LivingWeekley experience in this extraordinary new home plan?' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707751' WHERE `Matrix_Unique_ID` = '209944328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:05:32.420' ,`MLSNumber` = '57618531' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.476540' ,`Longitude` = '-95.506271' ,`PhotoCount` = '40' ,`PostalCode` = '77459' ,`RoomCount` = '7' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant View' ,`StreetNumber` = '10710' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2361' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Design excellence and attention to detail make every day in The Braden family home plan amazing. Your bright and airy study is the perfect place for a productive home office or a unique lounge. Share your culinary masterpieces on the presentation island in the modern kitchen. Decorate and furnish your sunlit open floor plan to perfectly fit your interior design style. Enjoy leisurely evenings and breezy weekends relaxing on the deluxe covered patio. Your Owner’s Retreat provides a glamorous retreat from the world and includes a luxury bathroom and walk-in closet. Each spare bedroom features enhanced privacy with ample living and closet space. The incredible upstairs retreat presents a unique place to create an ultimate family fun zone and lifelong memories. Design details include a downstairs powder room and extra storage space in the garage. How do you imagine your Living Weekley experience in this new home plan' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707751' WHERE `Matrix_Unique_ID` = '209946720' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:01:17.677' ,`MLSNumber` = '84047795' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404928' ,`Longitude` = '-95.509030' ,`PhotoCount` = '41' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Lincoln Rim' ,`StreetNumber` = '219' ,`StreetSuffix` = 'Pass' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1870' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Gladesdale lifestyle home plan strikes a pristine balance between innovative convenience and classic luxury. Craft your perfect home office, library, or family entertainment lounge in the cheerful study. The epicurean kitchen features a presentation island and ample room for food storage and meal prep. Your open floor plan provides a sunlit expanse of enhanced livability and decorative possibilities. Each spare bedroom offers plenty of space for growing minds to shine. Your Owner’s Retreat presents a serene retreat from the world that includes a deluxe en suite bathroom with walk-in shower and closet. Experience the benefits of our Brand Promise in this remarkable new home plan.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 03 Block 07' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707751' WHERE `Matrix_Unique_ID` = '209989161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:47:47.227' ,`MLSNumber` = '47533040' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223214' ,`Longitude` = '-95.702989' ,`PhotoCount` = '7' ,`PostalCode` = '77354' ,`RoomCount` = '13' ,`ListPrice` = '365990.00' ,`Status` = 'Active' ,`StreetName` = 'Goldeneye' ,`StreetNumber` = '40581' ,`StreetSuffix` = 'Place' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2.5 Baths, Formal Dining, Game Room Plus Bonus Room Up, Primary Suite Down, Dual Vanities Primary Bath, Open Concept Kitchen/Family Room, 12”x 24” Tile Floors in Entry, Dining, Kitchen, and all Baths, Undermount Composite Matte Grey Sink with Pull Out Faucet, Granite Kitchen Countertops with Island, Tile Backsplash, 42” Upper Grey Kitchen Cabinets, Stainless Steel Kitchen Appliances, Wrought Iron Stair Spindles, Full Sod Front and Rear Yard, Full Irrigation System, Full Gutters, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE OCTOBER.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 20 BLK 4 SEC 3B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707751' WHERE `Matrix_Unique_ID` = '210065965' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:57:20.800' ,`MLSNumber` = '39445722' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.433451' ,`Longitude` = '-95.450781' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '337990.00' ,`Status` = 'Active' ,`StreetName` = 'Greenhorn' ,`StreetNumber` = '10334' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 4 Bedroom, 2 Bath, Study with French Doors, Formal Dining, Dual Vanities in Primary Bath, Separate Garden Tub and 1/2 Glass Wall Shower, Rigid Core Floors in Entry/Foyer, Study, Dining, Kitchen, Family Room and All Baths, Recessed Tile Shower in Primary Bath, Granite Kitchen Countertops with Island, Granite Bathroom Tops with Square Sinks, Mosaic Tile Backsplash, 42” Upper Kitchen Cabinets, Stainless Steel Appliances, Stone Accents, 2” Window Blinds, Upgraded Lighting & Plumbing Packages, Rocker Switches, Brick Back, Covered Patio, Full Sod and Irrigation System, Full Gutters, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE OCTOBER.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLK 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8059' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707751' WHERE `Matrix_Unique_ID` = '210066397' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:41:19.883' ,`MLSNumber` = '42633041' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.601798' ,`Longitude` = '-95.443862' ,`PhotoCount` = '5' ,`PostalCode` = '77053' ,`RoomCount` = '12' ,`ListPrice` = '397990.00' ,`Status` = 'Active' ,`StreetName` = 'Mooring Cove' ,`StreetNumber` = '4402' ,`StreetSuffix` = 'Court' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cul-de-sac Corner LAKE LOT!! 2 Story, 4 Bedroom, 2 Full baths, 2 Half Baths, Game Room & Study Up, Open Concept Kitchen/Dining Combo, Primary Bedroom Down, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Ceramic Tile in Dining Room, Kitchen and Bathrooms, Granite Kitchen Countertops with Island, Ceramic Tile Backsplash, Stainless Steel Appliances with Microwave, Cast Stone Fireplace, Upgraded Lighting and Trim Packages, Wrought Iron Stair Parts, Extended Covered Patio, Brick on Four Sides of Home, Landscaping with Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE OCTOBER.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK 2 SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707751' WHERE `Matrix_Unique_ID` = '210067447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:17:41.260' ,`MLSNumber` = '31673956' ,`ListAgentFullName` = 'Michael Cordray' ,`ListOfficeName` = 'Save 1900 Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.288357' ,`Longitude` = '-94.817127' ,`PhotoCount` = '15' ,`PostalCode` = '77551' ,`RoomCount` = '3' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Ursuline' ,`StreetNumber` = '4607' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well maintained bungalow on a charming street has 3 bedrooms and 1 bath. Notable from the exterior is the long driveway with ample parking which leads to a well appointed man cave in the garage with a half bath and its own central AC. In the main residence there is plenty of character throughout from the original wood floors and windows as well as more storage than you would expect. There is also a shed for beach toys and lawn equipment. Must see.' ,`Acres` = '0.118' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR E 1/2 OF LOT 5 & W 1/2 OF LOT 6 (5-1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Reyder Sub Blk 62' ,`TaxAmount` = '4460' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707751' WHERE `Matrix_Unique_ID` = '210204926' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:41:37.853' ,`MLSNumber` = '83913374' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.091067' ,`Longitude` = '-95.698982' ,`PhotoCount` = '4' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '304990.00' ,`Status` = 'Active' ,`StreetName` = 'Pensford' ,`StreetNumber` = '17718' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1624' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedrooms, 2 Baths, Pocket Office, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Vinyl Plank Floors in Entry, Kitchen, Pocket Office, Dining, Family, all Baths and Secondary Bedrooms, Hallways, and Utility Room, Carpet in Primary Bedroom, Granite Countertops in Kitchen with Tile Backsplash, Under Cabinet Lighting in Kitchen, Single Bowl Quartz Undermount Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets with Crown Molding, Upgraded Lighting, 2” Blinds, Covered Rear Patio, Full Gutters, Brick Front and Sides, Tech Shield Radiant Barrier Roof Decking, Environments for Living Home, plus more...AVAILABLE AUGUST/SEPTEMBER.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 30 BLK 3 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosehill Meadow' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707752' WHERE `Matrix_Unique_ID` = '210507488' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:54:16.363' ,`MLSNumber` = '64725954' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.270818' ,`Longitude` = '-95.476122' ,`PhotoCount` = '8' ,`PostalCode` = '77304' ,`RoomCount` = '3' ,`ListPrice` = '577253.00' ,`Status` = 'Active' ,`StreetName` = 'Cibolo Creek' ,`StreetNumber` = '618' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 64725954 - Built by Drees Custom Homes - Ready Now! ~ The Alexandria at Grand Central Park is a spacious one-story home. The open family room and kitchen feature a soaring vaulted ceiling. With a large serving island, walk-in pantry and ample cabinets, the kitchen is a chef\'s dream. The dining room is perfect for family gatherings. Complete with two guest bedrooms, a study, pocket office, and breakfast room. The owner\'s suite is the perfect oasis with a spacious walk-in closet and two vanities. Spend time outdoors in the covered outdoor living area. Grand Central Park is rich with amenities featuring an on-site marketplace, pools, and nature trails full of lush beauty!' ,`Acres` = '0.17275' ,`Area` = '19' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S537520 - GRAND CENTRAL PARK 20, BLOCK 3, LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7525' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707752' WHERE `Matrix_Unique_ID` = '210718437' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:42:00.800' ,`MLSNumber` = '95756359' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.090906' ,`Longitude` = '-95.701055' ,`PhotoCount` = '4' ,`PostalCode` = '77377' ,`RoomCount` = '12' ,`ListPrice` = '384990.00' ,`Status` = 'Active' ,`StreetName` = 'Beeching' ,`StreetNumber` = '17818' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 story, 4 bedrooms, 2 1/2 baths, Study, Formal Dining, Kitchen/Breakfast Open to Family Room, Granite Countertops in Kitchen, Vinyl Plank Flooring in Foyer, Study, Utility, Kitchen/Breakfast, Powder, Family Room, Dining, and all Baths, Undermount Quartz Sink at Kitchen with Pull Out Faucet, 42\" Upper Kitchen Cabinets, Stainless Steel Appliance Package, 2\" Window Blinds, Iron Stair Spindles, Full Gutters, Tech Shield Radiant Barrier Roof Decking, Environments for Living Home, plus more…AVAILABLE SEPTEMBER/OCTOBER.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 2 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosehill Meadow' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707752' WHERE `Matrix_Unique_ID` = '210827582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:47:14.530' ,`MLSNumber` = '23588616' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223122' ,`Longitude` = '-95.700718' ,`PhotoCount` = '7' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '335990.00' ,`Status` = 'Active' ,`StreetName` = 'Francolin' ,`StreetNumber` = '15203' ,`StreetSuffix` = 'Place' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 4 Bedroom, 2 Bath ,Corner Lot, Fireplace, Study with French Doors, Separate Garden Tub and Shower, Vinyl Plank Flooring in Entry, Study, Dining, Kitchen/Breakfast, Granite Countertops in Kitchen with Island, Tile Backsplash, Upgraded Stainless Steel Appliances, 42” Upper Kitchen Cabinets, 2” Blinds, Upgrade Carpet and Pad, Covered Back Patio, Stone Accents, Fully Sodded Front and Back Yard, Irrigation System, Tech Shield Roof, Environments for Living Home, plus more...AVAILABLE DECEMBER.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 4 SEC 2A' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7238' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707752' WHERE `Matrix_Unique_ID` = '211107299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:50:03.570' ,`MLSNumber` = '12651756' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225460' ,`Longitude` = '-95.703469' ,`PhotoCount` = '11' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Tyto' ,`StreetNumber` = '40503' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1624' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Pocket Office, Corner Lot, Open Concept Kitchen/Dining Combo, Dual Vanities in Owner’s Bath, Luxury Vinyl Plank Floors in Dining/Kitchen Area, Family Room, Hallway and all Wet Areas, Granite Kitchen Countertops, Mosaic Tile Backsplash, Undermount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, White 42” Upper Kitchen Cabinets, Upgraded Lighting and Trim Packages, Extended Covered Patio, Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more...AVAILABLE NOVEMBER.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 3 SEC 2B' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707752' WHERE `Matrix_Unique_ID` = '211107992' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:41:44.420' ,`MLSNumber` = '3864384' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051264' ,`Longitude` = '-95.359722' ,`PhotoCount` = '20' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '274990.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Ginko' ,`StreetNumber` = '4814' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1629' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Cypresswood Landing in Spring, TX! Conveniently located with easy access to Grand Parkway, I-45, FM 1960, and I-69 - commuting to the Energy Corridor, The Woodlands, or Bush Intercontinental Airport is a breeze! The Aubrey floor plan is a spacious 2-story home with 4 bedrooms, 2.5 bathrooms, game room, and a 2-car garage. This home has it all, including soaring ceilings in the entry, vinyl plank flooring, and walk-in closets in EVERY room! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless-steel appliances! Retreat to the Owner\'s Suite featuring double sinks and a separate tub and shower! Enjoy the great outdoors on the covered patio! Don’t miss your opportunity to call Cypresswood Landing home, schedule a visit today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Blk 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.61' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707752' WHERE `Matrix_Unique_ID` = '211170474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:57:04.547' ,`MLSNumber` = '10346767' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.204900' ,`Longitude` = '-95.425974' ,`PhotoCount` = '10' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '999764.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Palmetto' ,`StreetNumber` = '10491' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 10346767 - Built by Drees Custom Homes - December completion! ~ The Brookdale II plan is tailored to fit your family\'s lifestyle. The openness of the living triangle intuitively connects the main living areas: the family room with its cozy fireplace, the kitchen with its ample work/serving island, and the dining area. A convenient study flanks the two story foyer and staircase. The outdoor living area expands this space even further for your enjoyment. The luxurious owner\'s suite features a spa-like bath and voluminous walk-in closet. For indoor entertainment, enjoy a second-floor gameroom and media.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572704 - Harper\'s Preserve 04, BLOCK 4, Lot 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '9750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double 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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707752' WHERE `Matrix_Unique_ID` = '211190203' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:15:26.960' ,`MLSNumber` = '74797868' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.276211' ,`Longitude` = '-95.476015' ,`PhotoCount` = '39' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Liatris' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Place' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2351' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This new home in Grand Central Park is designed to improve your everyday lifestyle while providing a glamorous atmosphere for social gatherings and special occasions. Guests are greeted by the spacious and stylish layout of the study. The chef’s kitchen is just around the turn, and opens up to the tall ceiling of the open-concept living area. The kitchen island is big enough to host your own cooking show, making it perfect for hosting guests. The laundry room window pairs natural light with the scent of fresh linens. You’ll love the “Texas Basement,” an easy access attic for storing seasonal decor and other bulky items.\r\n\r\n\r\n\r\nContact David Weekley’s Grand Central Park Team to learn about the industry-leading warranty and EnergySaver™ features included with this amazing new construction home in Conroe,' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 08 Block 05' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7601' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1073' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707753' WHERE `Matrix_Unique_ID` = '211271340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:09:11.740' ,`MLSNumber` = '98391481' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404179' ,`Longitude` = '-95.510026' ,`PhotoCount` = '8' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Lincoln Rim' ,`StreetNumber` = '208' ,`StreetSuffix` = 'Pass' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Gladesdale lifestyle home plan strikes a pristine balance between innovative convenience and classic luxury. Craft your perfect home office, library, or family entertainment lounge in the cheerful study. The epicurean kitchen features a presentation island and ample room for food storage and meal prep. Your open floor plan provides a sunlit expanse of enhanced livability and decorative possibilities with large windows overlooking your beautiful covered back porch. Each spare bedroom offers plenty of space for growing minds to shine. Your Extended Owner’s Retreat presents a serene retreat from the world that includes a deluxe en suite bathroom with Super Shower and walk-in closet. Experience the benefits of our Brand Promise in this remarkable new home plan.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 04 Block 02' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707753' WHERE `Matrix_Unique_ID` = '211354562' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T06:14:40.177' ,`MLSNumber` = '95779735' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135368' ,`Longitude` = '-95.318082' ,`PhotoCount` = '9' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Mount Greylock' ,`StreetNumber` = '7384' ,`StreetSuffix` = 'Loop' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This remarkable new home in The Highlands adds easy sophistication to the streamlined versatility that makes this luxury home plan ideal for families whose lifestyle needs will change through the years. Treat yourself to the everyday delight of your Owner’s Retreat, which features a spa-inspired en suite bathroom and a sizable walk-in closet. Sunshine spills into the open-concept floor plan through energy-efficient windows, highlighting your interior design style and making special occasions picture-perfect. Enjoy your quiet and fun-filled leisure time from the shade of your covered porch and peaceful green space views. The full-function island at the heart of the kitchen presents a cheerful spot to share party snacks and quick breakfasts. The Timeless Collection featuring gray cabinets and stainless gas appliances create a welcome space for creativity. Start thinking about how you’ll use and decorate the versatile spacious upstairs retreat.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41 Block 05' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707753' WHERE `Matrix_Unique_ID` = '211356337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:40:04.410' ,`MLSNumber` = '62511801' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600588' ,`Longitude` = '-95.445329' ,`PhotoCount` = '6' ,`PostalCode` = '77053' ,`RoomCount` = '11' ,`ListPrice` = '346990.00' ,`Status` = 'Active' ,`StreetName` = 'Bollardpoint' ,`StreetNumber` = '15522' ,`StreetSuffix` = 'Lane' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 4 Bedroom, 2 Full Baths, Pocket Office, Open Concept Kitchen/Dining Combo, 42” Upper Kitchen Cabinets, Single Undermount Stainless Steel Kitchen Sink, Luxury Vinyl Plank Flooring Throughout Home including Entry, Family Room, Dining Room, Kitchen and Bedrooms, Upgraded Tile in Bathrooms, Granite Countertops in Master Bath and Secondary Bathroom, Granite Kitchen Countertops with Island, Herringbone Tile Kitchen Backsplash, Stainless Steel Appliances with Microwave, Cast Stone Fireplace, Upgraded Interior Doors, Upgraded Lighting and Trim Packages, Covered Patio, Full Gutters, Landscaping with Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE NOW.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 15 BLK 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707753' WHERE `Matrix_Unique_ID` = '211368422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:49:18.797' ,`MLSNumber` = '51555955' ,`ListAgentFullName` = 'Rigoberto Villarreal' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.129160' ,`Longitude` = '-95.766581' ,`PhotoCount` = '42' ,`PostalCode` = '77355' ,`RoomCount` = '12' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Wintergreen' ,`StreetNumber` = '24602' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2563' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country style living at its finest! Ample room for kids, chickens and even a horse on this 1-acre lot in the quiet neighborhood of Clear Creek Forest. This beautiful home features a stone elevation, 3-car detached garage, large covered front porch and a swimming pool for those hot summer days. Inside you will find a very open floor plan. The formal dining has tray ceilings, crown & chair rail molding. Large family room with a stone surround fireplace is open to the kitchen. Kitchen and breakfast room feature stainless steel appliances, breakfast bar & a wall of windows overlooking the back yard. The lovely primary bedroom and en-suite bath features high ceilings, recessed lighting, French door leading to the back yard, double sinks, jetted tub with separate shower and large walk-in closet. Upstairs you will find 3 spacious bedrooms, full bath and a game room. Beautifully secluded back yard features a covered patio, 36x18 swimming pool, gazebo, fire pit area and garden.' ,`Acres` = '0.9277' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CLEAR CREEK FOREST 12, BLOCK 4, LOT 8, ACRES 0.930' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '40409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'J.L. LYON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Creek Forest' ,`TaxAmount` = '6592' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707753' WHERE `Matrix_Unique_ID` = '211505864' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:44:18.280' ,`MLSNumber` = '49111303' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504047' ,`Longitude` = '-95.445244' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '264990.00' ,`Status` = 'Active' ,`StreetName` = 'James Michael' ,`StreetNumber` = '5431' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Charleston Heights in Rosharon, TX! Conveniently located off Highway 6 near 288, Charleston Heights makes commuting a breeze! The Charlotte floor plan is a charming 1-story home with 3 bedrooms, 2 bathrooms, and a 2-car garage! This home has it all with blinds, vinyl plank flooring throughout the common areas, and NO BACK NEIGHBORS! The gourmet kitchen is sure to please with a large bar top overlooking the dining and family rooms, 42” cabinets, and granite countertops! Retreat to the Owner’s Suite featuring a beautiful bay window, sizable shower, spacious walk-in closet, and tray ceiling for some dramatic flair! Enjoy the great outdoors with a covered patio! Don’t miss your opportunity to call Charleston Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 77 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5805' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Charleston Heights' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707753' WHERE `Matrix_Unique_ID` = '211610465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:42:47.460' ,`MLSNumber` = '80169301' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.503807' ,`Longitude` = '-95.445310' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'James Michael' ,`StreetNumber` = '5439' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Charleston Heights in Rosharon, TX! Conveniently located off Highway 6 near 288, Charleston Heights makes commuting a breeze! The Grayson floorplan is a charming 1-story home with 3 bedrooms, 2 bathrooms, and a 2-car garage! This home has it all, including NO BACK NEIGHBORS! The gourmet kitchen is sure to please with an island overlooking the dining and family rooms, 42” cabinets, and granite countertops! Retreat to the spacious Owner’s Suite featuring a separate tub and shower, walk-in closet, and tray ceiling for some dramatic flair! Enjoy the great outdoors on the covered patio! Don’t miss your opportunity to call Charleston Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 75 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5805' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Charleston Heights' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707753' WHERE `Matrix_Unique_ID` = '211611157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:43:45.193' ,`MLSNumber` = '91206620' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.503560' ,`Longitude` = '-95.446921' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '304990.00' ,`Status` = 'Active' ,`StreetName` = 'Brooklyn Rose' ,`StreetNumber` = '5510' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Charleston Heights in Rosharon, TX! Conveniently located off Highway 6 near 288, Charleston Heights makes commuting a breeze! The Devonhurst floor plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, and 2-car garage. The first floor offers the perfect space for entertaining with a peninsula kitchen open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry and granite countertops. Upstairs offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, separate tub and shower, and walk-in closet. Enjoy the great outdoors on the covered patio! Don’t miss your opportunity to call Charleston Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5580' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Charleston Heights' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707754' WHERE `Matrix_Unique_ID` = '211611607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:43:21.700' ,`MLSNumber` = '8762972' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502846' ,`Longitude` = '-95.446552' ,`PhotoCount` = '20' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '294990.00' ,`Status` = 'Active' ,`StreetName` = 'Brooklyn Rose' ,`StreetNumber` = '5603' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1729' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Charleston Heights in Rosharon, TX! Conveniently located off Highway 6 near 288, Charleston Heights makes commuting a breeze! The Berkley floor plan is a charming 1-story home with 4 bedrooms, 3 baths, and 2-car garage. This home has it all, including blinds and vinyl plank flooring! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, center island, and a peninsula overlooking the family room. Retreat to the Owner\'s Suite featuring a separate tub and shower and a walk-in closet. Enjoy the great outdoors on the covered patio! Don’t miss your opportunity to call Charleston Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 40 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Charleston Heights' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707754' WHERE `Matrix_Unique_ID` = '211624217' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211896201','1663707754','211896201','2022-09-07T07:11:36.837','90429241','Alex Arenas','Keller Williams Realty -SW','','','29.606748','-95.596507','40','77478','11','770000.00','Active','Sugar Creek','1218','Boulevard','Sugar Land','3','1','4','4181','Single-Family','Gorgeous and fully remodeled home located on prestigious Sugar Creek Boulevard inside Sugar Creek subdivision. This spacious home with an open floor plan was fully remodeled and painted in July 2022. A large Calcatta Vicenza quartz island with a new Euro-Style 36-inch 5-element Jenn-Air cooktop with downdraft and seating for four is the centerpiece of this Chef\'s kitchen. New stainless steel appliances, a farmhouse sink, stunning Calcatta Vicenza quartz countertops with white cabinetry and under-mount lighting, and a butler\'s pantry with a wine fridge complete the kitchen. Calcatta quartz is used throughout the home in the bathrooms and wet bar. New low-E french doors open up from the kitchen and from the gym/ sun room unto the new concrete deck and kitchen pad that are ready for your outdoor patio furniture and your new outside kitchen. This home boasts spa-like master bathrooms in both upstairs and downstairs primary suites with large vanities, jetted tubs, and separate showers.','0.2441','29','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Home Protection Plan,Sellers Disclosure','1','Wood Burning Fireplace','1','Sugar Land East','Central Gas,Zoned','1','SUGAR CREEK SEC 21, BLOCK 6, LOT 17','In Golf Course Community','10633','Appraisal District','','650','0','','2','Single Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','DULLES ELEMENTARY SCHOOL','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','Sugar Creek Sec 21','11194','2.0094','Public Sewer,Public Water','1985','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T07:37:04.187' ,`MLSNumber` = '38330261' ,`ListAgentFullName` = 'Lisa Adams' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.176634' ,`Longitude` = '-95.793198' ,`PhotoCount` = '34' ,`PostalCode` = '77355' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeshore' ,`StreetNumber` = '20111' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled peacefully on lush, greenery-laden landscape, this picturesque setting speaks loudly to a lifestyle of natural splendor. Located five minutes from Downtown Magnolia, large oak trees. The home features open living space adorned in wood with a vaulted ceiling enhanced by a 2 story stone fireplace, beautiful antique pieces accent throughout and also interconnects a chef’s kitchen, SS appliances, granite counters and a butcher block island. 3 car garage boasts similar rustic charm. Beautiful Primary BR up with an impressive bath, corner fireplace and walk out second story porch. Live the lifestyle you have been waiting for! Lease includes the house, garage apartment and immediate space around it.' ,`Acres` = '1.709' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '5034' ,`TaxRate` = '1.858' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707754' WHERE `Matrix_Unique_ID` = '211942079' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212217095','1663707754','212217095','2022-09-07T07:34:04.100','56436219','Jessica Dabney','Keller Williams Signature','','','29.559584','-95.372154','30','77584','7','419900.00','Active','Sunnycoast','9805','Lane','Pearland','3','1','4','2443','Single-Family','Beautiful home located in the heart of Pearland right off 288. From the time you step onto the front porch you are sure to be impressed. This home features a spacious formal living and dining room. The fully upgraded kitchen has stainless steel appliances, a granite countertop island in the middle of the kitchen that is sure to be a meeting spot. The primary bedroom is very generous with space. The huge landscaped backyard will be great for entertaining or relaxing. Don’t miss out on this captivating home. Schedule a showing today!','0.1528','5','','','Electric Dryer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Pearland','Central Electric','1','SUNRISE LAKES SEC 2 (A0721 & A0304) (PEARLAND) BLK 4 LOT 11','Subdivision Lot','6656','Appraisal District','','450','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','42 - Pearland','CHALLENGER ELEMENTARY SCHOOL','GLENDA DAWSON HIGH SCHOOL','BERRY MILLER JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Sunrise Lakes','6980','2.8851','Public Sewer,Public Water','2000','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212234182','1663707754','212234182','2022-09-07T07:54:21.403','80177331','Dana Cooper','Compass RE Texas, LLCKaty','','','29.634283','-95.727226','43','77406','10','779000.00','Active','Ripe Amber Cup','2706','Court','Richmond','3','2','4','4122','Single-Family','Beautifully crafted David Weekly with timeless style and modern design combined make this a fantastic lifestyle home. The gourmet kitchen features a corner walk in pantry and a full-function island. Perfect for entertaining with large slide doors out to large, covered patio and pool area, sensational for calm evenings and weekend cookouts. Your glorious master bedroom features a scenic backyard view, expansive walk-in closet, and a personal-spa bathroom. Design details include a downstairs powder room, sunlit study, a cheerful and spacious laundry room, mudroom, and extra storage in temperature controlled 3-car garage. The second floor offers a game room, media room, Jack-and-Jill bedrooms with walk in closets while the downstairs suite offers privacy and convenience for overnight guests. New high-end Karastan carpet throughout. Harvest Green amenities include clubhouse, pool, fitness center, organic local farm, fishing, dog parks, winery, weekly Saturday Farmer\'s Market, & more!','0.2095','37','Weekly Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','0','Fort Bend County North/Richmond','Central Gas','1','HARVEST GREEN SEC 20, BLOCK 2, LOT 8','Cul-De-Sac,Subdivision Lot','9125','Appraisal District','','1075','0','','3','','1','Heated','','Gas Cooktop','','Composition','19 - Fort Bend','NEILL ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','Appointment Required,Supra Keybox','Appraisal District','2','Contemporary/Modern','Harvest Green Sec 20','15306','3.1129','Public Sewer,Public Water,Water District','2019','Appraisal District'); --> New record created successfully