Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T07:46:52.303' ,`MLSNumber` = '32325415' ,`ListAgentFullName` = 'Penny Brockway' ,`ListOfficeName` = 'Brockway Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.464910' ,`Longitude` = '-95.024527' ,`PhotoCount` = '20' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Leslie\'s' ,`StreetNumber` = '4119' ,`StreetSuffix` = 'Way' ,`City` = 'Dickinson' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Built home by Crystal Creek Homes and a JMK5 Holdings Development, this home is framed and ready for your design choices! The home boasts four bedrooms, game room up, three and a half bathrooms and an inviting kitchen that includes a chef\'s dream island, lots of beautiful cabinetry and it’s own office or large butler’s pantry. The Owner\'s Retreat sits in the back corner with a calming Owners En-suite and 2 spacious Walk-in closets. The optional bonus room is a great addition to add for just about anything and an optional extra laundry room up is absolutely a must! Enjoy the Large Utility room and pantry. You will have plenty of space for all your storage. Open concept home with so many standard upgrades. Home includes a 2 or optional 3-car side-by-side garage on a 114’ x 219 homesite. Enjoy life on your covered back porch viewing the water. So many great restaurants, golf, boating, shopping and entertainment close by.' ,`Acres` = '0.57' ,`Area` = '33' ,`BuilderName` = 'Crystal Creek' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAYOU BEND ESTATES (2017) ABST 155, BLOCK 3, LOT 4, ACRES 0.' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '24966' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Bayou Bend Estates' ,`TaxAmount` = '612' ,`TaxRate` = '2.6502' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101408' WHERE `Matrix_Unique_ID` = '196857878' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T08:34:52.230' ,`MLSNumber` = '73795990' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.641979' ,`Longitude` = '-95.759781' ,`PhotoCount` = '15' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '365990.00' ,`Status` = 'Active' ,`StreetName` = 'Avary River' ,`StreetNumber` = '3350' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 4 Bedroom, 2 Bath, Study, Covered Patio, 42\" Upper Cabinets, Garage Door Opener, Granite Countertops in Kitchen with Herringbone Backsplash, Garden Tub with Separate Shower, Dual Vanities in Primary Bath, Upgraded Lighting Package, Ceramic Tile in Entry, Kitchen/Breakfast, Utility and Baths, Fireplace, Four Sides Brick on First Floor, Tech Shield Roof, Environments for Living Home, plus more…Ready for Quick Move In!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 37 BLK 2 SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7619' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'McCrary Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101409' WHERE `Matrix_Unique_ID` = '208050572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T07:59:01.910' ,`MLSNumber` = '79640859' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151693' ,`Longitude` = '-95.616135' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Barn Owl' ,`StreetNumber` = '10106' ,`StreetSuffix` = 'Trail' ,`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, 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 Plumbing Fixtures, Covered Patio, Stained Leaded Glass Front Door, 2” Faux Wood Blinds, Tech Shield Radiant Barrier, Environments for Living Home, plus more... AVAILABLE JANUARY/FEBRUARY.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 31 BLK 1 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`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` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101409' WHERE `Matrix_Unique_ID` = '209584122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T07:56:38.457' ,`MLSNumber` = '56168068' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153650' ,`Longitude` = '-95.616938' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '277990.00' ,`Status` = 'Active' ,`StreetName` = 'Grey Fox' ,`StreetNumber` = '27282' ,`StreetSuffix` = 'Run' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1624' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Pocket Office, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Luxury Vinyl Plank Floors in Pocket Office, Dining Room, Kitchen, Family Room and All Wet Areas, Granite Kitchen Countertops, Upgrade Kitchen Backsplash, Undermount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42\" Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, Covered Rear Patio, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE JANUARY/FEBRUARY.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 20 BLK 2 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`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` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101409' WHERE `Matrix_Unique_ID` = '209832610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T08:04:15.710' ,`MLSNumber` = '10126488' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150745' ,`Longitude` = '-95.616370' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '14' ,`ListPrice` = '343990.00' ,`Status` = 'Active' ,`StreetName` = 'Whooping Crane' ,`StreetNumber` = '10108' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 5 Bedroom, 3 ½ Baths, Primary Downstairs, Game Room, Tech Room, Wrought Iron Stair Rails, Open Concept Kitchen/Dining Combo, Dual Vanities in Owner’s Bath, 17” Tile Floors in Entry, Dining/Kitchen Area, Family Room, and All Wet Areas, Granite Kitchen Countertops, Herringbone Tile Backsplash, Undermount Stainless Steel Single Bowl Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, 2\" Blinds, Extended Covered Patio Tech Shield Radiant Barrier, Environments for Living Home, plus more… AVAILABLE FEBRUARY.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 3 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`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` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101409' WHERE `Matrix_Unique_ID` = '210072132' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T08:00:36.227' ,`MLSNumber` = '40843530' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153014' ,`Longitude` = '-95.615816' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Whooping Crane' ,`StreetNumber` = '10149' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2242' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2 Full Baths and 2 Powder Baths, Primary Downstairs, Game Room, Wrought Iron Stair Rails, Open Concept Kitchen/Dining Combo, Dual Vanities in Owner’s Bath, Luxury Vinyl Plank Floors in Entry, Dining/Kitchen Area, Family Room, Hallway and All Wet Areas, Granite Kitchen Countertops, 3” x 12” Tile Backsplash, Undermount Stainless Steel Single Bowl Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, 2\" Blinds, Extended Covered Patio Tech Shield Radiant Barrier, ENERGY STAR Certified Home, plus more… AVAILABLE FEBRUARY.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 12 BLK 1 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5513' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`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` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101409' WHERE `Matrix_Unique_ID` = '210076634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T08:03:28.507' ,`MLSNumber` = '19655089' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150505' ,`Longitude` = '-95.616343' ,`PhotoCount` = '5' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Barn Owl' ,`StreetNumber` = '10115' ,`StreetSuffix` = 'Trail' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2 ½ Baths, Formal Dining, Primary Downstairs, Game Room Up, Wrought Iron Stair Rails, Open Concept Kitchen/Breakfast Combo, Kitchen Island, Primary Bath with Separate Tub and Shower and Dual Sinks, Luxury Vinyl Plank Floors in Entry, Kitchen/Breakfast Area, Family Room, Hallway and all Wet Areas, Granite Kitchen Countertops, Herringbone Kitchen Tile Backsplash, Undermount Stainless Steel Single Bowl Sink with Pullout Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets, Upgraded Lighting and Trim Packages, 2\" Blinds, Covered Rear Patio, Tech Shield Radiant Barrier, ENERGY STAR Certified Home, plus more…AVAILABLE FEBRUARY.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 15 BLK 3 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5553' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`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` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101410' WHERE `Matrix_Unique_ID` = '211163350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T08:01:53.367' ,`MLSNumber` = '83884806' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152192' ,`Longitude` = '-95.616665' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Red Snapper' ,`StreetNumber` = '10127' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1674' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, High Ceilings, Open Concept Kitchen/Family, Dining, Study, Primary Bath with Separate Shower and Tub with Dual Sinks, Luxury Vinyl Plank Floors in Entry, Study, Dining Room, Kitchen, Family Room and all Wet Areas, Granite Kitchen Countertops with Island, Herringbone Kitchen Backsplash, Undermount Stainless Steel Sink with Pullout Faucet, Upgraded Stainless Steel Appliances with Microwave, 42\" Upper Kitchen Cabinets, Upgraded Lighting, Trim and Plumbing Package, 2\" Window Blinds, Covered Rear Patio, Tech Shield Radiant Barrier, ENERGY STAR Certified Home, plus more…AVAILABLE JANUARY/FEBRUARY.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 37 BLK 1 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5421' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`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` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101410' WHERE `Matrix_Unique_ID` = '211163949' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T08:02:56.480' ,`MLSNumber` = '39606161' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150294' ,`Longitude` = '-95.615409' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Red Snapper' ,`StreetNumber` = '10113' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 3 Bedroom, 2 1/2 Baths, Formal Dining, Primary Downstairs, Game Room Up, Wrought Iron Stair Rails, Open Concept Kitchen/Breakfast Combo, Primary Bath with Separate Shower and Tub with Dual Sinks, Luxury Vinyl Plank Floors in Entry, Kitchen/Breakfast, Dining, Family Room and all Wet Areas, Kitchen Island, Granite Kitchen Countertops, 3” x 12” Herringbone Kitchen Tile Backsplash, Undermount Stainless Steel Single Bowl Sink with Pullout Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets, Upgraded Lighting, Trim and Plumbing Packages, 2\" Blinds, Covered Rear Patio, Tech Shield Radiant Barrier, ENERGY STAR Certified Home, plus more…AVAILABLE JANUARY/FEBRUARY.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 34 BLK 1 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`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` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101410' WHERE `Matrix_Unique_ID` = '211164399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T08:36:56.263' ,`MLSNumber` = '26364226' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.638922' ,`Longitude` = '-95.766125' ,`PhotoCount` = '24' ,`PostalCode` = '77406' ,`RoomCount` = '13' ,`ListPrice` = '468990.00' ,`Status` = 'Active' ,`StreetName` = 'Star Jasmine' ,`StreetNumber` = '3210' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2883' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Model Home, Now For Sale! Big Cul-de-Sac Yard, 4 Bedrooms, 3 1/2 Baths, Primary Bed Down, Media and Game Rooms Up, Study, Dining, Tile in Entry, Family Room, Kitchen/Breakfast, Utility and all Bathrooms, Hardwood Flooring in Study and Dining Room, Wrought Iron Stair Rails, Fireplace with Cast Stone Surround, Decorator Paint and Trim with Custom Window Coverings, Granite Countertops in Kitchen and all Full Bathrooms, Mahogany Front Door, Stainless Steel Appliances including Refrigerator, Upgraded Landscaping, Flooring and Backsplashes, Stone Accented Elevation, Covered Front and Back Patios...AVAILABLE NOW!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 54 BLK 1 SEC 2R' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'McCrary Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101410' WHERE `Matrix_Unique_ID` = '211366450' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T07:57:18.000' ,`MLSNumber` = '69006448' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153060' ,`Longitude` = '-95.615817' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '278990.00' ,`Status` = 'Active' ,`StreetName` = 'Grey Fox' ,`StreetNumber` = '27314' ,`StreetSuffix` = 'Run' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1624' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Pocket Office, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Luxury Vinyl Plank Floors in Pocket Office, Dining Room, Kitchen, Family Room and all Wet Areas, Granite Kitchen Countertops, 3”x12” Herringbone Kitchen Backsplash, Undermount Stainless Steel Single Bowl Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42\" Upper Kitchen Cabinets, Upgraded Lighting and Trim Packages, 2\" Window Blinds, Covered Rear Patio, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE JANUARY/FEBRUARY.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 12 BLK 2 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`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` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101411' WHERE `Matrix_Unique_ID` = '211422765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T08:23:57.423' ,`MLSNumber` = '86116239' ,`ListAgentFullName` = 'Sionny Currence' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984519' ,`Longitude` = '-95.147460' ,`PhotoCount` = '31' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Lure' ,`StreetNumber` = '8511' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2597' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful house is a MUST SEE It\'s located on the 17th hole on the private Walden Country Club. 5 Mins to 1960 and 15 mins to beltway, This gorgeous property has a 1 Year old roof, AC is still under warranty and all Bedrooms are downstairs and a massive game room upstairs, you will love the beautiful view of the fairway and a relaxing walk to the lake Houston. Seller is willing to sell their pool table upstairs.' ,`Acres` = '0.2025' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 32 CHAMPIONS VILLAGE WALDEN ON LAKE HOUSTON PH 5' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '8823' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden/Lake Houston Champions' ,`TaxAmount` = '6836' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101411' WHERE `Matrix_Unique_ID` = '212169373' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T07:58:07.827' ,`MLSNumber` = '42437800' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153060' ,`Longitude` = '-95.615817' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Barn Owl' ,`StreetNumber` = '10102' ,`StreetSuffix` = 'Trail' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1624' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Pocket Office, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Luxury Vinyl Plank Floors in Pocket Office, Dining Room, Kitchen, Family Room and all Wet Areas, Granite Kitchen Countertops with Island, 4”x16” Subway Tile Kitchen Backsplash, Undermount Single Bowl Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42\" Upper Kitchen Cabinets, Upgraded Lighting and Trim Packages, 2\" Window Blinds, Covered Rear Patio, Large Corner Homesite, Tech Shield Radiant Barrier, ENERGY STAR Certified Home, plus more…AVAILABLE JANUARY/FEBRUARY.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 32 BLK 1 SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5626' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`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` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101411' WHERE `Matrix_Unique_ID` = '212358590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T08:03:12.003' ,`MLSNumber` = '22457217' ,`ListAgentFullName` = 'Lucia Vazquez-Jimenez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080819' ,`Longitude` = '-95.561386' ,`PhotoCount` = '13' ,`PostalCode` = '77375' ,`RoomCount` = '8' ,`ListPrice` = '346990.00' ,`Status` = 'Active' ,`StreetName` = 'Little Blue Stem' ,`StreetNumber` = '22714' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home! Home features inviting front porch, study, big kitchen for perfect for entertaining and family room large and open; large primary bath; master bath features separate shower and tub; large closet with lots of storage; large flex room that can be used for many purposes (playroom, den, extra office or more); covered back porch; sprinkler system; 2 1/2 garage for extra storage. No back neighbors. Close to 99, shopping and entertaining. Highly acclaimed Klein ISD!!' ,`Acres` = '0.1578' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 WILDWOOD GLEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '764' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wildwood Glen Sec 1' ,`TaxAmount` = '7628' ,`TaxRate` = '2.8765' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101411' WHERE `Matrix_Unique_ID` = '212858189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T08:31:01.217' ,`MLSNumber` = '74999315' ,`ListAgentFullName` = 'Brandon Gorman' ,`ListOfficeName` = 'Virginia Malone Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772925' ,`Longitude` = '-94.924645' ,`PhotoCount` = '39' ,`PostalCode` = '77521' ,`RoomCount` = '10' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn' ,`StreetNumber` = '3601' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely Stunning one story home in Whispering Pines in need of a new caretaker. This home offers a flowing floorplan with tons of amenities and features. Designer Hardwoods and tile throughout, this home has no carpet. Custom built-ins and entertainment center in family room with fireplace and recessed ceiling. Master bedroom is nice, but the master bath offers heated flooring, open shower to add to the luxury of this home. The fireplace in the family room currently offers a remote gas logs for cold winter nights or just ambiance. Beautiful kitchen with granite countertops and a bar with a sonic style ice maker. The house is also equipped with a new emergency natural gas generator that runs the whole house. The utility room offers a small sink and is equipped with connections for a gas or electric dryer. The 3 car garage is a great space for storage or mancave. This house has been completely rebuilt after hurricane Harvey.' ,`Acres` = '0.2587' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 45 WHISPERING PINES SEC 1 R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '11269' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Whispering Pines Sec 01 R/P' ,`TaxAmount` = '3759' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101411' WHERE `Matrix_Unique_ID` = '214279717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T07:55:59.880' ,`MLSNumber` = '38495811' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153019' ,`Longitude` = '-95.616449' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '259990.00' ,`Status` = 'Active' ,`StreetName` = 'Whooping Crane' ,`StreetNumber` = '10117' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Pocket Office, Open Concept Kitchen/Dining Combo, High Ceilings, Dual Vanities in Primary Bath, 3 Sides Brick, Granite Kitchen Countertops with Island, 3”x12” Kitchen Tile Backsplash with Herringbone Design, Undermount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, Recessed Lighting in the Kitchen, 2\" Window Blinds, Garage Door Opener, Covered Rear Patio, Tech Shield Radiant Barrier, Environments for Living Home, plus more…Ready for Immediate Move-In!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 1 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4866' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101412' WHERE `Matrix_Unique_ID` = '214787318' --> 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','215556085','1675101412','215556085','2023-01-04T08:01:12.713','56725931','Joe Rothchild','Keller Williams Signature','','','30.153231','-95.616541','6','77354','11','332990.00','Active','Crevalle Jack','27221','Lane','Magnolia','2','1','4','2387','Single-Family','2 Story, 4 Bedroom, 2 ½ Baths, Primary Downstairs, Game Room Up, Wrought Iron Staircase, Open Concept Kitchen/Dining Combo, Separate Shower, Spa Tub and Dual Vanities in Primary Bath, Luxury Vinyl Plank Floors in Entry, Dining/Kitchen Area, Family Room, Hallway and all Wet Areas, Granite Kitchen Countertops, Sit Down Breakfast Bar Countertop Level, 3”x6” Herringbone Design Kitchen Tile Backsplash, Undermount Stainless Steel Single Bowl Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets, Upgraded Lighting and Trim Packages, 2\" Window Blinds, Extended Covered Rear Patio, 4 Sides Brick Exterior, Full Length Lead Glass Stained Wood Door, Tech Shield Radiant Barrier, Environments for Living Home, plus more… AVAILABLE JANUARY/FEBRUARY.','','15','Devon Street Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Magnolia/1488 East','Central Gas','1','LOT 19 BLK 1 SEC 2','Subdivision Lot','5388','Appraisal District','','450','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','No Appointment Required','Builder','2','Traditional','Mill Creek Trails','','3.1087','Other Water/Sewer','2022','Builder'); --> 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','215737909','1675101412','215737909','2023-01-04T07:59:58.943','71879320','Joe Rothchild','Keller Williams Signature','','','30.153230','-95.617588','6','77354','8','299990.00','Active','Barn Owl','10134','Trail','Magnolia','2','0','3','1759','Single-Family','1 Story, 3 Bedroom, 2 Bath, Pocket Office, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Dual Closets in the Primary Bedroom, Wood Like Tile Floors in Pocket Office, Dining Room, Kitchen, Family Room, Hallway and all Wet Areas, Large Kitchen Island, Quartz Kitchen Countertops, Herringbone Kitchen Backsplash, Undermount Stainless Steel Single Bowl Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42\" Upper Kitchen Cabinets, Cabinet Hardware, Under Cabinet Lighting, Recessed Can Lighting, Upgraded Lighting and Trim Packages, Covered Rear Patio, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE JANUARY/FEBRUARY.','','15','Devon Street Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Magnolia/1488 East','Central Gas','1','LOT 24 BLK 1 SEC 2','Subdivision Lot','6302','Appraisal District','','450','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Mill Creek Trails','','3.1087','Other Water/Sewer','2022','Builder'); --> 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','215848406','1675101412','215848406','2023-01-04T08:51:40.633','17227741','Erica Wright','RE/MAX One','','','30.684524','-94.395286','23','75979','8','150000.00','Active','Ivanhoe','200','Drive','Woodville','1','1','3','1256','Single-Family','Welcome to Ivanhoe! Land of the Lakes! This 3 bedroom, 1.5 bath brick home sits right inside the entrance of this lovely lake community boasting 5 lakes. It\'s got a nice size fenced in back yard and on blacktop road. The home is just waiting for your loving touch and updates. It\'s got a great layout and the perfect location with easy access to Hwy 69. The current owner has even had it approved for commercial use if you\'d like to go that direction. Bring your fishing poles or business ideas! This property has so much potential to be your little slice of lake paradise or new business venture!','0.32','48','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','Tyler County','Central Electric','0','LAKE IVANHOE SEC 1 (A720), BLOCK 6, LOT 1 & 2','Cleared,Corner','32','Appraisal District','','','0','','0','','0','','','','','Composition','253 - Woodville','WHEAT ELEMENTARY SCHOOL','WOODVILLE HIGH SCHOOL','WOODVILLE MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Ranch','LAKE IVANHOE','','','Septic Tank','1970','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','215962574','1675101412','215962574','2023-01-04T08:56:42.967','92405556','Margaret Lindow','Keller Williams SoutheastTexas','','','29.475774','-94.581383','38','77650','10','975000.00','Active','Prides','3284','Way','Crystal Beach','3','0','5','2154','Single-Family','Gorgeous 2nd row home with protected views. This charming 5bd/3ba is a must see with its beautiful views, artistic décor, and thoughtful design! This beautiful family beach cottage comfortably accommodates 18 and is also a popular rental called “The Blue Bell”. Your family, guests, or renters will love the fantastic views, all wood floors, a second living space upstairs, claw foot tub, cozy fireplaces, built in bunk rooms, wood ship lap walls, outdoor living spaces, and many other creative features. This home has been updated and furnished with attention to detail, quality bedding, and kitchen supplies that allow for relaxation and large gatherings. The home will sell furnished with a few exclusions. One step on the porch and you will want this to be your forever beach house!','','33','','','Electric Dryer Connections,Washer Connections','','Exclusions,Other Disclosures','1','Freestanding,Mock Fireplace','1','Crystal Beach','Central Electric','0','LEGAL: ABST 65 B FRANKS SUR LOT 7 BLK 2 LAFITTES LANDING','Cleared,Subdivision Lot,Water View','9060','Appraisal District','','','0','','0','Electric Oven','0','','','Freestanding Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','2','Mediterranean,Traditional','Laffittes Landing','','','Other Water/Sewer','2011','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','215990935','1675101412','215990935','2023-01-04T08:15:40.530','66672208','Jamie Hornbuckle','All City Real Estate, Ltd. Co.','','','29.915623','-98.085270','34','78666','4','934500.00','Active','Cascade','900','Trail','San Marcos','3','0','4','2667','Single-Family','WELCOME HOME to your Hill Country Retreat! \r\nNestled among the trees on 5 acres in the quiet, horse-friendly subdivision of Summer Mountain Ranch, this spacious 4 bedroom home has everything you\'re looking for – designer remodel, open plan, split bedrooms, location, & privacy. Make sure to see the video walkthrough! Meticulously maintained, this home is turnkey for your new chapter. Located 10 minutes from Wimberley & San Marcos, and close to many Hill Country attractions. Within an hour of 2 international airports in Austin & San Antonio. Gourmet kitchen, spacious master with sitting area, 2nd bedroom has an ensuite and could be used as a 2nd master. Outdoor amenities include a large back deck, hot tub, dog run, garden, circular driveway, extra parking, and storage shed. Updates include new flooring and baseboards throughout, shiplap accent walls, landscaping and lighting in front/back, graded driveway, painted gutters, HVAC, & water heater. Can apply for Wimberley ISD placement.','5','83','','','','','Other Disclosures,Sellers Disclosure','','','','','Central Electric','1','SUMMER MOUNTAIN RANCH SEC 1, LOT 82, ACRES 5','Other','217800','Appraisal District','','107','0','','2','','0','','','','','Aluminum','214 - San Marcos Consolidated','HERNANDEZ ELEMENTARY SCHOOL','SAN MARCOS HIGH SCHOOL','MILLER JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Ranch','Summer Mountain Ranch','8030','1.6083','Aerobic,Well','1998','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','216036052','1675101412','216036052','2023-01-04T07:57:22.290','25719682','Walter Cole','Coldwell Banker Realty','','','29.936639','-95.228916','22','77396','8','254900.00','Active','Harbor Canyon','10534','Drive','Humble','2','0','3','1560','Single-Family','Bring your most discriminating buyers, this home is in incredible move in condition with fresh interior paint and new carpet. As you enter the tiled entryway you will transition to the family room featuring beautiful wood flooring and archways leading into the kitchen. The cook in the family will enjoy the electric range, built in microwave, dishwasher and double stainless steel sink. Entertaining is outstanding in this home with the kitchen open to the living room and a breakfast bar perfect for kids and family. The bedrooms in this home are split for owner privacy. For energy efficency each bedroom and the living room have ceiling fans and there is a programable thermostate. The third bedroom as well as hallway between beds 2 and 3 also has wood flooring. In the living room you will appreciate the touch button gas start fireplace with gas logs and wood flooring. All windows have 2\" blinds and the carpet in the master and bedroom 2 is new. Outside you will enjoy a rear fenced yard.','0.1102','1','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding,Gas Connections,Gaslog Fireplace','1','Humble Area East','Central Gas','1','LT 46 BLK 4 SUNSET RIDGE WEST SEC 3','Subdivision Lot','4801','Appraisal District','','350','0','','2','Electric Oven','0','','','Electric Range','','Composition','29 - Humble','AUTUMN CREEK ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Sunset Rdg West Sec 03','6180','3.0673','Public Sewer,Public Water','2008','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','216043550','1675101412','216043550','2023-01-04T07:47:31.630','58304044','Darby Grimmett','Compass RE Texas, LLC Heights','','','29.749580','-95.488365','44','77057','9','750000.00','Active','San Felipe','6017','Street','Houston','3','1','4','3197','Single-Family','Incredible opportunity to own a true contemporary masterpiece in a prime location. This home is perfect for entertaining w/ first floor social areas & sliding glass patio doors that open fully, leading to the covered patio w/ deck, custom outdoor kitchen & peacefully landscaped yard. Gorgeous kitchen w/ high end appliances & marble countertops. Large master bedroom w/private balcony & two secondary bedrooms & bath on 2nd floor. Huge third floor en suite bedroom.','','22','Built By Habitat','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Galleria','Central Gas','0','LT 2 BLK 1 WESTHAVEN ESTATES SEC 2 2ND PAR R/P AMEND','Other','3600','Appraisal District','','0','0','','2','Convection Oven','0','','','Gas Cooktop','','Composition','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal','3','Contemporary/Modern','Westhaven Estates Sec 2 Pt R','18725','2.3307','Public Sewer,Public Water','2016','Builder'); --> 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','216044169','1675101412','216044169','2023-01-04T08:28:58.963','28572079','Joe Rothchild','Keller Williams Signature','','','30.151693','-95.616135','6','77354','11','304990.00','Active','Barn Owl','10127','Trail','Magnolia','3','1','4','2181','Single-Family','2 Story, 4 Bedroom, 3.5 Baths, all Bedrooms Up, 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, Mosaic Tile Kitchen Backsplash, Undermount Stainless Steel Single Bowl Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets, Upgraded Lighting and Trim Packages, Extended Covered Rear Patio, Window Blinds, Tech Shield Radiant Barrier, Environments for Living Home, plus more...AVAILABLE NOW!','','15','Devon Street Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Magnolia/1488 East','Central Gas','1','LOT 12 BLK 3 SEC 2','Subdivision Lot','5508','Appraisal District','','450','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','No Appointment Required','Builder','2','Traditional','Mill Creek Trails','','3.1087','Other Water/Sewer','2022','Builder'); --> New record created successfully