Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:56:13.227' ,`MLSNumber` = '76430312' ,`ListAgentFullName` = 'Kimberly Whaley' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765427' ,`Longitude` = '-95.552014' ,`PhotoCount` = '14' ,`PostalCode` = '77024' ,`RoomCount` = '10' ,`ListPrice` = '1615000.00' ,`Status` = 'Active' ,`StreetName` = 'Egerton Crescent Drive' ,`StreetNumber` = '408' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! CORNER PARK VIEW! Built by Pelican Builders and designed by George Hopkins. Plan G features beautiful exterior elevations, first-floor living, wood floors throughout living area, crown molding, high ceilings and outdoor living! 1st floor open-layout living with fireplace, dining and access to outdoor living; abundance of light from wall of windows and french doors to side courtyard. Gourmet kitchen features Bosch stainless steel appliances, quartz countertops and Benedettini cabinetry. 2nd floor Primary suite with luxurious bath including soaking tub and walk-in shower, separate vanities and separate his&hers walk-in closets; ensuite secondary bedroom with walk-in closet; study and utility room. 3rd floor ensuite secondary bedroom; media room and bar with covered rooftop terrace! Elevator capable, two-car garage, first-floor living with outdoor space. BY APPOINTMENT ONLY.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'Pelican Builders Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 MEMORIAL GREEN SEC 2 R/P & EXTN 2ND PAR R/P' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '2584' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Green' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294932' WHERE `Matrix_Unique_ID` = '196844659' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:53:38.320' ,`MLSNumber` = '472625' ,`ListAgentFullName` = 'Kimberly Whaley' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765409' ,`Longitude` = '-95.553105' ,`PhotoCount` = '11' ,`PostalCode` = '77024' ,`RoomCount` = '8' ,`ListPrice` = '1410000.00' ,`Status` = 'Active' ,`StreetName` = 'Wetherby Terrace' ,`StreetNumber` = '411' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! LAST REMAINING CORNER LOT! Memorial Green is a gated community of beautifully designed, luxury urban homes located in the heart of Memorial. Built by Pelican Builders, Inc., the Wetherby Terrace plan features beautiful exterior elevations, first-floor living, wood floors throughout living area, crown molding, high ceilings and outdoor living! 1st floor open-layout living with fireplace, dining and access to outdoor living; abundance of lights from wall of windows and french doors to patio. Gourmet kitchen features Bosch stainless steel appliances, quartz countertops and designer cabinetry. 2nd floor Primary suite with luxurious bath including soaking tub and walk-in shower, separate vanities and separate his&hers walk-in closets; Two secondary bedrooms with walk-in closets and jack and jill bath; utility room. 3rd floor oversized game room with full bath and space for upgraded wet bar. Elevator capable, two-car garage. BY APPOINTMENT ONLY.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'Pelican Builders Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 3 MEMORIAL GREEN SEC 2 R/P & EXTN' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '2448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`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` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Green' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294932' WHERE `Matrix_Unique_ID` = '204315952' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:54:50.080' ,`MLSNumber` = '33036316' ,`ListAgentFullName` = 'Kimberly Whaley' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764823' ,`Longitude` = '-95.552682' ,`PhotoCount` = '13' ,`PostalCode` = '77024' ,`RoomCount` = '8' ,`ListPrice` = '1125000.00' ,`Status` = 'Active' ,`StreetName` = 'Morningside Park Street' ,`StreetNumber` = '210' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TO BE BUILT! Memorial Green is a gated community of beautifully designed, luxury urban homes located in\r\nthe heart of Memorial. Built by Pelican Builders, Inc. and designed by George Hopkins, Plan A features\r\nbeautiful exterior elevations, second-floor living, wood floors throughout living area, crown molding and high\r\nceilings! 1st floor features guest suite with full bath connected to study/optional secondary bedroom, both complete with walk-in closets. 2nd floor features open-layout living, dining and kitchen with balcony off living room. Gourmet kitchen: Bosch stainless steel appliances, quartz countertops and designer cabinetry. 3rd floor Primary suite with luxurious bath including soaking tub and walk-in shower, separate his&hers walk-in closets; Secondary ensuite\r\nbedroom with walk-in closet; Utility room. Elevator capable. 2-car garage. BY APPOINTMENT ONLY.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'Pelican Builders Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 MEMORIAL GREEN SEC 2 R/P & EXTN' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Green' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294932' WHERE `Matrix_Unique_ID` = '205615197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:39:48.817' ,`MLSNumber` = '68100256' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.324226' ,`Longitude` = '-95.306582' ,`PhotoCount` = '16' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '303757.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreview' ,`StreetNumber` = '272' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to your beautiful 1 Story, Aintree Floor Plan with 4 Bedrooms, 2 Baths, with 2 Car Garage. This floor plan boasts High Ceilings and a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Study/Flex Room, and 4 spacious bedrooms. Vinyl and Carpet throughout. You will love the Kitchen with lots of cabinets, Stainless Steel appliances, and even a USB outlet.. COST AND ENERGY EFFICIENCY FEATURES: 15 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Electric Water Heater and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. A beautiful community filled with lakes, park areas, playground, and walking trails, the Lakes at Crockett Martin in the Sam Houston National Forest offers a serene lifestyle with a small town feel. Convenient to I45, TX 105, and TX59/I69. Conroe ISD!' ,`Acres` = '0.1729' ,`Area` = '40' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S929600 - THE LAKES AT CROCKETT MARTIN 01, BLOCK 2, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7530' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'The Lakes At Crockett Martin' ,`TaxAmount` = '574' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294933' WHERE `Matrix_Unique_ID` = '206209114' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:17:06.430' ,`MLSNumber` = '34680371' ,`ListAgentFullName` = 'Jenni Meador' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.160065' ,`Longitude` = '-95.630644' ,`PhotoCount` = '20' ,`PostalCode` = '77486' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgewood' ,`StreetNumber` = '2248' ,`StreetSuffix` = '' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION 1 STORY HOME, NO BACK NEIGHBORS. LARGE BEDROOMS. OPEN KITCHEN, FORMAL DINING WITH LARGE FAMILY ROOM AND HIGH CEILINGS! MASTER BEDROOM WITH WALK IN CLOSET AND BUILT-INS. DON\'T MISS EVERYTHING THIS BEAUTIFUL NEW HOME HAS TO OFFER!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'WS4 HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 3 (A0133 M VARNER) BLK 24 LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14250' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '1159' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294933' WHERE `Matrix_Unique_ID` = '208289440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:54:10.720' ,`MLSNumber` = '17164688' ,`ListAgentFullName` = 'Kimberly Whaley' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764837' ,`Longitude` = '-95.552422' ,`PhotoCount` = '13' ,`PostalCode` = '77024' ,`RoomCount` = '8' ,`ListPrice` = '1140000.00' ,`Status` = 'Active' ,`StreetName` = 'Morningside Park Street' ,`StreetNumber` = '204' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TO BE BUILT! Memorial Green is a gated community of beautifully designed, luxury urban homes located in the heart of Memorial. Built by Pelican Builders, Inc. and designed by George Hopkins, The Morningside plan features beautiful exterior elevations, second-floor living, wood floors throughout living area, crown molding and high ceilings! 1st floor features guest suite with full bath connected to study/optional secondary bedroom, both complete with walk-in closets. 2nd floor features open-layout living, dining and kitchen with balcony off living room. Gourmet kitchen: Bosch stainless steel appliances, quartz countertops and designer cabinetry. 3rd floor Primary suite with luxurious bath including soaking tub and walk-in shower, separate his&hers walk-in closets; Secondary ensuite bedroom with walk-in closet; Utility room. Elevator capable. 2-car garage. BY APPOINTMENT ONLY.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'Pelican Builders Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 MEMORIAL GREEN SEC 2 R/P & EXTN' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Green' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294933' WHERE `Matrix_Unique_ID` = '209839014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:55:44.257' ,`MLSNumber` = '93559683' ,`ListAgentFullName` = 'Kimberly Whaley' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764828' ,`Longitude` = '-95.552508' ,`PhotoCount` = '13' ,`PostalCode` = '77024' ,`RoomCount` = '8' ,`ListPrice` = '1125000.00' ,`Status` = 'Active' ,`StreetName` = 'Morningside Park Street' ,`StreetNumber` = '206' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TO BE BUILT! Memorial Green is a gated community of beautifully designed, luxury urban homes located in the heart of Memorial. Built by Pelican Builders, Inc. and designed by George Hopkins, The Morningside plan features beautiful exterior elevations, second-floor living, wood floors throughout living area, crown molding and high ceilings! 1st floor features guest suite with full bath connected to study/optional secondary bedroom, both complete with walk-in closets. 2nd floor features open-layout living, dining and kitchen with balcony off living room. Gourmet kitchen: Bosch stainless steel appliances, quartz countertops and designer cabinetry. 3rd floor Primary suite with luxurious bath including soaking tub and walk-in shower, separate his&hers walk-in closets; Secondary ensuite bedroom with walk-in closet; Utility room. Elevator capable. 2-car garage. BY APPOINTMENT ONLY.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'Pelican Builders Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 MEMORIAL GREEN SEC 2 R/P & EXTN' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Green' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294933' WHERE `Matrix_Unique_ID` = '209839327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:52:42.820' ,`MLSNumber` = '37039835' ,`ListAgentFullName` = 'Kimberly Whaley' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764832' ,`Longitude` = '-95.552593' ,`PhotoCount` = '13' ,`PostalCode` = '77024' ,`RoomCount` = '8' ,`ListPrice` = '1140000.00' ,`Status` = 'Active' ,`StreetName` = 'Morningside Park Street' ,`StreetNumber` = '208' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TO BE BUILT! Memorial Green is a gated community of beautifully designed, luxury urban homes located in the heart of Memorial. Built by Pelican Builders, Inc. and designed by George Hopkins, The Morningside plan features beautiful exterior elevations, second-floor living, wood floors throughout living area, crown molding and high ceilings! 1st floor features guest suite with full bath connected to study/optional secondary bedroom, both complete with walk-in closets. 2nd floor features open-layout living, dining and kitchen with balcony off living room. Gourmet kitchen: Bosch stainless steel appliances, quartz countertops and designer cabinetry. 3rd floor Primary suite with luxurious bath including soaking tub and walk-in shower, separate his&hers walk-in closets; Secondary ensuite bedroom with walk-in closet; Utility room. Elevator capable. 2-car garage. BY APPOINTMENT ONLY.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'Pelican Builders Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 MEMORIAL GREEN SEC 2 R/P & EXTN' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Green' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294933' WHERE `Matrix_Unique_ID` = '209839482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:37:33.350' ,`MLSNumber` = '53439854' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.335783' ,`Longitude` = '-95.318426' ,`PhotoCount` = '18' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '292669.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreview' ,`StreetNumber` = '300' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See sample 3D Virtual tour. Beautiful all brick home with 3 Bedroom, 2 Bath, with attached 2 car garage. This Epsom floor plan boasts High Ceilings and a spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining room, Study/Flex Room, and 3 spacious bedrooms. Vinyl and Carpet throughout. You will love the Kitchen with lots of cabinets, stainless steel appliances, and even a USB outlet. Fenced Backyard with Covered Patio. COST AND ENERGY EFFICIENCY FEATURES: 15 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. A beautiful community filled with lakes, park areas, playground, and walking trails, the Lakes at Crockett Martin in the Sam Houston National Forest offers a serene lifestyle with a small town feel. Convenient to I45, TX 105, and TX59/I69. Conroe ISD!' ,`Acres` = '0.1733' ,`Area` = '19' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S929600 - THE LAKES AT CROCKETT MARTIN 01, BLOCK 2, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7547' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'The Lakes At Crockett Martin' ,`TaxAmount` = '574' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294934' WHERE `Matrix_Unique_ID` = '210590340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:38:30.630' ,`MLSNumber` = '16174293' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.323930' ,`Longitude` = '-95.310187' ,`PhotoCount` = '14' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '305990.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreview' ,`StreetNumber` = '223' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See sample 3D Virtual tour. Beautiful all brick home with 3 Bedroom, 2 Bath, with attached 2 car garage. This Epsom floor plan boasts High Ceilings and a spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining room, Study/Flex Room, and 3 spacious bedrooms. Vinyl and Carpet throughout. You will love the Kitchen with lots of cabinets, stainless steel appliances, and even a USB outlet. Fenced Backyard with Covered Patio. COST AND ENERGY EFFICIENCY FEATURES: 15 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. A beautiful community filled with lakes, park areas, playground, and walking trails, the Lakes at Crockett Martin in the Sam Houston National Forest offers a serene lifestyle with a small town feel. Convenient to I45, TX 105, and TX59/I69. Conroe ISD!' ,`Acres` = '0.1939' ,`Area` = '40' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S929600 - THE LAKES AT CROCKETT MARTIN 01, BLOCK 1, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8445' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'The Lakes At Crockett Martin' ,`TaxAmount` = '574' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294934' WHERE `Matrix_Unique_ID` = '210590466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:36:05.977' ,`MLSNumber` = '15958379' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.335487' ,`Longitude` = '-95.319628' ,`PhotoCount` = '6' ,`PostalCode` = '77303' ,`RoomCount` = '10' ,`ListPrice` = '336963.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreview' ,`StreetNumber` = '276' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See sample 3D Virtual tour. LOW TAXES!!! Beautiful 2 Story, Sandown Floor Plan with 4 Bedrooms, 3 1/2 Baths, with a 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining Room, Half Bath, and the Primary Bedroom downstairs. Upstairs you will find a Game Room, 3 Bedrooms with 2 full Baths. Vinyl and Carpet throughout. You will love the Kitchen with lots of cabinets, breakfast bar, stainless steel appliances, and even a USB outlet. COST AND ENERGY EFFICIENCY FEATURES: Lennox 15 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Electric Water Heater, Radiant Barrier, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. A beautiful community filled with lakes, park areas, playground, and walking trails, the Lakes at Crockett Martin in the Sam Houston National Forest offers a serene lifestyle with a small town feel. Convenient to I45, TX 105, and TX59/I69. Conroe ISD!' ,`Acres` = '0.1731' ,`Area` = '19' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S929600 - THE LAKES AT CROCKETT MARTIN 01, BLOCK 2, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes At Crockett Martin' ,`TaxAmount` = '574' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294934' WHERE `Matrix_Unique_ID` = '210590574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:51:21.497' ,`MLSNumber` = '54868499' ,`ListAgentFullName` = 'Buddy Novak' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = 'Lanell Duke' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '30.715377' ,`Longitude` = '-94.935113' ,`PhotoCount` = '32' ,`PostalCode` = '77351' ,`RoomCount` = '9' ,`ListPrice` = '240000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Beatty' ,`StreetNumber` = '905' ,`StreetSuffix` = 'Avenue' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2583' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large unique 5 BR 2 BA- 2,583\' square foot Historic home built in 1905 centrally located in downtown Livingston. Features a large kitchen, wonderful formal dining and den with Master BR & bath downstairs. 4 large bedrooms and another full bath upstairs. Has a 2 car carport and storage building. New Roof installed in 2021. AC was replaced 2018. This home is a Historic Landmark designated by the Polk County Heritage Society known as the \"Ray Brock\" home. Come take a look and own a slice of History! The potential of this home is unlimited!' ,`Acres` = '0.303' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 15 M L CHOATE SURVEY SEC 1 SUB LOT 91' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '2276' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1905' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294934' WHERE `Matrix_Unique_ID` = '211261643' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T05:47:06.367' ,`MLSNumber` = '51368824' ,`ListAgentFullName` = 'Virginia Ledwell' ,`ListOfficeName` = 'Led Well Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768385' ,`Longitude` = '-95.337788' ,`PhotoCount` = '43' ,`PostalCode` = '77020' ,`RoomCount` = '9' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou' ,`StreetNumber` = '721' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '721 Bayou is a stunning new construction home that will appease the most discerning of buyers. It is squarely situated in the heart of Houston’s East Side & offers ample space for living & entertaining alike. This home is flooded w/ loads of natural light coming through ample windows & boasts gorgeous wood floors, high-end fixtures, lighting, & hardware throughout, a gourmet kitchen w SS appliances, island seating, Quartz countertops, as well as a centrally located balcony. The ensuite primary offers dual closets, a free-standing soaking tub, seamless shower & vanity w/ dual sinks. A private side-entrance to the home leads right into the foyer w purposeful placement of the downstairs guest/flex room w/ ensuite bath & access to the 2 car garage-perfect for a short-term room rental. All 3 bedrooms have ensuite baths. Centrally located & less than a 1/2 mile away from the up & coming East River Development & minutes away from downtown, Midtown, the Heights, as well as I10, 45, & 610.' ,`Acres` = '0.0287' ,`Area` = '2' ,`BuilderName` = 'Klass Act Solutions' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1A BLK 13 SWINEY' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Swiney' ,`TaxAmount` = '5158' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294935' WHERE `Matrix_Unique_ID` = '211354223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T05:10:18.640' ,`MLSNumber` = '24409353' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.999668' ,`Longitude` = '-95.225597' ,`PhotoCount` = '40' ,`PostalCode` = '77541' ,`RoomCount` = '8' ,`ListPrice` = '1285000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluewater Hwy' ,`StreetNumber` = '5122' ,`StreetSuffix` = '' ,`City` = 'Freeport' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Signature Beachfront Home known as the Coastal Dream has 4 bdrms and 4 en-Suites,over 2,600 sf and is ready for its next family. There is a reason this home is known as the Coastal Dream with beach and bay views and resting on 1.8 acres of relaxation. You and your guest can begin your day with a cup of coffee and a sunrise Gulf view and end the day with a sunset bay view while relaxing on this wrap-around deck. Enter the Coastal Dream into an open living areas with vaulted ceiling, crown molding and the wall of water view windows in the living areas and in every bedroom. The primary bedroom is to the right with private deck access. Bedrooms have en-suites and water views. Utility room, with elevator/lyft, is directly off the stairs. The Kitchen is ready to entertain as it opens to the living area for your guest and short-term renters. Schedule your tour to take advantage of a beachfront home that does allow Vacation Rentals. Sold mostly furnished.' ,`Acres` = '1.8331' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SEAHORSE ESTATES (A0029 S F AUSTIN) LOT 9-10' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '79850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Seahorse Estates' ,`TaxAmount` = '15372' ,`TaxRate` = '1.9981' ,`WaterSewer` = 'Septic Tank,Water District,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294935' WHERE `Matrix_Unique_ID` = '211876505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T05:02:56.097' ,`MLSNumber` = '30478786' ,`ListAgentFullName` = 'Lisa Kenny' ,`ListOfficeName` = 'R.E.D (Real Estate Driven)' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.870004' ,`Longitude` = '-95.710755' ,`PhotoCount` = '14' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Tahoka Springs' ,`StreetNumber` = '19436' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 19436 Tahoka Springs located Bear Creek Meadows and zoned to Cy-Fair ISD. This lovely home features 3 bedrooms, 2 full baths, and an attached 2 car garage. As you open the front door you are welcomed to the open concept floor plan making entertaining a breeze. The open kitchen features recently painted cabinetry with light countertops and island. The family room high ceilings and large windows allowing the natural light to shine through. End your days in the spacious master suite. The master bath includes a separate shower and tub. You don\'t want to miss all this gorgeous home has to offer! Recent updates include fresh paint, flooring, recent water heater, outside condenser within the last two years, and recent evaporator coil. Attic has radiant barrier for energy efficiency! Schedule your showing today!' ,`Acres` = '0.1148' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 6 BEAR CREEK MEADOWS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Meadows Sec 02' ,`TaxAmount` = '4414' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294935' WHERE `Matrix_Unique_ID` = '212468592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:51:34.010' ,`MLSNumber` = '15657704' ,`ListAgentFullName` = 'Kimberly Whaley' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765140' ,`Longitude` = '-95.551628' ,`PhotoCount` = '13' ,`PostalCode` = '77024' ,`RoomCount` = '10' ,`ListPrice` = '1685000.00' ,`Status` = 'Active' ,`StreetName` = 'Sutherland Terrace Place' ,`StreetNumber` = '403' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TO BE BUILT! CORNER LOT! Memorial Green is a gated community of beautifully designed, luxury urban homes located in the heart of Memorial. Built by Pelican Builders and designed by George Hopkins. The Park Plan features\r\nbeautiful exterior elevations, first-floor living, wood floors throughout living area, crown molding, high\r\nceilings and outdoor living! 1st floor open-layout living with fireplace, dining and access to outdoor living;\r\nabundance of light from wall of windows and french doors to side courtyard. Gourmet kitchen features Bosch\r\nstainless steel appliances, quartz countertops and designer cabinetry. 2nd floor Primary suite with luxurious\r\nbath including soaking tub and walk-in shower, separate vanities and separate his&hers walk-in closets;\r\nensuite secondary bedroom with walk-in closet; study and utility room. 3rd floor ensuite secondary bedroom;\r\nmedia room with covered rooftop terrace! Elevator capable, two-car garage, first-floor living with outdoor\r\nspace. Park view!' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'Pelican Builders Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 MEMORIAL GREEN SEC 2 R/P & EXTN 2ND PAR R/P' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '2566' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3860' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Green' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294935' WHERE `Matrix_Unique_ID` = '212694755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:40:38.453' ,`MLSNumber` = '63606580' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.339635' ,`Longitude` = '-95.316710' ,`PhotoCount` = '6' ,`PostalCode` = '77303' ,`RoomCount` = '10' ,`ListPrice` = '318478.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreview' ,`StreetNumber` = '308' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOW TAXES!!! Beautiful 2 Story, Kempton Floor Plan with 4 Bedrooms, 2 1/2 Baths, with a 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining Room, and the Master Bedroom downstairs. Upstairs you will find a Game Room, 3 Bedrooms with a full Bath. Vinyl and Carpet throughout. You will love the Kitchen with lots of cabinets, breakfast bar, stainless steel appliances, and even a USB outlet. Fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: Lennox 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Electric Water Heater, Radiant Barrier, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. A beautiful community filled with lakes, park areas, playground, and walking trails, the Lakes at Crockett Martin in the Sam Houston National Forest offers a serene lifestyle with a small town feel. Convenient to I45, TX 105, and TX59/I69. Conroe ISD!' ,`Acres` = '0.1728' ,`Area` = '19' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S929600 - THE LAKES AT CROCKETT MARTIN 01, BLOCK 2, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7525' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes At Crockett Martin' ,`TaxAmount` = '574' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294935' WHERE `Matrix_Unique_ID` = '213051073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T05:17:06.787' ,`MLSNumber` = '28538531' ,`ListAgentFullName` = 'Stephanie Childress' ,`ListOfficeName` = 'Rockin 4C Properties' ,`SellingAgentFullName` = 'Vicki Trevino' ,`SellingOfficeName` = 'Rockin 4C Properties' ,`Latitude` = '29.401778' ,`Longitude` = '-94.909354' ,`PhotoCount` = '31' ,`PostalCode` = '77590' ,`RoomCount` = '5' ,`ListPrice` = '199000.00' ,`Status` = 'Option Pending' ,`StreetName` = '18th' ,`StreetNumber` = '1013' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home, Open spacious floor plan ready for all the entertaining. Large open kitchen has plenty of space for the chef in the family and open to the living area, Primary bedroom is a great space to relax with the ensuite bathroom and double sinks. Huge Backyard with an above ground pool and covered patio. Home has been well cared for and shows pride of ownership, Fresh Carpet in the bedrooms, New Solar Screens and freshly painted on the outside, and half of roof has been replaced with ice and water barrier, French drain in back yard, NO Flooding! Make your appt today!' ,`Acres` = '0.2497' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 PAGE 5 LOT 8 BLK 32 MAINLAND PARK SEC A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mainland Park' ,`TaxAmount` = '4914' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294936' WHERE `Matrix_Unique_ID` = '213877639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T05:33:01.557' ,`MLSNumber` = '27268345' ,`ListAgentFullName` = 'Jeffrey Sadler' ,`ListOfficeName` = 'Sadler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.520727' ,`Longitude` = '-95.550280' ,`PhotoCount` = '32' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '694900.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Sky' ,`StreetNumber` = '2' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4019' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable two story home with SPARKLING POOL & SPA located on a cul-de-sac lot in the desirable Bees Creek of Sienna. Built by Newmark, this 5 bed, 4 bath home offers a SECONDARY GUEST BED & ADDITIONAL FULL BATH DOWNSTAIRS plus an oversized media room & game room upstairs. Highlights of this home start at the front door when you are greeted by a rounded staircase flanked by the formal dining & study w/ french doors. The open concept design is perfect for entertaining. Chef\'s kitchen w/ expansive island, granite countertops & stainless steel appliances seamlessly opens to the spacious family room w/ soaring ceilings & stone fireplace. The impressive backyard oasis comes complete w/ a covered patio, new sparkling pool and spa & built-in fire pit. 3 CAR GARAGE. This home offers it all and then some! Conveniently located in the front of Sienna w/ easy access to Hwy 6, University & the Ft Bend Toll road. You do not want to miss this opportunity!' ,`Acres` = '0.2438' ,`Area` = '38' ,`BuilderName` = 'Newmark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF BEES CREEK SEC 9, BLOCK 1, LOT 14' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,In Golf Course Community' ,`LotSize` = '10619' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'SIENNA' ,`TaxAmount` = '12605' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294936' WHERE `Matrix_Unique_ID` = '214088701' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T05:44:03.400' ,`MLSNumber` = '44021628' ,`ListAgentFullName` = 'Jessica Murphy' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.905222' ,`Longitude` = '-95.640968' ,`PhotoCount` = '33' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble Lake' ,`StreetNumber` = '15618' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! Premium Lot on Greenbelt with No Neighbors Behind Home and Subdivision Pool and Shaded Playground Right Across the Street. New Roof Is in the Process for next week. Interior and Exterior Painted 10/2022. New Carpet Thru-Out. New Gorgeous Granite CounterTops In Kitchen. Large Primary Bedroom with Windows Overlooking Backyard. Primary Bath has Two Sinks and Two Separate Walk-In Closet. Spacious Family Room with Beautiful Gaslog Fireplace and Hearth. Large Covered Patio and Big Backyard. Low Taxes and Great Shopping Close By.' ,`Acres` = '0.1997' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 5 COPPERFIELD NORTHMEAD VLG 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '565' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'COPPERFIELD' ,`TaxAmount` = '4507' ,`TaxRate` = '2.617' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294936' WHERE `Matrix_Unique_ID` = '214127558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:40:13.743' ,`MLSNumber` = '61970261' ,`ListAgentFullName` = 'Krystyna Fennelly' ,`ListOfficeName` = 'Bay Area Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.281572' ,`Longitude` = '-94.812144' ,`PhotoCount` = '19' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '334500.00' ,`Status` = 'Active' ,`StreetName` = '44th' ,`StreetNumber` = '2321' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Vacation awaits at this Beautifully updated bungalow just blocks from the Seawall. Refinished hardwood floors throughout, New Quartz counter tops in kitchen with dining bar, New appliances include 5-burner gas range and dishwasher. New Central HVAC, New fixtures and ceiling fans in all rooms. Beautifully remodeled bath with New fixtures, tub surround with accessory niche, crystal doorknobs and wood casement windows throughout keep the olde world charm. Large utility room provides ample room for storage. Large fence backyard with privacy fence and spacious patio area to enjoy the fresh air and warm sea breeze. Perfect for your everyday home, weekend getaway or vacation rental...your options are unlimited. Flood Map#48167C0441G, Zone X500. Call today to schedule your private viewing and celebrate the holidays in Your New Home!' ,`Acres` = '0.0617' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR S 42 FT OF LOT 8 & PT OF LOT 9 (8-1)' ,`LotDesciption` = 'Corner' ,`LotSize` = '2688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Slate,Tile' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '3413' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294936' WHERE `Matrix_Unique_ID` = '214312465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:48:31.400' ,`MLSNumber` = '23951041' ,`ListAgentFullName` = 'Cecilia Bonnickson' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = 'Donald Thomson' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '29.995349' ,`Longitude` = '-95.611811' ,`PhotoCount` = '48' ,`PostalCode` = '77429' ,`RoomCount` = '11' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Belgrave' ,`StreetNumber` = '12930' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a home with plenty of space for your family and a large outdoor entertaining area look no further. As you walk through the front door your formal dining room is on the left & to the right is a flex room which can be used for a home office. Next head into your large cozy family room w/wood burning fireplace. Off of the family room is an even larger entertaining area. Left of family room is casual eating area & large kitchen w/plenty of counter space. Right off of the kitchen is utility room & 1/2 bath. 2nd floor has your primary bedroom & 3 secondary bedrooms. Primary bath has double sinks & walk in shower. 3 closets in primary quarters. Heading out back is your walk in beachfront type entry pool oasis with waterfall. This yard is huge, room for play equipment, volleyball court and more! Detached garage set up with 220 volt outlet as well as 220 volt in workshop.' ,`Acres` = '0.3025' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 17 LAKEWOOD FOREST SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest Sec 10' ,`TaxAmount` = '6680' ,`TaxRate` = '2.5217' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294937' WHERE `Matrix_Unique_ID` = '214394367' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:14:14.680' ,`MLSNumber` = '33544380' ,`ListAgentFullName` = 'Jason Vo' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033153' ,`Longitude` = '-95.530418' ,`PhotoCount` = '28' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Mystic Morning' ,`StreetNumber` = '7107' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a beautiful two stories home with 3 beds, 2 and a half-bath, 2 car garage, nice size yard, and no back neighborhood. Located in Klein Grove community built by HistoryMaker Homes conveniently located between Spring Cypress and Louetta with easy access to I-45 and The Grand Parkway, making the commute to The Woodlands, George Bush International Airport, and the Exxon/Mobil campus quick and easy. This beautiful Gladewater Plan with over $25,000 upgrade boasts a chef-inspired kitchen with 42\" white cabinetry, crown molding, stainless-steel Whirlpool appliances, stunning quartz countertops, and a corner walk-in pantry, and a large island. Luxury vinyl plank flooring throughout the first floor. All bedrooms are located on the second floor and the master suite features a large walk-in closet, dual sinks, a garden tub, and a separate shower. A beautiful home, a good school district, a convenient location, and an incredibly low tax rate. CALL NOW FOR A PRIVATE SHOWING.' ,`Acres` = '0.1268' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 1 KLEIN GROVE' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5523' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Klein Grove' ,`TaxAmount` = '6092' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294937' WHERE `Matrix_Unique_ID` = '214473594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:52:42.663' ,`MLSNumber` = '40938150' ,`ListAgentFullName` = 'Curtis Brown' ,`ListOfficeName` = 'Lane Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594095' ,`Longitude` = '-95.532715' ,`PhotoCount` = '23' ,`PostalCode` = '77489' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Greencrest' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home sits in a well maintained neighborhood on a cul-de-sac street. Patio upgraded for those backyard gatherings. Home is vacant for immediate move in.' ,`Acres` = '0.108' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL GREEN WEST SEC 3, BLOCK 1, LOT 20, R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4703' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'EDGAR GLOVER JR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Green West Sec 3' ,`TaxAmount` = '4490' ,`TaxRate` = '3.1174' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294937' WHERE `Matrix_Unique_ID` = '214566055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T06:28:55.023' ,`MLSNumber` = '52179796' ,`ListAgentFullName` = 'David Gross' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745175' ,`Longitude` = '-95.432489' ,`PhotoCount` = '1' ,`PostalCode` = '77027' ,`RoomCount` = '16' ,`ListPrice` = '7995000.00' ,`Status` = 'Active' ,`StreetName` = 'Ella Lee' ,`StreetNumber` = '3460' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '4' ,`BedsTotal` = '5' ,`SqFtTotal` = '10360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 3460 Elle Lee Ln, a stately River Oaks new-build with a soft-modern twist. Situated on a prime, oversized lot in the coveted St. Johns quadrant of River Oaks, this highly custom home by acclaimed builder Layne Kelly & JD Bartell Designs has a feature rich list of amenities that would delight the most discerning buyers. Highlights include: slate roof, rare 3-car garage, large pool, beautiful sky lights, convenient scullery, Lutron Homeworks lighting system, ultra-premium L\'Atelier Paris appliances, elevator to all floors, incredible owner\'s suite, and more. Please call for further details and/or to schedule a meeting with the builder.' ,`Acres` = '0.2769' ,`Area` = '16' ,`BuilderName` = 'Layne Kelly' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 60 RIVER OAKS SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2445' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'River Oaks Sec 07' ,`TaxAmount` = '53605' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294937' WHERE `Matrix_Unique_ID` = '214655083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T05:27:25.573' ,`MLSNumber` = '76994189' ,`ListAgentFullName` = 'Riza Tajonera' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.622099' ,`Longitude` = '-95.418080' ,`PhotoCount` = '34' ,`PostalCode` = '77045' ,`RoomCount` = '5' ,`ListPrice` = '334000.00' ,`Status` = 'Active' ,`StreetName` = 'Meandering Elm' ,`StreetNumber` = '2738' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Come home to the private, gated community of Bayou Oaks at West Orem! This spectacular, meticulously maintained home features a two-story great room, an open floor plan and design. A spacious owner\'s suite is on the first floor with a large primary bathroom and walk-in closet. A covered patio and garden pond create a relaxing oasis in your backyard! The community is conveniently located between Pearland and the Texas Medical Center, just minutes from Downtown Houston, the University of Houston, Texas Southern University, and a quick hop to popular Houston destinations!' ,`Acres` = '0.1074' ,`Area` = '18' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 BAYOU OAKS AT WEST OREM SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PETERSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Bayou Oaks at West Orem' ,`TaxAmount` = '6866' ,`TaxRate` = '2.8907' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294937' WHERE `Matrix_Unique_ID` = '214687903' --> Updated record success