Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:12:21.947' ,`MLSNumber` = '92974933' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = 'Joshua Garza' ,`SellingOfficeName` = 'Apex Brokerage, LLC' ,`Latitude` = '29.823110' ,`Longitude` = '-94.833810' ,`PhotoCount` = '22' ,`PostalCode` = '77523' ,`RoomCount` = '7' ,`ListPrice` = '388990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Red River' ,`StreetNumber` = '13910' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Premium cul-de-sac homesite with No Back Neighbors** The Perry plan is a two-story home featuring 4 bedrooms, 2.5 baths, and 2 car garage. The foyer opens to a study and powder bath with linen closet. Center kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry. Open concept floorplan boasts large combined family room and dining area. Extra storage space under the stairs is a plus. The private primary suite with attractive primary bath features dual vanities, water closet and his and hers walk-in closets. A versatile gameroom greets you at the top of the stairs and opens to three additional bedrooms and bath. The standard rear covered patio is located off the family room.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '09/01/05' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7266' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Farms' ,`TaxAmount` = '' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704500' WHERE `Matrix_Unique_ID` = '203896033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:37:14.837' ,`MLSNumber` = '66437383' ,`ListAgentFullName` = 'Joan Imperato' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026616' ,`Longitude` = '-95.158202' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '14' ,`ListPrice` = '1399000.00' ,`Status` = 'Active' ,`StreetName` = 'Kings River Point' ,`StreetNumber` = '21110' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A stunning estate home custom built by Sugar Creek Homes in the exclusive gated community of the Lakes at Kings River Estates*Elegantly set on a 1.061 acre lot, professionally landscaped and maintained* Many opportunities for family fun and entertaining in the fabulous yard with pool, spa & summer kitchen*Magnificently appointed with extensive moldings, trim, granite counters, wood & travertine flooring*The kitchen is a cook\'s dream w/upscale appliances, a built-in refrigerator, double ovens & 2 dishwashers*The comfortably elegant open concept plan features an oversized living area, study, breakfast room, dining room and primary suite*The second floor features a spacious gameroom with 4 more large bedrooms*Monier Life tile roof* Icynene spray foam insulation*Easy access to Hwy 59, either via W Lake Houston Pkwy North to Kingwood Drive West or Lake Houston Pkwy South to FM 1960 East*Remediation and Refurbishing information available*A GEM' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Sugar Creek' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 KINGS RIVER ESTATES' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '46217' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Kings River Estates' ,`TaxAmount` = '21848' ,`TaxRate` = '2.43908' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704501' WHERE `Matrix_Unique_ID` = '205718740' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:03:46.600' ,`MLSNumber` = '81560458' ,`ListAgentFullName` = 'Frank Thomas' ,`ListOfficeName` = 'Realty Executives' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697920' ,`Longitude` = '-95.583623' ,`PhotoCount` = '16' ,`PostalCode` = '77072' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Triola' ,`StreetNumber` = '11614' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1682' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recent complete remodel of 3 bedroom / 2 bath home in 2018. Open Concept with granite kitchen countertop, spacious bedrooms, updated bathrooms, new flooring and paint. Location is close access to Westpark Tollway and Sam Houston Parkway.' ,`Acres` = '0.1389' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 35 BLK 13 BELLAIRE WEST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'MARTIN ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'KILLOUGH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Split Level' ,`Subdivision` = 'Bellaire West' ,`TaxAmount` = '3302' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704501' WHERE `Matrix_Unique_ID` = '207499841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:33:45.837' ,`MLSNumber` = '24774522' ,`ListAgentFullName` = 'Andrea Kitzmann' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.699502' ,`Longitude` = '-95.608244' ,`PhotoCount` = '21' ,`PostalCode` = '77340' ,`RoomCount` = '7' ,`ListPrice` = '263265.00' ,`Status` = 'Active' ,`StreetName` = 'Pecos' ,`StreetNumber` = '220' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bed, 2 bath home in Rockbridge from DR Horton! Beautifully constructed, the Fargo offers an open concept floor plan with a spacious living room open to the kitchen, dining area, walk-in closets in 3 beds, and much more. Enjoy cooking in the gourmet kitchen featuring granite counters, dark cabinetry, eating bar, pantry, and stainless appliance package. Escape to the master suite with oversized shower, dual sinks, and huge walk-in closet. Smart home features include Amazon Echo, Amazon Echo Dot, 7” HD touchscreen security control panel, video doorbell, programmable thermostat, and smart lights at the front entry. Extras you don’t want to miss include vinyl flooring throughout common areas, covered patio, sprinklers, and so much more! Conveniently located just minutes to Sam Houston State University, a quick jaunt to the heart of Huntsville, and an easy commute to Lake Livingston, Bryan/College Station, and the Houston Metro areas. Ready for Fall 2022 move-in!' ,`Acres` = '0.142' ,`Area` = '43' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ROCKBRIDGE SUBD PHASE 3, BLOCK 11, LOT 15, ACRES 0.142' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6185' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rockbridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704501' WHERE `Matrix_Unique_ID` = '207622095' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T17:35:12.397' ,`MLSNumber` = '69191640' ,`ListAgentFullName` = 'Stephanie Le' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.581164' ,`Longitude` = '-95.214686' ,`PhotoCount` = '20' ,`PostalCode` = '77089' ,`RoomCount` = '6' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Nicoles Place Trail' ,`StreetNumber` = '10619' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, well constructed, spacious J Patrick Home with 2 PRIMARY BEDROOMS, one on main level and one upstairs. Both have double sinks with tub and shower combo, with large walk in closets. It has an impressive two story high ceiling entryway and living room. Owner replaced floor with premium and durable luxury vinyl flooring on main level. Other features include tall windows, lots of natural lighting, efficient and open floor plan. Media room AND Game room are located upstairs, along with spacious bedrooms. Pool table, ring security system, nest thermostat and custom curtains are included. Spacious backyard for your own retreat. This home is located in a quiet neighborhood and zoned to wonderful CCISD schools. This home is MOVE IN READY!!' ,`Acres` = '0.234' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 MEADOWS OF CLEAR CREEK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '262' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEBER ELEMENTARY' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadows/Clear Crk Sec 04' ,`TaxAmount` = '8781' ,`TaxRate` = '2.524' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704501' WHERE `Matrix_Unique_ID` = '207826300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:45:41.120' ,`MLSNumber` = '63034377' ,`ListAgentFullName` = 'Bob Burkhalter' ,`ListOfficeName` = 'Texas Lake & Country Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.685261' ,`Longitude` = '-95.167865' ,`PhotoCount` = '22' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '134500.00' ,`Status` = 'Active' ,`StreetName` = 'Hideaway' ,`StreetNumber` = '200' ,`StreetSuffix` = 'Trail' ,`City` = 'Coldspring' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escaped from the city at this Cottage near Lake Livingston. This one bedroom one bath home is in a Deed restricted neighborhood within walking distance of the lake.' ,`Acres` = '0.241' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'HOLIDAY SHORES SUB 1, BLOCK 7, LOT 8, SECTION 2, ACRES .241' ,`LotDesciption` = 'Other' ,`LotSize` = '10498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holiday Shores Sub 1' ,`TaxAmount` = '1218' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704501' WHERE `Matrix_Unique_ID` = '208164074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:34:04.790' ,`MLSNumber` = '33389628' ,`ListAgentFullName` = 'Andrea Kitzmann' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.699853' ,`Longitude` = '-95.608255' ,`PhotoCount` = '22' ,`PostalCode` = '77340' ,`RoomCount` = '7' ,`ListPrice` = '264015.00' ,`Status` = 'Active' ,`StreetName` = 'Pecos' ,`StreetNumber` = '228' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bed, 2 bath home in Rockbridge from DR Horton! Beautifully constructed, the Fargo offers an open concept floor plan with a spacious living room open to the kitchen, dining area, walk-in closets in 3 beds, and much more. Enjoy cooking in the gourmet kitchen featuring granite counters, white cabinetry, eating bar, pantry, and stainless appliance package. Escape to the master suite with oversized shower, dual sinks, and huge walk-in closet. Smart home features include Amazon Echo, Amazon Echo Dot, 7” HD touchscreen security control panel, video doorbell, programmable thermostat, and smart lights at the front entry. Extras you don’t want to miss include vinyl flooring throughout common areas, covered patio, sprinklers, and so much more! Conveniently located just minutes to Sam Houston State University, a quick jaunt to the heart of Huntsville, and an easy commute to Lake Livingston, Bryan/College Station, and the Houston Metro areas. Ready for Fall 2022 move-in!' ,`Acres` = '0.142' ,`Area` = '43' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ROCKBRIDGE SUBD PHASE 3, BLOCK 11, LOT 19, ACRES 0.142' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6185' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rockbridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704501' WHERE `Matrix_Unique_ID` = '208546998' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:33:13.590' ,`MLSNumber` = '23276608' ,`ListAgentFullName` = 'Andrea Kitzmann' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.699853' ,`Longitude` = '-95.608255' ,`PhotoCount` = '22' ,`PostalCode` = '77340' ,`RoomCount` = '7' ,`ListPrice` = '263565.00' ,`Status` = 'Active' ,`StreetName` = 'Pecos' ,`StreetNumber` = '236' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bed, 2 bath home in Rockbridge from DR Horton! Beautifully constructed, the Fargo offers an open concept floor plan with a spacious living room open to the kitchen, dining area, walk-in closets in 3 beds, and much more. Enjoy cooking in the gourmet kitchen featuring granite counters, dark cabinetry, eating bar, pantry, and stainless appliance package. Escape to the master suite with oversized shower, dual sinks, and huge walk-in closet. Smart home features include Amazon Echo, Amazon Echo Dot, 7” HD touchscreen security control panel, video doorbell, programmable thermostat, and smart lights at the front entry. Extras you don’t want to miss include vinyl flooring throughout common areas, covered patio, sprinklers, and so much more! Conveniently located just minutes to Sam Houston State University, a quick jaunt to the heart of Huntsville, and an easy commute to Lake Livingston, Bryan/College Station, and the Houston Metro areas. Ready for Winter 2022 move-in!' ,`Acres` = '0.143' ,`Area` = '43' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ROCKBRIDGE SUBD PHASE 3, BLOCK 11, LOT 23, ACRES 0.143' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6229' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rockbridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704501' WHERE `Matrix_Unique_ID` = '208566211' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:43:13.003' ,`MLSNumber` = '40496808' ,`ListAgentFullName` = 'Ginger Mashburn' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841352' ,`Longitude` = '-94.385463' ,`PhotoCount` = '19' ,`PostalCode` = '77665' ,`RoomCount` = '3' ,`ListPrice` = '140000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake' ,`StreetNumber` = '119' ,`StreetSuffix` = 'Drive' ,`City` = 'Winnie' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home sits on a corner lot in a beautiful location. Across the street is a small community Lake. The home needs some tender loving care but has so much potential.Tile and laminate flooring can be found throughout the home. It is being sold below tax value. There is a nice sized storage shed and the back yard is fenced. Priced to sell well below tax value!' ,`Acres` = '0.4821' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'N/2 LT 32 & LT 33 NORTH LAKE 50X210 FLOODED' ,`LotDesciption` = 'Corner' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '18 - East Chambers' ,`SchoolElementary` = 'EAST CHAMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EAST CHAMBERS HIGH SCHOOL' ,`SchoolMiddle` = 'EAST CHAMBERS J H' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Lake Add' ,`TaxAmount` = '2923' ,`TaxRate` = '2.1546' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704502' WHERE `Matrix_Unique_ID` = '208970913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:10:34.810' ,`MLSNumber` = '49884297' ,`ListAgentFullName` = 'William Shipman' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809748' ,`Longitude` = '-94.990062' ,`PhotoCount` = '7' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '259990.00' ,`Status` = 'Active' ,`StreetName` = 'Mohegan' ,`StreetNumber` = '4731' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2269' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a spacious home in an established neighborhood, come see this one! Large corner lot with a big master bedroom downstairs, huge game room on the second floor + 2 secondary bedrooms. Great location & highly rated schools, in addition to community pool and park! Easy access to major highways, shopping and restaurants. Come give some TLC to this loving home & make it yours!!' ,`Acres` = '0.2083' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 MEADOW LAKE SEC 5' ,`LotDesciption` = 'Corner' ,`LotSize` = '9074' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Lake Sec 05' ,`TaxAmount` = '5995' ,`TaxRate` = '2.755' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704502' WHERE `Matrix_Unique_ID` = '209008783' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:38:21.493' ,`MLSNumber` = '19917779' ,`ListAgentFullName` = 'Isac George' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748362' ,`Longitude` = '-95.328654' ,`PhotoCount` = '28' ,`PostalCode` = '77011' ,`RoomCount` = '6' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Super' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new construction on East End near downtown Houston. House is currently under construction. Area is being revitalized with many new constructions/rehab. House offers 3 bedrooms, 3.5 bathrooms, with 2 car attached garage. Features are custom wood cabinets, quartz counter tops, primary bathroom with free standing tub and separate shower, along with double sink vanity. Primary bedroom also offers walk in closet. Utility room upstairs near all bedrooms. Complete house is wired video cameras and termite/pest control system. Please note that pictures are for sample only. Exact colors and finishes may vary.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'East End Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 Super Duper Place' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Split Level,Traditional' ,`Subdivision` = 'Super Duper Place' ,`TaxAmount` = '783' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704502' WHERE `Matrix_Unique_ID` = '209037562' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:38:04.053' ,`MLSNumber` = '38473998' ,`ListAgentFullName` = 'Isac George' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731008' ,`Longitude` = '-95.321182' ,`PhotoCount` = '27' ,`PostalCode` = '77023' ,`RoomCount` = '6' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Jefferson' ,`StreetNumber` = '5317' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new construction on East End area. Very close to downtown Houston. House is currently under construction. Area is being revitalized with many new constructions/rehab. House offers 3 bedrooms, 3.5 bathrooms, with 2 car attached garage. Features are custom wood cabinets, quartz counter tops, primary bathroom with free standing tub and separate shower, along with double sink vanity. Primary bedroom also offers walk in closet. Utility room upstairs near all bedrooms. Complete house is wired video cameras and termite/pest control system. Pictures are for sample purpose only. Colors and finishes may vary.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Alta Vista Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 Jefferson Luxury Homes' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2818' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CARRILLO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Split Level,Traditional' ,`Subdivision` = 'Jefferson Luxury Homes' ,`TaxAmount` = '783' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704502' WHERE `Matrix_Unique_ID` = '209043479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:06:41.893' ,`MLSNumber` = '22981157' ,`ListAgentFullName` = 'Michael Parker' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.538548' ,`Longitude` = '-95.085890' ,`PhotoCount` = '43' ,`PostalCode` = '77058' ,`RoomCount` = '9' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Upper Bay' ,`StreetNumber` = '18706' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to wonderfully unique 18706 Upper Bay! This elevated home features a gorgeous water view! The custom kitchen is designed for the chef in mind with professional appliances, oversized stove with 2 ovens, 5 burner stove, vent hood to match. Tons of kitchen storage, built-in spice racks and pull out shelves. Granite countertops, , island, and soft closing cabinets and drawers. 4 bdrms plus a well-lit sunroom/ game room w/ skylights that looks out to patio deck & overlooks the beautiful pool & backyard. Cozy master bath includes his & hers sinks. All windows are Low-E tinted w/ lifetime warranty. Imagine the possibilities with 3000 feet paved and enclosed garages with 3 double garage doors w/ openers and 5 passage doors. Many updates include, new roof June/2022 50-year shingles with 7-year manufactures certificate, plumbing and electrical. Zoned to highly recommended CCISD! Minutes away from Johnson Space Center, Kemah Boardwalk, walking trails, dog parks & so much more!' ,`Acres` = '0.2204' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3O NASSAU BAY SEC 8' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nassau Bay Sec 08' ,`TaxAmount` = '8737' ,`TaxRate` = '2.4882' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704502' WHERE `Matrix_Unique_ID` = '209172547' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T17:12:25.610' ,`MLSNumber` = '84428996' ,`ListAgentFullName` = 'Erin Picou' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405694' ,`Longitude` = '-95.050314' ,`PhotoCount` = '36' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '374900.00' ,`Status` = 'Active' ,`StreetName` = 'Jetty Cove' ,`StreetNumber` = '12616' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*SELLER WILL PAY ONE (1) POINT!* towards loan.\r\nbright and cozy home is in the gated section of Lago Mar & sits on one of the largest lots in the community 1/3 acre w/ sprinkler system & gutters. Space for pets, kids and pool.\r\nUpgrades throughout , a coastal vibe, large kitchen open to the family room & formal dining area. Large windows in the family room add plenty of natural light. High ceilings, upgraded ceiling and wall features, quartz countertops, large island & covered back porch that is outdoor-kitchen-ready make this open-concept home perfect for entertaining. Master bedroom features spacious walk-in closet. The en-suite features dual vanities, soaker tub & stand-alone shower. Ceiling fans in all bedrooms. \r\nThis home is in the master planned community of Lago Mar, home to Texas’ largest crystal lagoon! The 12-acre Crystal lagoon and by white sandy beaches. \r\nThe community amenities to include a clubhouse, golf cart paths, fitness center, splash pad playground.' ,`Acres` = '0.3033' ,`Area` = '33' ,`BuilderName` = 'Castle Rock' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18 BLK 1 LAGO MAR POD 7 SEC 5 (2018) ABST 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13210' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Ranch' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '10423' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704502' WHERE `Matrix_Unique_ID` = '209299041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:06:50.347' ,`MLSNumber` = '18271914' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Emmanuel Nnabuo' ,`SellingOfficeName` = 'NB Elite Realty' ,`Latitude` = '29.683939' ,`Longitude` = '-95.835741' ,`PhotoCount` = '28' ,`PostalCode` = '77406' ,`RoomCount` = '16' ,`ListPrice` = '587836.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Alina Brook' ,`StreetNumber` = '10731' ,`StreetSuffix` = 'Trace' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation G) CURRENTLY BEING BUILT. Two story. 4 bedrooms, 3.5 baths. Primary suite downstairs with large walk in closet. Formal Living/Study and Dining room. Spacious island kitchen with breakfast area open to Family room. Game Room upstairs with Media room. Covered patio and 2 car attached garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '0.1413' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6155' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704502' WHERE `Matrix_Unique_ID` = '209311136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:44:22.250' ,`MLSNumber` = '60869534' ,`ListAgentFullName` = 'Samer Derawi' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771240' ,`Longitude` = '-95.862070' ,`PhotoCount` = '41' ,`PostalCode` = '77494' ,`RoomCount` = '5' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Crosby Sky' ,`StreetNumber` = '1110' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4940' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 1110 Crosby Sky Court! This stunning home sits on a spacious 11,210 sq/ft lot and offers 4,940 sq/ft of living space with 5 bedrooms, 4 and a half bathrooms, sits on a quiet street with beautiful landscaping, brick and stone exterior, and all zoned to Katy ISD! You\'ll love the incredible features this home has to offer including a huge primary suite, spacious living room with cozy fireplace, extra-large kitchen island, upstairs game room, private home office, fully fenced backyard with open patio, and so much more! Anserra is minutes from IH-10 and HWY 90 - in an excellent location! Schedule your private showing today!' ,`Acres` = '0.2573' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ANSERRA SEC 3, BLOCK 2, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11210' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '963' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anserra' ,`TaxAmount` = '13222' ,`TaxRate` = '3.2845' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704502' WHERE `Matrix_Unique_ID` = '209453257' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:22:08.647' ,`MLSNumber` = '62561648' ,`ListAgentFullName` = 'Michelle Carruthers' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Angelica Flournoy' ,`SellingOfficeName` = 'Redfin Corporation' ,`Latitude` = '30.462215' ,`Longitude` = '-95.571253' ,`PhotoCount` = '47' ,`PostalCode` = '77318' ,`RoomCount` = '5' ,`ListPrice` = '479900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Jamaica' ,`StreetNumber` = '15191' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic & Gorgeous. This timeless home is located on over 1/2 acre in a Lake Conroe waterfront community! The warm and inviting front porch leads you into the stunning 5 bedroom, 3 bath home. Primary bedroom & 2nd bedroom on first floor. Island kitchen, granite countertops & lots of storage. \r\nFamily room with vaulted ceiling & wood burning fireplace. Primary bedroom with tray ceiling & sitting room/sunroom; ensuite with walk in shower, soaking tub, walk in closets & high ceilings.\r\n3 incredibly spacious bedrooms upstairs & balcony overlooking backyard. Large screened in porch & outdoor kitchen. Fabulous 1/2 acre yard with mature trees. Plenty of room to add a pool! \r\nNeighborhood amenities: swimming pool, tennis courts, pickleball, basketball court, fishing pier, active clubhouse, boat launch, green spaces on the water throughout the neighborhood for resident use.\r\nMinutes from Conroe/The Woodlands with world class shopping, dining, & medical facilities.' ,`Acres` = '0.6043' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CORINTHIAN POINT 04, BLOCK 21, LOT 408, 409' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '26325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '106' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Corinthian Point 04' ,`TaxAmount` = '6497' ,`TaxRate` = '2.2463' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704503' WHERE `Matrix_Unique_ID` = '209724730' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:46:33.317' ,`MLSNumber` = '44107959' ,`ListAgentFullName` = 'Bernard Green' ,`ListOfficeName` = 'Greenleaf Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.962258' ,`Longitude` = '-95.459401' ,`PhotoCount` = '41' ,`PostalCode` = '77067' ,`RoomCount` = '5' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Swords Creek' ,`StreetNumber` = '12151' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 3 bed 2 bath home features a spacious living area, formal dining, a lovely greenhouse and a backyard.' ,`Acres` = '0.1366' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 HERITAGE VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Village Sec 01' ,`TaxAmount` = '3514' ,`TaxRate` = '3.1167' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704503' WHERE `Matrix_Unique_ID` = '209819126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T17:09:56.433' ,`MLSNumber` = '10819258' ,`ListAgentFullName` = 'Dana Newell' ,`ListOfficeName` = '316 Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.653837' ,`Longitude` = '-95.058514' ,`PhotoCount` = '48' ,`PostalCode` = '77571' ,`RoomCount` = '7' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple Leaf' ,`StreetNumber` = '3805' ,`StreetSuffix` = 'Circle' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2030' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in a quiet neighborhood. Located on a culdesac and walking distance to a local fishing pond, neighborhood park, and pool. This 2 story 3/2.5/2 won\'t last long. Master bedroom is located on the 1st floor, 2 bedrooms, 1 bath, and game room are located upstairs. Kitchen has a small island, breakfast room and separate dinning area. Large fully fenced backyard. House has been updated with fresh paint and ready for move in.' ,`Acres` = '0.1515' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 48 FAIRMONT PARK EAST SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LEO RIZZUTO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairmont Park East Sec 05' ,`TaxAmount` = '6512' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704503' WHERE `Matrix_Unique_ID` = '209830243' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:21:39.333' ,`MLSNumber` = '95485924' ,`ListAgentFullName` = 'Dana Hilty' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508673' ,`Longitude` = '-95.019068' ,`PhotoCount` = '37' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '389999.00' ,`Status` = 'Active' ,`StreetName` = 'Gran Canary' ,`StreetNumber` = '4453' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful family home that sits in a half cul-de-sac in Mar Bella. This home has a 3-car garage that also features a third garage door on the back side to pull a boat or camper through & 200 amp service, six 110 plugs in garage. Fresh paint, new carpet. Master down. Gas log fireplace. Large open kitchen with lots of natural light. Granite counters, tile backsplash & floors. Water filtration on kitchen sink. Nice ceilings fans in all rooms. Large gameroom upstairs with an computer nook. Three nice size bedrooms with large closets. Large walk-in attic includes Radiant Barrier. Honeywell Data Center. Pool tube through the attic for a future pool instillation. Covered back porch with a huge backyard and no back neighbors. Gas hookup for an outdoor grill. Exterior paint two years ago. Quickport manifold to shut off water system. Neighborhood water features and walking trails. Award winning school district.' ,`Acres` = '0.2854' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MAR BELLA SEC 7 (2008) ABST 32, BLOCK 1, LOT 24, ACRES 0.285' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12433' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mar Bella Sec 7 2008' ,`TaxAmount` = '9006' ,`TaxRate` = '2.7997' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704503' WHERE `Matrix_Unique_ID` = '210080187' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T17:32:59.237' ,`MLSNumber` = '27009701' ,`ListAgentFullName` = 'Steve Soyebo' ,`ListOfficeName` = 'SpectrumSource Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667877' ,`Longitude` = '-95.586566' ,`PhotoCount` = '39' ,`PostalCode` = '77099' ,`RoomCount` = '6' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Plumpoint' ,`StreetNumber` = '11831' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t pass on an opportunity to own this Beautiful, newly renovated home ideally situated minutes from the beltway. This 3 bedrooms, 2baths updates include: Fresh paint throughout interior, Granite countertops in the Kitchen & bathrooms, tile flooring throughout the rooms, Bathrooms updated with beautiful wall tiles and accents. Spacious Kitchen & cabinet spaces. ***SCHEDULE A SHOWING FOR YOURSELF TODAY***' ,`Acres` = '' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 73 BLK 2 KEEGANS GLEN SEC 6 R/P' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CUMMINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Keegans Glen' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704503' WHERE `Matrix_Unique_ID` = '210223159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T17:02:33.420' ,`MLSNumber` = '93639552' ,`ListAgentFullName` = 'Kathryn Hensley' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.444732' ,`Longitude` = '-94.748874' ,`PhotoCount` = '33' ,`PostalCode` = '75904' ,`RoomCount` = '3' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkland' ,`StreetNumber` = '315' ,`StreetSuffix` = 'Road' ,`City` = 'Lufkin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1859' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Custom Home located on 3.56 acres. Come tour this open floor plan, split floor plan with all the upgrades\r\nThis home offers a formal dining or office, Beautiful Quartz countertops, eat in kitchen with large island, stainless steel appliances, Large Primary bedroom w/ walk in shower and great walk in closet! This home has so much character and all that is missing is YOU!' ,`Acres` = '3.56' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '4665 KIRKLAND RD ESTATES BLK 1 LOT 3' ,`LotDesciption` = 'Wooded' ,`LotSize` = '155074' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '267 - Central' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (CENTRAL)' ,`SchoolHigh` = 'CENTRAL HIGH SCHOOL (CENTRAL)' ,`SchoolMiddle` = 'CENTRAL JUNIOR HIGH SCHOOL (CENTRAL)' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Split Level,Traditional' ,`Subdivision` = 'Kirkland Road Estates' ,`TaxAmount` = '4798' ,`TaxRate` = '1.717' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704503' WHERE `Matrix_Unique_ID` = '210591233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:09:59.570' ,`MLSNumber` = '5123136' ,`ListAgentFullName` = 'John Jarvis' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.686775' ,`Longitude` = '-95.220024' ,`PhotoCount` = '48' ,`PostalCode` = '75765' ,`RoomCount` = '6' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Private Road 7908 Before 549 P' ,`StreetNumber` = '551' ,`StreetSuffix` = '' ,`City` = 'Hawkins' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This waterfront home is nestled away on a beautiful, wooded lot, located on Brooks Lake in Hawkins. Brooks Lake is approx. 65 acres in size & is a private fishing lake community. If you love to fish, you have a pier & deck that has approx. 345 sq. feet with bench seating, lighting & electricity. Walking up to the home, you will come to what I would call an observation deck that has a tree deliberately growing out of the center of the deck. When you walk through the front door, you may have your breath taken away by how high the ceiling is. It measures close to 16 feet high. The living area has a wood-burning, floor-to-ceiling fireplace. The kitchen is adorned with wood cabinetry which compliments the hardwood flooring. The dining, kitchen & living areas all have a great view of the lake. The stairwell takes you up to the loft or sitting area. This is almost like having a second living room. Both bedrooms, one downstairs & one upstairs are very comfortable in size.' ,`Acres` = '0.2461' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 .2461 BROOKHAVEN SEC 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot,Waterfront,Wooded' ,`LotSize` = '10720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '588 - Hawkins' ,`SchoolElementary` = 'HAWKINS ELEMENTARY SCHOOL (HAWKINS)' ,`SchoolHigh` = 'HAWKINS HIGH SCHOOL' ,`SchoolMiddle` = 'HAWKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookhaven' ,`TaxAmount` = '3481' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704503' WHERE `Matrix_Unique_ID` = '210630857' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T17:06:20.863' ,`MLSNumber` = '48290115' ,`ListAgentFullName` = 'Tarl Anderson' ,`ListOfficeName` = 'Tarl Anderson Properties' ,`SellingAgentFullName` = 'Rebecca Hutton' ,`SellingOfficeName` = 'Redfin Corporation' ,`Latitude` = '29.933271' ,`Longitude` = '-95.077140' ,`PhotoCount` = '29' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '199900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Crows Nest' ,`StreetNumber` = '17419' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1511' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We are excited to present this affordable 3 bedroom home in Newport that would be great for a first-time home buyer! This home has so much potential. All bedrooms have large walk-in closets offering tons of storage space. There\'s a large backyard with a covered patio and storage shed.' ,`Acres` = '0.1928' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 9 NEWPORT SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Newport Sec 05' ,`TaxAmount` = '4069' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704504' WHERE `Matrix_Unique_ID` = '210826987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T17:48:44.680' ,`MLSNumber` = '61297099' ,`ListAgentFullName` = 'Ashton Weatherford' ,`ListOfficeName` = 'Martindale Real EstateInvestments' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.929341' ,`Longitude` = '-94.336505' ,`PhotoCount` = '30' ,`PostalCode` = '75938' ,`RoomCount` = '8' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3260' ,`StreetNumber` = '1248' ,`StreetSuffix` = '' ,`City` = 'Colmesneil' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 2021 mobile home, 2128 sqft of living space, sitting on almost an acre of quiet land. This home is perfect for your family! 5 bedrooms, 3 bathrooms, a large living room that opens up to the kitchen and dinning area creating that perfect open floor plan. A spacious laundry room, just off of the kitchen, that features 2 new Samsung washer and dryers that will stay in the home. The master bath features an oversized walk in shower. Large closets throughout the home, plenty of storage space. There is a newly built deck off of the back of the home that features a wheelchair accessible ramp. \r\n\r\nCall today to schedule your showing!' ,`Acres` = '' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0331 G&BN CO,TRACT 5,ACRES 0.916' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '427 - Colmesneil' ,`SchoolElementary` = 'COLMESNEIL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLMESNEIL HIGH SCHOOL' ,`SchoolMiddle` = 'COLMESNEIL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Other' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704504' WHERE `Matrix_Unique_ID` = '211279504' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:04:36.240' ,`MLSNumber` = '89953441' ,`ListAgentFullName` = 'Brandi Stroka' ,`ListOfficeName` = 'Richards & Assoc. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.473284' ,`Longitude` = '-95.670394' ,`PhotoCount` = '23' ,`PostalCode` = '77356' ,`RoomCount` = '3' ,`ListPrice` = '209900.00' ,`Status` = 'Active' ,`StreetName` = 'Redwood' ,`StreetNumber` = '15644' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '996' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Bed, 2 Bath home with an additional 2 car covered carport with additional garage storage space approx. 12x24. This home is fully fenced front to back with plenty of space for your animals to roam. 10\' Ceilings & 9\' in the Kitchen & Bedrooms. Stylish Concrete Flooring throughout. Dining area with Huge Picture window to let in Natural Light. Kitchen has 42\" upper cabinets with granite countertops. Perfect home for first time buyer, or someone down-Sizing. Fridge can be negotiated. Conveniently Located just minutes from Lake Conroe, shopping, dining, and entertainment. Schools are zoned to Montgomery ISD. LOW TAX rate 1.90 and HOA due of ONLY $36 A YEAR, Community lake and pool for $100 year.' ,`Acres` = '0.1159' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S580304 - HIDDEN FOREST EST 04, LOT 190' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '36' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Forest Estate 04' ,`TaxAmount` = '2039' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704504' WHERE `Matrix_Unique_ID` = '211435985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:44:41.187' ,`MLSNumber` = '55766376' ,`ListAgentFullName` = 'Stacey Sappington' ,`ListOfficeName` = 'Red Shoe Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.938266' ,`Longitude` = '-95.080137' ,`PhotoCount` = '23' ,`PostalCode` = '77532' ,`RoomCount` = '5' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Batten' ,`StreetNumber` = '607' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 607 Batten Way! This split floor plan has tons of living area with great sized bedrooms. The backyard is a dream! Huge covered patio the full length of the house, fire pit with plenty of yard for your trampoline or pool. New laminate flooring in living and dining areas. Large primary bedroom with a fantastic bathroom with both a soaker tub and separate shower. Schedule your showing today!' ,`Acres` = '0.2009' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 5 NEWPORT SEC 6' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '720' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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` = 'Newport Sec 06' ,`TaxAmount` = '4484' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704504' WHERE `Matrix_Unique_ID` = '211631865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:10:03.890' ,`MLSNumber` = '46230613' ,`ListAgentFullName` = 'Dolores Aguirre' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003888' ,`Longitude` = '-95.179574' ,`PhotoCount` = '34' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'KELLY MILL' ,`StreetNumber` = '6019' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2417' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFULLY RENOVATED HOME 4/2.5/2- ROOF RECENTLY REPLACED, CARPET HAS BEEN REPLACED, KITCHEN\r\nCOUNTERS HAVE BEEN REPLACED. THE LIST GOES ON AND ON.\r\nTHIS HOME FACES A BEAUTIFUL FAMILY PARK AND HOME LOCATED NEAR HUMBLE SCHOOL DISCTRICT, AIRPORT\r\nAND LAKE HOUSTON.' ,`Acres` = '0.1326' ,`Area` = '1' ,`BuilderName` = 'PULTE' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 KINGWOOD GLEN SEC 3 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'KINGWOOD GLEN' ,`TaxAmount` = '5539' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704504' WHERE `Matrix_Unique_ID` = '211667654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:38:22.650' ,`MLSNumber` = '12502857' ,`ListAgentFullName` = 'Melanie Cook' ,`ListOfficeName` = 'Palmer Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.863085' ,`Longitude` = '-95.251307' ,`PhotoCount` = '50' ,`PostalCode` = '77320' ,`RoomCount` = '18' ,`ListPrice` = '1599000.00' ,`Status` = 'Active' ,`StreetName` = 'Newport' ,`StreetNumber` = '161' ,`StreetSuffix` = 'Way' ,`City` = 'Huntsville' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5709' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop looking because here is a strikingly beautiful waterfront home with lavish finishes in the deed restricted, waterfront subdivision of Emerald Estates. Walk through the huge wood/wrought iron doors into a grand entry to breathtaking views of Lake Livingston. Move through the home to the right & you will find the luxurious master suite & home office, both with phenomenal views of the lake. Upon entry to the left is where the well-equipped kitchen serves as the anchor to the open formal & casual dining, living, & wet bar. A full guest bath is conveniently located just off the living area. Upstairs is a 2nd master suite & 3 bedrooms, 2 of which are joined by a Jack-n-Jill bath. Step into the hall closet & you will find floored attic space that can serve not only as storage but as a fire escape & spans the home to an exit above the tandem garage. Come outside & tour the deck, outdoor kitchen, boat house, landscaped yard, & Texas basement! Find more details in photo descriptions!' ,`Acres` = '0.7206' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'EMERALD ESTATES, LOT 11 & 12 A PART OF, ACRES .7206' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '31389' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Emerald Estates' ,`TaxAmount` = '13667' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704504' WHERE `Matrix_Unique_ID` = '211699656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T17:18:48.797' ,`MLSNumber` = '34717083' ,`ListAgentFullName` = 'Komarickal Paulose' ,`ListOfficeName` = 'Reliable, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.035181' ,`Longitude` = '-95.538393' ,`PhotoCount` = '35' ,`PostalCode` = '77373' ,`RoomCount` = '10' ,`ListPrice` = '307999.00' ,`Status` = 'Active' ,`StreetName` = 'PELHAM PRAIRIE' ,`StreetNumber` = '23227' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HUGE TWO STORY HOUSE .WITH 4 BEDROOMS AND 2 1/2 BATH ROOMS .ONLY TWO YEAR OLD HOUSE .STILL LOOKS NEW .ALL LIVING AND WET AREA HAS VINYL TILES.. ALL BEDROOMS HAS CARPET . REFRIGERATOR,WASHER ,DRYER AND MICRO WAVE COMES WITH HOUSE .PRICED TO SELL WONT LAST LONG \r\nEXCELLENT SCHOOLS' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 26 BLK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Beckenridge west' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704504' WHERE `Matrix_Unique_ID` = '211934227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:03:42.437' ,`MLSNumber` = '18375075' ,`ListAgentFullName` = 'Renay Cohen' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.193681' ,`Longitude` = '-95.459113' ,`PhotoCount` = '8' ,`PostalCode` = '77384' ,`RoomCount` = '9' ,`ListPrice` = '689000.00' ,`Status` = 'Active' ,`StreetName` = 'Cinder Berry' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2827' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pelican New Construction in Shenandoah, LOW tax rate (no MUD), and great location! Houston\'s renowned Pelican Builders have brought their award-winning architecture and design to The Woodlands area at the charming, gated community of Boulevard Green at Vision Park. Just minutes from I45, Hughes Landing, The Woodlands Mall, Town Center, Market Street and more. Sophisticated design combined with a low maintenance, Lock-And-Leave lifestyle. HOA maintained yards. Popular, 3 story \"D-1\" plan with brick exterior. This 4 bed, 4.5 bath home offers high end, designer finishes, a large, island kitchen w/stainless appliances, and an open concept floor plan. Community amenities include area pool, sports lawn, and access to hike/bike trails. Call to schedule an appointment today!' ,`Acres` = '0.0591' ,`Area` = '15' ,`BuilderName` = 'Pelican Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S266100 Boulevard Green, Block 7, Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2573' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Boulevard Green at Vision Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704505' WHERE `Matrix_Unique_ID` = '211948338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:05:04.893' ,`MLSNumber` = '31978213' ,`ListAgentFullName` = 'Renay Cohen' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.191896' ,`Longitude` = '-95.457939' ,`PhotoCount` = '5' ,`PostalCode` = '77384' ,`RoomCount` = '9' ,`ListPrice` = '644000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '155' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2221' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Shenandoah, LOW tax rate (no MUD), and great location! Houston\'s renowned Pelican Builder have brought their award-winning architecture and design to The Woodlands area at the charming, gated community of Boulevard Green at Vision Park. Popular, 2 story, D-2 plan with stucco exterior. Just minutes from I-45, Hughes Landing, The Woodlands Mall, Town Center, Market Street and more. You\'ll be delighted by the sophisticated designed combined with a low maintenance, Lock-And-Leave lifestyle. HOA maintained yard. This 3 bedroom, 3.5 bath home offers high end, designer finishes, a large, island kitchen, and an open concept floor plan. Community amenities include area pool, sports lawn, and access to hike/bike trails. Call to schedule an appointment today! Zoned to Woodlands schools.' ,`Acres` = '0.0688' ,`Area` = '15' ,`BuilderName` = 'Pelican Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S266100-Boulevard Green, Block 8, Lot 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2995' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Boulevard Green at Vision Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704505' WHERE `Matrix_Unique_ID` = '211948587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T16:44:05.043' ,`MLSNumber` = '5757940' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830916' ,`Longitude` = '-94.998665' ,`PhotoCount` = '8' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Zavala Mill' ,`StreetNumber` = '4115' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1683' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Cottage Collection \"Camellia\" Plan with Elevation \"B\" in Burnet Fields! This single-story home has a smart layout that is perfect in many ways. The front door leads to an open concept living area that is ideal for daily activities and entertaining guests with a modern kitchen, dining room and family room, all side by side. Three bedrooms share a hall bathroom at the front of the home, while the owner’s suite is tucked into the back with a private bathroom and large walk-in closet. *HOME ESTIMATED TO BE COMPLETE, December, 2022*' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 003 LOT 006' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Burnet Fields' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704505' WHERE `Matrix_Unique_ID` = '211950322' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T17:52:45.457' ,`MLSNumber` = '59246061' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816598' ,`Longitude` = '-95.397277' ,`PhotoCount` = '16' ,`PostalCode` = '77018' ,`RoomCount` = '3' ,`ListPrice` = '464999.00' ,`Status` = 'Active' ,`StreetName` = 'E 33rd Street' ,`StreetNumber` = '207' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION!!!! Located in the heart of independence Heights, this home is close to many local hotspots such as restaurants and nightlife in the Heights. You will also be minutes away from many major business districts including Downtown, the Galleria, and Med Center. Each home has a private driveway, spacious backyard and downstairs living with an additional game room/flex space upstairs! In addition, the home is equipped with engineered hardwoods throughout living areas, quartz countertops, modern hardware, and boasts natural light.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Urban Arc' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'tbd' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Independence Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704505' WHERE `Matrix_Unique_ID` = '211955028' --> Updated record success