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-11-12T00:07:01.173' ,`MLSNumber` = '41662212' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150899' ,`Longitude` = '-95.584323' ,`PhotoCount` = '26' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '899717.00' ,`Status` = 'Active' ,`StreetName` = 'Tynan Ridge' ,`StreetNumber` = '8538' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 41662212 - Built by Toll Brothers, Inc. - December completion! ~ Located on a corner home site with no rear neighbors, the Adalyn Italian Villa boasts a clean stucco finish that makes an impressive statement. This beautiful two-story home features soaring ceilings, private study, and formal dining room with views to the curved staircase. Open the multi-slide doors in the great room and expand your entertaining and living space to the covered porch. Additional highlights are a first-floor guest suite with full bath. The primary suite offers a tray ceiling and resort-style bath and spacious closet. Host game and movie nights in the flex/game space or media room. Outdoor toys will be covered in the huge 4-car tandem garage. This is the epitome of luxury living in a resort-style community!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 9 Blk 3' ,`LotDesciption` = 'Corner,Other' ,`LotSize` = '11718' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294636' WHERE `Matrix_Unique_ID` = '200571208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:53:39.090' ,`MLSNumber` = '76432475' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.468092' ,`Longitude` = '-95.525340' ,`PhotoCount` = '21' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '524075.00' ,`Status` = 'Active' ,`StreetName` = 'Rustling Creek' ,`StreetNumber` = '1715' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76432475 - Built by Toll Brothers, Inc. - November completion! ~ The Waller Mission boast curb appeal with the stylish stucco exterior with shutters and covered entry. The impressive two-story foyer with tray ceiling flows into the secluded office with double doors. A spacious great room offers a multi-slide door that opens to an expanded back patio. The grand and private back yard has plenty of room for a future pool and outdoor recreational activities. The gourmet kitchen features a casual dining room, walk-in pantry and island that overlooks the great room. The first-floor primary bedroom includes dramatic sloped ceilings and ensuite bath with dual vanities, free standing tub with separate shower and walk-in closet with convenient access to the utility room. Additional highlights are three spacious bedrooms, one with private bath, shared hall bath and a loft overlooking the great room.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Blk 2' ,`LotDesciption` = 'Greenbelt,Other,Subdivision Lot' ,`LotSize` = '8693' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sienna - Villa Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294636' WHERE `Matrix_Unique_ID` = '202961781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:07:01.173' ,`MLSNumber` = '65287671' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.644636' ,`Longitude` = '-95.027897' ,`PhotoCount` = '29' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '334125.00' ,`Status` = 'Active' ,`StreetName` = 'Lucky Manor' ,`StreetNumber` = '177' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 65287671 - Built by HistoryMaker Homes - Ready Now! ~ Built by HistoryMaker Homes, January 2022 completion! This 3 bedroom, 2.5 bathroom, two-story home boasts a soaring two-story entry and 9\' ceilings throughout the remainder of the 1st floor. Luxury vinyl plank can be found in the common areas and all baths. The chef-inspired kitchen offers 42 inch white cabinetry with crown molding, ceramic tile backsplash, granite countertops, a corner walk-in pantry, and stainless-steel appliances that make entertaining easy. Settle into the spacious primary bedroom located on first floor and bathroom with dual sink vanity and 60-inch shower. This home comes with full sod, full irrigation, and covered back patio.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 3 ARTESIA VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5340' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artesia Village' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294636' WHERE `Matrix_Unique_ID` = '202972493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:54:36.047' ,`MLSNumber` = '39102668' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099473' ,`Longitude` = '-95.347974' ,`PhotoCount` = '32' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '749520.00' ,`Status` = 'Active' ,`StreetName` = 'Woodley' ,`StreetNumber` = '28261' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 39102668 - Built by Toll Brothers, Inc. - Ready Now! ~ This beautiful Quinton contemporary home opens to a welcoming foyer with tray ceiling and a clear view of an expansive great room. Adjacent to an inviting front covered porch is a formal dining area that has pass through access to a well-appointed kitchen with a large center island. The primary bedroom is enhanced with a majestic cathedral ceiling, enormous walk-in closet with an ultra-shower and large soaking stand-alone tub and dual-sink vanities. This home includes generous spaced secondary bedrooms, two with a shared bath and one with full hall bath access. Multi-slide doors lead to a generous covered patio form the great room, and breakfast area with cathedral ceiling perfect for entertaining. Thoughtfully placed on a northwest facing cul-de-sac home site, the backyard provides a serene view, and plenty of space for a future pool. Schedule your appointment today!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S973718 - WOODSON\'S RESERVE 18, BLOCK 1, LOT 16' ,`LotDesciption` = 'Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '11030' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Woodson\'s Reserve' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294636' WHERE `Matrix_Unique_ID` = '203319030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:07:01.173' ,`MLSNumber` = '31786152' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150508' ,`Longitude` = '-95.585401' ,`PhotoCount` = '22' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '1039979.00' ,`Status` = 'Active' ,`StreetName` = 'Tynan Ridge' ,`StreetNumber` = '8522' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 31786152 - Built by Toll Brothers, Inc. - January completion! ~ The Venetian Calais plan offers luxurious style and design. The impressive exterior featuring a Porte Cochere with motor court, 3-car split garage, and covered front porch and patio, makes for great curb appeal. The foyer provides elegance with it\'s curved staircase, two-story ceilings, and views into the formal dining room. A private office and bedroom suite off the foyer provide convenience of remote working and solitude for guests. Entertaining is easy in the open concept kitchen and great room. The primary suite includes a tray ceiling, and luxurious bath with freestanding tub, large vanity with double sinks, separate shower and huge walk-in closet. Upstairs, you will find a spacious flex-game room and media room, along with three generous bedrooms with full baths!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S740205 - NORTHGROVE 05, BLOCK 3, LOT 5' ,`LotDesciption` = 'Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '12850' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294636' WHERE `Matrix_Unique_ID` = '205387513' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:20:56.857' ,`MLSNumber` = '2856526' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.920561' ,`Longitude` = '-95.729741' ,`PhotoCount` = '15' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Mossycup Spur' ,`StreetNumber` = '14906' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 2856526 - Built by Highland Homes - November completion! ~ Highland Homes 4 Bedroom, 3 bath with Soaring Ceilings and dramatic entry! The kitchen overlooking the family room gives an open feel to the home and the vaulted ceilings truly elevates the space. 2 Bed/ bath downstairs and 2 Bed/ bath upstairs along with a game room. Extended outdoor patio, full sod yard and sprinkler system! The quality of this home is only found with Highland Homes.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 20, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5758' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.65' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294636' WHERE `Matrix_Unique_ID` = '206450658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:25:14.903' ,`MLSNumber` = '85796281' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834939' ,`Longitude` = '-95.409721' ,`PhotoCount` = '9' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Abbadean' ,`StreetNumber` = '4803' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Martin Court located in Independence Heights built by Oracle City Homes. This privately gated urban modern farmhouse community consists of 16 units total units with twelve 2 story homes and four 3 story homes that each come with a private yard. Each unit has been professionally designed interiors raising the bar with high end standard features that come with each home. First floor living with an oversized island countertop with seating of 3 that overlooks the living room that leads you to your own private backyard. The dining area is nestled in it\'s own private section with oversized windows along the adjoining walls giving plenty of natural lighting. The primary bedroom features 10 ft high ceilings and oversized windows that leads you to your own primary ensuite with separate his/her sinks along each wall that welcomes you into your own stand alone tub and walk in shower and closet. This community is a must see combining luxury and privacy!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Martin Court' ,`LotDesciption` = 'Other' ,`LotSize` = '1100' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Martin Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294637' WHERE `Matrix_Unique_ID` = '207252108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:03:01.313' ,`MLSNumber` = '79517619' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099434' ,`Longitude` = '-95.349580' ,`PhotoCount` = '15' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '699254.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Peak' ,`StreetNumber` = '28224' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3789' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 79517619 - Built by Toll Brothers, Inc. - November completion! ~ Entertainers dream home now available! This luxurious Warner High Plains home features impeccable finishes and inspiring spaces throughout. High 19-foot ceilings start in the foyer and lead into a two-story great room making the home feel open and bright. A 60\' linear fireplace keeps you warm on cool nights and 12-foot multi-slide doors open to the covered patio and expand your entertaining space to the outdoors. A formal dining room is easily accessed from the chef-inspired kitchen via the butlers pantry. The comfortable and relaxing primary suite boasts tray ceilings, a stunning freestanding tub that sits between individual vanities, a tiled shower and enormous walk-in closet. Take the party to the upper level to enjoy the game/flex room for friendly competition or relax with a movie in the media room. Act now and call to schedule an appointment to view this amazing home.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S973718 - WOODSON\'S RESERVE 18, BLOCK 1, LOT 8' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '8433' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1335' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodson\'s Reserve Select' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294637' WHERE `Matrix_Unique_ID` = '208564179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:03:33.043' ,`MLSNumber` = '90101102' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099631' ,`Longitude` = '-95.350013' ,`PhotoCount` = '19' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '699886.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Peak' ,`StreetNumber` = '28219' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 90101102 - Built by Toll Brothers, Inc. - November completion! ~ Single-story living at it\'s finest, the Loralai High Plains plan features a stunning entry that boasts curb appeal. Friends and family are welcomed with impressive tray ceilings in the foyer which flow into the kitchen and great room. The primary bedroom displays a tray ceiling and en-suite with a luxurious freestanding tub, separate shower with beautiful floor and wall tile, and a spacious walk-in closet. The great room\'s 9-foot multi-slide doors open to the expanded covered patio which is pre-plumbed for sink and gas stub for a future outdoor kitchen. Other features include a study with sloped ceiling, and media room for entertaining.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S973718 - WOODSON\'S RESERVE 18, BLOCK 1, LOT 30' ,`LotDesciption` = 'Cleared,Other,Subdivision Lot' ,`LotSize` = '8433' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1335' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodson\'s Reserve Select' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294637' WHERE `Matrix_Unique_ID` = '208698841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:34:31.793' ,`MLSNumber` = '13478814' ,`ListAgentFullName` = 'Paul Stewart' ,`ListOfficeName` = 'Home Run Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023487' ,`Longitude` = '-95.315874' ,`PhotoCount` = '23' ,`PostalCode` = '77338' ,`RoomCount` = '5' ,`ListPrice` = '284499.00' ,`Status` = 'Active' ,`StreetName` = 'Foxwood Garden' ,`StreetNumber` = '20838' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ROOF INSTALLED 8/8/2022. Large 5 bedrooms and 2.5 baths available in Foxwood. Inviting entry opens into a large living area that features hardwood floor and a fireplace. Beautiful formal area, open kitchen with extended breakfast area. There is an energy-efficient gas cooking stove, a large master suite with a garden tub, and a separate shower. The secondary bedroom would be great for guests, and a spacious media/game room. Extended Laundry, and ceiling fans in all rooms. Rounded sheetrock corners, security camera/system. HURRY this one is priced to go quickly!!!' ,`Acres` = '0.1085' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 FOXWOOD SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxwood' ,`TaxAmount` = '5740' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294637' WHERE `Matrix_Unique_ID` = '209607299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:20:56.747' ,`MLSNumber` = '89552299' ,`ListAgentFullName` = 'Billy Wade' ,`ListOfficeName` = 'Texas Sage Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063819' ,`Longitude` = '-95.490680' ,`PhotoCount` = '18' ,`PostalCode` = '77388' ,`RoomCount` = '5' ,`ListPrice` = '238500.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Lake' ,`StreetNumber` = '4718' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1622' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 3 bedroom home with two baths. Laminated floors, covered patio that overlooks a nice shaded back yard. A/C, air ducts and kitchen appliance less that 5 years old. Home interior and exterior has been recently painted.' ,`Acres` = '0.1641' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 4 017*B6830749-003-004-041 BRIDGESTONE SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '327' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ROTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgestone Sec 03' ,`TaxAmount` = '3127' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294637' WHERE `Matrix_Unique_ID` = '211973894' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:54:56.450' ,`MLSNumber` = '57904216' ,`ListAgentFullName` = 'Rob Roy' ,`ListOfficeName` = 'Texas Flat Fee, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406687' ,`Longitude` = '-94.916815' ,`PhotoCount` = '42' ,`PostalCode` = '77590' ,`RoomCount` = '8' ,`ListPrice` = '339777.00' ,`Status` = 'Active' ,`StreetName` = '23rd' ,`StreetNumber` = '1505' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open concept custom home on oversized 1/4+ acre lot. Circle driveway*Large family room features brick accented fireplace, wood beams, recessed lighting & ceiling fans*Custom wood cabinets and shelving throughout the home*Plenty of cabinet space*Formal dining room with crown & chair molding & chandelier*Wet Bar*Spacious sun room with wall of windows*Island kitchen with chef\'s desk, double oven, cooktop, microwave, dishwasher & double sink, service window and breakfast bar*Window seat in breakfast room*Primary bedroom has gambrel ceiling and ceiling fan*Primary bath has his and her walk-in closets, double sink vanity, and walk-in shower*Inside utility room with room for freezer*Three car garage.' ,`Acres` = '0.2755' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 PAGE 1 LOT 6 BLK 56 MAINLAND PARK SEC N' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'GUAJARDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mainland Park' ,`TaxAmount` = '6208' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294638' WHERE `Matrix_Unique_ID` = '212212810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:20:56.670' ,`MLSNumber` = '89756914' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.055410' ,`Longitude` = '-95.352140' ,`PhotoCount` = '6' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '284990.00' ,`Status` = 'Active' ,`StreetName` = 'Pinetum' ,`StreetNumber` = '23414' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available in October! The Pierce offers a lot of value for those seeking an affordable two story home. With 4 bedrooms, this is a home you can grow into. The open concept downstairs kitchen/gathering room make for a great space to entertain. This home is on a cul de sac lot for extra privacy!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '08302' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5977' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Grove' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294638' WHERE `Matrix_Unique_ID` = '212361350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:07:29.610' ,`MLSNumber` = '45413071' ,`ListAgentFullName` = 'Syed Mubashir' ,`ListOfficeName` = 'M&M Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844318' ,`Longitude` = '-95.733746' ,`PhotoCount` = '45' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Greenfield Springs' ,`StreetNumber` = '4823' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 Bedrooms 2.5 Baths Home in the Meadows at Westfield Village Community of Katy, Texas. Welcome Home to 4823 Greenfield Springs Lane. Built on a Premium 7059sqft Lot & Boasts a Beautiful Brick Front Elevation. Interior offers an ideal floor plan with the Primary Suite Down, Flex Area that could be used as Formal Dining/Living, Spacious Den Area that is Open to the Kitchen/Breakfast Area, Recessed Lighting & Upgraded 9 Ft Ceilings. Upstairs you will find the Texas Size Game Room with Three additional Spacious Bedrooms. Primary Suite has a Walk-In Closet with the Primary bath featuring Dual Vanities, Stand-In Shower and a Kohler Master Windward Tub. Enjoy LOW ENERGY BILLS with the High Efficiency HVAC System & Digital Programable Thermostat. Other Upgrades include Granite Countertops in the Kitchen with 42\" Woodmont Ashford Raised Panel Cabinets, Pendent Lighting, Moen High Arc Faucet, Black Appliance including the Refrigerator & Water Softener System Stays. Will Not Last!' ,`Acres` = '0.1621' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 MEADOWS AT WESTFIELD VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7059' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadows/Westfield Village Sec 4' ,`TaxAmount` = '7094' ,`TaxRate` = '2.821' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294638' WHERE `Matrix_Unique_ID` = '212587623' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:29:58.190' ,`MLSNumber` = '76666367' ,`ListAgentFullName` = 'Jace Bowlin' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.983136' ,`Longitude` = '-95.166962' ,`PhotoCount` = '19' ,`PostalCode` = '77346' ,`RoomCount` = '3' ,`ListPrice` = '209990.00' ,`Status` = 'Active' ,`StreetName` = 'Wisteria Chase' ,`StreetNumber` = '7315' ,`StreetSuffix` = 'Place' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous mature tree in the front yard gives lots of shade on this beautiful brick one story 3 bedroom, 2 bathroom home located in the sought out Atasca Woods. Great locations with walking distance from Atascocita High School and tons of great restaurants. One entered into the home you will be greeted with tile flooring with a spacious living room with a fireplace. The kitchen is open to the living area equipped with stainless steel appliances (replace din 2020) and has a walk through to access the bedrooms. The primary bedroom is spacious with a great sized bathroom. The bathroom has dual sinks with separate tower and tub ready for you to relax. The backyard has ample space and is fully fenced (replaced in 2021) for your fur babies to run around and enjoy. Whether this is your first home or an investment property this home has everything you need. AC unit, Water heater and roof were replaced in 2022. Reach out and schedule a showing today.' ,`Acres` = '0.11' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 2 ATASCA WOODS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atasca Woods' ,`TaxAmount` = '3748' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294638' WHERE `Matrix_Unique_ID` = '212641363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:39:56.887' ,`MLSNumber` = '23936572' ,`ListAgentFullName` = 'Marichka Oldag' ,`ListOfficeName` = 'Watkins Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739836' ,`Longitude` = '-95.487389' ,`PhotoCount` = '34' ,`PostalCode` = '77057' ,`RoomCount` = '3' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Nantucket' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1934' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the Galleria OUTSTANDING AND FULLY UPDATED home with the yard UNDER $500k! \r\nThe finishes at this home are incredible! Contemporary home with the open floor plan full of natural light, private and fenced backyard, perfect location. Luxury LED lights through-out the house are complementing stylish and modern interior. Humungous primary bathroom with the double shower (free standing, glass door shower with the oversized topical shower heads), double sink with the led mirror. Sliding glass door to the backyard from the living room and primary bedroom, balcony on the second floor. Stunning LED hallway lights to a primary bedroom. Brand new roof, foundation was fixed before remodeling and house conveys with the warranty. Brand new cabinets, countertops, luxury carpet, bamboo wood water resistant flooring, new windows, new sheetrock, new balcony, all light and plumbing fixtures, tile... NO HOA!' ,`Acres` = '0.0948' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 99A BLK 5 .333000 INT COMMON LAND & ELE 2518 NANTUCKET T/' ,`LotDesciption` = 'Other' ,`LotSize` = '4130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Westhaven Estates Sec 01' ,`TaxAmount` = '8143' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294639' WHERE `Matrix_Unique_ID` = '212971808' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:45:54.133' ,`MLSNumber` = '35537525' ,`ListAgentFullName` = 'Ashton Ferrari' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743250' ,`Longitude` = '-95.505061' ,`PhotoCount` = '28' ,`PostalCode` = '77063' ,`RoomCount` = '15' ,`ListPrice` = '1055000.00' ,`Status` = 'Active' ,`StreetName` = 'Stoney Brook' ,`StreetNumber` = '2303' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4503' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is priced to sell. There will be no further reductions via MLS. HCAD appraised at 1.240M. Corner lot in Briarbend, 4 BD custom home w/ 2 kitchens, primary suite + in-law suite(w/ private driveway access), 2nd-floor game & 3-4 car garage or can be converted to home gym. Kitchen 1-island facing living room w/ custom built cabinetry, 4 burner electric top, & microwave drawer. Kitchen 2 - Wolf 4 Burners + Infrared Griddle, 2 convection ovens+commercial ventilation system. Living room offers custom built-ins, high ceilings w/ recessed lighting, fireplace & surround sound speakers w/ projector screen. Primary suite-cozy sitting area w/fireplace, built-in nooks, spa bathroom w/ heated controlled floors, separate vanities & designer closet. Home is equipped w/ water softener, vacuum system, surveillance system, skylights & large floored attic space w/ safe room. HOA provides courtesy patrol, trash/recycling & fun neighborhood events. All info per seller.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Charnwood/Briarbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 7 BRIARBEND' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarbend' ,`TaxAmount` = '27541' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294639' WHERE `Matrix_Unique_ID` = '213025761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:24:56.917' ,`MLSNumber` = '9124426' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.921403' ,`Longitude` = '-95.733629' ,`PhotoCount` = '27' ,`PostalCode` = '77433' ,`RoomCount` = '5' ,`ListPrice` = '890990.00' ,`Status` = 'Active' ,`StreetName` = 'Big Spring Park' ,`StreetNumber` = '15034' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4290' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 9124426 - Built by Highland Homes - December completion! ~ No Rear Neighbors - Backs to Water. Parkland Village / FINAL OPPORTUNITY FOR CY-FAIR ISD. New & Fresh Design Plan 224 M by Highland Homes! Soaring Ceilings, Natural Light & Functional Design. 2 Story, 4 Bed, 4 Bath, 3 Car features Upgraded Plank Tile Floors at Main Living Area & Study. Downstairs Media Room. Kitchen Opens to Family Room w/ Uppers & Silestone Quartz Counters! Spacious Primary Suite, Dual Vanities, Freestanding Tub & Large Shower. Expanded Bedrooms Upstairs w-Gameroom! Expanded Outdoor Living on Lot w Full Yard Sprinkler, 4 Sides, Brick & More. 2022 HERS Energy Rated = LOW Electric Bills! Built with the Quality & Craftsmanship you expect only in a Highland Home!!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23, Block 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8887' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.5724' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294639' WHERE `Matrix_Unique_ID` = '213042706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:28:42.500' ,`MLSNumber` = '22559337' ,`ListAgentFullName` = 'Mia Strnad' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.105699' ,`Longitude` = '-95.502261' ,`PhotoCount` = '8' ,`PostalCode` = '77389' ,`RoomCount` = '7' ,`ListPrice` = '169000.00' ,`Status` = 'Active' ,`StreetName` = 'Sitca' ,`StreetNumber` = '5402' ,`StreetSuffix` = 'Street' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION !!! One of the structures is leased till November 2023. Landlords and Investors galore. Property has great privacy in the backyard. Great for storage of equipment has plenty of space. Property has a big detached shed and separated garage that has lots storage space and unfinished attic. Amazing property !!!' ,`Acres` = '0.1653' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 FIVE OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Five Oaks' ,`TaxAmount` = '542' ,`TaxRate` = '2.124' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294639' WHERE `Matrix_Unique_ID` = '213309820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:08:15.210' ,`MLSNumber` = '3437465' ,`ListAgentFullName` = 'Darius Franklin' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = 'Paula McGann' ,`SellingOfficeName` = 'Target Realty, Inc.' ,`Latitude` = '29.954876' ,`Longitude` = '-95.437318' ,`PhotoCount` = '15' ,`PostalCode` = '77067' ,`RoomCount` = '7' ,`ListPrice` = '238800.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bartlett Cove' ,`StreetNumber` = '1219' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'First lived in at the end of 2003, this house has been upgraded and is ready for immediate occupancy. Its proximity to I-45 or the Beltway (less than 5 minutes to get on either) should make commuting much easier. Highlights: New flooring throughout the house, brand new stainless steel appliances, new vanity in second bathroom. LED lights everywhere and a jetted tub in the master. Take a look at the pictures...' ,`Acres` = '0.127' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 2 GREEN OAK PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5531' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SPENCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'PLUMMER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Green Oak Park Sec 02' ,`TaxAmount` = '6173' ,`TaxRate` = '2.9908' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294639' WHERE `Matrix_Unique_ID` = '213663625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:51:27.557' ,`MLSNumber` = '72562693' ,`ListAgentFullName` = 'David Hageman' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.980863' ,`Longitude` = '-95.710828' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '15' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Bellows Gate' ,`StreetNumber` = '13911' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tired of being cramped in a home too small for your family? Check out 4,169sf - 5 Bedrooms, 3.5 Baths, Family Room, Formal Dining, Formal Living, Home Office, Game Room & Media Room! This home is ready for a new family to love and is a “must-see”! The family chef will appreciate a kitchen boasting granite counters, a walk-in pantry, & 42” cabinets. Relax with your family in the large family room with windows overlooking your backyard and a remote-controlled gas log fireplace as the focal point. A sitting room at the front of the home is great for additional entertaining space or could be a second home office. Upstairs you will discover the home office, game room, and media room. The kiddos and pets will love having a backyard where they can play and you’ll love the producing peach trees. Relax on your covered patio. Enjoy the convenience of a great location within three minutes of Houston Premier Outlet, HEB, Kroger Marketplace & Loads of Restaurants. Seconds from HWY 290 & Grand Pkwy.' ,`Acres` = '0.1452' ,`Area` = '35' ,`BuilderName` = 'Long Lake' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 VILLAGES OF CYPRESS LAKES SEC 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'A ROBISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages/Cypress Lakes Sec 25' ,`TaxAmount` = '10524' ,`TaxRate` = '3.061' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294640' WHERE `Matrix_Unique_ID` = '213670952' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:24:03.567' ,`MLSNumber` = '85845383' ,`ListAgentFullName` = 'Adriana Evans' ,`ListOfficeName` = 'TWG Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946333' ,`Longitude` = '-95.129679' ,`PhotoCount` = '24' ,`PostalCode` = '77532' ,`RoomCount` = '3' ,`ListPrice` = '284000.00' ,`Status` = 'Active' ,`StreetName` = 'Deep Anchor' ,`StreetNumber` = '2827' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1795' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3/2 home on a corner lot located in shadow lake subdivision in Crosby near Lake Houston. Community offers amenities such as boat ramp, pool, playground and a tennis court. Home offers you an open concept with high ceilings allowing you plenty of space to entertain friends and family, as well plenty of space in the back yard to enjoy your morning coffee. Call for your private showing!' ,`Acres` = '0.1928' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 6 LAKE SHADOWS SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '127' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Shadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294640' WHERE `Matrix_Unique_ID` = '213765141' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:08:47.013' ,`MLSNumber` = '4369895' ,`ListAgentFullName` = 'Jean Jabbour' ,`ListOfficeName` = 'Jabbour Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526321' ,`Longitude` = '-95.731648' ,`PhotoCount` = '36' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Fuchsia' ,`StreetNumber` = '1006' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1915' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONBROOK PLANTATION SOUTH SEC 6, BLOCK 5, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8341' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonbrook Plantation South Sec 6' ,`TaxAmount` = '7710' ,`TaxRate` = '2.6948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294640' WHERE `Matrix_Unique_ID` = '213869798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:12:38.933' ,`MLSNumber` = '65894236' ,`ListAgentFullName` = 'Maria Rocha' ,`ListOfficeName` = 'Stoneburner & Associates ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064087' ,`Longitude` = '-95.512652' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairway Meadow' ,`StreetNumber` = '20518' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A hole in one! Stop your search now! This home is right on the golf course with backyard access to the favorited Wind Rose Golf Course. The kitchen, family room & primary bedroom look directly out onto the low maintenance backyard and stunning view. The large windows paired with high ceilings make this beautiful home so light and bright. The home features 3 bedrooms, 1 was being used as a media room and office and has recessed lighting and is wired for sound. The primary bedroom has an ensuite bathroom complete with dual vanities and sinks, walk in shower, jetted tub and walk in closet with built in drawers and shelving. The kitchen has ample storage, island cooktop, breakfast bar and looks out into the family room and once again the beautiful back yard, patio & golf course! Perfect for entertaining. Greenspace to the right of home means you don\'t have an immediate neighbor on your right. Annual HOA dues include mowing of the front yard. Schedule your private tour today!' ,`Acres` = '0.1512' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 PINELAKES PROMENADE 1 AMEND' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '6585' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1442' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENIGNUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinelakes Promenade 01 Amd' ,`TaxAmount` = '8192' ,`TaxRate` = '2.6765' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294640' WHERE `Matrix_Unique_ID` = '213881397' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213921599','1668294641','213921599','2022-11-12T00:20:55.687','76422601','Edward Cottrell','Texas United Realty','','','30.081659','-95.479037','31','77388','7','254900.00','Active','Mossy Place','4049','Lane','Spring','2','0','3','1428','Single-Family','Nice brick and siding home. Front porch for relaxing in courtyard. Tall 42\" custom cabinets. Gas Range/Oven, Microwave. Bright kitchen and dining room. Open concept living. Primary walk in closet. Nice soaker tub and separate shower. Attached two car garage with off-street two car driveway. Private fenced in back yard for out door grilling. This home is also on the market to lease, Lease will covey to new owner if leased prior to sale.','0.0934','14','','','Electric Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure,Tenant Occupied','1','','','Spring/Klein','Central Gas','1','LT 5 BLK 1 PARK AT MEADOWHILL RUN SEC 3','Patio Lot','4068','Appraisal District','','687','0','','2','Convection Oven,Gas Oven','0','','','Gas Range','','Composition','32 - Klein','ZWINK ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','SCHINDEWOLF INTERMEDIATE SCHOOL','Accompany,Appointment Required,Controlled Access','Appraisal District','1','Contemporary/Modern','Park/Meadowhill Run','4947','2.804','Public Sewer,Public Water','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213942331','1668294641','213942331','2022-11-12T00:20:55.343','55864337','Amy Dunlap','Abundant Living Real Estate','','','30.028394','-95.613173','0','77377','4','289900.00','Active','Innisfall','12203','Circle','Tomball','2','1','4','2379','Single-Family','','0.3974','35','','','','','Sellers Disclosure','','','1','Tomball South/Lakewood','Central Gas','1','LT 43 BLK 6 WESTBOURNE SEC 2','Cul-De-Sac,Subdivision Lot','17311','Appraisal District','','500','0','','3','','0','','','','','Composition','53 - Tomball','WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)','TOMBALL MEMORIAL H S','WILLOW WOOD JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Westbourne Sec 02','6382','2.5764','Water District','1993','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:12:25.487' ,`MLSNumber` = '35027329' ,`ListAgentFullName` = 'Jennifer Doring' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = 'Alain Bedos Towa Njankou' ,`SellingOfficeName` = 'Jerry Fullerton Realty, Inc.' ,`Latitude` = '30.000517' ,`Longitude` = '-95.791328' ,`PhotoCount` = '46' ,`PostalCode` = '77447' ,`RoomCount` = '13' ,`ListPrice` = '440000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hargrove' ,`StreetNumber` = '16202' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The stunning Faith floorplan by Infinity Classic Homes offers 4 bedrooms/3.5 baths/formal dining/home office/game room/3 car tandem garage! Large covered patio & oversized lot w/room for a pool! Upstairs game room overlooks family room. Upon entering the home you\'ll notice the stunning curb appeal w/a double door entry, grand staircase & soaring ceilings. Formal dining is to the left & home office is to the right. (Home office currently being used as 5th bedroom.) Continuing to the back of the home you\'ll find a large open concept family room, kitchen, & breakfast room. The primary bedroom is located at the back of the home with tray ceiling & en-suite with oversized walk-in closet. Upstairs is a split floorplan with 1 bedroom & bath to the right of the game room & 2 additional bedrooms w/Jack & Jill bath on the opposite side. Backyard shed & water softener to remain. Extra decked attic storage space is upstairs w/entry via the closet in the Jack & Jill bathroom.' ,`Acres` = '0.2662' ,`Area` = '25' ,`BuilderName` = 'Infinity Classic' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 STONE CREEK RANCH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11597' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas 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,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '10753' ,`TaxRate` = '3.1924' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294641' WHERE `Matrix_Unique_ID` = '214302442' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214314539','1668294641','214314539','2022-11-11T23:23:54.423','75663926','Joseph Landes','Directed Realty LLC','','','29.575879','-95.039830','7','77586','8','279000.00','Active','Bayview','523','Drive','El Lago','2','0','3','1880','Single-Family','This lovely house located in a quiet and friendly neighborhood has lots to offer, and can be yours if you hurry!! It comes with 3 beds, 2 full baths, 2 car garage, a formal dining room, a breakfast room, and a formal dining room. The social areas will capture your attention with a high ceiling and large windows with views of the front yard that allow a lot of natural light. The kitchen offers lots of cabinets and counter space, plus easy flow from the breakfast room to the formal dining. The primary room comes with his and hers closet and a primary bath. The family can enjoy three large bedrooms and a den with a lovely fireplace that all the family can love. Don’t miss any memories in this large backyard with your own covered deck, which is great for entertaining. Also, AWESOME CCISD Schools. This is a charming home. DON\'T DELAY!!','0.2014','7','','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Clear Lake Area','Central Electric','1','LT 13 BLK 5 EL LAGO ESTATES SEC 6','Cleared,Subdivision Lot','8774','Appraisal District','','200','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','9 - Clear Creek','ED H WHITE ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','El Lago Estates','5975','2.6666','Public Sewer,Public Water,Water District','1964','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:27:22.680' ,`MLSNumber` = '92839067' ,`ListAgentFullName` = 'Vicki Warren' ,`ListOfficeName` = 'MBA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.554046' ,`Longitude` = '-95.708722' ,`PhotoCount` = '50' ,`PostalCode` = '77469' ,`RoomCount` = '11' ,`ListPrice` = '549990.00' ,`Status` = 'Active' ,`StreetName` = 'Watermoon Trail' ,`StreetNumber` = '1222' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3773' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the exclusive, gated enclave of \"RIVERCHASE\", this HIGHLY SOUGHT-AFTER LAKEFRONT/GREENBELT BEAUTY is one of only a few built by WESTIN, recognized for high quality, superior architectural design & attention to detail. RARE, SPACIOUS floor plan features a 2-STY. entry w/stately columns & art niches, home office, formal dining w/wine bar. Extensive tile flooring opens to the ENORMOUS 2-STY. FAMILY room w/22’ SOARING CEILINGS & WINDOWS GALORE. Spacious kitchen w/GRANITE counters, 8FT. island & high-top bar. Sweeping staircase leads to HUGE gameroom & 4 ADDIT. OVERSIZED bedrooms, including a 2ND ENSUITE w/INCREDIBLE VIEWS! New carpeting, door & UPDATED VANITIES in the Jack N\' Jill bath. LAKE, SPRAY FOUNTAIN (lit at night) & GREENBELT VIEWS behind the home! HOA clubhouse, fitness center, Jr. Olympic pool & children\'s wading pools, tennis, basketball & sand volleyball courts, park/playground & trails. Excellent LCISD schools. EASY ACCESS TO 59. ZONED TO TOP-RATED LCISD SCHOOLS !!' ,`Acres` = '0.1763' ,`Area` = '30' ,`BuilderName` = 'WESTIN' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON LAKES AT THE BRAZOS SEC 1, BLOCK 3, LOT 41' ,`LotDesciption` = 'Greenbelt,Water View,Waterfront' ,`LotSize` = '7681' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1036' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lakes At The Brazos' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294641' WHERE `Matrix_Unique_ID` = '214443229' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:12:34.067' ,`MLSNumber` = '62205813' ,`ListAgentFullName` = 'Holly Grajales' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.443815' ,`Longitude` = '-95.456162' ,`PhotoCount` = '35' ,`PostalCode` = '77378' ,`RoomCount` = '4' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Buffalo' ,`StreetNumber` = '5453' ,`StreetSuffix` = 'Circle' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step into this stunning, completely updated 3 bed, 2.5 bath home! Enjoy the open floor plan with high-end finishes. Designer, handpicked lighting & plumbing fixtures in black throughout the house, including the ceiling fans! The kitchen has been updated with white quartz countertops & a gorgeous white backsplash. Stainless steel appliances including range, microwave & dishwasher. The kitchen is open to the living room, great for entertaining. Windows galore, giving plenty of natural light. Flooring is upgraded in luxury vinyl plank in the main areas & contemporary tile in the upstairs bathrooms. Plush carpeting in the bedrooms. Walk upstairs to the primary bedroom & you will love your spectacular walk-in shower! It has all of the modern upgrades that give it a spa-like feeling. The interior has been freshly painted. A new HVAC system was recently installed. The fenced-in backyard is spacious, perfect for outdoor activities & barbecues. You will love the modern appeal of this home!' ,`Acres` = '0.149' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CADDO VILLAGE, LOT 107' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6489' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Caddo Village' ,`TaxAmount` = '3233' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294641' WHERE `Matrix_Unique_ID` = '214581458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:34:01.280' ,`MLSNumber` = '93259829' ,`ListAgentFullName` = 'Melissa Orr' ,`ListOfficeName` = 'Coldwell Banker The Ron Brown' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.890000' ,`Longitude` = '-96.998380' ,`PhotoCount` = '28' ,`PostalCode` = '77904' ,`RoomCount` = '3' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Arabian' ,`StreetNumber` = '101' ,`StreetSuffix` = 'Drive' ,`City` = 'Victoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss the opportunity to own this immaculate 3bd 2 ba home that features an open concept living area with a beautiful updated kitchen. Featuring granite countertops, ample counter space, and recently painted cabinets. Wood look ceramic tile flooring in the living room and kitchen. New AC installed 2 years ago and a new roof was installed 5 years ago.' ,`Acres` = '0.2334' ,`Area` = '66' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BRIDLE RIDGE VI BLOCK 13 LOT 26' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10167' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '191 - Victoria' ,`SchoolElementary` = 'VICKERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VICTORIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'HAROLD CADE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridle Ridge VI' ,`TaxAmount` = '5565' ,`TaxRate` = '2.3976' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294641' WHERE `Matrix_Unique_ID` = '214664576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:15:20.610' ,`MLSNumber` = '39945125' ,`ListAgentFullName` = 'David Chen' ,`ListOfficeName` = 'Intercity Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813133' ,`Longitude` = '-95.759151' ,`PhotoCount` = '43' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Guston Hall' ,`StreetNumber` = '22326' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New remodeled home located in a great location&neighbourhood, fresh paint wall and all doors, new vinyl floor throughout the house, 4 beds 2 baths, schedule your tour today!' ,`Acres` = '0.1263' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 4 LAKES AT MASON PARK SEC 1 AMEND' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MORTON RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakes/Mason Park' ,`TaxAmount` = '5800' ,`TaxRate` = '2.8233' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668294642' WHERE `Matrix_Unique_ID` = '214672040' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:36:16.387' ,`MLSNumber` = '75123042' ,`ListAgentFullName` = 'Nelson Escobar' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998102' ,`Longitude` = '-95.715277' ,`PhotoCount` = '31' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '297000.00' ,`Status` = 'Active' ,`StreetName` = 'Midnight Glen' ,`StreetNumber` = '19235' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning one story home in Cypress Landing subdivision! The tile floored kitchen features granite countertops and stainless steel appliances with a pantry that was recently converted to a walk-in for extra storage. The spacious office area includes custom built shelving. This home comes equipped with a Nest smart thermostat, Ring camera doorbell and keypad entry to the front door! \n\nThis home never flooded during the Tax Day Flood nor did it flood during Hurricane Harvey. There is a small greenbelt separating the backyard from the subdivision behind the home. The community offers a peaceful lake with a walking and running path, and an outdoor pool. 7 minutes to HEB, Krogers, and Costco! Department stores, restaurants, and the Premium Outlet mall are about 10 minutes away. Easy access to 290 and 99. What a great location and an even better home! This house won\'t be on the market for long!' ,`Acres` = '0.1281' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 CYPRESS LANDING EAST SEC 7' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '764' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KEITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Lndg East' ,`TaxAmount` = '5763' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294642' WHERE `Matrix_Unique_ID` = '214673851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:10:06.777' ,`MLSNumber` = '9998089' ,`ListAgentFullName` = 'Whitney Sodders' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.473470' ,`Longitude` = '-95.671151' ,`PhotoCount` = '35' ,`PostalCode` = '77356' ,`RoomCount` = '3' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Redwood' ,`StreetNumber` = '15612' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SHOWINGS BEGIN 11/13/2022. This new build home is located in the Hidden Forest neighborhood of Sam Houston National Forest. This new, cozy home is a great place to get away from it all & call home, but still be close enough to enjoy the city amenities of Montgomery, TX. This quaint 3 bed, 2 bath home has an oversized primary bedroom w/ walk in closet, tile flooring throughout main areas & carpeting in the bedrooms. The kitchen boasts ample granite countertop space to entertain those special moments w/ friends or family! The fully sodded lawn provides plenty of space to relax on the front porch. Other features include high ceilings & efficient appliances. Stove/range & dishwasher INCLUDED. With ample parking in the double wide driveway just outside the front door for guests and your vehicle makes it easy to get around town quickly & conveniently. W/ high efficiency appliances, HVAC & windows, this house can provide everything you need when looking for a quiet community to call home!' ,`Acres` = '0.132' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S580304 - HIDDEN FOREST EST 04, LOT 181' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '136' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Forest Estate' ,`TaxAmount` = '3131' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294642' WHERE `Matrix_Unique_ID` = '214679692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:35:43.800' ,`MLSNumber` = '66127618' ,`ListAgentFullName` = 'Lidia Tripputi' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.878366' ,`Longitude` = '-95.421300' ,`PhotoCount` = '6' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Randolph' ,`StreetNumber` = '910' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SCHEDULE A TOUR WITH YOUR REALTOR TO SEE THIS CHARMING HOME. APPLIANCES AND SOME FURNITURE ARE FOR SALE.' ,`Acres` = '0.1887' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 379 BLK 22 LINCOLN CITY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OSBORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lincoln City 3' ,`TaxAmount` = '3711' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294642' WHERE `Matrix_Unique_ID` = '214682543' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:21:49.770' ,`MLSNumber` = '54208002' ,`ListAgentFullName` = 'Dao Vo' ,`ListOfficeName` = 'Intercontinental Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968069' ,`Longitude` = '-95.393783' ,`PhotoCount` = '15' ,`PostalCode` = '77073' ,`RoomCount` = '9' ,`ListPrice` = '288000.00' ,`Status` = 'Active' ,`StreetName` = 'Ranch View' ,`StreetNumber` = '18439' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Big House, Big extra lot free use. Inside many rooms. Down stair tile, Up stair carpet. House with Refrigerator , washer/dryer.....Sell fast' ,`Acres` = '0.1085' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 REMINGTON CREEK RANCH SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Crk Ranch Sec 1' ,`TaxAmount` = '5813' ,`TaxRate` = '2.8445' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668294643' WHERE `Matrix_Unique_ID` = '214683004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:13:16.403' ,`MLSNumber` = '53528338' ,`ListAgentFullName` = 'Harry Montecinos' ,`ListOfficeName` = 'Shanni Lo' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741442' ,`Longitude` = '-95.564813' ,`PhotoCount` = '25' ,`PostalCode` = '77042' ,`RoomCount` = '8' ,`ListPrice` = '484900.00' ,`Status` = 'Active' ,`StreetName` = 'Burgoyne' ,`StreetNumber` = '10627' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2231' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly remodeled 4-bedroom, 2-bathroom home in Walnut Bend. This remodeled home includes new paint in and out, new flooring and fixtures, new windows, new roof, new ceiling fans in each bedroom, electrical panel and a new water heater. Quartz countertops with great looking tile and backsplash that brings the whole look together. Also, items that have been upgraded recently are the HVAC system, plumbing, the drive way, and transferable warranty for the foundation. This home is a complete turnkey home.' ,`Acres` = '0.2223' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 6 WALNUT BEND SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9683' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Bend Sec 02' ,`TaxAmount` = '7175' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294643' WHERE `Matrix_Unique_ID` = '214683360' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:45:23.540' ,`MLSNumber` = '41310057' ,`ListAgentFullName` = 'Jean Jabbour' ,`ListOfficeName` = 'Jabbour Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.686280' ,`Longitude` = '-95.673921' ,`PhotoCount` = '0' ,`PostalCode` = '77083' ,`RoomCount` = '4' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Soledad' ,`StreetNumber` = '8230' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautifully remodeled house, walking distance to school, with all new roof 2022, 2 new exterior AC units, new tile floors, updated bathrooms, new paint, new fence, new quartz countertops, new appliances, all you wish in a house' ,`Acres` = '0.1494' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION GLEN ESTATES SEC 6, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Glen Estates Sec 6' ,`TaxAmount` = '5890' ,`TaxRate` = '2.2857' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294643' WHERE `Matrix_Unique_ID` = '214683485' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:26:46.380' ,`MLSNumber` = '35864702' ,`ListAgentFullName` = 'Wenjie Wang' ,`ListOfficeName` = 'Sunet Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773595' ,`Longitude` = '-95.899353' ,`PhotoCount` = '32' ,`PostalCode` = '77423' ,`RoomCount` = '4' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'White Birch' ,`StreetNumber` = '1001' ,`StreetSuffix` = 'Lane' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely 2-story house is located in Kingsland Heights community, Waller County, located in Katy and just off I-1 0. Get readyto wake up to stainless steel appliances, granite countertops and your own private backyard. Gorgeous kitchen and island for home party! The Master Suite is located upstairs and away from the noisy first floor, making it the perfect place to relax and unwind! Covered patio for weekend BBQ. You will love all Kingsland Heights community offers! Conveniently located near I-10, you have easy access to restaurants, shopping and nightlife in Houston.' ,`Acres` = '0.2479' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S556300 KINGSLAND HEIGHTS SECTION 1 BLK 3 LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingsland Heights Sec 1' ,`TaxAmount` = '9976' ,`TaxRate` = '3.2993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294643' WHERE `Matrix_Unique_ID` = '214683487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T23:57:34.753' ,`MLSNumber` = '84037063' ,`ListAgentFullName` = 'Raul Quintanilla' ,`ListOfficeName` = 'Jose Garza Agency' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341906' ,`Longitude` = '-95.285905' ,`PhotoCount` = '6' ,`PostalCode` = '77328' ,`RoomCount` = '4' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Walker' ,`StreetNumber` = '2547' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '2.27' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0088 - BARTON H, TRACT 11, ACRES 2.27' ,`LotDesciption` = 'Cleared' ,`LotSize` = '98881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hail Barton Surv Abs # 88' ,`TaxAmount` = '2877' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294643' WHERE `Matrix_Unique_ID` = '214683592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T00:43:11.880' ,`MLSNumber` = '94206950' ,`ListAgentFullName` = 'Teri Le' ,`ListOfficeName` = 'B & W Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.117688' ,`Longitude` = '-95.364718' ,`PhotoCount` = '35' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '699800.00' ,`Status` = 'Active' ,`StreetName` = 'Steep Woods' ,`StreetNumber` = '4006' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated seller, any offer is considered! Prestigious Woodson\'s Reserve offers this stunning and impeccable BEAUTIFUL PERRY HOME with endless features. From nature light to open floor plan and beautiful thought-out details. Mahogany front door. Two-story entry with 19-foot ceiling. Library with French doors and formal dining room, both with hardwood floors. Two-story family room with ceramic tile floor, a wall of windows and wood mantel fireplace. Kitchen features island with built-in seating space, walk-in pantry and butler\'s pantry. Double door entry to master bath with a garden tub, separate glass enclosed shower, dual vanities and spacious walk-in closet with access to utility room. BONUS-3 car garage with epoxy flooring and 220 outlets.' ,`Acres` = '0.189' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSON\'S RESERVE 02, BLOCK 1, LOT 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8234' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodsons Reserve 02' ,`TaxAmount` = '15501' ,`TaxRate` = '3.0987' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294644' WHERE `Matrix_Unique_ID` = '214683599' --> Updated record success