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-07T01:22:00.760' ,`MLSNumber` = '25798388' ,`ListAgentFullName` = 'Brady Burnett' ,`ListOfficeName` = 'Burnett Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797409' ,`Longitude` = '-95.412976' ,`PhotoCount` = '30' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '609990.00' ,`Status` = 'Active' ,`StreetName` = 'Prince' ,`StreetNumber` = '1436' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2449' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Single Family in Popular Heights area. Open floor plan with lots of space. Walking distance to many restaurants and shopping. This one want last so make your appointment today. Will be completed in February for March move-in' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = 'Ryan Barrett Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 488 HOUSTON HEIGHTS ANNEX' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights Annex' ,`TaxAmount` = '7575' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695337' WHERE `Matrix_Unique_ID` = '204301305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '66286609' ,`ListAgentFullName` = 'Ryan Jockers' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.012533' ,`Longitude` = '-95.488276' ,`PhotoCount` = '37' ,`PostalCode` = '77068' ,`RoomCount` = '13' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Moss' ,`StreetNumber` = '15703' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular describes this one-of-a-kind, 4 bedroom, 3.5 bathroom home, nestled in the heart of the distinctive Olde Oaks subdivision. The sellers have spared no expense on the beautifully updated MODERN MARVEL l!!! Be Wowed by the custom glass & iron front door, travertine floors, high beamed & vaulted ceilings, open floor plan, wrought iron stairway, amazing recently added balcony, formal dining, recently added sunroom, and spacious family room w/ cozy fireplace. Get swept away in the backyard oasis featuring glistening pool & spa, & amazing recently added pergola. The exquisite kitchen features granite countertops, glass cabinets, Island w/ cooktop, breakfast bar, & stainless steel appliances. Primary and Secondary bedrooms also have beautiful recently added additions. Enjoy easy access to membership at the Northgate Country Club, & close proximity to the new School of Science & Technology. Lovely hiking & walking trails, close to Downtown, The Woodlands, & IAH airport!' ,`Acres` = '0.2342' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 15 OLDE OAKS SEC 1' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '10200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '463' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Olde Oaks' ,`TaxAmount` = '5598' ,`TaxRate` = '2.4246' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695337' WHERE `Matrix_Unique_ID` = '206958302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '2292082' ,`ListAgentFullName` = 'Roger Pool' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472091' ,`Longitude` = '-95.519673' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '16' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Woods' ,`StreetNumber` = '10026' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful spacious home is a RARE FIND, the owner built their perfect home and closed on it 12/30/2021. New in every way and feature. This white painted brick with a black roof home in Oakhill Trails features a courtyard 227 SF Casita with full bath and walk-in closet. The main home offers 4 additional bedrooms with 3½ baths, a 3-car garage, a huge open concept family room, kitchen with a huge island, white quartz countertops throughout with tons of cabinets, dining area, and sitting area. This opens to a 21’ X 12’ covered patio through a 4 panel 8’ X 16’ glass slider door. The sodded and fenced backyard is 65’ X 65’ PERFECT for a pool. The primary suite has a bay window, a free-standing soaker tub, and seamless glass shower, with large double vanity, and an oversized closet which opens to a large laundry room. Also, a ½ bath and a dedicated study with french doors downstairs. Upstairs features a media room, 3 additional bedrooms, one large jack & jill bath + another full bath.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'Sienna Plantation Sec 34A, Lot 47, Block 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10086' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '11323' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695337' WHERE `Matrix_Unique_ID` = '208128097' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '18484641' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747938' ,`Longitude` = '-95.537091' ,`PhotoCount` = '34' ,`PostalCode` = '77063' ,`RoomCount` = '7' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Brook' ,`StreetNumber` = '9613' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story townhome 3 bedrooms with the primary room are downstairs. Completely remodeled tiles downstairs and wood floor upstairs. Spacious living room with high ceiling, great patio overlooking the bayou. Just a few steps from the community swimming pool and tennis courts. minuets to I 10, Beltway 8, and Memorial City Medical Center. New AC, water heater 2022, roof 2017. A two-car garage is attached. Lots of natural lights and skylights.' ,`Acres` = '0.0688' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 10 WOODLAKE FOREST SEC 4B R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'EMERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlake Forest' ,`TaxAmount` = '13258' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695337' WHERE `Matrix_Unique_ID` = '208384161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '15176471' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679436' ,`Longitude` = '-95.830659' ,`PhotoCount` = '6' ,`PostalCode` = '77406' ,`RoomCount` = '6' ,`ListPrice` = '444900.00' ,`Status` = 'Active' ,`StreetName` = 'Cecilia Star' ,`StreetNumber` = '10502' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'EPERRY HOMES NEW CONSTRUCTION! Entry leads to open family room, dining area and kitchen. Large windows and 10-foot ceilings throughout. Kitchen features generous counter space, corner walk-in pantry and large island with built-in seating space. Primary suite includes bedroom with 10-foot ceiling. Double doors lead to primary bath with dual vanities, separate glass-enclosed shower, garden tub and walk-in closet. Covered backyard patio. Mud room with adjoining closet is just off two-car garage' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Candela Lot 22, Blk 1, Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695337' WHERE `Matrix_Unique_ID` = '208749346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '7037431' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.365547' ,`Longitude` = '-95.669965' ,`PhotoCount` = '19' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '349640.00' ,`Status` = 'Active' ,`StreetName` = 'Youth Water Road' ,`StreetNumber` = '910' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOVELY NEW D. R. HORTON BUILT 4 BEDROOM!! Gourmet Island Kitchen with Large Corner Pantry & Abundant Cabinetry, Open Living Space, & Lovely Dining Area! Primary Suite - Lovely Garden Bath with Dual Sinks, Separate Tub & Shower, & Enormous Walk-In Closet! Spacious Second Bedrooms/Guest Suites! Covered Patio Enhances Backyard! Fantastic Community with Recreation Center, SplashPad, Playground, Pavilion, & Pickleball Courts! Wonderful MISD and zoned to Lake Creek High School! MUST SEE! Nestled in the rolling hills along FM 2854, you\'ll find FAIRWATER the NEWEST community in Montgomery, TX! Zoned to the prestigious Montgomery ISD students receive the best education in some of the HIGHEST rated schools in the state! Come see why we are the FASTEST growing community in Montgomery, TX' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Fairwater 07, BLOCK 2, Lot 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6901' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas 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' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '3.17' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695337' WHERE `Matrix_Unique_ID` = '209259253' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '43844453' ,`ListAgentFullName` = 'Jason Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684407' ,`Longitude` = '-95.096233' ,`PhotoCount` = '40' ,`PostalCode` = '77536' ,`RoomCount` = '10' ,`ListPrice` = '424900.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Brook' ,`StreetNumber` = '2510' ,`StreetSuffix` = 'Drive' ,`City` = 'Deer Park' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3892' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 4 bedroom home has been impeccably maintained and cared for. The large open concept floor plan provides tall ceilings and solid wood floors throughout. The kitchen is light and bright and provides more than ample space to enjoy with friends and family. The first floor master bedroom is quietly tucked away in the back of the home with a generous master bath and walk in closets. The second floor offers a large game room and 3 additional bedrooms. One of which could be used as a second master or in-law suite given its size. The recently added back patio is perfect for entertaining friends and family. Call today to schedule your private tour!' ,`Acres` = '0.1791' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 PINEY POINT SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (LA PORTE)' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Piney Point Sec 02' ,`TaxAmount` = '9564' ,`TaxRate` = '2.7308' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695338' WHERE `Matrix_Unique_ID` = '209409418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '46930398' ,`ListAgentFullName` = 'Sharon Ballas' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751604' ,`Longitude` = '-95.467859' ,`PhotoCount` = '49' ,`PostalCode` = '77056' ,`RoomCount` = '17' ,`ListPrice` = '3325000.00' ,`Status` = 'Active' ,`StreetName` = 'Huckleberry' ,`StreetNumber` = '5262' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '7333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exciting 2022 enhancements include Segreto plaster finish walls in entry, dining, family room, primary suite & bath, kitchen/breakfast, formal powder room, front stair hall & Segreto finish on fireplaces.* Fabulous architecture & interiors, the ever so important study features softly painted paneled walls, beautiful millwork & fireplace. The stunning family room w/ soaring beamed ceiling enjoys a massive fireplace & outstanding wine room. Warm & inviting kitchen w/ beamed ceiling, brick accents, wood burning fireplace & huge butler’s pantry. Primary Suite is an elegant retreat w/ spectacular 2021* bath appointed w/freestanding tub, gorgeous tilework, white marble, wonderful spa shower & extraordinary closet. Game room w/ chic chevron patterned wood flooring. Delightful outdoor entertaining w/ a covered brick patio & summer kitchen overlooking the tranquil pool w/ cascading water feature. Craft room over garage. Water softener. Central Vac. Mosquito system. Herb garden. (*per seller)' ,`Acres` = '0.3471' ,`Area` = '22' ,`BuilderName` = 'Cyrus Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 29 TANGLEWOOD SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Sec 07' ,`TaxAmount` = '55004' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695338' WHERE `Matrix_Unique_ID` = '209591954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '26083116' ,`ListAgentFullName` = 'Pamela Pena' ,`ListOfficeName` = 'RE/MAX GO' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.882559' ,`Longitude` = '-95.721348' ,`PhotoCount` = '36' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Rising Brook' ,`StreetNumber` = '7118' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1965' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This beautiful home has 4 bedrooms and 2.5 bathrooms. Tile flooring and crown molding throughout the first floor. The primary bedroom has his and her closets. There is a designated office space and outside patio/pavilion for entertaining. This home is close to restaurants and shopping and has easy access to the main highways. Great school district.' ,`Acres` = '0.1232' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 3 TEALBROOK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5367' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tealbrook' ,`TaxAmount` = '4719' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663695338' WHERE `Matrix_Unique_ID` = '209596466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '66327634' ,`ListAgentFullName` = 'Danielle Zequeira' ,`ListOfficeName` = 'Abundant Living Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.715368' ,`Longitude` = '-95.461682' ,`PhotoCount` = '31' ,`PostalCode` = '77401' ,`RoomCount` = '4' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Wedgewood' ,`StreetNumber` = '4716' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellaire' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate, well maintained original Bellaire home on a large lot with mature trees and beautiful landscaping. Never flooded! Zoned to the extremely desirable Bellaire High School, this home boasts original hardwoods through most of the house and has many charming features. Easy access to 610 and 59. Great, functional layout and beautiful vintage details. This home would be perfect for anyone wanting a cozy, smaller home in Bellaire. You can live now and build later or as an investment for an area that continues to appreciate!' ,`Acres` = '0.1865' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 2 WEST POST OAK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West Post Oak' ,`TaxAmount` = '9755' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695338' WHERE `Matrix_Unique_ID` = '209610954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '39180372' ,`ListAgentFullName` = 'Carla Wade' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.204651' ,`Longitude` = '-94.938738' ,`PhotoCount` = '40' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '664900.00' ,`Status` = 'Active' ,`StreetName` = 'San Domingo' ,`StreetNumber` = '13839' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom, 3 bath beach house has been beautifully updated with soft coastal hues and is sold furnished with just a few exclusions. This beauty has it\'s own lift to make life easy for those that don\'t love walking upstairs! \r\n It features 2 decks on the main living level and a roof top deck for nice views. Pirates beach is a very desirable beachfront neighborhood with beach access. This house offers an extended 2 car garage, so much storage including 2 ground level storage rooms. There is a breezeway, a double covered parking area plus a covered patio area at the back of the house. The large driveway allows for lots of friends and family gatherings. House has been a successful vacation rental, and would make a fantastic full time home or investment property!' ,`Acres` = '0.14' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 45 LOT 2 BLK 11 PIRATES BEACH SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pirates Beach' ,`TaxAmount` = '10909' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695338' WHERE `Matrix_Unique_ID` = '209626000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '8931669' ,`ListAgentFullName` = 'Brady Burnett' ,`ListOfficeName` = 'Burnett Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797409' ,`Longitude` = '-95.412976' ,`PhotoCount` = '10' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '594990.00' ,`Status` = 'Active' ,`StreetName` = 'Prince' ,`StreetNumber` = '1436' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2449' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = 'Ryan Barrett Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 487 HOUSTON HEIGHTS ANNEX' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights Annex' ,`TaxAmount` = '7575' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695338' WHERE `Matrix_Unique_ID` = '209866563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '24180428' ,`ListAgentFullName` = 'Porshae\' Brown' ,`ListOfficeName` = 'Equinox Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.597540' ,`Longitude` = '-95.805989' ,`PhotoCount` = '20' ,`PostalCode` = '77471' ,`RoomCount` = '5' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Wembley' ,`StreetNumber` = '2442' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2453' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your like new Saratoga Home in the beautiful community of Kingdom Heights! This Appealing & Thriving Community is WONDERFULLY LOCATED w/ EASY ACCESS to I-69, HWY 90, & 99; Shopping, & Entertainment. Attractive, LOW TAX RATE & HOA! Your NEW HOME has been well-maintained in LIKE NEW CONDITION--it is PRICED TO SELL! VERY SPACIOUS 3 BEDROOM + 3 FULL BATHS, Features 3 BEDROOMS DOWN, LARGE GAME ROOM Upstairs + Study! Enjoy LIGHT, BRIGHT, & AIRY LIVING w/ the OPEN, & FLOWING DESIGN, UPGRADED w/ ELEGANT, FASHION-FORWARD FINISHES! Revel in your LUXURIOUSLY-APPOINTED FEATURES: EXQUISITE GRANITE Countertops & GORGEOUS SOLID FLOORING Delights & BEAUTIFIES the SPACE. ENERGY EFFICIENT SPRAY FOAM INSULATION, Recessed Lighting, & High Ceilings! Enjoy Outdoor Fun/BBQ in your HUGE BACKYARD! RELISH the SHORT WALK to the Community Center , Fully-Equipped w/ WEIGHT ROOM & OLYMPIC SIZED POOL! Schedule your showing today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'KINGDOM HEIGHTS SEC 5, BLOCK 7, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Split Level,Traditional' ,`Subdivision` = 'Kingdom Heights Sec 5' ,`TaxAmount` = '1573' ,`TaxRate` = '2.7948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663695338' WHERE `Matrix_Unique_ID` = '209898449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '19174376' ,`ListAgentFullName` = 'Jeffrey Whitespeare' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.279072' ,`Longitude` = '-95.738953' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '1395000.00' ,`Status` = 'Active' ,`StreetName` = 'Bingham' ,`StreetNumber` = '7519' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction with estimated end of August completion. This gorgeous 1.5 story home is located on a beautiful, wooded cul-de-sac lot in the highly sought-after High Meadow Estates neighborhood.This home has a charming modern, farmhouse exterior & features 4 bedrooms, 3.5 bath, & a large game room on the 2nd floor. Sitting on 1.8 acres, this is truly a custom home complete with custom woodwork throughout, expansive back porch great for entertaining, open concept main living area with 14 foot ceilings, large walk in pantry, & an elaborate mudroom with custom shelving. This home also includes a huge game room upstairs with plenty of space for media, pool table, etc. This home sits on an ideal lot & is full of detail & charm. Due to the recent expansion of toll road access;High Meadows Estates is easily accessible with a short drive from State HWY 249. Subdivision also includes a stocked pond, olympic style pool, tennis court, basketball court, playground & clubhouse access year round!' ,`Acres` = '1.8' ,`Area` = '39' ,`BuilderName` = 'Phoenix Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S929700 - The Reserve At High Meadow Estates, BLOCK 1, Lot 4' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '78412' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'High Meadow Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695339' WHERE `Matrix_Unique_ID` = '209912513' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '34445655' ,`ListAgentFullName` = 'Leah McKinney' ,`ListOfficeName` = 'Exit Realty Property Pros' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.118193' ,`Longitude` = '-94.181783' ,`PhotoCount` = '41' ,`PostalCode` = '77706' ,`RoomCount` = '4' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'Rehan Wood' ,`StreetNumber` = '6505' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2727' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location! Be the first to enjoy this home in the newly constructed Whispering Heights Subdivision. Conveniently located off of Folsom and Major with restaurants, shopping, and major thoroughfares galore. This home offers an concept kitchen features beautiful white and grey quartz countertops, pot filler and plenty of counter-space. The extra tall ceiling give the feel of endless space. Split bedroom with Jack and Jill bath for two bedroom, a hall bath to service a bedroom and guest. The Primary bath features a jetted tub and separate shower with large vanities and connecting Primary closet. The Primary Bedroom is full of light with a bay window adding extra space for a sitting area, or a multitude of other options. Privacy fence in backyard. You have got to see this home!' ,`Acres` = '0.21' ,`Area` = '51' ,`BuilderName` = 'REDWOOD DEVELOPMENT' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 1 WHISPERING HEIGHTS PH 1 .210AC' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9148' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'GUESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'WHISPERING HEIGHTS' ,`TaxAmount` = '1962' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695339' WHERE `Matrix_Unique_ID` = '210035792' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '22213253' ,`ListAgentFullName` = 'Claudia Canfield' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804800' ,`Longitude` = '-95.556351' ,`PhotoCount` = '25' ,`PostalCode` = '77043' ,`RoomCount` = '6' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Bend' ,`StreetNumber` = '1810' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1968' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Owner remodeled home with high end sustainable finishes in the Shadow Oaks subdivision. Fully remodeled thought by its owners in 2020 with the highest end finishes available. Cool off this summer in your Mediterranean style white fiberglass pool. Solid hardwood acacia flooring all throughout, kitchen remodel with stainless steel appliances, custom vent hood, custom dishwasher panel, and custom birch cabinets. The Brazilian quartzite natural quarried stone countertops. The Walker Zanger 6th Avenue backsplash in white cocoon mosaic gives a bright sophisticated finish to the look which is modern, but more interesting than subway tile. The added floor to ceiling tempered glass window makes this kitchen even brighter and creates a breakfast nook with a view of your backyard pool. The pool reflection sparkling on the ceiling, white brick gas fireplace and plantation shutters complete the interior coastal vibe. This house won\'t last long come and see it today.' ,`Acres` = '0.2024' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 17 SHADOW OAKS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8816' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Oaks Sec 04' ,`TaxAmount` = '7861' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695339' WHERE `Matrix_Unique_ID` = '210043336' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '55384174' ,`ListAgentFullName` = 'Maria Bonilla' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.643339' ,`Longitude` = '-95.249957' ,`PhotoCount` = '13' ,`PostalCode` = '77075' ,`RoomCount` = '3' ,`ListPrice` = '293000.00' ,`Status` = 'Active' ,`StreetName` = 'Scranton' ,`StreetNumber` = '9328' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This NEW Construction Home is a 1-Story, 3 Beds, 2 Baths with Covered Patio! The Kitchen features custom cabinets with an open concept. High ceilings and wood tile throughout the entire home. Perfect Home for entertaining. This property is minutes from the shopping center, airport and freeways. No HOA. \r\nSchedule your showing today' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'na' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'JESSUP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'EASTHAVEN VISTA' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663695339' WHERE `Matrix_Unique_ID` = '210344220' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '76047741' ,`ListAgentFullName` = 'Malik Riles' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.413144' ,`Longitude` = '-95.009623' ,`PhotoCount` = '29' ,`PostalCode` = '77591' ,`RoomCount` = '10' ,`ListPrice` = '274500.00' ,`Status` = 'Active' ,`StreetName` = 'Voyager' ,`StreetNumber` = '8923' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 8923 Voyager Drive! This home was built to maximize connectivity without sacrificing functionality. The open concept allows you to cook, entertain, and interact with everyone from the kitchen to the family room. The office in the front of the home features double doors that are great for a little privacy. Your primary suite has spectacular windows, a double vanity, and a large walk-in closet. The backyard is incredibly roomy. It features an extended patio that is perfect for entertaining your guests and a dog run to keep your puppies from free ranging throughout your yard. Truly the ideal home for any buyer!' ,`Acres` = '0.1503' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 MARLOW LAKE SEC 1B (2019) ABST 180' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6548' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Final Plat/Marlow Lake Sec 1b' ,`TaxAmount` = '7645' ,`TaxRate` = '3.3628' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695339' WHERE `Matrix_Unique_ID` = '210398695' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '45389742' ,`ListAgentFullName` = 'Pamela Castello' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.298296' ,`Longitude` = '-94.920328' ,`PhotoCount` = '26' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '699907.00' ,`Status` = 'Active' ,`StreetName` = 'Neptune' ,`StreetNumber` = '302' ,`StreetSuffix` = 'Circle' ,`City` = 'Tiki Island' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great House in one of the most desired communities, with 4 bedrooms, fish from your backyard or go in your boat this one has 2 boat docks. Epoxy on deck floor garage area. Lots of time left in the summer to enjoy and have fun, come on down and take the tour. Hope to See You Soon!' ,`Acres` = '0.126' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 124 TIKI ISLAND SEC 8' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '5489' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tiki Island 8' ,`TaxAmount` = '10900' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695339' WHERE `Matrix_Unique_ID` = '210469039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '40221222' ,`ListAgentFullName` = 'Claudia Hellmund' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747455' ,`Longitude` = '-95.519626' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '3200000.00' ,`Status` = 'Active' ,`StreetName` = 'MOTT' ,`StreetNumber` = '39' ,`StreetSuffix` = 'Lane' ,`City` = 'Piney Point Village' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6234' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Every once in a while you come across a very special home that makes your heart skip a beat...Opportunity awaits at one of the most private coveted streets at 39 Mott Lane, located in highly sought after Piney Point. This unique property offers expansive clean lines with a sophisticated contemporary sleek design that features modern geometry with the warmth of a sleek elegant architecture. Sits on an acre and a quarter elevated lot with a crisp mid century feel throughout. With it\'s stunning architecture and breathtaking views through the floor to ceiling glass windows and doors to the extensive lush grounds, reflective pool and bayou, this property stands out from the rest. Presents a front motor court, impressive gallery entry, formal living and dining with seamless fluidity to the outdoors. Gourmet kitchen open to breakfast area & family room catered for today\'s lifestyle. At second level offers 4 ensuite bedrooms plus luxurious primary retreat with grand bath, game room & laundry.' ,`Acres` = '1.2659' ,`Area` = '23' ,`BuilderName` = 'Woodmark Constructio' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 EVERGREEN POINT' ,`LotDesciption` = 'Ravine,Water View,Wooded' ,`LotSize` = '55143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Evergreen Point' ,`TaxAmount` = '45615' ,`TaxRate` = '2.1721' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695339' WHERE `Matrix_Unique_ID` = '210483994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '77038799' ,`ListAgentFullName` = 'Michael McSorley' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043263' ,`Longitude` = '-95.653785' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '15' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Ponderosa Bend' ,`StreetNumber` = '15522' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3143' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your sanctuary awaits at this spectacular 4BD/3.5BA Energy Star Sustained Excellence Award-winning Beazer home! Whether entering from the impressive 3-car garage or covered front porch, you will love the open sight-lines of spacious layout & high ceilings. From the foyer, French doors into the office spill natural light from the windows on the front porch. A sophisticated dining area naturally flows to the covered patio & fenced yard as well as into the kitchen that sparkles in elegance with quartz counters & SS appliances. A sophisticated main floor primary indulges a spa-like bath & walk-in closet, while three bedrooms & two full baths tuck themselves upstairs. This well-planned home has so much space including an upstairs bonus room & home theater. Amenities are the name of the game in this Wildwood community which include a swimming pool, cabana & playground, with dynamic location with easy access to highways & downtown, zoned to an amazing school district with a low 2.8 tax rate.' ,`Acres` = '0.1818' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 WILDWOOD AT OAKCREST NORTH SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wildwood/Oakcrest North' ,`TaxAmount` = '10287' ,`TaxRate` = '2.8172' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695340' WHERE `Matrix_Unique_ID` = '210640085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '71637206' ,`ListAgentFullName` = 'Angela Chiang' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800710' ,`Longitude` = '-95.414857' ,`PhotoCount` = '19' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = '17th' ,`StreetNumber` = '935' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2309' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredibly rare FOUR bedroom, 3/1 bath home in a gated community in the lively Greater Heights/Shady Acres area with no HOA fees. Sought after 1st floor living, dining and kitchen with stainless steel appliances and gas stove. Huge primary bedroom with en suite bath and 2 secondary bedrooms on the 2nd floor. Large 4th bedroom with full bath on the third floor could also be used as an office, game room, or media room. Upgrades include: tankless water heater (2019), new carpet (2022), refinished wood floors (2022), central vacuum, sensor lighting with dimmers, and more. Fantastic neighborhood with tons of new restaurants and entertainment nearby.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 WEST 17TH SYS' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2758' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'West 17th Sys' ,`TaxAmount` = '8815' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695340' WHERE `Matrix_Unique_ID` = '210714785' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '83047473' ,`ListAgentFullName` = 'Manmohan Bhatia' ,`ListOfficeName` = 'Tasnim Moolla' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949089' ,`Longitude` = '-95.694624' ,`PhotoCount` = '32' ,`PostalCode` = '77433' ,`RoomCount` = '5' ,`ListPrice` = '429990.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset Elm' ,`StreetNumber` = '18327' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning recent construction by David Weekley Homes features 3 bedrooms, 2 full baths, 1 half bath, a flex room, spacious laundry room, mud room and an attached 2 car garage. It has a study that looks out to the new walking trail right across the street. A gorgeous kitchen with a large island, fabulous stove & stainless steel appliances that opens to the family room/breakfast area for an open concept feel. A beautiful gas fireplace in the family room & high ceilings throughout the home. An extended, large covered patio with TV connection and a gas connection for a barbecue. The master bedroom connects to a luxurious, relaxing bathroom with a large soaking bathtub, frameless shower with 3 niches to keep bathroom items nicely organized, dual sinks & a deluxe walk-in closet. Towne Lake is one of the most sought after master-planned developments offering amenities, restaurants and a lake lifestyle in the heart of Cypress. The gym, pool, club house and park are all down the street!' ,`Acres` = '0.1377' ,`Area` = '25' ,`BuilderName` = 'David Weekly' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 TOWNE LAKE SEC 61' ,`LotDesciption` = 'Other' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1674' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Towne Lk' ,`TaxAmount` = '2777' ,`TaxRate` = '3.471' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663695340' WHERE `Matrix_Unique_ID` = '210728098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '14252878' ,`ListAgentFullName` = 'Stephen Hallmark' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747583' ,`Longitude` = '-95.636822' ,`PhotoCount` = '33' ,`PostalCode` = '77077' ,`RoomCount` = '13' ,`ListPrice` = '770000.00' ,`Status` = 'Active' ,`StreetName` = 'Quiet Bluff' ,`StreetNumber` = '14206' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This luxury home was designed and built home by Kickerillo. It is in a gated community. The home is on a cul-de-sac street. Mature landscape. Backyard is large enough for a pool and yard area. The floor plan is ideal for modern living and functionality. Formal living room/office and formal dining room have hardwood floors and coffered ceilings. The kitchen has an island, granite countertops, and plenty of storage. Breakfast area is just off the kitchen. The breakfast area and kitchen are open to the main living area. Master suite includes a large bathroom and an “L” shaped walk-in closet. A large game room, 2 large secondary bedrooms (one with ensuite bath), and work/study area upstairs. There are two oversized climate-controlled storage rooms upstairs. Large laundry room with sink. Special features: crown molding, plantation shutters, floor to ceiling windows for natural light, custom window coverings, jetted master tub, large back patio, and water feature in front.' ,`Acres` = '0.1961' ,`Area` = '31' ,`BuilderName` = 'Kickerillo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 LAKES OF PARKWAY SEC 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Pkwy Sec 09' ,`TaxAmount` = '14834' ,`TaxRate` = '2.3907' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695340' WHERE `Matrix_Unique_ID` = '210755116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T01:22:00.760' ,`MLSNumber` = '26385019' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.236237' ,`Longitude` = '-95.709557' ,`PhotoCount` = '13' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '278490.00' ,`Status` = 'Active' ,`StreetName` = 'Cottontop Mountain' ,`StreetNumber` = '14523' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely BRAND NEW EXPRESS HOME! This beautiful Open Concept property has a large kitchen that is open to the family room & dining room! Primary suite offers a HUGE walk in closet! Features include 30\" Flat panel maple cabinets w/ crown molding, exotic granite, 4 burner gas cooktop w/ SS appliances, tile wall surrounds in bathrooms, smart home system, front & back sod, fully front landscape,tankless water heater, LED lighting, and more! Large covered patio overlooks the fenced backyard! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR HORTON/ EXPRESS' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '15/1/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695340' WHERE `Matrix_Unique_ID` = '210772746' --> Updated record success