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-25T19:45:52.877' ,`MLSNumber` = '18435479' ,`ListAgentFullName` = 'Wanda Pearrie' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806165' ,`Longitude` = '-95.388614' ,`PhotoCount` = '8' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Nadine' ,`StreetNumber` = '1214' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do not enter house--house to be torn down. Perfect lot for new construction! Investor special sold at lot value only (2 lots Lot 3 & 4-2500 sq ft ea). Unlimited potential. Premier neighborhood, hike/bike trail system, bars/restaurants, Heights Beer Gardens, breweries, shops--you name it!! 5 local elementary schools with Heights High school being top rated! Named one of the most walkable communities! Make this one yours! Priced to move.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 3 & 4 BLK 1 RODGERS PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodgers Park-Stude/Houston Heights' ,`TaxAmount` = '6060' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702953' WHERE `Matrix_Unique_ID` = '207553635' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T19:35:55.743' ,`MLSNumber` = '84016121' ,`ListAgentFullName` = 'Michael Prince' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362720' ,`Longitude` = '-95.387631' ,`PhotoCount` = '21' ,`PostalCode` = '77303' ,`RoomCount` = '10' ,`ListPrice` = '404790.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel Lake Drive' ,`StreetNumber` = '6130' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1968' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Slab was poured 05-20-22 So September possible August is the time frame for completion of home...\r\n\r\nBuilt by Alta Homes, this brand-new Pinehurst floor plan is our beautiful open-concept, one-story home! Located on a large, very nice 80 x 200 lot in the new final section 3 of Deer Trail Estates. The home has 4 bedrooms, 2 and 1/2 baths. The home features luxury vinyl plank flooring in all areas except the bedrooms. Cermaic tile in Utility room and Bathrooms. Stylish kitchen, with flat top island perfect for hosting, tray ceilings with crown molding in the large open entry, and a 3-car garage for additional storage space. The Kitchen, Breakfast, Family, and Master bedroom has the view of the 20 acres pond out the back.! The backyard is spacious and has a nice, covered patio. This home features, subway tile backsplash, with stylish granite countertops in the kitchen and all bathrooms. Breath-taking new home with very low property taxes!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Alta Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 1 Section 3' ,`LotDesciption` = 'Water View' ,`LotSize` = '16000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '485' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Deer Trails Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702953' WHERE `Matrix_Unique_ID` = '208129100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T19:57:39.287' ,`MLSNumber` = '41982032' ,`ListAgentFullName` = 'Javier Gonzalez' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.247726' ,`Longitude` = '-95.544833' ,`PhotoCount` = '15' ,`PostalCode` = '77384' ,`RoomCount` = '12' ,`ListPrice` = '852500.00' ,`Status` = 'Active' ,`StreetName` = 'West Forest Ct' ,`StreetNumber` = '5' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**ESTIMATED DELIVERY: SEPTEMBER** Beautiful modern farmhouse design at Lake Forest Subdivision. ** Low Tax Rate ** Zoned to highly acclaimed schools like The Woodlands High School, close to parks and restaurants, and easy access to I-45, located in a quiet neighborhood surrounded by trees. This spacious two-story home with three bedrooms and 3.5 bathrooms, plus an office, TV room, an a huge game room/extra room upstairs. It will be completed in September 2022. Many upgrades throughout, such as granite countertops, stainless steel appliances, wood flooring, spacious bedrooms, and an open floor plan, are perfectly laid out. Great front porch. Massive rear covered patio with summer kitchen.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Urbanika' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 1 Lake Creek Forest Section 1 Montgomery TX' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '21780' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Lake Creek Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702954' WHERE `Matrix_Unique_ID` = '208284248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:36:05.027' ,`MLSNumber` = '38525535' ,`ListAgentFullName` = 'Kenneth Tuggle' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786853' ,`Longitude` = '-94.841734' ,`PhotoCount` = '26' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '629900.00' ,`Status` = 'Active' ,`StreetName` = 'Camp Creek' ,`StreetNumber` = '4735' ,`StreetSuffix` = 'Road' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BARBER\'S HILL SCHOOLS & LOW TAXES. LARGE SINGLE STORY HOME ON +/- 1 ACRE LOT. LOOKS LIKE NEW. FANTASTIC FLOOR PLAN, VERY OPEN AND INVITING. WOOD FLOORS IN MAIN AREAS, CARPET IN THE BEDROOMS. STUNNING KITCHEN WITH BEAUTIFUL CABINETRY AND LOTS OF COUNTER SPACE WITH A BREAKFAST NOOK. AMAZING OWNER\'S SUITE WITH ALL THE APPOINTMENTS. 4 BEDROOMS AND 3 BATHS. 3 CAR DETACHED GARAGE WITH A PORTA-COCHERE. DON\'T MISS THIS ONE.' ,`Acres` = '0.974' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BK 1 SELLERS STATION SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '42427' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric 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` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sellers Station Sec 2' ,`TaxAmount` = '7266' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702954' WHERE `Matrix_Unique_ID` = '208677926' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:11:33.943' ,`MLSNumber` = '24252737' ,`ListAgentFullName` = 'Jeanne Eschenfelder' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.097777' ,`Longitude` = '-95.390395' ,`PhotoCount` = '36' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Cade Hills' ,`StreetNumber` = '28122' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home on large lot in gated section of Spring Trails! This 4 bedroom, 3 1/2 bath home features high ceilings, open floor plan, study with French doors, and outdoor kitchen w/ large covered patio. The kitchen is the heart of this home with open sight lines to the formal dining room, family room, breakfast nook and outdoor patio. The kitchen features soaring ceilings, SS appliances, gas cooktop and double islands. Enormous second island is perfect for serving and entertaining. Family room is full of natural light, large windows and stone fireplace. Wine Bar/Wet Bar area off of kitchen/family room. Huge utility room. Hallway has a large storage bench. Primary bedroom is spacious, plantation shutters throughout home. Three car garage plus bump out! Recent paint and carpet (July 2022).' ,`Acres` = '0.2601' ,`Area` = '40' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S901416 - SPRING TRAILS 16, BLOCK 1, LOT 40' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11328' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Trails 16' ,`TaxAmount` = '9776' ,`TaxRate` = '2.6137' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702954' WHERE `Matrix_Unique_ID` = '208697933' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T19:06:41.217' ,`MLSNumber` = '37381742' ,`ListAgentFullName` = 'Naomi Tonsul' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019432' ,`Longitude` = '-95.111839' ,`PhotoCount` = '11' ,`PostalCode` = '77336' ,`RoomCount` = '7' ,`ListPrice` = '135000.00' ,`Status` = 'Active' ,`StreetName` = 'Corydon' ,`StreetNumber` = '514' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS PROPERTY IS AVAILABLE; AS BUYER UNABLE TO GET FUNDING..\r\nTHIS HOUSE NEEDS A LOT OF WORK; SITS ON TWO LOTS IN QUIET N/HOOD IN GREAT LOCATION' ,`Acres` = '0.2388' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 232 BLK 5 LAKEWOOD HEIGHTS SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '215' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lakewood Heights Sec 01' ,`TaxAmount` = '863' ,`TaxRate` = '2.5081' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702954' WHERE `Matrix_Unique_ID` = '208942224' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:53:52.003' ,`MLSNumber` = '66801001' ,`ListAgentFullName` = 'Susan Edwards' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Lydia Davies' ,`SellingOfficeName` = 'Norhill Realty' ,`Latitude` = '30.146334' ,`Longitude` = '-95.520306' ,`PhotoCount` = '48' ,`PostalCode` = '77389' ,`RoomCount` = '12' ,`ListPrice` = '833000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bacopa' ,`StreetNumber` = '83' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in The Woodlands Village of Creekside Park with great curb appeal featuring a stunning Rotunda! Just steps to the lake, Rob Fleming Aquatic Center, dog park & more! 4 bedrooms & 4.5 bathrooms, 3 car garage, a private study w/French doors, formal dining room, family room with floor-to-ceiling windows for a stunning view of the outdoors, chef’s kitchen, charming breakfast room, en-suite guest bedroom down, 2nd story game room and media room, and secluded guest rooms! The owner’s retreat is spacious and private with a spa-like bath! HUGE yard with plenty of room for a pool, the summer kitchen is ready to entertain, and no neighbors behind! Creekside Village is known for its outdoor lifestyle offering scenic miles of walking & biking trails around the lake, the George Mitchell trail, & annual family photos in the sea of Bluebonnets! Nearby Creekside Park Village Green offers fine dining, movie theater, shopping, & more! Easy commute to Grand Pkwy 99 and I-45. Exemplary Schools!' ,`Acres` = '0.2937' ,`Area` = '14' ,`BuilderName` = 'Partners In Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 6 THE WOODLANDS VLG OF CREEKSIDE PARK 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKSIDE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park' ,`TaxAmount` = '18453' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702954' WHERE `Matrix_Unique_ID` = '209480350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:27:14.987' ,`MLSNumber` = '24788140' ,`ListAgentFullName` = 'Benny George' ,`ListOfficeName` = 'Soluna Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662460' ,`Longitude` = '-95.688585' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '12' ,`ListPrice` = '629990.00' ,`Status` = 'Active' ,`StreetName` = 'Browning Trace' ,`StreetNumber` = '17306' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well Maintained house in a Master planned community - ALIANA - under fort bend ISD with great schools - Its a beautiful house , with open floor plan with High ceiling - Spacious bed rooms - Granite counter tops - upgraded appliances - Extended patio - Roof replaced in 2019 - Sprinkler system - Easy access to shopping malls, restaurants, highways such as 90, 99 and west park toll way.- Around 30 minutes to Katy mill mall, First colony mall, Galleria - Don\'t miss this - Buyers should verify the room size and the schools - SELLING AS IS - PRICE REDUCED FOR QUICK SALE !!!!' ,`Acres` = '0.1708' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 7, BLOCK 3, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MADDEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aliana Sec 7' ,`TaxAmount` = '10878' ,`TaxRate` = '2.9329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702954' WHERE `Matrix_Unique_ID` = '210056039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:26:49.497' ,`MLSNumber` = '40947156' ,`ListAgentFullName` = 'Theresa Giesman' ,`ListOfficeName` = 'HOM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.026188' ,`Longitude` = '-95.747562' ,`PhotoCount` = '30' ,`PostalCode` = '75852' ,`RoomCount` = '3' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 21' ,`StreetNumber` = '12294' ,`StreetSuffix` = '' ,`City` = 'Midway' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2145' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This completely remodeled home in the country is just waiting for you! On just over 3.5 acres this beautiful home is very spacious from living space to bedrooms you won\'t be disappointed. Custom cabinets in kitchen and bathrooms, spacious closets, walk in pantry and large laundry room off kitchen. Property is fenced and has some pasture land ready for horses or cattle. Fenced in area around back porch for your fur babies. New A/C in 2021, tankless water heater, all new plumbing, new electrical and additional storage room at attached carport. Only 9 minutes from I-45 and 10 minutes to downtown Madisonville. MOTIVATED SELLERS... Bring your offers!! Call and make your appointment today!' ,`Acres` = '3.57' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midway Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0247 JESSE YOUNG TRACT 208 3.57 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '155509' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '175 - Madisonville Consolidated' ,`SchoolElementary` = 'MADISONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MADISONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Jesse Young Surv Abs #247' ,`TaxAmount` = '2637' ,`TaxRate` = '1.7287' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702954' WHERE `Matrix_Unique_ID` = '210223515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:15:06.330' ,`MLSNumber` = '61021851' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.425246' ,`Longitude` = '-95.456916' ,`PhotoCount` = '19' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '445140.00' ,`Status` = 'Active' ,`StreetName` = 'Pioneer Rest' ,`StreetNumber` = '10839' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Make this quaint and beautiful home yours with its open family room, luxurious & stylish primary suite, and upstairs game room. Linen cabinets with white/grey granite countertops, brown grey EVP flooring with multi-tone carpet in our Elemental package. Situated along the Manuel growth corridor, Sierra Vista is 25 miles south of metro Houston in the sought-after Alvin ISD, consistently rated among the best in the region. Nearby, the brand-new rec center offers amenities like fitness classes, youth sports, and a swimming pool. Known for our energy saving features, our homes help you live a healthier and quieter lifestyle, while saving you thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0320 Plan 4L91C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.61' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702955' WHERE `Matrix_Unique_ID` = '210355933' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T19:24:57.270' ,`MLSNumber` = '60768810' ,`ListAgentFullName` = 'Inez Tripson' ,`ListOfficeName` = 'Provenzano Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.305941' ,`Longitude` = '-96.036898' ,`PhotoCount` = '31' ,`PostalCode` = '77488' ,`RoomCount` = '7' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 123' ,`StreetNumber` = '814' ,`StreetSuffix` = '' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2199' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bird watchers Paradise! Feel like you’re “at one with nature” in this private 3-bedroom 2.5 bath home on 3.06 acres. This home features a large open living room with views into an incredible sunroom that lights up the home w/ views of Crepe Myrtles, Lilies, Jasmine & Sunflowers! The home stays cool with an energy efficient radiant heat barrier. The home also features a largeden complete with a full bath and a wood burning stove for the cooler nights. The kitchen has beautiful cabinetry, quartz countertops w/ island, a travertine backsplash and engineered wood floors that spill into the formal dining room. The primary bedroom has a walk-in closet and private bathroom. The home also has a utility room, a water softener, ceiling fans throughout and several large closets. Outside you will find yourself surrounded by gorgeous mature trees and the serene sounds of Caney Creek flowing through the property when full . There is also a 2-stall barn with plenty of storage for any horse lovers.' ,`Acres` = '3.06' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Stove' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Caney Acres Sec. Lot 7 and 6' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '140 - Boling' ,`SchoolElementary` = 'NEWGULF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOLING HIGH SCHOOL' ,`SchoolMiddle` = 'IAGO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Caney Acres' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702955' WHERE `Matrix_Unique_ID` = '210963162' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:09:49.083' ,`MLSNumber` = '22994194' ,`ListAgentFullName` = 'Daniel Zalman' ,`ListOfficeName` = 'Zalman & Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.202860' ,`Longitude` = '-96.276529' ,`PhotoCount` = '15' ,`PostalCode` = '77437' ,`RoomCount` = '12' ,`ListPrice` = '149500.00' ,`Status` = 'Active' ,`StreetName` = 'Fahrenthold' ,`StreetNumber` = '911' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ranch style wood frame four bedroom, two bath home. Unique home with lots of character and potential waiting for the ideal buyer to take this home to the next level of visionary excellence. Spacious home and lot located in the heart of El Campo close to schools, church and shopping.' ,`Acres` = '0.4821' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'DUSON BLOCK 16 LOT 1,2,3' ,`LotDesciption` = 'Corner' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Duson' ,`TaxAmount` = '5550' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1944' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702955' WHERE `Matrix_Unique_ID` = '210995128' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:37:26.613' ,`MLSNumber` = '22709004' ,`ListAgentFullName` = 'Nolan Nix' ,`ListOfficeName` = 'Home Run Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.060581' ,`Longitude` = '-95.159307' ,`PhotoCount` = '22' ,`PostalCode` = '77345' ,`RoomCount` = '12' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Lodge' ,`StreetNumber` = '5902' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful Custom Home by Calli Builders Located in the Highly Desirable Sand Creek Village. 2 Bedrooms Down and 3 Up. 3.5 Updated Bathrooms. 2 Car Attached Garage. Formal Dining, Executive Study with Cabinetry, Formal Living and Family Room. High Ceilings. Extensive Crown Molding, Plantation Shutters and Wood Floors Throughout. kitchen has an Induction Cooktop that Cooks Faster Than Gas! Abundance of Storage, Built-Ins and Butler\'s Pantry. Resort Style Pool/Spa with Rock Waterfall, Outdoor Kitchen and Covered Patio. Pentair Screenlogic Automation Interface for Pool which allows you to Remotely monitor, program and control water temperature, lighting, waterfall, cleaner, hot tub and other pool features whenever and wherever you choose. Never Flooded. Great Schools. This Home Has it All! A MUST SEE!!!' ,`Acres` = '0.2852' ,`Area` = '32' ,`BuilderName` = 'Calli' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 20 SAND CREEK VILLAGE SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '12423' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'DEERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sand Creek' ,`TaxAmount` = '10077' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702955' WHERE `Matrix_Unique_ID` = '211059002' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:46:58.710' ,`MLSNumber` = '73028499' ,`ListAgentFullName` = 'Laura Miranda' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741905' ,`Longitude` = '-95.333254' ,`PhotoCount` = '15' ,`PostalCode` = '77023' ,`RoomCount` = '2' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Walker' ,`StreetNumber` = '4415' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredibly charming and spacious bungalow nestled in the heart of Eastwood proper. Situated on one of the most desirable streets, this rare 2 bed/2 bath home with an in-ground POOL has all the conveniences one would need while living 8 minutes to Downtown. An inviting Texas stone front porch immediately welcomes you to the living room which features a wood-burning fireplace and custom built-in shelving. Both bedrooms are incredibly spacious. The home has so much potential at the current price point. Eastwood was developed by William A. Wilson, who also developed Woodland Heights; when you drive through you\'ll immediately fall in love with the tree-lined streets and architecture. Located within 8 minutes to Downtown, EaDo and East River--you get the cozy \"Heights-like\" neighborhood vibes without compromising your commute and price point! Schedule your appointment today!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 14 EASTWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Eastwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702955' WHERE `Matrix_Unique_ID` = '211162237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:16:17.513' ,`MLSNumber` = '46016145' ,`ListAgentFullName` = 'Kerry Bland' ,`ListOfficeName` = 'Evan Lloyd Properties, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.791682' ,`Longitude` = '-94.893985' ,`PhotoCount` = '18' ,`PostalCode` = '77351' ,`RoomCount` = '1' ,`ListPrice` = '69900.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway Loop 116' ,`StreetNumber` = '1586' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New 1 bed / 1 bath house on over ½ acre of land. This house has been framed for the 1bd/1ba with flooring installed but needs to be completed. The house is 14\' x 36\' with an oversized concerted 8\' high carport that is 24\' x 54\'. This little paradise is a blank slate, far enough in the country for peace and quiet but conveniently located 5 miles from town. Seller will install aerobic septic system and water at closing.' ,`Acres` = '0.572' ,`Area` = '44' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 54 ISAAC N MORELAND SURVEY TRACT 102' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '24916' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'unknown' ,`TaxAmount` = '212' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702955' WHERE `Matrix_Unique_ID` = '211323125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T19:56:12.430' ,`MLSNumber` = '73565523' ,`ListAgentFullName` = 'Andrea Grimm' ,`ListOfficeName` = 'AgentInc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.890293' ,`Longitude` = '-95.560117' ,`PhotoCount` = '39' ,`PostalCode` = '77040' ,`RoomCount` = '8' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Tahoe' ,`StreetNumber` = '15805' ,`StreetSuffix` = 'Drive' ,`City` = 'Jersey Village' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5057' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Original owner has taken excellent care of this home and has added lots of upgrades throughout the home to include a tandem detached garage, with office. This separate garage built exclusively for car collection and business. From the spacious living area inside this well appointed luxurious home, the floor to above the ceiling, features a fully opening up design to your own private oasis in back, where you can enjoy the full seclusion of this retreat, also accessible from the ensuite. Home is to reflect the new current updates, add ons and (per seller) the actual square footage of home and land attached in documents.' ,`Acres` = '1.9173' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 42 JERSEY VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '83517' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jersey Village' ,`TaxAmount` = '15420' ,`TaxRate` = '2.7758' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702955' WHERE `Matrix_Unique_ID` = '211412775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:51:31.903' ,`MLSNumber` = '37529587' ,`ListAgentFullName` = 'Wenjie Wang' ,`ListOfficeName` = 'Sunet Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.327260' ,`Longitude` = '-94.936824' ,`PhotoCount` = '30' ,`PostalCode` = '77563' ,`RoomCount` = '3' ,`ListPrice` = '620000.00' ,`Status` = 'Active' ,`StreetName` = 'Warsaw' ,`StreetNumber` = '583' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking to live in paradise on the water with room to grow, this is IT!! Three-story canal home on the sunny side with so many features and amenities you will fall in love! TWO MASTER BEDROOMS on the main floor!! Two garages, which is almost unheard of in Bayou Vista! Spacious master bedrooms, one with en-suite bath, and the other with a tub/shower combo. Living room has high ceilings with large fireplace. Large kitchen with butcher block island. Laundry room on main floor which is a huge plus! New paint and new hard wood floor throughout the house. There is even a dumbwaiter from the foyer to just outside the kitchen for hauling up those groceries without having to go up and down the stairs a million times! Low-E storm windows and patio doors to save money and reduce sound. Huge loft/bedroom on 2nd floor. This home has a ton of square footage. Schedule your appointment today!' ,`Acres` = '0.1056' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 583 NEW BAYOU VISTA ADDN 4B' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'New Bayou Vista 4b' ,`TaxAmount` = '10376' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702956' WHERE `Matrix_Unique_ID` = '211793304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:17:25.603' ,`MLSNumber` = '59898580' ,`ListAgentFullName` = 'Christine Laborde' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.800256' ,`Longitude` = '-95.066678' ,`PhotoCount` = '21' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Point' ,`StreetNumber` = '554' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Boat launch to access Lake Livingston WOW!, community pool and fishing pier! Darling two story home in the relaxing and gated community of Cedar Point. Enjoy a spacious back yard and an open floor plan in this recently constructed 4 bedroom, 3 bath home with attached 2-car garage. The kitchen offers granite countertops, stainless steel appliances, and opens to the living space. The primary suite boasts a private, en-suite bath with dual sinks and a walk-in closet.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'Century Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Cedar Point Sec 1, Block 15, Lot 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702956' WHERE `Matrix_Unique_ID` = '211804594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T19:36:36.927' ,`MLSNumber` = '65955318' ,`ListAgentFullName` = 'Myrna Sharpe' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666726' ,`Longitude` = '-95.227867' ,`PhotoCount` = '26' ,`PostalCode` = '77587' ,`RoomCount` = '5' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Volney' ,`StreetNumber` = '104' ,`StreetSuffix` = 'Street' ,`City` = 'South Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful cozy 3 bedroom house with a large backyard in a quiet neighborhood. Located close to Hobby Airport and many shopping and entertainment areas. A good first home buyer or investment property.' ,`Acres` = '0.1515' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'South Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 MERILYN PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'L F SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Merilyn Place Sec 01' ,`TaxAmount` = '2227' ,`TaxRate` = '2.8255' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702956' WHERE `Matrix_Unique_ID` = '211807020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:35:13.017' ,`MLSNumber` = '65915668' ,`ListAgentFullName` = 'Sarah Hartwell' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.800729' ,`Longitude` = '-95.064556' ,`PhotoCount` = '16' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '209500.00' ,`Status` = 'Active' ,`StreetName` = 'Bluebonnet' ,`StreetNumber` = '246' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Boat launch to access Lake Livingston WOW!, community pool and fishing pier! Adorable single story home in the relaxing and gated community of Cedar Point. Enjoy a spacious back yard and an open floor plan in this recently constructed 3 bedroom, 2 bath home with attached 2-car garage. The kitchen offers granite countertops, stainless steel appliances, and opens to the living space. The primary suite boasts a private, en-suite bath with dual sinks.' ,`Acres` = '0.1418' ,`Area` = '44' ,`BuilderName` = 'Century Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'THE MEADOWS SECTION 1 BLK 40 LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '512' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702956' WHERE `Matrix_Unique_ID` = '211832713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:40:03.387' ,`MLSNumber` = '89173327' ,`ListAgentFullName` = 'Sarah Hartwell' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.800672' ,`Longitude` = '-95.064720' ,`PhotoCount` = '17' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluebonnet' ,`StreetNumber` = '256' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Boat launch to access Lake Livingston WOW!, community pool and fishing pier! Spacious back yard and an open floor plan in this recently constructed 4 bedroom, 2 bath home with attached 2-car garage. The kitchen offers granite countertops, stainless steel appliances, and opens to the living space. The primary suite boasts a private, en-suite bath with dual sinks and a walk-in closet.' ,`Acres` = '0.1418' ,`Area` = '44' ,`BuilderName` = 'Century Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'THE MEADOWS SECTION 1 BLK 40 LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '512' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '22' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702956' WHERE `Matrix_Unique_ID` = '211832825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:45:04.020' ,`MLSNumber` = '9505829' ,`ListAgentFullName` = 'Scott Miller' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.354660' ,`Longitude` = '-95.602831' ,`PhotoCount` = '8' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '244900.00' ,`Status` = 'Active' ,`StreetName` = 'Cherokee' ,`StreetNumber` = '511' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '10\' ceilings in kitchen/Living, open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.' ,`Acres` = '0.1151' ,`Area` = '39' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE FOREST 03, BLOCK 51, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Forest 03' ,`TaxAmount` = '141' ,`TaxRate` = '2.1625' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702956' WHERE `Matrix_Unique_ID` = '211832850' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T18:50:31.080' ,`MLSNumber` = '22303613' ,`ListAgentFullName` = 'Scott Miller' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.354754' ,`Longitude` = '-95.602750' ,`PhotoCount` = '9' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '244900.00' ,`Status` = 'Active' ,`StreetName` = 'Cherokee' ,`StreetNumber` = '509' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '10\' ceilings in kitchen/Living, open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.' ,`Acres` = '0.1151' ,`Area` = '39' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE FOREST 03, BLOCK 51, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5012' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Forest 03' ,`TaxAmount` = '653' ,`TaxRate` = '2.1625' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702956' WHERE `Matrix_Unique_ID` = '211832930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T19:45:17.827' ,`MLSNumber` = '65041817' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801127' ,`Longitude` = '-95.480466' ,`PhotoCount` = '38' ,`PostalCode` = '77055' ,`RoomCount` = '3' ,`ListPrice` = '519000.00' ,`Status` = 'Active' ,`StreetName` = 'Jacquelyn Springs' ,`StreetNumber` = '1714' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2051' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Introducing VILLAS De Marbella | A community of two & three level contemporary residences. Four open floor plan options designed for the modern lifestyle, with living areas on the main level, 10’ ceilings & sliding glass doors opening to a sizable porch/private yard. Level I is complete w/ wide-plank luxury vinyl flooring, dine-in kitchen garnished w/ SS appliances, select plumbing fixtures, modern quartz countertops & euro style cabinetry. Level II features the Owners Primary Suite, two guest suites, & a vast utility room. The expansive window lined primary bedroom is complete w/ luxury vinyl flooring, a stunning bath complete with dual vanities, freestanding soaking tub, glass enclosed shower & a massive walk-in closet with built-ins. Substantial secondary bedrooms are both en-suite with walk-in closets & tub/shower combos. Please use 1720 Jacquelyn as address for GPS navigation. *THIS HOME IS MOVE IN READY*' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'Marbella / Greyden' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLOCK 1 ESTATES AT JACQUELYN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Branch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702957' WHERE `Matrix_Unique_ID` = '211833856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T19:48:41.977' ,`MLSNumber` = '63121289' ,`ListAgentFullName` = 'Moon Kim' ,`ListOfficeName` = 'Lifestyles Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.670255' ,`Longitude` = '-95.335568' ,`PhotoCount` = '9' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '164900.00' ,`Status` = 'Active' ,`StreetName` = 'Kenilwood' ,`StreetNumber` = '5730' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the established Edgewood subdivision. This recently remodeled home features an updated kitchen with granite counter tops, nice fixtures, and stainless appliances. The restroom has a granite counter top and updated tile surround. Recent roof and HVAC. With easy access to 610, 288, and 45. This one is a MUST SEE!!!' ,`Acres` = '0.1501' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 13 EDGEWOOD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALCOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702957' WHERE `Matrix_Unique_ID` = '211833918' --> Updated record success