Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:31:00.280' ,`MLSNumber` = '10540397' ,`ListAgentFullName` = 'Traci Crawford' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877814' ,`Longitude` = '-94.707199' ,`PhotoCount` = '46' ,`PostalCode` = '77597' ,`RoomCount` = '3' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Charlotte' ,`StreetNumber` = '724' ,`StreetSuffix` = 'Road' ,`City` = 'Wallisville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 5 acre beauty is looking for new owners! Gated access to front of home with 2 long driveways lead you to the front porch with double french front doors. Inside you will find a sitting area with fireplace, study/office, leading into kitchen area with eat-in kitchen, and additional living room/den. There are 2 secondary bedrooms with built-ins, full bathroom, and large primary bedroom with doors leading out to patio. Outside is a covered patio, large carport, and plenty of room in the front and backyard. Call to schedule your showing today!' ,`Acres` = '5.023' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '17 TR 11B-0 J MCFADDIN' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '218802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'MCFADDIN' ,`TaxAmount` = '7240' ,`TaxRate` = '2.8113' ,`WaterSewer` = 'Public Sewer,Septic Tank' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704469' WHERE `Matrix_Unique_ID` = '201278354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:30:47.270' ,`MLSNumber` = '58629782' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Shelly Mattingly-Arnold' ,`SellingOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`Latitude` = '30.534015' ,`Longitude` = '-95.509101' ,`PhotoCount` = '6' ,`PostalCode` = '77358' ,`RoomCount` = '6' ,`ListPrice` = '454835.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Leila' ,`StreetNumber` = '109' ,`StreetSuffix` = 'Lane' ,`City` = 'New Waverly' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2464' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS NEW D. R. HORTON BUILT 1 STORY! EXPANSIVE 1 ACRE LOT! 3 CAR GARAGE! Versatile Interior Layout with Home Office/Study/4th Bedroom! Espresso Kitchen Cabinetry, Spacious Family Room with Picture Windows Overlooking the Backyard Oasis, Double Pane Low-E Vinyl Windows, & LED Lighting! Lovely Formal Dining AND Light & Bright Breakfast Area! Gourmet Island Kitchen - Open to Family Room! Privately Located Primary Suite Features Garden Bath with Separate Tub & Shower, Dual Sinks, & Big Walk-In Closet! Home Office/Study/4th Bdrm with Handy Storage Closet! Subdivision is Deed Restricted, but RVs & Horses Allowed! Beautiful Soaring Trees Galore! Easy Access to National Park & Lake Conroe! SUPER LOW TAX RATE! MUST SEE! Estimated Completion - May/June 2022.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'New Waverly Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WAVERLY PLACE - SEC 1, BLOCK 2, LOT 12' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '43561' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waverly Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704470' WHERE `Matrix_Unique_ID` = '205160902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:36:47.870' ,`MLSNumber` = '21875131' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990713' ,`Longitude` = '-95.436652' ,`PhotoCount` = '24' ,`PostalCode` = '77090' ,`RoomCount` = '5' ,`ListPrice` = '234900.00' ,`Status` = 'Active' ,`StreetName` = 'Darbydale Crossing' ,`StreetNumber` = '819' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0929' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 DARBYDALE CROSSING SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '4045' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Darbydale Xing Sec 1' ,`TaxAmount` = '4069' ,`TaxRate` = '2.5867' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704470' WHERE `Matrix_Unique_ID` = '205633658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:27:22.980' ,`MLSNumber` = '54868451' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654261' ,`Longitude` = '-95.052639' ,`PhotoCount` = '34' ,`PostalCode` = '77571' ,`RoomCount` = '10' ,`ListPrice` = '414793.00' ,`Status` = 'Active' ,`StreetName` = 'Bishop Lagoon' ,`StreetNumber` = '2391' ,`StreetSuffix` = 'Way' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2348' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 54868451 ~ REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, Ready January ~ The Jasmine! This two-story beautiful Jasmine floor plan features a welcoming front porch, entry foyer and a flex room at the front of the home. The foyer opens to a sunny kitchen, dining area and gathering room. Perfect for entertaining family and friends! The owner\'s suite is positioned at the back of the home for peace and serenity with the lovely owner\'s bath and walk-in closet! Upstairs has a game room, three bedrooms and a shared bathroom. Structural options added to 2391 Bishop Lagoon Way include: 4th bedroom with bath 2, 8\' front & rear doors, open rails, full gutters, arches package, and covered outdoor living.' ,`Acres` = '0.147' ,`Area` = '7' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric,Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8, Block 1 of Morgan\'s Landing section 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing 45s' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704470' WHERE `Matrix_Unique_ID` = '207063874' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:12:26.710' ,`MLSNumber` = '61727160' ,`ListAgentFullName` = 'Yvette Crain' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835459' ,`Longitude` = '-95.057667' ,`PhotoCount` = '24' ,`PostalCode` = '77562' ,`RoomCount` = '6' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Main' ,`StreetNumber` = '1501' ,`StreetSuffix` = 'Street' ,`City` = 'Highlands' ,`BathsFull` = '9' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '10401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3.5 acres, 10,000 square foot home, fully equipped pool house and much more luxury upgrades! Newly renovated and about 75% to completion. Very versatile property and really a MUST SEE!' ,`Acres` = '3.5222' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 60A-1 ELENA FRUIT & COTTON FARMS A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '153427' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Elena Fruit & Cotton Farms A' ,`TaxAmount` = '14874' ,`TaxRate` = '2.235' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704470' WHERE `Matrix_Unique_ID` = '207483515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:12:40.047' ,`MLSNumber` = '43830664' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.914485' ,`Longitude` = '-95.759011' ,`PhotoCount` = '32' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '824950.00' ,`Status` = 'Active' ,`StreetName` = 'Bossley Park' ,`StreetNumber` = '9207' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 43830664 ~REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, Ready November! The Calypso floor plan design presents a beautiful option for those looking for a home that is as sophisticated as it is practical. A soaring 2 story ceiling fills the gathering room with sunshine, adding to its inviting appeal. There are 2 islands: one for prep and another for sit-down snacking or setting out a buffet spread. Located at the rear of the house for privacy, the upgraded extended owner’s suite and bath are similar to what you find in a lavish custom home. Multi-generational suite with den on the first floor features a private bath with dual sinks and walk-in shower. 3 other bedrooms and 2 baths are located upstairs and all include walk-in closets and private vanities. Upstairs is a fun retreat with a game room and media room. Structural options added include: 5th bed, 4th bath, multi generation suite, extended covered patio, extended owner\'s suite, fireplace.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Block 2 of Avalon at Cypress Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`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` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon at Cypress 70\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704470' WHERE `Matrix_Unique_ID` = '208128856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:06:35.750' ,`MLSNumber` = '75989460' ,`ListAgentFullName` = 'Wendy Riffe' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.144870' ,`Longitude` = '-94.190927' ,`PhotoCount` = '28' ,`PostalCode` = '77708' ,`RoomCount` = '7' ,`ListPrice` = '689000.00' ,`Status` = 'Active' ,`StreetName` = 'Major' ,`StreetNumber` = '7415' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4539' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous 6/3.5/3 new construction with sweeping views of the park. The home boast of many imported upgrades, custom features & superior craftsmanship, open floor plan with (2) two fireplaces. The home offers inviting tile in the foyer, open concept living with tile & waterproof wood flooring throughout, energy-efficient double pane vinyl windows, trey ceilings with crown, a gourmet kitchen with w/granite counters, custom cabinetry, walk-in pantry, energy-efficient stainless gas appliances, custom designer interior paint colors, brilliant light fixtures, wired for security system, extra concrete padding, sidewalks, huge, covered patio/ entertainment offers a gorgeous fireplace with granite mantle, outdoor kitchen, imported stone brick. More pictures & virtual tour coming soon' ,`Acres` = '0.2755' ,`Area` = '51' ,`BuilderName` = 'See Agent' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BEAU TERR L 27 - 30 B 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'GUESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beau Terrace' ,`TaxAmount` = '62' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663704470' WHERE `Matrix_Unique_ID` = '208328045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:44:18.667' ,`MLSNumber` = '61713482' ,`ListAgentFullName` = 'Joseph Campbell' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151847' ,`Longitude` = '-96.397442' ,`PhotoCount` = '43' ,`PostalCode` = '77833' ,`RoomCount` = '5' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Day' ,`StreetNumber` = '1802' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in a very busy commercial area on Business 36. Zoned for both residential and commercial.\r\n\r\nOwner is highly motivated to sell. All reasonable offers will be considered. \r\n\r\nThis is a 1322 sq/ft property with 3 bedrooms and one bath. Kitchen area is extremely spacious at 16x23, which also includes a 12ft island. Oven, Range, telescoping vent, and a Brand-New dishwasher are all included. \r\n\r\nLarge front yard, with an extremely large back yard. All Plumbing, Electrical, and sheetrock was recently replaced with crown molding throughout the house. Two car garage, which was made into an office. There are also, four large pecan trees on the property.' ,`Acres` = '0.3131' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'AMAL HEIGHTS, BLOCK 2, LOT 4' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '13640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amal Heights' ,`TaxAmount` = '2375' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704470' WHERE `Matrix_Unique_ID` = '209010865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:34:57.317' ,`MLSNumber` = '85828705' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.165027' ,`Longitude` = '-95.472606' ,`PhotoCount` = '13' ,`PostalCode` = '77380' ,`RoomCount` = '10' ,`ListPrice` = '1672381.00' ,`Status` = 'Active' ,`StreetName` = 'Vue Point' ,`StreetNumber` = '168' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#85828705 ~ REPRESENTATIVE PHOTOS ADDED! Ready February! This free-standing 4-story home features a mud room, guest suite, and covered patio w/ an outdoor fireplace on the 1st floor. Take the elevator to the 2nd floor to the impressive main living areas w/ 11\' ceilings. The kitchen, dining area, and large great room are also on the 2nd level. A guest suite and owner\'s suite are on the 3rd level and include convenient utility room access. Level 4 features a 4th guest suite w/ a wet bar and generous storage. Step through the sliding glass doors outside onto the spacious covered terrace w/ an outdoor fireplace and entertain in style! Structural options added include: Elevator to all floors, 2nd-floor version 2.2, 4th-floor version 4.2, fireplaces in the family room, 1st-floor outdoor living and 4th-floor terrace, standing showers at baths 2, 3, and 4, 9\' 3-panel sliding door to 1st-floor outdoor living, 12\' 3-panel sliding door to 4th-floor terrace and wet bar and 4th guest suite.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Darling Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Mock Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS LAKE WOODLANDS EAST SHORE 20, BLOCK 1, LOT 35' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2344' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '5300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'VUE at East Shore' ,`TaxAmount` = '' ,`TaxRate` = '2.19' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704471' WHERE `Matrix_Unique_ID` = '209053782' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:31:16.817' ,`MLSNumber` = '70429800' ,`ListAgentFullName` = 'Tammy Locke' ,`ListOfficeName` = 'Texas Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892505' ,`Longitude` = '-94.795138' ,`PhotoCount` = '16' ,`PostalCode` = '77535' ,`RoomCount` = '9' ,`ListPrice` = '169900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 4013' ,`StreetNumber` = '252' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two Story Country Charmer with covered porch offers 4 bedrooms with possible 5th bedroom. Large family room and formal dining offer great spaces for entertaining. Property is a little over an acre with public water and septic. 20x30 Workshop available as well. Bring your vision and make this your dream home.' ,`Acres` = '1.12' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OAK MEADOWS, LOT 12, SEC 3, ACRES 1.12' ,`LotDesciption` = 'Cleared' ,`LotSize` = '48787' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Meadows' ,`TaxAmount` = '2945' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704471' WHERE `Matrix_Unique_ID` = '209200066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:57:00.500' ,`MLSNumber` = '31598438' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000044' ,`Longitude` = '-95.464602' ,`PhotoCount` = '19' ,`PostalCode` = '77014' ,`RoomCount` = '6' ,`ListPrice` = '234900.00' ,`Status` = 'Active' ,`StreetName` = 'Bammelwood' ,`StreetNumber` = '2542' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0898' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 BAMMEL VILLAGE SEC 02 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '3913' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MAJOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bammel Village Sec 02 Rep 01' ,`TaxAmount` = '4712' ,`TaxRate` = '2.8192' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704471' WHERE `Matrix_Unique_ID` = '209283896' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:05:01.653' ,`MLSNumber` = '2253883' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Robert Almogabar' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.061746' ,`Longitude` = '-95.720553' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '359445.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Shetland Valley' ,`StreetNumber` = '20822' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy your own slice of paradise in this beautiful Beazer Home in Amira, boasting a brick façade, tile flooring, sprinkler system, open great room, and an extended covered patio. Entertain guests in the quartz countertops, mosaic backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are a part of the top-rated Tomball ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704471' WHERE `Matrix_Unique_ID` = '209380702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:39:17.453' ,`MLSNumber` = '22291512' ,`ListAgentFullName` = 'Russell Hubenak' ,`ListOfficeName` = 'Hudgins-Groover Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.308575' ,`Longitude` = '-95.973889' ,`PhotoCount` = '31' ,`PostalCode` = '77488' ,`RoomCount` = '6' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 107' ,`StreetNumber` = '1423' ,`StreetSuffix` = '' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, completely remodeled 3/2/2 home with 2 acres in the country located in Boling ISD. The kitchen features all new appliances, a huge granite top island with built in microwave and trash bin and lots of cabinet storage space. Luxury Vinyl Plank (LVP) waterproof flooring is installed throughout the home. The roof along with almost everything else is brand new! The pond out back is also new and features a sand beach, fountain and a plastic liner with clean washed sand on top so you don\'t get mud on your feet! The pier is solidly constructed with a steel base and treated lumber decking. Facing west, the pier is an excellent spot to relax and enjoy the sunsets! The main well is approximately 700\' deep with very clean water. The backyard is set up nicely for parties and family functions. The main breaker box is setup to allow plug in of a generator for power outages and has 3, 50 amp plugs for RV plug in. Make your showing appointment today, this is a rare find!' ,`Acres` = '2' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'A20050 ABST.50 TRACT 11A-2, 11A-3' ,`LotDesciption` = 'Other' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '140 - Boling' ,`SchoolElementary` = 'NEWGULF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOLING HIGH SCHOOL' ,`SchoolMiddle` = 'IAGO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2351' ,`TaxRate` = '1.6468' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704471' WHERE `Matrix_Unique_ID` = '209440258' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:02:36.047' ,`MLSNumber` = '39827285' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405858' ,`Longitude` = '-95.051605' ,`PhotoCount` = '7' ,`PostalCode` = '77568' ,`RoomCount` = '12' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayrose' ,`StreetNumber` = '2514' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ideal for families who love to make the most of time spent at home. The 2,811 sq.ft. Caledon floor plan is loaded with features that make home the ultimate destination. From an upper-level game room to a dedicated dining area and covered patio outdoors. The kitchen is the heart of the Caledon floor plan featuring a functional layout that maximizes storage space with a large island and additional pantry space added in the utility room. Homeowners can relax and recharge in the spacious owner’s retreat, which includes a huge walk-in closet and spa- like ensuite. This floor plan also comes with a private study located on the first floor.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Block 2, Section 2' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704471' WHERE `Matrix_Unique_ID` = '209473866' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:01:15.333' ,`MLSNumber` = '83292865' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.407248' ,`Longitude` = '-95.052739' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '13' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Edge' ,`StreetNumber` = '2506' ,`StreetSuffix` = 'Crossing' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Our Collingwood has become one of our most popular floor plans, offering an open-concept living space with everything you need. This home boasts an open-air study, 18\' ceilings in the kitchen, an oversized kitchen island, a Texas-sized patio, and plenty of windows to fill the home with natural light. This home sits inside the gated section of the community and is waiting for a family to call it home in Lago Mar, the home of the largest Crystal Lagoon in Texas featuring water sports, dining, and exclusive members-only beaches.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24, Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704471' WHERE `Matrix_Unique_ID` = '209669576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:03:08.010' ,`MLSNumber` = '13375817' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406029' ,`Longitude` = '-95.051345' ,`PhotoCount` = '7' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '456000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayrose' ,`StreetNumber` = '2522' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fabulous Kingston floor plan is a 3 bedroom, 2 baths, single-story home that boasts a large open great room area with 11- foot ceilings and an extended covered back patio! The kitchen includes an oversized island looking into the living room, and a sizeable pantry for additional storage needs. The owner\'s retreat features a double-door entry into the ensuite bathroom, complete with a deep-soaking tub and separate stand-up shower with a spacious walk-in closet. Don\'t wait to seize your opportunity to own this perfect mid-sized ranch-style home in Lago Mar, the home of the largest Crystal Lagoon in Texas featuring water sports, dining, and exclusive members-only beaches.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 2, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704471' WHERE `Matrix_Unique_ID` = '209673260' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:05:10.840' ,`MLSNumber` = '61664718' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408028' ,`Longitude` = '-95.051543' ,`PhotoCount` = '7' ,`PostalCode` = '77568' ,`RoomCount` = '10' ,`ListPrice` = '426000.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Key' ,`StreetNumber` = '2703' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Kelowna floor plan is a 3/4 bedroom with optional study space, 3 bath home that’s spacious and functional, with an open concept kitchen and great room with an eat in island, dedicated dining room, and sizable owner’s retreat complete with a large walk-in closet and spa-like ensuite with double sinks. A walk-in kitchen pantry, spacious utility room, and covered patio are the additional spaces buyer’s appreciate.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 11 BLK 5 LAGO MAR POD 6 SEC 2 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704472' WHERE `Matrix_Unique_ID` = '209746681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:52:41.267' ,`MLSNumber` = '65833912' ,`ListAgentFullName` = 'Steven Franco' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.052283' ,`Longitude` = '-94.098399' ,`PhotoCount` = '23' ,`PostalCode` = '77705' ,`RoomCount` = '6' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'Elgie' ,`StreetNumber` = '1445' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Superb FULLY UPDATED Home in Pear Orchard! This 2 bed 1 bath with an additional Office/Flex space that has been remodeled with NEW Luxurious Vinyl Plank floor, Beautiful NEW carpeting, brand NEW HVAC system, NEW Appliances, NEW Ceiling fans, NEW Cabinet hardware, NEW Door handles, NEW water heater, NEW back deck, NEWLY painted interior/exterior, spacious bedrooms and updated bathroom make this home move-in ready. Plus Interior Utility room. What are you waiting for? Welcome home and bring your personal touches! Zoned to the prestigious Beaumont ISD.' ,`Acres` = '0.241' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Real Estate Owned' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PEAR ORCHARD L6 B6 PT L7 B6' ,`LotDesciption` = 'Other,Patio Lot' ,`LotSize` = '10500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'PIETZSCH-MACARTHUR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pear Orchard' ,`TaxAmount` = '1294' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704472' WHERE `Matrix_Unique_ID` = '210289126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:39:24.770' ,`MLSNumber` = '57277610' ,`ListAgentFullName` = 'Debbie Hagan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768622' ,`Longitude` = '-95.305498' ,`PhotoCount` = '10' ,`PostalCode` = '77020' ,`RoomCount` = '5' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Rouse' ,`StreetNumber` = '1114' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Calling all Developer\'s, Investor\'s and HGTV Lovers! East of Houston\'s NEXT BIG thing, the East River Project, and with over 6000 Sq Ft of land, 1114 Rouse Street is a Builder\'s dream! Don\'t miss this opportunity! Phase 1 of the East River is currently under construction and is estimated to open in 2023. With 26 acres, Phase 1 is planned to have over 300,00 Sq Ft of office and 100,000 Sq Ft of retail space.\r\n**No showings without an accepted contract. Property to be sold AS IS. Buyer will need to verify all room dimensions.' ,`Acres` = '0.1435' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 5 DENVER ANNEX' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Annex' ,`TaxAmount` = '2882' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704472' WHERE `Matrix_Unique_ID` = '210350865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:38:27.083' ,`MLSNumber` = '79514766' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.136778' ,`Longitude` = '-95.046886' ,`PhotoCount` = '6' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5203' ,`StreetNumber` = '625' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two-story home features a smart layout that uses the available space efficiently. On the first floor is an open concept family room and modern kitchen with a powder room in the foyer. Upstairs are two bedrooms, including an owner’s suite which had a private bathroom and walk-in closet.\r\n\r\nPrices and features may vary and are subject to change. Photos are for illustrative purposes only.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0004 BLK 063 LOT 6018' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12223' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704472' WHERE `Matrix_Unique_ID` = '210385230' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:28:36.983' ,`MLSNumber` = '21348774' ,`ListAgentFullName` = 'Joe Applewhite' ,`ListOfficeName` = 'Prime Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685321' ,`Longitude` = '-95.217386' ,`PhotoCount` = '47' ,`PostalCode` = '77502' ,`RoomCount` = '11' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Oaks' ,`StreetNumber` = '1804' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come See This Beautifully Updated POOL Home. Property Entrance Features A Private, Electric Gated Driveway. Make A Statement To Guests As They Enter The Home Through A Grand Double Lead Glass Door Entrance. The Home Features Beautiful Granite Counter Tops In Large Chef\'s Kitchen And All Bathrooms. This Home\'s Layout Is Perfect For Entertaining And Gatherings As It Has Plenty Of Room For Everybody And Wonderful Open Concept Living. Awesome, Extra Large Yard WITH Fenced Pool Is Perfect For Those Hot Summer Days And Covered Patio Makes It The Ideal Hangout. This Home Is Very Roomy With 6 Large Bedrooms And 4 Full Bathrooms. Awesome Master Ensuite With Separate Shower And Soaking Tub Makes A Perfect Retreat. Huge Walk In Closets And Storage Throughout. Bonus Income Potential With The Beautiful Converted Garage Apartment, Gives Endless Opportunities. This Home Is A Must See! Have Your Realtor Book A Showing TODAY!' ,`Acres` = '0.4304' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 42 & 43 PASADENA OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'PASADENA HIGH SCHOOL' ,`SchoolMiddle` = 'QUEENS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pasadena Oaks' ,`TaxAmount` = '9705' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704472' WHERE `Matrix_Unique_ID` = '210639751' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:38:01.937' ,`MLSNumber` = '55447005' ,`ListAgentFullName` = 'Jesus Ruiz' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151574' ,`Longitude` = '-95.169706' ,`PhotoCount` = '19' ,`PostalCode` = '77357' ,`RoomCount` = '1' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine' ,`StreetNumber` = '25745' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highly motivated seller for this unrestricted lot. Only 5-6 minutes form Hwy 59, close to 242 and Grand Parkway. Seller has not verified dimensions or utilities; please verify independently. All offers will be considered, make your offer today.' ,`Acres` = '0.5702' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'S783000 - PEACH CREEK PINES, LOT 11, 12' ,`LotDesciption` = 'Corner' ,`LotSize` = '24840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Peach Creek Pines' ,`TaxAmount` = '1460' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704472' WHERE `Matrix_Unique_ID` = '210643645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:28:40.667' ,`MLSNumber` = '18817655' ,`ListAgentFullName` = 'Jill Fouch' ,`ListOfficeName` = 'Moxie Texas Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.679149' ,`Longitude` = '-96.422219' ,`PhotoCount` = '33' ,`PostalCode` = '77807' ,`RoomCount` = '12' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Brisbane Way' ,`StreetNumber` = '2034' ,`StreetSuffix` = '' ,`City` = 'Bryan' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5 bedroom, 3 bath home with a game room has almost 3100 sq ft! It features master suite and 2 bedrooms on the first floor and a game room and 2 bedrooms on second floor. Open floor plan that is great for entertaining friends/family. The kitchen, family, and formal dining room are all wide open to each other featuring tons of lighting, waterproof laminate flooring and a wall of windows viewing the backyard. Kitchen features a large island, stainless appliances, granite counters, designer backsplash, a walk-in pantry and plenty of island seating. The master suite features walk-in closet, large tiled walk-in shower, linen closet and separate soaking tub. The covered back patio looks out on the fully fenced, sprinklered front and back yard. The game room upstairs is a great place for movies, games and just fun! Amenities include community pool, walking trails, playground for you to enjoy.' ,`Acres` = '0.1377' ,`Area` = '61' ,`BuilderName` = 'Omega' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PLEASANT HILL PH 1, BLOCK 2, LOT 33' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'KEMP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pleasant Hill Ph 1' ,`TaxAmount` = '5950' ,`TaxRate` = '2.3493' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704472' WHERE `Matrix_Unique_ID` = '210681021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:41:48.800' ,`MLSNumber` = '82200455' ,`ListAgentFullName` = 'Bruce Sellers' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.339805' ,`Longitude` = '-95.494290' ,`PhotoCount` = '36' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Yorkchase' ,`StreetNumber` = '2026' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2893' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE! One Story home in the master planned community of Graystone Hills. Paradise in your own backyard, Tuscany designed pool with 3 waterfalls/lights and lush landscaping. Bask in the sun on the huge cool deck that overlooks the pool. Property backs to a green space for privacy. Fenced with electric gate to access garage. Faux paint & custom fixtures, family room with cast stone fireplace, tile in all main living areas and faux wood blinds. Gourmet kitchen offers gas cooktop, granite counters, stainless appliances and breakfast bar opening to the family room. Primary bedroom has sitting, high ceilings and crown molding. Great outdoor space showcasing pool that was re-plastered in 2019 using pebble tech, including blue glass beads for enhanced brilliance when the sun hits them. Close to schools (all grade levels). Quick access to all amenities of Conroe, plus a short drive to all the shopping, dining and world-class medical facility amities of The Woodlands. CISD. Welcome Home!' ,`Acres` = '0.2283' ,`Area` = '19' ,`BuilderName` = 'Meritage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S539302 - GRAYSTONE HILLS 02, BLOCK 2, LOT 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9946' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '765' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Graystone Hills' ,`TaxAmount` = '8607' ,`TaxRate` = '2.7763' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704473' WHERE `Matrix_Unique_ID` = '210810610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:43:35.813' ,`MLSNumber` = '71744118' ,`ListAgentFullName` = 'Audrey Rochell' ,`ListOfficeName` = 'Bluewater Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.970043' ,`Longitude` = '-95.266676' ,`PhotoCount` = '4' ,`PostalCode` = '77541' ,`RoomCount` = '2' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Nesmith' ,`StreetNumber` = '222' ,`StreetSuffix` = 'Place' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bayside New Construction! Fun 2/2 with excellent views of the beach and bay. Both bedrooms and one full bath upstairs with living/kitchen/dining and full bathroom downstairs. Will be finished out with great neutral colors, vinyl plank flooring, and quartz kitchen countertops. Call today to schedule your showing!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'RM Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NESMITH TR 212 (A0009 B T ARCHER DIV 1 (B C I C)) (SURFSIDE)' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '3500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nesmith Tr 212' ,`TaxAmount` = '567' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704473' WHERE `Matrix_Unique_ID` = '211073985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:30:30.423' ,`MLSNumber` = '81080695' ,`ListAgentFullName` = 'Sherrie Bass' ,`ListOfficeName` = 'Bluewater Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.071455' ,`Longitude` = '-95.123432' ,`PhotoCount` = '38' ,`PostalCode` = '77541' ,`RoomCount` = '7' ,`ListPrice` = '419800.00' ,`Status` = 'Active' ,`StreetName` = 'Jolly Roger' ,`StreetNumber` = '12910' ,`StreetSuffix` = 'Drive' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this little gem in paradise!! Great location to the beach entrance with views to the gulf and sunrise. Open floor plan with kitchen, dining, and living area with a loft for extra sleeping. This property has been a vacation rental for a few years and has a following. Treasure Island has a community building, boat ramp, and fishing pier on the bayside. You can golf cart all the way down the island for fantastic shelling and fishing or to the bayside to watch the sunset.' ,`Acres` = '0.1148' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Treasure Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TREASURE ISLAND (A0029 S F AUSTIN), BLOCK 16, LOT 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Treasure Island' ,`TaxAmount` = '4412' ,`TaxRate` = '2.3804' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704473' WHERE `Matrix_Unique_ID` = '211074107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:47:20.540' ,`MLSNumber` = '62209089' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682825' ,`Longitude` = '-95.738236' ,`PhotoCount` = '39' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '587632.00' ,`Status` = 'Active' ,`StreetName` = 'Granary Gate' ,`StreetNumber` = '8822' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful one-story floor plan boasts everything you have been dreaming of and more. As you enter the elegant foyer, you will discover a study complemented by glass French doors and a secondary bedroom with its own private bath and walk-in closet. Following the extended foyer, you will be escorted into the heart of the home. The kitchen offers ample amounts of counter space to prepare multiple meals for any occasion. Your guests will be able to enjoy time out on the covered patio, while you prepare for dinner. Complete with a three-car garage, what’s not to love?' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7645' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Grand Mission Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.96' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704473' WHERE `Matrix_Unique_ID` = '211205866' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:39:56.780' ,`MLSNumber` = '43066435' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.945712' ,`Longitude` = '-95.782046' ,`PhotoCount` = '43' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '1074898.00' ,`Status` = 'Active' ,`StreetName` = 'White Caterpillar' ,`StreetNumber` = '11015' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REPRESENTATIVE PHOTOS ADDED! MLS#43066435 Built by Taylor Morrison, March 2023 Completion - The Darling Collection 7431 Plan! Featuring a dramatic entry way and soaring ceilings, this floor plan fits all your needs. Off the foyer secondary bedroom and full bath, game room, media room, and study. Keep the good times going by extending the casual dining area to include a sitting room, conveniently located next to the outdoor living area for seamlessly entertaining. Your owner’s suite has everything you need to set the stage for a peaceful retreat. In the owner’s bath you find a tub for ultimate relaxation as well as a separate shower encased in glass. The dramatic staircase takes you upstairs, where the three remaining bedrooms include full baths and walk-in closets. Structural options include: Bay window at owner\'s suite, 15x8 sliding glass doors, game room 2, media room, tray ceilings, freestanding tub and sitting room.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10902' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland 80s' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704473' WHERE `Matrix_Unique_ID` = '211429848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:38:01.953' ,`MLSNumber` = '93212277' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946400' ,`Longitude` = '-95.781933' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '1215060.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Winged' ,`StreetNumber` = '21331' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5488' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REPRESENTATIVE PHOTOS ADDED! MLS#93212277 Built by Taylor Morrison, March 2023 Completion - The Darling Collection 8093 Plan! A large portion of the square footage is devoted to deluxe entertaining spaces including an impressive two-story luxury gathering room, formal dining, two-story covered outdoor living and spacious second floor game room. Along with a magnificently-appointed owner’s suite, all four additional bedrooms feature a walk-in closet and private bath. The owner’s suite is more than just the owner’s bedroom, it’s a separate entity with an expansive bathroom complete with a tub, shower, dual sink vanities and massive his and her walk-in closets. Structural options include: Wet bar, bay window at owner\'s suite, sliding glass door at gathering room, freestanding tub, extended patio and wine grotto.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704473' WHERE `Matrix_Unique_ID` = '211435060' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:36:38.667' ,`MLSNumber` = '82462576' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.945257' ,`Longitude` = '-95.781665' ,`PhotoCount` = '10' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '1187480.00' ,`Status` = 'Active' ,`StreetName` = 'White Caterpillar' ,`StreetNumber` = '11019' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#82462576 Built by Taylor Morrison, March 2023 Completion - The Darling Collection 8091 Plan features a dramatic entry way and soaring ceilings. Walking past the formal dining room enter a spacious open area with a gathering room, kitchen, breakfast nook, and hearth room. The kitchen is near the formal dining room. The owner’s suite is tucked away in the back of the home for a more privacy, with a stunning bay window. The luxurious bath holds dual sink vanities, a shower and separate tub, and a private commode. The second bedroom is located conveniently on the first floor with a full bath, perfect for company. Heading upstairs you will find 3 additional bedrooms with 3 full baths and walk-in closets, a game room and a media room. Structural options include: Bay window at owner\'s suite, covered outdoor living 1 and wine grotto.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10981' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704473' WHERE `Matrix_Unique_ID` = '211437961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:12:04.773' ,`MLSNumber` = '93681491' ,`ListAgentFullName` = 'Anansia Nobles' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735319' ,`Longitude` = '-95.538660' ,`PhotoCount` = '29' ,`PostalCode` = '77063' ,`RoomCount` = '9' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Val Verde st' ,`StreetNumber` = '9659' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '2010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW LISTING in the BELLAIRE section of Houston, near the Galleria, Sam Houston Tollway - Beltway 8, Westpark Tollway, Memorial Hermann Southwest Hospital, and Houston Baptist University. This property boasts 6 bedrooms in a great location just minutes from downtown and major highways. Many upgrades have been made including additional parking, A/C and heating, a surveillance system, and more. Call or text the agent for the exact rental income. The home is occupied. PLEASE DO NOT DISTURB THE TENANTS. ' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '9659 Val Verde St' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'EMERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'TangleWilde' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704474' WHERE `Matrix_Unique_ID` = '211452719' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:36:39.930' ,`MLSNumber` = '45744882' ,`ListAgentFullName` = 'Diane Kink' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161074' ,`Longitude` = '-95.486919' ,`PhotoCount` = '47' ,`PostalCode` = '77381' ,`RoomCount` = '15' ,`ListPrice` = '6499000.00' ,`Status` = 'Active' ,`StreetName` = 'Isle Place' ,`StreetNumber` = '2' ,`StreetSuffix` = '' ,`City` = 'The Woodlands' ,`BathsFull` = '6' ,`BathsHalf` = '3' ,`BedsTotal` = '5' ,`SqFtTotal` = '10621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Picturesque waterfront scenery in the heart of The Woodlands! Take in sunlit days in the pool or beautiful evenings on a relaxing boat ride. Beautiful waterfront property will leave you breathless as a dual gated entry opens to a spacious circle drive and an exceptional custom home. Its abundant and large windows add to the elegance of the scenery. The estate boasts 5 primary bedrooms w/en-suite baths, ELEVATOR, handsome library, indoor spa w/wet & dry saunas, gym, media, and game room. Dramatic high ceilings, elegant lighting & Italian chandeliers, custom millwork, luxury fixtures, Venetian walls and ceilings, and Travertine floors, all complement the soft hues throughout the house. Stunning formals, wine cellar, kitchen, and primary bedroom all enjoy fantastic water views. Newly painted exterior; a private dock with bench seating. Expansive balconies, infinity pool & spa, summer kitchen, and firepit. A must-see property for car enthusiasts with custom showcase garages.' ,`Acres` = '0.6541' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL PANTHER CK 25, BLOCK 1, LOT 17' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '28493' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SALLY RIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Wdlnds Village Panther Ck' ,`TaxAmount` = '92158' ,`TaxRate` = '2.1432' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704474' WHERE `Matrix_Unique_ID` = '211504346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:29:13.130' ,`MLSNumber` = '42462796' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661910' ,`Longitude` = '-95.056152' ,`PhotoCount` = '37' ,`PostalCode` = '77571' ,`RoomCount` = '11' ,`ListPrice` = '486673.00' ,`Status` = 'Active' ,`StreetName` = 'Vanessa Cay' ,`StreetNumber` = '2246' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3022' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#42462796 REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, January Completion - The Bordeaux! An excellent choice for larger households needing additional living space! Walkthrough the long foyer to an impressive two-story floorplan open to the family room, kitchen with island, and casual dining area with views to the covered outdoor living. Perfect for family and entertaining guests! A private study is left of the foyer near the half-bath and the laundry is conveniently located near the kitchen. The owner’s suite is situated nicely in the back for peace and quiet. Relax in the owner’s bath with soaking tub, separate shower, and large walk-in closet. Upstairs are 2 additional bedrooms each with baths and walk-in closets. Family fun night can be every night in the large game room upstairs. Structural options for 2246 Vanessa Cay Lane include: study, open rails, soaking tub in owner’s bath, extended owner’s suite, and patio, and 8’ entry door.' ,`Acres` = '0.153' ,`Area` = '7' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Block 4 of Morgan\'s Landing Section 9' ,`LotDesciption` = 'Other' ,`LotSize` = '6687' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704474' WHERE `Matrix_Unique_ID` = '211524204' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:25:22.740' ,`MLSNumber` = '43615827' ,`ListAgentFullName` = 'William Hibbard' ,`ListOfficeName` = 'Hibbard Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.259001' ,`Longitude` = '-95.500041' ,`PhotoCount` = '17' ,`PostalCode` = '77384' ,`RoomCount` = '4' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Coachlight' ,`StreetNumber` = '2416' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2387' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful upgraded one story in desirable Carriage Hills. Excellent Woodlands Schools.4 bedrooms 2 1/2 bath. Kitchen has all stainless steel appliances and open to breakfast room and living room.Beautiful modern light fixtures and tons of natural light! throughout this gorgeous home! 2 car detached garage with extended workshop. This home offers a huge back yard with a covered patio and includes a large hot tub with privacy fence. Large front porch and spacious circle driveway. Ample parking. This is a must see!' ,`Acres` = '0.4591' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CARRIAGE HILLS 02, LOT 208' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Carriage Hills 02' ,`TaxAmount` = '6053' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704474' WHERE `Matrix_Unique_ID` = '211524815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:09:10.120' ,`MLSNumber` = '64789604' ,`ListAgentFullName` = 'Sonia Trevino' ,`ListOfficeName` = 'Houston Homes Legacy Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.870886' ,`Longitude` = '-95.435752' ,`PhotoCount` = '20' ,`PostalCode` = '77088' ,`RoomCount` = '6' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Willow' ,`StreetNumber` = '7703A' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION....in progress. The approximate completion date is in October. May still be in time to make some selections if you hurry. This is a two-story home with all bedrooms up and a split plan. All neutral tones throughout with lots of natural lighting. The home features a wrought iron decorative staircase, vinyl plank flooring, stainless steel appliances, and quartz countertops.' ,`Acres` = '0.1377' ,`Area` = '11' ,`BuilderName` = 'D\'Marco Homes+Const.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 28 BLK 13 HIGHLAND ADDITION' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Add' ,`TaxAmount` = '650' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704474' WHERE `Matrix_Unique_ID` = '211639950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:10:45.823' ,`MLSNumber` = '15897794' ,`ListAgentFullName` = 'Sonia Trevino' ,`ListOfficeName` = 'Houston Homes Legacy Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.870886' ,`Longitude` = '-95.435752' ,`PhotoCount` = '20' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Willow' ,`StreetNumber` = '7703B' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION....in progress. The approximate completion date is in October. May still be in time to make some selections if you hurry. This is a two-story home with all bedrooms up and a split plan. All neutral tones throughout with lots of natural lighting. The home features a wrought iron decorative staircase, vinyl plank flooring, stainless steel appliances, and quartz countertops.' ,`Acres` = '0.1377' ,`Area` = '11' ,`BuilderName` = 'D\'Marco Homes+Const.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 29 BLK 13 HIGHLAND ADDITION' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Addition' ,`TaxAmount` = '650' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704474' WHERE `Matrix_Unique_ID` = '211640295' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:13:46.407' ,`MLSNumber` = '78221091' ,`ListAgentFullName` = 'Sonia Trevino' ,`ListOfficeName` = 'Houston Homes Legacy Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.870954' ,`Longitude` = '-95.435753' ,`PhotoCount` = '20' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Willow' ,`StreetNumber` = '7711' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION...in process. The approximate completion date is around October. May still be in time to make some selections if you hurry. This is a two-story home with all bedrooms up and a split plan. All neutral tones throughout with lots of natural lighting. Home features a wrought iron decorative staircase, vinyl plank flooring, stainless steel appliances, quartz countertops.' ,`Acres` = '0.0689' ,`Area` = '11' ,`BuilderName` = 'D\'Marco Homes+Const.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 33 BLK 13 HIGHLAND ADDITION' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Add' ,`TaxAmount` = '433' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704475' WHERE `Matrix_Unique_ID` = '211646846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:09:27.207' ,`MLSNumber` = '56898783' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906675' ,`Longitude` = '-95.749751' ,`PhotoCount` = '14' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '785864.00' ,`Status` = 'Active' ,`StreetName` = 'Luddenham Lilac' ,`StreetNumber` = '8903' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3666' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS # 56898783 ~ REPRESENTATIVE PHOTOS ADDED. January Completion! The 5809 is a two-story floor plan design features a welcoming foyer with soaring ceilings and a study with double doors which is perfect for an office space. In the kitchen you will find a large island overlooking the gathering room and dining area. Outside is a spacious outdoor covered living area, perfect for entertaining or meals with family and friends. The owner’s suite is positioned for privacy at the back of the home and provides a peaceful haven where you can relax at the end of the day with a sizable shower and two separate walk-in closets. The second floor features a game room, media room, three bedrooms and two bathrooms. Structural options added at 8903 Luddenham Lilac Lane include: full gutters, first floor bedroom with shower in the bathroom , media room, bay window at owner\'s suite, fireplace, and sliding glass door at family room.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '030110' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10047' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Avalon at Cypress 60\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704475' WHERE `Matrix_Unique_ID` = '211772587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:18:09.867' ,`MLSNumber` = '33404111' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292474' ,`Longitude` = '-95.548597' ,`PhotoCount` = '25' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '515193.00' ,`Status` = 'Active' ,`StreetName` = 'Dandelion' ,`StreetNumber` = '144' ,`StreetSuffix` = 'Way' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#33404111 REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison specifically for age restricted 55+ communities. Ready January - the beautiful 1507 plan is a 2 bedroom home that offers a blend of comfort and style. The open and airy living spaces bring you into the heart of the home where the kitchen, dining area and family room overlook the covered patio. The study with double doors is off the foyer and provides a perfect setting for those who work from home. Relax in the owner\'s suite with spa-like bathroom and large walk-in closet. A guest bedroom with walk-in shower is located on the opposite side of the home. Structural options include: 5\' extension on bedroom 2, 8\' doors, covered outdoor living 2 and kitchen island.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S265910 - BONTERRA AT WOODFOREST 10, BLOCK 3, LOT 32' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '14675' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra at Woodforest Cottages' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704475' WHERE `Matrix_Unique_ID` = '211845911' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:10:26.590' ,`MLSNumber` = '98840907' ,`ListAgentFullName` = 'Tram Nguyen' ,`ListOfficeName` = 'TTN Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684459' ,`Longitude` = '-95.571297' ,`PhotoCount` = '11' ,`PostalCode` = '77099' ,`RoomCount` = '5' ,`ListPrice` = '186666.00' ,`Status` = 'Active' ,`StreetName` = 'Bexley' ,`StreetNumber` = '10946' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1517' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COZY, CORNER LOT TOWNHOUSE WITH LOTS OF UPGRADED. FRESH PAINT, NEW WINDOWS, NEW CABINETS, CROWN MOLDING, TILE FLOOR THRU OUT THE HOUSE. BEAUTIFUL GRANITE COUNTERTOP WITH DROP-IN SINK A THE KITCHEN AND 2 FULL BATH. CLOSE TO SHOPPING CENTERS, DINING, EASY ACCESS TO FREEWAY 59 AND BELTWAY 8.' ,`Acres` = '' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'UNIT 10946 BLDG 2 GLENSHANNON SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '334' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'BOONE ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'OLLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Glenshannon Sec 02 Reserve C' ,`TaxAmount` = '2095' ,`TaxRate` = '2.72686' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704475' WHERE `Matrix_Unique_ID` = '211862465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:53:42.807' ,`MLSNumber` = '96218348' ,`ListAgentFullName` = 'Belinda Gaines' ,`ListOfficeName` = 'Belinda Gaines Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.187178' ,`Longitude` = '-95.415820' ,`PhotoCount` = '22' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '268500.00' ,`Status` = 'Active' ,`StreetName` = 'Kelly' ,`StreetNumber` = '186' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable newly built 3/2/1 home located at the end of the street. Lot is oversized, fenced, landscaped, and offers amenities such as location to AISD schools, highways, and city infrastructure. This home is approximately three months old, has a large living area for entertaining, open concept for cooking and dining, and large garage/parking area for vehicles. Call now for an appointment, You will not be disappointed.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sec. 0001 Riverwood Ranch' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '337' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704475' WHERE `Matrix_Unique_ID` = '211917427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:11:52.517' ,`MLSNumber` = '51934977' ,`ListAgentFullName` = 'Sherry Harlan' ,`ListOfficeName` = 'Riverbend Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502091' ,`Longitude` = '-97.436340' ,`PhotoCount` = '18' ,`PostalCode` = '78629' ,`RoomCount` = '6' ,`ListPrice` = '185900.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Vincent' ,`StreetNumber` = '1608' ,`StreetSuffix` = 'Street' ,`City` = 'Gonzales' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2035' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own a piece of Gonzales history with this 1930s built home. This 3 bedroom, 3 bath home includes high ceilings and hardwood floors. A large, fenced back yard with a concreated area that can be used as an outdoor kitchen and/or entertaining patio that sits next to the swimming pool. A garage large enough for 2 cars. This home sits nicely on 3 lots.' ,`Acres` = '0.3504' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '5-9 3 RIVERCREST PT OF 18,19 & 20' ,`LotDesciption` = 'Other' ,`LotSize` = '15263' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '550 - Gonzales' ,`SchoolElementary` = 'GONZALES ELEMENTARY SCHOOL (GONZALES)' ,`SchoolHigh` = 'GONZALES HIGH SCHOOL' ,`SchoolMiddle` = 'GONZALES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rivercrest Place Add' ,`TaxAmount` = '5652' ,`TaxRate` = '2.4121' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704475' WHERE `Matrix_Unique_ID` = '211935644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:02:14.863' ,`MLSNumber` = '23907474' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.407626' ,`Longitude` = '-95.052623' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '417000.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Edge' ,`StreetNumber` = '2602' ,`StreetSuffix` = 'Crossing' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well suited to a variety of lifestyle needs, this Elora is a 4 bedroom, 3 bathroom home that\'s spacious and functional, with an open-concept kitchen and great room, dedicated dining room, and sizable primary bedroom complete with a large walk-in closet and spa-like ensuite. Enjoy all this the Elora has to offer plus a walk-in kitchen pantry, luxury vinyl plank throughout the great room, and a large covered patio with a ceiling fan to beat the Texas heat.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28, Block 5, Section 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6524' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704475' WHERE `Matrix_Unique_ID` = '211941499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:41:08.883' ,`MLSNumber` = '57182207' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662668' ,`Longitude` = '-95.754760' ,`PhotoCount` = '3' ,`PostalCode` = '77406' ,`RoomCount` = '6' ,`ListPrice` = '435600.00' ,`Status` = 'Active' ,`StreetName` = 'Iron Oak' ,`StreetNumber` = '21407' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready March 2023! Debate what to wear in the Preston’s impressive walk-in closet located just off the private primary suite bath. Sizeable secondary bedrooms are ideal for kids or guests. The spacious living area flows seamlessly outdoors to the covered back patio. Access to Grand Parkway and the Westpark Tollway make it easy to get to work or play. A low tax rate and zoning to the prestigious Lamar Consolidated ISD bolster Creekside Farms’ appeal. Known for our energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on your utility bills.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0114 Plan L403D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704476' WHERE `Matrix_Unique_ID` = '211944701' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T14:47:17.967' ,`MLSNumber` = '70426507' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014004' ,`Longitude` = '-95.414155' ,`PhotoCount` = '28' ,`PostalCode` = '77073' ,`RoomCount` = '6' ,`ListPrice` = '269990.00' ,`Status` = 'Active' ,`StreetName` = 'Sovereign Heights' ,`StreetNumber` = '22110' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1849' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Imperial Heights in Houston, TX! The Chestnut floor plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! The first floor offers the perfect entertainment space with a large kitchen island overlooking the family and dining rooms! The gourmet kitchen is sure to please with 42\" white colored cabinets, granite countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights 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` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 5 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3243' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704476' WHERE `Matrix_Unique_ID` = '211945050' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:04:56.350' ,`MLSNumber` = '91212636' ,`ListAgentFullName` = 'Twila Bertrand' ,`ListOfficeName` = 'Century 21 Cota Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.926515' ,`Longitude` = '-94.006920' ,`PhotoCount` = '31' ,`PostalCode` = '75951' ,`RoomCount` = '5' ,`ListPrice` = '79900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue D' ,`StreetNumber` = '601' ,`StreetSuffix` = '' ,`City` = 'Jasper' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1224' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment Property on a corner lot conveniently located near shopping, schools, and medical facilities! This cute brick home has 3 Bedrooms, 1 Full Bath, a cozy open concept living and dining area, and a large kitchen with lots of storage. It features tile flooring throughout for long lasting durability, natural colors throughout, a metal roof, and a concrete drive with extra parking.' ,`Acres` = '0.195' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LOT E PT OF 4-5 BLK 1 COLLEGE HEIGHTS 1050 /260 .195 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '149 - Jasper' ,`SchoolElementary` = 'PARNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JASPER HIGH SCHOOL (JASPER)' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '704' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704476' WHERE `Matrix_Unique_ID` = '211945084' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:03:39.973' ,`MLSNumber` = '41865239' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014117' ,`Longitude` = '-95.414162' ,`PhotoCount` = '19' ,`PostalCode` = '77073' ,`RoomCount` = '5' ,`ListPrice` = '272990.00' ,`Status` = 'Active' ,`StreetName` = 'Sovereign Heights' ,`StreetNumber` = '22114' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1753' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Imperial Heights in Houston, TX! The Leon plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and a 2-car garage. This home has it all, including blinds! The first floor offers the perfect space for entertaining, with an open kitchen overlooking the family room and dining area! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, separate tub and shower, and a walk-in closet! Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights 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` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 5 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3244' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704476' WHERE `Matrix_Unique_ID` = '211945976' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:46:11.277' ,`MLSNumber` = '19044178' ,`ListAgentFullName` = 'Jude Nassar' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.024678' ,`Longitude` = '-95.509885' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Wimbledon Forest' ,`StreetNumber` = '16623' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL LARGE HOME WITH SPACIOUS FLOOR PLAN, HUGE MASTER BEDROOM WITH WALK-IN CLOSET, DOUBLE SINKS, SEPARATE TUB AND SHOWER, MASTER DOWNSTAIRS ONLY, GOURMET KITCHEN WITH ALL APPLIANCES INCLUDED, MARBLE COUNTERTOPS, NICE SIZE PATIO WITH POOL PERFECT FOR ENTERTAINING AND FAMILY ACTIVITIES, LOCATED CLOSE TO GOLF COURSE, TENNIS COURTS, RESTAURANTS, SHOPPING CENTERS AND FWY ACCESS, MUST SEE TO APPRECIATE..' ,`Acres` = '0.2167' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 4 WIMBLEDON ESTS & RACQ CL SEC 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '664' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wimbledon Estates & Racq Cl Se' ,`TaxAmount` = '6498' ,`TaxRate` = '2.1875' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704476' WHERE `Matrix_Unique_ID` = '211946681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T15:53:56.940' ,`MLSNumber` = '20666261' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.013865' ,`Longitude` = '-95.414571' ,`PhotoCount` = '28' ,`PostalCode` = '77073' ,`RoomCount` = '6' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Sovereign Heights' ,`StreetNumber` = '22111' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Imperial Heights in Houston, TX! The Shannon Plan is a spacious 2-story home with 3 bedrooms, 2.5 bathrooms and a 2-car garage. This home has it all, including blinds and a FLEX ROOM on the first floor! With an open kitchen, dining, and family room, you\'ll love entertaining in this home! The gourmet kitchen is sure to please with 42\" white colored cabinets, granite countertops, and stainless steel appliances. Upstairs offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a separate tub and shower, and walk-in closet. Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights 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` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 4 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3614' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704476' WHERE `Matrix_Unique_ID` = '211948794' --> Updated record success