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-12T15:52:35.997' ,`MLSNumber` = '61774276' ,`ListAgentFullName` = 'Karen Rohan' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.391933' ,`Longitude` = '-95.837454' ,`PhotoCount` = '32' ,`PostalCode` = '77461' ,`RoomCount` = '7' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Margaret' ,`StreetNumber` = '3607' ,`StreetSuffix` = 'Street' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2362' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Walk your kids to school! NO HOA!! Original homeowner, custom built home. Located directly across the street from Needville elementary, this charming home has much to offer. All brick on an oversized lot, this 4 bedroom 2.5 bath home is ready to move in. All flooring has been replaced with laminate tile look, no carpet! Nice covered patio with trees in the fenced in backyard. Make this your home today!' ,`Acres` = '0.2975' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '0464 C ABENDROTH, ACRES 0.2975, BLOCK 1 LOT 7 HORAK 3RD ADDI' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Blue Jay 8250' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697624' WHERE `Matrix_Unique_ID` = '207964612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:49:06.323' ,`MLSNumber` = '65172957' ,`ListAgentFullName` = 'Kai Wang' ,`ListOfficeName` = 'Lawson Tx Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750953' ,`Longitude` = '-95.829834' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '519900.00' ,`Status` = 'Active' ,`StreetName` = 'Baldridge' ,`StreetNumber` = '1602' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3191' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this CUSTOM 2-story home that features 3 beds, 3.5 baths, & an attached 3-car garage in the sought-after community of Grayson Lakes! This gem is situated on a beautiful lot & has an expansive backyard with a STUNNING pergola. You have an elegant formal dining room just off the foyer. Plantation shutters are seen throughout the home! The gourmet kitchen features granite counters, custom cabinets with pull-out drawers, Jenn-Air & Bosch appliances, & under-cabinet lighting. You have an elegant primary bedroom & ensuite bath downstairs that is wheelchair accessible and offers a custom closet system. Upstairs you will find another primary bedroom with recent carpet & an ensuite bathroom with a new shower enclosure & plumbing fixtures. The spacious game room offers custom cabinetry and a murphy bed! Behind a bookcase, you will find a media room! Updates include a recent roof (2018), recent exterior & interior paint, a massive garage with epoxy floors, & updated spare bathroom.' ,`Acres` = '0.2771' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRY LAKES SEC 3, BLOCK 3, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12072' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Lakes Sec 3' ,`TaxAmount` = '10498' ,`TaxRate` = '2.4245' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697624' WHERE `Matrix_Unique_ID` = '208045944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:11:30.430' ,`MLSNumber` = '52437746' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794944' ,`Longitude` = '-95.821420' ,`PhotoCount` = '43' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '1079000.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '5602' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2033' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Iconic property in the heart of Old Towne Katy. Limestone 3 bedroom, 1.5 bath home built in 1953 (2033 sq.ft) on a huge lot with beautiful big trees. Large air-conditioned shop (2715 sq. ft.) can have multiple uses - business, additional living space, storage, etc. Shop has kitchenette, full bath. Additional studio space (556 sq.ft.) is attached to home by shared covered carport. Automatic gate access and paved parking lot. Site well suited to home/business arrangement. Zoned residential/commercial. Don\'t delay, Call today!' ,`Acres` = '0.831' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PT E PT LT 6 TR 14A KATY OL .831AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '36198' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Town/Katy' ,`TaxAmount` = '11277' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697624' WHERE `Matrix_Unique_ID` = '208933963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:37:10.820' ,`MLSNumber` = '74596869' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.601194' ,`Longitude` = '-95.443528' ,`PhotoCount` = '30' ,`PostalCode` = '77053' ,`RoomCount` = '13' ,`ListPrice` = '416893.00' ,`Status` = 'Active' ,`StreetName` = 'Islandview' ,`StreetNumber` = '15407' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2719' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction - Liberty Home Builders – Trenton Plan – 2719 sqft. – 2 Story – 5 bed, 3.5 baths w/ Game room, 2 car garage w/ covered patio, Primary bedroom with bay window, High 9’ Ceilings Up/Downstairs, LVP Wood flooring family room, Kitchen/Breakfast/Powder Bath/Utility room, 24” x 12” tile floors @ Primary Bathroom/Bathrooms 2 & 3, Upgrade Level 2 Carpet, 42” Thimble Light Gray cabinets w/ Level 6 Granite tops w/ Oversized 29” x 10” undermount sink w/ upgraded backsplash w/ under-mount cabinet lighting, (3) Hanging pedant lighting @ Kitchen Island, GE Stainless Steel Appliances (Gas Range/Dishwasher/Microwave-Vented Outside), Marlana countertops @ bathrooms, Wrought Spindles at stairs, Separate Tub/Shower in primary bath, Front/Back sprinkler system. Brick/Stone Elevation, 2” Designer white blinds, Wi-Fi Garage door opener, 2 Ceiling fans (primary bedroom & Family room), Medicine cabinet @ Primary bathroom, Trash Can Pullout in kitchen, and Upgraded front door.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '2.95' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697624' WHERE `Matrix_Unique_ID` = '209164564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:37:54.293' ,`MLSNumber` = '10753591' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.601194' ,`Longitude` = '-95.443528' ,`PhotoCount` = '5' ,`PostalCode` = '77053' ,`RoomCount` = '12' ,`ListPrice` = '436036.00' ,`Status` = 'Active' ,`StreetName` = 'Islandview' ,`StreetNumber` = '15442' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction - Liberty Home Builders – Sullivan Plan – 2587 sqft. – 2 Story – Located on Lake Lot w/ (4) Sides Brick, 4 bed, 2.5 baths, Media Room & Game Room, 2 car garage w/ Covered patio, Primary bedroom with bay window, LVP Wood flooring Family room, Kitchen/Breakfast/Powder Bath/Utility room, Tile floors @ Primary Bath (12” x 24”) & Bath 2 13” x 13”, 42” Alpine Iron kitchen cabinets w/ Level 6 Omegastone counter tops w/ Upgrade Edge/Backsplash and undermount 29” x 10” depth w/ undermount sink, Undermount kitchen cabinet lighting, (3) Pedant lighting @ kitchen Island, GE Stainless Steel appliances, Marlana counter tops with upgrade undermount sinks in bathrooms, Wrought Spindles at stairs, Separate Tub/Shower in Primary bath, Front/Back sprinkler system. Brick/Stone elevation, 2” Designer White Blinds, Wi-Fi Garage Door Opener, Convenient Pull out Trash Cans in Kitchen and Must have Medicine Cabinet @ Primary Bath. Make your appointment TODAY!' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '2.95' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697624' WHERE `Matrix_Unique_ID` = '209165454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:39:16.190' ,`MLSNumber` = '57844596' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.601194' ,`Longitude` = '-95.443528' ,`PhotoCount` = '4' ,`PostalCode` = '77053' ,`RoomCount` = '9' ,`ListPrice` = '421207.00' ,`Status` = 'Active' ,`StreetName` = 'Mooring Cove' ,`StreetNumber` = '4403' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction - Liberty Home Builders – Sullivan Plan – 2587 sqft. – 2 Story – Corner Lot/Cul-de-sac w/ (3) Sides Brick, 4 bed, 2.5 baths, Media Room & Game Room, 2 car garage w/ Covered patio, Primary bedroom with bay window, LVP Wood flooring Family room, Kitchen/Breakfast/Powder Bath/Utility room, Tile floors @ Primary Bath (12” x 24”) Bath 2 (13” x 13”), 42” Snowbound White cabinets @ Kitchen w/ Lvl 6 Granite counter tops w/ Oversized 29” x 10” undermount sink w/ upgrade backsplash w/ undermount cabinet lighting, (3) Pedant lighting @ kitchen Island, GE Stainless Steel appliances, Thunder Gray cabinets @ bathrooms w/ Marlana counter tops with upgrade undermount sinks in bathrooms, Wrought Spindles at stairs, Separate Tub/Shower in Primary bath, Front/Back sprinkler system. Brick/Stone elevation, 2” Designer White Blinds, Wi-Fi Garage Door Opener, Convenient Pull out Trash Cans in kitchen and Must have Medicine Cabinet @ Primary Bath.\r\nSet your appointment to Come See Today!' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 2 Section 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '2.95' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697624' WHERE `Matrix_Unique_ID` = '209181035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:44:18.340' ,`MLSNumber` = '75730011' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.061593' ,`Longitude` = '-95.720845' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '339911.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Shetland Valley' ,`StreetNumber` = '20827' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*home is under construction.* Enjoy peace and quiet in this charming Beazer Home in Amira, boasting a brick façade, sloped ceilings, wood-look tile flooring, sprinkler system, an open great room, and a covered patio. Whip up meals for guests in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. Spend evenings relaxing in the primary suite, featuring a walk-in closet, dual vanities, a tub, and a separate shower. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are a part of the top-rated Tomball ISD. Call for more information today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697624' WHERE `Matrix_Unique_ID` = '209380616' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:37:49.443' ,`MLSNumber` = '50764956' ,`ListAgentFullName` = 'Tim Surratt' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.702835' ,`Longitude` = '-95.069722' ,`PhotoCount` = '44' ,`PostalCode` = '77351' ,`RoomCount` = '12' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Country' ,`StreetNumber` = '185' ,`StreetSuffix` = 'Lane' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular setting on a private cul-de-sac, this log cabin provides the ideal place for fishing, boating, swimming or just relaxing under all the trees. With extensive water frontage all w/metal bulkhead and approximately 2.52 (per PCAD) acres. Exquisite views. Features large outdoor kitchen, 2 car garage, boathouse, and pier. Interior: Beautiful wood finishes, wood-burning fireplace, oversized kitchen. Spacious bedrooms. The kitchen has abundant cabinets, storage, a breakfast bar, and another breakfast area. Master down. Upstairs, two bedrooms, a bath, and two flex rooms. The outdoor kitchen has a built-in gas stove, sink, and tile flooring. Live in the house as is, or build your new lake house here. A must-see. All per Seller' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A VIESCA ABST 78 TR 85' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '109771' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'A VIESCA' ,`TaxAmount` = '11618' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697625' WHERE `Matrix_Unique_ID` = '209689420' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:40:19.917' ,`MLSNumber` = '48288792' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.601194' ,`Longitude` = '-95.443528' ,`PhotoCount` = '48' ,`PostalCode` = '77053' ,`RoomCount` = '12' ,`ListPrice` = '424094.00' ,`Status` = 'Active' ,`StreetName` = 'Sailpoint' ,`StreetNumber` = '15411' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2719' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction - Liberty Home Builders – Trenton Plan – 2719 sqft. – 2 Story – Corner Lot w/ (3) Sides Brick, 5 bed, 3.5 baths & Game Room, 2 car garage w/ Covered patio, Primary bedroom with bay window, LVP Wood flooring Family room, Kitchen/Breakfast/Powder Bath/Utility room, Tile floors @ Primary Bath (12” x 24”) , 42” Cobblestone Durango cabinets w/ Lvl 3 Omega stone counter tops w/ Upgrade backsplash w/ undermount cabinet lighting, (3) Pedant lighting @ kitchen Island, GE Stainless Steel appliances, Marlana counter tops with upgrade undermount sinks in bathrooms, Wrought Spindles at stairs, Separate Tub/Shower in Primary bath, Front/Back sprinkler system. Brick/Stone elevation, 2” Designer White Blinds, Wi-Fi Garage Door Opener, Convenient Pull out Trash Cans in kitchen and Must have Medicine Cabinet @ Primary Bath.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 4, Section 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lakes' ,`TaxAmount` = '2019' ,`TaxRate` = '3.04' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697625' WHERE `Matrix_Unique_ID` = '209753341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:26:13.020' ,`MLSNumber` = '43477082' ,`ListAgentFullName` = 'Francessca Petrie' ,`ListOfficeName` = 'Soluna Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005747' ,`Longitude` = '-95.655437' ,`PhotoCount` = '24' ,`PostalCode` = '77429' ,`RoomCount` = '6' ,`ListPrice` = '298500.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Creek Farms' ,`StreetNumber` = '15326' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful and well maintained home is located in a highly sought after Cypress community. The home has recent new paint 2020, new flooring 2020, new roof 2020 and the curb appeal is undeniable recent stainless steal appliances, granite, luxury floors in kitchen and formal dining, open living, good size bedrooms, sprinkler system, home zoned to highly acclaimed Cy Fair schools and much more.' ,`Acres` = '0.1205' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 FOREST CREEK FARMS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Crk Farms' ,`TaxAmount` = '5467' ,`TaxRate` = '2.821' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697625' WHERE `Matrix_Unique_ID` = '210106523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:13:34.150' ,`MLSNumber` = '44608347' ,`ListAgentFullName` = 'Milena Canal' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.142374' ,`Longitude` = '-95.457073' ,`PhotoCount` = '25' ,`PostalCode` = '77380' ,`RoomCount` = '8' ,`ListPrice` = '334000.00' ,`Status` = 'Active' ,`StreetName` = 'Kittiwake' ,`StreetNumber` = '38' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Location! This home is nestled in the heart of Grogans Mill easy access to I-45, Restaurants, Cinema, The Pavilion, Market Street shopping, and the Mall. On a cul-de-sac lot and backing to a greenbelt the best of all worlds. Tile in high traffic areas down stairs. Primary bedroom and a secondary room downstairs. The backyard has mature trees that provide wonderful shade. Upstairs has a split plan and a game room/tv room or can also act as a 5th bedroom. This home has lots of storage closets. The garage is oversized with shelving, for home supplies.' ,`Acres` = '0.2317' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML23, LOT 12' ,`LotDesciption` = 'Cul-De-Sac,Wooded' ,`LotSize` = '10095' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric 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` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 23' ,`TaxAmount` = '3832' ,`TaxRate` = '2.0079' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697625' WHERE `Matrix_Unique_ID` = '210340197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:35:22.560' ,`MLSNumber` = '30736561' ,`ListAgentFullName` = 'Clark McFarland' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.320221' ,`Longitude` = '-95.457030' ,`PhotoCount` = '28' ,`PostalCode` = '77301' ,`RoomCount` = '6' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Dallas' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1399' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS - Spacious 2 bedroom 1 bathroom home centrally located in Conroe on a large lot. Remodeled kitchen with farmhouse sink, concrete countertops, tile flooring, new appliances. Remodeled bathroom also with concrete countertops, tile flooring, new tub and toilet. Updated electrical, fixtures.' ,`Acres` = '0.2565' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S691003 - LEWIS 03, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSTON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lewis 03' ,`TaxAmount` = '2666' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697625' WHERE `Matrix_Unique_ID` = '210430601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:31:17.067' ,`MLSNumber` = '15287962' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887006' ,`Longitude` = '-95.834568' ,`PhotoCount` = '8' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn Haven' ,`StreetNumber` = '7502' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Wildflower Series, \'\'Lantana II\'\' Plan with Elevation \'\'C\" in Beautiful Winward! Charming Single Story with 3 Beds/2 Baths/2 Car Garage! Welcoming Entry Foyer leads to an adjoining Study, Open Island Kitchen, Breakfast Nook, and Spacious Family Room! Kitchen has 36\'\' Designer Cabinets, Sparkling Countertops & a Great Appliance Pkg! En Suite Master Bath has Large Walk-in Closet and Shower! Lovely and Resilient Hard Surface Flooring in Main & Wet Areas. Walk-in Utility Room! Patio, Fully Sodded Yard & Landscape Pkg, Energy Efficient w/ 16 SEER HVAC System & MORE!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0006 BLK 003 LOT 017' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Winward' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697625' WHERE `Matrix_Unique_ID` = '210633596' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:10:39.293' ,`MLSNumber` = '97938321' ,`ListAgentFullName` = 'Marcia Gibbs' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.130792' ,`Longitude` = '-95.470258' ,`PhotoCount` = '9' ,`PostalCode` = '77380' ,`RoomCount` = '5' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Oak Lane' ,`StreetNumber` = '13' ,`StreetSuffix` = '' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location !Location ! Location ! Welcome to 13 Canyon Oak Place, this 3 bedroom, 2 bathrooms one story home located in the heart of the The Grogan\'s Mill in the Woodlands, conveniently located just few minutes from The Woodlands Mall, Water Way, Market Street, Grocery stores, I-45 and Hardy Tollway and with easy access to the Woodlands\' walking trails. Tile floor and ceiling fans in every room, beautiful open floor concept. Kitchen is updated with an over-the-range microwave and granite counter-top. It has a sunken family room with wood trim, high ceiling, and a skylight! Separate living room and den and interior utility area. Fresh paint. Zoned to CONROE ISD, located in a quiet street within a great neighborhood! Ready to move in! It won\'t last long.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Wdlnds Village Grogans Ml 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6164' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wdlnds Village Grogans Ml 14' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697625' WHERE `Matrix_Unique_ID` = '210911291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:12:55.273' ,`MLSNumber` = '7154024' ,`ListAgentFullName` = 'Jeanette Lopez' ,`ListOfficeName` = 'Value Roc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845120' ,`Longitude` = '-95.469117' ,`PhotoCount` = '19' ,`PostalCode` = '77091' ,`RoomCount` = '4' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Forest' ,`StreetNumber` = '5131' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO CANDLELIGHT OAKS VILLAGE SUBDIVISION. \r\nWALK INTO THIS BEAUTIFUL TWO STORY HOME THAT OFFERS 3BED, 2 1/2 BATH, LAMINATE AND TILE FLORING INSTALLED THROUGHOUT ENTIRE DOWNSTAIRS WITH MASTER ROOM LOCATED ON 1ST FLOOR. SEMI-NEWLY INSTALLED GRANITE COUNTERTOPS IN THE KITCHEN WITH A SEMI-NEW STOVE, DISHWASHER, MICROVE AND DISPOSAL. AS YOU MAKE YOUR WAY UPSTAIRS, YOU WILL FIND TWO BEDROOMS UPSTAIRS PERFECT FOR A STARTER OR FOREVVER HOME! CALL OR SCHEDULE YOUR SHOWING TODAY!' ,`Acres` = '0.0934' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 7 BLK 3 CANDLELIGHT OAKS VILLAGE' ,`LotDesciption` = 'Corner' ,`LotSize` = '4068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candlelight Oaks Village' ,`TaxAmount` = '4166' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697626' WHERE `Matrix_Unique_ID` = '210917364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:28:53.317' ,`MLSNumber` = '54478816' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Brookes Cunningham' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.682649' ,`Longitude` = '-95.835486' ,`PhotoCount` = '24' ,`PostalCode` = '77406' ,`RoomCount` = '16' ,`ListPrice` = '658576.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hypatia' ,`StreetNumber` = '26403' ,`StreetSuffix` = 'Trace' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston, Elevation D) CURRENTLY BEING BUILT. Oversized lot. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Spacious island kitchen open to Family room. Formal Dining and Study. Game room and Media Room upstairs. Covered back patio and attached 3 car 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.2964' ,`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 3, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12911' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`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`='1663697626' WHERE `Matrix_Unique_ID` = '211178822' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:24:38.657' ,`MLSNumber` = '64095028' ,`ListAgentFullName` = 'Anna Cuellar' ,`ListOfficeName` = 'Realty Associates - Baytown' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775784' ,`Longitude` = '-95.001799' ,`PhotoCount` = '21' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Surrey' ,`StreetNumber` = '3404' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1916' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home. The house features a very nice floor plan which includes a 3 bedroom, 2 baths. The large extra room has many entertaining possibilities like a game room, formal dinning or an extra bedroom if necessary. The living room features a vaulted ceiling with a nice fireplace for those winter cold nights. Brand new roof installed in June 2022.\r\nRestaurants and shopping just minutes away. Easy access to 330, 146 and i-10.. \r\nRoom dimensions are approximate, verify if necessary.' ,`Acres` = '0.1901' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 42 BLK 2 KOUNTRY KLUB VILLAGE SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HARLEM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kountry Klub Village 2' ,`TaxAmount` = '3495' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697626' WHERE `Matrix_Unique_ID` = '211263497' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:00:04.783' ,`MLSNumber` = '8993094' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841513' ,`Longitude` = '-95.860283' ,`PhotoCount` = '8' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '540740.00' ,`Status` = 'Active' ,`StreetName` = 'Malibu Pines' ,`StreetNumber` = '616' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2055' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SHEA HOMES NEW CONSTRUCTION in a 3.5 acre Crystal Lagoon community. This gorgeous home is located in the gated section of the community, which is walking distance from the lagoon. The 4117 plan features 3 bedrooms, 2 full bathrooms. The spacious family room has 10ft ceilings, wood flooring and 8ft doors throughout. The kitchen will have a built in cooktop, double oven configuration, microwave and dishwasher. Speaker prewire, 5.1 Surround Sound prewire, Smart-home capabilities, Energy Saving HVAC 16 SEER rated system a full sprinkler system and full gutters.\r\nUnder & over cabinet lighting, extended outdoor living, extended primary room, bay window, fireplace at lounge w/built in base cabinets and shelves, pre-plumb for future water purification system, tray ceilings at entry an primary room, valet bench.\r\nThe extended Outdoor Living will include Speaker Prewiring, Outdoor Fireplace and Outdoor Kitchenette with a built in Grill, Stainless Steel Sink and Under Counter Refrigerator.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29, block 1, Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697626' WHERE `Matrix_Unique_ID` = '211264358' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:54:49.620' ,`MLSNumber` = '4202359' ,`ListAgentFullName` = 'Lisa Kornhauser' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694498' ,`Longitude` = '-95.472552' ,`PhotoCount` = '7' ,`PostalCode` = '77401' ,`RoomCount` = '13' ,`ListPrice` = '3950000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine' ,`StreetNumber` = '5203' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '6446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity to live on a coveted 18,900 sq ft \"Bellaire Half Acre.\" Built by award-winning custom home builders Bentley Custom Homes, 5203 Pine is a European Modern home with 6 beds, 6.5 baths, and all the bells and whistles. Totaling 6,446 square feet, this one-of-a-kind home has a slurried brick and stucco exterior with steel doors. The first floor offers a study/formal living room, large den open to the chef\'s kitchen, dining room, downstairs gameroom (or media room), home office, and two bedrooms, including the luxurious primary retreat. The large den and kitchen are two stories, with high, expansive ceilings. Elevator capable. The second floor offers four additional secondary bedrooms with en-suite bathrooms and walk-in closets. There is also a loft, which could be an additional gameroom. The amazing backyard has a covered patio with summer kitchen, overlooking the large green space with room for a pool and more. Still time to completely customize!' ,`Acres` = '0.4339' ,`Area` = '17' ,`BuilderName` = 'Bentley Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 19 BRAEBURN CNTRY CLUB ESTS SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Braeburn Cntry Club Estate Sec 7' ,`TaxAmount` = '17817' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2024' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697626' WHERE `Matrix_Unique_ID` = '211270134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:11:21.270' ,`MLSNumber` = '93398416' ,`ListAgentFullName` = 'Angela Ganze' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.931241' ,`Longitude` = '-95.553610' ,`PhotoCount` = '6' ,`PostalCode` = '77422' ,`RoomCount` = '3' ,`ListPrice` = '109900.00' ,`Status` = 'Active' ,`StreetName` = 'Belt' ,`StreetNumber` = '5569' ,`StreetSuffix` = 'Street' ,`City` = 'Brazoria' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention all Investors! This is a great project home on a nice piece of land.' ,`Acres` = '0.2296' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LAS PLAYAS SEC IV (A0002 T & W ALLEY) BLK 17 LOT 73 SEC 6 PT' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Las Playas Sec IV' ,`TaxAmount` = '524' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697626' WHERE `Matrix_Unique_ID` = '211306394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:30:12.640' ,`MLSNumber` = '66397396' ,`ListAgentFullName` = 'Kacey Valley' ,`ListOfficeName` = 'Tramco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.020995' ,`Longitude` = '-95.559652' ,`PhotoCount` = '14' ,`PostalCode` = '77379' ,`RoomCount` = '5' ,`ListPrice` = '232000.00' ,`Status` = 'Active' ,`StreetName` = 'Benwick' ,`StreetNumber` = '9210' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute three bedroom two bath home in great location. Easy access to restaurants, entertainment, and shopping. Primary bedroom has en-suite bathroom. Spacious living/kitchen area. Separate office/study space. Fenced in backyard with covered patio. Schedule your showing today!' ,`Acres` = '0.1494' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 6 017*M1875900-004-006-042 MEMORIAL CHASE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Memorial Chase Sec 04' ,`TaxAmount` = '4068' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697626' WHERE `Matrix_Unique_ID` = '211357498' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:31:54.693' ,`MLSNumber` = '12183036' ,`ListAgentFullName` = 'Elsa Martinez' ,`ListOfficeName` = 'JWang Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800520' ,`Longitude` = '-95.377355' ,`PhotoCount` = '28' ,`PostalCode` = '77009' ,`RoomCount` = '14' ,`ListPrice` = '1095000.00' ,`Status` = 'Active' ,`StreetName` = 'Tabor' ,`StreetNumber` = '1007' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '2231' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 1007 Tabor Street.This Home is located in the heart of Historic Brooke Smith neighborhood of the Heights. Amaizing property features 4 Bedrooms 4 1/2 Bathrooms,3 Car Garage with 4 additional parking space.\r\nElegant foyer entrance with curved metal stair case,Spectacular Kitchen with granite counters and lots of cabinetry space large living area with luxury tray ceilings, extra space on 2nd floor that can be use as an office, best of all this home includes a Income Producing garage apartment with 2 additional Bedrooms, 1 full bath and a fully equipped kitchen.Strategically Located minutes away from Houston’s main districts including Downtown Houston, Texas Medical Center, Houston Farmers Market, close to the MetroRail, Montie Beach Park around the corner enjoy several amenities including, tennis court, sports field, hike and bike trails, and playground areas. Call for a private showing.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 111 BROOKE SMITH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Brooke Smith' ,`TaxAmount` = '15990' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697627' WHERE `Matrix_Unique_ID` = '211358903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:15:10.023' ,`MLSNumber` = '49600915' ,`ListAgentFullName` = 'Mitchell Haynes' ,`ListOfficeName` = 'BuyBroker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824251' ,`Longitude` = '-95.449130' ,`PhotoCount` = '12' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Wakefield' ,`StreetNumber` = '2102' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Custom Home ready to be built by Hummingbird Hideaway Homes. Massive Master Suite!! Master Bath offers dual entry shower, soaking tub, Huge walk-in closet. Oversized secondary bedrooms with grand walk-in closets! Outdoor kitchen included. Mudroom entry off garage, tons of storage. Construction has not yet begun, so don\'t miss out on having the option of choosing all the finishes. Plans are being approved with the city now and we will be ready to build when you are!!! Contact me for an unbelievable 3d video walk through of this ultra modern custom home!' ,`Acres` = '0.1644' ,`Area` = '9' ,`BuilderName` = 'Hummingbird Hideaway' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 BLK 6 OAK FOREST SEC 13' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7162' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '6827' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697627' WHERE `Matrix_Unique_ID` = '211361892' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:26:03.317' ,`MLSNumber` = '27515892' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657219' ,`Longitude` = '-95.118920' ,`PhotoCount` = '22' ,`PostalCode` = '77505' ,`RoomCount` = '15' ,`ListPrice` = '512669.00' ,`Status` = 'Active' ,`StreetName` = 'Leighton' ,`StreetNumber` = '7803' ,`StreetSuffix` = 'Trail' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story Walton II home with 4 bedrooms, 3.5 baths and 3 car attached garage. Convenient home office tucked off hall. Elegant dining room with easy access to gourmet kitchen. Beautiful maple cabinets, quartz countertops, farmhouse sink and walk-in pantry in kitchen. Huge walk-in closet, dual vanity sinks, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a versatile activity room and all secondary bedrooms. Bedroom 2 features an en-suite bath. Enjoy your evening relaxing on your cover patio. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '1/3/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697627' WHERE `Matrix_Unique_ID` = '211363947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T14:43:17.347' ,`MLSNumber` = '70156143' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Danielle Frazer' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.652208' ,`Longitude` = '-95.121650' ,`PhotoCount` = '22' ,`PostalCode` = '77505' ,`RoomCount` = '15' ,`ListPrice` = '499990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wrightwood' ,`StreetNumber` = '7607' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story Walton II home with 4 bedrooms, 3.5 baths and 3 car attached garage on a corner lot. Convenient home office tucked off hall. Elegant dining room with easy access to gourmet kitchen. Beautiful maple cabinets, quartz countertops, farmhouse sink and walk-in pantry in kitchen. Huge walk-in closet, dual vanity sinks, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a versatile activity room and all secondary bedrooms. Bedroom 2 features an en-suite bath. Enjoy your evening relaxing on your cover patio. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '24/1/5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697627' WHERE `Matrix_Unique_ID` = '211364915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T15:35:58.030' ,`MLSNumber` = '83587465' ,`ListAgentFullName` = 'Pat Bean' ,`ListOfficeName` = 'RE/MAX Suburbia' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.367624' ,`Longitude` = '-95.287502' ,`PhotoCount` = '40' ,`PostalCode` = '77511' ,`RoomCount` = '9' ,`ListPrice` = '864000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 172' ,`StreetNumber` = '4731' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3476' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Perfect Oasis! This fantastic 12+ Acres, home features 6 bedrooms 3 bathrooms, beautiful family room, large open kitchen w/reverse osmosis system & bight eating area. Good size utility room w/folding area. Home office. Plantation shutters on most windows. There is a possibility to make separate quarters out of 3 bedrooms on one side of the home. The seller has the 3 rooms with beds and wardrobe storage. Covered parking. Across the drive is an office w/2 offices, 2 conference rooms, storage area and bathroom. There is also a storage garage. Covered patio over looking pool. Barn. One stall lean-to. Updates: OSSF 1000 gal/day Septic system including pump tank, plumbing to ATU, sprinkler heads, etc.. Water well- 1\" water meter, wiring on pressure switch, chlorinator pump. Appliances, flooring, paint. A great place to live & work. Call Today To Visit This One Before It\'s Sold.' ,`Acres` = '12.26' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOST ROAD RANCH S/D SEC I (A0100 F MOORE) LOT 11 ACRES 5.71' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '533915' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lost Road Ranch Sub Sec I' ,`TaxAmount` = '11702' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697627' WHERE `Matrix_Unique_ID` = '211367920' --> Updated record success